DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FII_AR_RECEIPTS_F_V

Object Details
Object Name: FII_AR_RECEIPTS_F_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FII_AR_RECEIPTS_F_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is based on table FII_AR_RECEIPTS_F. It sotres receipts and credit memos.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIVABLE_APPLICATION_ID NUMBER (15) Yes Receivable application identifier for receipts and credit memos
TIME_ID NUMBER (15) Yes Time identifier corresponding to filter date
CASH_RECEIPT_ID NUMBER (15)
Receipt identifier
APPLICATION_STATUS VARCHAR2 (30) Yes Status of the application (UNID, UNAPP, APP, ACC, ACTIVITY, OTHER ACC)
HEADER_STATUS VARCHAR2 (30)
Status of the receipt header (UNID, UNAPP, APP, NSF, REV, STOP)
AMOUNT_APPLIED_RCT NUMBER

Application amount in the receipt original transactional currency
AMOUNT_APPLIED_TRX NUMBER

Application amount in the invoice transactional currency
AMOUNT_APPLIED_RCT_FUNC NUMBER

Application amount in the functional currency calculated using the receipt exchange rate
AMOUNT_APPLIED_TRX_FUNC NUMBER

Application amount in the functional currency calculated using the invoice exchange rate
AMOUNT_APPLIED_RCT_PRIM NUMBER

Application amount in the primary global currency calculated using the receipt exchange date
AMOUNT_APPLIED_TRX_PRIM NUMBER

Application amount in the primary global currency calculated using the invoice exchange date
AMOUNT_APPLIED_RCT_SEC NUMBER

Application amount in the secondary global currency calculated using the receipt exchange date
AMOUNT_APPLIED_TRX_SEC NUMBER

Application amount in the secondary global currency calculated using the invoice exchange date
EARNED_DISCOUNT_AMOUNT_TRX NUMBER

Earned discount amount taken in the transactional currency
EARNED_DISCOUNT_AMOUNT_FUNC NUMBER

Earned discount amount taken in the functional currency
EARNED_DISCOUNT_AMOUNT_PRIM NUMBER

Earned discount amount taken in the DBI primary global currency
EARNED_DISCOUNT_AMOUNT_SEC NUMBER

Earned discount amount taken in the DBI secondary global currency
UNEARNED_DISCOUNT_AMOUNT_TRX NUMBER

Unearned discount amount taken in the transactional currency
UNEARNED_DISCOUNT_AMOUNT_FUNC NUMBER

Unearned discount amount taken in the functional currency
UNEARNED_DISCOUNT_AMOUNT_PRIM NUMBER

Unearned discount amount taken in the DBI primary global currency
UNEARNED_DISCOUNT_AMOUNT_SEC NUMBER

Unearned discount amount taken in the DBI secondary global currency
APPLY_DATE DATE
Yes Application date
GL_DATE DATE
Yes GL date of the receipt header
FILTER_DATE DATE
Yes Filter date is equal to either apply_date or gl_date of the application
APPLICATION_TYPE VARCHAR2 (20) Yes Lookup code for the type of application
APPLIED_PAYMENT_SCHEDULE_ID NUMBER (15)
Payment schedule identifier of the transaction to which this receipt or credit is applied
APPLIED_CUSTOMER_TRX_ID NUMBER (15)
Transaction identifier to which this receipt or credit memo is applied.
CUSTOMER_TRX_ID NUMBER (15)
Identifies the credit memo being applied
PAYMENT_SCHEDULE_ID NUMBER (15)
Identifies the payment_schedule of the credit memo being applied
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
RECEIPT_TYPE VARCHAR2 (20)
Identifies the category of the payment entry as either CASH or MISC
RECEIPT_DATE DATE

Date of the payment entry
RCT_ACTUAL_DATE_CLOSED DATE

Date that the receipt is completely applied
RECEIPT_METHOD_ID NUMBER (15)
Identifies the payment method of a receipt
CURRENCY_CODE VARCHAR2 (15)
Receipt currency code
USER_ID NUMBER (15) Yes Application creator user identifier
BILL_TO_CUSTOMER_ID NUMBER (15)
Bill to customer account identifier of the receipt or credit memo
BILL_TO_SITE_USE_ID NUMBER (15)
Bill to customer site use identifier to the receipt or credit memo
COLLECTOR_BILL_TO_CUSTOMER_ID NUMBER (15)
Bill to customer account identifier to be used for identifying the collector
COLLECTOR_BILL_TO_SITE_USE_ID NUMBER (15)
Bill to customer site use identifier to be used for identifying the collector
ORG_ID NUMBER (15)
Organization identifier
TRX_DATE DATE

Creation date of the transaction to which a receipt or CM is applied
DUE_DATE DATE

Due date of the transaction to which a receipt or CM is applied
CM_PREVIOUS_CUSTOMER_TRX_ID NUMBER

Populated for regular credit memos with the identifier of the credited transaction. This identifier is not populated for on-account credit memos that are applied to transactions.
TOTAL_RECEIPT_COUNT NUMBER

Number of receipts
CREATION_DATE DATE
Yes Standard who columns
CREATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard who columns
AR_CREATION_DATE DATE
Yes Creation date in AR source table
HEADER_FILTER_DATE DATE

Filter date is equal to either receipt_date or gl_date of the receipt header
UNAPP_AMOUNT NUMBER

Unapplied amount in the receipt original transactional currency
UNAPP_AMOUNT_FUNC NUMBER

Unapplied amount in the functional currency using the receipt exchange rate
UNAPP_AMOUNT_PRIM NUMBER

Unapplied amount in the primary global currency using the receipt exchange rate
UNAPP_AMOUNT_SEC NUMBER

Unapplied amount in the secondary global currency using the receipt exchange rate
UNID_AMOUNT NUMBER

Unidentified amount in the receipt original transactional currency
UNID_AMOUNT_FUNC NUMBER

Unidentified amount in the functional currency using the receipt exchange rate
UNID_AMOUNT_PRIM NUMBER

Unidentified amount in the primary global currency using the receipt exchange rate
UNID_AMOUNT_SEC NUMBER

Unidentified amount in the secondary global currency using the receipt exchange rate
APP_AMOUNT NUMBER

Applied amount in the receipt original transactional currency
APP_AMOUNT_FUNC NUMBER

Applied amount in the functional currency using the receipt exchange rate
APP_AMOUNT_PRIM NUMBER

Applied amount in the primary global currency using the receipt exchange rate
APP_AMOUNT_SEC NUMBER

Applied amount in the secondary global currency using the receipt exchange rate
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECEIVABLE_APPLICATION_ID
,      TIME_ID
,      CASH_RECEIPT_ID
,      APPLICATION_STATUS
,      HEADER_STATUS
,      AMOUNT_APPLIED_RCT
,      AMOUNT_APPLIED_TRX
,      AMOUNT_APPLIED_RCT_FUNC
,      AMOUNT_APPLIED_TRX_FUNC
,      AMOUNT_APPLIED_RCT_PRIM
,      AMOUNT_APPLIED_TRX_PRIM
,      AMOUNT_APPLIED_RCT_SEC
,      AMOUNT_APPLIED_TRX_SEC
,      EARNED_DISCOUNT_AMOUNT_TRX
,      EARNED_DISCOUNT_AMOUNT_FUNC
,      EARNED_DISCOUNT_AMOUNT_PRIM
,      EARNED_DISCOUNT_AMOUNT_SEC
,      UNEARNED_DISCOUNT_AMOUNT_TRX
,      UNEARNED_DISCOUNT_AMOUNT_FUNC
,      UNEARNED_DISCOUNT_AMOUNT_PRIM
,      UNEARNED_DISCOUNT_AMOUNT_SEC
,      APPLY_DATE
,      GL_DATE
,      FILTER_DATE
,      APPLICATION_TYPE
,      APPLIED_PAYMENT_SCHEDULE_ID
,      APPLIED_CUSTOMER_TRX_ID
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      RECEIPT_NUMBER
,      RECEIPT_TYPE
,      RECEIPT_DATE
,      RCT_ACTUAL_DATE_CLOSED
,      RECEIPT_METHOD_ID
,      CURRENCY_CODE
,      USER_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      COLLECTOR_BILL_TO_CUSTOMER_ID
,      COLLECTOR_BILL_TO_SITE_USE_ID
,      ORG_ID
,      TRX_DATE
,      DUE_DATE
,      CM_PREVIOUS_CUSTOMER_TRX_ID
,      TOTAL_RECEIPT_COUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AR_CREATION_DATE
,      HEADER_FILTER_DATE
,      UNAPP_AMOUNT
,      UNAPP_AMOUNT_FUNC
,      UNAPP_AMOUNT_PRIM
,      UNAPP_AMOUNT_SEC
,      UNID_AMOUNT
,      UNID_AMOUNT_FUNC
,      UNID_AMOUNT_PRIM
,      UNID_AMOUNT_SEC
,      APP_AMOUNT
,      APP_AMOUNT_FUNC
,      APP_AMOUNT_PRIM
,      APP_AMOUNT_SEC
FROM APPS.FII_AR_RECEIPTS_F_V;

Dependencies

[top of page]

APPS.FII_AR_RECEIPTS_F_V references the following:

SchemaAPPS
SynonymFII_AR_RECEIPTS_F

APPS.FII_AR_RECEIPTS_F_V is not referenced by any database object