LIBRARY ALLOCATION DETAIL Table
View exposing library fund allocation detail records including fund identifiers, allocation amounts, fiscal attributes, and related allocation references used for financial reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALLOCATION_AMOUNT |
Allocation amount associated with the record. |
NUMBER |
15,2 |
LIBRARY_FUND_KEY |
Surrogate key identifying the library fund. |
VARCHAR2 |
50 |
NOTE |
Note associated with the record. |
VARCHAR2 |
200 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
TRANSACTION_DATE |
Date associated with transaction. |
DATE |
|
TRANSACTION_SORT_SEQUENCE |
Transaction sort sequence associated with the record. |
VARCHAR2 |
15 |
TRANSACTION_TYPE_KEY |
Surrogate key identifying the transaction type. |
VARCHAR2 |
3 |
TRANSACTION_USER |
Transaction user associated with the record. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |