FND Design Data [Home] [Help]

Table: IGS_FI_CREDITS_ALL

Product: IGS - Student System (Obsolete)
Description: This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_FI_CREDITS_ALL_PK
  1. ColumnCREDIT_ID
Primary Key: IGS_FI_CREDITS_ALL_UK
  1. ColumnPARTY_ID
  2. ColumnCREDIT_NUMBER
  3. ColumnORG_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_CREDITS_ALL FK Joins to TableIGS_FI_CR_TYPES_ALL IGS_FI_CREDITS_ALL.CREDIT_TYPE_ID
IGS_FI_CREDITS_ALL FK Joins to TableHZ_PARTIES IGS_FI_CREDITS_ALL.PARTY_ID
IGS_FI_CREDITS_ALL FK Joins to TableIGS_FI_SUBACCTS_ALL IGS_FI_CREDITS_ALL.SUBACCOUNT_ID
IGS_FI_CREDITS_ALL FK Joins to TableIGS_FI_LOCKBOXES IGS_FI_CREDITS_ALL.RECEIPT_LOCKBOX_NUMBER
IGS_FI_CREDITS_ALL FK Joins to TableIGS_FI_INV_INT_ALL IGS_FI_CREDITS_ALL.SOURCE_INVOICE_ID
IGS_FI_CREDITS_ALL FK Joins to Table% IGS_FI_CREDITS_ALL.FEE_CAL_TYPE
IGS_FI_CREDITS_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_CREDITS_ALL.WAIVER_NAME
TableIGS_FI_APPLICATIONS FK Joins to IGS_FI_CREDITS_ALL IGS_FI_APPLICATIONS.CREDIT_ID
TableIGS_FI_CR_ACTIVITIES FK Joins to IGS_FI_CREDITS_ALL IGS_FI_CR_ACTIVITIES.CREDIT_ID
TableIGS_FI_PERSON_HOLDS FK Joins to IGS_FI_CREDITS_ALL IGS_FI_PERSON_HOLDS.RELEASE_CREDIT_ID
TableIGS_FI_PP_INS_APPLS FK Joins to IGS_FI_CREDITS_ALL IGS_FI_PP_INS_APPLS.CREDIT_ID
TableIGS_FI_OTC_CHARGES FK Joins to IGS_FI_CREDITS_ALL IGS_FI_OTC_CHARGES.CREDIT_ID