XLA_FSN_BAL_BSV_GT
This table is used by the Accounting Engine when running Entered Currency or Rounding balancing on big transactions or on transactions that need Intercompany balancing. It is used to store the combinations that need to be balanced, and the amount that they are off by. It also stores the type of balancing necessary and the account combination to be used.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AE_HEADER_ID | NUMBER | 18 | Yes | Accounting entry identifier to be balanced. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Three-letter ISO code associated with a currency. | |
| UNRND_ENTERED_DELTA | NUMBER | Yes | Unrounded entered amount to be plugged. | ||
| UNRND_ACCOUNTED_DELTA | NUMBER | Yes | Unrounded accounted amount to be plugged | ||
| ENTERED_DELTA | NUMBER | Yes | Rounded entered amount to be plugged. | ||
| ACCOUNTED_DELTA | NUMBER | Yes | Rounded accounted amount to be plugged. | ||
| BAL_SIGN_CODE | VARCHAR2 | 30 | Yes | Indicates whether the amount to be plugged is a debit or a credit (D or C). | |
| BAL_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates whether entered currency balancing or rounding balancing is necessary (E or I). | |
| ACCT_STATUS | NUMBER | Yes | Result of validating the account combination to be used when balancing. | ||
| CODE_COMBINATION_ID | NUMBER | Account combination to be used when balancing. | |||
| ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type (if encumbrances) to be balanced. | |||
| SUBLEDGER_XCC_COMPLETE_STATUS | VARCHAR2 | 1 | Subledger Budgetary Control Status | ||
| BSV1 | VARCHAR2 | 25 | Value of primary balancing segment. | ||
| BSV2 | VARCHAR2 | 25 | Value of secondary balancing segment. | ||
| BSV3 | VARCHAR2 | 25 | Value of third balancing segment. |