LIBRARY FUND ORDER MAPPING Table
Includes only fields containing Keys for linking tables together. Use to join the LIBRARY_FUND, LIBRARY_ORDER, LIBRARY_CATALOG, LIBRARY_ORDER_TYPE AND LIBRARY_ORDER_STATUS tables.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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_FUND_KEY |
Key used to join to the LIBRARY_FUND table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_FUND_SEQ |
Used as a unique identifier of the transaction record. Records are sorted by this number in the display list. (Z601-SEQUENCE) |
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 |
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 |