[Home] [Help] [Dependency Information]
Object Name: | CE_DISC_PROJECT_INV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_DISC_PROJECT_INV_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The Cash forecasting program uses this view to generate cash outflow amounts from AP invoices when discount amounts are used for forecasting and project information is entered as a submission parameter. This view has project information plus all the columns in CE_DISC_INVOICES_V.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT | NUMBER | Projected payment amount based on discounts | ||
BASE_AMOUNT | NUMBER | Projected payment amount in the base currency | ||
TRX_DATE | DATE | Transaction date, determined by discount dates | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the invoice | |
PAYMENT_PRIORITY | NUMBER | Payment priority for the invoice | ||
VENDOR_TYPE | VARCHAR2 | (30) | Supplier type of the invoice | |
PAYGROUP | VARCHAR2 | (25) | Pay group assigned for the invoice | |
ORG_ID | NUMBER | (15) | Organization identifier | |
PROJECT_ID | NUMBER | (15) | Identifier for project used to build default Accounting Flexfield | |
ON_HOLD | VARCHAR2 | (1) | Identifier for on hold invoices | |
INVOICE_NUM | VARCHAR2 | (50) | Invoice Number | |
PAYMENT_NUM | NUMBER | (15) | Payment Number | |
REFERENCE_ID | VARCHAR2 | (81) | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT
, BASE_AMOUNT
, TRX_DATE
, CURRENCY_CODE
, PAYMENT_PRIORITY
, VENDOR_TYPE
, PAYGROUP
, ORG_ID
, PROJECT_ID
, ON_HOLD
, INVOICE_NUM
, PAYMENT_NUM
, REFERENCE_ID
FROM APPS.CE_DISC_PROJECT_INV_V;
APPS.CE_DISC_PROJECT_INV_V is not referenced by any database object
|
|
|