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: IGI.IGI_CBR_AP_RECONCILE

Object Details

Object Name:	IGI_CBR_AP_RECONCILE
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_CBR_AP_RECONCILE
Subobject Name:
Status:	VALID

IGI_CBR_AP_RECONCILE contains records of unpaid invoices.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ACCOUNT_NUM	VARCHAR2	(25)	Account number
DOC_SEQ_NUM	NUMBER	(25)	Document sequence number
INVOICE_NUM	VARCHAR2	(50)	Invoice number
INVOICE_DATE	DATE		Invoice date
VENDOR_NUM	VARCHAR2	(30)	Vendor number
VENDOR_NAME	VARCHAR2	(240)	Vendor name
INVOICE_AMOUNT	NUMBER		Invoice amount
ORG_ID	NUMBER	(15)	Organization identifier
TYPE	VARCHAR2	(10)	Transaction type

Query Text

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


SELECT ACCOUNT_NUM
,      DOC_SEQ_NUM
,      INVOICE_NUM
,      INVOICE_DATE
,      VENDOR_NUM
,      VENDOR_NAME
,      INVOICE_AMOUNT
,      ORG_ID
,      TYPE
FROM IGI.IGI_CBR_AP_RECONCILE;

Dependencies

[top of page]

IGI.IGI_CBR_AP_RECONCILE does not reference any database object

IGI.IGI_CBR_AP_RECONCILE is referenced by following:

APPS: IGI_CBR_AP_RECONCILE