11 columnname: budget_period_descriptions
29 columnname: total_available
33 default_display_length: 20
37 columnname: order_line
43 columnname: basket_creator
45 columnname: basket_group
47 columnname: managing_library
49 columnname: invoice_number
57 columnname: received_on
59 columnname: quantity_received
61 columnname: pending_order
67 columnname: internalnote
69 columnname: vendornote
73 default_display_length: 20
81 columnname: order_line
83 columnname: order_date
85 columnname: estimated_delivery_date
89 columnname: information
93 columnname: total_cost
97 columnname: basket_group
105 columnname: claims_count
107 columnname: claimed_date
109 columnname: internal_note
111 columnname: vendor_note
117 default_display_length: 20
118 default_sort_order: 0
121 columnname: basket_number
123 columnname: order_information
125 columnname: recommended_retail_price_tax_excluded
127 columnname: actual_cost_tax_excluded
129 columnname: budgeted_cost_price_tax_included
131 columnname: recommended_retail_price_tax_included
134 columnname: actual_cost_tax_included
137 columnname: budgeted_cost_tax_included
139 columnname: replacement_price
143 columnname: total_tax_excluded
145 columnname: total_tax_included
148 columnname: goods_and_services_tax_percentage
150 columnname: goods_and_services_tax
154 columnname: estimated_delivery_date
156 columnname: supplier_report
160 cannot_be_modified: 1
164 cannot_be_modified: 1
170 columnname: selections
172 cannot_be_modified: 1
174 columnname: suggestion
176 columnname: suggested_by
178 columnname: suggested_category
180 columnname: suggested_on
182 columnname: patron_reason
184 columnname: managed_by
186 columnname: managed_on
188 columnname: lastmodificationby
190 columnname: lastmodificationdate
192 columnname: last_updated_date
196 columnname: library_fund
198 columnname: staff_note
200 columnname: suggestion_status
204 cannot_be_modified: 1
208 default_display_length: 20
209 default_sort_order: 0
214 columnname: city_name
216 columnname: city_state
218 columnname: city_zipcode
220 columnname: city_country
224 cannot_be_modified: 1
231 cannot_be_modified: 1
235 cannot_be_modified: 1
242 columnname: last_updated
250 default_display_length: 20
251 default_sort_order: 1
256 columnname: category_name
260 columnname: enrollment_period
262 columnname: password_expiration
264 columnname: age_required
266 columnname: upper_age_limit
268 columnname: enrollment_fee
272 columnname: lost_items
276 columnname: messaging
278 columnname: branches_limitations
280 columnname: can_be_guarantee
282 columnname: default_privacy
284 columnname: exclude_from_local_holds_priority
288 cannot_be_modified: 1
292 default_display_length: 10
293 default_sort_order: 1
298 columnname: description
302 columnname: parent_code
304 columnname: search_category
306 columnname: not_for_loan
308 columnname: hide_in_opac
310 columnname: rental_charge
312 columnname: daily_rental_charge
314 columnname: hourly_rental_charge
316 columnname: default_replacement_cost
318 columnname: lost_processing_fee
320 columnname: checkin_message
322 columnname: library_limitations
324 columnname: automatic_checkin
329 cannot_be_modified: 1
333 default_display_length: 20
334 default_sort_order: 0
337 columnname: library_name
339 columnname: library_code
341 columnname: library_address
343 columnname: marc_organization_code
345 columnname: library_ip
347 columnname: is_pickup_location
351 columnname: smtp_server
355 cannot_be_modified: 1
362 columnname: holdings_checkbox
364 cannot_be_modified: 1
366 columnname: holdings_cover_image
368 columnname: holdings_itype
370 columnname: holdings_holdingbranch
372 columnname: holdings_homebranch
374 columnname: holdings_ccode
376 columnname: holdings_item_group
378 columnname: holdings_itemcallnumber
380 columnname: holdings_enumchron
382 columnname: holdings_status
384 columnname: holdings_lastseen
386 columnname: holdings_issues
389 columnname: holdings_renewals
392 columnname: holdings_dateaccessioned
394 columnname: holdings_datelastborrowed
396 columnname: holdings_barcodes
398 columnname: holdings_uri
400 columnname: holdings_copynumber
402 columnname: holdings_stocknumber
404 columnname: holdings_materials
406 columnname: holdings_itemnotes
408 columnname: holdings_itemnotes_nonpublic
410 columnname: holdings_hostrecord
412 columnname: holdings_usedin
414 columnname: holdings_course_reserves
416 columnname: holdings_spinelabel
418 columnname: holdings_actions
420 cannot_be_modified: 1
425 columnname: otherholdings_checkbox
427 cannot_be_modified: 1
429 columnname: otherholdings_cover_image
431 columnname: otherholdings_itype
433 columnname: otherholdings_holdingbranch
435 columnname: otherholdings_homebranch
437 columnname: otherholdings_ccode
439 columnname: otherholdings_item_group
441 columnname: otherholdings_itemcallnumber
443 columnname: otherholdings_enumchron
445 columnname: otherholdings_status
447 columnname: otherholdings_lastseen
449 columnname: otherholdings_issues
452 columnname: otherholdings_renewals
455 columnname: otherholdings_dateaccessioned
457 columnname: otherholdings_datelastborrowed
459 columnname: otherholdings_barcode
461 columnname: otherholdings_uri
463 columnname: otherholdings_copynumber
465 columnname: otherholdings_stocknumber
467 columnname: otherholdings_materials
469 columnname: otherholdings_itemnotes
471 columnname: otherholdings_itemnotes_nonpublic
473 columnname: otherholdings_hostrecord
475 columnname: otherholdings_usedin
477 columnname: otherholdings_course_reserves
479 columnname: otherholdings_spinelabel
481 columnname: otherholdings_actions
483 cannot_be_modified: 1
485 acquisitiondetails-table:
492 columnname: basketgroup
496 columnname: ordernumber
498 columnname: creation_date
500 columnname: received_data
508 columnname: order_internalnote
510 columnname: subscription
512 columnname: subscription_callnumber
514 checkoutshistory-table:
515 default_display_length: 20
520 cannot_be_modified: 1
524 cannot_be_modified: 1
526 columnname: checked_out_from
528 columnname: checked_out_by
532 columnname: checkout_on
536 columnname: checkin_on
546 columnname: callnumber
552 columnname: bundle_actions
554 cannot_be_modified: 1
565 columnname: coming_from
567 columnname: import_date
571 cannot_be_modified: 1
574 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
575 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
576 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
582 columnname: dateaccessioned
584 columnname: booksellerid
586 columnname: homebranch
590 columnname: replacementprice
592 columnname: replacementpricedate
594 columnname: datelastborrowed
596 columnname: datelastseen
600 columnname: notforloan
606 columnname: withdrawn
608 columnname: itemcallnumber
610 columnname: coded_location_qualifier
612 columnname: restricted
614 columnname: itemnotes
616 columnname: itemnotes_nonpublic
618 columnname: holdingbranch
620 columnname: timestamp
626 columnname: cn_source
630 columnname: materials
636 columnname: enumchron
638 columnname: copynumber
640 columnname: stocknumber
644 default_sort_order: 1
663 cannot_be_modified: 1
667 course_reserves_table:
668 default_display_length: 20
669 default_sort_order: 0
674 columnname: department
676 columnname: course_no
682 columnname: instructors
684 columnname: staff_note
686 columnname: public_note
688 columnname: no_of_students
693 course_reserves_table:
694 default_display_length: 20
695 default_sort_order: 0
704 columnname: call_number
706 columnname: item_type
708 columnname: collection
712 columnname: home_library
714 columnname: holding_library
716 columnname: staff_note
718 columnname: public_note
722 columnname: other_course_reserves
726 cannot_be_modified: 1
737 columnname: description
741 columnname: closure_reason
743 columnname: is_perpetual
745 columnname: renewal_priority
749 cannot_be_modified: 1
758 columnname: description
764 columnname: started_on
770 cannot_be_modified: 1
781 columnname: content_type
783 columnname: created_on
789 cannot_be_modified: 1
795 columnname: contributors
797 columnname: publication_type
799 columnname: identifier
803 cannot_be_modified: 1
810 columnname: ill_request_id
812 columnname: metadata_author
814 columnname: metadata_title
816 columnname: metadata_article_title
818 columnname: metadata_issue
820 columnname: metadata_volume
822 columnname: metadata_year
824 columnname: metadata_pages
826 columnname: metadata_type
832 columnname: biblio_id
834 columnname: library_branchname
838 columnname: placed_formatted
840 columnname: updated_formatted
844 columnname: completed_formatted
846 columnname: accessurl
850 columnname: price_paid
854 columnname: notesopac
856 columnname: notesstaff
862 cannot_be_modified: 1
867 default_display_length: 20
872 columnname: timestamp
874 columnname: credit_number
877 columnname: account_type
879 columnname: description
885 columnname: returndate
887 columnname: issuedate
889 columnname: checked_out_from
891 columnname: home_library
897 cannot_be_modified: 1
899 columnname: amountoutstanding
901 cannot_be_modified: 1
905 cannot_be_modified: 1
909 default_display_length: 20
910 default_sort_order: 3
915 cannot_be_modified: 1
919 cannot_be_modified: 1
921 columnname: account_type
923 columnname: description
929 columnname: callnumber
933 columnname: returndate
935 columnname: issuedate
937 columnname: checked_out_from
939 columnname: home_library
945 columnname: amountoutstanding
953 cannot_be_modified: 1
955 columnname: cardnumber
959 columnname: dateofbirth
965 columnname: expires_on
967 columnname: od_checkouts
971 columnname: circ_notes
975 cannot_be_modified: 1
981 columnname: sort_order
983 cannot_be_modified: 1
986 columnname: todays_or_previous_checkouts
988 cannot_be_modified: 1
991 columnname: due_date_unformatted
993 cannot_be_modified: 1
1000 columnname: record_type
1002 columnname: item_type
1004 columnname: collection
1006 columnname: location
1008 columnname: homebranch
1010 columnname: checkout_on_unformatted
1011 cannot_be_toggled: 1
1012 cannot_be_modified: 1
1015 columnname: checkout_on
1017 columnname: checkout_from
1021 columnname: copynumber
1030 cannot_be_toggled: 1
1031 cannot_be_modified: 1
1035 columnname: claims_returned
1038 cannot_be_toggled: 1
1039 cannot_be_modified: 1
1041 relatives-issues-table:
1044 columnname: due_date_unformatted
1045 cannot_be_toggled: 1
1046 cannot_be_modified: 1
1049 columnname: due_date
1053 columnname: record_type
1055 columnname: item_type
1057 columnname: collection
1059 columnname: location
1061 columnname: checkout_on_unformatted
1062 cannot_be_toggled: 1
1063 cannot_be_modified: 1
1066 columnname: checkout_on
1068 columnname: checkout_from
1072 columnname: copynumber
1084 default_display_length: 20
1088 cannot_be_toggled: 1
1089 cannot_be_modified: 1
1097 columnname: reservedate
1099 columnname: expirationdate
1101 columnname: waitingdate
1103 columnname: cancellationdate
1105 columnname: itemtype
1110 checkouthistory-table:
1111 default_display_length: 20
1114 cannot_be_toggled: 1
1115 cannot_be_modified: 1
1123 columnname: call_number
1125 columnname: enumchron
1129 columnname: number_of_renewals
1131 columnname: checked_out_on
1133 columnname: checked_out_from
1135 columnname: date_due
1137 columnname: return_date
1141 default_display_length: 20
1142 default_sort_order: 3
1145 columnname: checkbox
1146 cannot_be_toggled: 1
1147 cannot_be_modified: 1
1151 columnname: firstname
1157 columnname: category
1161 columnname: expires_on
1163 columnname: circ_notes
1171 cannot_be_toggled: 1
1172 cannot_be_modified: 1
1176 columnname: lostcode
1178 columnname: itemlost_on
1182 columnname: callnumber
1184 columnname: datelastseen
1188 columnname: replacementprice
1192 columnname: itemtype
1194 columnname: collection_code
1196 columnname: current_location
1198 columnname: location
1200 columnname: notforloan
1206 default_display_length: 20
1207 default_sort_order: 0
1213 cannot_be_toggled: 1
1214 cannot_be_modified: 1
1216 columnname: basket_name
1218 columnname: basket_by
1222 columnname: currency
1224 columnname: list_price
1228 columnname: budgeted_cost
1230 columnname: quantity
1232 columnname: total_rrp
1234 columnname: total_cost
1236 columnname: entry_date
1238 columnname: date_received
1240 columnname: internal_note
1242 columnname: vendor_note
1246 default_display_length: 20
1247 default_sort_order: 0
1250 columnname: selection
1251 cannot_be_toggled: 1
1252 cannot_be_modified: 1
1254 columnname: report_id
1255 cannot_be_toggled: 1
1256 cannot_be_modified: 1
1258 columnname: report_name
1264 columnname: subgroup
1270 columnname: creation_date
1272 columnname: last_edit
1274 columnname: last_run
1278 columnname: json_url
1280 columnname: cache_expiry
1282 columnname: saved_results
1287 cannot_be_toggled: 1
1288 cannot_be_modified: 1
1295 columnname: sort_order
1296 cannot_be_toggled: 1
1297 cannot_be_modified: 1
1300 columnname: todays_or_previous_checkouts
1301 cannot_be_toggled: 1
1302 cannot_be_modified: 1
1305 columnname: due_date_unformatted
1306 cannot_be_toggled: 1
1307 cannot_be_modified: 1
1310 columnname: due_date
1314 columnname: record_type
1316 columnname: item_type
1318 columnname: collection
1320 columnname: location
1322 columnname: homebranch
1324 columnname: checkout_on_unformatted
1325 cannot_be_toggled: 1
1326 cannot_be_modified: 1
1329 columnname: checkout_on
1331 columnname: checkout_from
1335 columnname: copynumber
1344 cannot_be_toggled: 1
1345 cannot_be_modified: 1
1349 columnname: claims_returned
1352 cannot_be_toggled: 1
1353 cannot_be_modified: 1
1355 relatives-issues-table:
1358 columnname: due_date_unformatted
1359 cannot_be_toggled: 1
1360 cannot_be_modified: 1
1363 columnname: due_date
1367 columnname: record_type
1369 columnname: item_type
1371 columnname: collection
1373 columnname: location
1375 columnname: checkout_on_unformatted
1376 cannot_be_toggled: 1
1377 cannot_be_modified: 1
1380 columnname: checkout_on
1382 columnname: checkout_from
1386 columnname: copynumber
1400 cannot_be_toggled: 1
1401 cannot_be_modified: 1
1403 columnname: cardnumber
1405 columnname: date_of_birth
1407 columnname: category
1420 columnname: due_date
1428 columnname: homelibrary
1430 columnname: transferlibrary
1432 columnname: location
1434 columnname: itemcallnumber
1436 columnname: dateaccessioned
1439 columnname: record_type
1445 columnname: borrower
1447 columnname: itemnote
1451 default_sort_order: 3
1456 columnname: holdingbranch
1459 columnname: collection
1461 columnname: document_type
1463 columnname: callnumber
1465 columnname: copynumber
1467 columnname: enumeration
1473 columnname: patroncategory
1483 default_display_length: 20
1484 default_sort_order: 0
1487 columnname: pull_items
1489 columnname: avalaible_items
1497 columnname: libraries
1499 columnname: barcodes
1501 columnname: call_numbers
1503 columnname: copy_numbers
1505 columnname: enumeration
1507 columnname: itemtypes
1509 columnname: locations
1511 columnname: collection
1513 columnname: hold_date
1515 columnname: reserve_notes
1517 columnname: pickup_location
1523 default_display_length: 20
1530 columnname: holds_ratio
1534 columnname: home_libraries
1536 columnname: holding_libraries
1538 columnname: location
1540 columnname: itemtype
1542 columnname: call_numbers
1544 columnname: items_needed
1546 holds_awaiting_pickup:
1550 columnname: checkbox
1551 cannot_be_toggled: 1
1552 cannot_be_modified: 1
1554 columnname: waiting_since
1556 columnname: date_hold_placed
1558 columnname: expiration_date
1564 columnname: home_library
1566 columnname: current_location
1568 columnname: shelving_location
1570 columnname: call_number
1572 columnname: copy_number
1574 columnname: enumeration
1581 columnname: checkbox
1582 cannot_be_toggled: 1
1583 cannot_be_modified: 1
1585 columnname: waiting_since
1587 columnname: date_hold_placed
1589 columnname: expiration_date
1595 columnname: home_library
1597 columnname: current_location
1599 columnname: shelving_location
1601 columnname: call_number
1603 columnname: copy_number
1605 columnname: enumeration
1612 columnname: checkbox
1613 cannot_be_toggled: 1
1614 cannot_be_modified: 1
1616 columnname: waiting_since
1618 columnname: date_hold_placed
1620 columnname: expiration_date
1626 columnname: home_library
1628 columnname: current_location
1630 columnname: shelving_location
1632 columnname: call_number
1634 columnname: copy_number
1636 columnname: enumeration
1642 default_display_length: 20
1643 default_sort_order: 0
1646 columnname: due_date
1650 columnname: patron_category
1653 columnname: patron_library
1657 columnname: home_library
1660 columnname: holding_library
1663 columnname: shelving_location
1667 columnname: call_number
1669 columnname: item_type
1674 columnname: non-public_note
1676 columnname: claims_returned
1679 print-summary-checkouts:
1686 columnname: call_number
1688 columnname: item_type
1690 columnname: date_due
1694 columnname: inventory_number
1702 print-summary-holds:
1709 columnname: placed_on
1711 columnname: expires_on
1713 columnname: pick up_location
1715 print-summary-fines:
1720 columnname: description_of_charges
1726 columnname: outstanding
1733 columnname: item_cover
1735 columnname: item_itemtype
1737 columnname: item_current_location
1739 columnname: item_home_location
1741 columnname: item_shelving_location
1744 columnname: item_ccode
1746 columnname: item_callnumber
1748 columnname: item_materials
1751 columnname: item_enumchron
1753 columnname: item_url
1755 columnname: item_copy
1757 columnname: item_status
1759 columnname: item_notes
1761 columnname: item_datedue
1763 columnname: item_barcode
1766 columnname: item_holds
1768 columnname: item_priority
1770 columnname: item_coursereserves
1772 course_reserves_table:
1775 columnname: coursename
1777 columnname: department
1779 columnname: course_number
1785 columnname: instructor
1792 columnname: serial_serialseq
1794 columnname: serial_publisheddate
1796 columnname: serial_planneddate
1798 columnname: serial_status
1800 columnname: serial_notes
1809 columnname: itemtype
1811 columnname: location
1813 columnname: collection
1815 columnname: callnumber
1817 columnname: copynumber
1828 subscription-detail:
1836 columnname: ordernumber
1838 columnname: creation_date
1840 columnname: receive_date
1844 columnname: order_internalnote
1846 columnname: order_vendornote
1855 batch_patron_modification:
1859 columnname: batch_patron_edit_selections
1860 cannot_be_toggled: 1
1861 cannot_be_modified: 1
1863 columnname: batch_patron_edit_cardnumber
1865 columnname: batch_patron_edit_surname
1867 columnname: batch_patron_edit_firstname
1869 columnname: batch_patron_edit_branchcode
1871 columnname: batch_patron_edit_categorycode
1873 columnname: batch_patron_edit_streetnumber
1875 columnname: batch_patron_edit_address
1877 columnname: batch_patron_edit_address2
1879 columnname: batch_patron_edit_city
1881 columnname: batch_patron_edit_state
1883 columnname: batch_patron_edit_zipcode
1885 columnname: batch_patron_edit_country
1887 columnname: batch_patron_edit_email
1889 columnname: batch_patron_edit_phone
1891 columnname: batch_patron_edit_mobile
1893 columnname: batch_patron_edit_dateenrolled
1895 columnname: batch_patron_edit_dateexpiry
1897 columnname: batch_patron_edit_borrowernotes
1899 columnname: batch_patron_edit_opacnote
1901 columnname: batch_patron_edit_debarred
1903 columnname: batch_patron_edit_debarredcomment
1907 default_display_length: 20
1912 columnname: librarian
1922 columnname: interface
1923 marc-modification-templates:
1930 columnname: template
1933 cannot_be_toggled: 1
1934 cannot_be_modified: 1
1937 default_sort_order: 3
1948 columnname: updated_on
1950 columnname: copy_notice
1953 cannot_be_toggled: 1
1954 cannot_be_modified: 1
1962 columnname: cyclical
1966 columnname: description
1968 columnname: number_of_items
1971 cannot_be_toggled: 1
1972 cannot_be_modified: 1
1974 stock_rotation_manage_items:
1983 columnname: call_number
1985 columnname: in_transit
1990 cannot_be_toggled: 1
1991 cannot_be_modified: 1
1995 default_display_length: 20
1998 columnname: filename
2002 columnname: hashvalue
2007 columnname: category
2011 columnname: temporary
2014 cannot_be_toggled: 1
2015 cannot_be_modified: 1
2023 columnname: description
2028 cannot_be_toggled: 1
2029 cannot_be_modified: 1