FND Design Data [Home] [Help]

Table: IGS_FI_DSB_SPSHT_DTL

Product: IGS - Student System
Description: This entity describes the detail of a fee assessment income disbursement journal. Each detail is specific to an organisational unit, disbursed income account. - Obsolete
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_FI_DSB_SPSHT_DTL_PK
  1. ColumnFEE_TYPE
  2. ColumnFEE_CAL_TYPE
  3. ColumnFEE_CI_SEQUENCE_NUMBER
  4. ColumnCREATE_DT
  5. ColumnACCOUNT_CD
  6. ColumnORG_UNIT_CD
  7. ColumnOU_START_DT
  8. ColumnCLASSIFICATION_CD
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_DSB_SPSHT_DTL FK Joins to TableIGS_FI_DSBR_SPSHT IGS_FI_DSB_SPSHT_DTL.FEE_TYPE
IGS_FI_DSB_SPSHT_DTL.FEE_CAL_TYPE
IGS_FI_DSB_SPSHT_DTL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_DSB_SPSHT_DTL.CREATE_DT
IGS_FI_DSB_SPSHT_DTL FK Joins to TableIGS_OR_UNIT_AC IGS_FI_DSB_SPSHT_DTL.ACCOUNT_CD
IGS_FI_DSB_SPSHT_DTL.ORG_UNIT_CD
IGS_FI_DSB_SPSHT_DTL.OU_START_DT
IGS_FI_DSB_SPSHT_DTL.CLASSIFICATION_CD
TableIGS_FI_DSB_DTL_ALC FK Joins to IGS_FI_DSB_SPSHT_DTL IGS_FI_DSB_DTL_ALC.FEE_TYPE
IGS_FI_DSB_DTL_ALC.FEE_CAL_TYPE
IGS_FI_DSB_DTL_ALC.FEE_CI_SEQUENCE_NUMBER
IGS_FI_DSB_DTL_ALC.CREATE_DT
IGS_FI_DSB_DTL_ALC.FIN_CAL_TYPE
IGS_FI_DSB_DTL_ALC.FIN_CI_SEQUENCE_NUMBER
IGS_FI_DSB_DTL_ALC.ACCOUNT_CD
IGS_FI_DSB_DTL_ALC.ORG_UNIT_CD
IGS_FI_DSB_DTL_ALC.OU_START_DT
IGS_FI_DSB_DTL_ALC.CLASSIFICATION_CD