LIBRARY ORDER ARRIVAL DETAIL Table
View exposing library order arrival transaction records including receipt dates and item receipt attributes used for acquisitions tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_ARRIVAL_DATE |
Date associated with library arrival. |
DATE |
|
LIBRARY_ARRIVAL_NOTE |
Library arrival note associated with the record. |
VARCHAR2 |
60 |
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
LIBRARY_KEY |
Surrogate key identifying the library. |
VARCHAR2 |
3 |
LIBRARY_ORDER_ARRIVAL_SEQ |
Library order arrival seq associated with the record. |
VARCHAR2 |
3 |
LIBRARY_ORDER_ARRIVAL_UNITS |
Library order arrival units associated with the record. |
NUMBER |
5 |
LIBRARY_ORDER_KEY |
Surrogate key identifying the library order. |
VARCHAR2 |
14 |
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 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |