LIBRARY FUND ORDER MAPPING Table
View exposing relationships between library funds and purchase orders used in acquisitions reporting and financial analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
LIBRARY_FUND_KEY |
Surrogate key identifying the library fund. |
VARCHAR2 |
50 |
LIBRARY_FUND_SEQ |
Library fund seq associated with the record. |
NUMBER |
15 |
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 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |