FND Design Data [Home] [Help]

Table: IGS_FI_BILL_ALL

Product: IGS - Student System (Obsolete)
Description: IGS_FI_BILL_ALL is the relation where the Billing Header information is recorded. Here the Bill Numbers are generated and Bill header details such as Bill Date, Due Date, Billed Person, Sub Account and Balances are recorded.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_FI_BILL_ALL_PK
  1. ColumnBILL_ID
Primary Key: IGS_FI_BILL_ALL_UK1
  1. ColumnCUT_OFF_DATE
  2. ColumnPERSON_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_BILL_ALL FK Joins to TableHZ_PARTIES IGS_FI_BILL_ALL.PERSON_ID
IGS_FI_BILL_ALL FK Joins to TableIGS_FI_SUBACCTS_ALL IGS_FI_BILL_ALL.SUBACCOUNT_ID
TableIGS_FI_CR_ACTIVITIES FK Joins to IGS_FI_BILL_ALL IGS_FI_CR_ACTIVITIES.BILL_ID
TableIGS_FI_BILL_PLN_CRD FK Joins to IGS_FI_BILL_ALL IGS_FI_BILL_PLN_CRD.BILL_ID
TableIGS_FI_BILL_ADDR FK Joins to IGS_FI_BILL_ALL IGS_FI_BILL_ADDR.BILL_ID
TableIGS_FI_BILL_DPSTS FK Joins to IGS_FI_BILL_ALL IGS_FI_BILL_DPSTS.BILL_ID
TableIGS_FI_BILL_P_PLANS FK Joins to IGS_FI_BILL_ALL IGS_FI_BILL_P_PLANS.BILL_ID
TableIGS_FI_BILL_TRNSCTNS FK Joins to IGS_FI_BILL_ALL IGS_FI_BILL_TRNSCTNS.BILL_ID
TableIGS_FI_INV_INT_ALL FK Joins to IGS_FI_BILL_ALL IGS_FI_INV_INT_ALL.BILL_ID