aqorders

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ordernumber INT 10 √ null
aqorder_users.ordernumber aqorder_users_ibfk_1 C
aqorders_claims.ordernumber aqorders_claims_ibfk_1 C
aqorders_items.ordernumber aqorders_items_ibfk_1 C
aqorders_transfers.ordernumber_from aqorders_transfers_ordernumber_from N
aqorders_transfers.ordernumber_to aqorders_transfers_ordernumber_to N

primary key and unique identifier assigned by Koha to each line
biblionumber INT 10 √ NULL
biblio.biblionumber aqorders_ibfk_2 N

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_currency N

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_3 N

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_by N

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
basketno INT 10 √ NULL
aqbasket.basketno aqorders_ibfk_1 C

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_fk C

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 TINYINT 3 √ NULL

was this price uncertain (1 for yes, 0 for no)
subscriptionid INT 10 √ NULL
subscription.subscriptionid aqorders_subscriptionid N

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_currency N

the currency of the invoice_unitprice

Indexes

Constraint Name Type Sort Column(s)
aqorders_s_pk 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
PRIMARY Must be unique Asc ordernumber

Relationships

Close relationships within degrees of separation