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
257 columnname: homebranch
259 columnname: checkout_on
261 columnname: checkout_from
273 cannot_be_modified: 1
279 cannot_be_modified: 1
286 cannot_be_modified: 1
294 columnname: reservedate
296 columnname: expirationdate
298 columnname: waitingdate
300 columnname: cancellationdate
312 cannot_be_modified: 1
318 columnname: itemlost_on
322 columnname: callnumber
324 columnname: datelastseen
328 columnname: replacementprice
334 columnname: current_location
338 columnname: notforloan
345 columnname: selection
347 cannot_be_modified: 1
349 columnname: report_id
351 cannot_be_modified: 1
353 columnname: report_name
365 columnname: creation_date
367 columnname: last_edit
375 columnname: cache_expiry
377 columnname: saved_results
383 cannot_be_modified: 1
389 columnname: sort_order
391 cannot_be_modified: 1
394 columnname: todays_or_previous_checkouts
396 cannot_be_modified: 1
399 columnname: due_date_unformatted
401 cannot_be_modified: 1
408 columnname: item_type
412 columnname: homebranch
414 columnname: checkout_on
416 columnname: checkout_from
428 cannot_be_modified: 1
434 cannot_be_modified: 1
447 columnname: homelibrary
449 columnname: holdinglibrary
453 columnname: itemcallnumber
455 columnname: dateaccessioned
469 columnname: collection
471 columnname: document_type
473 columnname: callnumber
475 columnname: copynumber
477 columnname: enumeration
492 columnname: pull_items
494 columnname: avalaible_items
502 columnname: libraries
504 columnname: call_numbers
506 columnname: copy_numbers
508 columnname: enumeration
510 columnname: itemtypes
512 columnname: locations
514 columnname: hold_date
522 columnname: item_itemtype
524 columnname: item_current_location
526 columnname: item_home_location
528 columnname: item_shelving_location
531 columnname: item_ccode
533 columnname: item_callnumber
535 columnname: item_enumchron
539 columnname: item_copy
541 columnname: item_status
543 columnname: item_notes
545 columnname: item_datedue
547 columnname: item_barcode
550 columnname: item_holds
552 columnname: item_priority
554 columnname: item_coursereserves
558 columnname: serial_serialseq
560 columnname: serial_publisheddate
562 columnname: serial_planneddate
564 columnname: serial_status
566 columnname: serial_notes