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: XTR.XTR_PAY_REC_RECONCILIATION

Object Details

Object Name:	XTR_PAY_REC_RECONCILIATION
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_PAY_REC_RECONCILIATION
Subobject Name:
Status:	VALID

XTR_PAY_REC_RECONCILATION contains information on successfully transferred bank statements. Each row corresponds to one statement line. Along with the transaction information, such as amount, date, and party, each row also contains the statement line?s reconciliation status information. When a statement line is reconciled, a reconciled reference number and the pass code used for the reconciliation are stored in the RECONCILED_REFERENCE and RECONCILED_PASS_CODE columns. These two values are also applied to the to the RECONCILED_REFERENCE and RECONCILED_PASS_CODE columns in the XTR_DEAL_DATE_AMOUNTS table.
This table corresponds to the Unreconciled Records region of the Manual Reconciliation window and the Review Reconciled Items and Verify Reconciled Items regions in the Reconciliation Process window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_PAY_REC_RECONCILIATION_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IMPORT_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
COMMENTS	VARCHAR2	(150)		Comments for the transferred transaction
CONFIRMATION_STATUS	VARCHAR2	(1)		Flag to indicate if the statement transaction has been manually reconciled (M) or unreconciled (U) or neither (null value)
CONFIRMED_BY	VARCHAR2	(10)		User who performed the manual confirmation
CONFIRMED_ON	DATE			Date on which the manual confirmation was performed
CREDIT_AMOUNT	NUMBER			Credit amount
DEBIT_AMOUNT	NUMBER			Debit amount
IMPORT_REFERENCE	NUMBER		Yes	Sequence number which uniquely identifies the imported statement line
PARTICULARS	VARCHAR2	(12)		Deal number to which the statement line is reconciled
PARTY_NAME	VARCHAR2	(20)		Counterparty name
RECONCILED_PASS_CODE	VARCHAR2	(2)		Pass code used to reconcile the statement line
RECONCILED_REFERENCE	NUMBER			Unique identifier linking the statement line with its reconciled transaction in the deal date amounts table
RECORD_TYPE	VARCHAR2	(2)		Code that identifies if the record is a statement header (00), statement line (01), or statement trailer (02)
SERIAL_REFERENCE	VARCHAR2	(12)		Not currently used
VALUE_DATE	DATE		Yes	Statement value date

Query Text

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


SELECT COMMENTS
,      CONFIRMATION_STATUS
,      CONFIRMED_BY
,      CONFIRMED_ON
,      CREDIT_AMOUNT
,      DEBIT_AMOUNT
,      IMPORT_REFERENCE
,      PARTICULARS
,      PARTY_NAME
,      RECONCILED_PASS_CODE
,      RECONCILED_REFERENCE
,      RECORD_TYPE
,      SERIAL_REFERENCE
,      VALUE_DATE
FROM XTR.XTR_PAY_REC_RECONCILIATION;

Dependencies

[top of page]

XTR.XTR_PAY_REC_RECONCILIATION does not reference any database object

XTR.XTR_PAY_REC_RECONCILIATION is referenced by following:

XTR: XTR_PAY_REC_RECONCILIATION#