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_REFUNDS

Product:	IGS - Student System (Obsolete)
Description:	Stores all refund transactions which have been created due to excess unapplied credits.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_FI_REFUNDS_PK

REFUND_ID

Primary Key: IGS_FI_REFUNDS_UK

PERSON_ID
PAY_PERSON_ID
FEE_TYPE
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
REVERSAL_IND
INVOICE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_FI_REFUNDS	IGS_FI_ACC_ALL	IGS_FI_REFUNDS.DR_ACCOUNT_CD
IGS_FI_REFUNDS	IGS_FI_ACC_ALL	IGS_FI_REFUNDS.CR_ACCOUNT_CD
IGS_FI_REFUNDS	IGS_FI_F_TYP_CA_INST_ALL	IGS_FI_REFUNDS.FEE_TYPE IGS_FI_REFUNDS.FEE_CAL_TYPE IGS_FI_REFUNDS.FEE_CI_SEQUENCE_NUMBER
IGS_FI_REFUNDS	HZ_PARTIES	IGS_FI_REFUNDS.PERSON_ID
IGS_FI_REFUNDS	HZ_PARTIES	IGS_FI_REFUNDS.PAY_PERSON_ID
IGS_FI_REFUNDS	IGS_FI_INV_INT_ALL	IGS_FI_REFUNDS.INVOICE_ID
IGS_FI_REFUNDS	IGS_FI_REFUNDS	IGS_FI_REFUNDS.SOURCE_REFUND_ID
IGS_FI_REFUNDS	IGS_FI_REFUNDS	IGS_FI_REFUNDS.SOURCE_REFUND_ID