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

TABLE: XTR.XTR_IMPORT_TRAILER_DETAILS

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


XTR_IMPORT_TRAILER_DETAILS contains summary information of successful transfers from the XTR_EXT_IMPORT_INTERFACE table to the XTR_PAY_REC_RECONCILIATION table. Each row corresponds to a successfully transferred statement. This summary information
includes the account number, statement, or creation, date, currency, import source, and import reference number. Each statement line transferred has its information and its import reference number inserted into the XTR_PAY_REC_RECONCILIATION table. The import reference number allows you to trace the statement line in the XTR_PAY_REC_RECONCILIATION table back to the statement transfer in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_IMPORT_TRAILER_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnIMPORT_REFERENCE
XTR_IMPORT_TRAILER_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NUMBER VARCHAR2 (20)
Alpha-numeric reference to financial accounts of Treasury parties
AMOUNT NUMBER

Not currently used
CREATION_DATE DATE
Yes Date the transfer is made
CREDIT_AMOUNT NUMBER

Not currently used
CURRENCY VARCHAR2 (15)
Currency code
DEBIT_AMOUNT NUMBER

Not currently used
IMPORT_REFERENCE NUMBER
Yes Unique reference for the statement transfer
NUMBER_OF_TRANSACTIONS NUMBER

Not currently used
SOURCE VARCHAR2 (20) Yes Reconciliation import source
VALUE_DATE DATE

Not currently used
BANK_ACCT_USE_ID NUMBER (15)
ID reference to financial accounts of Treasury
Query Text

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


SELECT ACCOUNT_NUMBER
,      AMOUNT
,      CREATION_DATE
,      CREDIT_AMOUNT
,      CURRENCY
,      DEBIT_AMOUNT
,      IMPORT_REFERENCE
,      NUMBER_OF_TRANSACTIONS
,      SOURCE
,      VALUE_DATE
,      BANK_ACCT_USE_ID
FROM XTR.XTR_IMPORT_TRAILER_DETAILS;

Dependencies

[top of page]

XTR.XTR_IMPORT_TRAILER_DETAILS does not reference any database object

XTR.XTR_IMPORT_TRAILER_DETAILS is referenced by following:

SchemaXTR
ViewXTR_IMPORT_TRAILER_DETAILS#