[Home] [Help] [Dependency Information]
Object Name: | CE_AP_FC_DISC_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AP_FC_DISC_INVOICES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_AP_FC_DISC_INVOICES_V view contains unpaid AP invoices and their discount information for forecasting. The Cash Forecasting program then uses the CE_DISC_INVOICES_V view, which is based on this view, to generate projected cash outflow amounts from the AP invoices. Based on the forecast template source definition, the CE_DISC_INVOICES_V view determines which discount to use when calculating the projected cash flow amount for each invoice.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
PAYMENT_NUM | NUMBER | (15) | Yes | Payment number |
DUE_DATE | DATE | Payment due date | ||
FIRST_DISCOUNTED_AMT | NUMBER | Payment amount less the first discount amount | ||
FIRST_DISC_BASE_AMT | NUMBER | Payment amount less the first discount amount in the functional currency | ||
FIRST_DISCOUNT_DATE | DATE | Discount date for the first discount | ||
SECOND_DISCOUNTED_AMT | NUMBER | Payment amount less the second discount amount | ||
SECOND_DISC_BASE_AMT | NUMBER | Payment amount less second discount amount in the functional currency | ||
SECOND_DISCOUNT_DATE | DATE | Discount date for the second discount | ||
THIRD_DISCOUNTED_AMT | NUMBER | Payment amount less the third discount amount | ||
THIRD_DISC_BASE_AMT | NUMBER | Payment amount less third discount amount in the functional currency | ||
THIRD_DISCOUNT_DATE | DATE | Discount date for the third discount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Invoice currency code |
PAYMENT_PRIORITY | NUMBER | Payment priority for the invoice | ||
VENDOR_TYPE | VARCHAR2 | (30) | Vendor type defined for the invoice | |
PAYGROUP | VARCHAR2 | (25) | Pay group defined 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) | Hold placed on invoice | |
INVOICE_NUM | VARCHAR2 | (50) | Yes | Invoice Number |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PAYMENT_NUM
, DUE_DATE
, FIRST_DISCOUNTED_AMT
, FIRST_DISC_BASE_AMT
, FIRST_DISCOUNT_DATE
, SECOND_DISCOUNTED_AMT
, SECOND_DISC_BASE_AMT
, SECOND_DISCOUNT_DATE
, THIRD_DISCOUNTED_AMT
, THIRD_DISC_BASE_AMT
, THIRD_DISCOUNT_DATE
, CURRENCY_CODE
, PAYMENT_PRIORITY
, VENDOR_TYPE
, PAYGROUP
, ORG_ID
, PROJECT_ID
, ON_HOLD
, INVOICE_NUM
FROM APPS.CE_AP_FC_DISC_INVOICES_V;
|
|
|