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_RECONCILIATION_PASSES

Object Details

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

XTR_RECONCILIATION_PASSES contains the reconciliation criteria for bank statement lines. This table contains the following variables: the bank account number, date, transaction number, and amount required for reconciliation. A reconciliation pass can be used by many reconciliation methods.
This table corresponds to the Reconciliation Passes tabbed region in the Import Sources window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PASS_DESCRIPTION	VARCHAR2	(35)	Yes	Description of the reconciliation pass
RECONCILED_PASS_CODE	VARCHAR2	(2)	Yes	Set of selection criteria used for reconciliation
RECONCILE_DETAIL	VARCHAR2	(15)	Yes	Criteria by which you want to reconcile each column (the list of available criteria differs depending on which column you select)
RECONCILE_ON_COLUMN	VARCHAR2	(10)	Yes	Name of the column to use as criteria for the reconcilation pass

Query Text

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


SELECT PASS_DESCRIPTION
,      RECONCILED_PASS_CODE
,      RECONCILE_DETAIL
,      RECONCILE_ON_COLUMN
FROM XTR.XTR_RECONCILIATION_PASSES;

Dependencies

[top of page]

XTR.XTR_RECONCILIATION_PASSES does not reference any database object

XTR.XTR_RECONCILIATION_PASSES is referenced by following:

APPS: XTR_RECONCILIATION_PASSES