FND Design Data [Home] [Help]

Table: IGS_FI_BALANCES

Product: IGS - Student System
Description: This table contains balance amount for a party in the context of an Account.
Implementation/DBA Data: TableIGS.IGS_FI_BALANCES
Primary Key: IGS_FI_BALANCES_PK
  1. ColumnBALANCE_ID
Primary Key: IGS_FI_BALANCES_UK
  1. ColumnPARTY_ID
  2. ColumnBALANCE_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_BALANCES FK Joins to TableIGS_FI_BALANCE_RULES IGS_FI_BALANCES.FEE_BALANCE_RULE_ID
IGS_FI_BALANCES FK Joins to TableIGS_FI_BALANCE_RULES IGS_FI_BALANCES.HOLDS_BALANCE_RULE_ID
IGS_FI_BALANCES FK Joins to TableIGS_FI_BALANCE_RULES IGS_FI_BALANCES.INSTALLMENT_BALANCE_RULE_ID
IGS_FI_BALANCES FK Joins to TableIGS_FI_BALANCE_RULES IGS_FI_BALANCES.OTHER_BALANCE_RULE_ID
IGS_FI_BALANCES FK Joins to TableIGS_FI_BALANCE_RULES IGS_FI_BALANCES.STANDARD_BALANCE_RULE_ID
IGS_FI_BALANCES FK Joins to TableHZ_PARTIES IGS_FI_BALANCES.PARTY_ID
IGS_FI_BALANCES FK Joins to TableIGS_FI_SUBACCTS_ALL IGS_FI_BALANCES.SUBACCOUNT_ID
TableIGS_FI_BALANCES_HST FK Joins to IGS_FI_BALANCES IGS_FI_BALANCES_HST.BALANCE_ID