aqorders

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ordernumber INT 10 √ null
aqorder_users.ordernumber aqorder_users_ibfk_1C
aqorders_claims.ordernumber aqorders_claims_ibfk_1C
aqorders_items.ordernumber aqorders_items_ibfk_1C
aqorders_transfers.ordernumber_from aqorders_transfers_ordernumber_fromN
aqorders_transfers.ordernumber_to aqorders_transfers_ordernumber_toN

primary key and unique identifier assigned by Koha to each line
biblionumber INT 10 √ null
biblio.biblionumber aqorders_ibfk_2N

links the order to the biblio being ordered (biblio.biblionumber)
deleted_biblionumber INT 10 √ null

links the order to the deleted bibliographic record (deletedbiblio.biblionumber)
entrydate DATE 10 √ null

the date the bib was added to the basket
quantity SMALLINT 5 √ null

the quantity ordered
currency VARCHAR 10 √ null
currency.currency aqorders_currencyN

the currency used for the purchase
listprice DECIMAL 28,6 √ null

the vendor price for this line item
datereceived DATE 10 √ null

the date this order was received
invoiceid INT 10 √ null
aqinvoices.invoiceid aqorders_ibfk_3N

id of invoice
freight DECIMAL 28,6 √ null

shipping costs (not used)
unitprice DECIMAL 28,6 √ null

the actual cost entered when receiving this line item
unitprice_tax_excluded DECIMAL 28,6 √ null

the unit price excluding tax (on receiving)
unitprice_tax_included DECIMAL 28,6 √ null

the unit price including tax (on receiving)
quantityreceived SMALLINT 5 0

the quantity that have been received so far
created_by INT 10 √ null
borrowers.borrowernumber aqorders_created_byN

the borrowernumber of order line’s creator
datecancellationprinted DATE 10 √ null

the date the line item was deleted
cancellationreason MEDIUMTEXT 16777215 √ null

reason of cancellation
order_internalnote LONGTEXT 2147483647 √ null

notes related to this order line, made for staff
order_vendornote LONGTEXT 2147483647 √ null

notes related to this order line, made for vendor
purchaseordernumber LONGTEXT 2147483647 √ null

not used? always NULL
basketno INT 10 √ null
aqbasket.basketno aqorders_ibfk_1C

links this order line to a specific basket (aqbasket.basketno)
timestamp TIMESTAMP 19 current_timestamp()

the date and time this order line was last modified
rrp DECIMAL 13,2 √ null

the retail cost for this line item
replacementprice DECIMAL 28,6 √ null

the replacement cost for this line item
rrp_tax_excluded DECIMAL 28,6 √ null

the replacement cost excluding tax
rrp_tax_included DECIMAL 28,6 √ null

the replacement cost including tax
ecost DECIMAL 13,2 √ null

the replacement cost for this line item
ecost_tax_excluded DECIMAL 28,6 √ null

the estimated cost excluding tax
ecost_tax_included DECIMAL 28,6 √ null

the estimated cost including tax
tax_rate_bak DECIMAL 6,4 √ null

the tax rate for this line item (%)
tax_rate_on_ordering DECIMAL 6,4 √ null

the tax rate on ordering for this line item (%)
tax_rate_on_receiving DECIMAL 6,4 √ null

the tax rate on receiving for this line item (%)
tax_value_bak DECIMAL 28,6 √ null

the tax value for this line item
tax_value_on_ordering DECIMAL 28,6 √ null

the tax value on ordering for this line item
tax_value_on_receiving DECIMAL 28,6 √ null

the tax value on receiving for this line item
discount FLOAT 6,4 √ null

the discount for this line item (%)
budget_id INT 10 null
aqbudgets.budget_id aqorders_budget_id_fkC

the fund this order goes against (aqbudgets.budget_id)
budgetdate DATE 10 √ null

not used? always NULL
sort1 VARCHAR 80 √ null

statistical field
sort2 VARCHAR 80 √ null

second statistical field
sort1_authcat VARCHAR 10 √ null
sort2_authcat VARCHAR 10 √ null
uncertainprice BIT 0 √ null

was this price uncertain (1 for yes, 0 for no)
subscriptionid INT 10 √ null
subscription.subscriptionid aqorders_subscriptionidC

links this order line to a subscription (subscription.subscriptionid)
parent_ordernumber INT 10 √ null

ordernumber of parent order line, or same as ordernumber if no parent
orderstatus VARCHAR 16 √ new

the current status for this line item. Can be ‘new’, ‘ordered’, ‘partial’, ‘complete’ or ‘cancelled’
line_item_id VARCHAR 35 √ null

Supplier’s article id for Edifact orderline
suppliers_reference_number VARCHAR 35 √ null

Suppliers unique edifact quote ref
suppliers_reference_qualifier VARCHAR 3 √ null

Type of number above usually ‘QLI’
suppliers_report MEDIUMTEXT 16777215 √ null

reports received from suppliers
estimated_delivery_date DATE 10 √ null

Estimated delivery date
invoice_unitprice DECIMAL 28,6 √ null

the unit price in foreign currency
invoice_currency VARCHAR 10 √ null
currency.currency aqorders_invoice_currencyN

the currency of the invoice_unitprice

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ordernumber
aqorders_created_by Performance Asc created_by
aqorders_currency Performance Asc currency
aqorders_ibfk_3 Performance Asc invoiceid
aqorders_invoice_currency Performance Asc invoice_currency
aqorders_subscriptionid Performance Asc subscriptionid
basketno Performance Asc basketno
biblionumber Performance Asc biblionumber
budget_id Performance Asc budget_id
orderstatus Performance Asc orderstatus
parent_ordernumber Performance Asc parent_ordernumber

Relationships

Close relationships within degrees of separation