XLA_FSN_RVSL_DATA_GT
This table is used by the accounting engine to retrieve data for transaction and transaction line reversals.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| APPLICATION_ID | NUMBER | Functional area within a software suite of products. For example, Financials or Payroll. | ||
| EVENT_ID | NUMBER | Identifier of the categorization of accounting events that is unique within an application and event class. | ||
| ENTITY_ID | NUMBER | Transaction entity of data to be reversed. | ||
| LEDGER_ID | NUMBER | Self-contained accounting information set for single or multiple legal or management entities. | ||
| HDRNUM | NUMBER | Position in accounting entry method 4 structure of reversing entry. | ||
| LNSNUM | NUMBER | Position in accounting entry line method 4 structure of reversing line. | ||
| RVSL_DIST_TYPE | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_INT_1 | NUMBER | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | ||
| RVSL_DIST_ID_INT_2 | NUMBER | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | ||
| RVSL_DIST_ID_INT_3 | NUMBER | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | ||
| RVSL_DIST_ID_INT_4 | NUMBER | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | ||
| RVSL_DIST_ID_INT_5 | NUMBER | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | ||
| RVSL_DIST_ID_CHAR_1 | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_CHAR_2 | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_CHAR_3 | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_CHAR_4 | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_CHAR_5 | VARCHAR2 | 31 | Distribution line identifier of the data to be reversed. Only populated for transaction line reversals. | |
| RVSL_DIST_ID_TYPE_1 | VARCHAR2 | 2 | Data type for transaction identifier. | |
| RVSL_DIST_ID_TYPE_2 | VARCHAR2 | 2 | Data type for transaction identifier. | |
| RVSL_DIST_ID_TYPE_3 | VARCHAR2 | 2 | Data type for transaction identifier. | |
| RVSL_DIST_ID_TYPE_4 | VARCHAR2 | 2 | Data type for transaction identifier. | |
| RVSL_DIST_ID_TYPE_5 | VARCHAR2 | 2 | Data type for transaction identifier. | |
| PASS_NUM | NUMBER | 18 | The processing pass in which the row is inserted. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_FSN_RVSL_DATA_GT_N1 | Non Unique | PASS_NUM |