[Home] [Help] [Dependency Information]
Object Name: | CE_AP_FC_DUE_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AP_FC_DUE_INVOICES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_AP_FC_DUE_INVOICES_V view contains unpaid AP invoices for forecasting. The Cash Forecasting program uses this view to generate projected forecast outflow amounts from the unpaid AP invoices based on the due dates on the invoice scheduled payments. When determining forecast amounts, the program selects only the applicable invoices from this view that match the forecast template definition and forecast submission parameters.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Invoice identifier | |
PAYMENT_NUM | NUMBER | (15) | Payment number | |
AMOUNT | NUMBER | Payment amount | ||
BASE_AMOUNT | NUMBER | Payment amount in the functional currency | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the invoice | |
PAYMENT_PRIORITY | NUMBER | Payment priority assigned for the invoice | ||
VENDOR_TYPE | VARCHAR2 | (30) | Vendor type code assigned for the invoice | |
PAYGROUP | VARCHAR2 | (25) | Pay group code assigned for the invoice | |
TRX_DATE | DATE | Payment due date | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
PROJECT_ID | NUMBER | (15) | Identifier for project used to build default Accounting Flexfield | |
ON_HOLD | VARCHAR2 | (1) | Hold placed on invoice | |
INVOICE_NUM | VARCHAR2 | (50) | Invoice Number | |
REFERENCE_ID | VARCHAR2 | (81) | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PAYMENT_NUM
, AMOUNT
, BASE_AMOUNT
, CURRENCY_CODE
, PAYMENT_PRIORITY
, VENDOR_TYPE
, PAYGROUP
, TRX_DATE
, ORG_ID
, PROJECT_ID
, ON_HOLD
, INVOICE_NUM
, REFERENCE_ID
FROM APPS.CE_AP_FC_DUE_INVOICES_V;
|
|
|