LIBRARY ORDER Table
Detailed information about the order records in Aleph (e.g., PO number, vendor code, pricing information, notes, etc.) Most of the data in this table is taken from the Z68 table in Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENCY_CODE |
Three-letter codes for the currency (follows ISO code structure) (e.g., USD, EUR) (Z82-CURRENCY) |
VARCHAR2 |
3 |
LATEST_ORDER_ARRIVAL_DATE |
Used to limit queries for non-serial material by the latest date the latest unit arrived. Note: this indicates the date the unit was received in acquisitions, not cataloged. (Z78-ARRIVAL-DATE) |
DATE |
8 |
LIBRARY_CATALOG_KEY |
Key used to join to the LIBRARY_CATALOG table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_KEY |
Key used to join to the LIBRARY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
LIBRARY_NOTE |
Note associated with the order, for internal use. (Z68-LIBRARY-NOTE) |
VARCHAR2 |
100 |
LIBRARY_ORDER_AMOUNT |
Total price of the order (NUMBER_OF_UNITS times UNIT_PRICE, in USD) (Z68-E-LOCAL-PRICE, referred to as ""Local Price"" in the client, not ""Final Price."") |
NUMBER |
22 |
LIBRARY_ORDER_AMOUNT_ORIG_CURR |
Total price of the order (NUMBER_OF_UNITS times UNIT_PRICE, in the original currency) (Z68-E-PRICE, referred to as ""Final Price"" in the client. DO NOT USE THIS FIELD FOR CALCULATIONS.) |
NUMBER |
22 |
LIBRARY_ORDER_CLAIM_DATE |
The date the next claim for the order should be sent; for Monograph orders only (Z68-EDA) |
DATE |
8 |
LIBRARY_ORDER_DATE |
The date the order was sent to the vendor (Order Status became SV) (Z68-ORDER-DATE) |
DATE |
8 |
LIBRARY_ORDER_KEY |
Key used to join to the LIBRARY_ORDER table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
14 |
LIBRARY_ORDER_NUMBER |
Purchase order number assigned to an order (e.g., 03-1456, D12345, etc.) (Z68-ORDER-NUMBER, referred to as ""Order Number 1"" in the client. ( the Z68-ORDER-NUMBER-1 field corresponds to ""Order Number 2."") |
VARCHAR2 |
30 |
LIBRARY_ORDER_OPEN_DATE |
The date the order record was created (Z68-OPEN-DATE) |
DATE |
8 |
LIBRARY_ORDER_STATUS_KEY |
Key used to join to the LIBRARY_ORDER_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_KEY |
Key used to join to the LIBRARY _ORDER_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_VENDOR_KEY |
Key used to join to the LIBRARY_VENDOR table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
NUMBER_OF_UNITS |
For LIBRARY data: Number of individual items (units) being ordered; usually the number of copies. This number is multiplied by UNIT_PRICE to get LIBRARY_ORDER_AMOUNT. For Serial orders, this number is always 1. (Z68-NO-UNITS) For SUBJECT ENROLLMENT Data, this represent the number of units the student registered for the subject. |
NUMBER |
2 |
ORIGINAL_ORDER_CLAIM_DATE |
The date the first claim for the order should be sent; for Monograph orders only (Z68-ORIGINAL-EDA) |
DATE |
8 |
PRICE_NOTE |
Note associated with the cost of the order; for Serial orders, this has the actual expected cost, rather than the $.01 in the UNIT_PRICE). (Z68-E-NOTE) |
VARCHAR2 |
100 |
QUANTITY_TEXT |
A note about the number of units in the order; used for multi-part Mono orders (Z68-QUANTITY-TEXT, called ""Quantity Note"" in the client) |
VARCHAR2 |
100 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
TARGET_TEXT |
For RUSH orders, name of the user who requested the order. (Z68-TARGET-TEXT) |
VARCHAR2 |
100 |
UNIT_PRICE |
Cost associated with each piece counted in NUMBER_OF_UNITS, converted to USD. For Serial orders, this is always $.01. (Z68-UNIT-PRICE converted to USD) |
NUMBER |
22 |
VENDOR_NOTE |
Note to be sent to the vendor on orders, claims, etc. (Z68-VENDOR-NOTE) |
VARCHAR2 |
100 |
VENDOR_REFERENCE_NUMBER |
A number assigned by the vendor to refer to this order; always used with GOBI orders, used less frequently with other Mono and Serial orders (Z68-VENDOR-REFERENCE-NO) |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |