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
206 course_reserves_table:
210 columnname: department
212 columnname: course_no
218 columnname: instructors
220 columnname: staff_note
222 columnname: public_note
224 columnname: no_of_students
229 course_reserves_table:
237 columnname: call_number
239 columnname: item_type
241 columnname: collection
247 columnname: staff_note
249 columnname: public_note
253 columnname: other_course_reserves
257 cannot_be_modified: 1
265 columnname: description
271 cannot_be_modified: 1
273 columnname: amountoutstanding
275 cannot_be_modified: 1
279 cannot_be_modified: 1
286 cannot_be_modified: 1
288 columnname: cardnumber
292 columnname: dateofbirth
298 columnname: expires_on
300 columnname: od_checkouts
304 columnname: circ_notes
308 cannot_be_modified: 1
313 columnname: sort_order
315 cannot_be_modified: 1
318 columnname: todays_or_previous_checkouts
320 cannot_be_modified: 1
323 columnname: due_date_unformatted
325 cannot_be_modified: 1
332 columnname: item_type
334 columnname: collection
338 columnname: homebranch
340 columnname: checkout_on
342 columnname: checkout_from
354 cannot_be_modified: 1
360 cannot_be_modified: 1
367 cannot_be_modified: 1
375 columnname: reservedate
377 columnname: expirationdate
379 columnname: waitingdate
381 columnname: cancellationdate
393 cannot_be_modified: 1
399 columnname: itemlost_on
403 columnname: callnumber
405 columnname: datelastseen
409 columnname: replacementprice
415 columnname: current_location
419 columnname: notforloan
426 columnname: selection
428 cannot_be_modified: 1
430 columnname: report_id
432 cannot_be_modified: 1
434 columnname: report_name
446 columnname: creation_date
448 columnname: last_edit
456 columnname: cache_expiry
458 columnname: saved_results
464 cannot_be_modified: 1
470 columnname: sort_order
472 cannot_be_modified: 1
475 columnname: todays_or_previous_checkouts
477 cannot_be_modified: 1
480 columnname: due_date_unformatted
482 cannot_be_modified: 1
489 columnname: item_type
491 columnname: collection
495 columnname: homebranch
497 columnname: checkout_on
499 columnname: checkout_from
511 cannot_be_modified: 1
517 cannot_be_modified: 1
530 columnname: homelibrary
532 columnname: holdinglibrary
536 columnname: itemcallnumber
538 columnname: dateaccessioned
552 columnname: collection
554 columnname: document_type
556 columnname: callnumber
558 columnname: copynumber
560 columnname: enumeration
575 columnname: pull_items
577 columnname: avalaible_items
585 columnname: libraries
587 columnname: call_numbers
589 columnname: copy_numbers
591 columnname: enumeration
593 columnname: itemtypes
595 columnname: locations
597 columnname: hold_date
605 columnname: item_itemtype
607 columnname: item_current_location
609 columnname: item_home_location
611 columnname: item_shelving_location
614 columnname: item_ccode
616 columnname: item_callnumber
618 columnname: item_enumchron
622 columnname: item_copy
624 columnname: item_status
626 columnname: item_notes
628 columnname: item_datedue
630 columnname: item_barcode
633 columnname: item_holds
635 columnname: item_priority
637 columnname: item_coursereserves
641 columnname: serial_serialseq
643 columnname: serial_publisheddate
645 columnname: serial_planneddate
647 columnname: serial_status
649 columnname: serial_notes
659 columnname: ordernumber
661 columnname: creation_date
663 columnname: receive_date
667 columnname: order_internalnote
669 columnname: order_vendornote
689 columnname: copy_notice
693 cannot_be_modified: 1