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

TABLE: XTR.XTR_IMPORT_TRANSFER_ERRORS

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


XTR_IMPORT_TRANSFER_ERRORS contains the error information associated with a failed statement transfer. Each row stores header information, including the import source, creation date and currency, for a statement and the reason for the error.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COMMENTS VARCHAR2 (255)
Error description
CREATION_DATE DATE
Yes Date the error was recorded
CURRENCY VARCHAR2 (15) Yes Currency code
NET_AMOUNT NUMBER

Amount difference between the statement net total amount from the statement lines and the trailer net total
NET_CREDIT_AMOUNT NUMBER

Amount difference between the statement total credit amount and the trailer total credit amount
NET_DEBIT_AMOUNT NUMBER

Amount difference between the statement total debit amount and the trailer total debit amount
NET_TRANS_NOS NUMBER

Difference between the number of lines in the statement and the trailer total number of transactions
SOURCE VARCHAR2 (20) Yes Reconciliation import source
TRANSFER_BY VARCHAR2 (10) Yes User who initiated the transfer from the interface table
TRANSFER_ON DATE
Yes Date of transfer from interface table
Query Text

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


SELECT COMMENTS
,      CREATION_DATE
,      CURRENCY
,      NET_AMOUNT
,      NET_CREDIT_AMOUNT
,      NET_DEBIT_AMOUNT
,      NET_TRANS_NOS
,      SOURCE
,      TRANSFER_BY
,      TRANSFER_ON
FROM XTR.XTR_IMPORT_TRANSFER_ERRORS;

Dependencies

[top of page]

XTR.XTR_IMPORT_TRANSFER_ERRORS does not reference any database object

XTR.XTR_IMPORT_TRANSFER_ERRORS is referenced by following:

SchemaXTR
ViewXTR_IMPORT_TRANSFER_ERRORS#