FND Design Data [Home] [Help]

Table: IGS_FI_FTCI_ACCTS

Product: IGS - Student System
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: TableIGS.IGS_FI_FTCI_ACCTS
Primary Key: IGS_FI_FTCI_ACCTS_PK
  1. ColumnACCT_ID
Primary Key: IGS_FI_FTCI_ACCTS_UK1
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnORDER_SEQUENCE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_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 FK Joins to TableIGS_PS_UNIT_OFR_OPT_ALL IGS_FI_FTCI_ACCTS.UOO_ID
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_PS_UNIT_TYPE_LVL IGS_FI_FTCI_ACCTS.UNIT_TYPE_ID
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_AS_UNIT_CLASS_ALL IGS_FI_FTCI_ACCTS.UNIT_CLASS
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_AS_UNIT_MODE IGS_FI_FTCI_ACCTS.UNIT_MODE
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_PS_UNIT_LEVEL_ALL IGS_FI_FTCI_ACCTS.UNIT_LEVEL
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_FI_ACC_ALL IGS_FI_FTCI_ACCTS.REV_ACCOUNT_CD
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_AD_LOCATION_ALL IGS_FI_FTCI_ACCTS.LOCATION_CD
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_EN_ATD_TYPE_ALL IGS_FI_FTCI_ACCTS.ATTENDANCE_TYPE
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_EN_ATD_MODE_ALL IGS_FI_FTCI_ACCTS.ATTENDANCE_MODE
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_PS_VER_ALL IGS_FI_FTCI_ACCTS.COURSE_CD
IGS_FI_FTCI_ACCTS.CRS_VERSION_NUMBER
IGS_FI_FTCI_ACCTS FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_FI_FTCI_ACCTS.UNIT_CD
IGS_FI_FTCI_ACCTS.UNIT_VERSION_NUMBER