DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_FI_BILL_INSTLS

Object Details
Object Name: IGS_FI_BILL_INSTLS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_BILL_INSTLS
Subobject Name:
Status: VALID


This table stores Billing Installment information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_BILL_INSTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTUDENT_PLAN_ID
ColumnBILL_ID
ColumnINSTALLMENT_ID
Columns
Name Datatype Length Mandatory Comments
STUDENT_PLAN_ID NUMBER
Yes Student Plan Identifier
BILL_ID NUMBER
Yes Bill Identifier
INSTALLMENT_ID NUMBER
Yes Installment Identifier
INSTALLMENT_LINE_NUM NUMBER
Yes Installment Line Number
INSTALLMENT_DUE_DATE DATE
Yes Installment Due Date
INSTALLMENT_AMT NUMBER
Yes Installment Amount
DUE_AMT NUMBER
Yes Installment Amount due
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Concurrent Program column
PROGRAM_ID NUMBER (15)
Standard Concurrent Program column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent Program column
PROGRAM_UPDATE_DATE DATE

Standard Concurrent Program column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STUDENT_PLAN_ID
,      BILL_ID
,      INSTALLMENT_ID
,      INSTALLMENT_LINE_NUM
,      INSTALLMENT_DUE_DATE
,      INSTALLMENT_AMT
,      DUE_AMT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_BILL_INSTLS;

Dependencies

[top of page]

IGS.IGS_FI_BILL_INSTLS does not reference any database object

IGS.IGS_FI_BILL_INSTLS is referenced by following:

SchemaAPPS
SynonymIGS_FI_BILL_INSTLS