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
51 columnname: total_cost
55 columnname: basket_group
61 columnname: claims_count
63 columnname: claimed_date
65 columnname: internal_note
67 columnname: vendor_note
74 columnname: basket_number
76 columnname: order_information
78 columnname: recommended_retail_price_tax_excluded
80 columnname: ecost_tax_excluded
82 columnname: recommended_retail_price_tax_included
85 columnname: ecost_tax_included
88 columnname: replacement_price
92 columnname: total_tax_excluded
94 columnname: total_tax_included
97 columnname: goods_and_services_tax_percentage
99 columnname: goods_and_services_tax
103 columnname: supplier_report
107 cannot_be_modified: 1
111 cannot_be_modified: 1
116 columnname: selections
118 cannot_be_modified: 1
120 columnname: suggestion
122 columnname: suggested_by
124 columnname: suggested_on
126 columnname: managed_by
128 columnname: managed_on
130 columnname: lastmodificationby
132 columnname: lastmodificationdate
136 columnname: library_fund
138 columnname: suggestion_status
142 cannot_be_modified: 1
150 cannot_be_modified: 1
154 cannot_be_modified: 1
161 columnname: last_updated
172 columnname: category_name
176 columnname: enrollment_period
178 columnname: age_required
180 columnname: upper_age_limit
182 columnname: enrollment_fee
186 columnname: lost_items
190 columnname: messaging
192 columnname: branches_limitations
194 columnname: default_privacy
198 cannot_be_modified: 1
207 columnname: description
209 columnname: search_category
211 columnname: not_for_loan
213 columnname: hide_in_opac
215 columnname: rental_charge
217 columnname: daily_rental_charge
219 columnname: hourly_rental_charge
221 columnname: default_replacement_cost
223 columnname: lost_processing_fee
225 columnname: checkin_message
227 columnname: library_limitations
231 cannot_be_modified: 1
236 columnname: library_name
238 columnname: library_code
240 columnname: library_address
242 columnname: marc_organization_code
244 columnname: library_ip
246 columnname: is_pickup_location
250 cannot_be_modified: 1
256 columnname: holdings_checkbox
258 cannot_be_modified: 1
260 columnname: holdings_itype
262 columnname: holdings_holdingbranch
264 columnname: holdings_homebranch
266 columnname: holdings_ccode
268 columnname: holdings_itemcallnumber
270 columnname: holdings_status
272 columnname: holdings_lastseen
274 columnname: holdings_barcode
276 columnname: holdings_enumchron
278 columnname: holdings_uri
280 columnname: holdings_copynumber
282 columnname: holdings_stocknumber
284 columnname: holdings_materials
286 columnname: holdings_itemnotes
288 columnname: holdings_itemnotes_nonpublic
290 columnname: holdings_hostrecord
292 columnname: holdings_usedin
294 columnname: holdings_usedin_col
296 columnname: holdings_course_reserves
298 columnname: holdings_spinelabel
300 columnname: holdings_actions
302 cannot_be_modified: 1
306 columnname: otherholdings_checkbox
308 cannot_be_modified: 1
310 columnname: otherholdings_itype
312 columnname: otherholdings_holdingbranch
314 columnname: otherholdings_homebranch
316 columnname: otherholdings_ccode
318 columnname: otherholdings_itemcallnumber
320 columnname: otherholdings_status
322 columnname: otherholdings_lastseen
324 columnname: otherholdings_barcode
326 columnname: otherholdings_enumchron
328 columnname: otherholdings_uri
330 columnname: otherholdings_copynumber
332 columnname: otherholdings_stocknumber
334 columnname: otherholdings_materials
336 columnname: otherholdings_itemnotes
338 columnname: otherholdings_itemnotes_nonpublic
340 columnname: otherholdings_hostrecord
342 columnname: otherholdings_usedin
344 columnname: otherholdings_usedin_col
346 columnname: otherholdings_course_reserves
348 columnname: otherholdings_spinelabel
350 columnname: otherholdings_actions
352 cannot_be_modified: 1
354 acquisitiondetails-table:
360 columnname: basketgroup
364 columnname: ordernumber
366 columnname: creation_date
368 columnname: received_data
374 columnname: order_internalnote
376 columnname: subscription
378 columnname: subscription_callnumber
380 checkoutshistory-table:
384 cannot_be_modified: 1
388 cannot_be_modified: 1
390 columnname: checked_out_from
394 columnname: checkout_on
398 columnname: checkin_on
403 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
404 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
405 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
410 columnname: dateaccessioned
412 columnname: booksellerid
414 columnname: homebranch
418 columnname: replacementprice
420 columnname: replacementpricedate
422 columnname: datelastborrowed
424 columnname: datelastseen
428 columnname: notforloan
434 columnname: withdrawn
436 columnname: itemcallnumber
438 columnname: coded_location_qualifier
440 columnname: restricted
442 columnname: itemnotes
444 columnname: itemnotes_nonpublic
446 columnname: holdingbranch
448 columnname: timestamp
454 columnname: cn_source
458 columnname: materials
464 columnname: enumchron
466 columnname: copynumber
468 columnname: stocknumber
489 cannot_be_modified: 1
493 course_reserves_table:
497 columnname: department
499 columnname: course_no
505 columnname: instructors
507 columnname: staff_note
509 columnname: public_note
511 columnname: no_of_students
516 course_reserves_table:
524 columnname: call_number
526 columnname: item_type
528 columnname: collection
534 columnname: staff_note
536 columnname: public_note
540 columnname: other_course_reserves
544 cannot_be_modified: 1
550 columnname: illrequest_id
552 columnname: metadata_author
554 columnname: metadata_title
556 columnname: metadata_article_title
558 columnname: metadata_issue
560 columnname: metadata_volume
562 columnname: metadata_year
564 columnname: metadata_pages
566 columnname: metadata_type
572 columnname: biblio_id
574 columnname: library_branchname
580 cannot_be_modified: 1
583 columnname: placed_formatted
587 cannot_be_modified: 1
590 columnname: updated_formatted
594 columnname: completed
596 cannot_be_modified: 1
599 columnname: completed_formatted
601 columnname: accessurl
607 columnname: notesopac
609 columnname: notesstaff
615 cannot_be_modified: 1
623 columnname: account_type
625 columnname: description
631 columnname: returndate
637 cannot_be_modified: 1
639 columnname: amountoutstanding
641 cannot_be_modified: 1
645 cannot_be_modified: 1
652 cannot_be_modified: 1
656 cannot_be_modified: 1
658 columnname: account_type
660 columnname: description
668 columnname: returndate
674 columnname: amountoutstanding
681 cannot_be_modified: 1
683 columnname: cardnumber
687 columnname: dateofbirth
693 columnname: expires_on
695 columnname: od_checkouts
699 columnname: circ_notes
703 cannot_be_modified: 1
708 columnname: sort_order
710 cannot_be_modified: 1
713 columnname: todays_or_previous_checkouts
715 cannot_be_modified: 1
718 columnname: due_date_unformatted
720 cannot_be_modified: 1
727 columnname: record_type
729 columnname: item_type
731 columnname: collection
735 columnname: homebranch
737 columnname: checkout_on_unformatted
739 cannot_be_modified: 1
742 columnname: checkout_on
744 columnname: checkout_from
756 cannot_be_modified: 1
760 columnname: claims_returned
764 cannot_be_modified: 1
771 cannot_be_modified: 1
779 columnname: reservedate
781 columnname: expirationdate
783 columnname: waitingdate
785 columnname: cancellationdate
792 checkouthistory-table:
795 cannot_be_modified: 1
803 columnname: call_number
807 columnname: number_of_renewals
809 columnname: checked_out_on
811 columnname: checked_out_from
815 columnname: return_date
822 cannot_be_modified: 1
826 columnname: firstname
836 columnname: expires_on
838 columnname: circ_notes
846 cannot_be_modified: 1
852 columnname: itemlost_on
856 columnname: callnumber
858 columnname: datelastseen
862 columnname: replacementprice
868 columnname: collection_code
870 columnname: current_location
874 columnname: notforloan
881 columnname: selection
883 cannot_be_modified: 1
885 columnname: report_id
887 cannot_be_modified: 1
889 columnname: report_name
901 columnname: creation_date
903 columnname: last_edit
911 columnname: cache_expiry
913 columnname: saved_results
919 cannot_be_modified: 1
925 columnname: sort_order
927 cannot_be_modified: 1
930 columnname: todays_or_previous_checkouts
932 cannot_be_modified: 1
935 columnname: due_date_unformatted
937 cannot_be_modified: 1
944 columnname: record_type
946 columnname: item_type
948 columnname: collection
952 columnname: homebranch
954 columnname: checkout_on_unformatted
956 cannot_be_modified: 1
959 columnname: checkout_on
961 columnname: checkout_from
973 cannot_be_modified: 1
977 columnname: claims_returned
981 cannot_be_modified: 1
987 cannot_be_modified: 1
989 columnname: cardnumber
991 columnname: date_of_birth
1004 columnname: due_date
1012 columnname: homelibrary
1014 columnname: holdinglibrary
1016 columnname: location
1018 columnname: itemcallnumber
1020 columnname: dateaccessioned
1023 columnname: record_type
1027 columnname: borrower
1029 columnname: itemnote
1036 columnname: collection
1038 columnname: document_type
1040 columnname: callnumber
1042 columnname: copynumber
1044 columnname: enumeration
1059 columnname: pull_items
1061 columnname: avalaible_items
1069 columnname: libraries
1071 columnname: call_numbers
1073 columnname: copy_numbers
1075 columnname: enumeration
1077 columnname: itemtypes
1079 columnname: locations
1081 columnname: hold_date
1092 columnname: holds_ratio
1096 columnname: home_libraries
1098 columnname: holding_libraries
1100 columnname: location
1102 columnname: itemtype
1104 columnname: call_numbers
1106 columnname: items_needed
1108 holds_awaiting_pickup:
1111 columnname: waiting_since
1113 columnname: date_hold_placed
1119 columnname: home_library
1121 columnname: current_location
1123 columnname: shelving_location
1125 columnname: call_number
1127 columnname: copy_number
1129 columnname: enumeration
1135 columnname: waiting_since
1137 columnname: date_hold_placed
1143 columnname: home_library
1145 columnname: current_location
1147 columnname: shelving_location
1149 columnname: call_number
1151 columnname: copy_number
1153 columnname: enumeration
1160 columnname: due_date
1164 columnname: patron_category
1167 columnname: patron_library
1171 columnname: home_library
1174 columnname: holding_library
1179 columnname: call_number
1181 columnname: item_type
1186 columnname: non-public_note
1192 columnname: item_itemtype
1194 columnname: item_current_location
1196 columnname: item_home_location
1198 columnname: item_shelving_location
1201 columnname: item_ccode
1203 columnname: item_callnumber
1205 columnname: item_enumchron
1207 columnname: item_url
1209 columnname: item_copy
1211 columnname: item_status
1213 columnname: item_notes
1215 columnname: item_datedue
1217 columnname: item_barcode
1220 columnname: item_holds
1222 columnname: item_priority
1224 columnname: item_coursereserves
1226 course_reserves_table:
1228 columnname: coursename
1230 columnname: department
1232 columnname: course_number
1238 columnname: instructor
1244 columnname: serial_serialseq
1246 columnname: serial_publisheddate
1248 columnname: serial_planneddate
1250 columnname: serial_status
1252 columnname: serial_notes
1260 columnname: itemtype
1262 columnname: location
1264 columnname: collection
1266 columnname: callnumber
1268 columnname: copynumber
1279 subscription-detail:
1286 columnname: ordernumber
1288 columnname: creation_date
1290 columnname: receive_date
1294 columnname: order_internalnote
1296 columnname: order_vendornote
1316 columnname: copy_notice
1319 cannot_be_toggled: 1
1320 cannot_be_modified: 1
1327 columnname: cyclical
1331 columnname: description
1333 columnname: number_of_items
1336 cannot_be_toggled: 1
1337 cannot_be_modified: 1
1339 stock_rotation_manage_items:
1347 columnname: call_number
1349 columnname: in_transit
1354 cannot_be_toggled: 1
1355 cannot_be_modified: 1