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.CEBV_BANK_STATEMENT_LINES

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

It is a detailed banking transaction, such as a debit and a credit, and its reconciliation status. Along with the Bank Statements, represents a bank statement receive from bank.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STATEMENT_LINE_ID	NUMBER	(15)	Yes	System-assigned statement line identifier
LINE_NUMBER	NUMBER	(15)	Yes	Statement line number
TRANSACTION_DATE	DATE		Yes	Line transaction date, used to update AP checks cleared date and AR receipts cleared date if EFFECTIVE_DATE is null
TRANSACTION_TYPE	VARCHAR2	(80)	Yes	Transaction type, lookup type BANK_TRX_TYPE
TRANSACTION_CODE	VARCHAR2	(30)		Bank transaction code identifier
AMOUNT	NUMBER		Yes	Statement line amount
RECONCILIATION_STATUS	VARCHAR2	(80)	Yes	Statement line status, lookup type STATEMENT_LINE_STATUS
EFFECTIVE_DATE	DATE			Statement line effective date, used to update AR receipts clearing date.
TRANSACTION_NUMBER	VARCHAR2	(240)		Transaction number that identifies the transaction to be matched against the statement line.
DESCRIPTION	VARCHAR2	(255)		Statement line description.
AGENT	VARCHAR2	(80)		Customer number for finding available transactions by customer numbers
AGENT_BANK_ACCOUNT_NUMBER	VARCHAR2	(60)		Supplier/Customer bank account number for finding available transactions by supplier/customer numbers.
INVOICE_NUMBER	VARCHAR2	(70)		Invoice number for finding available transactions by invoice number
CURRENCY_CODE	VARCHAR2	(15)		Statement line currency code
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type
EXCHANGE_RATE	NUMBER			Currency conversion rate
EXCHANGE_DATE	DATE			Date used in determining the currency exchange rate
TRANSACTION_AMOUNT	NUMBER			Statement line amount in currency code
CHARGES	NUMBER			Bank charges amount.
STATEMENT_NUMBER	VARCHAR2	(50)	Yes	A number or code assigned by the bank to uniquely identify the bank statement.
STATEMENT_DATE	DATE		Yes	Bank Statement generation date.
STATEMENT_ID	NUMBER	(15)	Yes	Bank statement identifier.
CREATED_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATED_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.

Query Text

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


SELECT STATEMENT_LINE_ID
,      LINE_NUMBER
,      TRANSACTION_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_CODE
,      AMOUNT
,      RECONCILIATION_STATUS
,      EFFECTIVE_DATE
,      TRANSACTION_NUMBER
,      DESCRIPTION
,      AGENT
,      AGENT_BANK_ACCOUNT_NUMBER
,      INVOICE_NUMBER
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      TRANSACTION_AMOUNT
,      CHARGES
,      STATEMENT_NUMBER
,      STATEMENT_DATE
,      STATEMENT_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.CEBV_BANK_STATEMENT_LINES;

Dependencies

[top of page]

APPS.CEBV_BANK_STATEMENT_LINES references the following:

APPS: CE_LOOKUPS; CE_STATEMENT_HEADERS; CE_STATEMENT_LINES; CE_TRANSACTION_CODES; GL_DAILY_CONVERSION_TYPES

APPS.CEBV_BANK_STATEMENT_LINES is not referenced by any database object