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_CR_TYPES_ALL

Product:	IGS - Student System (Obsolete)
Description:	Stores information about the 'credit type' of a credit transaction. The credit type provides the debit and credit account information to a credit transaction along with some other information like credit class etc.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_FI_CR_TYPES_ALL_PK

CREDIT_TYPE_ID

Primary Key: IGS_FI_CR_TYPES_ALL_UK

CREDIT_TYPE_NAME
EFFECTIVE_START_DATE
ORG_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_FI_CR_TYPES_ALL	IGS_FI_ACC_ALL	IGS_FI_CR_TYPES_ALL.DR_ACCOUNT_CD
IGS_FI_CR_TYPES_ALL	IGS_FI_ACC_ALL	IGS_FI_CR_TYPES_ALL.CR_ACCOUNT_CD
IGS_FI_CR_TYPES_ALL	IGS_FI_A_HIERARCHIES	IGS_FI_CR_TYPES_ALL.APPL_HIERARCHY_ID
IGS_FI_CR_TYPES_ALL	IGS_FI_SUBACCTS_ALL	IGS_FI_CR_TYPES_ALL.SUBACCOUNT_ID
IGS_FI_CR_TYPES_ALL	IGS_FI_CR_TYPES_ALL	IGS_FI_CR_TYPES_ALL.PAYMENT_CREDIT_TYPE_ID
IGS_FI_CR_TYPES_ALL	IGS_FI_ACC_ALL	IGS_FI_CR_TYPES_ALL.FORFEITURE_ACCOUNT_CD
IGS_FI_A_HIERARCHIES	IGS_FI_CR_TYPES_ALL	IGS_FI_A_HIERARCHIES.CREDIT_TYPE_ID
IGS_FI_CREDITS_ALL	IGS_FI_CR_TYPES_ALL	IGS_FI_CREDITS_ALL.CREDIT_TYPE_ID
IGS_FI_BAL_EX_C_TYPS	IGS_FI_CR_TYPES_ALL	IGS_FI_BAL_EX_C_TYPS.CREDIT_TYPE_ID
IGS_FI_CR_TYPES_ALL	IGS_FI_CR_TYPES_ALL	IGS_FI_CR_TYPES_ALL.PAYMENT_CREDIT_TYPE_ID
IGS_FI_LB_CR_TYPES	IGS_FI_CR_TYPES_ALL	IGS_FI_LB_CR_TYPES.CREDIT_TYPE_ID
IGS_FI_LOCKBOXES	IGS_FI_CR_TYPES_ALL	IGS_FI_LOCKBOXES.DEFAULT_CREDIT_TYPE_ID
IGS_FI_WAIVER_PGMS	IGS_FI_CR_TYPES_ALL	IGS_FI_WAIVER_PGMS.CREDIT_TYPE_ID