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) |
|||||||||||
| 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 |
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
