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 columnname: returndate
371 cannot_be_modified: 1
373 columnname: amountoutstanding
375 cannot_be_modified: 1
379 cannot_be_modified: 1
386 cannot_be_modified: 1
390 cannot_be_modified: 1
392 columnname: description
400 columnname: returndate
404 columnname: account_type
408 columnname: amountoutstanding
415 cannot_be_modified: 1
417 columnname: cardnumber
421 columnname: dateofbirth
427 columnname: expires_on
429 columnname: od_checkouts
433 columnname: circ_notes
437 cannot_be_modified: 1
442 columnname: sort_order
444 cannot_be_modified: 1
447 columnname: todays_or_previous_checkouts
449 cannot_be_modified: 1
452 columnname: due_date_unformatted
454 cannot_be_modified: 1
461 columnname: item_type
463 columnname: collection
467 columnname: homebranch
469 columnname: checkout_on_unformatted
471 cannot_be_modified: 1
474 columnname: checkout_on
476 columnname: checkout_from
488 cannot_be_modified: 1
494 cannot_be_modified: 1
501 cannot_be_modified: 1
509 columnname: reservedate
511 columnname: expirationdate
513 columnname: waitingdate
515 columnname: cancellationdate
527 cannot_be_modified: 1
533 columnname: itemlost_on
537 columnname: callnumber
539 columnname: datelastseen
543 columnname: replacementprice
549 columnname: current_location
553 columnname: notforloan
560 columnname: selection
562 cannot_be_modified: 1
564 columnname: report_id
566 cannot_be_modified: 1
568 columnname: report_name
580 columnname: creation_date
582 columnname: last_edit
590 columnname: cache_expiry
592 columnname: saved_results
598 cannot_be_modified: 1
604 columnname: sort_order
606 cannot_be_modified: 1
609 columnname: todays_or_previous_checkouts
611 cannot_be_modified: 1
614 columnname: due_date_unformatted
616 cannot_be_modified: 1
623 columnname: item_type
625 columnname: collection
629 columnname: homebranch
631 columnname: checkout_on_unformatted
633 cannot_be_modified: 1
636 columnname: checkout_on
638 columnname: checkout_from
650 cannot_be_modified: 1
656 cannot_be_modified: 1
661 cannot_be_modified: 1
663 columnname: cardnumber
665 columnname: date_of_birth
686 columnname: homelibrary
688 columnname: holdinglibrary
692 columnname: itemcallnumber
694 columnname: dateaccessioned
708 columnname: collection
710 columnname: document_type
712 columnname: callnumber
714 columnname: copynumber
716 columnname: enumeration
731 columnname: pull_items
733 columnname: avalaible_items
741 columnname: libraries
743 columnname: call_numbers
745 columnname: copy_numbers
747 columnname: enumeration
749 columnname: itemtypes
751 columnname: locations
753 columnname: hold_date
764 columnname: holds_ratio
768 columnname: home_libraries
770 columnname: holding_libraries
776 columnname: call_numbers
778 columnname: items_needed
784 columnname: item_itemtype
786 columnname: item_current_location
788 columnname: item_home_location
790 columnname: item_shelving_location
793 columnname: item_ccode
795 columnname: item_callnumber
797 columnname: item_enumchron
801 columnname: item_copy
803 columnname: item_status
805 columnname: item_notes
807 columnname: item_datedue
809 columnname: item_barcode
812 columnname: item_holds
814 columnname: item_priority
816 columnname: item_coursereserves
820 columnname: serial_serialseq
822 columnname: serial_publisheddate
824 columnname: serial_planneddate
826 columnname: serial_status
828 columnname: serial_notes
838 columnname: ordernumber
840 columnname: creation_date
842 columnname: receive_date
846 columnname: order_internalnote
848 columnname: order_vendornote
868 columnname: copy_notice
872 cannot_be_modified: 1