13 columnname: basket_creator
15 columnname: basket_group
17 columnname: invoice_number
25 columnname: received_on
27 columnname: quantity_received
29 columnname: pending_order
43 columnname: order_line
45 columnname: order_date
47 columnname: estimated_delivery_date
51 columnname: information
55 columnname: total_cost
59 columnname: basket_group
67 columnname: claims_count
69 columnname: claimed_date
71 columnname: internal_note
73 columnname: vendor_note
79 default_display_length: 20
83 columnname: basket_number
85 columnname: order_information
87 columnname: recommended_retail_price_tax_excluded
89 columnname: actual_cost_tax_excluded
91 columnname: budgeted_cost_price_tax_included
93 columnname: recommended_retail_price_tax_included
96 columnname: actual_cost_tax_included
99 columnname: budgeted_cost_tax_included
101 columnname: replacement_price
105 columnname: total_tax_excluded
107 columnname: total_tax_included
110 columnname: goods_and_services_tax_percentage
112 columnname: goods_and_services_tax
116 columnname: supplier_report
120 cannot_be_modified: 1
124 cannot_be_modified: 1
130 columnname: selections
132 cannot_be_modified: 1
134 columnname: suggestion
136 columnname: suggested_by
138 columnname: suggested_on
140 columnname: managed_by
142 columnname: managed_on
144 columnname: lastmodificationby
146 columnname: lastmodificationdate
150 columnname: library_fund
152 columnname: suggestion_status
156 cannot_be_modified: 1
164 columnname: city_name
166 columnname: city_state
168 columnname: city_zipcode
170 columnname: city_country
174 cannot_be_modified: 1
181 cannot_be_modified: 1
185 cannot_be_modified: 1
192 columnname: last_updated
204 columnname: category_name
208 columnname: enrollment_period
210 columnname: age_required
212 columnname: upper_age_limit
214 columnname: enrollment_fee
218 columnname: lost_items
222 columnname: messaging
224 columnname: branches_limitations
226 columnname: default_privacy
230 cannot_be_modified: 1
238 columnname: description
242 columnname: parent_code
244 columnname: search_category
246 columnname: not_for_loan
248 columnname: hide_in_opac
250 columnname: rental_charge
252 columnname: daily_rental_charge
254 columnname: hourly_rental_charge
256 columnname: default_replacement_cost
258 columnname: lost_processing_fee
260 columnname: checkin_message
262 columnname: library_limitations
264 columnname: automatic_checkin
269 cannot_be_modified: 1
275 columnname: library_name
277 columnname: library_code
279 columnname: library_address
281 columnname: marc_organization_code
283 columnname: library_ip
285 columnname: is_pickup_location
287 columnname: smtp_server
291 cannot_be_modified: 1
298 columnname: holdings_checkbox
300 cannot_be_modified: 1
302 columnname: holdings_cover_image
304 columnname: holdings_itype
306 columnname: holdings_holdingbranch
308 columnname: holdings_homebranch
310 columnname: holdings_ccode
312 columnname: holdings_itemcallnumber
314 columnname: holdings_status
316 columnname: holdings_lastseen
318 columnname: holdings_dateaccessioned
320 columnname: holdings_datelastborrowed
322 columnname: holdings_barcode
324 columnname: holdings_enumchron
326 columnname: holdings_uri
328 columnname: holdings_copynumber
330 columnname: holdings_stocknumber
332 columnname: holdings_materials
334 columnname: holdings_itemnotes
336 columnname: holdings_itemnotes_nonpublic
338 columnname: holdings_hostrecord
340 columnname: holdings_usedin
342 columnname: holdings_usedin_col
344 columnname: holdings_course_reserves
346 columnname: holdings_spinelabel
348 columnname: holdings_actions
350 cannot_be_modified: 1
355 columnname: otherholdings_checkbox
357 cannot_be_modified: 1
359 columnname: otherholdings_cover_image
361 columnname: otherholdings_itype
363 columnname: otherholdings_holdingbranch
365 columnname: otherholdings_homebranch
367 columnname: otherholdings_ccode
369 columnname: otherholdings_itemcallnumber
371 columnname: otherholdings_status
373 columnname: otherholdings_lastseen
375 columnname: otherholdings_dateaccessioned
377 columnname: otherholdings_barcode
379 columnname: otherholdings_enumchron
381 columnname: otherholdings_uri
383 columnname: otherholdings_copynumber
385 columnname: otherholdings_stocknumber
387 columnname: otherholdings_materials
389 columnname: otherholdings_itemnotes
391 columnname: otherholdings_itemnotes_nonpublic
393 columnname: otherholdings_hostrecord
395 columnname: otherholdings_usedin
397 columnname: otherholdings_usedin_col
399 columnname: otherholdings_course_reserves
401 columnname: otherholdings_spinelabel
403 columnname: otherholdings_actions
405 cannot_be_modified: 1
407 acquisitiondetails-table:
414 columnname: basketgroup
418 columnname: ordernumber
420 columnname: creation_date
422 columnname: received_data
430 columnname: order_internalnote
432 columnname: subscription
434 columnname: subscription_callnumber
436 checkoutshistory-table:
441 cannot_be_modified: 1
445 cannot_be_modified: 1
447 columnname: checked_out_from
451 columnname: checkout_on
455 columnname: checkin_on
460 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
461 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
462 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
468 columnname: dateaccessioned
470 columnname: booksellerid
472 columnname: homebranch
476 columnname: replacementprice
478 columnname: replacementpricedate
480 columnname: datelastborrowed
482 columnname: datelastseen
486 columnname: notforloan
492 columnname: withdrawn
494 columnname: itemcallnumber
496 columnname: coded_location_qualifier
498 columnname: restricted
500 columnname: itemnotes
502 columnname: itemnotes_nonpublic
504 columnname: holdingbranch
506 columnname: timestamp
512 columnname: cn_source
516 columnname: materials
522 columnname: enumchron
524 columnname: copynumber
526 columnname: stocknumber
548 cannot_be_modified: 1
552 course_reserves_table:
557 columnname: department
559 columnname: course_no
565 columnname: instructors
567 columnname: staff_note
569 columnname: public_note
571 columnname: no_of_students
576 course_reserves_table:
585 columnname: call_number
587 columnname: item_type
589 columnname: collection
595 columnname: staff_note
597 columnname: public_note
601 columnname: other_course_reserves
605 cannot_be_modified: 1
612 columnname: illrequest_id
614 columnname: metadata_author
616 columnname: metadata_title
618 columnname: metadata_article_title
620 columnname: metadata_issue
622 columnname: metadata_volume
624 columnname: metadata_year
626 columnname: metadata_pages
628 columnname: metadata_type
634 columnname: biblio_id
636 columnname: library_branchname
642 cannot_be_modified: 1
645 columnname: placed_formatted
649 cannot_be_modified: 1
652 columnname: updated_formatted
656 columnname: completed
658 cannot_be_modified: 1
661 columnname: completed_formatted
663 columnname: accessurl
669 columnname: notesopac
671 columnname: notesstaff
677 cannot_be_modified: 1
686 columnname: credit_number
689 columnname: account_type
691 columnname: description
697 columnname: returndate
699 columnname: issuedate
701 columnname: home_library
703 columnname: checked_out_from
709 cannot_be_modified: 1
711 columnname: amountoutstanding
713 cannot_be_modified: 1
717 cannot_be_modified: 1
725 cannot_be_modified: 1
729 cannot_be_modified: 1
731 columnname: account_type
733 columnname: description
741 columnname: returndate
743 columnname: issuedate
745 columnname: checked_out_from
751 columnname: amountoutstanding
759 cannot_be_modified: 1
761 columnname: cardnumber
765 columnname: dateofbirth
771 columnname: expires_on
773 columnname: od_checkouts
777 columnname: circ_notes
781 cannot_be_modified: 1
787 columnname: sort_order
789 cannot_be_modified: 1
792 columnname: todays_or_previous_checkouts
794 cannot_be_modified: 1
797 columnname: due_date_unformatted
799 cannot_be_modified: 1
806 columnname: record_type
808 columnname: item_type
810 columnname: collection
814 columnname: homebranch
816 columnname: checkout_on_unformatted
818 cannot_be_modified: 1
821 columnname: checkout_on
823 columnname: checkout_from
827 columnname: copynumber
837 cannot_be_modified: 1
841 columnname: claims_returned
845 cannot_be_modified: 1
853 cannot_be_modified: 1
861 columnname: reservedate
863 columnname: expirationdate
865 columnname: waitingdate
867 columnname: cancellationdate
874 checkouthistory-table:
878 cannot_be_modified: 1
886 columnname: call_number
890 columnname: number_of_renewals
892 columnname: checked_out_on
894 columnname: checked_out_from
898 columnname: return_date
906 cannot_be_modified: 1
910 columnname: firstname
920 columnname: expires_on
922 columnname: circ_notes
931 cannot_be_modified: 1
937 columnname: itemlost_on
941 columnname: callnumber
943 columnname: datelastseen
947 columnname: replacementprice
953 columnname: collection_code
955 columnname: current_location
959 columnname: notforloan
965 default_display_length: 20
966 default_sort_order: 0
973 cannot_be_modified: 1
975 columnname: basket_name
977 columnname: basket_by
983 columnname: list_price
987 columnname: budgeted_cost
991 columnname: total_rrp
993 columnname: total_cost
995 columnname: entry_date
997 columnname: date_received
999 columnname: internal_note
1001 columnname: vendor_note
1007 columnname: selection
1008 cannot_be_toggled: 1
1009 cannot_be_modified: 1
1011 columnname: report_id
1012 cannot_be_toggled: 1
1013 cannot_be_modified: 1
1015 columnname: report_name
1021 columnname: subgroup
1027 columnname: creation_date
1029 columnname: last_edit
1031 columnname: last_run
1035 columnname: json_url
1037 columnname: cache_expiry
1039 columnname: saved_results
1044 cannot_be_toggled: 1
1045 cannot_be_modified: 1
1052 columnname: sort_order
1053 cannot_be_toggled: 1
1054 cannot_be_modified: 1
1057 columnname: todays_or_previous_checkouts
1058 cannot_be_toggled: 1
1059 cannot_be_modified: 1
1062 columnname: due_date_unformatted
1063 cannot_be_toggled: 1
1064 cannot_be_modified: 1
1067 columnname: due_date
1071 columnname: record_type
1073 columnname: item_type
1075 columnname: collection
1077 columnname: location
1079 columnname: homebranch
1081 columnname: checkout_on_unformatted
1082 cannot_be_toggled: 1
1083 cannot_be_modified: 1
1086 columnname: checkout_on
1088 columnname: checkout_from
1092 columnname: copynumber
1101 cannot_be_toggled: 1
1102 cannot_be_modified: 1
1106 columnname: claims_returned
1109 cannot_be_toggled: 1
1110 cannot_be_modified: 1
1116 cannot_be_toggled: 1
1117 cannot_be_modified: 1
1119 columnname: cardnumber
1121 columnname: date_of_birth
1123 columnname: category
1136 columnname: due_date
1144 columnname: homelibrary
1146 columnname: holdinglibrary
1148 columnname: location
1150 columnname: itemcallnumber
1152 columnname: dateaccessioned
1155 columnname: record_type
1161 columnname: borrower
1163 columnname: itemnote
1171 columnname: collection
1173 columnname: document_type
1175 columnname: callnumber
1177 columnname: copynumber
1179 columnname: enumeration
1195 columnname: pull_items
1197 columnname: avalaible_items
1205 columnname: libraries
1207 columnname: barcodes
1209 columnname: call_numbers
1211 columnname: copy_numbers
1213 columnname: enumeration
1215 columnname: itemtypes
1217 columnname: locations
1219 columnname: hold_date
1221 columnname: reserve_notes
1223 columnname: pickup_location
1235 columnname: holds_ratio
1239 columnname: home_libraries
1241 columnname: holding_libraries
1243 columnname: location
1245 columnname: itemtype
1247 columnname: call_numbers
1249 columnname: items_needed
1251 holds_awaiting_pickup:
1255 columnname: waiting_since
1257 columnname: date_hold_placed
1263 columnname: home_library
1265 columnname: current_location
1267 columnname: shelving_location
1269 columnname: call_number
1271 columnname: copy_number
1273 columnname: enumeration
1280 columnname: waiting_since
1282 columnname: date_hold_placed
1288 columnname: home_library
1290 columnname: current_location
1292 columnname: shelving_location
1294 columnname: call_number
1296 columnname: copy_number
1298 columnname: enumeration
1306 columnname: due_date
1310 columnname: patron_category
1313 columnname: patron_library
1317 columnname: home_library
1320 columnname: holding_library
1325 columnname: call_number
1327 columnname: item_type
1332 columnname: non-public_note
1339 columnname: item_cover
1341 columnname: item_itemtype
1343 columnname: item_current_location
1345 columnname: item_home_location
1347 columnname: item_shelving_location
1350 columnname: item_ccode
1352 columnname: item_callnumber
1354 columnname: item_materials
1357 columnname: item_enumchron
1359 columnname: item_url
1361 columnname: item_copy
1363 columnname: item_status
1365 columnname: item_notes
1367 columnname: item_datedue
1369 columnname: item_barcode
1372 columnname: item_holds
1374 columnname: item_priority
1376 columnname: item_coursereserves
1378 course_reserves_table:
1381 columnname: coursename
1383 columnname: department
1385 columnname: course_number
1391 columnname: instructor
1398 columnname: serial_serialseq
1400 columnname: serial_publisheddate
1402 columnname: serial_planneddate
1404 columnname: serial_status
1406 columnname: serial_notes
1415 columnname: itemtype
1417 columnname: location
1419 columnname: collection
1421 columnname: callnumber
1423 columnname: copynumber
1434 subscription-detail:
1442 columnname: ordernumber
1444 columnname: creation_date
1446 columnname: receive_date
1450 columnname: order_internalnote
1452 columnname: order_vendornote
1461 batch_patron_modification:
1465 columnname: batch_patron_edit_selections
1466 cannot_be_toggled: 1
1467 cannot_be_modified: 1
1469 columnname: batch_patron_edit_cardnumber
1471 columnname: batch_patron_edit_surname
1473 columnname: batch_patron_edit_firstname
1475 columnname: batch_patron_edit_branchcode
1477 columnname: batch_patron_edit_categorycode
1479 columnname: batch_patron_edit_streetnumber
1481 columnname: batch_patron_edit_address
1483 columnname: batch_patron_edit_address2
1485 columnname: batch_patron_edit_city
1487 columnname: batch_patron_edit_state
1489 columnname: batch_patron_edit_zipcode
1491 columnname: batch_patron_edit_country
1493 columnname: batch_patron_edit_email
1495 columnname: batch_patron_edit_phone
1497 columnname: batch_patron_edit_mobile
1499 columnname: batch_patron_edit_dateenrolled
1501 columnname: batch_patron_edit_dateexpiry
1503 columnname: batch_patron_edit_borrowernotes
1505 columnname: batch_patron_edit_opacnote
1507 columnname: batch_patron_edit_debarred
1509 columnname: batch_patron_edit_debarredcomment
1517 columnname: librarian
1527 columnname: interface
1540 columnname: updated_on
1542 columnname: copy_notice
1545 cannot_be_toggled: 1
1546 cannot_be_modified: 1
1554 columnname: cyclical
1558 columnname: description
1560 columnname: number_of_items
1563 cannot_be_toggled: 1
1564 cannot_be_modified: 1
1566 stock_rotation_manage_items:
1575 columnname: call_number
1577 columnname: in_transit
1582 cannot_be_toggled: 1
1583 cannot_be_modified: 1
1592 columnname: description
1597 cannot_be_toggled: 1
1598 cannot_be_modified: 1