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: subscription
204 columnname: subscription_callnumber
206 checkoutshistory-table:
210 cannot_be_modified: 1
214 cannot_be_modified: 1
216 columnname: checked_out_from
220 columnname: checkout_on
224 columnname: checkin_on
229 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
230 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
231 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
236 columnname: dateaccessioned
238 columnname: booksellerid
240 columnname: homebranch
244 columnname: replacementprice
246 columnname: replacementpricedate
248 columnname: datelastborrowed
250 columnname: datelastseen
254 columnname: notforloan
260 columnname: withdrawn
262 columnname: itemcallnumber
264 columnname: coded_location_qualifier
266 columnname: restricted
268 columnname: itemnotes
270 columnname: itemnotes_nonpublic
272 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
359 columnname: description
365 cannot_be_modified: 1
367 columnname: amountoutstanding
369 cannot_be_modified: 1
373 cannot_be_modified: 1
380 cannot_be_modified: 1
384 cannot_be_modified: 1
386 columnname: description
392 columnname: account_type
396 columnname: amountoutstanding
403 cannot_be_modified: 1
405 columnname: cardnumber
409 columnname: dateofbirth
415 columnname: expires_on
417 columnname: od_checkouts
421 columnname: circ_notes
425 cannot_be_modified: 1
430 columnname: sort_order
432 cannot_be_modified: 1
435 columnname: todays_or_previous_checkouts
437 cannot_be_modified: 1
440 columnname: due_date_unformatted
442 cannot_be_modified: 1
449 columnname: item_type
451 columnname: collection
455 columnname: homebranch
457 columnname: checkout_on_unformatted
459 cannot_be_modified: 1
462 columnname: checkout_on
464 columnname: checkout_from
476 cannot_be_modified: 1
482 cannot_be_modified: 1
489 cannot_be_modified: 1
497 columnname: reservedate
499 columnname: expirationdate
501 columnname: waitingdate
503 columnname: cancellationdate
515 cannot_be_modified: 1
521 columnname: itemlost_on
525 columnname: callnumber
527 columnname: datelastseen
531 columnname: replacementprice
537 columnname: current_location
541 columnname: notforloan
548 columnname: selection
550 cannot_be_modified: 1
552 columnname: report_id
554 cannot_be_modified: 1
556 columnname: report_name
568 columnname: creation_date
570 columnname: last_edit
578 columnname: cache_expiry
580 columnname: saved_results
586 cannot_be_modified: 1
592 columnname: sort_order
594 cannot_be_modified: 1
597 columnname: todays_or_previous_checkouts
599 cannot_be_modified: 1
602 columnname: due_date_unformatted
604 cannot_be_modified: 1
611 columnname: item_type
613 columnname: collection
617 columnname: homebranch
619 columnname: checkout_on_unformatted
621 cannot_be_modified: 1
624 columnname: checkout_on
626 columnname: checkout_from
638 cannot_be_modified: 1
644 cannot_be_modified: 1
649 cannot_be_modified: 1
651 columnname: cardnumber
653 columnname: date_of_birth
674 columnname: homelibrary
676 columnname: holdinglibrary
680 columnname: itemcallnumber
682 columnname: dateaccessioned
696 columnname: collection
698 columnname: document_type
700 columnname: callnumber
702 columnname: copynumber
704 columnname: enumeration
719 columnname: pull_items
721 columnname: avalaible_items
729 columnname: libraries
731 columnname: call_numbers
733 columnname: copy_numbers
735 columnname: enumeration
737 columnname: itemtypes
739 columnname: locations
741 columnname: hold_date
752 columnname: holds_ratio
756 columnname: home_libraries
758 columnname: holding_libraries
764 columnname: call_numbers
766 columnname: items_needed
772 columnname: item_itemtype
774 columnname: item_current_location
776 columnname: item_home_location
778 columnname: item_shelving_location
781 columnname: item_ccode
783 columnname: item_callnumber
785 columnname: item_enumchron
789 columnname: item_copy
791 columnname: item_status
793 columnname: item_notes
795 columnname: item_datedue
797 columnname: item_barcode
800 columnname: item_holds
802 columnname: item_priority
804 columnname: item_coursereserves
808 columnname: serial_serialseq
810 columnname: serial_publisheddate
812 columnname: serial_planneddate
814 columnname: serial_status
816 columnname: serial_notes
826 columnname: ordernumber
828 columnname: creation_date
830 columnname: receive_date
834 columnname: order_internalnote
836 columnname: order_vendornote
856 columnname: copy_notice
860 cannot_be_modified: 1