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
79 columnname: replacement_price
83 columnname: total_tax_excluded
85 columnname: total_tax_included
88 columnname: goods_and_services_tax_percentage
90 columnname: goods_and_services_tax
94 columnname: supplier_report
102 cannot_be_modified: 1
110 cannot_be_modified: 1
114 cannot_be_modified: 1
121 columnname: last_updated
132 columnname: category_name
136 columnname: enrollment_period
138 columnname: age_required
140 columnname: upper_age_limit
142 columnname: enrollment_fee
146 columnname: lost_items
150 columnname: messaging
152 columnname: branches_limitations
154 columnname: default_privacy
158 cannot_be_modified: 1
163 columnname: library_name
165 columnname: library_code
167 columnname: library_address
169 columnname: marc_organization_code
171 columnname: library_ip
173 columnname: is_pickup_location
177 cannot_be_modified: 1
182 acquisitiondetails-table:
188 columnname: basketgroup
192 columnname: ordernumber
194 columnname: creation_date
196 columnname: received_data
202 columnname: order_internalnote
204 columnname: subscription
206 columnname: subscription_callnumber
208 checkoutshistory-table:
212 cannot_be_modified: 1
216 cannot_be_modified: 1
218 columnname: checked_out_from
222 columnname: checkout_on
226 columnname: checkin_on
231 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
232 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
233 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
238 columnname: dateaccessioned
240 columnname: booksellerid
242 columnname: homebranch
246 columnname: replacementprice
248 columnname: replacementpricedate
250 columnname: datelastborrowed
252 columnname: datelastseen
256 columnname: notforloan
262 columnname: withdrawn
264 columnname: itemcallnumber
266 columnname: coded_location_qualifier
268 columnname: restricted
270 columnname: itemnotes
272 columnname: itemnotes_nonpublic
274 columnname: holdingbranch
278 columnname: timestamp
284 columnname: cn_source
288 columnname: materials
294 columnname: enumchron
296 columnname: copynumber
298 columnname: stocknumber
302 course_reserves_table:
306 columnname: department
308 columnname: course_no
314 columnname: instructors
316 columnname: staff_note
318 columnname: public_note
320 columnname: no_of_students
325 course_reserves_table:
333 columnname: call_number
335 columnname: item_type
337 columnname: collection
343 columnname: staff_note
345 columnname: public_note
349 columnname: other_course_reserves
353 cannot_be_modified: 1
359 columnname: illrequest_id
361 columnname: metadata_author
363 columnname: metadata_title
365 columnname: metadata_article_title
367 columnname: metadata_issue
369 columnname: metadata_volume
371 columnname: metadata_year
373 columnname: metadata_pages
375 columnname: metadata_type
381 columnname: biblio_id
383 columnname: library_branchname
389 cannot_be_modified: 1
392 columnname: placed_formatted
396 cannot_be_modified: 1
399 columnname: updated_formatted
403 columnname: completed
405 cannot_be_modified: 1
408 columnname: completed_formatted
410 columnname: accessurl
416 columnname: notesopac
418 columnname: notesstaff
424 cannot_be_modified: 1
432 columnname: description
438 columnname: returndate
444 cannot_be_modified: 1
446 columnname: amountoutstanding
448 cannot_be_modified: 1
452 cannot_be_modified: 1
459 cannot_be_modified: 1
463 cannot_be_modified: 1
465 columnname: description
473 columnname: returndate
477 columnname: account_type
481 columnname: amountoutstanding
488 cannot_be_modified: 1
490 columnname: cardnumber
494 columnname: dateofbirth
500 columnname: expires_on
502 columnname: od_checkouts
506 columnname: circ_notes
510 cannot_be_modified: 1
515 columnname: sort_order
517 cannot_be_modified: 1
520 columnname: todays_or_previous_checkouts
522 cannot_be_modified: 1
525 columnname: due_date_unformatted
527 cannot_be_modified: 1
534 columnname: item_type
536 columnname: collection
540 columnname: homebranch
542 columnname: checkout_on_unformatted
544 cannot_be_modified: 1
547 columnname: checkout_on
549 columnname: checkout_from
561 cannot_be_modified: 1
567 cannot_be_modified: 1
574 cannot_be_modified: 1
582 columnname: reservedate
584 columnname: expirationdate
586 columnname: waitingdate
588 columnname: cancellationdate
600 cannot_be_modified: 1
606 columnname: itemlost_on
610 columnname: callnumber
612 columnname: datelastseen
616 columnname: replacementprice
622 columnname: collection_code
624 columnname: current_location
628 columnname: notforloan
635 columnname: selection
637 cannot_be_modified: 1
639 columnname: report_id
641 cannot_be_modified: 1
643 columnname: report_name
655 columnname: creation_date
657 columnname: last_edit
665 columnname: cache_expiry
667 columnname: saved_results
673 cannot_be_modified: 1
679 columnname: sort_order
681 cannot_be_modified: 1
684 columnname: todays_or_previous_checkouts
686 cannot_be_modified: 1
689 columnname: due_date_unformatted
691 cannot_be_modified: 1
698 columnname: item_type
700 columnname: collection
704 columnname: homebranch
706 columnname: checkout_on_unformatted
708 cannot_be_modified: 1
711 columnname: checkout_on
713 columnname: checkout_from
725 cannot_be_modified: 1
731 cannot_be_modified: 1
736 cannot_be_modified: 1
738 columnname: cardnumber
740 columnname: date_of_birth
761 columnname: homelibrary
763 columnname: holdinglibrary
767 columnname: itemcallnumber
769 columnname: dateaccessioned
783 columnname: collection
785 columnname: document_type
787 columnname: callnumber
789 columnname: copynumber
791 columnname: enumeration
806 columnname: pull_items
808 columnname: avalaible_items
816 columnname: libraries
818 columnname: call_numbers
820 columnname: copy_numbers
822 columnname: enumeration
824 columnname: itemtypes
826 columnname: locations
828 columnname: hold_date
839 columnname: holds_ratio
843 columnname: home_libraries
845 columnname: holding_libraries
851 columnname: call_numbers
853 columnname: items_needed
859 columnname: item_itemtype
861 columnname: item_current_location
863 columnname: item_home_location
865 columnname: item_shelving_location
868 columnname: item_ccode
870 columnname: item_callnumber
872 columnname: item_enumchron
876 columnname: item_copy
878 columnname: item_status
880 columnname: item_notes
882 columnname: item_datedue
884 columnname: item_barcode
887 columnname: item_holds
889 columnname: item_priority
891 columnname: item_coursereserves
895 columnname: serial_serialseq
897 columnname: serial_publisheddate
899 columnname: serial_planneddate
901 columnname: serial_status
903 columnname: serial_notes
913 columnname: ordernumber
915 columnname: creation_date
917 columnname: receive_date
921 columnname: order_internalnote
923 columnname: order_vendornote
943 columnname: copy_notice
947 cannot_be_modified: 1