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_FTCI_ACCTS

Product:	IGS - Student System (Obsolete)
Description:	For a Fee Type Calendar Instance, Revenue Account Code or the Natural Account Segment for the combination of attributes will be stored in this table.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_FI_FTCI_ACCTS_PK

ACCT_ID

Primary Key: IGS_FI_FTCI_ACCTS_UK1

FEE_TYPE
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
ORDER_SEQUENCE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_FI_FTCI_ACCTS	IGS_FI_F_TYP_CA_INST_ALL	IGS_FI_FTCI_ACCTS.FEE_TYPE IGS_FI_FTCI_ACCTS.FEE_CAL_TYPE IGS_FI_FTCI_ACCTS.FEE_CI_SEQUENCE_NUMBER
IGS_FI_FTCI_ACCTS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_FI_FTCI_ACCTS.UOO_ID
IGS_FI_FTCI_ACCTS	IGS_PS_UNIT_TYPE_LVL	IGS_FI_FTCI_ACCTS.UNIT_TYPE_ID
IGS_FI_FTCI_ACCTS	IGS_AS_UNIT_CLASS_ALL	IGS_FI_FTCI_ACCTS.UNIT_CLASS
IGS_FI_FTCI_ACCTS	IGS_AS_UNIT_MODE	IGS_FI_FTCI_ACCTS.UNIT_MODE
IGS_FI_FTCI_ACCTS	IGS_PS_UNIT_LEVEL_ALL	IGS_FI_FTCI_ACCTS.UNIT_LEVEL
IGS_FI_FTCI_ACCTS	IGS_FI_ACC_ALL	IGS_FI_FTCI_ACCTS.REV_ACCOUNT_CD
IGS_FI_FTCI_ACCTS	IGS_AD_LOCATION_ALL	IGS_FI_FTCI_ACCTS.LOCATION_CD
IGS_FI_FTCI_ACCTS	IGS_EN_ATD_TYPE_ALL	IGS_FI_FTCI_ACCTS.ATTENDANCE_TYPE
IGS_FI_FTCI_ACCTS	IGS_EN_ATD_MODE_ALL	IGS_FI_FTCI_ACCTS.ATTENDANCE_MODE
IGS_FI_FTCI_ACCTS	IGS_PS_VER_ALL	IGS_FI_FTCI_ACCTS.COURSE_CD IGS_FI_FTCI_ACCTS.CRS_VERSION_NUMBER
IGS_FI_FTCI_ACCTS	IGS_PS_UNIT_VER_ALL	IGS_FI_FTCI_ACCTS.UNIT_CD IGS_FI_FTCI_ACCTS.UNIT_VERSION_NUMBER