eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: IGS_FI_SUBACCTS_ALL

Product:	IGS - Student System
Description:	Stores information about each defined sub account. Each row contains information for a specific sub account, including name, description, receivables, revenue, cash and unapplied account details and receipt lockbox numbers that are assigned
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_FI_SUBACCTS_ALL_PK

SUBACCOUNT_ID

Primary Key: IGS_FI_SUBACCTS_ALL_UK

ORG_ID
SUBACCOUNT_NAME
EFFECTIVE_START_DATE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_FI_BALANCES	IGS_FI_SUBACCTS_ALL	IGS_FI_BALANCES.SUBACCOUNT_ID
IGS_FI_CREDITS_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_CREDITS_ALL.SUBACCOUNT_ID
IGS_FI_CR_TYPES_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_CR_TYPES_ALL.SUBACCOUNT_ID
IGS_FI_BAL_EX_SACCTS	IGS_FI_SUBACCTS_ALL	IGS_FI_BAL_EX_SACCTS.SUBACCOUNT_ID
IGS_FI_HOLD_PLN_LNS	IGS_FI_SUBACCTS_ALL	IGS_FI_HOLD_PLN_LNS.SUBACCOUNT_ID
IGS_FI_SA_SEGMENTS_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_SA_SEGMENTS_ALL.SUBACCOUNT_ID
IGS_FI_FIN_LT_PLAN	IGS_FI_SUBACCTS_ALL	IGS_FI_FIN_LT_PLAN.SUBACCOUNT_ID
IGS_FI_PARTY_SA	IGS_FI_SUBACCTS_ALL	IGS_FI_PARTY_SA.SUBACCOUNT_ID
IGS_FI_F_TYP_CA_INST_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_F_TYP_CA_INST_ALL.SUBACCOUNT_ID
IGS_FI_FEE_TYPE_HIST_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_FEE_TYPE_HIST_ALL.SUBACCOUNT_ID
IGS_FI_FEE_TYPE_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_FEE_TYPE_ALL.SUBACCOUNT_ID
IGS_FI_BILL_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_BILL_ALL.SUBACCOUNT_ID
IGS_FI_INV_INT_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_INV_INT_ALL.SUBACCOUNT_ID
IGS_FI_P_SA_NOTES	IGS_FI_SUBACCTS_ALL	IGS_FI_P_SA_NOTES.SUBACCOUNT_ID
IGS_FI_PARTY_SUBACTS	IGS_FI_SUBACCTS_ALL	IGS_FI_PARTY_SUBACTS.SUBACCOUNT_ID
IGS_FI_SA_LOCKBOXES	IGS_FI_SUBACCTS_ALL	IGS_FI_SA_LOCKBOXES.SUBACCOUNT_ID