[Home] [Help] [Dependency Information]
Object Name: | CE_AR_FC_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AR_FC_INVOICES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_AR_FC_INVOICES_V view contains AR invoices for forecasting. The Cash Forecasting program uses this view to generate projected cash inflow amounts from the AR invoices. 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 |
---|---|---|---|---|
TRX_NUMBER | VARCHAR2 | (30) | Invoice number | |
BASE_AMOUNT | NUMBER | Invoice amount in the functional currency | ||
AMOUNT | NUMBER | Invoice amount | ||
DISPUTE_AMOUNT | NUMBER | Portion of invoice amounts that are in dispute | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the invoice | |
EXCHANGE_RATE | NUMBER | Currency exchange rate for the foreign currency invoice | ||
TRX_DATE | DATE | Receipt due date | ||
PROFILE_CLASS_ID | NUMBER | (15) | Profile class assigned to the invoice | |
CUSTOMER_TRX_ID | NUMBER | (15) | Invoice identifier | |
ORG_ID | NUMBER | (15) | Organization identifier | |
CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
SITE_USE_ID | NUMBER | (15) | Identifies the customer site associated with the customer | |
INVOICE_DATE | DATE | Transaction date of item | ||
PROFILE_CLASS | VARCHAR2 | (30) | Profile Class | |
REFERENCE_ID | VARCHAR2 | (42) | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_NUMBER
, BASE_AMOUNT
, AMOUNT
, DISPUTE_AMOUNT
, CURRENCY_CODE
, EXCHANGE_RATE
, TRX_DATE
, PROFILE_CLASS_ID
, CUSTOMER_TRX_ID
, ORG_ID
, CUSTOMER_ID
, SITE_USE_ID
, INVOICE_DATE
, PROFILE_CLASS
, REFERENCE_ID
FROM APPS.CE_AR_FC_INVOICES_V;
|
|
|