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

Object Details

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

View Type

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

The CE_222_RECONCILED_V view contains the AR cash receipt reconciliation information that is used for unreconciling. The reconciliation data selected in this view is consolidated with other transaction reconciliation data, such as GLjournal entries, if any, into the CE_RECONCILED_TRANSACTIONS_V view.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database row identifier
MULTI_SELECT	CHAR	(1)		Column used internally
STATEMENT_LINE_ID	NUMBER	(15)	Yes	Statement line indentifier
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank account identifier
TRX_ID	NUMBER	(15)	Yes	Transaction identifier, cash receipt history identifier
TRX_TYPE	VARCHAR2	(20)		Transaction type, RECEIPT
TYPE_MEANING	VARCHAR2	(80)		Transaction type meaning, Receipt
TRX_NUMBER	VARCHAR2	(30)		Transaction number, receipt number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency code
TRX_CURRENCY_TYPE	VARCHAR2	(10)		Transaction currency type
AMOUNT	NUMBER			Transaction amount
BANK_ACCOUNT_AMOUNT	NUMBER			Transaction amount in bank currency
AMOUNT_CLEARED	NUMBER			Cleared amount in bank currency including bank charges and errors
GL_DATE	DATE		Yes	GL date
STATUS_DSP	VARCHAR2	(80)		Transaction status description
STATUS	VARCHAR2	(30)		Transaction status
TRX_DATE	DATE		Yes	Transaction date
CLEARED_DATE	DATE		Yes	Date this receipt was cleared
MATURITY_DATE	DATE			Maturity date, due date
EXCHANGE_RATE_DATE	DATE			Date used in determining currency exchange rate
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency exchange rate type
EXCHANGE_RATE	NUMBER			Currency exchange rate
BANK_CHARGES	NUMBER			Bank charge amount
BANK_ERRORS	NUMBER			Bank error amount, Null
BATCH_NAME	VARCHAR2	(20)		Batch name
BATCH_ID	NUMBER	(15)		Batch identifier
AGENT_NAME	VARCHAR2	(360)		Agent name, customer name
CUSTOMER_NAME	VARCHAR2	(360)		Customer name
VENDOR_NAME	VARCHAR2	(0)		Vendor name, Null
CUSTOMER_ID	NUMBER	(15)		Customer identifier
SUPPLIER_ID	NUMBER			Vendor identifier, Null
REFERENCE_TYPE_DSP	VARCHAR2	(80)		Reference type description
REFERENCE_TYPE	VARCHAR2	(30)		Reference type
REFERENCE_ID	NUMBER	(15)		Reference identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
STATEMENT_HEADER_ID	NUMBER	(15)	Yes	Statement identifier
CASH_RECEIPT_ID	NUMBER	(15)	Yes	Cash receipt identifier
BANK_BRANCH_ID	NUMBER	(15)	Yes	Bank branch identifier
RECEIPT_DATE	DATE		Yes	Receipt date
POSTED_FLAG	VARCHAR2	(1)		GL posting flag
POSTED_DATE	DATE			GL posting date
LINE_TYPE_MEANING	VARCHAR2	(80)	Yes	Statement line type meaning
STATEMENT_LINE_NUMBER	NUMBER	(15)	Yes	Statement line number
STATEMENT_LINE_DATE	DATE		Yes	Statement line date
STATEMENT_LINE_AMOUNT	NUMBER		Yes	Statement line amount
STATEMENT_LINE_STATUS_MEANING	VARCHAR2	(30)	Yes	Statement line status
STATEMENT_LINE_TYPE_MEANING	VARCHAR2	(240)		Statement line Transaction Code type meaning
STATEMENT_HEADER_NUMBER	VARCHAR2	(50)	Yes	Statement header number
STATEMENT_HEADER_DATE	DATE		Yes	Statement header date
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank account name
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
BANK_CURRENCY_CODE	VARCHAR2	(15)		Bank currency code
STATEMENT_DOC_SEQUENCE_VALUE	NUMBER			Document sequence number
LINE_TRX_TYPE	VARCHAR2	(30)	Yes	Line transaction type
REMITTANCE_NUMBER	VARCHAR2	(30)		Remittance number, bank deposit number
CONTROL_END_BALANCE	NUMBER			Statement control ending balance
APPLICATION_ID	NUMBER			Application identifier, 222
COUNT_CLEARED	NUMBER			Internal use
ACTUAL_AMOUNT_CLEARED	NUMBER			Not used
CLEARING_TRX_TYPE	VARCHAR2	(20)		Transaction type for clearing, CASH
REQUEST_ID	NUMBER	(15)		Reconciliation request identifier
INVOICE_TEXT	VARCHAR2	(70)		Invoice Number
BANK_ACCOUNT_TEXT	VARCHAR2	(60)		Customer bank account number
CUSTOMER_TEXT	VARCHAR2	(80)		Customer name
VALUE_DATE	DATE			Value date
CE_BANK_ACCT_USE_ID	NUMBER	(15)	Yes	Bank Account Use identifier
ORG_ID	NUMBER	(15)		Organization identifier
LEGAL_ENTITY_ID	NUMBER			Legal Entity identifier

Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      STATEMENT_LINE_ID
,      BANK_ACCOUNT_ID
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CURRENCY_CODE
,      TRX_CURRENCY_TYPE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      BATCH_NAME
,      BATCH_ID
,      AGENT_NAME
,      CUSTOMER_NAME
,      VENDOR_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      REFERENCE_TYPE_DSP
,      REFERENCE_TYPE
,      REFERENCE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      STATEMENT_HEADER_ID
,      CASH_RECEIPT_ID
,      BANK_BRANCH_ID
,      RECEIPT_DATE
,      POSTED_FLAG
,      POSTED_DATE
,      LINE_TYPE_MEANING
,      STATEMENT_LINE_NUMBER
,      STATEMENT_LINE_DATE
,      STATEMENT_LINE_AMOUNT
,      STATEMENT_LINE_STATUS_MEANING
,      STATEMENT_LINE_TYPE_MEANING
,      STATEMENT_HEADER_NUMBER
,      STATEMENT_HEADER_DATE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_CURRENCY_CODE
,      STATEMENT_DOC_SEQUENCE_VALUE
,      LINE_TRX_TYPE
,      REMITTANCE_NUMBER
,      CONTROL_END_BALANCE
,      APPLICATION_ID
,      COUNT_CLEARED
,      ACTUAL_AMOUNT_CLEARED
,      CLEARING_TRX_TYPE
,      REQUEST_ID
,      INVOICE_TEXT
,      BANK_ACCOUNT_TEXT
,      CUSTOMER_TEXT
,      VALUE_DATE
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.CE_222_RECONCILED_V;

Dependencies

[top of page]

APPS.CE_222_RECONCILED_V references the following:

APPS: AR_BATCHES_ALL; AR_CASH_RECEIPTS_ALL; AR_CASH_RECEIPT_HISTORY_ALL; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; CE_BANK_ACCOUNTS; CE_BANK_ACCT_USES_ALL; CE_LOOKUPS; CE_SECURITY_PROFILES_GT; CE_STATEMENT_HEADERS; CE_STATEMENT_LINES; CE_STATEMENT_RECONCILS_ALL; CE_SYSTEM_PARAMETERS; CE_TRANSACTION_CODES; GL_DAILY_CONVERSION_TYPES; GL_LEDGERS; HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.CE_222_RECONCILED_V is referenced by following:

APPS: CE_AUTO_BANK_MATCH - show dependent code; CE_RECONCILED_TRANSACTIONS_V