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 acquisitiondetails-table:
169 columnname: basketgroup
173 columnname: ordernumber
175 columnname: creation_date
177 columnname: received_data
183 columnname: subscription
185 columnname: subscription_callnumber
187 checkoutshistory-table:
191 cannot_be_modified: 1
195 cannot_be_modified: 1
197 columnname: checked_out_from
201 columnname: checkout_on
205 columnname: checkin_on
210 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
211 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
212 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
217 columnname: dateaccessioned
219 columnname: booksellerid
221 columnname: homebranch
225 columnname: replacementprice
227 columnname: replacementpricedate
229 columnname: datelastborrowed
231 columnname: datelastseen
235 columnname: notforloan
241 columnname: withdrawn
243 columnname: itemcallnumber
245 columnname: coded_location_qualifier
247 columnname: restricted
249 columnname: itemnotes
251 columnname: itemnotes_nonpublic
253 columnname: holdingbranch
257 columnname: timestamp
263 columnname: cn_source
267 columnname: materials
273 columnname: enumchron
275 columnname: copynumber
277 columnname: stocknumber
281 course_reserves_table:
285 columnname: department
287 columnname: course_no
293 columnname: instructors
295 columnname: staff_note
297 columnname: public_note
299 columnname: no_of_students
304 course_reserves_table:
312 columnname: call_number
314 columnname: item_type
316 columnname: collection
322 columnname: staff_note
324 columnname: public_note
328 columnname: other_course_reserves
332 cannot_be_modified: 1
340 columnname: description
346 cannot_be_modified: 1
348 columnname: amountoutstanding
350 cannot_be_modified: 1
354 cannot_be_modified: 1
361 cannot_be_modified: 1
365 cannot_be_modified: 1
367 columnname: description
373 columnname: account_type
377 columnname: amountoutstanding
384 cannot_be_modified: 1
386 columnname: cardnumber
390 columnname: dateofbirth
396 columnname: expires_on
398 columnname: od_checkouts
402 columnname: circ_notes
406 cannot_be_modified: 1
411 columnname: sort_order
413 cannot_be_modified: 1
416 columnname: todays_or_previous_checkouts
418 cannot_be_modified: 1
421 columnname: due_date_unformatted
423 cannot_be_modified: 1
430 columnname: item_type
432 columnname: collection
436 columnname: homebranch
438 columnname: checkout_on_unformatted
440 cannot_be_modified: 1
443 columnname: checkout_on
445 columnname: checkout_from
457 cannot_be_modified: 1
463 cannot_be_modified: 1
470 cannot_be_modified: 1
478 columnname: reservedate
480 columnname: expirationdate
482 columnname: waitingdate
484 columnname: cancellationdate
496 cannot_be_modified: 1
502 columnname: itemlost_on
506 columnname: callnumber
508 columnname: datelastseen
512 columnname: replacementprice
518 columnname: current_location
522 columnname: notforloan
529 columnname: selection
531 cannot_be_modified: 1
533 columnname: report_id
535 cannot_be_modified: 1
537 columnname: report_name
549 columnname: creation_date
551 columnname: last_edit
559 columnname: cache_expiry
561 columnname: saved_results
567 cannot_be_modified: 1
573 columnname: sort_order
575 cannot_be_modified: 1
578 columnname: todays_or_previous_checkouts
580 cannot_be_modified: 1
583 columnname: due_date_unformatted
585 cannot_be_modified: 1
592 columnname: item_type
594 columnname: collection
598 columnname: homebranch
600 columnname: checkout_on_unformatted
602 cannot_be_modified: 1
605 columnname: checkout_on
607 columnname: checkout_from
619 cannot_be_modified: 1
625 cannot_be_modified: 1
630 cannot_be_modified: 1
632 columnname: cardnumber
634 columnname: date_of_birth
655 columnname: homelibrary
657 columnname: holdinglibrary
661 columnname: itemcallnumber
663 columnname: dateaccessioned
677 columnname: collection
679 columnname: document_type
681 columnname: callnumber
683 columnname: copynumber
685 columnname: enumeration
700 columnname: pull_items
702 columnname: avalaible_items
710 columnname: libraries
712 columnname: call_numbers
714 columnname: copy_numbers
716 columnname: enumeration
718 columnname: itemtypes
720 columnname: locations
722 columnname: hold_date
733 columnname: holds_ratio
737 columnname: home_libraries
739 columnname: holding_libraries
745 columnname: call_numbers
747 columnname: items_needed
753 columnname: item_itemtype
755 columnname: item_current_location
757 columnname: item_home_location
759 columnname: item_shelving_location
762 columnname: item_ccode
764 columnname: item_callnumber
766 columnname: item_enumchron
770 columnname: item_copy
772 columnname: item_status
774 columnname: item_notes
776 columnname: item_datedue
778 columnname: item_barcode
781 columnname: item_holds
783 columnname: item_priority
785 columnname: item_coursereserves
789 columnname: serial_serialseq
791 columnname: serial_publisheddate
793 columnname: serial_planneddate
795 columnname: serial_status
797 columnname: serial_notes
807 columnname: ordernumber
809 columnname: creation_date
811 columnname: receive_date
815 columnname: order_internalnote
817 columnname: order_vendornote
837 columnname: copy_notice
841 cannot_be_modified: 1