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_SOURCE_OF_IMPORTS

Object Details

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

XTR_SOURCE_OF_IMPORTS contains the import sources for reconciliation and for the instances when you create a single regular payment on a bank statement to consolidate multiple transactions. EDI (Electronic Data Interchange) is an example of an import source.
This table corresponds to the Import Source tabbed region of the Import Source window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NUMBER	VARCHAR2	(20)	Yes	Alpha-numeric reference to financial accounts of Treasury parties
COMMENTS	VARCHAR2	(50)		Comments
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CURRENCY	VARCHAR2	(15)	Yes	Currency code
CURRENTLY_VALID	VARCHAR2	(1)		Flag to indicate if the record is valid currently (Y), or not (N)
FREQUENCY_DAYS	VARCHAR2	(3)		Not currently used
IMPORT_INCLUDES_DECIMAL	VARCHAR2	(1)		Flag to indicate if the import source includes decimal (Y), or not (N)
REVERSE_ON_TRANSFER_YN	VARCHAR2	(1)		Flag to indicate if the trailer record can be reverse (Y), or not (N)
SOURCE	VARCHAR2	(20)	Yes	Reconciliation import source
TRANSFER_TRAILER_YN	VARCHAR2	(1)		Flag to indicate if the trailer record is transferable (Y), or not (N)
VERIFICATION_METHOD	VARCHAR2	(30)		Reconciliation method
VERIFY_TRAILER_TOTALS	VARCHAR2	(1)		Flag to indicate if the trailer record should verify control total (Y), or not (N)
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
,      COMMENTS
,      COMPANY_CODE
,      CURRENCY
,      CURRENTLY_VALID
,      FREQUENCY_DAYS
,      IMPORT_INCLUDES_DECIMAL
,      REVERSE_ON_TRANSFER_YN
,      SOURCE
,      TRANSFER_TRAILER_YN
,      VERIFICATION_METHOD
,      VERIFY_TRAILER_TOTALS
,      BANK_ACCT_USE_ID
FROM XTR.XTR_SOURCE_OF_IMPORTS;

Dependencies

[top of page]

XTR.XTR_SOURCE_OF_IMPORTS does not reference any database object

XTR.XTR_SOURCE_OF_IMPORTS is referenced by following:

XTR: XTR_SOURCE_OF_IMPORTS#