JA_CN_ACCOUNT_BALANCES
This table contains the beginning balance, period net debit amount, period net credit amount, and ending balance for natural account and subsidiary segments by period and currency.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JA_CN_ACCOUNT_BALANCES_PK |
ACC_BAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACC_BAL_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies an accounting balance. | |
| LEDGER_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies a ledger. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | An identifier that uniquely identifies a legal entity. | |
| BALANCING_SEGMENT | VARCHAR2 | 25 | Yes | Value for balancing segment of accounting flexfield. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Accounting period for which the delta balances should be tracked. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code for the amounts in a record. | |
| COST_CENTER_SEGMENT | VARCHAR2 | 25 | Value for cost center segment of accounting flexfield. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| THIRD_PARTY_TYPE | VARCHAR2 | 1 | Source to indicate the type of third party. 'C' indicates customer and 'S' indicates supplier. | ||
| THIRD_PARTY_ID | NUMBER | 18 | Third party identifier, such as customer identifier and supplier identifier. | ||
| THIRD_PARTY_NUMBER | VARCHAR2 | 300 | Number of third party, such as customer number and supplier number. | ||
| PROJECT_ID | NUMBER | 18 | An identifier that uniquely identifies a project. | ||
| PROJECT_NUMBER | VARCHAR2 | 150 | Number of the project in Oracle Projects to which the cost of this payment/shipment will be charged. | ||
| PROJECT_SOURCE | VARCHAR2 | 3 | Source of the project. When the project is defined as 'Chart of Account', the value is 'COA'. When the project is defined as 'project module', the value is 'PA'. | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 25 | Yes | Value for natural account number of accounting flexfield. | |
| PERSONNEL_ID | NUMBER | 18 | An identifier that uniquely identifies a personnel. | ||
| PERSONNEL_NUMBER | VARCHAR2 | 300 | The employee number for employee supplier. | ||
| BEGIN_BALANCE_DR_BEQ | NUMBER | Beginning debit balance. It is specified in the base currency. | |||
| BEGIN_BALANCE_CR_BEQ | NUMBER | Beginning credit balance. It is specified in the base currency. | |||
| BEGIN_BALANCE_DR | NUMBER | Beginning debit balance summarized by itemization process. | |||
| BEGIN_BALANCE_CR | NUMBER | Beginning credit balances summarized by itemization process. | |||
| PERIOD_NET_DR_BEQ | NUMBER | Period net debit balance. It is specified in the base currency. | |||
| PERIOD_NET_CR_BEQ | NUMBER | Period net credit balance. It is specified in the base currency. | |||
| PERIOD_NET_DR | NUMBER | Period net debit balance summarized by itemization process. | |||
| PERIOD_NET_CR | NUMBER | Period net credit balance summarized by itemization process. | |||
| PERIOD_MONTH | NUMBER | 18 | Yes | Stores the accounting period number. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ACCOUNT_TYPE | VARCHAR2 | 1 | Natural account type. Valid values are 'A' for 'Asset', 'C' for 'Budgetary (credit)', 'D' for 'Budgetary (debit)','E' for 'Expense', 'L' for 'Liability', 'O' for 'Ownership or Stockholder Equity or Fund Balance' and 'R' for 'Revenue'. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JA_CN_ACCOUNT_BALANCES_N1 | Non Unique | Default | LEDGER_ID, LEGAL_ENTITY_ID, THIRD_PARTY_ID, PERIOD_NAME, CURRENCY_CODE, NATURAL_ACCOUNT_SEGMENT, BALANCING_SEGMENT |
| JA_CN_ACCOUNT_BALANCES_PK | Unique | Default | ACC_BAL_ID |