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