LIBRARY INVOICE DETAIL Table
View exposing library invoice transaction records including vendor identifiers, fund attributes, invoice status, invoice types, and invoice amounts used for acquisitions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENCY_CODE |
Code identifying currency. |
VARCHAR2 |
3 |
CURRENCY_RATIO |
Currency ratio associated with the record. |
NUMBER |
12,6 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
INVOICE_LINE_ITEM_NOTE |
Invoice line item note associated with the record. |
VARCHAR2 |
200 |
INVOICE_NUMBER_OF_UNITS |
Invoice number of units associated with the record. |
NUMBER |
5 |
LIBRARY_FUND_KEY |
Surrogate key identifying the library fund. |
VARCHAR2 |
50 |
LIBRARY_INVOICE_DATE |
Date associated with library invoice. |
DATE |
|
LIBRARY_INVOICE_LINE_ITEM |
Library invoice line item associated with the record. |
NUMBER |
5 |
LIBRARY_INVOICE_NOTE |
Library invoice note associated with the record. |
VARCHAR2 |
60 |
LIBRARY_INVOICE_NUMBER |
Library invoice number associated with the record. |
VARCHAR2 |
15 |
LIBRARY_INVOICE_PAYMENT_DATE |
Date associated with library invoice payment. |
DATE |
|
LIBRARY_INVOICE_RECEIVED_DATE |
Date associated with library invoice received. |
DATE |
|
LIBRARY_INVOICE_STATUS_KEY |
Surrogate key identifying the library invoice status. |
VARCHAR2 |
10 |
LIBRARY_INVOICE_TYPE_KEY |
Surrogate key identifying the library invoice type. |
VARCHAR2 |
10 |
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 |
MATERIAL_SHIPPED_DATE |
Date associated with material shipped. |
DATE |
|
ORIGINAL_INVOICE_NUMBER |
Original invoice number associated with the record. |
VARCHAR2 |
15 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
TOTAL_INVOICE_AMOUNT |
Total invoice amount associated with the record. |
NUMBER |
15,2 |
TOTAL_INVOICE_AMOUNT_ORIG_CURR |
Total invoice amount orig curr associated with the record. |
NUMBER |
15,2 |
TRANSACTION_AMOUNT |
Transaction amount associated with the record. |
NUMBER |
15,2 |
TRANSACTION_AMOUNT_ORIG_CURR |
Transaction amount orig curr associated with the record. |
NUMBER |
15,2 |
TRANSACTION_DATE |
Date associated with transaction. |
DATE |
|
TRANSACTION_NOTE |
Transaction note associated with the record. |
VARCHAR2 |
200 |
TRANSACTION_SORT_SEQUENCE |
Transaction sort sequence associated with the record. |
VARCHAR2 |
15 |
TRANSACTION_USER |
Transaction user associated with the record. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |