columnname: claims_count
-
columnname: claimed_date
+ basket:
+ orders:
+ -
+ columnname: basket_number
+ -
+ columnname: order_information
+ -
+ columnname: recommended_retail_price_tax_excluded
+ -
+ columnname: ecost_tax_excluded
+ -
+ columnname: recommended_retail_price_tax_included
+ is_hidden: 1
+ -
+ columnname: ecost_tax_included
+ is_hidden: 1
+ -
+ columnname: replacement_price
+ -
+ columnname: quantity
+ -
+ columnname: total_tax_excluded
+ -
+ columnname: total_tax_included
+ is_hidden: 1
+ -
+ columnname: goods_and_services_tax_percentage
+ -
+ columnname: goods_and_services_tax
+ -
+ columnname: fund
+ -
+ columnname: supplier_report
+ -
+ columnname: modify
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: cancel
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
admin:
currency:
-
columnname: actions
+ categories:
+ patron_categories:
+ -
+ columnname: code
+ -
+ columnname: category_name
+ -
+ columnname: type
+ -
+ columnname: enrollment_period
+ -
+ columnname: age_required
+ -
+ columnname: upper_age_limit
+ -
+ columnname: enrollment_fee
+ -
+ columnname: overdue
+ -
+ columnname: lost_items
+ -
+ columnname: hold_fee
+ -
+ columnname: messaging
+ -
+ columnname: branches_limitations
+ -
+ columnname: default_privacy
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
+ libraries:
+ libraries:
+ -
+ columnname: library_name
+ -
+ columnname: library_code
+ -
+ columnname: library_address
+ -
+ columnname: marc_organization_code
+ -
+ columnname: library_ip
+ -
+ columnname: is_pickup_location
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
+
+ catalogue:
+ detail:
+ acquisitiondetails-table:
+ -
+ columnname: vendor
+ -
+ columnname: invoice
+ -
+ columnname: basketgroup
+ -
+ columnname: basket
+ -
+ columnname: ordernumber
+ -
+ columnname: creation_date
+ -
+ columnname: received_data
+ -
+ columnname: status
+ -
+ columnname: quantity
+ -
+ columnname: order_internalnote
+ -
+ columnname: subscription
+ -
+ columnname: subscription_callnumber
+
+ checkoutshistory-table:
+ -
+ columnname: patron
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: barcode
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: checked_out_from
+ -
+ columnname: renewed
+ -
+ columnname: checkout_on
+ -
+ columnname: due_date
+ -
+ columnname: checkin_on
+
cataloguing:
additem:
itemst:
# NOTE: These columns are in the same order as kohastructure.sql, and contain all items
# columns except for the following internal/obsolete fields: stack, more_subfields_xml,
- # cn_sort, permanent_location, itemlost_on, withdrawn_on, issues, renewals and reserves.
+ # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
+ # reserves.
-
columnname: barcode
-
-
columnname: stocknumber
+ coursereserves:
+ courses:
+ course_reserves_table:
+ -
+ columnname: name
+ -
+ columnname: department
+ -
+ columnname: course_no
+ -
+ columnname: section
+ -
+ columnname: term
+ -
+ columnname: instructors
+ -
+ columnname: staff_note
+ -
+ columnname: public_note
+ -
+ columnname: no_of_students
+ -
+ columnname: enabled
+
+ reserves:
+ course_reserves_table:
+ -
+ columnname: title
+ -
+ columnname: author
+ -
+ columnname: barcode
+ -
+ columnname: call_number
+ -
+ columnname: item_type
+ -
+ columnname: collection
+ -
+ columnname: location
+ -
+ columnname: library
+ -
+ columnname: staff_note
+ -
+ columnname: public_note
+ -
+ columnname: link
+ -
+ columnname: other_course_reserves
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
+ illrequests:
+ ill-requests:
+ ill-requests:
+ -
+ columnname: illrequest_id
+ -
+ columnname: metadata_author
+ -
+ columnname: metadata_title
+ -
+ columnname: metadata_article_title
+ -
+ columnname: metadata_issue
+ -
+ columnname: metadata_volume
+ -
+ columnname: metadata_year
+ -
+ columnname: metadata_pages
+ -
+ columnname: metadata_type
+ -
+ columnname: orderid
+ -
+ columnname: patron
+ -
+ columnname: biblio_id
+ -
+ columnname: library_branchname
+ -
+ columnname: status
+ -
+ columnname: placed
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ is_hidden: 1
+ -
+ columnname: placed_formatted
+ -
+ columnname: updated
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ is_hidden: 1
+ -
+ columnname: updated_formatted
+ -
+ columnname: replied
+ -
+ columnname: completed
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ is_hidden: 1
+ -
+ columnname: completed_formatted
+ -
+ columnname: accessurl
+ -
+ columnname: cost
+ -
+ columnname: comments
+ -
+ columnname: notesopac
+ -
+ columnname: notesstaff
+ -
+ columnname: backend
+ -
+ columnname: action
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
members:
+ fines:
+ account-fines:
+ -
+ columnname: date
+ -
+ columnname: description
+ -
+ columnname: barcode
+ -
+ columnname: date_due
+ -
+ columnname: returndate
+ -
+ columnname: note
+ -
+ columnname: amount
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: amountoutstanding
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
+ pay:
+ pay-fines-table:
+ -
+ columnname: checkbox
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: description
+ -
+ columnname: date
+ -
+ columnname: barcode
+ -
+ columnname: date_due
+ -
+ columnname: returndate
+ -
+ columnname: note
+ -
+ columnname: account_type
+ -
+ columnname: amount
+ -
+ columnname: amountoutstanding
+
member:
memberresultst:
-
columnname: cardnumber
-
columnname: name
+ -
+ columnname: dateofbirth
-
columnname: category
-
columnname: title
-
columnname: item_type
+ -
+ columnname: collection
-
columnname: location
+ -
+ columnname: homebranch
+ -
+ columnname: checkout_on_unformatted
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ is_hidden: 1
-
columnname: checkout_on
-
columnname: callno
-
columnname: charge
+ -
+ columnname: fine
-
columnname: price
-
cannot_be_modified: 1
-
columnname: checkin
+ -
+ columnname: export
cannot_be_toggled: 1
cannot_be_modified: 1
+
+ holdshistory:
+ holdshistory-table:
-
- columnname: export
+ columnname: title
cannot_be_toggled: 1
cannot_be_modified: 1
+ -
+ columnname: author
+ -
+ columnname: barcode
+ -
+ columnname: branch
+ -
+ columnname: reservedate
+ -
+ columnname: expirationdate
+ -
+ columnname: waitingdate
+ -
+ columnname: cancellationdate
+ -
+ columnname: itemtype
+ -
+ columnname: status
reports:
lostitems:
columnname: author
-
columnname: lostcode
+ -
+ columnname: itemlost_on
-
columnname: barcode
-
columnname: library
-
columnname: itemtype
+ -
+ columnname: collection_code
-
columnname: current_location
-
columnname: location
+ -
+ columnname: notforloan
-
columnname: notes
+ saved-sql:
+ table_reports:
+ -
+ columnname: selection
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: report_id
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: report_name
+ -
+ columnname: type
+ -
+ columnname: group
+ -
+ columnname: subgroup
+ -
+ columnname: notes
+ -
+ columnname: author
+ -
+ columnname: creation_date
+ -
+ columnname: last_edit
+ -
+ columnname: last_run
+ -
+ columnname: public
+ -
+ columnname: json_url
+ -
+ columnname: cache_expiry
+ -
+ columnname: saved_results
+ -
+ columnname: update
+ -
+ columnname: actions
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+
circ:
circulation:
issues-table:
columnname: title
-
columnname: item_type
+ -
+ columnname: collection
-
columnname: location
+ -
+ columnname: homebranch
+ -
+ columnname: checkout_on_unformatted
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ is_hidden: 1
-
columnname: checkout_on
-
columnname: callno
-
columnname: charge
+ -
+ columnname: fine
-
columnname: price
-
cannot_be_modified: 1
-
columnname: checkin
+ -
+ columnname: export
cannot_be_toggled: 1
cannot_be_modified: 1
+ table_borrowers:
-
- columnname: export
+ columnname: name
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: cardnumber
+ -
+ columnname: date_of_birth
+ -
+ columnname: category
+ -
+ columnname: library
+ -
+ columnname: address
+ -
+ columnname: phone
+ is_hidden: 1
+ returns:
+ checkedintable:
+ -
+ columnname: due_date
+ -
+ columnname: title
+ -
+ columnname: author
+ -
+ columnname: barcode
+ -
+ columnname: homelibrary
+ -
+ columnname: holdinglibrary
+ -
+ columnname: location
+ -
+ columnname: itemcallnumber
+ -
+ columnname: dateaccessioned
+ is_hidden: 1
+ -
+ columnname: itype
+ -
+ columnname: borrower
+ -
+ columnname: itemnote
+
+ view_holdsqueue:
+ holds-table:
+ -
+ columnname: title
+ -
+ columnname: collection
+ -
+ columnname: document_type
+ -
+ columnname: callnumber
+ -
+ columnname: copynumber
+ -
+ columnname: enumeration
+ -
+ columnname: barcode
+ -
+ columnname: patron
+ -
+ columnname: send_to
+ -
+ columnname: date
+ -
+ columnname: notes
+
+ holds:
+ holds-to-pull:
+ -
+ columnname: pull_items
+ -
+ columnname: avalaible_items
+ -
+ columnname: patrons
+ -
+ columnname: patron
+ -
+ columnname: title
+ -
+ columnname: libraries
+ -
+ columnname: call_numbers
+ -
+ columnname: copy_numbers
+ -
+ columnname: enumeration
+ -
+ columnname: itemtypes
+ -
+ columnname: locations
+ -
+ columnname: hold_date
+ -
+ columnname: action
+
+ holdsratios:
+ holds-ratios:
+ -
+ columnname: holds
+ -
+ columnname: items
+ -
+ columnname: holds_ratio
+ -
+ columnname: title
+ -
+ columnname: home_libraries
+ -
+ columnname: holding_libraries
+ -
+ columnname: location
+ -
+ columnname: itemtype
+ -
+ columnname: call_numbers
+ -
+ columnname: items_needed
+
+ opac:
+ biblio-detail:
+ holdingst:
+ -
+ columnname: item_itemtype
+ -
+ columnname: item_current_location
+ -
+ columnname: item_home_location
+ -
+ columnname: item_shelving_location
+ is_hidden: 1
+ -
+ columnname: item_ccode
+ -
+ columnname: item_callnumber
+ -
+ columnname: item_enumchron
+ -
+ columnname: item_url
+ -
+ columnname: item_copy
+ -
+ columnname: item_status
+ -
+ columnname: item_notes
+ -
+ columnname: item_datedue
+ -
+ columnname: item_barcode
+ is_hidden: 1
+ -
+ columnname: item_holds
+ -
+ columnname: item_priority
+ -
+ columnname: item_coursereserves
+
+ subscriptionst:
+ -
+ columnname: serial_serialseq
+ -
+ columnname: serial_publisheddate
+ -
+ columnname: serial_planneddate
+ -
+ columnname: serial_status
+ -
+ columnname: serial_notes
+
+ serials:
+ subscription-detail:
+ orders:
+ -
+ columnname: invoice
+ -
+ columnname: basket
+ -
+ columnname: ordernumber
+ -
+ columnname: creation_date
+ -
+ columnname: receive_date
+ -
+ columnname: status
+ -
+ columnname: order_internalnote
+ -
+ columnname: order_vendornote
+ -
+ columnname: fund
+ -
+ columnname: ordered
+ -
+ columnname: spent
+
+ tools:
+ notices:
+ lettert:
+ -
+ columnname: library
+ -
+ columnname: module
+ -
+ columnname: code
+ -
+ columnname: name
+ -
+ columnname: copy_notice
+ -
+ columnname: actions
cannot_be_toggled: 1
cannot_be_modified: 1
projects / koha.git / blobdiff