eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AR_RECEIPTS_F

Object Details

Object Name:	FII_AR_RECEIPTS_F
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_RECEIPTS_F
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_RECEIPTS_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTOR_BILL_TO_CUSTOMER_ID FILTER_DATE ORG_ID APPLIED_PAYMENT_SCHEDULE_ID APPLICATION_STATUS CASH_RECEIPT_ID
FII_AR_RECEIPTS_F_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLIED_CUSTOMER_TRX_ID FILTER_DATE CASH_RECEIPT_ID APPLICATION_STATUS
FII_AR_RECEIPTS_F_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID BILL_TO_CUSTOMER_ID RECEIPT_METHOD_ID HEADER_STATUS FILTER_DATE
FII_AR_RECEIPTS_F_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID ORG_ID APPLIED_PAYMENT_SCHEDULE_ID FILTER_DATE COLLECTOR_BILL_TO_CUSTOMER_ID

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
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
FILTER_DATE	DATE		Yes	Filter date is equal to either apply_date or gl_date
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

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
FROM FII.FII_AR_RECEIPTS_F;

Dependencies

[top of page]

FII.FII_AR_RECEIPTS_F does not reference any database object

FII.FII_AR_RECEIPTS_F is referenced by following:

APPS: FII_AR_NET_REC_INTR_MV; FII_AR_RECEIPTS_F