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: actual_cost_tax_excluded
73 columnname: budgeted_cost_price_tax_included
75 columnname: recommended_retail_price_tax_included
78 columnname: actual_cost_tax_included
81 columnname: budgeted_cost_tax_included
83 columnname: replacement_price
87 columnname: total_tax_excluded
89 columnname: total_tax_included
92 columnname: goods_and_services_tax_percentage
94 columnname: goods_and_services_tax
98 columnname: supplier_report
102 cannot_be_modified: 1
106 cannot_be_modified: 1
114 cannot_be_modified: 1
118 cannot_be_modified: 1
125 columnname: last_updated
136 columnname: category_name
140 columnname: enrollment_period
142 columnname: age_required
144 columnname: upper_age_limit
146 columnname: enrollment_fee
150 columnname: lost_items
154 columnname: messaging
156 columnname: branches_limitations
158 columnname: default_privacy
162 cannot_be_modified: 1
167 columnname: library_name
169 columnname: library_code
171 columnname: library_address
173 columnname: marc_organization_code
175 columnname: library_ip
177 columnname: is_pickup_location
181 cannot_be_modified: 1
186 acquisitiondetails-table:
192 columnname: basketgroup
196 columnname: ordernumber
198 columnname: creation_date
200 columnname: received_data
206 columnname: order_internalnote
208 columnname: subscription
210 columnname: subscription_callnumber
212 checkoutshistory-table:
216 cannot_be_modified: 1
220 cannot_be_modified: 1
222 columnname: checked_out_from
226 columnname: checkout_on
230 columnname: checkin_on
235 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
236 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
237 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
242 columnname: dateaccessioned
244 columnname: booksellerid
246 columnname: homebranch
250 columnname: replacementprice
252 columnname: replacementpricedate
254 columnname: datelastborrowed
256 columnname: datelastseen
260 columnname: notforloan
266 columnname: withdrawn
268 columnname: itemcallnumber
270 columnname: coded_location_qualifier
272 columnname: restricted
274 columnname: itemnotes
276 columnname: itemnotes_nonpublic
278 columnname: holdingbranch
282 columnname: timestamp
288 columnname: cn_source
292 columnname: materials
298 columnname: enumchron
300 columnname: copynumber
302 columnname: stocknumber
306 course_reserves_table:
310 columnname: department
312 columnname: course_no
318 columnname: instructors
320 columnname: staff_note
322 columnname: public_note
324 columnname: no_of_students
329 course_reserves_table:
337 columnname: call_number
339 columnname: item_type
341 columnname: collection
347 columnname: staff_note
349 columnname: public_note
353 columnname: other_course_reserves
357 cannot_be_modified: 1
363 columnname: illrequest_id
365 columnname: metadata_author
367 columnname: metadata_title
369 columnname: metadata_article_title
371 columnname: metadata_issue
373 columnname: metadata_volume
375 columnname: metadata_year
377 columnname: metadata_pages
379 columnname: metadata_type
385 columnname: biblio_id
387 columnname: library_branchname
393 cannot_be_modified: 1
396 columnname: placed_formatted
400 cannot_be_modified: 1
403 columnname: updated_formatted
407 columnname: completed
409 cannot_be_modified: 1
412 columnname: completed_formatted
414 columnname: accessurl
420 columnname: notesopac
422 columnname: notesstaff
428 cannot_be_modified: 1
436 columnname: account_type
438 columnname: description
444 columnname: returndate
450 cannot_be_modified: 1
452 columnname: amountoutstanding
454 cannot_be_modified: 1
458 cannot_be_modified: 1
465 cannot_be_modified: 1
469 cannot_be_modified: 1
471 columnname: account_type
473 columnname: description
481 columnname: returndate
487 columnname: amountoutstanding
494 cannot_be_modified: 1
496 columnname: cardnumber
500 columnname: dateofbirth
506 columnname: expires_on
508 columnname: od_checkouts
512 columnname: circ_notes
516 cannot_be_modified: 1
521 columnname: sort_order
523 cannot_be_modified: 1
526 columnname: todays_or_previous_checkouts
528 cannot_be_modified: 1
531 columnname: due_date_unformatted
533 cannot_be_modified: 1
540 columnname: item_type
542 columnname: collection
546 columnname: homebranch
548 columnname: checkout_on_unformatted
550 cannot_be_modified: 1
553 columnname: checkout_on
555 columnname: checkout_from
567 cannot_be_modified: 1
573 cannot_be_modified: 1
580 cannot_be_modified: 1
588 columnname: reservedate
590 columnname: expirationdate
592 columnname: waitingdate
594 columnname: cancellationdate
601 checkouthistory-table:
604 cannot_be_modified: 1
612 columnname: call_number
616 columnname: number_of_renewals
618 columnname: checked_out_on
620 columnname: checked_out_from
624 columnname: return_date
631 cannot_be_modified: 1
635 columnname: firstname
645 columnname: expires_on
647 columnname: circ_notes
655 cannot_be_modified: 1
661 columnname: itemlost_on
665 columnname: callnumber
667 columnname: datelastseen
671 columnname: replacementprice
677 columnname: collection_code
679 columnname: current_location
683 columnname: notforloan
690 columnname: selection
692 cannot_be_modified: 1
694 columnname: report_id
696 cannot_be_modified: 1
698 columnname: report_name
710 columnname: creation_date
712 columnname: last_edit
720 columnname: cache_expiry
722 columnname: saved_results
728 cannot_be_modified: 1
734 columnname: sort_order
736 cannot_be_modified: 1
739 columnname: todays_or_previous_checkouts
741 cannot_be_modified: 1
744 columnname: due_date_unformatted
746 cannot_be_modified: 1
753 columnname: item_type
755 columnname: collection
759 columnname: homebranch
761 columnname: checkout_on_unformatted
763 cannot_be_modified: 1
766 columnname: checkout_on
768 columnname: checkout_from
780 cannot_be_modified: 1
786 cannot_be_modified: 1
791 cannot_be_modified: 1
793 columnname: cardnumber
795 columnname: date_of_birth
816 columnname: homelibrary
818 columnname: holdinglibrary
822 columnname: itemcallnumber
824 columnname: dateaccessioned
838 columnname: collection
840 columnname: document_type
842 columnname: callnumber
844 columnname: copynumber
846 columnname: enumeration
861 columnname: pull_items
863 columnname: avalaible_items
871 columnname: libraries
873 columnname: call_numbers
875 columnname: copy_numbers
877 columnname: enumeration
879 columnname: itemtypes
881 columnname: locations
883 columnname: hold_date
894 columnname: holds_ratio
898 columnname: home_libraries
900 columnname: holding_libraries
906 columnname: call_numbers
908 columnname: items_needed
910 holds_awaiting_pickup:
913 columnname: waiting_since
915 columnname: date_hold_placed
921 columnname: home_library
923 columnname: current_location
925 columnname: shelving_location
927 columnname: call_number
929 columnname: copy_number
931 columnname: enumeration
937 columnname: waiting_since
939 columnname: date_hold_placed
945 columnname: home_library
947 columnname: current_location
949 columnname: shelving_location
951 columnname: call_number
953 columnname: copy_number
955 columnname: enumeration
966 columnname: patron_category
969 columnname: patron_library
973 columnname: home_library
976 columnname: holding_library
981 columnname: call_number
983 columnname: item_type
988 columnname: non-public_note
994 columnname: item_itemtype
996 columnname: item_current_location
998 columnname: item_home_location
1000 columnname: item_shelving_location
1003 columnname: item_ccode
1005 columnname: item_callnumber
1007 columnname: item_enumchron
1009 columnname: item_url
1011 columnname: item_copy
1013 columnname: item_status
1015 columnname: item_notes
1017 columnname: item_datedue
1019 columnname: item_barcode
1022 columnname: item_holds
1024 columnname: item_priority
1026 columnname: item_coursereserves
1030 columnname: serial_serialseq
1032 columnname: serial_publisheddate
1034 columnname: serial_planneddate
1036 columnname: serial_status
1038 columnname: serial_notes
1041 subscription-detail:
1048 columnname: ordernumber
1050 columnname: creation_date
1052 columnname: receive_date
1056 columnname: order_internalnote
1058 columnname: order_vendornote
1078 columnname: copy_notice
1081 cannot_be_toggled: 1
1082 cannot_be_modified: 1
1089 columnname: cyclical
1093 columnname: description
1095 columnname: number_of_items
1098 cannot_be_toggled: 1
1099 cannot_be_modified: 1
1101 stock_rotation_manage_items:
1109 columnname: call_number
1111 columnname: in_transit
1116 cannot_be_toggled: 1
1117 cannot_be_modified: 1