[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_BALANCE_RULES |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_BALANCE_RULES |
Subobject Name: | |
Status: | VALID |
This table contains Balance Rules definition for five system level balances - STANDARD, FEE, HOLDS, INSTALLMENT and OTHER. The rules defined for each are for exclusion purposes. The exclusions attributes are Transaction Date Ranges, Effective Date Ranges, Fee types, Credit types and Sub Accounts. The Balance Calculation Process uses this exclusion definition to ignore charges and credits transactions matching with exclusion rule attributes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_BALANCE_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BALANCE_RULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BALANCE_RULE_ID | NUMBER | (15) | Yes | Sequence Generated Number - Primary Key for this table |
BALANCE_NAME | VARCHAR2 | (60) | Yes | Balance Name - System Defined Lookups - STANDARD, FEE, HOLDS, INSTALLMENT, OTHER |
VERSION_NUMBER | NUMBER | Yes | Version Number of the Rule Definition | |
EFFECTIVE_START_DATE | DATE | No longer used | ||
EFFECTIVE_END_DATE | DATE | No longer used | ||
EXCLUDE_TXN_DATE_LOW | DATE | No longer used | ||
EXCLUDE_TXN_DATE_HIGH | DATE | No longer used | ||
EXCLUDE_EFF_DATE_LOW | DATE | No longer used | ||
EXCLUDE_EFF_DATE_HIGH | DATE | No longer used | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_CONVERSION_DATE | DATE | Describes the earliest date from which the holds balance was updated using this rule |
Cut, paste (and edit) the following text to query this object:
SELECT BALANCE_RULE_ID
, BALANCE_NAME
, VERSION_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, EXCLUDE_TXN_DATE_LOW
, EXCLUDE_TXN_DATE_HIGH
, EXCLUDE_EFF_DATE_LOW
, EXCLUDE_EFF_DATE_HIGH
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_CONVERSION_DATE
FROM IGS.IGS_FI_BALANCE_RULES;
IGS.IGS_FI_BALANCE_RULES does not reference any database object
IGS.IGS_FI_BALANCE_RULES is referenced by following:
|
|
|