XLA_FSN_PBF_DATA_GT
This table is used by the Accounting Engine to retrieve prior business flow data.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| APPLD_TO_APPLN_ID | NUMBER | Identifier for application used by accounting business flow, | ||
| APPLD_TO_ENTITY_CODE | VARCHAR2 | 30 | Entity code of the data to be retrieved. | |
| BUSINESS_CLASS_CODE | VARCHAR2 | 30 | Business class code of the data to be retrieved. | |
| LEDGER_ID | NUMBER | Self-contained accounting information set for single or multiple legal or management entities. | ||
| AELPOS | NUMBER | Position in internal structures of the line prior business flow data is being retrieved for. | ||
| APPLD_TO_DIST_ID_TYPE_1 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_DIST_ID_TYPE_2 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_DIST_ID_TYPE_3 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_DIST_ID_TYPE_4 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_DIST_ID_TYPE_5 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_DIST_ID_CHAR_1 | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved (Character). | |
| APPLD_TO_DIST_ID_CHAR_2 | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved (Character). | |
| APPLD_TO_DIST_ID_CHAR_3 | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved (Character). | |
| APPLD_TO_DIST_ID_CHAR_4 | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved (Character). | |
| APPLD_TO_DIST_ID_CHAR_5 | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved (Character). | |
| APPLD_TO_DIST_ID_INT_1 | NUMBER | Distribution line identifier of the data to be retrieved. | ||
| APPLD_TO_DIST_ID_INT_2 | NUMBER | Distribution line identifier of the data to be retrieved. | ||
| APPLD_TO_DIST_ID_INT_3 | NUMBER | Distribution line identifier of the data to be retrieved. | ||
| APPLD_TO_DIST_ID_INT_4 | NUMBER | Distribution line identifier of the data to be retrieved. | ||
| APPLD_TO_DIST_ID_INT_5 | NUMBER | Distribution line identifier of the data to be retrieved. | ||
| APPLD_TO_DISTBN_TYPE | VARCHAR2 | 30 | Distribution line identifier of the data to be retrieved. | |
| APPLD_TO_TRAN_ID_TYPE_1 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_TRAN_ID_TYPE_2 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_TRAN_ID_TYPE_3 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_TRAN_ID_TYPE_4 | NUMBER | Data type for transaction identifier. | ||
| APPLD_TO_TRAN_ID_CHAR_1 | VARCHAR2 | 30 | Transaction identifier of the data to be retrieved. | |
| APPLD_TO_TRAN_ID_CHAR_2 | VARCHAR2 | 30 | Transaction identifier of the data to be retrieved. | |
| APPLD_TO_TRAN_ID_CHAR_3 | VARCHAR2 | 30 | Transaction identifier of the data to be retrieved. | |
| APPLD_TO_TRAN_ID_CHAR_4 | VARCHAR2 | 30 | Transaction identifier of the data to be retrieved. | |
| APPLD_TO_TRAN_ID_INT_1 | NUMBER | Transaction identifier of the data to be retrieved. | ||
| APPLD_TO_TRAN_ID_INT_2 | NUMBER | Transaction identifier of the data to be retrieved. | ||
| APPLD_TO_TRAN_ID_INT_3 | NUMBER | Transaction identifier of the data to be retrieved. | ||
| APPLD_TO_TRAN_ID_INT_4 | NUMBER | Transaction identifier of the data to be retrieved. | ||
| SOURCE_AE_ID | NUMBER | Source accounting entry identifier. | ||
| SOURCE_CCID | NUMBER | Source accounting code combination identifier. | ||
| SOURCE_AEL_NUM | NUMBER | Source accounting entry line number. | ||
| REFPOS | NUMBER | Position in internal structures of the distribution link prior business flow data is being retrieved for. | ||
| INHERIT_DESC | VARCHAR2 | 1 | Indicates whether journal line description is retrieved. | |
| DIST_LINK_NUM | NUMBER | Number of retrieved distribution link. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 1 | Type of balances. Valid values are Actual, Budget, and Encumbrance. | |
| AE_HEADER_ID | NUMBER | 18 | Subledger journal entry identifier. | |
| AE_LINE_NUM | NUMBER | 18 | Subledger journal entry line number. | |
| SOURCE_REF_AE_ID | NUMBER | 18 | Source referenced accounting entry identifier. |