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_date
43 columnname: estimated_delivery_date
47 columnname: information
49 columnname: total_cost
53 columnname: basket_group
59 columnname: claims_count
61 columnname: claimed_date
65 columnname: basket_number
67 columnname: order_information
69 columnname: recommended_retail_price_tax_excluded
71 columnname: ecost_tax_excluded
73 columnname: recommended_retail_price_tax_included
76 columnname: ecost_tax_included
79 columnname: replacement_price
83 columnname: total_tax_excluded
85 columnname: total_tax_included
88 columnname: goods_and_services_tax_percentage
90 columnname: goods_and_services_tax
94 columnname: supplier_report
102 cannot_be_modified: 1
110 cannot_be_modified: 1
114 cannot_be_modified: 1
121 columnname: last_updated
132 columnname: category_name
136 columnname: enrollment_period
138 columnname: age_required
140 columnname: upper_age_limit
142 columnname: enrollment_fee
146 columnname: lost_items
150 columnname: messaging
152 columnname: branches_limitations
154 columnname: default_privacy
158 cannot_be_modified: 1
163 columnname: library_name
165 columnname: library_code
167 columnname: library_address
169 columnname: marc_organization_code
171 columnname: library_ip
173 columnname: is_pickup_location
177 cannot_be_modified: 1
182 acquisitiondetails-table:
188 columnname: basketgroup
192 columnname: ordernumber
194 columnname: creation_date
196 columnname: received_data
202 columnname: order_internalnote
204 columnname: subscription
206 columnname: subscription_callnumber
208 checkoutshistory-table:
212 cannot_be_modified: 1
216 cannot_be_modified: 1
218 columnname: checked_out_from
222 columnname: checkout_on
226 columnname: checkin_on
231 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
232 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
233 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
238 columnname: dateaccessioned
240 columnname: booksellerid
242 columnname: homebranch
246 columnname: replacementprice
248 columnname: replacementpricedate
250 columnname: datelastborrowed
252 columnname: datelastseen
256 columnname: notforloan
262 columnname: withdrawn
264 columnname: itemcallnumber
266 columnname: coded_location_qualifier
268 columnname: restricted
270 columnname: itemnotes
272 columnname: itemnotes_nonpublic
274 columnname: holdingbranch
278 columnname: timestamp
284 columnname: cn_source
288 columnname: materials
294 columnname: enumchron
296 columnname: copynumber
298 columnname: stocknumber
302 course_reserves_table:
306 columnname: department
308 columnname: course_no
314 columnname: instructors
316 columnname: staff_note
318 columnname: public_note
320 columnname: no_of_students
325 course_reserves_table:
333 columnname: call_number
335 columnname: item_type
337 columnname: collection
343 columnname: staff_note
345 columnname: public_note
349 columnname: other_course_reserves
353 cannot_be_modified: 1
359 columnname: illrequest_id
361 columnname: metadata_author
363 columnname: metadata_title
365 columnname: metadata_article_title
367 columnname: metadata_issue
369 columnname: metadata_volume
371 columnname: metadata_year
373 columnname: metadata_pages
375 columnname: metadata_type
381 columnname: biblio_id
383 columnname: library_branchname
389 cannot_be_modified: 1
392 columnname: placed_formatted
396 cannot_be_modified: 1
399 columnname: updated_formatted
403 columnname: completed
405 cannot_be_modified: 1
408 columnname: completed_formatted
410 columnname: accessurl
416 columnname: notesopac
418 columnname: notesstaff
424 cannot_be_modified: 1
432 columnname: account_type
434 columnname: description
440 columnname: returndate
446 cannot_be_modified: 1
448 columnname: amountoutstanding
450 cannot_be_modified: 1
454 cannot_be_modified: 1
461 cannot_be_modified: 1
465 cannot_be_modified: 1
467 columnname: account_type
469 columnname: description
477 columnname: returndate
483 columnname: amountoutstanding
490 cannot_be_modified: 1
492 columnname: cardnumber
496 columnname: dateofbirth
502 columnname: expires_on
504 columnname: od_checkouts
508 columnname: circ_notes
512 cannot_be_modified: 1
517 columnname: sort_order
519 cannot_be_modified: 1
522 columnname: todays_or_previous_checkouts
524 cannot_be_modified: 1
527 columnname: due_date_unformatted
529 cannot_be_modified: 1
536 columnname: item_type
538 columnname: collection
542 columnname: homebranch
544 columnname: checkout_on_unformatted
546 cannot_be_modified: 1
549 columnname: checkout_on
551 columnname: checkout_from
563 cannot_be_modified: 1
569 cannot_be_modified: 1
576 cannot_be_modified: 1
584 columnname: reservedate
586 columnname: expirationdate
588 columnname: waitingdate
590 columnname: cancellationdate
597 checkouthistory-table:
600 cannot_be_modified: 1
608 columnname: call_number
612 columnname: number_of_renewals
614 columnname: checked_out_on
616 columnname: checked_out_from
620 columnname: return_date
627 cannot_be_modified: 1
631 columnname: firstname
641 columnname: expires_on
643 columnname: circ_notes
651 cannot_be_modified: 1
657 columnname: itemlost_on
661 columnname: callnumber
663 columnname: datelastseen
667 columnname: replacementprice
673 columnname: collection_code
675 columnname: current_location
679 columnname: notforloan
686 columnname: selection
688 cannot_be_modified: 1
690 columnname: report_id
692 cannot_be_modified: 1
694 columnname: report_name
706 columnname: creation_date
708 columnname: last_edit
716 columnname: cache_expiry
718 columnname: saved_results
724 cannot_be_modified: 1
730 columnname: sort_order
732 cannot_be_modified: 1
735 columnname: todays_or_previous_checkouts
737 cannot_be_modified: 1
740 columnname: due_date_unformatted
742 cannot_be_modified: 1
749 columnname: item_type
751 columnname: collection
755 columnname: homebranch
757 columnname: checkout_on_unformatted
759 cannot_be_modified: 1
762 columnname: checkout_on
764 columnname: checkout_from
776 cannot_be_modified: 1
782 cannot_be_modified: 1
787 cannot_be_modified: 1
789 columnname: cardnumber
791 columnname: date_of_birth
812 columnname: homelibrary
814 columnname: holdinglibrary
818 columnname: itemcallnumber
820 columnname: dateaccessioned
834 columnname: collection
836 columnname: document_type
838 columnname: callnumber
840 columnname: copynumber
842 columnname: enumeration
857 columnname: pull_items
859 columnname: avalaible_items
867 columnname: libraries
869 columnname: call_numbers
871 columnname: copy_numbers
873 columnname: enumeration
875 columnname: itemtypes
877 columnname: locations
879 columnname: hold_date
890 columnname: holds_ratio
894 columnname: home_libraries
896 columnname: holding_libraries
902 columnname: call_numbers
904 columnname: items_needed
906 holds_awaiting_pickup:
909 columnname: waiting_since
911 columnname: date_hold_placed
917 columnname: home_library
919 columnname: current_location
921 columnname: shelving_location
923 columnname: call_number
925 columnname: copy_number
927 columnname: enumeration
933 columnname: waiting_since
935 columnname: date_hold_placed
941 columnname: home_library
943 columnname: current_location
945 columnname: shelving_location
947 columnname: call_number
949 columnname: copy_number
951 columnname: enumeration
962 columnname: patron_category
965 columnname: patron_library
969 columnname: home_library
972 columnname: holding_library
977 columnname: call_number
979 columnname: item_type
984 columnname: non-public_note
990 columnname: item_itemtype
992 columnname: item_current_location
994 columnname: item_home_location
996 columnname: item_shelving_location
999 columnname: item_ccode
1001 columnname: item_callnumber
1003 columnname: item_enumchron
1005 columnname: item_url
1007 columnname: item_copy
1009 columnname: item_status
1011 columnname: item_notes
1013 columnname: item_datedue
1015 columnname: item_barcode
1018 columnname: item_holds
1020 columnname: item_priority
1022 columnname: item_coursereserves
1026 columnname: serial_serialseq
1028 columnname: serial_publisheddate
1030 columnname: serial_planneddate
1032 columnname: serial_status
1034 columnname: serial_notes
1037 subscription-detail:
1044 columnname: ordernumber
1046 columnname: creation_date
1048 columnname: receive_date
1052 columnname: order_internalnote
1054 columnname: order_vendornote
1074 columnname: copy_notice
1077 cannot_be_toggled: 1
1078 cannot_be_modified: 1
1085 columnname: cyclical
1089 columnname: description
1091 columnname: number_of_items
1094 cannot_be_toggled: 1
1095 cannot_be_modified: 1
1097 stock_rotation_manage_items:
1105 columnname: call_number
1107 columnname: in_transit
1112 cannot_be_toggled: 1
1113 cannot_be_modified: 1