XLA_REPORT_BALANCES_GT
Internal use for report balance calculation.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Identifier of a self-contained accounting information set for single or multiple legal or management entities. | |
| LEDGER_SHORT_NAME | VARCHAR2 | 20 | Short name of a self-contained accounting information set for single or multiple legal or management entities. | |
| LEDGER_DESCRIPTION | VARCHAR2 | 240 | Additional information associated with a ledger. | |
| LEDGER_NAME | VARCHAR2 | 30 | Represents a self-contained accounting information set for single or multiple legal or management entities. | |
| LEDGER_CURRENCY | VARCHAR2 | 15 | Currency used for accounting and reporting in a ledger. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Unique number used to identify a Legal Entity; either manually set by user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. This is only relevant for third party legal entities. | |
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of the legal entity that belongs to your own corporate structure (enterprise). | |
| LE_ADDRESS_LINE_1 | VARCHAR2 | 240 | Address line 1 registered with the identifying jurisdiction at registration time and used to help identify the legal entity in Oracle Fusion Applications. This address will be printed on legal documents when required. | |
| LE_ADDRESS_LINE_2 | VARCHAR2 | 240 | Address line 2 registered with the identifying jurisdiction at registration time and used to help identify the legal entity in Oracle Fusion Applications. This address will be printed on legal documents when required. | |
| LE_ADDRESS_LINE_3 | VARCHAR2 | 240 | Address line 3 registered with the identifying jurisdiction at registration time and used to help identify the legal entity in Oracle Fusion Applications. This address will be printed on legal documents when required. | |
| LE_CITY | VARCHAR2 | 60 | City name where legal entity is registered. | |
| LE_REGION_1 | VARCHAR2 | 120 | Oracle internal use only. | |
| LE_REGION_2 | VARCHAR2 | 120 | Oracle internal use only. | |
| LE_REGION_3 | VARCHAR2 | 120 | Oracle internal use only. | |
| LE_POSTAL_CODE | VARCHAR2 | 60 | Oracle internal use only. | |
| LE_COUNTRY | VARCHAR2 | 80 | Oracle internal use only. | |
| LE_REGISTRATION_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | |
| LE_REGISTRATION_EFFECTIVE_FROM | DATE | Oracle internal use only. | ||
| LE_ACTIVITY_CODE | VARCHAR2 | 150 | Oracle internal use only. | |
| LE_SUB_ACTIVITY_CODE | VARCHAR2 | 150 | Oracle internal use only. | |
| LE_CONTACT_NAME | VARCHAR2 | 240 | Oracle internal use only. | |
| LE_CONTACT_PHONE_NUMBER | VARCHAR2 | 240 | Oracle internal use only. | |
| LE_BR_DAILY_INSCRIPTION_NUMBER | NUMBER | Oracle internal use only. | ||
| LE_BR_DAILY_INSCRIPTION_DATE | DATE | Oracle internal use only. | ||
| LE_BR_DAILY_ENTITY | VARCHAR2 | 360 | Oracle internal use only. | |
| LE_BR_DAILY_LOCATION | VARCHAR2 | 80 | Oracle internal use only. | |
| LE_BR_DIRECTOR_NUMBER | NUMBER | Oracle internal use only. | ||
| LE_BR_ACCOUNTANT_NUMBER | NUMBER | Oracle internal use only. | ||
| LE_BR_ACCOUNTANT_NAME | VARCHAR2 | 360 | Oracle internal use only. | |
| PARTY_TYPE_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
| PARTY_ID | NUMBER | 18 | Oracle internal use only. | |
| PARTY_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | |
| PARTY_NAME | VARCHAR2 | 360 | Oracle internal use only. | |
| PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | |
| PARTY_SITE_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | |
| PARTY_SITE_TAX_REGS_NUMBER | VARCHAR2 | 50 | Oracle internal use only. | |
| PARTY_TYPE_TAXPAYER_ID | VARCHAR2 | 30 | Oracle internal use only. | |
| PARTY_TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Oracle internal use only. | |
| PARTY_ADDRESS_1 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_ADDRESS_2 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_ADDRESS_3 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_ADDRESS_4 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_CITY | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_ZIP_CODE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_STATE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_PROVINCE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_COUNTRY | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_COUNTY | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_NAME | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_ADDRESS_LINE_1 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_ADDRESS_LINE_2 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_ADDRESS_LINE_3 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_ADDRESS_LINE_4 | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_CITY | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_ZIP_CODE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_STATE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_PROVINCE | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_COUNTRY | VARCHAR2 | 240 | Oracle internal use only. | |
| PARTY_SITE_COUNTY | VARCHAR2 | 240 | Oracle internal use only. | |
| APPLICATION_ID | NUMBER | 18 | Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. | |
| APPLICATION_NAME | VARCHAR2 | 4000 | Functional area within a software suite of products. For example, Financials or Payroll. | |
| JE_SOURCE_NAME | VARCHAR2 | 25 | Oracle internal use only. | |
| PERIOD_YEAR | NUMBER | 18 | Fiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar. | |
| PERIOD_NUMBER | NUMBER | 18 | Number assigned to each period in the accounting calendar. | |
| PERIOD_NAME | VARCHAR2 | 15 | Name of a fiscal period a company uses to report financial results, such as a calendar month or fiscal period. | |
| PERIOD_START_DATE | DATE | First day of the accounting period. | ||
| PERIOD_END_DATE | DATE | Last date of an accounting period. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 1 | Balance type (Actual, Budget, or Encumbrance) | |
| BALANCE_TYPE | VARCHAR2 | 80 | Type of balance, such as actual or budget. | |
| BUDGET_VERSION_ID | NUMBER | Oracle internal use only. | ||
| BUDGET_NAME | VARCHAR2 | 15 | Oracle internal use only. | |
| ENCUMBRANCE_TYPE_ID | NUMBER | Oracle internal use only. | ||
| ENCUMBRANCE_TYPE | VARCHAR2 | 80 | Oracle internal use only. | |
| BEGIN_BALANCE_DR | NUMBER | Oracle internal use only. | ||
| BEGIN_BALANCE_CR | NUMBER | Oracle internal use only. | ||
| PERIOD_NET_DR | NUMBER | Total of debit entries during a specified period of time. | ||
| PERIOD_NET_CR | NUMBER | Total of credit entries during a specified period of time. | ||
| BEGIN_DRAFT_BALANCE_DR | NUMBER | Oracle internal use only. | ||
| BEGIN_DRAFT_BALANCE_CR | NUMBER | Oracle internal use only. | ||
| PERIOD_DRAFT_NET_DR | NUMBER | Oracle internal use only. | ||
| PERIOD_DRAFT_NET_CR | NUMBER | Oracle internal use only. | ||
| BEGIN_RUNNING_TOTAL_CR | NUMBER | Oracle internal use only. | ||
| BEGIN_RUNNING_TOTAL_DR | NUMBER | Oracle internal use only. | ||
| END_RUNNING_TOTAL_CR | NUMBER | Oracle internal use only. | ||
| END_RUNNING_TOTAL_DR | NUMBER | Oracle internal use only. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only. | |
| ACCOUNTING_CODE_COMBINATION | VARCHAR2 | 240 | Account structure an organization uses to record transactions and maintain account balances. | |
| CODE_COMBINATION_DESCRIPTION | VARCHAR2 | 4000 | Oracle internal use only. | |
| CONTROL_ACCOUNT_FLAG | VARCHAR2 | 25 | Oracle internal use only. | |
| CONTROL_ACCOUNT | VARCHAR2 | 80 | Oracle internal use only. | |
| BALANCING_SEGMENT | VARCHAR2 | 25 | Segment in the chart of accounts flexfields where transactions will be balanced for each of the values in the segment. | |
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 25 | Oracle internal use only. | |
| COST_CENTER_SEGMENT | VARCHAR2 | 25 | Oracle internal use only. | |
| MANAGEMENT_SEGMENT | VARCHAR2 | 25 | Oracle internal use only. | |
| INTERCOMPANY_SEGMENT | VARCHAR2 | 25 | Oracle internal use only. | |
| BALANCING_SEGMENT_DESC | VARCHAR2 | 240 | Additional information of a balancing segment. | |
| NATURAL_ACCOUNT_DESC | VARCHAR2 | 240 | Oracle internal use only. | |
| COST_CENTER_DESC | VARCHAR2 | 240 | Oracle internal use only. | |
| MANAGEMENT_SEGMENT_DESC | VARCHAR2 | 240 | Oracle internal use only. | |
| INTERCOMPANY_SEGMENT_DESC | VARCHAR2 | 240 | Oracle internal use only. | |
| SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | |
| SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. |