LIBRARY TRANSACTION TYPE Table
Includes codes and descriptions for the types of budget transactions (Allocation, Carryover, Encumbrance, Invoice, Transfer). Use this table to limit the query by type of budget activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_ALLOCATION_TRANSACTION |
Use this to limit a query to Allocation Transactions type. (includes Transfers and Carry Forwards). |
VARCHAR2 |
1 |
IS_ENCUMBRANCE_TRANSACTION |
Use this to limit a query to Encumbrance Transactions type. |
VARCHAR2 |
1 |
IS_INVOICE_TRANSACTION |
Use this to limit a query to Invoice Transactions type. |
VARCHAR2 |
1 |
TRANSACTION_CODE |
The code assigned to each transaction by SAP. It may be more meaningful to use the document type. |
VARCHAR2 |
4 |
TRANSACTION_DESCRIPTION |
Description of Transaction Type (e.g., Allocation, Encumbrance, Invoice, etc.) |
VARCHAR2 |
30 |
TRANSACTION_TYPE_KEY |
Key used to join to the LIBRARY_TRANSACTION_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |