[Home] [Help] [Dependency Information]
Object Name: | IGI_AP_INV_DISTRIBUTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGI.IGI_AP_INV_DISTRIBUTIONS_V |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Public Sector Financials (international) view that lists invoice distributions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice ID |
LINE_NUMBER | NUMBER | Invoice line number | ||
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_NAME | VARCHAR2 | (50) | Batch name | |
BATCH_ID | NUMBER | (15) | Batch ID | |
ENTERED_BY | VARCHAR2 | (100) | Yes | Name of person who entered invoice |
APPROVER_ID | NUMBER | Approver ID | ||
IGI_SAP_FLAG | VARCHAR2 | (1) | Secondary approval indicator. Indicates that secondary hold is approved. | |
CREATED_BY | NUMBER | (15) | Standard who column | |
INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice number |
INVOICE_DATE | DATE | Invoice date | ||
INVOICE_AMOUNT | NUMBER | Invoice amount | ||
AMOUNT | NUMBER | Invoice distribution amount | ||
DIST_CODE_COMBINATION_ID | NUMBER | Accounting Flexfield ID for account associated with a distribution line. | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | Line number for invoice distribution line. |
LINE_TYPE | VARCHAR2 | (80) | Yes | Name of line type |
DIST_ROWID | ROWID | (10) | Distribution row ID | |
IGI_ROWID | ROWID | (10) | Row ID | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, LINE_NUMBER
, VENDOR_NAME
, VENDOR_ID
, BATCH_NAME
, BATCH_ID
, ENTERED_BY
, APPROVER_ID
, IGI_SAP_FLAG
, CREATED_BY
, INVOICE_NUM
, INVOICE_DATE
, INVOICE_AMOUNT
, AMOUNT
, DIST_CODE_COMBINATION_ID
, DISTRIBUTION_LINE_NUMBER
, LINE_TYPE
, DIST_ROWID
, IGI_ROWID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGI_AP_INV_DISTRIBUTIONS_V;
APPS.IGI_AP_INV_DISTRIBUTIONS_V is not referenced by any database object
|
|
|