[Home] [Help] [Dependency Information]
Object Name: | CE_AR_FC_RECEIPTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_AR_FC_RECEIPTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_AR_FC_RECEIPTS_V view contains AR receipts for forecasting. The Cash Forecasting program uses this view to generate projected forecast inflow amounts from the AR receipts. When determining forecast amounts, the program selects only the applicable receipts from this view that match the forecast template definition and forecast submission parameters. For example, when forecasting based on historical data, the Cash Forecasting program selects only the receipts that were previously cleared or reconciled. Similarly, when forecasting by future method, the program selects only the receipts that are remitted but not yet cleared.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_AMOUNT | NUMBER | Receipt amount in the functional currency | ||
AMOUNT | NUMBER | Receipt amount | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the receipt | |
TRX_DATE | DATE | Transaction date | ||
MATURITY_DATE | DATE | Receipt due date | ||
ACTUAL_VALUE_DATE | DATE | Actual value date | ||
BANK_ACCOUNT_ID | NUMBER | Bank account identifier | ||
RECEIPT_METHOD_ID | NUMBER | (15) | Receipt method identifier | |
STATUS | VARCHAR2 | (30) | Receipt status | |
EFFECTIVE_DATE | DATE | Cleared or anticipated cleared date | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
RECEIPT_NUMBER | VARCHAR2 | (30) | Receipt Number | |
REFERENCE_ID | NUMBER | (15) | Reference identifier | |
CASH_ACTIVITY_DATE | DATE | Cash activity date |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_AMOUNT
, AMOUNT
, CURRENCY_CODE
, TRX_DATE
, MATURITY_DATE
, ACTUAL_VALUE_DATE
, BANK_ACCOUNT_ID
, RECEIPT_METHOD_ID
, STATUS
, EFFECTIVE_DATE
, ORG_ID
, RECEIPT_NUMBER
, REFERENCE_ID
, CASH_ACTIVITY_DATE
FROM APPS.CE_AR_FC_RECEIPTS_V;
|
|
|