FND Design Data [Home] [Help]

Table: IGS_FI_BILL_TRNSCTNS

Product: IGS - Student System
Description: IGS_FI_TRNSCTNS is the relation where the transactions recorded against a Bill are stored. This relation has a mapping to the Bill Header table as it stores the detail information against the header records. The transaction recorded in this
Implementation/DBA Data: TableIGS.IGS_FI_BILL_TRNSCTNS
Primary Key: IGS_FI_BILL_TRNSCTNS_PK
  1. ColumnTRANSACTION_ID
Primary Key: IGS_FI_BILL_TRNSCTNS_UK1
  1. ColumnTRANSACTION_TYPE
  2. ColumnINVOICE_CREDITACT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_BILL_TRNSCTNS FK Joins to TableIGS_FI_BILL_ALL IGS_FI_BILL_TRNSCTNS.BILL_ID
IGS_FI_BILL_TRNSCTNS FK Joins to TableIGS_FI_CR_ACTIVITIES IGS_FI_BILL_TRNSCTNS.INVOICE_CREDITACT_ID
IGS_FI_BILL_TRNSCTNS FK Joins to TableIGS_FI_INV_INT_ALL IGS_FI_BILL_TRNSCTNS.INVOICE_CREDITACT_ID