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 checkoutshistory-table:
98 columnname: checked_out_from
102 columnname: checkout_on
106 columnname: checkin_on
111 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
112 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
113 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
118 columnname: dateaccessioned
120 columnname: booksellerid
122 columnname: homebranch
126 columnname: replacementprice
128 columnname: replacementpricedate
130 columnname: datelastborrowed
132 columnname: datelastseen
136 columnname: notforloan
142 columnname: withdrawn
144 columnname: itemcallnumber
146 columnname: coded_location_qualifier
148 columnname: restricted
150 columnname: itemnotes
152 columnname: itemnotes_nonpublic
154 columnname: holdingbranch
158 columnname: timestamp
164 columnname: cn_source
168 columnname: materials
174 columnname: enumchron
176 columnname: copynumber
178 columnname: stocknumber
186 columnname: description
192 cannot_be_modified: 1
194 columnname: amountoutstanding
196 cannot_be_modified: 1
200 cannot_be_modified: 1
207 cannot_be_modified: 1
209 columnname: cardnumber
213 columnname: dateofbirth
219 columnname: expires_on
221 columnname: od_checkouts
225 columnname: circ_notes
229 cannot_be_modified: 1
234 columnname: sort_order
236 cannot_be_modified: 1
239 columnname: todays_or_previous_checkouts
241 cannot_be_modified: 1
244 columnname: due_date_unformatted
246 cannot_be_modified: 1
253 columnname: item_type
255 columnname: collection
259 columnname: homebranch
261 columnname: checkout_on
263 columnname: checkout_from
275 cannot_be_modified: 1
281 cannot_be_modified: 1
288 cannot_be_modified: 1
296 columnname: reservedate
298 columnname: expirationdate
300 columnname: waitingdate
302 columnname: cancellationdate
314 cannot_be_modified: 1
320 columnname: itemlost_on
324 columnname: callnumber
326 columnname: datelastseen
330 columnname: replacementprice
336 columnname: current_location
340 columnname: notforloan
347 columnname: selection
349 cannot_be_modified: 1
351 columnname: report_id
353 cannot_be_modified: 1
355 columnname: report_name
367 columnname: creation_date
369 columnname: last_edit
377 columnname: cache_expiry
379 columnname: saved_results
385 cannot_be_modified: 1
391 columnname: sort_order
393 cannot_be_modified: 1
396 columnname: todays_or_previous_checkouts
398 cannot_be_modified: 1
401 columnname: due_date_unformatted
403 cannot_be_modified: 1
410 columnname: item_type
412 columnname: collection
416 columnname: homebranch
418 columnname: checkout_on
420 columnname: checkout_from
432 cannot_be_modified: 1
438 cannot_be_modified: 1
451 columnname: homelibrary
453 columnname: holdinglibrary
457 columnname: itemcallnumber
459 columnname: dateaccessioned
473 columnname: collection
475 columnname: document_type
477 columnname: callnumber
479 columnname: copynumber
481 columnname: enumeration
496 columnname: pull_items
498 columnname: avalaible_items
506 columnname: libraries
508 columnname: call_numbers
510 columnname: copy_numbers
512 columnname: enumeration
514 columnname: itemtypes
516 columnname: locations
518 columnname: hold_date
526 columnname: item_itemtype
528 columnname: item_current_location
530 columnname: item_home_location
532 columnname: item_shelving_location
535 columnname: item_ccode
537 columnname: item_callnumber
539 columnname: item_enumchron
543 columnname: item_copy
545 columnname: item_status
547 columnname: item_notes
549 columnname: item_datedue
551 columnname: item_barcode
554 columnname: item_holds
556 columnname: item_priority
558 columnname: item_coursereserves
562 columnname: serial_serialseq
564 columnname: serial_publisheddate
566 columnname: serial_planneddate
568 columnname: serial_status
570 columnname: serial_notes