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_date
99 columnname: basket_group
107 columnname: claims_count
109 columnname: claimed_date
111 columnname: internal_note
113 columnname: vendor_note
119 default_display_length: 20
120 default_sort_order: 0
123 columnname: order_line
125 columnname: order_information
127 columnname: recommended_retail_price_tax_excluded
129 columnname: actual_cost_tax_excluded
131 columnname: budgeted_cost_price_tax_included
133 columnname: recommended_retail_price_tax_included
136 columnname: actual_cost_tax_included
139 columnname: budgeted_cost_tax_included
141 columnname: replacement_price
145 columnname: total_tax_excluded
147 columnname: total_tax_included
150 columnname: goods_and_services_tax_percentage
152 columnname: goods_and_services_tax
156 columnname: estimated_delivery_date
158 columnname: statistic1
161 columnname: statistic2
166 columnname: supplier_report
168 columnname: place_hold
172 cannot_be_modified: 1
176 cannot_be_modified: 1
182 columnname: selections
184 cannot_be_modified: 1
186 columnname: suggestion
188 columnname: suggested_by
190 columnname: suggested_category
192 columnname: suggested_on
194 columnname: patron_reason
196 columnname: managed_by
198 columnname: managed_on
200 columnname: lastmodificationby
202 columnname: lastmodificationdate
204 columnname: last_updated_date
208 columnname: library_fund
210 columnname: staff_note
212 columnname: suggestion_status
216 cannot_be_modified: 1
220 default_display_length: 20
221 default_sort_order: 0
226 columnname: city_name
228 columnname: city_state
230 columnname: city_zipcode
232 columnname: city_country
236 cannot_be_modified: 1
243 cannot_be_modified: 1
247 cannot_be_modified: 1
254 columnname: last_updated
262 default_display_length: 20
263 default_sort_order: 1
268 columnname: category_name
272 columnname: enrollment_period
274 columnname: password_expiration
276 columnname: age_required
278 columnname: upper_age_limit
280 columnname: enrollment_fee
284 columnname: lost_items
288 columnname: messaging
290 columnname: branches_limitations
292 columnname: can_be_guarantee
294 columnname: default_privacy
296 columnname: exclude_from_local_holds_priority
300 cannot_be_modified: 1
304 default_display_length: 10
305 default_sort_order: 1
310 columnname: description
314 columnname: parent_code
316 columnname: search_category
318 columnname: not_for_loan
320 columnname: hide_in_opac
322 columnname: rental_charge
324 columnname: daily_rental_charge
326 columnname: hourly_rental_charge
328 columnname: default_replacement_cost
330 columnname: lost_processing_fee
332 columnname: checkin_message
334 columnname: library_limitations
336 columnname: automatic_checkin
341 cannot_be_modified: 1
345 default_display_length: 20
346 default_sort_order: 0
349 columnname: library_name
351 columnname: library_code
353 columnname: library_address
355 columnname: marc_organization_code
357 columnname: library_ip
359 columnname: is_pickup_location
363 columnname: smtp_server
365 columnname: library_hours
369 cannot_be_modified: 1
376 columnname: holdings_checkbox
378 cannot_be_modified: 1
380 columnname: holdings_cover_image
382 columnname: holdings_itype
384 columnname: holdings_holdingbranch
386 columnname: holdings_homebranch
388 columnname: holdings_ccode
390 columnname: holdings_item_group
392 columnname: holdings_itemcallnumber
394 columnname: holdings_enumchron
396 columnname: holdings_status
398 columnname: holdings_lastseen
400 columnname: holdings_issues
403 columnname: holdings_renewals
406 columnname: holdings_localuse
409 columnname: holdings_dateaccessioned
411 columnname: holdings_datelastborrowed
413 columnname: holdings_barcodes
415 columnname: holdings_uri
417 columnname: holdings_copynumber
419 columnname: holdings_stocknumber
421 columnname: holdings_materials
423 columnname: holdings_itemnotes
425 columnname: holdings_itemnotes_nonpublic
427 columnname: holdings_hostrecord
429 columnname: holdings_usedin
431 columnname: holdings_course_reserves
433 columnname: holdings_spinelabel
435 columnname: holdings_actions
437 cannot_be_modified: 1
442 columnname: otherholdings_checkbox
444 cannot_be_modified: 1
446 columnname: otherholdings_cover_image
448 columnname: otherholdings_itype
450 columnname: otherholdings_holdingbranch
452 columnname: otherholdings_homebranch
454 columnname: otherholdings_ccode
456 columnname: otherholdings_item_group
458 columnname: otherholdings_itemcallnumber
460 columnname: otherholdings_enumchron
462 columnname: otherholdings_status
464 columnname: otherholdings_lastseen
466 columnname: otherholdings_issues
469 columnname: otherholdings_renewals
472 columnname: otherholdings_localuse
475 columnname: otherholdings_dateaccessioned
477 columnname: otherholdings_datelastborrowed
479 columnname: otherholdings_barcode
481 columnname: otherholdings_uri
483 columnname: otherholdings_copynumber
485 columnname: otherholdings_stocknumber
487 columnname: otherholdings_materials
489 columnname: otherholdings_itemnotes
491 columnname: otherholdings_itemnotes_nonpublic
493 columnname: otherholdings_hostrecord
495 columnname: otherholdings_usedin
497 columnname: otherholdings_course_reserves
499 columnname: otherholdings_spinelabel
501 columnname: otherholdings_actions
503 cannot_be_modified: 1
505 acquisitiondetails-table:
512 columnname: basketgroup
516 columnname: ordernumber
518 columnname: creation_date
520 columnname: received_data
528 columnname: order_internalnote
530 columnname: subscription
532 columnname: subscription_callnumber
534 checkoutshistory-table:
535 default_display_length: 20
540 cannot_be_modified: 1
544 cannot_be_modified: 1
546 columnname: checked_out_from
548 columnname: checked_out_by
552 columnname: checkout_on
556 columnname: checkin_on
566 columnname: callnumber
572 columnname: bundle_actions
574 cannot_be_modified: 1
578 default_sort_order: 0
592 cannot_be_modified: 1
603 columnname: coming_from
605 columnname: import_date
609 cannot_be_modified: 1
612 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
613 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
614 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
620 columnname: dateaccessioned
622 columnname: booksellerid
624 columnname: homebranch
628 columnname: replacementprice
630 columnname: replacementpricedate
632 columnname: datelastborrowed
634 columnname: datelastseen
638 columnname: notforloan
644 columnname: withdrawn
646 columnname: itemcallnumber
648 columnname: coded_location_qualifier
650 columnname: restricted
652 columnname: itemnotes
654 columnname: itemnotes_nonpublic
656 columnname: holdingbranch
658 columnname: timestamp
664 columnname: cn_source
668 columnname: materials
674 columnname: enumchron
676 columnname: copynumber
678 columnname: stocknumber
682 default_sort_order: 0
695 cannot_be_modified: 1
699 default_sort_order: 1
718 cannot_be_modified: 1
722 course_reserves_table:
723 default_display_length: 20
724 default_sort_order: 0
729 columnname: department
731 columnname: course_no
737 columnname: instructors
739 columnname: staff_note
741 columnname: public_note
743 columnname: no_of_students
748 course_reserves_table:
749 default_display_length: 20
750 default_sort_order: 0
759 columnname: call_number
761 columnname: item_type
763 columnname: collection
767 columnname: home_library
769 columnname: holding_library
771 columnname: staff_note
773 columnname: public_note
777 columnname: other_course_reserves
781 cannot_be_modified: 1
792 columnname: description
796 columnname: closure_reason
798 columnname: is_perpetual
800 columnname: renewal_priority
804 cannot_be_modified: 1
813 columnname: description
819 columnname: started_on
825 cannot_be_modified: 1
836 columnname: content_type
838 columnname: created_on
844 cannot_be_modified: 1
850 columnname: contributors
852 columnname: publication_type
854 columnname: identifier
858 cannot_be_modified: 1
859 usage_data_providers:
860 usage_data_providers:
865 columnname: description
869 cannot_be_modified: 1
876 columnname: metric_type
883 columnname: importdate
887 cannot_be_modified: 1
894 columnname: usage_data_provider
902 columnname: metric_type
909 columnname: usage_data_provider
913 columnname: metric_type
922 columnname: ill_request_id
927 columnname: metadata_author
929 columnname: metadata_title
931 columnname: metadata_article_title
933 columnname: metadata_issue
935 columnname: metadata_volume
937 columnname: metadata_year
939 columnname: metadata_pages
941 columnname: metadata_type
947 columnname: biblio_id
949 columnname: library_branchname
953 columnname: placed_formatted
955 columnname: updated_formatted
959 columnname: completed_formatted
961 columnname: accessurl
965 columnname: price_paid
969 columnname: notesopac
971 columnname: notesstaff
977 cannot_be_modified: 1
982 default_display_length: 20
987 columnname: timestamp
989 columnname: credit_number
992 columnname: account_type
994 columnname: description
998 columnname: callnumber
1000 columnname: date_due
1002 columnname: returndate
1004 columnname: issuedate
1006 columnname: checked_out_from
1008 columnname: home_library
1013 cannot_be_toggled: 1
1014 cannot_be_modified: 1
1016 columnname: amountoutstanding
1017 cannot_be_toggled: 1
1018 cannot_be_modified: 1
1021 cannot_be_toggled: 1
1022 cannot_be_modified: 1
1026 default_display_length: 20
1027 default_sort_order: 3
1030 columnname: checkbox
1031 cannot_be_toggled: 1
1032 cannot_be_modified: 1
1035 cannot_be_toggled: 1
1036 cannot_be_modified: 1
1038 columnname: account_type
1040 columnname: description
1046 columnname: callnumber
1048 columnname: date_due
1050 columnname: returndate
1052 columnname: issuedate
1054 columnname: checked_out_from
1056 columnname: home_library
1062 columnname: amountoutstanding
1068 columnname: checkbox
1069 cannot_be_toggled: 1
1070 cannot_be_modified: 1
1072 columnname: cardnumber
1079 columnname: dateofbirth
1083 columnname: category
1085 columnname: expires_on
1087 columnname: od_checkouts
1091 columnname: circ_notes
1094 cannot_be_toggled: 1
1095 cannot_be_modified: 1
1101 columnname: sort_order
1102 cannot_be_toggled: 1
1103 cannot_be_modified: 1
1106 columnname: todays_or_previous_checkouts
1107 cannot_be_toggled: 1
1108 cannot_be_modified: 1
1111 columnname: due_date_unformatted
1112 cannot_be_toggled: 1
1113 cannot_be_modified: 1
1116 columnname: due_date
1120 columnname: record_type
1122 columnname: item_type
1124 columnname: collection
1126 columnname: location
1128 columnname: homebranch
1130 columnname: checkout_on_unformatted
1131 cannot_be_toggled: 1
1132 cannot_be_modified: 1
1135 columnname: checkout_on
1137 columnname: checkout_from
1141 columnname: copynumber
1150 cannot_be_toggled: 1
1151 cannot_be_modified: 1
1155 columnname: claims_returned
1158 cannot_be_toggled: 1
1159 cannot_be_modified: 1
1164 columnname: reservedate
1168 columnname: callnumber
1170 columnname: itemtype
1174 columnname: pickup_location
1176 columnname: expirationdate
1178 columnname: priority
1184 cannot_be_toggled: 1
1185 cannot_be_modified: 1
1188 cannot_be_toggled: 1
1189 cannot_be_modified: 1
1196 columnname: booking_id
1203 columnname: start_date
1205 columnname: end_date
1208 cannot_be_toggled: 0
1210 relatives-issues-table:
1213 columnname: due_date_unformatted
1214 cannot_be_toggled: 1
1215 cannot_be_modified: 1
1218 columnname: due_date
1222 columnname: record_type
1224 columnname: item_type
1226 columnname: collection
1228 columnname: location
1230 columnname: checkout_on_unformatted
1231 cannot_be_toggled: 1
1232 cannot_be_modified: 1
1235 columnname: checkout_on
1237 columnname: checkout_from
1241 columnname: copynumber
1253 default_display_length: 20
1257 cannot_be_toggled: 1
1258 cannot_be_modified: 1
1264 columnname: itemcallnumber
1268 columnname: reservedate
1270 columnname: expirationdate
1272 columnname: waitingdate
1274 columnname: cancellationdate
1276 columnname: itemtype
1281 checkouthistory-table:
1282 default_display_length: 20
1285 cannot_be_toggled: 1
1286 cannot_be_modified: 1
1294 columnname: call_number
1296 columnname: enumchron
1300 columnname: number_of_renewals
1302 columnname: checked_out_on
1304 columnname: checked_out_from
1306 columnname: date_due
1308 columnname: return_date
1312 default_display_length: 20
1313 default_sort_order: 3
1316 columnname: checkbox
1317 cannot_be_toggled: 1
1318 cannot_be_modified: 1
1322 columnname: firstname
1328 columnname: category
1332 columnname: expires_on
1334 columnname: circ_notes
1342 cannot_be_toggled: 1
1343 cannot_be_modified: 1
1347 columnname: lostcode
1349 columnname: itemlost_on
1353 columnname: callnumber
1355 columnname: datelastseen
1359 columnname: replacementprice
1363 columnname: itemtype
1365 columnname: collection_code
1367 columnname: current_location
1369 columnname: location
1371 columnname: notforloan
1377 default_display_length: 20
1378 default_sort_order: 0
1384 cannot_be_toggled: 1
1385 cannot_be_modified: 1
1387 columnname: basket_name
1389 columnname: basket_by
1393 columnname: currency
1395 columnname: list_price
1399 columnname: budgeted_cost
1401 columnname: quantity
1403 columnname: total_rrp
1405 columnname: total_cost
1407 columnname: entry_date
1409 columnname: date_received
1411 columnname: internal_note
1413 columnname: vendor_note
1417 default_display_length: 20
1418 default_sort_order: 0
1421 columnname: selection
1422 cannot_be_toggled: 1
1423 cannot_be_modified: 1
1425 columnname: report_id
1426 cannot_be_toggled: 1
1427 cannot_be_modified: 1
1429 columnname: report_name
1435 columnname: subgroup
1441 columnname: creation_date
1443 columnname: last_edit
1445 columnname: last_run
1449 columnname: json_url
1451 columnname: cache_expiry
1453 columnname: saved_results
1458 cannot_be_toggled: 1
1459 cannot_be_modified: 1
1466 columnname: sort_order
1467 cannot_be_toggled: 1
1468 cannot_be_modified: 1
1471 columnname: todays_or_previous_checkouts
1472 cannot_be_toggled: 1
1473 cannot_be_modified: 1
1476 columnname: due_date_unformatted
1477 cannot_be_toggled: 1
1478 cannot_be_modified: 1
1481 columnname: due_date
1485 columnname: record_type
1487 columnname: item_type
1489 columnname: collection
1491 columnname: location
1493 columnname: homebranch
1495 columnname: checkout_on_unformatted
1496 cannot_be_toggled: 1
1497 cannot_be_modified: 1
1500 columnname: checkout_on
1502 columnname: checkout_from
1506 columnname: copynumber
1515 cannot_be_toggled: 1
1516 cannot_be_modified: 1
1520 columnname: claims_returned
1523 cannot_be_toggled: 1
1524 cannot_be_modified: 1
1526 relatives-issues-table:
1529 columnname: due_date_unformatted
1530 cannot_be_toggled: 1
1531 cannot_be_modified: 1
1534 columnname: due_date
1538 columnname: record_type
1540 columnname: item_type
1542 columnname: collection
1544 columnname: location
1546 columnname: checkout_on_unformatted
1547 cannot_be_toggled: 1
1548 cannot_be_modified: 1
1551 columnname: checkout_on
1553 columnname: checkout_from
1557 columnname: copynumber
1571 cannot_be_toggled: 1
1572 cannot_be_modified: 1
1574 columnname: cardnumber
1576 columnname: date_of_birth
1578 columnname: category
1590 columnname: reservedate
1594 columnname: callnumber
1596 columnname: itemtype
1600 columnname: pickup_location
1602 columnname: expirationdate
1604 columnname: priority
1610 cannot_be_toggled: 1
1611 cannot_be_modified: 1
1614 cannot_be_toggled: 1
1615 cannot_be_modified: 1
1623 columnname: due_date
1631 columnname: homelibrary
1633 columnname: transferlibrary
1635 columnname: transferreason
1637 columnname: location
1639 columnname: itemcallnumber
1641 columnname: dateaccessioned
1644 columnname: record_type
1650 columnname: borrower
1652 columnname: itemnote
1656 default_sort_order: 3
1661 columnname: holdingbranch
1664 columnname: homebranch
1667 columnname: collection
1669 columnname: document_type
1671 columnname: callnumber
1673 columnname: copynumber
1675 columnname: enumeration
1681 columnname: patroncategory
1691 default_display_length: 20
1692 default_sort_order: 0
1695 columnname: pull_items
1697 columnname: avalaible_items
1705 columnname: libraries
1707 columnname: barcodes
1709 columnname: call_numbers
1711 columnname: copy_numbers
1713 columnname: enumeration
1715 columnname: itemtypes
1717 columnname: locations
1719 columnname: collection
1721 columnname: hold_date
1723 columnname: reserve_notes
1725 columnname: pickup_location
1732 columnname: checkbox
1733 cannot_be_toggled: 1
1734 cannot_be_modified: 1
1736 columnname: priority
1737 cannot_be_toggled: 1
1738 cannot_be_modified: 1
1740 columnname: change_priority
1748 columnname: expiration
1749 cannot_be_toggled: 1
1750 cannot_be_modified: 1
1752 columnname: pickup_library
1753 cannot_be_toggled: 1
1754 cannot_be_modified: 1
1758 columnname: set_lowest_priority
1764 columnname: print_slip
1768 default_display_length: 20
1775 columnname: holds_ratio
1779 columnname: home_libraries
1781 columnname: holding_libraries
1783 columnname: location
1785 columnname: itemtype
1787 columnname: collection
1789 columnname: call_numbers
1791 columnname: items_needed
1793 holds_awaiting_pickup:
1795 default_display_length: 20
1796 default_sort_order: 1
1799 columnname: checkbox
1800 cannot_be_toggled: 1
1801 cannot_be_modified: 1
1803 columnname: waiting_since
1805 columnname: date_hold_placed
1807 columnname: expiration_date
1813 columnname: home_library
1815 columnname: current_location
1817 columnname: shelving_location
1819 columnname: call_number
1821 columnname: copy_number
1823 columnname: enumeration
1828 default_display_length: 20
1829 default_sort_order: 1
1832 columnname: checkbox
1833 cannot_be_toggled: 1
1834 cannot_be_modified: 1
1836 columnname: waiting_since
1838 columnname: date_hold_placed
1840 columnname: expiration_date
1846 columnname: home_library
1848 columnname: current_location
1850 columnname: shelving_location
1852 columnname: call_number
1854 columnname: copy_number
1856 columnname: enumeration
1861 default_display_length: 20
1862 default_sort_order: 1
1865 columnname: checkbox
1866 cannot_be_toggled: 1
1867 cannot_be_modified: 1
1869 columnname: waiting_since
1871 columnname: date_hold_placed
1873 columnname: date_cancellation_request
1875 columnname: expiration_date
1881 columnname: home_library
1883 columnname: current_location
1885 columnname: shelving_location
1887 columnname: call_number
1889 columnname: copy_number
1891 columnname: enumeration
1897 default_display_length: 20
1898 default_sort_order: 0
1901 columnname: due_date
1905 columnname: patron_category
1908 columnname: patron_library
1912 columnname: home_library
1915 columnname: holding_library
1918 columnname: shelving_location
1922 columnname: call_number
1924 columnname: item_type
1929 columnname: non-public_note
1931 columnname: claims_returned
1934 print-summary-checkouts:
1941 columnname: call_number
1943 columnname: item_type
1945 columnname: date_due
1949 columnname: inventory_number
1957 print-summary-holds:
1964 columnname: placed_on
1966 columnname: expires_on
1968 columnname: pick up_location
1970 columnname: priority
1972 print-summary-fines:
1977 columnname: description_of_charges
1983 columnname: outstanding
1990 columnname: item_cover
1992 columnname: item_itemtype
1994 columnname: item_current_location
1996 columnname: item_home_location
1998 columnname: item_shelving_location
2001 columnname: item_ccode
2003 columnname: item_callnumber
2005 columnname: item_materials
2008 columnname: item_enumchron
2010 columnname: item_url
2012 columnname: item_copy
2014 columnname: item_status
2016 columnname: item_notes
2018 columnname: item_datedue
2020 columnname: item_barcode
2023 columnname: item_holds
2025 columnname: item_priority
2027 columnname: item_coursereserves
2029 course_reserves_table:
2032 columnname: coursename
2034 columnname: department
2036 columnname: course_number
2042 columnname: instructor
2049 columnname: serial_serialseq
2051 columnname: serial_publisheddate
2053 columnname: serial_planneddate
2055 columnname: serial_status
2057 columnname: serial_notes
2066 columnname: itemtype
2068 columnname: location
2070 columnname: collection
2072 columnname: callnumber
2074 columnname: copynumber
2085 subscription-detail:
2093 columnname: ordernumber
2095 columnname: creation_date
2097 columnname: receive_date
2101 columnname: order_internalnote
2103 columnname: order_vendornote
2112 batch_patron_modification:
2116 columnname: batch_patron_edit_selections
2117 cannot_be_toggled: 1
2118 cannot_be_modified: 1
2120 columnname: batch_patron_edit_cardnumber
2122 columnname: batch_patron_edit_surname
2124 columnname: batch_patron_edit_firstname
2126 columnname: batch_patron_edit_branchcode
2128 columnname: batch_patron_edit_categorycode
2130 columnname: batch_patron_edit_streetnumber
2132 columnname: batch_patron_edit_address
2134 columnname: batch_patron_edit_address2
2136 columnname: batch_patron_edit_city
2138 columnname: batch_patron_edit_state
2140 columnname: batch_patron_edit_zipcode
2142 columnname: batch_patron_edit_country
2144 columnname: batch_patron_edit_email
2146 columnname: batch_patron_edit_phone
2148 columnname: batch_patron_edit_mobile
2150 columnname: batch_patron_edit_dateenrolled
2152 columnname: batch_patron_edit_dateexpiry
2154 columnname: batch_patron_edit_borrowernotes
2156 columnname: batch_patron_edit_opacnote
2158 columnname: batch_patron_edit_debarred
2160 columnname: batch_patron_edit_debarredcomment
2164 default_display_length: 20
2169 columnname: librarian
2179 columnname: interface
2180 marc-modification-templates:
2187 columnname: template
2190 cannot_be_toggled: 1
2191 cannot_be_modified: 1
2194 default_sort_order: 3
2205 columnname: updated_on
2207 columnname: copy_notice
2210 cannot_be_toggled: 1
2211 cannot_be_modified: 1
2219 columnname: cyclical
2223 columnname: description
2225 columnname: number_of_items
2228 cannot_be_toggled: 1
2229 cannot_be_modified: 1
2231 stock_rotation_manage_items:
2240 columnname: call_number
2242 columnname: in_transit
2247 cannot_be_toggled: 1
2248 cannot_be_modified: 1
2252 default_display_length: 20
2255 columnname: filename
2259 columnname: hashvalue
2264 columnname: category
2268 columnname: temporary
2271 cannot_be_toggled: 1
2272 cannot_be_modified: 1
2280 columnname: description
2285 cannot_be_toggled: 1
2286 cannot_be_modified: 1