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
240 columnname: description
242 columnname: search_category
244 columnname: not_for_loan
246 columnname: hide_in_opac
248 columnname: rental_charge
250 columnname: daily_rental_charge
252 columnname: hourly_rental_charge
254 columnname: default_replacement_cost
256 columnname: lost_processing_fee
258 columnname: checkin_message
260 columnname: library_limitations
264 cannot_be_modified: 1
270 columnname: library_name
272 columnname: library_code
274 columnname: library_address
276 columnname: marc_organization_code
278 columnname: library_ip
280 columnname: is_pickup_location
282 columnname: smtp_server
286 cannot_be_modified: 1
293 columnname: holdings_checkbox
295 cannot_be_modified: 1
297 columnname: holdings_cover_image
299 columnname: holdings_itype
301 columnname: holdings_holdingbranch
303 columnname: holdings_homebranch
305 columnname: holdings_ccode
307 columnname: holdings_itemcallnumber
309 columnname: holdings_status
311 columnname: holdings_lastseen
313 columnname: holdings_dateaccessioned
315 columnname: holdings_datelastborrowed
317 columnname: holdings_barcode
319 columnname: holdings_enumchron
321 columnname: holdings_uri
323 columnname: holdings_copynumber
325 columnname: holdings_stocknumber
327 columnname: holdings_materials
329 columnname: holdings_itemnotes
331 columnname: holdings_itemnotes_nonpublic
333 columnname: holdings_hostrecord
335 columnname: holdings_usedin
337 columnname: holdings_usedin_col
339 columnname: holdings_course_reserves
341 columnname: holdings_spinelabel
343 columnname: holdings_actions
345 cannot_be_modified: 1
350 columnname: otherholdings_checkbox
352 cannot_be_modified: 1
354 columnname: otherholdings_cover_image
356 columnname: otherholdings_itype
358 columnname: otherholdings_holdingbranch
360 columnname: otherholdings_homebranch
362 columnname: otherholdings_ccode
364 columnname: otherholdings_itemcallnumber
366 columnname: otherholdings_status
368 columnname: otherholdings_lastseen
370 columnname: otherholdings_dateaccessioned
372 columnname: otherholdings_barcode
374 columnname: otherholdings_enumchron
376 columnname: otherholdings_uri
378 columnname: otherholdings_copynumber
380 columnname: otherholdings_stocknumber
382 columnname: otherholdings_materials
384 columnname: otherholdings_itemnotes
386 columnname: otherholdings_itemnotes_nonpublic
388 columnname: otherholdings_hostrecord
390 columnname: otherholdings_usedin
392 columnname: otherholdings_usedin_col
394 columnname: otherholdings_course_reserves
396 columnname: otherholdings_spinelabel
398 columnname: otherholdings_actions
400 cannot_be_modified: 1
402 acquisitiondetails-table:
409 columnname: basketgroup
413 columnname: ordernumber
415 columnname: creation_date
417 columnname: received_data
425 columnname: order_internalnote
427 columnname: subscription
429 columnname: subscription_callnumber
431 checkoutshistory-table:
436 cannot_be_modified: 1
440 cannot_be_modified: 1
442 columnname: checked_out_from
446 columnname: checkout_on
450 columnname: checkin_on
455 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
456 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
457 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
463 columnname: dateaccessioned
465 columnname: booksellerid
467 columnname: homebranch
471 columnname: replacementprice
473 columnname: replacementpricedate
475 columnname: datelastborrowed
477 columnname: datelastseen
481 columnname: notforloan
487 columnname: withdrawn
489 columnname: itemcallnumber
491 columnname: coded_location_qualifier
493 columnname: restricted
495 columnname: itemnotes
497 columnname: itemnotes_nonpublic
499 columnname: holdingbranch
501 columnname: timestamp
507 columnname: cn_source
511 columnname: materials
517 columnname: enumchron
519 columnname: copynumber
521 columnname: stocknumber
543 cannot_be_modified: 1
547 course_reserves_table:
552 columnname: department
554 columnname: course_no
560 columnname: instructors
562 columnname: staff_note
564 columnname: public_note
566 columnname: no_of_students
571 course_reserves_table:
580 columnname: call_number
582 columnname: item_type
584 columnname: collection
590 columnname: staff_note
592 columnname: public_note
596 columnname: other_course_reserves
600 cannot_be_modified: 1
607 columnname: illrequest_id
609 columnname: metadata_author
611 columnname: metadata_title
613 columnname: metadata_article_title
615 columnname: metadata_issue
617 columnname: metadata_volume
619 columnname: metadata_year
621 columnname: metadata_pages
623 columnname: metadata_type
629 columnname: biblio_id
631 columnname: library_branchname
637 cannot_be_modified: 1
640 columnname: placed_formatted
644 cannot_be_modified: 1
647 columnname: updated_formatted
651 columnname: completed
653 cannot_be_modified: 1
656 columnname: completed_formatted
658 columnname: accessurl
664 columnname: notesopac
666 columnname: notesstaff
672 cannot_be_modified: 1
681 columnname: credit_number
684 columnname: account_type
686 columnname: description
692 columnname: returndate
694 columnname: issuedate
696 columnname: home_library
698 columnname: checked_out_from
704 cannot_be_modified: 1
706 columnname: amountoutstanding
708 cannot_be_modified: 1
712 cannot_be_modified: 1
720 cannot_be_modified: 1
724 cannot_be_modified: 1
726 columnname: account_type
728 columnname: description
736 columnname: returndate
738 columnname: issuedate
740 columnname: checked_out_from
746 columnname: amountoutstanding
754 cannot_be_modified: 1
756 columnname: cardnumber
760 columnname: dateofbirth
766 columnname: expires_on
768 columnname: od_checkouts
772 columnname: circ_notes
776 cannot_be_modified: 1
782 columnname: sort_order
784 cannot_be_modified: 1
787 columnname: todays_or_previous_checkouts
789 cannot_be_modified: 1
792 columnname: due_date_unformatted
794 cannot_be_modified: 1
801 columnname: record_type
803 columnname: item_type
805 columnname: collection
809 columnname: homebranch
811 columnname: checkout_on_unformatted
813 cannot_be_modified: 1
816 columnname: checkout_on
818 columnname: checkout_from
822 columnname: copynumber
832 cannot_be_modified: 1
836 columnname: claims_returned
840 cannot_be_modified: 1
848 cannot_be_modified: 1
856 columnname: reservedate
858 columnname: expirationdate
860 columnname: waitingdate
862 columnname: cancellationdate
869 checkouthistory-table:
873 cannot_be_modified: 1
881 columnname: call_number
885 columnname: number_of_renewals
887 columnname: checked_out_on
889 columnname: checked_out_from
893 columnname: return_date
901 cannot_be_modified: 1
905 columnname: firstname
915 columnname: expires_on
917 columnname: circ_notes
926 cannot_be_modified: 1
932 columnname: itemlost_on
936 columnname: callnumber
938 columnname: datelastseen
942 columnname: replacementprice
948 columnname: collection_code
950 columnname: current_location
954 columnname: notforloan
960 default_display_length: 20
961 default_sort_order: 0
968 cannot_be_modified: 1
970 columnname: basket_name
972 columnname: basket_by
978 columnname: list_price
982 columnname: budgeted_cost
986 columnname: total_rrp
988 columnname: total_cost
990 columnname: entry_date
992 columnname: date_received
994 columnname: internal_note
996 columnname: vendor_note
1002 columnname: selection
1003 cannot_be_toggled: 1
1004 cannot_be_modified: 1
1006 columnname: report_id
1007 cannot_be_toggled: 1
1008 cannot_be_modified: 1
1010 columnname: report_name
1016 columnname: subgroup
1022 columnname: creation_date
1024 columnname: last_edit
1026 columnname: last_run
1030 columnname: json_url
1032 columnname: cache_expiry
1034 columnname: saved_results
1039 cannot_be_toggled: 1
1040 cannot_be_modified: 1
1047 columnname: sort_order
1048 cannot_be_toggled: 1
1049 cannot_be_modified: 1
1052 columnname: todays_or_previous_checkouts
1053 cannot_be_toggled: 1
1054 cannot_be_modified: 1
1057 columnname: due_date_unformatted
1058 cannot_be_toggled: 1
1059 cannot_be_modified: 1
1062 columnname: due_date
1066 columnname: record_type
1068 columnname: item_type
1070 columnname: collection
1072 columnname: location
1074 columnname: homebranch
1076 columnname: checkout_on_unformatted
1077 cannot_be_toggled: 1
1078 cannot_be_modified: 1
1081 columnname: checkout_on
1083 columnname: checkout_from
1087 columnname: copynumber
1096 cannot_be_toggled: 1
1097 cannot_be_modified: 1
1101 columnname: claims_returned
1104 cannot_be_toggled: 1
1105 cannot_be_modified: 1
1111 cannot_be_toggled: 1
1112 cannot_be_modified: 1
1114 columnname: cardnumber
1116 columnname: date_of_birth
1118 columnname: category
1131 columnname: due_date
1139 columnname: homelibrary
1141 columnname: holdinglibrary
1143 columnname: location
1145 columnname: itemcallnumber
1147 columnname: dateaccessioned
1150 columnname: record_type
1156 columnname: borrower
1158 columnname: itemnote
1166 columnname: collection
1168 columnname: document_type
1170 columnname: callnumber
1172 columnname: copynumber
1174 columnname: enumeration
1190 columnname: pull_items
1192 columnname: avalaible_items
1200 columnname: libraries
1202 columnname: barcodes
1204 columnname: call_numbers
1206 columnname: copy_numbers
1208 columnname: enumeration
1210 columnname: itemtypes
1212 columnname: locations
1214 columnname: hold_date
1216 columnname: reserve_notes
1228 columnname: holds_ratio
1232 columnname: home_libraries
1234 columnname: holding_libraries
1236 columnname: location
1238 columnname: itemtype
1240 columnname: call_numbers
1242 columnname: items_needed
1244 holds_awaiting_pickup:
1248 columnname: waiting_since
1250 columnname: date_hold_placed
1256 columnname: home_library
1258 columnname: current_location
1260 columnname: shelving_location
1262 columnname: call_number
1264 columnname: copy_number
1266 columnname: enumeration
1273 columnname: waiting_since
1275 columnname: date_hold_placed
1281 columnname: home_library
1283 columnname: current_location
1285 columnname: shelving_location
1287 columnname: call_number
1289 columnname: copy_number
1291 columnname: enumeration
1299 columnname: due_date
1303 columnname: patron_category
1306 columnname: patron_library
1310 columnname: home_library
1313 columnname: holding_library
1318 columnname: call_number
1320 columnname: item_type
1325 columnname: non-public_note
1332 columnname: item_cover
1334 columnname: item_itemtype
1336 columnname: item_current_location
1338 columnname: item_home_location
1340 columnname: item_shelving_location
1343 columnname: item_ccode
1345 columnname: item_callnumber
1347 columnname: item_materials
1350 columnname: item_enumchron
1352 columnname: item_url
1354 columnname: item_copy
1356 columnname: item_status
1358 columnname: item_notes
1360 columnname: item_datedue
1362 columnname: item_barcode
1365 columnname: item_holds
1367 columnname: item_priority
1369 columnname: item_coursereserves
1371 course_reserves_table:
1374 columnname: coursename
1376 columnname: department
1378 columnname: course_number
1384 columnname: instructor
1391 columnname: serial_serialseq
1393 columnname: serial_publisheddate
1395 columnname: serial_planneddate
1397 columnname: serial_status
1399 columnname: serial_notes
1408 columnname: itemtype
1410 columnname: location
1412 columnname: collection
1414 columnname: callnumber
1416 columnname: copynumber
1427 subscription-detail:
1435 columnname: ordernumber
1437 columnname: creation_date
1439 columnname: receive_date
1443 columnname: order_internalnote
1445 columnname: order_vendornote
1454 batch_patron_modification:
1458 columnname: batch_patron_edit_selections
1459 cannot_be_toggled: 1
1460 cannot_be_modified: 1
1462 columnname: batch_patron_edit_cardnumber
1464 columnname: batch_patron_edit_surname
1466 columnname: batch_patron_edit_firstname
1468 columnname: batch_patron_edit_branchcode
1470 columnname: batch_patron_edit_categorycode
1472 columnname: batch_patron_edit_streetnumber
1474 columnname: batch_patron_edit_address
1476 columnname: batch_patron_edit_address2
1478 columnname: batch_patron_edit_city
1480 columnname: batch_patron_edit_state
1482 columnname: batch_patron_edit_zipcode
1484 columnname: batch_patron_edit_country
1486 columnname: batch_patron_edit_email
1488 columnname: batch_patron_edit_phone
1490 columnname: batch_patron_edit_mobile
1492 columnname: batch_patron_edit_dateenrolled
1494 columnname: batch_patron_edit_dateexpiry
1496 columnname: batch_patron_edit_borrowernotes
1498 columnname: batch_patron_edit_opacnote
1500 columnname: batch_patron_edit_debarred
1502 columnname: batch_patron_edit_debarredcomment
1510 columnname: librarian
1520 columnname: interface
1533 columnname: updated_on
1535 columnname: copy_notice
1538 cannot_be_toggled: 1
1539 cannot_be_modified: 1
1547 columnname: cyclical
1551 columnname: description
1553 columnname: number_of_items
1556 cannot_be_toggled: 1
1557 cannot_be_modified: 1
1559 stock_rotation_manage_items:
1568 columnname: call_number
1570 columnname: in_transit
1575 cannot_be_toggled: 1
1576 cannot_be_modified: 1
1585 columnname: description
1590 cannot_be_toggled: 1
1591 cannot_be_modified: 1