Koha::Schema::Result::Aqorder
aqorders
data_type: 'integer' is_auto_increment: 1 is_nullable: 0
primary key and unique identifier assigned by Koha to each line
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
links the order to the biblio being ordered (biblio.biblionumber)
data_type: 'integer' is_nullable: 1
links the order to the deleted bibliographic record (deletedbiblio.biblionumber)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date the bib was added to the basket
data_type: 'smallint' is_nullable: 1
the quantity ordered
data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10
the currency used for the purchase
data_type: 'decimal' is_nullable: 1 size: [28,6]
the vendor price for this line item
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date this order was received
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
id of invoice
data_type: 'decimal' is_nullable: 1 size: [28,6]
shipping costs (not used)
data_type: 'decimal' is_nullable: 1 size: [28,6]
the actual cost entered when receiving this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the unit price excluding tax (on receiving)
data_type: 'decimal' is_nullable: 1 size: [28,6]
the unit price including tax (on receiving)
data_type: 'smallint' default_value: 0 is_nullable: 0
the quantity that have been received so far
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
the borrowernumber of order line's creator
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date the line item was deleted
data_type: 'mediumtext' is_nullable: 1
reason of cancellation
data_type: 'longtext' is_nullable: 1
notes related to this order line, made for staff
data_type: 'longtext' is_nullable: 1
notes related to this order line, made for vendor
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
links this order line to a specific basket (aqbasket.basketno)
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
the date and time this order line was last modified
data_type: 'decimal' is_nullable: 1 size: [13,2]
the retail cost for this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the replacement cost for this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the replacement cost excluding tax
data_type: 'decimal' is_nullable: 1 size: [28,6]
the replacement cost including tax
data_type: 'decimal' is_nullable: 1 size: [13,2]
the replacement cost for this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the estimated cost excluding tax
data_type: 'decimal' is_nullable: 1 size: [28,6]
the estimated cost including tax
data_type: 'decimal' is_nullable: 1 size: [6,4]
the tax rate for this line item (%)
data_type: 'decimal' is_nullable: 1 size: [6,4]
the tax rate on ordering for this line item (%)
data_type: 'decimal' is_nullable: 1 size: [6,4]
the tax rate on receiving for this line item (%)
data_type: 'decimal' is_nullable: 1 size: [28,6]
the tax value for this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the tax value on ordering for this line item
data_type: 'decimal' is_nullable: 1 size: [28,6]
the tax value on receiving for this line item
data_type: 'float' is_nullable: 1 size: [6,4]
the discount for this line item (%)
data_type: 'integer' is_foreign_key: 1 is_nullable: 0
the fund this order goes against (aqbudgets.budget_id)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
not used? always NULL
data_type: 'varchar' is_nullable: 1 size: 80
statistical field
data_type: 'varchar' is_nullable: 1 size: 80
second statistical field
data_type: 'varchar' is_nullable: 1 size: 10
data_type: 'varchar' is_nullable: 1 size: 10
data_type: 'tinyint' is_nullable: 1
was this price uncertain (1 for yes, 0 for no)
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
links this order line to a subscription (subscription.subscriptionid)
data_type: 'integer' is_nullable: 1
ordernumber of parent order line, or same as ordernumber if no parent
data_type: 'varchar' default_value: 'new' is_nullable: 1 size: 16
the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled'
data_type: 'varchar' is_nullable: 1 size: 35
Supplier's article id for Edifact orderline
data_type: 'varchar' is_nullable: 1 size: 35
Suppliers unique edifact quote ref
data_type: 'varchar' is_nullable: 1 size: 3
Type of number above usually 'QLI'
data_type: 'mediumtext' is_nullable: 1
reports received from suppliers
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
Estimated delivery date
data_type: 'decimal' is_nullable: 1 size: [28,6]
the unit price in foreign currency
data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10
the currency of the invoice_unitprice
Type: has_many
Related object: Koha::Schema::Result::AqorderUser
Type: has_many
Related object: Koha::Schema::Result::AqordersClaim
Type: has_many
Related object: Koha::Schema::Result::AqordersItem
Type: might_have
Related object: Koha::Schema::Result::AqordersTransfer
Type: might_have
Related object: Koha::Schema::Result::AqordersTransfer
Type: belongs_to
Related object: Koha::Schema::Result::Aqbasket
Type: belongs_to
Related object: Koha::Schema::Result::Biblio
Type: belongs_to
Related object: Koha::Schema::Result::Aqbudget
Type: belongs_to
Related object: Koha::Schema::Result::Borrower
Type: belongs_to
Related object: Koha::Schema::Result::Currency
Type: belongs_to
Related object: Koha::Schema::Result::Currency
Type: belongs_to
Related object: Koha::Schema::Result::Aqinvoice
Type: belongs_to
Related object: Koha::Schema::Result::Subscription
Type: many_to_many
Composing rels: "aqorder_users" -> borrowernumber
Type: belongs_to
Related object: Koha::Schema::Result::Borrower