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
276 columnname: timestamp
282 columnname: cn_source
286 columnname: materials
292 columnname: enumchron
294 columnname: copynumber
296 columnname: stocknumber
300 course_reserves_table:
304 columnname: department
306 columnname: course_no
312 columnname: instructors
314 columnname: staff_note
316 columnname: public_note
318 columnname: no_of_students
323 course_reserves_table:
331 columnname: call_number
333 columnname: item_type
335 columnname: collection
341 columnname: staff_note
343 columnname: public_note
347 columnname: other_course_reserves
351 cannot_be_modified: 1
357 columnname: illrequest_id
359 columnname: metadata_author
361 columnname: metadata_title
363 columnname: metadata_article_title
365 columnname: metadata_issue
367 columnname: metadata_volume
369 columnname: metadata_year
371 columnname: metadata_pages
373 columnname: metadata_type
379 columnname: biblio_id
381 columnname: library_branchname
387 cannot_be_modified: 1
390 columnname: placed_formatted
394 cannot_be_modified: 1
397 columnname: updated_formatted
401 columnname: completed
403 cannot_be_modified: 1
406 columnname: completed_formatted
408 columnname: accessurl
414 columnname: notesopac
416 columnname: notesstaff
422 cannot_be_modified: 1
430 columnname: description
436 columnname: returndate
442 cannot_be_modified: 1
444 columnname: amountoutstanding
446 cannot_be_modified: 1
450 cannot_be_modified: 1
457 cannot_be_modified: 1
461 cannot_be_modified: 1
463 columnname: description
471 columnname: returndate
475 columnname: account_type
479 columnname: amountoutstanding
486 cannot_be_modified: 1
488 columnname: cardnumber
492 columnname: dateofbirth
498 columnname: expires_on
500 columnname: od_checkouts
504 columnname: circ_notes
508 cannot_be_modified: 1
513 columnname: sort_order
515 cannot_be_modified: 1
518 columnname: todays_or_previous_checkouts
520 cannot_be_modified: 1
523 columnname: due_date_unformatted
525 cannot_be_modified: 1
532 columnname: item_type
534 columnname: collection
538 columnname: homebranch
540 columnname: checkout_on_unformatted
542 cannot_be_modified: 1
545 columnname: checkout_on
547 columnname: checkout_from
559 cannot_be_modified: 1
565 cannot_be_modified: 1
572 cannot_be_modified: 1
580 columnname: reservedate
582 columnname: expirationdate
584 columnname: waitingdate
586 columnname: cancellationdate
593 checkouthistory-table:
596 cannot_be_modified: 1
604 columnname: call_number
608 columnname: number_of_renewals
610 columnname: checked_out_on
612 columnname: checked_out_from
616 columnname: return_date
623 cannot_be_modified: 1
627 columnname: firstname
637 columnname: expires_on
639 columnname: circ_notes
647 cannot_be_modified: 1
653 columnname: itemlost_on
657 columnname: callnumber
659 columnname: datelastseen
663 columnname: replacementprice
669 columnname: collection_code
671 columnname: current_location
675 columnname: notforloan
682 columnname: selection
684 cannot_be_modified: 1
686 columnname: report_id
688 cannot_be_modified: 1
690 columnname: report_name
702 columnname: creation_date
704 columnname: last_edit
712 columnname: cache_expiry
714 columnname: saved_results
720 cannot_be_modified: 1
726 columnname: sort_order
728 cannot_be_modified: 1
731 columnname: todays_or_previous_checkouts
733 cannot_be_modified: 1
736 columnname: due_date_unformatted
738 cannot_be_modified: 1
745 columnname: item_type
747 columnname: collection
751 columnname: homebranch
753 columnname: checkout_on_unformatted
755 cannot_be_modified: 1
758 columnname: checkout_on
760 columnname: checkout_from
772 cannot_be_modified: 1
778 cannot_be_modified: 1
783 cannot_be_modified: 1
785 columnname: cardnumber
787 columnname: date_of_birth
808 columnname: homelibrary
810 columnname: holdinglibrary
814 columnname: itemcallnumber
816 columnname: dateaccessioned
830 columnname: collection
832 columnname: document_type
834 columnname: callnumber
836 columnname: copynumber
838 columnname: enumeration
853 columnname: pull_items
855 columnname: avalaible_items
863 columnname: libraries
865 columnname: call_numbers
867 columnname: copy_numbers
869 columnname: enumeration
871 columnname: itemtypes
873 columnname: locations
875 columnname: hold_date
886 columnname: holds_ratio
890 columnname: home_libraries
892 columnname: holding_libraries
898 columnname: call_numbers
900 columnname: items_needed
906 columnname: item_itemtype
908 columnname: item_current_location
910 columnname: item_home_location
912 columnname: item_shelving_location
915 columnname: item_ccode
917 columnname: item_callnumber
919 columnname: item_enumchron
923 columnname: item_copy
925 columnname: item_status
927 columnname: item_notes
929 columnname: item_datedue
931 columnname: item_barcode
934 columnname: item_holds
936 columnname: item_priority
938 columnname: item_coursereserves
942 columnname: serial_serialseq
944 columnname: serial_publisheddate
946 columnname: serial_planneddate
948 columnname: serial_status
950 columnname: serial_notes
960 columnname: ordernumber
962 columnname: creation_date
964 columnname: receive_date
968 columnname: order_internalnote
970 columnname: order_vendornote
990 columnname: copy_notice
994 cannot_be_modified: 1
1001 columnname: cyclical
1005 columnname: description
1007 columnname: number_of_items
1010 cannot_be_toggled: 1
1011 cannot_be_modified: 1
1013 stock_rotation_manage_items:
1021 columnname: call_number
1023 columnname: in_transit
1028 cannot_be_toggled: 1
1029 cannot_be_modified: 1