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
107 columnname: selections
109 cannot_be_modified: 1
111 columnname: suggestion
113 columnname: suggested_by
115 columnname: suggested_on
117 columnname: managed_by
119 columnname: managed_on
123 columnname: library_fund
125 columnname: suggestion_status
129 cannot_be_modified: 1
137 cannot_be_modified: 1
141 cannot_be_modified: 1
148 columnname: last_updated
159 columnname: category_name
163 columnname: enrollment_period
165 columnname: age_required
167 columnname: upper_age_limit
169 columnname: enrollment_fee
173 columnname: lost_items
177 columnname: messaging
179 columnname: branches_limitations
181 columnname: default_privacy
185 cannot_be_modified: 1
194 columnname: description
196 columnname: search_category
198 columnname: not_for_loan
200 columnname: hide_in_opac
202 columnname: rental_charge
204 columnname: daily_rental_charge
206 columnname: hourly_rental_charge
208 columnname: default_replacement_cost
210 columnname: lost_processing_fee
212 columnname: checkin_message
214 columnname: library_limitations
218 cannot_be_modified: 1
223 columnname: library_name
225 columnname: library_code
227 columnname: library_address
229 columnname: marc_organization_code
231 columnname: library_ip
233 columnname: is_pickup_location
237 cannot_be_modified: 1
242 acquisitiondetails-table:
248 columnname: basketgroup
252 columnname: ordernumber
254 columnname: creation_date
256 columnname: received_data
262 columnname: order_internalnote
264 columnname: subscription
266 columnname: subscription_callnumber
268 checkoutshistory-table:
272 cannot_be_modified: 1
276 cannot_be_modified: 1
278 columnname: checked_out_from
282 columnname: checkout_on
286 columnname: checkin_on
291 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
292 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
293 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
298 columnname: dateaccessioned
300 columnname: booksellerid
302 columnname: homebranch
306 columnname: replacementprice
308 columnname: replacementpricedate
310 columnname: datelastborrowed
312 columnname: datelastseen
316 columnname: notforloan
322 columnname: withdrawn
324 columnname: itemcallnumber
326 columnname: coded_location_qualifier
328 columnname: restricted
330 columnname: itemnotes
332 columnname: itemnotes_nonpublic
334 columnname: holdingbranch
336 columnname: timestamp
342 columnname: cn_source
346 columnname: materials
352 columnname: enumchron
354 columnname: copynumber
356 columnname: stocknumber
377 cannot_be_modified: 1
381 course_reserves_table:
385 columnname: department
387 columnname: course_no
393 columnname: instructors
395 columnname: staff_note
397 columnname: public_note
399 columnname: no_of_students
404 course_reserves_table:
412 columnname: call_number
414 columnname: item_type
416 columnname: collection
422 columnname: staff_note
424 columnname: public_note
428 columnname: other_course_reserves
432 cannot_be_modified: 1
438 columnname: illrequest_id
440 columnname: metadata_author
442 columnname: metadata_title
444 columnname: metadata_article_title
446 columnname: metadata_issue
448 columnname: metadata_volume
450 columnname: metadata_year
452 columnname: metadata_pages
454 columnname: metadata_type
460 columnname: biblio_id
462 columnname: library_branchname
468 cannot_be_modified: 1
471 columnname: placed_formatted
475 cannot_be_modified: 1
478 columnname: updated_formatted
482 columnname: completed
484 cannot_be_modified: 1
487 columnname: completed_formatted
489 columnname: accessurl
495 columnname: notesopac
497 columnname: notesstaff
503 cannot_be_modified: 1
511 columnname: description
517 columnname: returndate
523 cannot_be_modified: 1
525 columnname: amountoutstanding
527 cannot_be_modified: 1
531 cannot_be_modified: 1
538 cannot_be_modified: 1
542 cannot_be_modified: 1
544 columnname: description
552 columnname: returndate
556 columnname: account_type
560 columnname: amountoutstanding
567 cannot_be_modified: 1
569 columnname: cardnumber
573 columnname: dateofbirth
579 columnname: expires_on
581 columnname: od_checkouts
585 columnname: circ_notes
589 cannot_be_modified: 1
594 columnname: sort_order
596 cannot_be_modified: 1
599 columnname: todays_or_previous_checkouts
601 cannot_be_modified: 1
604 columnname: due_date_unformatted
606 cannot_be_modified: 1
613 columnname: record_type
615 columnname: item_type
617 columnname: collection
621 columnname: homebranch
623 columnname: checkout_on_unformatted
625 cannot_be_modified: 1
628 columnname: checkout_on
630 columnname: checkout_from
642 cannot_be_modified: 1
648 cannot_be_modified: 1
655 cannot_be_modified: 1
663 columnname: reservedate
665 columnname: expirationdate
667 columnname: waitingdate
669 columnname: cancellationdate
676 checkouthistory-table:
679 cannot_be_modified: 1
687 columnname: call_number
691 columnname: number_of_renewals
693 columnname: checked_out_on
695 columnname: checked_out_from
699 columnname: return_date
706 cannot_be_modified: 1
710 columnname: firstname
720 columnname: expires_on
722 columnname: circ_notes
730 cannot_be_modified: 1
736 columnname: itemlost_on
740 columnname: callnumber
742 columnname: datelastseen
746 columnname: replacementprice
752 columnname: collection_code
754 columnname: current_location
758 columnname: notforloan
765 columnname: selection
767 cannot_be_modified: 1
769 columnname: report_id
771 cannot_be_modified: 1
773 columnname: report_name
785 columnname: creation_date
787 columnname: last_edit
795 columnname: cache_expiry
797 columnname: saved_results
803 cannot_be_modified: 1
809 columnname: sort_order
811 cannot_be_modified: 1
814 columnname: todays_or_previous_checkouts
816 cannot_be_modified: 1
819 columnname: due_date_unformatted
821 cannot_be_modified: 1
828 columnname: record_type
830 columnname: item_type
832 columnname: collection
836 columnname: homebranch
838 columnname: checkout_on_unformatted
840 cannot_be_modified: 1
843 columnname: checkout_on
845 columnname: checkout_from
857 cannot_be_modified: 1
863 cannot_be_modified: 1
868 cannot_be_modified: 1
870 columnname: cardnumber
872 columnname: date_of_birth
893 columnname: homelibrary
895 columnname: holdinglibrary
899 columnname: itemcallnumber
901 columnname: dateaccessioned
904 columnname: record_type
917 columnname: collection
919 columnname: document_type
921 columnname: callnumber
923 columnname: copynumber
925 columnname: enumeration
940 columnname: pull_items
942 columnname: avalaible_items
950 columnname: libraries
952 columnname: call_numbers
954 columnname: copy_numbers
956 columnname: enumeration
958 columnname: itemtypes
960 columnname: locations
962 columnname: hold_date
973 columnname: holds_ratio
977 columnname: home_libraries
979 columnname: holding_libraries
985 columnname: call_numbers
987 columnname: items_needed
996 columnname: patron_category
999 columnname: patron_library
1003 columnname: home_library
1006 columnname: holding_library
1011 columnname: call_number
1013 columnname: item_type
1018 columnname: non-public_note
1024 columnname: item_itemtype
1026 columnname: item_current_location
1028 columnname: item_home_location
1030 columnname: item_shelving_location
1033 columnname: item_ccode
1035 columnname: item_callnumber
1037 columnname: item_enumchron
1039 columnname: item_url
1041 columnname: item_copy
1043 columnname: item_status
1045 columnname: item_notes
1047 columnname: item_datedue
1049 columnname: item_barcode
1052 columnname: item_holds
1054 columnname: item_priority
1056 columnname: item_coursereserves
1060 columnname: serial_serialseq
1062 columnname: serial_publisheddate
1064 columnname: serial_planneddate
1066 columnname: serial_status
1068 columnname: serial_notes
1071 subscription-detail:
1078 columnname: ordernumber
1080 columnname: creation_date
1082 columnname: receive_date
1086 columnname: order_internalnote
1088 columnname: order_vendornote
1108 columnname: copy_notice
1111 cannot_be_toggled: 1
1112 cannot_be_modified: 1
1119 columnname: cyclical
1123 columnname: description
1125 columnname: number_of_items
1128 cannot_be_toggled: 1
1129 cannot_be_modified: 1
1131 stock_rotation_manage_items:
1139 columnname: call_number
1141 columnname: in_transit
1146 cannot_be_toggled: 1
1147 cannot_be_modified: 1