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

TABLE: XTR.XTR_EXT_IMPORT_INTERFACE

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


XTR_EXT_IMPORT_INTERFACE contains bank statement information that is about to be transferred into Treasury for reconciliation. Each row with a record type of ?01? corresponds to a statement line or transaction. Transactions are grouped by statements. Statements are uniquely defined by their combination of import source, creation date, and value date. Each statement has one row with record type of ?00? that holds the account, currency, and transferred by information. Each statement also has one row with record type of ?02? that keeps track of the total debits and credits for the statement.
When you transfer a statement for reconciliation, the transaction information from this table is transferred to the XTR_PAY_REC_RECONCILIATION table. If the transfer succeeds, a row is inserted in the XTR_IMPORT_TRAILER_DETAILS table, showing a summary of the transfer. Otherwise, a row is inserted into the XTR_IMPORT_TRANSFER_ERRORS table with the error information.
This table corresponds to the Manual Statement Input window.
Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Bank Statement Transfer Interface
Category: BUSINESS_ENTITY CE_BANK_STATEMENT


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_NUMBER VARCHAR2 (20)
Alpha-numeric reference to financial accounts of Treasury parties
AMOUNT NUMBER

Statement line amount
COMMENTS VARCHAR2 (150)
Comments for a statement line
CREATION_DATE DATE
Yes Statement creation date
CREDIT_AMOUNT NUMBER

Total credit amount of statement (trailer information)
CURRENCY VARCHAR2 (15)
Currency code
DEBIT_AMOUNT NUMBER

Total debit amount of statement (trailer information)
NUMBER_OF_TRANSACTIONS NUMBER

Number of transactions in the statement (trailer information)
PARTICULARS VARCHAR2 (12)
Particulars of a statement line
PARTY_NAME VARCHAR2 (20)
Counterparty code of a statement line
RECORD_TYPE VARCHAR2 (2) Yes Code that identifies if the record is a statement header (00), statement line (01), or statement trailer (02)
SELECT_FOR_TRANSFER VARCHAR2 (1)
Not currently used
SERIAL_REFERENCE VARCHAR2 (12)
Not currently used
SOURCE VARCHAR2 (20) Yes Reconciliation import source
TRANSACTION_CODE VARCHAR2 (2)
Code to indicate the type of transaction (45 for payment or 55 for receipt)
TRANSFER_BY VARCHAR2 (10)
User who initiated the transfer from the interface table
VALUE_DATE DATE
Yes Statement value date
BANK_ACCT_USE_ID NUMBER (15)
ID reference to financial accounts of Treasury parties
Query Text

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


SELECT ACCOUNT_NUMBER
,      AMOUNT
,      COMMENTS
,      CREATION_DATE
,      CREDIT_AMOUNT
,      CURRENCY
,      DEBIT_AMOUNT
,      NUMBER_OF_TRANSACTIONS
,      PARTICULARS
,      PARTY_NAME
,      RECORD_TYPE
,      SELECT_FOR_TRANSFER
,      SERIAL_REFERENCE
,      SOURCE
,      TRANSACTION_CODE
,      TRANSFER_BY
,      VALUE_DATE
,      BANK_ACCT_USE_ID
FROM XTR.XTR_EXT_IMPORT_INTERFACE;

Dependencies

[top of page]

XTR.XTR_EXT_IMPORT_INTERFACE does not reference any database object

XTR.XTR_EXT_IMPORT_INTERFACE is referenced by following:

SchemaAPPS
SynonymXTR_EXT_IMPORT_INTERFACE