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_STATEMENTS

Object Details

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

View Type

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

It is a document you receive from your bank that shows all your banking activities during the statement period. This contains general bank account and statement information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STATEMENT_ID	NUMBER	(15)	Yes	Bank statement identifier.
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.
BEGINNING_BALANCE	NUMBER			Beginning balance of the bank statement.
DEBIT_TOTAL	NUMBER			Total payment amount of the bank statement.
CREDIT_TOTAL	NUMBER			Total deposit or receipt amount of the bank statement.
ENDING_BALANCE	NUMBER			Ending balance of the bank statement.
DEBIT_LINE_COUNT	NUMBER			Total number of payment transactions in the bank statement.
CREDIT_LINE_COUNT	NUMBER			Total number of receipt transactions in the bank statement.
CURRENCY_CODE	VARCHAR2	(15)		Monetary currency of the amounts shown on the bank statement.
COMPLETION_STATUS	VARCHAR2	(1)		Indicates whether the bank statement is completely reconciled or not.
DOCUMENT_SEQUENCE_NUMBER	NUMBER			A sequence number assigned by the system or by you. This number may be used to uniquely identify your bank statements.
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier.
ORG_ID	NUMBER	(15)		Organization 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.
CHECK_DIGITS	VARCHAR2	(30)		Holds any check digits that result from bank account number validation in FBS.

Query Text

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


SELECT STATEMENT_ID
,      STATEMENT_NUMBER
,      STATEMENT_DATE
,      BEGINNING_BALANCE
,      DEBIT_TOTAL
,      CREDIT_TOTAL
,      ENDING_BALANCE
,      DEBIT_LINE_COUNT
,      CREDIT_LINE_COUNT
,      CURRENCY_CODE
,      COMPLETION_STATUS
,      DOCUMENT_SEQUENCE_NUMBER
,      BANK_ACCOUNT_ID
,      ORG_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      CHECK_DIGITS
FROM APPS.CEBV_BANK_STATEMENTS;

Dependencies

[top of page]

APPS.CEBV_BANK_STATEMENTS references the following:

APPS: CE_STATEMENT_HEADERS

APPS.CEBV_BANK_STATEMENTS is not referenced by any database object