LIBRARY ORDER ARRIVAL DETAIL Table
Includes detailed information about Monograph Arrivals (receipts) in Aleph (e.g., arrival date and number of units received). Data in this table is taken from the Z78 table in Aleph.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_ARRIVAL_DATE |
The date of the arrival (Z78-ARRIVAL-DATE) |
DATE |
8 |
LIBRARY_ARRIVAL_NOTE |
Free text note (Z78--ARRIVAL-NOTE) |
VARCHAR2 |
60 |
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_ORDER_ARRIVAL_SEQ |
Sequence number of the arrival within an order record (Z68). (Z78-SEQUENCE) |
VARCHAR2 |
3 |
LIBRARY_ORDER_ARRIVAL_UNITS |
Number of units arrived. (Z78-NO-UNITS-ARRIVED) |
NUMBER |
22 |
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_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 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |