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

TABLE: XTR.XTR_RECONCILIATION_PROCESS

Object Details
Object Name: XTR_RECONCILIATION_PROCESS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_RECONCILIATION_PROCESS
Subobject Name:
Status: VALID


XTR_RECONCILIATION_PROCESS contains the reconciliation method definitions. Each reconciliation method is composed of one or more reconciliation passes. The sequence of each pass, which is defined by the reconciliation method, determines the order by which bank statements are reconciled. A reconciliation method can be associated with many import sources.
This table corresponds to the Reconciliation Methods tabbed region in the Import Sources window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ALLOW_HOLIDAYS_YN VARCHAR2 (1)
Not currently used
DAYS_ADJUSTMENT NUMBER

Number of days of tolerance to allow for this reconciliation method
GENERATE_REPORT_YN VARCHAR2 (1)
Not currently used
PROCESS_TYPE VARCHAR2 (1) Yes Flag to indicate if manual (M or null) or automatic (A) match verification is required before the reconciliation is confirmed
RECONCILED_PASS_CODE VARCHAR2 (2) Yes Set of selection criteria used for reconciliation
SEQUENCE_ORDER NUMBER
Yes Order in which the set of reconciliation pass codes is performed for the reconciliation method
VERIFICATION_METHOD VARCHAR2 (30) Yes Reconciliation method
Query Text

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


SELECT ALLOW_HOLIDAYS_YN
,      DAYS_ADJUSTMENT
,      GENERATE_REPORT_YN
,      PROCESS_TYPE
,      RECONCILED_PASS_CODE
,      SEQUENCE_ORDER
,      VERIFICATION_METHOD
FROM XTR.XTR_RECONCILIATION_PROCESS;

Dependencies

[top of page]

XTR.XTR_RECONCILIATION_PROCESS does not reference any database object

XTR.XTR_RECONCILIATION_PROCESS is referenced by following:

SchemaAPPS
SynonymXTR_RECONCILIATION_PROCESS