FUN_BAL_INTRA_RULES
The intracompany balancing rules table contains information about ledger balancing options including the accounts used when only balancing segments two and three are out of balance and clearing company options.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FUN_BAL_INTRA_RULES_PK |
INTRA_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTRA_RULE_ID | NUMBER | 18 | Yes | Ledger balancing options rule identifier. | |
| STRUCTURE_ID | NUMBER | 18 | Chart of accounts structure identifier. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of the ledger balancing option rule. | ||
| LE_ID | NUMBER | 18 | Legal entity identifier of the ledger balancing option rule. | ||
| JE_SOURCE_NAME | VARCHAR2 | 25 | Journal source name of the ledger balancing option rule. | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Journal category name of the ledger balancing option rule. | ||
| CLEARING_OPTION | VARCHAR2 | 2 | Clearing company balancing option for a ledger. | ||
| CLEARING_BSV | VARCHAR2 | 25 | Clearing company segment value for balancing. | ||
| BALANCE_BY_FLAG | VARCHAR2 | 1 | Option to summarize lines before balancing or balance in detail. | ||
| MANY_TO_MANY_OPTION | VARCHAR2 | 2 | Option for the ledger when handling balancing where there are many debits and many credits involving many legal entities. | ||
| INTRA_RECEIVABLE_CCID | NUMBER | 18 | Account combination identifier for the receivables account used for ledger balancing. | ||
| INTRA_PAYABLE_CCID | NUMBER | 18 | Account combination identifier for the payables account used for ledger balancing. | ||
| PRECEDENCE_NUMBER | NUMBER | 18 | Order of precedence for evaluating rules to be used for balancing. | ||
| START_DATE | DATE | Date from which the ledger option balancing rule is active. | |||
| END_DATE | DATE | Date after which the ledger option balancing rule is inactive. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FUN_BAL_INTRA_RULES | gl_ledgers | LEDGER_ID |
| FUN_BAL_INTRA_RULES | xle_entity_profiles | LE_ID |
| FUN_BAL_INTRA_RULES | gl_code_combinations | INTRA_RECEIVABLE_CCID |
| FUN_BAL_INTRA_RULES | gl_code_combinations | INTRA_PAYABLE_CCID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_BAL_INTRA_RULES_U1 | Unique | Default | STRUCTURE_ID, LEDGER_ID, LE_ID, JE_SOURCE_NAME, JE_CATEGORY_NAME, START_DATE, END_DATE |
| FUN_BAL_INTRA_RULES_U2 | Unique | Default | INTRA_RULE_ID |