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_on
180 columnname: patron_reason
182 columnname: managed_by
184 columnname: managed_on
186 columnname: lastmodificationby
188 columnname: lastmodificationdate
190 columnname: last_updated_date
194 columnname: library_fund
196 columnname: staff_note
198 columnname: suggestion_status
202 cannot_be_modified: 1
206 default_display_length: 20
207 default_sort_order: 0
212 columnname: city_name
214 columnname: city_state
216 columnname: city_zipcode
218 columnname: city_country
222 cannot_be_modified: 1
229 cannot_be_modified: 1
233 cannot_be_modified: 1
240 columnname: last_updated
248 default_display_length: 20
249 default_sort_order: 1
254 columnname: category_name
258 columnname: enrollment_period
260 columnname: age_required
262 columnname: upper_age_limit
264 columnname: enrollment_fee
268 columnname: lost_items
272 columnname: messaging
274 columnname: branches_limitations
276 columnname: default_privacy
280 cannot_be_modified: 1
284 default_display_length: 10
285 default_sort_order: 1
290 columnname: description
294 columnname: parent_code
296 columnname: search_category
298 columnname: not_for_loan
300 columnname: hide_in_opac
302 columnname: rental_charge
304 columnname: daily_rental_charge
306 columnname: hourly_rental_charge
308 columnname: default_replacement_cost
310 columnname: lost_processing_fee
312 columnname: checkin_message
314 columnname: library_limitations
316 columnname: automatic_checkin
321 cannot_be_modified: 1
325 default_display_length: 20
326 default_sort_order: 0
329 columnname: library_name
331 columnname: library_code
333 columnname: library_address
335 columnname: marc_organization_code
337 columnname: library_ip
339 columnname: is_pickup_location
343 columnname: smtp_server
347 cannot_be_modified: 1
354 columnname: holdings_checkbox
356 cannot_be_modified: 1
358 columnname: holdings_cover_image
360 columnname: holdings_itype
362 columnname: holdings_holdingbranch
364 columnname: holdings_homebranch
366 columnname: holdings_ccode
368 columnname: holdings_volume
370 columnname: holdings_itemcallnumber
372 columnname: holdings_status
374 columnname: holdings_lastseen
376 columnname: holdings_issues
379 columnname: holdings_renewals
382 columnname: holdings_dateaccessioned
384 columnname: holdings_datelastborrowed
386 columnname: holdings_barcode
388 columnname: holdings_enumchron
390 columnname: holdings_uri
392 columnname: holdings_copynumber
394 columnname: holdings_stocknumber
396 columnname: holdings_materials
398 columnname: holdings_itemnotes
400 columnname: holdings_itemnotes_nonpublic
402 columnname: holdings_hostrecord
404 columnname: holdings_usedin
406 columnname: holdings_usedin_col
408 columnname: holdings_course_reserves
410 columnname: holdings_spinelabel
412 columnname: holdings_actions
414 cannot_be_modified: 1
419 columnname: otherholdings_checkbox
421 cannot_be_modified: 1
423 columnname: otherholdings_cover_image
425 columnname: otherholdings_itype
427 columnname: otherholdings_holdingbranch
429 columnname: otherholdings_homebranch
431 columnname: otherholdings_ccode
433 columnname: otherholdings_volume
435 columnname: otherholdings_itemcallnumber
437 columnname: otherholdings_status
439 columnname: otherholdings_lastseen
441 columnname: otherholdings_issues
444 columnname: otherholdings_renewals
447 columnname: otherholdings_dateaccessioned
449 columnname: otherholdings_datelastborrowed
451 columnname: otherholdings_barcode
453 columnname: otherholdings_enumchron
455 columnname: otherholdings_uri
457 columnname: otherholdings_copynumber
459 columnname: otherholdings_stocknumber
461 columnname: otherholdings_materials
463 columnname: otherholdings_itemnotes
465 columnname: otherholdings_itemnotes_nonpublic
467 columnname: otherholdings_hostrecord
469 columnname: otherholdings_usedin
471 columnname: otherholdings_usedin_col
473 columnname: otherholdings_course_reserves
475 columnname: otherholdings_spinelabel
477 columnname: otherholdings_actions
479 cannot_be_modified: 1
481 acquisitiondetails-table:
488 columnname: basketgroup
492 columnname: ordernumber
494 columnname: creation_date
496 columnname: received_data
504 columnname: order_internalnote
506 columnname: subscription
508 columnname: subscription_callnumber
510 checkoutshistory-table:
511 default_display_length: 20
516 cannot_be_modified: 1
520 cannot_be_modified: 1
522 columnname: checked_out_from
524 columnname: checked_out_by
528 columnname: checkout_on
532 columnname: checkin_on
542 columnname: callnumber
548 columnname: bundle_actions
550 cannot_be_modified: 1
561 columnname: coming_from
563 columnname: import_date
567 cannot_be_modified: 1
570 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
571 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
572 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
578 columnname: dateaccessioned
580 columnname: booksellerid
582 columnname: homebranch
586 columnname: replacementprice
588 columnname: replacementpricedate
590 columnname: datelastborrowed
592 columnname: datelastseen
596 columnname: notforloan
602 columnname: withdrawn
604 columnname: itemcallnumber
606 columnname: coded_location_qualifier
608 columnname: restricted
610 columnname: itemnotes
612 columnname: itemnotes_nonpublic
614 columnname: holdingbranch
616 columnname: timestamp
622 columnname: cn_source
626 columnname: materials
632 columnname: enumchron
634 columnname: copynumber
636 columnname: stocknumber
640 default_sort_order: 1
659 cannot_be_modified: 1
663 course_reserves_table:
664 default_display_length: 20
665 default_sort_order: 0
670 columnname: department
672 columnname: course_no
678 columnname: instructors
680 columnname: staff_note
682 columnname: public_note
684 columnname: no_of_students
689 course_reserves_table:
690 default_display_length: 20
691 default_sort_order: 0
700 columnname: call_number
702 columnname: item_type
704 columnname: collection
708 columnname: home_library
710 columnname: holding_library
712 columnname: staff_note
714 columnname: public_note
718 columnname: other_course_reserves
722 cannot_be_modified: 1
733 columnname: description
737 columnname: closure_reason
739 columnname: is_perpetual
741 columnname: renewal_priority
745 cannot_be_modified: 1
754 columnname: description
760 columnname: started_on
766 cannot_be_modified: 1
777 columnname: content_type
779 columnname: created_on
785 cannot_be_modified: 1
791 columnname: contributors
793 columnname: publication_type
795 columnname: identifier
799 cannot_be_modified: 1
806 columnname: illrequest_id
808 columnname: metadata_author
810 columnname: metadata_title
812 columnname: metadata_article_title
814 columnname: metadata_issue
816 columnname: metadata_volume
818 columnname: metadata_year
820 columnname: metadata_pages
822 columnname: metadata_type
828 columnname: biblio_id
830 columnname: library_branchname
836 cannot_be_modified: 1
839 columnname: placed_formatted
843 cannot_be_modified: 1
846 columnname: updated_formatted
850 columnname: completed
852 cannot_be_modified: 1
855 columnname: completed_formatted
857 columnname: accessurl
863 columnname: notesopac
865 columnname: notesstaff
871 cannot_be_modified: 1
876 default_display_length: 20
881 columnname: timestamp
883 columnname: credit_number
886 columnname: account_type
888 columnname: description
894 columnname: returndate
896 columnname: issuedate
898 columnname: checked_out_from
900 columnname: home_library
906 cannot_be_modified: 1
908 columnname: amountoutstanding
910 cannot_be_modified: 1
914 cannot_be_modified: 1
918 default_display_length: 20
919 default_sort_order: 3
924 cannot_be_modified: 1
928 cannot_be_modified: 1
930 columnname: account_type
932 columnname: description
940 columnname: returndate
942 columnname: issuedate
944 columnname: checked_out_from
950 columnname: amountoutstanding
958 cannot_be_modified: 1
960 columnname: cardnumber
964 columnname: dateofbirth
970 columnname: expires_on
972 columnname: od_checkouts
976 columnname: circ_notes
980 cannot_be_modified: 1
986 columnname: sort_order
988 cannot_be_modified: 1
991 columnname: todays_or_previous_checkouts
993 cannot_be_modified: 1
996 columnname: due_date_unformatted
998 cannot_be_modified: 1
1001 columnname: due_date
1005 columnname: record_type
1007 columnname: item_type
1009 columnname: collection
1011 columnname: location
1013 columnname: homebranch
1015 columnname: checkout_on_unformatted
1016 cannot_be_toggled: 1
1017 cannot_be_modified: 1
1020 columnname: checkout_on
1022 columnname: checkout_from
1026 columnname: copynumber
1035 cannot_be_toggled: 1
1036 cannot_be_modified: 1
1040 columnname: claims_returned
1043 cannot_be_toggled: 1
1044 cannot_be_modified: 1
1046 relatives-issues-table:
1049 columnname: due_date_unformatted
1050 cannot_be_toggled: 1
1051 cannot_be_modified: 1
1054 columnname: due_date
1058 columnname: record_type
1060 columnname: item_type
1062 columnname: collection
1064 columnname: location
1066 columnname: checkout_on_unformatted
1067 cannot_be_toggled: 1
1068 cannot_be_modified: 1
1071 columnname: checkout_on
1073 columnname: checkout_from
1077 columnname: copynumber
1089 default_display_length: 20
1093 cannot_be_toggled: 1
1094 cannot_be_modified: 1
1102 columnname: reservedate
1104 columnname: expirationdate
1106 columnname: waitingdate
1108 columnname: cancellationdate
1110 columnname: itemtype
1115 checkouthistory-table:
1116 default_display_length: 20
1119 cannot_be_toggled: 1
1120 cannot_be_modified: 1
1128 columnname: call_number
1130 columnname: enumchron
1134 columnname: number_of_renewals
1136 columnname: checked_out_on
1138 columnname: checked_out_from
1140 columnname: date_due
1142 columnname: return_date
1146 default_display_length: 20
1147 default_sort_order: 3
1150 columnname: checkbox
1151 cannot_be_toggled: 1
1152 cannot_be_modified: 1
1156 columnname: firstname
1162 columnname: category
1166 columnname: expires_on
1168 columnname: circ_notes
1176 cannot_be_toggled: 1
1177 cannot_be_modified: 1
1181 columnname: lostcode
1183 columnname: itemlost_on
1187 columnname: callnumber
1189 columnname: datelastseen
1193 columnname: replacementprice
1197 columnname: itemtype
1199 columnname: collection_code
1201 columnname: current_location
1203 columnname: location
1205 columnname: notforloan
1211 default_display_length: 20
1212 default_sort_order: 0
1218 cannot_be_toggled: 1
1219 cannot_be_modified: 1
1221 columnname: basket_name
1223 columnname: basket_by
1227 columnname: currency
1229 columnname: list_price
1233 columnname: budgeted_cost
1235 columnname: quantity
1237 columnname: total_rrp
1239 columnname: total_cost
1241 columnname: entry_date
1243 columnname: date_received
1245 columnname: internal_note
1247 columnname: vendor_note
1251 default_display_length: 20
1252 default_sort_order: 0
1255 columnname: selection
1256 cannot_be_toggled: 1
1257 cannot_be_modified: 1
1259 columnname: report_id
1260 cannot_be_toggled: 1
1261 cannot_be_modified: 1
1263 columnname: report_name
1269 columnname: subgroup
1275 columnname: creation_date
1277 columnname: last_edit
1279 columnname: last_run
1283 columnname: json_url
1285 columnname: cache_expiry
1287 columnname: saved_results
1292 cannot_be_toggled: 1
1293 cannot_be_modified: 1
1300 columnname: sort_order
1301 cannot_be_toggled: 1
1302 cannot_be_modified: 1
1305 columnname: todays_or_previous_checkouts
1306 cannot_be_toggled: 1
1307 cannot_be_modified: 1
1310 columnname: due_date_unformatted
1311 cannot_be_toggled: 1
1312 cannot_be_modified: 1
1315 columnname: due_date
1319 columnname: record_type
1321 columnname: item_type
1323 columnname: collection
1325 columnname: location
1327 columnname: homebranch
1329 columnname: checkout_on_unformatted
1330 cannot_be_toggled: 1
1331 cannot_be_modified: 1
1334 columnname: checkout_on
1336 columnname: checkout_from
1340 columnname: copynumber
1349 cannot_be_toggled: 1
1350 cannot_be_modified: 1
1354 columnname: claims_returned
1357 cannot_be_toggled: 1
1358 cannot_be_modified: 1
1360 relatives-issues-table:
1363 columnname: due_date_unformatted
1364 cannot_be_toggled: 1
1365 cannot_be_modified: 1
1368 columnname: due_date
1372 columnname: record_type
1374 columnname: item_type
1376 columnname: collection
1378 columnname: location
1380 columnname: checkout_on_unformatted
1381 cannot_be_toggled: 1
1382 cannot_be_modified: 1
1385 columnname: checkout_on
1387 columnname: checkout_from
1391 columnname: copynumber
1405 cannot_be_toggled: 1
1406 cannot_be_modified: 1
1408 columnname: cardnumber
1410 columnname: date_of_birth
1412 columnname: category
1425 columnname: due_date
1433 columnname: homelibrary
1435 columnname: transferlibrary
1437 columnname: location
1439 columnname: itemcallnumber
1441 columnname: dateaccessioned
1444 columnname: record_type
1450 columnname: borrower
1452 columnname: itemnote
1456 default_sort_order: 3
1461 columnname: holdingbranch
1464 columnname: collection
1466 columnname: document_type
1468 columnname: callnumber
1470 columnname: copynumber
1472 columnname: enumeration
1478 columnname: patroncategory
1488 default_display_length: 20
1489 default_sort_order: 0
1492 columnname: pull_items
1494 columnname: avalaible_items
1502 columnname: libraries
1504 columnname: barcodes
1506 columnname: call_numbers
1508 columnname: copy_numbers
1510 columnname: enumeration
1512 columnname: itemtypes
1514 columnname: locations
1516 columnname: hold_date
1518 columnname: reserve_notes
1520 columnname: pickup_location
1526 default_display_length: 20
1533 columnname: holds_ratio
1537 columnname: home_libraries
1539 columnname: holding_libraries
1541 columnname: location
1543 columnname: itemtype
1545 columnname: call_numbers
1547 columnname: items_needed
1549 holds_awaiting_pickup:
1553 columnname: checkbox
1554 cannot_be_toggled: 1
1555 cannot_be_modified: 1
1557 columnname: waiting_since
1559 columnname: date_hold_placed
1561 columnname: expiration_date
1567 columnname: home_library
1569 columnname: current_location
1571 columnname: shelving_location
1573 columnname: call_number
1575 columnname: copy_number
1577 columnname: enumeration
1584 columnname: checkbox
1585 cannot_be_toggled: 1
1586 cannot_be_modified: 1
1588 columnname: waiting_since
1590 columnname: date_hold_placed
1592 columnname: expiration_date
1598 columnname: home_library
1600 columnname: current_location
1602 columnname: shelving_location
1604 columnname: call_number
1606 columnname: copy_number
1608 columnname: enumeration
1615 columnname: checkbox
1616 cannot_be_toggled: 1
1617 cannot_be_modified: 1
1619 columnname: waiting_since
1621 columnname: date_hold_placed
1623 columnname: expiration_date
1629 columnname: home_library
1631 columnname: current_location
1633 columnname: shelving_location
1635 columnname: call_number
1637 columnname: copy_number
1639 columnname: enumeration
1645 default_display_length: 20
1646 default_sort_order: 0
1649 columnname: due_date
1653 columnname: patron_category
1656 columnname: patron_library
1660 columnname: home_library
1663 columnname: holding_library
1666 columnname: shelving_location
1670 columnname: call_number
1672 columnname: item_type
1677 columnname: non-public_note
1679 columnname: claims_returned
1682 print-summary-checkouts:
1689 columnname: call_number
1691 columnname: item_type
1693 columnname: date_due
1697 columnname: inventory_number
1705 print-summary-holds:
1712 columnname: placed_on
1714 columnname: expires_on
1716 columnname: pick up_location
1718 print-summary-fines:
1723 columnname: description_of_charges
1729 columnname: outstanding
1736 columnname: item_cover
1738 columnname: item_itemtype
1740 columnname: item_current_location
1742 columnname: item_home_location
1744 columnname: item_shelving_location
1747 columnname: item_ccode
1749 columnname: item_callnumber
1751 columnname: item_materials
1754 columnname: item_enumchron
1756 columnname: item_url
1758 columnname: item_copy
1760 columnname: item_status
1762 columnname: item_notes
1764 columnname: item_datedue
1766 columnname: item_barcode
1769 columnname: item_holds
1771 columnname: item_priority
1773 columnname: item_coursereserves
1775 course_reserves_table:
1778 columnname: coursename
1780 columnname: department
1782 columnname: course_number
1788 columnname: instructor
1795 columnname: serial_serialseq
1797 columnname: serial_publisheddate
1799 columnname: serial_planneddate
1801 columnname: serial_status
1803 columnname: serial_notes
1812 columnname: itemtype
1814 columnname: location
1816 columnname: collection
1818 columnname: callnumber
1820 columnname: copynumber
1831 subscription-detail:
1839 columnname: ordernumber
1841 columnname: creation_date
1843 columnname: receive_date
1847 columnname: order_internalnote
1849 columnname: order_vendornote
1858 batch_patron_modification:
1862 columnname: batch_patron_edit_selections
1863 cannot_be_toggled: 1
1864 cannot_be_modified: 1
1866 columnname: batch_patron_edit_cardnumber
1868 columnname: batch_patron_edit_surname
1870 columnname: batch_patron_edit_firstname
1872 columnname: batch_patron_edit_branchcode
1874 columnname: batch_patron_edit_categorycode
1876 columnname: batch_patron_edit_streetnumber
1878 columnname: batch_patron_edit_address
1880 columnname: batch_patron_edit_address2
1882 columnname: batch_patron_edit_city
1884 columnname: batch_patron_edit_state
1886 columnname: batch_patron_edit_zipcode
1888 columnname: batch_patron_edit_country
1890 columnname: batch_patron_edit_email
1892 columnname: batch_patron_edit_phone
1894 columnname: batch_patron_edit_mobile
1896 columnname: batch_patron_edit_dateenrolled
1898 columnname: batch_patron_edit_dateexpiry
1900 columnname: batch_patron_edit_borrowernotes
1902 columnname: batch_patron_edit_opacnote
1904 columnname: batch_patron_edit_debarred
1906 columnname: batch_patron_edit_debarredcomment
1910 default_display_length: 20
1915 columnname: librarian
1925 columnname: interface
1926 marc-modification-templates:
1933 columnname: template
1936 cannot_be_toggled: 1
1937 cannot_be_modified: 1
1940 default_sort_order: 3
1951 columnname: updated_on
1953 columnname: copy_notice
1956 cannot_be_toggled: 1
1957 cannot_be_modified: 1
1965 columnname: cyclical
1969 columnname: description
1971 columnname: number_of_items
1974 cannot_be_toggled: 1
1975 cannot_be_modified: 1
1977 stock_rotation_manage_items:
1986 columnname: call_number
1988 columnname: in_transit
1993 cannot_be_toggled: 1
1994 cannot_be_modified: 1
1998 default_display_length: 20
2001 columnname: filename
2005 columnname: hashvalue
2010 columnname: category
2014 columnname: temporary
2017 cannot_be_toggled: 1
2018 cannot_be_modified: 1
2026 columnname: description
2031 cannot_be_toggled: 1
2032 cannot_be_modified: 1