LIBRARY ORDER Table
View exposing library purchase order records including vendor identifiers, fund attributes, order types, order status, and order amounts used for acquisitions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENCY_CODE |
Code identifying currency. |
VARCHAR2 |
3 |
LATEST_ORDER_ARRIVAL_DATE |
Date associated with latest order arrival. |
DATE |
|
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
LIBRARY_KEY |
Surrogate key identifying the library. |
VARCHAR2 |
3 |
LIBRARY_NOTE |
Library note associated with the record. |
VARCHAR2 |
200 |
LIBRARY_ORDER_AMOUNT |
Library order amount associated with the record. |
NUMBER |
15,2 |
LIBRARY_ORDER_AMOUNT_ORIG_CURR |
Library order amount orig curr associated with the record. |
NUMBER |
15,2 |
LIBRARY_ORDER_CLAIM_DATE |
Date associated with library order claim. |
DATE |
|
LIBRARY_ORDER_DATE |
Date associated with library order. |
DATE |
|
LIBRARY_ORDER_KEY |
Surrogate key identifying the library order. |
VARCHAR2 |
14 |
LIBRARY_ORDER_NUMBER |
Library order number associated with the record. |
VARCHAR2 |
30 |
LIBRARY_ORDER_OPEN_DATE |
Date associated with library order open. |
DATE |
|
LIBRARY_ORDER_STATUS_KEY |
Surrogate key identifying the library order status. |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_KEY |
Surrogate key identifying the library order type. |
VARCHAR2 |
20 |
LIBRARY_VENDOR_KEY |
Surrogate key identifying the library vendor. |
VARCHAR2 |
20 |
NUMBER_OF_UNITS |
Number of units associated with the record. |
NUMBER |
5 |
ORIGINAL_ORDER_CLAIM_DATE |
Date associated with original order claim. |
DATE |
|
PRICE_NOTE |
Price note associated with the record. |
VARCHAR2 |
200 |
QUANTITY_TEXT |
Quantity text associated with the record. |
VARCHAR2 |
200 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
TARGET_TEXT |
Target text associated with the record. |
VARCHAR2 |
200 |
UNIT_PRICE |
Unit price associated with the record. |
NUMBER |
15,2 |
VENDOR_NOTE |
Vendor note associated with the record. |
VARCHAR2 |
200 |
VENDOR_REFERENCE_NUMBER |
Vendor reference number associated with the record. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |