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 columnmame: 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
341 columnname: smtp_server
345 cannot_be_modified: 1
352 columnname: holdings_checkbox
354 cannot_be_modified: 1
356 columnname: holdings_cover_image
358 columnname: holdings_itype
360 columnname: holdings_holdingbranch
362 columnname: holdings_homebranch
364 columnname: holdings_ccode
366 columnname: holdings_volume
368 columnname: holdings_itemcallnumber
370 columnname: holdings_status
372 columnname: holdings_lastseen
374 columnname: holdings_issues
377 columnname: holdings_renewals
380 columnname: holdings_dateaccessioned
382 columnname: holdings_datelastborrowed
384 columnname: holdings_barcode
386 columnname: holdings_enumchron
388 columnname: holdings_uri
390 columnname: holdings_copynumber
392 columnname: holdings_stocknumber
394 columnname: holdings_materials
396 columnname: holdings_itemnotes
398 columnname: holdings_itemnotes_nonpublic
400 columnname: holdings_hostrecord
402 columnname: holdings_usedin
404 columnname: holdings_usedin_col
406 columnname: holdings_course_reserves
408 columnname: holdings_spinelabel
410 columnname: holdings_actions
412 cannot_be_modified: 1
417 columnname: otherholdings_checkbox
419 cannot_be_modified: 1
421 columnname: otherholdings_cover_image
423 columnname: otherholdings_itype
425 columnname: otherholdings_holdingbranch
427 columnname: otherholdings_homebranch
429 columnname: otherholdings_ccode
431 columnname: otherholdings_volume
433 columnname: otherholdings_itemcallnumber
435 columnname: otherholdings_status
437 columnname: otherholdings_lastseen
439 columnname: otherholdings_issues
442 columnname: otherholdings_renewals
445 columnname: otherholdings_dateaccessioned
447 columnname: otherholdings_datelastborrowed
449 columnname: otherholdings_barcode
451 columnname: otherholdings_enumchron
453 columnname: otherholdings_uri
455 columnname: otherholdings_copynumber
457 columnname: otherholdings_stocknumber
459 columnname: otherholdings_materials
461 columnname: otherholdings_itemnotes
463 columnname: otherholdings_itemnotes_nonpublic
465 columnname: otherholdings_hostrecord
467 columnname: otherholdings_usedin
469 columnname: otherholdings_usedin_col
471 columnname: otherholdings_course_reserves
473 columnname: otherholdings_spinelabel
475 columnname: otherholdings_actions
477 cannot_be_modified: 1
479 acquisitiondetails-table:
486 columnname: basketgroup
490 columnname: ordernumber
492 columnname: creation_date
494 columnname: received_data
502 columnname: order_internalnote
504 columnname: subscription
506 columnname: subscription_callnumber
508 checkoutshistory-table:
509 default_display_length: 20
514 cannot_be_modified: 1
518 cannot_be_modified: 1
520 columnname: checked_out_from
522 columnname: checked_out_by
526 columnname: checkout_on
530 columnname: checkin_on
540 columnname: callnumber
546 columnname: bundle_actions
548 cannot_be_modified: 1
559 columnname: coming_from
561 columnname: import_date
565 cannot_be_modified: 1
568 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
569 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
570 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
576 columnname: dateaccessioned
578 columnname: booksellerid
580 columnname: homebranch
584 columnname: replacementprice
586 columnname: replacementpricedate
588 columnname: datelastborrowed
590 columnname: datelastseen
594 columnname: notforloan
600 columnname: withdrawn
602 columnname: itemcallnumber
604 columnname: coded_location_qualifier
606 columnname: restricted
608 columnname: itemnotes
610 columnname: itemnotes_nonpublic
612 columnname: holdingbranch
614 columnname: timestamp
620 columnname: cn_source
624 columnname: materials
630 columnname: enumchron
632 columnname: copynumber
634 columnname: stocknumber
638 default_sort_order: 1
657 cannot_be_modified: 1
661 course_reserves_table:
662 default_display_length: 20
663 default_sort_order: 0
668 columnname: department
670 columnname: course_no
676 columnname: instructors
678 columnname: staff_note
680 columnname: public_note
682 columnname: no_of_students
687 course_reserves_table:
688 default_display_length: 20
689 default_sort_order: 0
698 columnname: call_number
700 columnname: item_type
702 columnname: collection
706 columnname: home_library
708 columnname: holding_library
710 columnname: staff_note
712 columnname: public_note
716 columnname: other_course_reserves
720 cannot_be_modified: 1
731 columnname: description
735 columnname: closure_reason
737 columnname: is_perpetual
739 columnname: renewal_priority
743 cannot_be_modified: 1
752 columnname: description
758 columnname: started_on
764 cannot_be_modified: 1
775 columnname: content_type
777 columnname: created_on
783 cannot_be_modified: 1
789 columnname: contributors
791 columnname: publication_type
793 columnname: identifier
797 cannot_be_modified: 1
804 columnname: illrequest_id
806 columnname: metadata_author
808 columnname: metadata_title
810 columnname: metadata_article_title
812 columnname: metadata_issue
814 columnname: metadata_volume
816 columnname: metadata_year
818 columnname: metadata_pages
820 columnname: metadata_type
826 columnname: biblio_id
828 columnname: library_branchname
834 cannot_be_modified: 1
837 columnname: placed_formatted
841 cannot_be_modified: 1
844 columnname: updated_formatted
848 columnname: completed
850 cannot_be_modified: 1
853 columnname: completed_formatted
855 columnname: accessurl
861 columnname: notesopac
863 columnname: notesstaff
869 cannot_be_modified: 1
874 default_display_length: 20
879 columnname: timestamp
881 columnname: credit_number
884 columnname: account_type
886 columnname: description
892 columnname: returndate
894 columnname: issuedate
896 columnname: checked_out_from
898 columnname: home_library
904 cannot_be_modified: 1
906 columnname: amountoutstanding
908 cannot_be_modified: 1
912 cannot_be_modified: 1
916 default_display_length: 20
917 default_sort_order: 3
922 cannot_be_modified: 1
926 cannot_be_modified: 1
928 columnname: account_type
930 columnname: description
938 columnname: returndate
940 columnname: issuedate
942 columnname: checked_out_from
948 columnname: amountoutstanding
956 cannot_be_modified: 1
958 columnname: cardnumber
962 columnname: dateofbirth
968 columnname: expires_on
970 columnname: od_checkouts
974 columnname: circ_notes
978 cannot_be_modified: 1
984 columnname: sort_order
986 cannot_be_modified: 1
989 columnname: todays_or_previous_checkouts
991 cannot_be_modified: 1
994 columnname: due_date_unformatted
996 cannot_be_modified: 1
1003 columnname: record_type
1005 columnname: item_type
1007 columnname: collection
1009 columnname: location
1011 columnname: homebranch
1013 columnname: checkout_on_unformatted
1014 cannot_be_toggled: 1
1015 cannot_be_modified: 1
1018 columnname: checkout_on
1020 columnname: checkout_from
1024 columnname: copynumber
1033 cannot_be_toggled: 1
1034 cannot_be_modified: 1
1038 columnname: claims_returned
1041 cannot_be_toggled: 1
1042 cannot_be_modified: 1
1044 relatives-issues-table:
1047 columnname: due_date_unformatted
1048 cannot_be_toggled: 1
1049 cannot_be_modified: 1
1052 columnname: due_date
1056 columnname: record_type
1058 columnname: item_type
1060 columnname: collection
1062 columnname: location
1064 columnname: checkout_on_unformatted
1065 cannot_be_toggled: 1
1066 cannot_be_modified: 1
1069 columnname: checkout_on
1071 columnname: checkout_from
1075 columnname: copynumber
1087 default_display_length: 20
1091 cannot_be_toggled: 1
1092 cannot_be_modified: 1
1100 columnname: reservedate
1102 columnname: expirationdate
1104 columnname: waitingdate
1106 columnname: cancellationdate
1108 columnname: itemtype
1113 checkouthistory-table:
1114 default_display_length: 20
1117 cannot_be_toggled: 1
1118 cannot_be_modified: 1
1126 columnname: call_number
1128 columnname: enumchron
1132 columnname: number_of_renewals
1134 columnname: checked_out_on
1136 columnname: checked_out_from
1138 columnname: date_due
1140 columnname: return_date
1144 default_display_length: 20
1145 default_sort_order: 3
1148 columnname: checkbox
1149 cannot_be_toggled: 1
1150 cannot_be_modified: 1
1154 columnname: firstname
1160 columnname: category
1164 columnname: expires_on
1166 columnname: circ_notes
1174 cannot_be_toggled: 1
1175 cannot_be_modified: 1
1179 columnname: lostcode
1181 columnname: itemlost_on
1185 columnname: callnumber
1187 columnname: datelastseen
1191 columnname: replacementprice
1195 columnname: itemtype
1197 columnname: collection_code
1199 columnname: current_location
1201 columnname: location
1203 columnname: notforloan
1209 default_display_length: 20
1210 default_sort_order: 0
1216 cannot_be_toggled: 1
1217 cannot_be_modified: 1
1219 columnname: basket_name
1221 columnname: basket_by
1225 columnname: currency
1227 columnname: list_price
1231 columnname: budgeted_cost
1233 columnname: quantity
1235 columnname: total_rrp
1237 columnname: total_cost
1239 columnname: entry_date
1241 columnname: date_received
1243 columnname: internal_note
1245 columnname: vendor_note
1249 default_display_length: 20
1250 default_sort_order: 0
1253 columnname: selection
1254 cannot_be_toggled: 1
1255 cannot_be_modified: 1
1257 columnname: report_id
1258 cannot_be_toggled: 1
1259 cannot_be_modified: 1
1261 columnname: report_name
1267 columnname: subgroup
1273 columnname: creation_date
1275 columnname: last_edit
1277 columnname: last_run
1281 columnname: json_url
1283 columnname: cache_expiry
1285 columnname: saved_results
1290 cannot_be_toggled: 1
1291 cannot_be_modified: 1
1298 columnname: sort_order
1299 cannot_be_toggled: 1
1300 cannot_be_modified: 1
1303 columnname: todays_or_previous_checkouts
1304 cannot_be_toggled: 1
1305 cannot_be_modified: 1
1308 columnname: due_date_unformatted
1309 cannot_be_toggled: 1
1310 cannot_be_modified: 1
1313 columnname: due_date
1317 columnname: record_type
1319 columnname: item_type
1321 columnname: collection
1323 columnname: location
1325 columnname: homebranch
1327 columnname: checkout_on_unformatted
1328 cannot_be_toggled: 1
1329 cannot_be_modified: 1
1332 columnname: checkout_on
1334 columnname: checkout_from
1338 columnname: copynumber
1347 cannot_be_toggled: 1
1348 cannot_be_modified: 1
1352 columnname: claims_returned
1355 cannot_be_toggled: 1
1356 cannot_be_modified: 1
1358 relatives-issues-table:
1361 columnname: due_date_unformatted
1362 cannot_be_toggled: 1
1363 cannot_be_modified: 1
1366 columnname: due_date
1370 columnname: record_type
1372 columnname: item_type
1374 columnname: collection
1376 columnname: location
1378 columnname: checkout_on_unformatted
1379 cannot_be_toggled: 1
1380 cannot_be_modified: 1
1383 columnname: checkout_on
1385 columnname: checkout_from
1389 columnname: copynumber
1403 cannot_be_toggled: 1
1404 cannot_be_modified: 1
1406 columnname: cardnumber
1408 columnname: date_of_birth
1410 columnname: category
1423 columnname: due_date
1431 columnname: homelibrary
1433 columnname: transferlibrary
1435 columnname: location
1437 columnname: itemcallnumber
1439 columnname: dateaccessioned
1442 columnname: record_type
1448 columnname: borrower
1450 columnname: itemnote
1454 default_sort_order: 3
1459 columnname: holdingbranch
1462 columnname: collection
1464 columnname: document_type
1466 columnname: callnumber
1468 columnname: copynumber
1470 columnname: enumeration
1476 columnname: patroncategory
1486 default_display_length: 20
1487 default_sort_order: 0
1490 columnname: pull_items
1492 columnname: avalaible_items
1500 columnname: libraries
1502 columnname: barcodes
1504 columnname: call_numbers
1506 columnname: copy_numbers
1508 columnname: enumeration
1510 columnname: itemtypes
1512 columnname: locations
1514 columnname: hold_date
1516 columnname: reserve_notes
1518 columnname: pickup_location
1524 default_display_length: 20
1531 columnname: holds_ratio
1535 columnname: home_libraries
1537 columnname: holding_libraries
1539 columnname: location
1541 columnname: itemtype
1543 columnname: call_numbers
1545 columnname: items_needed
1547 holds_awaiting_pickup:
1551 columnname: checkbox
1552 cannot_be_toggled: 1
1553 cannot_be_modified: 1
1555 columnname: waiting_since
1557 columnname: date_hold_placed
1559 columnname: expiration_date
1565 columnname: home_library
1567 columnname: current_location
1569 columnname: shelving_location
1571 columnname: call_number
1573 columnname: copy_number
1575 columnname: enumeration
1582 columnname: checkbox
1583 cannot_be_toggled: 1
1584 cannot_be_modified: 1
1586 columnname: waiting_since
1588 columnname: date_hold_placed
1590 columnname: expiration_date
1596 columnname: home_library
1598 columnname: current_location
1600 columnname: shelving_location
1602 columnname: call_number
1604 columnname: copy_number
1606 columnname: enumeration
1613 columnname: checkbox
1614 cannot_be_toggled: 1
1615 cannot_be_modified: 1
1617 columnname: waiting_since
1619 columnname: date_hold_placed
1621 columnname: expiration_date
1627 columnname: home_library
1629 columnname: current_location
1631 columnname: shelving_location
1633 columnname: call_number
1635 columnname: copy_number
1637 columnname: enumeration
1643 default_display_length: 20
1644 default_sort_order: 0
1647 columnname: due_date
1651 columnname: patron_category
1654 columnname: patron_library
1658 columnname: home_library
1661 columnname: holding_library
1664 columnname: shelving_location
1668 columnname: call_number
1670 columnname: item_type
1675 columnname: non-public_note
1677 columnname: claims_returned
1680 print-summary-checkouts:
1687 columnname: call_number
1689 columnname: item_type
1691 columnname: date_due
1695 columnname: inventory_number
1703 print-summary-holds:
1710 columnname: placed_on
1712 columnname: expires_on
1714 columnname: pick up_location
1716 print-summary-fines:
1721 columnname: description_of_charges
1727 columnname: outstanding
1734 columnname: item_cover
1736 columnname: item_itemtype
1738 columnname: item_current_location
1740 columnname: item_home_location
1742 columnname: item_shelving_location
1745 columnname: item_ccode
1747 columnname: item_callnumber
1749 columnname: item_materials
1752 columnname: item_enumchron
1754 columnname: item_url
1756 columnname: item_copy
1758 columnname: item_status
1760 columnname: item_notes
1762 columnname: item_datedue
1764 columnname: item_barcode
1767 columnname: item_holds
1769 columnname: item_priority
1771 columnname: item_coursereserves
1773 course_reserves_table:
1776 columnname: coursename
1778 columnname: department
1780 columnname: course_number
1786 columnname: instructor
1793 columnname: serial_serialseq
1795 columnname: serial_publisheddate
1797 columnname: serial_planneddate
1799 columnname: serial_status
1801 columnname: serial_notes
1810 columnname: itemtype
1812 columnname: location
1814 columnname: collection
1816 columnname: callnumber
1818 columnname: copynumber
1829 subscription-detail:
1837 columnname: ordernumber
1839 columnname: creation_date
1841 columnname: receive_date
1845 columnname: order_internalnote
1847 columnname: order_vendornote
1856 batch_patron_modification:
1860 columnname: batch_patron_edit_selections
1861 cannot_be_toggled: 1
1862 cannot_be_modified: 1
1864 columnname: batch_patron_edit_cardnumber
1866 columnname: batch_patron_edit_surname
1868 columnname: batch_patron_edit_firstname
1870 columnname: batch_patron_edit_branchcode
1872 columnname: batch_patron_edit_categorycode
1874 columnname: batch_patron_edit_streetnumber
1876 columnname: batch_patron_edit_address
1878 columnname: batch_patron_edit_address2
1880 columnname: batch_patron_edit_city
1882 columnname: batch_patron_edit_state
1884 columnname: batch_patron_edit_zipcode
1886 columnname: batch_patron_edit_country
1888 columnname: batch_patron_edit_email
1890 columnname: batch_patron_edit_phone
1892 columnname: batch_patron_edit_mobile
1894 columnname: batch_patron_edit_dateenrolled
1896 columnname: batch_patron_edit_dateexpiry
1898 columnname: batch_patron_edit_borrowernotes
1900 columnname: batch_patron_edit_opacnote
1902 columnname: batch_patron_edit_debarred
1904 columnname: batch_patron_edit_debarredcomment
1908 default_display_length: 20
1913 columnname: librarian
1923 columnname: interface
1924 marc-modification-templates:
1931 columnname: template
1934 cannot_be_toggled: 1
1935 cannot_be_modified: 1
1938 default_sort_order: 3
1949 columnname: updated_on
1951 columnname: copy_notice
1954 cannot_be_toggled: 1
1955 cannot_be_modified: 1
1963 columnname: cyclical
1967 columnname: description
1969 columnname: number_of_items
1972 cannot_be_toggled: 1
1973 cannot_be_modified: 1
1975 stock_rotation_manage_items:
1984 columnname: call_number
1986 columnname: in_transit
1991 cannot_be_toggled: 1
1992 cannot_be_modified: 1
1996 default_display_length: 20
1999 columnname: filename
2003 columnname: hashvalue
2008 columnname: category
2012 columnname: temporary
2015 cannot_be_toggled: 1
2016 cannot_be_modified: 1
2024 columnname: description
2029 cannot_be_toggled: 1
2030 cannot_be_modified: 1