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
80 columnname: last_updated
88 acquisitiondetails-table:
94 columnname: basketgroup
98 columnname: ordernumber
100 columnname: creation_date
102 columnname: received_data
108 columnname: subscription
110 columnname: subscription_callnumber
112 checkoutshistory-table:
116 cannot_be_modified: 1
120 cannot_be_modified: 1
122 columnname: checked_out_from
126 columnname: checkout_on
130 columnname: checkin_on
135 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
136 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
137 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
142 columnname: dateaccessioned
144 columnname: booksellerid
146 columnname: homebranch
150 columnname: replacementprice
152 columnname: replacementpricedate
154 columnname: datelastborrowed
156 columnname: datelastseen
160 columnname: notforloan
166 columnname: withdrawn
168 columnname: itemcallnumber
170 columnname: coded_location_qualifier
172 columnname: restricted
174 columnname: itemnotes
176 columnname: itemnotes_nonpublic
178 columnname: holdingbranch
182 columnname: timestamp
188 columnname: cn_source
192 columnname: materials
198 columnname: enumchron
200 columnname: copynumber
202 columnname: stocknumber
210 columnname: description
216 cannot_be_modified: 1
218 columnname: amountoutstanding
220 cannot_be_modified: 1
224 cannot_be_modified: 1
231 cannot_be_modified: 1
233 columnname: cardnumber
237 columnname: dateofbirth
243 columnname: expires_on
245 columnname: od_checkouts
249 columnname: circ_notes
253 cannot_be_modified: 1
258 columnname: sort_order
260 cannot_be_modified: 1
263 columnname: todays_or_previous_checkouts
265 cannot_be_modified: 1
268 columnname: due_date_unformatted
270 cannot_be_modified: 1
277 columnname: item_type
279 columnname: collection
283 columnname: homebranch
285 columnname: checkout_on
287 columnname: checkout_from
299 cannot_be_modified: 1
305 cannot_be_modified: 1
312 cannot_be_modified: 1
320 columnname: reservedate
322 columnname: expirationdate
324 columnname: waitingdate
326 columnname: cancellationdate
338 cannot_be_modified: 1
344 columnname: itemlost_on
348 columnname: callnumber
350 columnname: datelastseen
354 columnname: replacementprice
360 columnname: current_location
364 columnname: notforloan
371 columnname: selection
373 cannot_be_modified: 1
375 columnname: report_id
377 cannot_be_modified: 1
379 columnname: report_name
391 columnname: creation_date
393 columnname: last_edit
401 columnname: cache_expiry
403 columnname: saved_results
409 cannot_be_modified: 1
415 columnname: sort_order
417 cannot_be_modified: 1
420 columnname: todays_or_previous_checkouts
422 cannot_be_modified: 1
425 columnname: due_date_unformatted
427 cannot_be_modified: 1
434 columnname: item_type
436 columnname: collection
440 columnname: homebranch
442 columnname: checkout_on
444 columnname: checkout_from
456 cannot_be_modified: 1
462 cannot_be_modified: 1
475 columnname: homelibrary
477 columnname: holdinglibrary
481 columnname: itemcallnumber
483 columnname: dateaccessioned
497 columnname: collection
499 columnname: document_type
501 columnname: callnumber
503 columnname: copynumber
505 columnname: enumeration
520 columnname: pull_items
522 columnname: avalaible_items
530 columnname: libraries
532 columnname: call_numbers
534 columnname: copy_numbers
536 columnname: enumeration
538 columnname: itemtypes
540 columnname: locations
542 columnname: hold_date
550 columnname: item_itemtype
552 columnname: item_current_location
554 columnname: item_home_location
556 columnname: item_shelving_location
559 columnname: item_ccode
561 columnname: item_callnumber
563 columnname: item_enumchron
567 columnname: item_copy
569 columnname: item_status
571 columnname: item_notes
573 columnname: item_datedue
575 columnname: item_barcode
578 columnname: item_holds
580 columnname: item_priority
582 columnname: item_coursereserves
586 columnname: serial_serialseq
588 columnname: serial_publisheddate
590 columnname: serial_planneddate
592 columnname: serial_status
594 columnname: serial_notes
604 columnname: ordernumber
606 columnname: creation_date
608 columnname: receive_date
612 columnname: order_internalnote
614 columnname: order_vendornote