FND Design Data [Home] [Help]

Table: IGS_FI_P_SA_NOTES

Product: IGS - Student System
Description: Contains any textual notes for a sub account and a person context. This tracks the notes with an effective date.
Implementation/DBA Data: TableIGS.IGS_FI_P_SA_NOTES
Primary Key: IGS_FI_P_SA_NOTES_PK
  1. ColumnPARTY_SA_NOTES_ID
Primary Key: IGS_FI_P_SA_NOTES_UK
  1. ColumnPARTY_ID
  2. ColumnEFFECTIVE_DATE
  3. ColumnREFERENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_P_SA_NOTES FK Joins to TableIGS_GE_NOTE IGS_FI_P_SA_NOTES.REFERENCE_NUMBER
IGS_FI_P_SA_NOTES FK Joins to TableHZ_PARTIES IGS_FI_P_SA_NOTES.PARTY_ID
IGS_FI_P_SA_NOTES FK Joins to TableIGS_FI_SUBACCTS_ALL IGS_FI_P_SA_NOTES.SUBACCOUNT_ID