13 columnname: basket_creator
15 columnname: basket_group
17 columnname: managing_library
19 columnname: invoice_number
27 columnname: received_on
29 columnname: quantity_received
31 columnname: pending_order
37 columnname: internalnote
39 columnname: vendornote
49 columnname: order_line
51 columnname: order_date
53 columnname: estimated_delivery_date
57 columnname: information
61 columnname: total_cost
65 columnname: basket_group
73 columnname: claims_count
75 columnname: claimed_date
77 columnname: internal_note
79 columnname: vendor_note
85 default_display_length: 20
89 columnname: basket_number
91 columnname: order_information
93 columnname: recommended_retail_price_tax_excluded
95 columnname: actual_cost_tax_excluded
97 columnname: budgeted_cost_price_tax_included
99 columnname: recommended_retail_price_tax_included
102 columnname: actual_cost_tax_included
105 columnname: budgeted_cost_tax_included
107 columnname: replacement_price
111 columnname: total_tax_excluded
113 columnname: total_tax_included
116 columnname: goods_and_services_tax_percentage
118 columnname: goods_and_services_tax
122 columnname: supplier_report
126 cannot_be_modified: 1
130 cannot_be_modified: 1
136 columnname: selections
138 cannot_be_modified: 1
140 columnname: suggestion
142 columnname: suggested_by
144 columnname: suggested_on
146 columnname: managed_by
148 columnname: managed_on
150 columnname: lastmodificationby
152 columnname: lastmodificationdate
154 columnname: last_updated_date
158 columnname: library_fund
160 columnname: suggestion_status
164 cannot_be_modified: 1
172 columnname: city_name
174 columnname: city_state
176 columnname: city_zipcode
178 columnname: city_country
182 cannot_be_modified: 1
189 cannot_be_modified: 1
193 cannot_be_modified: 1
200 columnname: last_updated
212 columnname: category_name
216 columnname: enrollment_period
218 columnname: age_required
220 columnname: upper_age_limit
222 columnname: enrollment_fee
226 columnname: lost_items
230 columnname: messaging
232 columnname: branches_limitations
234 columnname: default_privacy
238 cannot_be_modified: 1
246 columnname: description
250 columnname: parent_code
252 columnname: search_category
254 columnname: not_for_loan
256 columnname: hide_in_opac
258 columnname: rental_charge
260 columnname: daily_rental_charge
262 columnname: hourly_rental_charge
264 columnname: default_replacement_cost
266 columnname: lost_processing_fee
268 columnname: checkin_message
270 columnname: library_limitations
272 columnname: automatic_checkin
277 cannot_be_modified: 1
283 columnname: library_name
285 columnname: library_code
287 columnname: library_address
289 columnname: marc_organization_code
291 columnname: library_ip
293 columnname: is_pickup_location
295 columnname: smtp_server
299 cannot_be_modified: 1
306 columnname: holdings_checkbox
308 cannot_be_modified: 1
310 columnname: holdings_cover_image
312 columnname: holdings_itype
314 columnname: holdings_holdingbranch
316 columnname: holdings_homebranch
318 columnname: holdings_ccode
320 columnname: holdings_itemcallnumber
322 columnname: holdings_status
324 columnname: holdings_lastseen
326 columnname: holdings_dateaccessioned
328 columnname: holdings_datelastborrowed
330 columnname: holdings_barcode
332 columnname: holdings_enumchron
334 columnname: holdings_uri
336 columnname: holdings_copynumber
338 columnname: holdings_stocknumber
340 columnname: holdings_materials
342 columnname: holdings_itemnotes
344 columnname: holdings_itemnotes_nonpublic
346 columnname: holdings_hostrecord
348 columnname: holdings_usedin
350 columnname: holdings_usedin_col
352 columnname: holdings_course_reserves
354 columnname: holdings_spinelabel
356 columnname: holdings_actions
358 cannot_be_modified: 1
363 columnname: otherholdings_checkbox
365 cannot_be_modified: 1
367 columnname: otherholdings_cover_image
369 columnname: otherholdings_itype
371 columnname: otherholdings_holdingbranch
373 columnname: otherholdings_homebranch
375 columnname: otherholdings_ccode
377 columnname: otherholdings_itemcallnumber
379 columnname: otherholdings_status
381 columnname: otherholdings_lastseen
383 columnname: otherholdings_dateaccessioned
385 columnname: otherholdings_barcode
387 columnname: otherholdings_enumchron
389 columnname: otherholdings_uri
391 columnname: otherholdings_copynumber
393 columnname: otherholdings_stocknumber
395 columnname: otherholdings_materials
397 columnname: otherholdings_itemnotes
399 columnname: otherholdings_itemnotes_nonpublic
401 columnname: otherholdings_hostrecord
403 columnname: otherholdings_usedin
405 columnname: otherholdings_usedin_col
407 columnname: otherholdings_course_reserves
409 columnname: otherholdings_spinelabel
411 columnname: otherholdings_actions
413 cannot_be_modified: 1
415 acquisitiondetails-table:
422 columnname: basketgroup
426 columnname: ordernumber
428 columnname: creation_date
430 columnname: received_data
438 columnname: order_internalnote
440 columnname: subscription
442 columnname: subscription_callnumber
444 checkoutshistory-table:
449 cannot_be_modified: 1
453 cannot_be_modified: 1
455 columnname: checked_out_from
457 columnname: checked_out_by
461 columnname: checkout_on
465 columnname: checkin_on
470 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
471 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
472 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
478 columnname: dateaccessioned
480 columnname: booksellerid
482 columnname: homebranch
486 columnname: replacementprice
488 columnname: replacementpricedate
490 columnname: datelastborrowed
492 columnname: datelastseen
496 columnname: notforloan
502 columnname: withdrawn
504 columnname: itemcallnumber
506 columnname: coded_location_qualifier
508 columnname: restricted
510 columnname: itemnotes
512 columnname: itemnotes_nonpublic
514 columnname: holdingbranch
516 columnname: timestamp
522 columnname: cn_source
526 columnname: materials
532 columnname: enumchron
534 columnname: copynumber
536 columnname: stocknumber
558 cannot_be_modified: 1
562 course_reserves_table:
567 columnname: department
569 columnname: course_no
575 columnname: instructors
577 columnname: staff_note
579 columnname: public_note
581 columnname: no_of_students
586 course_reserves_table:
595 columnname: call_number
597 columnname: item_type
599 columnname: collection
605 columnname: staff_note
607 columnname: public_note
611 columnname: other_course_reserves
615 cannot_be_modified: 1
622 columnname: illrequest_id
624 columnname: metadata_author
626 columnname: metadata_title
628 columnname: metadata_article_title
630 columnname: metadata_issue
632 columnname: metadata_volume
634 columnname: metadata_year
636 columnname: metadata_pages
638 columnname: metadata_type
644 columnname: biblio_id
646 columnname: library_branchname
652 cannot_be_modified: 1
655 columnname: placed_formatted
659 cannot_be_modified: 1
662 columnname: updated_formatted
666 columnname: completed
668 cannot_be_modified: 1
671 columnname: completed_formatted
673 columnname: accessurl
679 columnname: notesopac
681 columnname: notesstaff
687 cannot_be_modified: 1
696 columnname: timestamp
698 columnname: credit_number
701 columnname: account_type
703 columnname: description
709 columnname: returndate
711 columnname: issuedate
713 columnname: home_library
715 columnname: checked_out_from
721 cannot_be_modified: 1
723 columnname: amountoutstanding
725 cannot_be_modified: 1
729 cannot_be_modified: 1
737 cannot_be_modified: 1
741 cannot_be_modified: 1
743 columnname: account_type
745 columnname: description
753 columnname: returndate
755 columnname: issuedate
757 columnname: checked_out_from
763 columnname: amountoutstanding
771 cannot_be_modified: 1
773 columnname: cardnumber
777 columnname: dateofbirth
783 columnname: expires_on
785 columnname: od_checkouts
789 columnname: circ_notes
793 cannot_be_modified: 1
799 columnname: sort_order
801 cannot_be_modified: 1
804 columnname: todays_or_previous_checkouts
806 cannot_be_modified: 1
809 columnname: due_date_unformatted
811 cannot_be_modified: 1
818 columnname: record_type
820 columnname: item_type
822 columnname: collection
826 columnname: homebranch
828 columnname: checkout_on_unformatted
830 cannot_be_modified: 1
833 columnname: checkout_on
835 columnname: checkout_from
839 columnname: copynumber
849 cannot_be_modified: 1
853 columnname: claims_returned
857 cannot_be_modified: 1
865 cannot_be_modified: 1
873 columnname: reservedate
875 columnname: expirationdate
877 columnname: waitingdate
879 columnname: cancellationdate
886 checkouthistory-table:
890 cannot_be_modified: 1
898 columnname: call_number
902 columnname: number_of_renewals
904 columnname: checked_out_on
906 columnname: checked_out_from
910 columnname: return_date
918 cannot_be_modified: 1
922 columnname: firstname
932 columnname: expires_on
934 columnname: circ_notes
943 cannot_be_modified: 1
949 columnname: itemlost_on
953 columnname: callnumber
955 columnname: datelastseen
959 columnname: replacementprice
965 columnname: collection_code
967 columnname: current_location
971 columnname: notforloan
977 default_display_length: 20
978 default_sort_order: 0
985 cannot_be_modified: 1
987 columnname: basket_name
989 columnname: basket_by
995 columnname: list_price
999 columnname: budgeted_cost
1001 columnname: quantity
1003 columnname: total_rrp
1005 columnname: total_cost
1007 columnname: entry_date
1009 columnname: date_received
1011 columnname: internal_note
1013 columnname: vendor_note
1019 columnname: selection
1020 cannot_be_toggled: 1
1021 cannot_be_modified: 1
1023 columnname: report_id
1024 cannot_be_toggled: 1
1025 cannot_be_modified: 1
1027 columnname: report_name
1033 columnname: subgroup
1039 columnname: creation_date
1041 columnname: last_edit
1043 columnname: last_run
1047 columnname: json_url
1049 columnname: cache_expiry
1051 columnname: saved_results
1056 cannot_be_toggled: 1
1057 cannot_be_modified: 1
1064 columnname: sort_order
1065 cannot_be_toggled: 1
1066 cannot_be_modified: 1
1069 columnname: todays_or_previous_checkouts
1070 cannot_be_toggled: 1
1071 cannot_be_modified: 1
1074 columnname: due_date_unformatted
1075 cannot_be_toggled: 1
1076 cannot_be_modified: 1
1079 columnname: due_date
1083 columnname: record_type
1085 columnname: item_type
1087 columnname: collection
1089 columnname: location
1091 columnname: homebranch
1093 columnname: checkout_on_unformatted
1094 cannot_be_toggled: 1
1095 cannot_be_modified: 1
1098 columnname: checkout_on
1100 columnname: checkout_from
1104 columnname: copynumber
1113 cannot_be_toggled: 1
1114 cannot_be_modified: 1
1118 columnname: claims_returned
1121 cannot_be_toggled: 1
1122 cannot_be_modified: 1
1128 cannot_be_toggled: 1
1129 cannot_be_modified: 1
1131 columnname: cardnumber
1133 columnname: date_of_birth
1135 columnname: category
1148 columnname: due_date
1156 columnname: homelibrary
1158 columnname: transferlibrary
1160 columnname: location
1162 columnname: itemcallnumber
1164 columnname: dateaccessioned
1167 columnname: record_type
1173 columnname: borrower
1175 columnname: itemnote
1183 columnname: collection
1185 columnname: document_type
1187 columnname: callnumber
1189 columnname: copynumber
1191 columnname: enumeration
1207 columnname: pull_items
1209 columnname: avalaible_items
1217 columnname: libraries
1219 columnname: barcodes
1221 columnname: call_numbers
1223 columnname: copy_numbers
1225 columnname: enumeration
1227 columnname: itemtypes
1229 columnname: locations
1231 columnname: hold_date
1233 columnname: reserve_notes
1235 columnname: pickup_location
1247 columnname: holds_ratio
1251 columnname: home_libraries
1253 columnname: holding_libraries
1255 columnname: location
1257 columnname: itemtype
1259 columnname: call_numbers
1261 columnname: items_needed
1263 holds_awaiting_pickup:
1267 columnname: waiting_since
1269 columnname: date_hold_placed
1275 columnname: home_library
1277 columnname: current_location
1279 columnname: shelving_location
1281 columnname: call_number
1283 columnname: copy_number
1285 columnname: enumeration
1292 columnname: waiting_since
1294 columnname: date_hold_placed
1300 columnname: home_library
1302 columnname: current_location
1304 columnname: shelving_location
1306 columnname: call_number
1308 columnname: copy_number
1310 columnname: enumeration
1318 columnname: due_date
1322 columnname: patron_category
1325 columnname: patron_library
1329 columnname: home_library
1332 columnname: holding_library
1335 columnname: shelving_location
1339 columnname: call_number
1341 columnname: item_type
1346 columnname: non-public_note
1349 print-summary-checkouts:
1356 columnname: call_number
1358 columnname: item_type
1360 columnname: date_due
1364 columnname: inventory_number
1372 print-summary-holds:
1379 columnname: placed_on
1381 columnname: expires_on
1383 columnname: pick up_location
1385 print-summary-fines:
1390 columnname: description_of_charges
1396 columnname: outstanding
1403 columnname: item_cover
1405 columnname: item_itemtype
1407 columnname: item_current_location
1409 columnname: item_home_location
1411 columnname: item_shelving_location
1414 columnname: item_ccode
1416 columnname: item_callnumber
1418 columnname: item_materials
1421 columnname: item_enumchron
1423 columnname: item_url
1425 columnname: item_copy
1427 columnname: item_status
1429 columnname: item_notes
1431 columnname: item_datedue
1433 columnname: item_barcode
1436 columnname: item_holds
1438 columnname: item_priority
1440 columnname: item_coursereserves
1442 course_reserves_table:
1445 columnname: coursename
1447 columnname: department
1449 columnname: course_number
1455 columnname: instructor
1462 columnname: serial_serialseq
1464 columnname: serial_publisheddate
1466 columnname: serial_planneddate
1468 columnname: serial_status
1470 columnname: serial_notes
1479 columnname: itemtype
1481 columnname: location
1483 columnname: collection
1485 columnname: callnumber
1487 columnname: copynumber
1498 subscription-detail:
1506 columnname: ordernumber
1508 columnname: creation_date
1510 columnname: receive_date
1514 columnname: order_internalnote
1516 columnname: order_vendornote
1525 batch_patron_modification:
1529 columnname: batch_patron_edit_selections
1530 cannot_be_toggled: 1
1531 cannot_be_modified: 1
1533 columnname: batch_patron_edit_cardnumber
1535 columnname: batch_patron_edit_surname
1537 columnname: batch_patron_edit_firstname
1539 columnname: batch_patron_edit_branchcode
1541 columnname: batch_patron_edit_categorycode
1543 columnname: batch_patron_edit_streetnumber
1545 columnname: batch_patron_edit_address
1547 columnname: batch_patron_edit_address2
1549 columnname: batch_patron_edit_city
1551 columnname: batch_patron_edit_state
1553 columnname: batch_patron_edit_zipcode
1555 columnname: batch_patron_edit_country
1557 columnname: batch_patron_edit_email
1559 columnname: batch_patron_edit_phone
1561 columnname: batch_patron_edit_mobile
1563 columnname: batch_patron_edit_dateenrolled
1565 columnname: batch_patron_edit_dateexpiry
1567 columnname: batch_patron_edit_borrowernotes
1569 columnname: batch_patron_edit_opacnote
1571 columnname: batch_patron_edit_debarred
1573 columnname: batch_patron_edit_debarredcomment
1581 columnname: librarian
1591 columnname: interface
1592 marc-modification-templates:
1599 columnname: template
1602 cannot_be_toggled: 1
1603 cannot_be_modified: 1
1616 columnname: updated_on
1618 columnname: copy_notice
1621 cannot_be_toggled: 1
1622 cannot_be_modified: 1
1630 columnname: cyclical
1634 columnname: description
1636 columnname: number_of_items
1639 cannot_be_toggled: 1
1640 cannot_be_modified: 1
1642 stock_rotation_manage_items:
1651 columnname: call_number
1653 columnname: in_transit
1658 cannot_be_toggled: 1
1659 cannot_be_modified: 1
1665 columnname: filename
1669 columnname: hashvalue
1674 columnname: category
1678 columnname: temporary
1681 cannot_be_toggled: 1
1682 cannot_be_modified: 1
1690 columnname: description
1695 cannot_be_toggled: 1
1696 cannot_be_modified: 1