Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ordernumber | INT | 10 | √ | null |
|
|
primary key and unique identifier assigned by Koha to each line |
|||||||||
| biblionumber | INT | 10 | √ | null |
|
|
links the order to the biblio being ordered (biblio.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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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) |
|||||||||
| claims_count | INT | 10 | √ | 0 |
|
|
count of claim letters generated |
|||||||||
| claimed_date | DATE | 10 | √ | null |
|
|
last date a claim was generated |
|||||||||
| subscriptionid | INT | 10 | √ | null |
|
|
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 |
Table contained 0 rows
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_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
