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
81 columnname: total_tax_excluded
83 columnname: total_tax_included
86 columnname: goods_and_services_tax_percentage
88 columnname: goods_and_services_tax
92 columnname: supplier_report
100 cannot_be_modified: 1
108 cannot_be_modified: 1
112 cannot_be_modified: 1
119 columnname: last_updated
127 acquisitiondetails-table:
133 columnname: basketgroup
137 columnname: ordernumber
139 columnname: creation_date
141 columnname: received_data
147 columnname: subscription
149 columnname: subscription_callnumber
151 checkoutshistory-table:
155 cannot_be_modified: 1
159 cannot_be_modified: 1
161 columnname: checked_out_from
165 columnname: checkout_on
169 columnname: checkin_on
174 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
175 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
176 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
181 columnname: dateaccessioned
183 columnname: booksellerid
185 columnname: homebranch
189 columnname: replacementprice
191 columnname: replacementpricedate
193 columnname: datelastborrowed
195 columnname: datelastseen
199 columnname: notforloan
205 columnname: withdrawn
207 columnname: itemcallnumber
209 columnname: coded_location_qualifier
211 columnname: restricted
213 columnname: itemnotes
215 columnname: itemnotes_nonpublic
217 columnname: holdingbranch
221 columnname: timestamp
227 columnname: cn_source
231 columnname: materials
237 columnname: enumchron
239 columnname: copynumber
241 columnname: stocknumber
245 course_reserves_table:
249 columnname: department
251 columnname: course_no
257 columnname: instructors
259 columnname: staff_note
261 columnname: public_note
263 columnname: no_of_students
268 course_reserves_table:
276 columnname: call_number
278 columnname: item_type
280 columnname: collection
286 columnname: staff_note
288 columnname: public_note
292 columnname: other_course_reserves
296 cannot_be_modified: 1
304 columnname: description
310 cannot_be_modified: 1
312 columnname: amountoutstanding
314 cannot_be_modified: 1
318 cannot_be_modified: 1
325 cannot_be_modified: 1
327 columnname: cardnumber
331 columnname: dateofbirth
337 columnname: expires_on
339 columnname: od_checkouts
343 columnname: circ_notes
347 cannot_be_modified: 1
352 columnname: sort_order
354 cannot_be_modified: 1
357 columnname: todays_or_previous_checkouts
359 cannot_be_modified: 1
362 columnname: due_date_unformatted
364 cannot_be_modified: 1
371 columnname: item_type
373 columnname: collection
377 columnname: homebranch
379 columnname: checkout_on
381 columnname: checkout_from
393 cannot_be_modified: 1
399 cannot_be_modified: 1
406 cannot_be_modified: 1
414 columnname: reservedate
416 columnname: expirationdate
418 columnname: waitingdate
420 columnname: cancellationdate
432 cannot_be_modified: 1
438 columnname: itemlost_on
442 columnname: callnumber
444 columnname: datelastseen
448 columnname: replacementprice
454 columnname: current_location
458 columnname: notforloan
465 columnname: selection
467 cannot_be_modified: 1
469 columnname: report_id
471 cannot_be_modified: 1
473 columnname: report_name
485 columnname: creation_date
487 columnname: last_edit
495 columnname: cache_expiry
497 columnname: saved_results
503 cannot_be_modified: 1
509 columnname: sort_order
511 cannot_be_modified: 1
514 columnname: todays_or_previous_checkouts
516 cannot_be_modified: 1
519 columnname: due_date_unformatted
521 cannot_be_modified: 1
528 columnname: item_type
530 columnname: collection
534 columnname: homebranch
536 columnname: checkout_on
538 columnname: checkout_from
550 cannot_be_modified: 1
556 cannot_be_modified: 1
569 columnname: homelibrary
571 columnname: holdinglibrary
575 columnname: itemcallnumber
577 columnname: dateaccessioned
591 columnname: collection
593 columnname: document_type
595 columnname: callnumber
597 columnname: copynumber
599 columnname: enumeration
614 columnname: pull_items
616 columnname: avalaible_items
624 columnname: libraries
626 columnname: call_numbers
628 columnname: copy_numbers
630 columnname: enumeration
632 columnname: itemtypes
634 columnname: locations
636 columnname: hold_date
644 columnname: item_itemtype
646 columnname: item_current_location
648 columnname: item_home_location
650 columnname: item_shelving_location
653 columnname: item_ccode
655 columnname: item_callnumber
657 columnname: item_enumchron
661 columnname: item_copy
663 columnname: item_status
665 columnname: item_notes
667 columnname: item_datedue
669 columnname: item_barcode
672 columnname: item_holds
674 columnname: item_priority
676 columnname: item_coursereserves
680 columnname: serial_serialseq
682 columnname: serial_publisheddate
684 columnname: serial_planneddate
686 columnname: serial_status
688 columnname: serial_notes
698 columnname: ordernumber
700 columnname: creation_date
702 columnname: receive_date
706 columnname: order_internalnote
708 columnname: order_vendornote
728 columnname: copy_notice
732 cannot_be_modified: 1