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
129 acquisitiondetails-table:
135 columnname: basketgroup
139 columnname: ordernumber
141 columnname: creation_date
143 columnname: received_data
149 columnname: subscription
151 columnname: subscription_callnumber
153 checkoutshistory-table:
157 cannot_be_modified: 1
161 cannot_be_modified: 1
163 columnname: checked_out_from
167 columnname: checkout_on
171 columnname: checkin_on
176 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
177 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
178 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
183 columnname: dateaccessioned
185 columnname: booksellerid
187 columnname: homebranch
191 columnname: replacementprice
193 columnname: replacementpricedate
195 columnname: datelastborrowed
197 columnname: datelastseen
201 columnname: notforloan
207 columnname: withdrawn
209 columnname: itemcallnumber
211 columnname: coded_location_qualifier
213 columnname: restricted
215 columnname: itemnotes
217 columnname: itemnotes_nonpublic
219 columnname: holdingbranch
223 columnname: timestamp
229 columnname: cn_source
233 columnname: materials
239 columnname: enumchron
241 columnname: copynumber
243 columnname: stocknumber
247 course_reserves_table:
251 columnname: department
253 columnname: course_no
259 columnname: instructors
261 columnname: staff_note
263 columnname: public_note
265 columnname: no_of_students
270 course_reserves_table:
278 columnname: call_number
280 columnname: item_type
282 columnname: collection
288 columnname: staff_note
290 columnname: public_note
294 columnname: other_course_reserves
298 cannot_be_modified: 1
306 columnname: description
312 cannot_be_modified: 1
314 columnname: amountoutstanding
316 cannot_be_modified: 1
320 cannot_be_modified: 1
327 cannot_be_modified: 1
331 cannot_be_modified: 1
333 columnname: description
339 columnname: account_type
343 columnname: amountoutstanding
350 cannot_be_modified: 1
352 columnname: cardnumber
356 columnname: dateofbirth
362 columnname: expires_on
364 columnname: od_checkouts
368 columnname: circ_notes
372 cannot_be_modified: 1
377 columnname: sort_order
379 cannot_be_modified: 1
382 columnname: todays_or_previous_checkouts
384 cannot_be_modified: 1
387 columnname: due_date_unformatted
389 cannot_be_modified: 1
396 columnname: item_type
398 columnname: collection
402 columnname: homebranch
404 columnname: checkout_on_unformatted
406 cannot_be_modified: 1
409 columnname: checkout_on
411 columnname: checkout_from
423 cannot_be_modified: 1
429 cannot_be_modified: 1
436 cannot_be_modified: 1
444 columnname: reservedate
446 columnname: expirationdate
448 columnname: waitingdate
450 columnname: cancellationdate
462 cannot_be_modified: 1
468 columnname: itemlost_on
472 columnname: callnumber
474 columnname: datelastseen
478 columnname: replacementprice
484 columnname: current_location
488 columnname: notforloan
495 columnname: selection
497 cannot_be_modified: 1
499 columnname: report_id
501 cannot_be_modified: 1
503 columnname: report_name
515 columnname: creation_date
517 columnname: last_edit
525 columnname: cache_expiry
527 columnname: saved_results
533 cannot_be_modified: 1
539 columnname: sort_order
541 cannot_be_modified: 1
544 columnname: todays_or_previous_checkouts
546 cannot_be_modified: 1
549 columnname: due_date_unformatted
551 cannot_be_modified: 1
558 columnname: item_type
560 columnname: collection
564 columnname: homebranch
566 columnname: checkout_on_unformatted
568 cannot_be_modified: 1
571 columnname: checkout_on
573 columnname: checkout_from
585 cannot_be_modified: 1
591 cannot_be_modified: 1
596 cannot_be_modified: 1
598 columnname: cardnumber
600 columnname: date_of_birth
621 columnname: homelibrary
623 columnname: holdinglibrary
627 columnname: itemcallnumber
629 columnname: dateaccessioned
643 columnname: collection
645 columnname: document_type
647 columnname: callnumber
649 columnname: copynumber
651 columnname: enumeration
666 columnname: pull_items
668 columnname: avalaible_items
676 columnname: libraries
678 columnname: call_numbers
680 columnname: copy_numbers
682 columnname: enumeration
684 columnname: itemtypes
686 columnname: locations
688 columnname: hold_date
699 columnname: holds_ratio
703 columnname: home_libraries
705 columnname: holding_libraries
711 columnname: call_numbers
713 columnname: items_needed
719 columnname: item_itemtype
721 columnname: item_current_location
723 columnname: item_home_location
725 columnname: item_shelving_location
728 columnname: item_ccode
730 columnname: item_callnumber
732 columnname: item_enumchron
736 columnname: item_copy
738 columnname: item_status
740 columnname: item_notes
742 columnname: item_datedue
744 columnname: item_barcode
747 columnname: item_holds
749 columnname: item_priority
751 columnname: item_coursereserves
755 columnname: serial_serialseq
757 columnname: serial_publisheddate
759 columnname: serial_planneddate
761 columnname: serial_status
763 columnname: serial_notes
773 columnname: ordernumber
775 columnname: creation_date
777 columnname: receive_date
781 columnname: order_internalnote
783 columnname: order_vendornote
803 columnname: copy_notice
807 cannot_be_modified: 1