12 columnname: basket_creator
14 columnname: basket_group
16 columnname: invoice_number
24 columnname: received_on
26 columnname: quantity_received
28 columnname: pending_order
41 columnname: order_line
43 columnname: order_date
45 columnname: estimated_delivery_date
49 columnname: information
53 columnname: total_cost
57 columnname: basket_group
63 columnname: claims_count
65 columnname: claimed_date
67 columnname: internal_note
69 columnname: vendor_note
76 columnname: basket_number
78 columnname: order_information
80 columnname: recommended_retail_price_tax_excluded
82 columnname: ecost_tax_excluded
84 columnname: recommended_retail_price_tax_included
87 columnname: ecost_tax_included
90 columnname: replacement_price
94 columnname: total_tax_excluded
96 columnname: total_tax_included
99 columnname: goods_and_services_tax_percentage
101 columnname: goods_and_services_tax
105 columnname: supplier_report
109 cannot_be_modified: 1
113 cannot_be_modified: 1
118 columnname: selections
120 cannot_be_modified: 1
122 columnname: suggestion
124 columnname: suggested_by
126 columnname: suggested_on
128 columnname: managed_by
130 columnname: managed_on
132 columnname: lastmodificationby
134 columnname: lastmodificationdate
138 columnname: library_fund
140 columnname: suggestion_status
144 cannot_be_modified: 1
152 cannot_be_modified: 1
156 cannot_be_modified: 1
163 columnname: last_updated
174 columnname: category_name
178 columnname: enrollment_period
180 columnname: age_required
182 columnname: upper_age_limit
184 columnname: enrollment_fee
188 columnname: lost_items
192 columnname: messaging
194 columnname: branches_limitations
196 columnname: default_privacy
200 cannot_be_modified: 1
209 columnname: description
211 columnname: search_category
213 columnname: not_for_loan
215 columnname: hide_in_opac
217 columnname: rental_charge
219 columnname: daily_rental_charge
221 columnname: hourly_rental_charge
223 columnname: default_replacement_cost
225 columnname: lost_processing_fee
227 columnname: checkin_message
229 columnname: library_limitations
233 cannot_be_modified: 1
238 columnname: library_name
240 columnname: library_code
242 columnname: library_address
244 columnname: marc_organization_code
246 columnname: library_ip
248 columnname: is_pickup_location
252 cannot_be_modified: 1
258 columnname: holdings_checkbox
260 cannot_be_modified: 1
262 columnname: holdings_itype
264 columnname: holdings_holdingbranch
266 columnname: holdings_homebranch
268 columnname: holdings_ccode
270 columnname: holdings_itemcallnumber
272 columnname: holdings_status
274 columnname: holdings_lastseen
276 columnname: holdings_dateaccessioned
278 columnname: holdings_barcode
280 columnname: holdings_enumchron
282 columnname: holdings_uri
284 columnname: holdings_copynumber
286 columnname: holdings_stocknumber
288 columnname: holdings_materials
290 columnname: holdings_itemnotes
292 columnname: holdings_itemnotes_nonpublic
294 columnname: holdings_hostrecord
296 columnname: holdings_usedin
298 columnname: holdings_usedin_col
300 columnname: holdings_course_reserves
302 columnname: holdings_spinelabel
304 columnname: holdings_actions
306 cannot_be_modified: 1
310 columnname: otherholdings_checkbox
312 cannot_be_modified: 1
314 columnname: otherholdings_itype
316 columnname: otherholdings_holdingbranch
318 columnname: otherholdings_homebranch
320 columnname: otherholdings_ccode
322 columnname: otherholdings_itemcallnumber
324 columnname: otherholdings_status
326 columnname: otherholdings_lastseen
328 columnname: otherholdings_dateaccessioned
330 columnname: otherholdings_barcode
332 columnname: otherholdings_enumchron
334 columnname: otherholdings_uri
336 columnname: otherholdings_copynumber
338 columnname: otherholdings_stocknumber
340 columnname: otherholdings_materials
342 columnname: otherholdings_itemnotes
344 columnname: otherholdings_itemnotes_nonpublic
346 columnname: otherholdings_hostrecord
348 columnname: otherholdings_usedin
350 columnname: otherholdings_usedin_col
352 columnname: otherholdings_course_reserves
354 columnname: otherholdings_spinelabel
356 columnname: otherholdings_actions
358 cannot_be_modified: 1
360 acquisitiondetails-table:
366 columnname: basketgroup
370 columnname: ordernumber
372 columnname: creation_date
374 columnname: received_data
380 columnname: order_internalnote
382 columnname: subscription
384 columnname: subscription_callnumber
386 checkoutshistory-table:
390 cannot_be_modified: 1
394 cannot_be_modified: 1
396 columnname: checked_out_from
400 columnname: checkout_on
404 columnname: checkin_on
409 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
410 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
411 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
416 columnname: dateaccessioned
418 columnname: booksellerid
420 columnname: homebranch
424 columnname: replacementprice
426 columnname: replacementpricedate
428 columnname: datelastborrowed
430 columnname: datelastseen
434 columnname: notforloan
440 columnname: withdrawn
442 columnname: itemcallnumber
444 columnname: coded_location_qualifier
446 columnname: restricted
448 columnname: itemnotes
450 columnname: itemnotes_nonpublic
452 columnname: holdingbranch
454 columnname: timestamp
460 columnname: cn_source
464 columnname: materials
470 columnname: enumchron
472 columnname: copynumber
474 columnname: stocknumber
495 cannot_be_modified: 1
499 course_reserves_table:
503 columnname: department
505 columnname: course_no
511 columnname: instructors
513 columnname: staff_note
515 columnname: public_note
517 columnname: no_of_students
522 course_reserves_table:
530 columnname: call_number
532 columnname: item_type
534 columnname: collection
540 columnname: staff_note
542 columnname: public_note
546 columnname: other_course_reserves
550 cannot_be_modified: 1
556 columnname: illrequest_id
558 columnname: metadata_author
560 columnname: metadata_title
562 columnname: metadata_article_title
564 columnname: metadata_issue
566 columnname: metadata_volume
568 columnname: metadata_year
570 columnname: metadata_pages
572 columnname: metadata_type
578 columnname: biblio_id
580 columnname: library_branchname
586 cannot_be_modified: 1
589 columnname: placed_formatted
593 cannot_be_modified: 1
596 columnname: updated_formatted
600 columnname: completed
602 cannot_be_modified: 1
605 columnname: completed_formatted
607 columnname: accessurl
613 columnname: notesopac
615 columnname: notesstaff
621 cannot_be_modified: 1
629 columnname: account_type
631 columnname: description
637 columnname: returndate
639 columnname: issuedate
645 cannot_be_modified: 1
647 columnname: amountoutstanding
649 cannot_be_modified: 1
653 cannot_be_modified: 1
660 cannot_be_modified: 1
664 cannot_be_modified: 1
666 columnname: account_type
668 columnname: description
676 columnname: returndate
678 columnname: issuedate
684 columnname: amountoutstanding
691 cannot_be_modified: 1
693 columnname: cardnumber
697 columnname: dateofbirth
703 columnname: expires_on
705 columnname: od_checkouts
709 columnname: circ_notes
713 cannot_be_modified: 1
718 columnname: sort_order
720 cannot_be_modified: 1
723 columnname: todays_or_previous_checkouts
725 cannot_be_modified: 1
728 columnname: due_date_unformatted
730 cannot_be_modified: 1
737 columnname: record_type
739 columnname: item_type
741 columnname: collection
745 columnname: homebranch
747 columnname: checkout_on_unformatted
749 cannot_be_modified: 1
752 columnname: checkout_on
754 columnname: checkout_from
766 cannot_be_modified: 1
770 columnname: claims_returned
774 cannot_be_modified: 1
781 cannot_be_modified: 1
789 columnname: reservedate
791 columnname: expirationdate
793 columnname: waitingdate
795 columnname: cancellationdate
802 checkouthistory-table:
805 cannot_be_modified: 1
813 columnname: call_number
817 columnname: number_of_renewals
819 columnname: checked_out_on
821 columnname: checked_out_from
825 columnname: return_date
832 cannot_be_modified: 1
836 columnname: firstname
846 columnname: expires_on
848 columnname: circ_notes
856 cannot_be_modified: 1
862 columnname: itemlost_on
866 columnname: callnumber
868 columnname: datelastseen
872 columnname: replacementprice
878 columnname: collection_code
880 columnname: current_location
884 columnname: notforloan
891 columnname: selection
893 cannot_be_modified: 1
895 columnname: report_id
897 cannot_be_modified: 1
899 columnname: report_name
911 columnname: creation_date
913 columnname: last_edit
921 columnname: cache_expiry
923 columnname: saved_results
929 cannot_be_modified: 1
935 columnname: sort_order
937 cannot_be_modified: 1
940 columnname: todays_or_previous_checkouts
942 cannot_be_modified: 1
945 columnname: due_date_unformatted
947 cannot_be_modified: 1
954 columnname: record_type
956 columnname: item_type
958 columnname: collection
962 columnname: homebranch
964 columnname: checkout_on_unformatted
966 cannot_be_modified: 1
969 columnname: checkout_on
971 columnname: checkout_from
983 cannot_be_modified: 1
987 columnname: claims_returned
991 cannot_be_modified: 1
997 cannot_be_modified: 1
999 columnname: cardnumber
1001 columnname: date_of_birth
1003 columnname: category
1014 columnname: due_date
1022 columnname: homelibrary
1024 columnname: holdinglibrary
1026 columnname: location
1028 columnname: itemcallnumber
1030 columnname: dateaccessioned
1033 columnname: record_type
1037 columnname: borrower
1039 columnname: itemnote
1046 columnname: collection
1048 columnname: document_type
1050 columnname: callnumber
1052 columnname: copynumber
1054 columnname: enumeration
1069 columnname: pull_items
1071 columnname: avalaible_items
1079 columnname: libraries
1081 columnname: call_numbers
1083 columnname: copy_numbers
1085 columnname: enumeration
1087 columnname: itemtypes
1089 columnname: locations
1091 columnname: hold_date
1102 columnname: holds_ratio
1106 columnname: home_libraries
1108 columnname: holding_libraries
1110 columnname: location
1112 columnname: itemtype
1114 columnname: call_numbers
1116 columnname: items_needed
1118 holds_awaiting_pickup:
1121 columnname: waiting_since
1123 columnname: date_hold_placed
1129 columnname: home_library
1131 columnname: current_location
1133 columnname: shelving_location
1135 columnname: call_number
1137 columnname: copy_number
1139 columnname: enumeration
1145 columnname: waiting_since
1147 columnname: date_hold_placed
1153 columnname: home_library
1155 columnname: current_location
1157 columnname: shelving_location
1159 columnname: call_number
1161 columnname: copy_number
1163 columnname: enumeration
1170 columnname: due_date
1174 columnname: patron_category
1177 columnname: patron_library
1181 columnname: home_library
1184 columnname: holding_library
1189 columnname: call_number
1191 columnname: item_type
1196 columnname: non-public_note
1202 columnname: item_itemtype
1204 columnname: item_current_location
1206 columnname: item_home_location
1208 columnname: item_shelving_location
1211 columnname: item_ccode
1213 columnname: item_callnumber
1215 columnname: item_enumchron
1217 columnname: item_url
1219 columnname: item_copy
1221 columnname: item_status
1223 columnname: item_notes
1225 columnname: item_datedue
1227 columnname: item_barcode
1230 columnname: item_holds
1232 columnname: item_priority
1234 columnname: item_coursereserves
1236 course_reserves_table:
1238 columnname: coursename
1240 columnname: department
1242 columnname: course_number
1248 columnname: instructor
1254 columnname: serial_serialseq
1256 columnname: serial_publisheddate
1258 columnname: serial_planneddate
1260 columnname: serial_status
1262 columnname: serial_notes
1270 columnname: itemtype
1272 columnname: location
1274 columnname: collection
1276 columnname: callnumber
1278 columnname: copynumber
1289 subscription-detail:
1296 columnname: ordernumber
1298 columnname: creation_date
1300 columnname: receive_date
1304 columnname: order_internalnote
1306 columnname: order_vendornote
1326 columnname: copy_notice
1329 cannot_be_toggled: 1
1330 cannot_be_modified: 1
1337 columnname: cyclical
1341 columnname: description
1343 columnname: number_of_items
1346 cannot_be_toggled: 1
1347 cannot_be_modified: 1
1349 stock_rotation_manage_items:
1357 columnname: call_number
1359 columnname: in_transit
1364 cannot_be_toggled: 1
1365 cannot_be_modified: 1