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
45 columnname: order_line
47 columnname: order_date
49 columnname: estimated_delivery_date
53 columnname: information
57 columnname: total_cost
61 columnname: basket_group
69 columnname: claims_count
71 columnname: claimed_date
73 columnname: internal_note
75 columnname: vendor_note
81 default_display_length: 20
85 columnname: basket_number
87 columnname: order_information
89 columnname: recommended_retail_price_tax_excluded
91 columnname: actual_cost_tax_excluded
93 columnname: budgeted_cost_price_tax_included
95 columnname: recommended_retail_price_tax_included
98 columnname: actual_cost_tax_included
101 columnname: budgeted_cost_tax_included
103 columnname: replacement_price
107 columnname: total_tax_excluded
109 columnname: total_tax_included
112 columnname: goods_and_services_tax_percentage
114 columnname: goods_and_services_tax
118 columnname: supplier_report
122 cannot_be_modified: 1
126 cannot_be_modified: 1
132 columnname: selections
134 cannot_be_modified: 1
136 columnname: suggestion
138 columnname: suggested_by
140 columnname: suggested_on
142 columnname: managed_by
144 columnname: managed_on
146 columnname: lastmodificationby
148 columnname: lastmodificationdate
150 columnname: last_updated_date
154 columnname: library_fund
156 columnname: suggestion_status
160 cannot_be_modified: 1
168 columnname: city_name
170 columnname: city_state
172 columnname: city_zipcode
174 columnname: city_country
178 cannot_be_modified: 1
185 cannot_be_modified: 1
189 cannot_be_modified: 1
196 columnname: last_updated
208 columnname: category_name
212 columnname: enrollment_period
214 columnname: age_required
216 columnname: upper_age_limit
218 columnname: enrollment_fee
222 columnname: lost_items
226 columnname: messaging
228 columnname: branches_limitations
230 columnname: default_privacy
234 cannot_be_modified: 1
242 columnname: description
246 columnname: parent_code
248 columnname: search_category
250 columnname: not_for_loan
252 columnname: hide_in_opac
254 columnname: rental_charge
256 columnname: daily_rental_charge
258 columnname: hourly_rental_charge
260 columnname: default_replacement_cost
262 columnname: lost_processing_fee
264 columnname: checkin_message
266 columnname: library_limitations
268 columnname: automatic_checkin
273 cannot_be_modified: 1
279 columnname: library_name
281 columnname: library_code
283 columnname: library_address
285 columnname: marc_organization_code
287 columnname: library_ip
289 columnname: is_pickup_location
291 columnname: smtp_server
295 cannot_be_modified: 1
302 columnname: holdings_checkbox
304 cannot_be_modified: 1
306 columnname: holdings_cover_image
308 columnname: holdings_itype
310 columnname: holdings_holdingbranch
312 columnname: holdings_homebranch
314 columnname: holdings_ccode
316 columnname: holdings_itemcallnumber
318 columnname: holdings_status
320 columnname: holdings_lastseen
322 columnname: holdings_dateaccessioned
324 columnname: holdings_datelastborrowed
326 columnname: holdings_barcode
328 columnname: holdings_enumchron
330 columnname: holdings_uri
332 columnname: holdings_copynumber
334 columnname: holdings_stocknumber
336 columnname: holdings_materials
338 columnname: holdings_itemnotes
340 columnname: holdings_itemnotes_nonpublic
342 columnname: holdings_hostrecord
344 columnname: holdings_usedin
346 columnname: holdings_usedin_col
348 columnname: holdings_course_reserves
350 columnname: holdings_spinelabel
352 columnname: holdings_actions
354 cannot_be_modified: 1
359 columnname: otherholdings_checkbox
361 cannot_be_modified: 1
363 columnname: otherholdings_cover_image
365 columnname: otherholdings_itype
367 columnname: otherholdings_holdingbranch
369 columnname: otherholdings_homebranch
371 columnname: otherholdings_ccode
373 columnname: otherholdings_itemcallnumber
375 columnname: otherholdings_status
377 columnname: otherholdings_lastseen
379 columnname: otherholdings_dateaccessioned
381 columnname: otherholdings_barcode
383 columnname: otherholdings_enumchron
385 columnname: otherholdings_uri
387 columnname: otherholdings_copynumber
389 columnname: otherholdings_stocknumber
391 columnname: otherholdings_materials
393 columnname: otherholdings_itemnotes
395 columnname: otherholdings_itemnotes_nonpublic
397 columnname: otherholdings_hostrecord
399 columnname: otherholdings_usedin
401 columnname: otherholdings_usedin_col
403 columnname: otherholdings_course_reserves
405 columnname: otherholdings_spinelabel
407 columnname: otherholdings_actions
409 cannot_be_modified: 1
411 acquisitiondetails-table:
418 columnname: basketgroup
422 columnname: ordernumber
424 columnname: creation_date
426 columnname: received_data
434 columnname: order_internalnote
436 columnname: subscription
438 columnname: subscription_callnumber
440 checkoutshistory-table:
445 cannot_be_modified: 1
449 cannot_be_modified: 1
451 columnname: checked_out_from
455 columnname: checkout_on
459 columnname: checkin_on
464 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
465 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
466 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
472 columnname: dateaccessioned
474 columnname: booksellerid
476 columnname: homebranch
480 columnname: replacementprice
482 columnname: replacementpricedate
484 columnname: datelastborrowed
486 columnname: datelastseen
490 columnname: notforloan
496 columnname: withdrawn
498 columnname: itemcallnumber
500 columnname: coded_location_qualifier
502 columnname: restricted
504 columnname: itemnotes
506 columnname: itemnotes_nonpublic
508 columnname: holdingbranch
510 columnname: timestamp
516 columnname: cn_source
520 columnname: materials
526 columnname: enumchron
528 columnname: copynumber
530 columnname: stocknumber
552 cannot_be_modified: 1
556 course_reserves_table:
561 columnname: department
563 columnname: course_no
569 columnname: instructors
571 columnname: staff_note
573 columnname: public_note
575 columnname: no_of_students
580 course_reserves_table:
589 columnname: call_number
591 columnname: item_type
593 columnname: collection
599 columnname: staff_note
601 columnname: public_note
605 columnname: other_course_reserves
609 cannot_be_modified: 1
616 columnname: illrequest_id
618 columnname: metadata_author
620 columnname: metadata_title
622 columnname: metadata_article_title
624 columnname: metadata_issue
626 columnname: metadata_volume
628 columnname: metadata_year
630 columnname: metadata_pages
632 columnname: metadata_type
638 columnname: biblio_id
640 columnname: library_branchname
646 cannot_be_modified: 1
649 columnname: placed_formatted
653 cannot_be_modified: 1
656 columnname: updated_formatted
660 columnname: completed
662 cannot_be_modified: 1
665 columnname: completed_formatted
667 columnname: accessurl
673 columnname: notesopac
675 columnname: notesstaff
681 cannot_be_modified: 1
690 columnname: credit_number
693 columnname: account_type
695 columnname: description
701 columnname: returndate
703 columnname: issuedate
705 columnname: home_library
707 columnname: checked_out_from
713 cannot_be_modified: 1
715 columnname: amountoutstanding
717 cannot_be_modified: 1
721 cannot_be_modified: 1
729 cannot_be_modified: 1
733 cannot_be_modified: 1
735 columnname: account_type
737 columnname: description
745 columnname: returndate
747 columnname: issuedate
749 columnname: checked_out_from
755 columnname: amountoutstanding
763 cannot_be_modified: 1
765 columnname: cardnumber
769 columnname: dateofbirth
775 columnname: expires_on
777 columnname: od_checkouts
781 columnname: circ_notes
785 cannot_be_modified: 1
791 columnname: sort_order
793 cannot_be_modified: 1
796 columnname: todays_or_previous_checkouts
798 cannot_be_modified: 1
801 columnname: due_date_unformatted
803 cannot_be_modified: 1
810 columnname: record_type
812 columnname: item_type
814 columnname: collection
818 columnname: homebranch
820 columnname: checkout_on_unformatted
822 cannot_be_modified: 1
825 columnname: checkout_on
827 columnname: checkout_from
831 columnname: copynumber
841 cannot_be_modified: 1
845 columnname: claims_returned
849 cannot_be_modified: 1
857 cannot_be_modified: 1
865 columnname: reservedate
867 columnname: expirationdate
869 columnname: waitingdate
871 columnname: cancellationdate
878 checkouthistory-table:
882 cannot_be_modified: 1
890 columnname: call_number
894 columnname: number_of_renewals
896 columnname: checked_out_on
898 columnname: checked_out_from
902 columnname: return_date
910 cannot_be_modified: 1
914 columnname: firstname
924 columnname: expires_on
926 columnname: circ_notes
935 cannot_be_modified: 1
941 columnname: itemlost_on
945 columnname: callnumber
947 columnname: datelastseen
951 columnname: replacementprice
957 columnname: collection_code
959 columnname: current_location
963 columnname: notforloan
969 default_display_length: 20
970 default_sort_order: 0
977 cannot_be_modified: 1
979 columnname: basket_name
981 columnname: basket_by
987 columnname: list_price
991 columnname: budgeted_cost
995 columnname: total_rrp
997 columnname: total_cost
999 columnname: entry_date
1001 columnname: date_received
1003 columnname: internal_note
1005 columnname: vendor_note
1011 columnname: selection
1012 cannot_be_toggled: 1
1013 cannot_be_modified: 1
1015 columnname: report_id
1016 cannot_be_toggled: 1
1017 cannot_be_modified: 1
1019 columnname: report_name
1025 columnname: subgroup
1031 columnname: creation_date
1033 columnname: last_edit
1035 columnname: last_run
1039 columnname: json_url
1041 columnname: cache_expiry
1043 columnname: saved_results
1048 cannot_be_toggled: 1
1049 cannot_be_modified: 1
1056 columnname: sort_order
1057 cannot_be_toggled: 1
1058 cannot_be_modified: 1
1061 columnname: todays_or_previous_checkouts
1062 cannot_be_toggled: 1
1063 cannot_be_modified: 1
1066 columnname: due_date_unformatted
1067 cannot_be_toggled: 1
1068 cannot_be_modified: 1
1071 columnname: due_date
1075 columnname: record_type
1077 columnname: item_type
1079 columnname: collection
1081 columnname: location
1083 columnname: homebranch
1085 columnname: checkout_on_unformatted
1086 cannot_be_toggled: 1
1087 cannot_be_modified: 1
1090 columnname: checkout_on
1092 columnname: checkout_from
1096 columnname: copynumber
1105 cannot_be_toggled: 1
1106 cannot_be_modified: 1
1110 columnname: claims_returned
1113 cannot_be_toggled: 1
1114 cannot_be_modified: 1
1120 cannot_be_toggled: 1
1121 cannot_be_modified: 1
1123 columnname: cardnumber
1125 columnname: date_of_birth
1127 columnname: category
1140 columnname: due_date
1148 columnname: homelibrary
1150 columnname: holdinglibrary
1152 columnname: location
1154 columnname: itemcallnumber
1156 columnname: dateaccessioned
1159 columnname: record_type
1165 columnname: borrower
1167 columnname: itemnote
1175 columnname: collection
1177 columnname: document_type
1179 columnname: callnumber
1181 columnname: copynumber
1183 columnname: enumeration
1199 columnname: pull_items
1201 columnname: avalaible_items
1209 columnname: libraries
1211 columnname: barcodes
1213 columnname: call_numbers
1215 columnname: copy_numbers
1217 columnname: enumeration
1219 columnname: itemtypes
1221 columnname: locations
1223 columnname: hold_date
1225 columnname: reserve_notes
1227 columnname: pickup_location
1239 columnname: holds_ratio
1243 columnname: home_libraries
1245 columnname: holding_libraries
1247 columnname: location
1249 columnname: itemtype
1251 columnname: call_numbers
1253 columnname: items_needed
1255 holds_awaiting_pickup:
1259 columnname: waiting_since
1261 columnname: date_hold_placed
1267 columnname: home_library
1269 columnname: current_location
1271 columnname: shelving_location
1273 columnname: call_number
1275 columnname: copy_number
1277 columnname: enumeration
1284 columnname: waiting_since
1286 columnname: date_hold_placed
1292 columnname: home_library
1294 columnname: current_location
1296 columnname: shelving_location
1298 columnname: call_number
1300 columnname: copy_number
1302 columnname: enumeration
1310 columnname: due_date
1314 columnname: patron_category
1317 columnname: patron_library
1321 columnname: home_library
1324 columnname: holding_library
1327 columnname: shelving_location
1331 columnname: call_number
1333 columnname: item_type
1338 columnname: non-public_note
1345 columnname: item_cover
1347 columnname: item_itemtype
1349 columnname: item_current_location
1351 columnname: item_home_location
1353 columnname: item_shelving_location
1356 columnname: item_ccode
1358 columnname: item_callnumber
1360 columnname: item_materials
1363 columnname: item_enumchron
1365 columnname: item_url
1367 columnname: item_copy
1369 columnname: item_status
1371 columnname: item_notes
1373 columnname: item_datedue
1375 columnname: item_barcode
1378 columnname: item_holds
1380 columnname: item_priority
1382 columnname: item_coursereserves
1384 course_reserves_table:
1387 columnname: coursename
1389 columnname: department
1391 columnname: course_number
1397 columnname: instructor
1404 columnname: serial_serialseq
1406 columnname: serial_publisheddate
1408 columnname: serial_planneddate
1410 columnname: serial_status
1412 columnname: serial_notes
1421 columnname: itemtype
1423 columnname: location
1425 columnname: collection
1427 columnname: callnumber
1429 columnname: copynumber
1440 subscription-detail:
1448 columnname: ordernumber
1450 columnname: creation_date
1452 columnname: receive_date
1456 columnname: order_internalnote
1458 columnname: order_vendornote
1467 batch_patron_modification:
1471 columnname: batch_patron_edit_selections
1472 cannot_be_toggled: 1
1473 cannot_be_modified: 1
1475 columnname: batch_patron_edit_cardnumber
1477 columnname: batch_patron_edit_surname
1479 columnname: batch_patron_edit_firstname
1481 columnname: batch_patron_edit_branchcode
1483 columnname: batch_patron_edit_categorycode
1485 columnname: batch_patron_edit_streetnumber
1487 columnname: batch_patron_edit_address
1489 columnname: batch_patron_edit_address2
1491 columnname: batch_patron_edit_city
1493 columnname: batch_patron_edit_state
1495 columnname: batch_patron_edit_zipcode
1497 columnname: batch_patron_edit_country
1499 columnname: batch_patron_edit_email
1501 columnname: batch_patron_edit_phone
1503 columnname: batch_patron_edit_mobile
1505 columnname: batch_patron_edit_dateenrolled
1507 columnname: batch_patron_edit_dateexpiry
1509 columnname: batch_patron_edit_borrowernotes
1511 columnname: batch_patron_edit_opacnote
1513 columnname: batch_patron_edit_debarred
1515 columnname: batch_patron_edit_debarredcomment
1523 columnname: librarian
1533 columnname: interface
1534 marc-modification-templates:
1541 columnname: template
1544 cannot_be_toggled: 1
1545 cannot_be_modified: 1
1558 columnname: updated_on
1560 columnname: copy_notice
1563 cannot_be_toggled: 1
1564 cannot_be_modified: 1
1572 columnname: cyclical
1576 columnname: description
1578 columnname: number_of_items
1581 cannot_be_toggled: 1
1582 cannot_be_modified: 1
1584 stock_rotation_manage_items:
1593 columnname: call_number
1595 columnname: in_transit
1600 cannot_be_toggled: 1
1601 cannot_be_modified: 1
1607 columnname: filename
1611 columnname: hashvalue
1616 columnname: category
1620 columnname: temporary
1623 cannot_be_toggled: 1
1624 cannot_be_modified: 1
1632 columnname: description
1637 cannot_be_toggled: 1
1638 cannot_be_modified: 1