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: AR.AR_CASH_REMIT_REFS_ALL

Object Details

Object Name:	AR_CASH_REMIT_REFS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CASH_REMIT_REFS_ALL
Subobject Name:
Status:	VALID

This table holds the remittance reference information provided for AutoApply.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CASH_RECOS_ALL_UK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_REFERENCE AUTO_APPLIED MANUALLY_APPLIED RESOLVED_MATCHING_NUMBER
AR_CASH_REMIT_REFS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOLVED_MATCHING_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
REMIT_REFERENCE_ID	NUMBER	(15)	Yes	Remit Reference Identifier
AUTOMATCH_SET_ID	NUMBER	(15)		Automatch Set Identifier
CASH_RECEIPT_ID	NUMBER	(15)		Cash Receipt Identifier
LINE_NUMBER	NUMBER	(15)		Line Number
REFERENCE_SOURCE	VARCHAR2	(30)		Reference Source
CUSTOMER_ID	NUMBER	(15)		Customer Identifier
CUSTOMER_NUMBER	VARCHAR2	(30)		Customer Number
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Bank Account Number
TRANSIT_ROUTING_NUMBER	VARCHAR2	(35)		Transit Routing Number
INVOICE_REFERENCE	VARCHAR2	(50)		Matching number of invoice that a payment is applied to
MATCHING_REFERENCE_DATE	DATE			Date that corresponds to matching number that is stored in Invoice column
RESOLVED_MATCHING_NUMBER	VARCHAR2	(30)		Invoice number that corresponds to matching number
RESOLVED_MATCHING_INSTALLMENT	NUMBER			Payment schedule for invoice number that is stored in matching number column
RESOLVED_MATCHING_DATE	DATE			Transaction date that corresponds to transaction number that is stored in matching number column
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Currency Code of Transaction
AMOUNT_APPLIED	NUMBER			Amount Applied in transaction currency
AMOUNT_APPLIED_FROM	NUMBER			Amount Applied in Receipt Currency
TRANS_TO_RECEIPT_RATE	NUMBER			Exchange rate
INVOICE_STATUS	VARCHAR2	(30)		Status of Invoice
MATCH_RESOLVED_USING	VARCHAR2	(30)		Match Resolved Category
ORG_ID	NUMBER	(15)	Yes	Organization identifier
CUSTOMER_TRX_ID	NUMBER	(15)		Customer Transaction Identifier
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Payment Schedule Identifier
CUSTOMER_REFERENCE	VARCHAR2	(240)		Additional Remittance Information.
AUTO_APPLIED	VARCHAR2	(1)		Auto applied
MANUALLY_APPLIED	VARCHAR2	(1)		Manually applied
INSTALLMENT_NUMBER	NUMBER	(30)		Transactions payment schedule
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program Application Identifier
PROGRAM_ID	NUMBER	(15)		Program Identifier
PROGRAM_UPDATE_DATE	DATE			Program Update date
REQUEST_ID	NUMBER	(15)		Request Identifier
RECEIPT_REFERENCE_STATUS	VARCHAR2	(30)	Yes	Receipt Reference Status
BATCH_ID	NUMBER	(15)		Batch Identifier
TRANSMISSION_ID	NUMBER	(15)		Transmission Identifier
INSTALLMENT_REFERENCE	NUMBER			Installment Reference
MATCH_SCORE_VALUE	NUMBER	(15)		Match Score

Query Text

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


SELECT REMIT_REFERENCE_ID
,      AUTOMATCH_SET_ID
,      CASH_RECEIPT_ID
,      LINE_NUMBER
,      REFERENCE_SOURCE
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      BANK_ACCOUNT_NUMBER
,      TRANSIT_ROUTING_NUMBER
,      INVOICE_REFERENCE
,      MATCHING_REFERENCE_DATE
,      RESOLVED_MATCHING_NUMBER
,      RESOLVED_MATCHING_INSTALLMENT
,      RESOLVED_MATCHING_DATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      INVOICE_STATUS
,      MATCH_RESOLVED_USING
,      ORG_ID
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_REFERENCE
,      AUTO_APPLIED
,      MANUALLY_APPLIED
,      INSTALLMENT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      RECEIPT_REFERENCE_STATUS
,      BATCH_ID
,      TRANSMISSION_ID
,      INSTALLMENT_REFERENCE
,      MATCH_SCORE_VALUE
FROM AR.AR_CASH_REMIT_REFS_ALL;

Dependencies

[top of page]

AR.AR_CASH_REMIT_REFS_ALL does not reference any database object

AR.AR_CASH_REMIT_REFS_ALL is referenced by following:

AR: AR_CASH_REMIT_REFS_ALL#