[Home] [Help] [Dependency Information]
Object Name: | IGI_CBR_AP_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_CBR_AP_INTERFACE |
Subobject Name: | |
Status: | VALID |
IGI_CBR_AP_INTERFACE contains invoices that have been posted to the accrual Set of Books but not the cash Set of Books.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
ORGANIZATION | VARCHAR2 | (60) | Organization name | |
ACCOUNT_NUM | VARCHAR2 | (25) | Account number | |
DOC_SEQ_NUM | NUMBER | Document sequence number | ||
INVOICE_NUM | VARCHAR2 | (50) | Invoice number | |
INVOICE_DATE | DATE | Invoice date | ||
VENDOR_NUM | VARCHAR2 | (30) | Vendor number | |
OPENING_VAR | NUMBER | Opening variance | ||
AMOUNT | NUMBER | Unpaid invoice amount |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, ORGANIZATION
, ACCOUNT_NUM
, DOC_SEQ_NUM
, INVOICE_NUM
, INVOICE_DATE
, VENDOR_NUM
, OPENING_VAR
, AMOUNT
FROM IGI.IGI_CBR_AP_INTERFACE;
IGI.IGI_CBR_AP_INTERFACE does not reference any database object
IGI.IGI_CBR_AP_INTERFACE is referenced by following:
|
|
|