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]

VIEW: APPS.CEFV_ECT

Object Details

Object Name:	CEFV_ECT
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CEFV_ECT
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows external cash transaction information. An external cash transaction is a payment or receipt from an external system that may be reconciled to bank statements.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER			External payment/receipt identifier.
BANK_ACCOUNT_NUMBER	VARCHAR2	(30)		Bank account number of the external cash transaction.
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank account name of the external cash transaction.
TRANSACTION_TYPE	VARCHAR2	(1)		Type of the external cash transaction, either payment or receipt.
TRANSACTION_NUMBER	VARCHAR2	(1)		Transaction number of the external cash transaction to uniquely identify the transaction.
TRANSACTION_DATE	DATE			Payment/Receipt date of the external cash transaction.
CURRENCY_CODE	VARCHAR2	(1)		Currency code of the external cash transaction.
STATUS	VARCHAR2	(1)		Status of the external cash transaction.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency exchange rate type used for converting the transaction amount to the function amount.
EXCHANGE_RATE_DATE	DATE			Currency exchange rate date used for converting the transaction amount to the functional amount.
EXCHANGE_RATE	NUMBER			Currency exchange rate used for converting the transaction amount to the functional amount when the exchange rate type is 'User'.
AMOUNT	NUMBER			Transaction amount of the external cash transaction.
CLEARED_AMOUNT	NUMBER			Cleared amount of the external transaction.
CHARGES	NUMBER			Any charges applicable to this external transaction.
GL_DATE	DATE			GL accounting date used for distribution entries created for the external transaction.
CREATED_DATE	DATE			Standard WHO column.
CREATED_BY	NUMBER			Standard WHO column.
LAST_UPDATED_DATE	DATE			Standard WHO column.
LAST_UPDATED_BY	NUMBER			Standard WHO column.

Query Text

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


SELECT TRANSACTION_ID
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_NAME
,      TRANSACTION_TYPE
,      TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      CURRENCY_CODE
,      STATUS
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      AMOUNT
,      CLEARED_AMOUNT
,      CHARGES
,      GL_DATE
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.CEFV_ECT;

Dependencies

[top of page]

APPS.CEFV_ECT references the following:

APPS: CE_999_INTERFACE_V; CE_BANK_ACCOUNTS; GL_DAILY_CONVERSION_TYPES

APPS.CEFV_ECT is not referenced by any database object