FV_XLA_TRANSACTION_LINES
"This table contains the federal specific sources required during the federal subledger budgetary accounting of Purchasing, Payables, Costing, Receiving and Federal. This table will be populated during subledger accounting process."
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
FV_XLA_TRANSACTION_LINES_PK |
EVENT_ID, LINE_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| LINE_NUMBER | NUMBER | 18 | Yes | Line number of the event that needs to be processed | Active | |
| LEDGER_ID | NUMBER | 18 | Yes | Ledger Identifier associated to the subledger accounting event | Active | |
| EVENT_ID | NUMBER | 18 | Yes | Accounting event identifier. Refers to the accounting event for which the data is extracted by federal SLA accounting hook | Active | |
| APPLICATION_ID | NUMBER | 18 | Yes | Application identifier of the accounting event | Active | |
| SOURCE_ID | NUMBER | 18 | Yes | Unique source document identifier | Active | |
| SOURCE_DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | Source doucment type, if it is PO or REQ or INVOICE etc | Active | |
| SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 150 | Source document number for the event | Active | ||
| SOURCE_LINE_ID | NUMBER | 18 | Source document line Identifier if any for the event | Active | ||
| SOURCE_DISTRIBUTION_ID | NUMBER | 18 | Yes | Source document distribution Identifier if any for the event | Active | |
| DATA_SET_ID | NUMBER | 18 | Source document budgetary control data set identifier. | Active | ||
| PRIOR_YEAR_FLAG | VARCHAR2 | 1 | Column to indicate if the transaction is result of a prior year transaction or not. | Active | ||
| TREASURY_SYMBOL_ID | NUMBER | 18 | Treasury account symbol identifier associated to the transaction | Active | ||
| FUND_VALUE | VARCHAR2 | 25 | Fund value associated to the transaction | Active | ||
| APPORTIONMENT_CATEGORY_CODE | VARCHAR2 | 30 | Apportionment category code derived for the transaction fund | Active | ||
| DIRECT_OR_REIMBURSABLE_CODE | VARCHAR2 | 30 | Direct or reimbursable code derived for the transaction fund | Active | ||
| TAS_EXPIRED_STATUS_CODE | VARCHAR2 | 30 | Treasury account symbol expiration status code | Active | ||
| PRIOR_YEAR_ADJUSTMENT_CODE | VARCHAR2 | 30 | Prior year adjustment type code. It is either UPWARD or DOWNWARD or Null. | Active | ||
| ENT_BUDGET_AMOUNT | NUMBER | Entered un-anticipated budget amount derived for this source transaction | Active | |||
| ACC_BUDGET_AMOUNT | NUMBER | Accounted un-anticipated budget amount derived for this source transaction | Active | |||
| ENT_ANTICIPATED_RECOVERY_AMT | NUMBER | Entered anticipated recovery amount derived for this source transaction | Active | |||
| ACC_ANTICIPATED_RECOVERY_AMT | NUMBER | Accounted anticipated recovery amount derived for this source transaction | Active | |||
| ENT_COMMITMENT_AMOUNT | NUMBER | Entered commitment amount on the purchase requisition distribution derived for this source transaction | Active | |||
| ACC_COMMITMENT_AMOUNT | NUMBER | Accounted commitment amount on the purchase requisition distribution derived for this source transaction | Active | |||
| ENT_UNPAID_OBLIG_AMOUNT | NUMBER | Entered unpaid obligation amount derived for this source transaction | Active | |||
| ACC_UNPAID_OBLIG_AMOUNT | NUMBER | Accounted unpaid purchase order obligation amount derived for this source transaction | Active | |||
| ENT_UNPAID_OBLIG_PYA_AMOUNT | NUMBER | Entered unpaid prior year account (PYA) amount derived for this source transaction | Active | |||
| ACC_UNPAID_OBLIG_PYA_AMOUNT | NUMBER | Accounted unpaid obligation prior year account amount derived for this source transaction | Active | |||
| ENT_UNPAID_OBLIG_PYA_OFF_AMT | NUMBER | Entered unpaid obligation prior year account offset amount derived for this source transaction | Active | |||
| ACC_UNPAID_OBLIG_PYA_OFF_AMT | NUMBER | Accounted unpaid obligation prior year account offset amount derived for this source transaction | Active | |||
| ENT_PAID_OBLIG_AMOUNT | NUMBER | Entered paid obligation amount derived for this source transaction | Active | |||
| ACC_PAID_OBLIG_AMOUNT | NUMBER | Accounted paid obligation amount derived for this source transaction | Active | |||
| ENT_UNPAID_EXPEND_AMOUNT | NUMBER | Entered unpaid expenditure amount derived for this source transaction | Active | |||
| ACC_UNPAID_EXPEND_AMOUNT | NUMBER | Accounted unpaid expenditure amount derived for this source transaction | Active | |||
| ENT_PAID_EXPEND_AMOUNT | NUMBER | Entered paid expended amount derived for this source transaction | Active | |||
| ACC_PAID_EXPEND_AMOUNT | NUMBER | Accounted paid expended amount derived for this source transaction | Active | |||
| ENT_PAID_EXPEND_PYA_AMOUNT | NUMBER | Entered paid expenditure prior year account amount derived for this source transaction | Active | |||
| ACC_PAID_EXPEND_PYA_AMOUNT | NUMBER | Accounted paid expenditure prior year account amount derived for this source transaction | Active | |||
| ENT_UNPAID_EXPEND_PYA_AMT | NUMBER | Entered unpaid expenditure prior year account amount derived for this source transaction | Active | |||
| ACC_UNPAID_EXPEND_PYA_AMT | NUMBER | Accounted unpaid expenditure prior year account amount derived for this source transaction | Active | |||
| ENT_UNPAID_EXPEND_PYA_OFF_AMT | NUMBER | Entered unpaid expenditure prior year account offset amount derived for this source transaction | Active | |||
| ACC_UNPAID_EXPEND_PYA_OFF_AMT | NUMBER | Accounted unpaid expenditure prior year account offset amount derived for this source transaction | Active | |||
| ENT_EXPENDED_APPROP_AMOUNT | NUMBER | Entered expended appropriation amount derived for this source transaction | Active | |||
| ACC_EXPENDED_APPROP_AMOUNT | NUMBER | Accounted expended appropriation amount derived for this source transaction | Active | |||
| ENT_PAID_EXP_PYA_OFF_AMOUNT | NUMBER | Entered paid expenditure prior year account offset amount derived for this source transaction | Active | |||
| ACC_PAID_EXP_PYA_OFF_AMOUNT | NUMBER | Accounted paid expenditure prior year account offset amount derived for this source transaction | Active | |||
| FUNDING_DERIVATION_TYPE_CODE | VARCHAR2 | 30 | Funding derivation type code. Value indicates whether the funding is derived from the general fund or not. | Active | ||
| ACC_APPROP_ACCRUED_AMT | NUMBER | Accounted appropriations accrued ledger amount. | Active | |||
| ENT_APPROP_ACCRUED_AMT | NUMBER | Entered appropriations accrued amount. | Active | |||
| ACC_APPROP_DISBURSED_AMT | NUMBER | Accounted appropriations disbursed ledger amount. | Active | |||
| ENT_APPROP_DISBURSED_AMT | NUMBER | Entered appropriations disbursed amount. | Active | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
| PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution identifier | ||||
| PAYMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the federal payment type. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| FV_XLA_TRANSACTION_LINES_U1 | Unique | FUSION_TS_TX_IDX | EVENT_ID, LINE_NUMBER | Active |