eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_FI_BILL_ALL

Object Details

Object Name:	IGS_FI_BILL_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_FI_BILL_ALL
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_BILL_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BILL_ID
IGS_FI_BILL_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUT_OFF_DATE PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_ID	NUMBER		Yes	A Sequence Generated Number that records the Primary Key
ORG_ID	NUMBER	(15)		The Org ID Column for Multi Org functionality
BILL_NUMBER	VARCHAR2	(50)	Yes	Bill number that the charge belongs to. Will be Sequence Generated and the same as Bill ID. Can be used if there is a requirement of Bill Number format being specified by the customer.
BILL_DATE	DATE		Yes	The date on which the Bill has been generated.
DUE_DATE	DATE		Yes	The date on which the payments against the Bill is due.
PERSON_ID	NUMBER	(15)	Yes	The Person being Billed
SUBACCOUNT_ID	NUMBER	(15)		OBSOLETE. The Sub Account for which the Bill is being generated.
BILL_FROM_DATE	DATE			The date from which the charges are included for Billing
OPENING_BALANCE	NUMBER		Yes	The Opening Balance for the Bill
CUT_OFF_DATE	DATE		Yes	The Cut Off Date till which the transactions were included in the Bill.
CLOSING_BALANCE	NUMBER		Yes	The Closing Balance for the Bill.
PRINTED_FLAG	VARCHAR2	(1)	Yes	Denotes whether the Bill has been printed and can have values ('Y','N') For Site Specific use. Default value is 'N'
PRINT_DATE	DATE			The date on which the Bill was printed.
TO_PAY_AMOUNT	NUMBER			Specifies the amount due for the particular bill, calculated using the planned credits for the person.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
REQUEST_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Request WHO Column

Query Text

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


SELECT BILL_ID
,      ORG_ID
,      BILL_NUMBER
,      BILL_DATE
,      DUE_DATE
,      PERSON_ID
,      SUBACCOUNT_ID
,      BILL_FROM_DATE
,      OPENING_BALANCE
,      CUT_OFF_DATE
,      CLOSING_BALANCE
,      PRINTED_FLAG
,      PRINT_DATE
,      TO_PAY_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_BILL_ALL;

Dependencies

[top of page]

IGS.IGS_FI_BILL_ALL does not reference any database object

IGS.IGS_FI_BILL_ALL is referenced by following:

APPS: IGS_FI_BILL_ALL