DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CE_260_TRANSACTIONS_V

Object Details
Object Name: CE_260_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_260_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

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


The CE_260_TRANSACTIONS_V view contains bank statement lines that are available for reconciling bank errors. These selected statement lines from this view are consolidated with other transactions, such as GL journal entries, if any, into the CE_AVAILABLE_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
BANK_ACCOUNT_ID NUMBER (15) Yes Bank account identifier
BANK_ACCOUNT_NAME VARCHAR2 (100) Yes Bank account name
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_NAME VARCHAR2 (360) Yes Bank name
BANK_BRANCH_NAME VARCHAR2 (360) Yes Bank branch name
TRX_ID NUMBER (15) Yes Transaction identifier, statement line identifier
TRX_TYPE VARCHAR2 (30) Yes Transaction type
TYPE_MEANING VARCHAR2 (80) Yes Transaction type meaning
TRX_NUMBER VARCHAR2 (240)
Transaction number, statement line number
CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
AMOUNT NUMBER

Transaction amount
BANK_ACCOUNT_AMOUNT NUMBER
Yes Transaction amount in bank currency
AMOUNT_CLEARED NUMBER

Cleared amount including bank charges and errors
GL_DATE DATE
Yes GL date
STATUS_DSP VARCHAR2 (80) Yes Transaction status description
STATUS VARCHAR2 (30) Yes Transaction status
TRX_DATE DATE
Yes Transaction date
CLEARED_DATE DATE

Cleared date, Null
MATURITY_DATE DATE

Maturity date, effective date
EXCHANGE_RATE_DATE DATE

Date used to determine currency exchange rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type
USER_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type description
EXCHANGE_RATE NUMBER

Currency exchange rate
BANK_CHARGES NUMBER

Bank charges
BANK_ERRORS NUMBER

Bank errors, Null
BATCH_NAME VARCHAR2 (0)
Batch name, Null
BATCH_ID NUMBER

Batch identifier, Null
AGENT_NAME VARCHAR2 (0)
Agent name, Null
CUSTOMER_NAME VARCHAR2 (0)
Customer name, Null
PAYMENT_METHOD VARCHAR2 (0)
Payment method, Null
VENDOR_NAME VARCHAR2 (0)
Vendor name, Null
CUSTOMER_ID NUMBER

Customer identifier, Null
SUPPLIER_ID NUMBER

Vendor identifier, Null
REFERENCE_TYPE_DSP VARCHAR2 (0)
Reference type description, Null
REFERENCE_TYPE VARCHAR2 (0)
Reference type, Null
REFERENCE_ID NUMBER (15) Yes Reference identifier, Null
ACTUAL_AMOUNT_CLEARED NUMBER

Not used
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
REMITTANCE_NUMBER VARCHAR2 (0)
Remittance number, Null
CASH_RECEIPT_ID NUMBER

Cash receipt identifier, Null
APPLICATION_ID NUMBER

Application identifier, 260
COUNT_CLEARED NUMBER

Internal use
BANK_CURRENCY_CODE VARCHAR2 (15)
Bank currency code
TRX_CURRENCY_TYPE VARCHAR2 (10)
Transaction currency type
CODE_COMBINATION_ID NUMBER (15)
GL account code, Null
PERIOD_NAME VARCHAR2 (0)
Accounting period name, Null
JOURNAL_ENTRY_NAME VARCHAR2 (0)
Journal entry name, Null
DOCUMENT_NUMBER NUMBER

Document number, Null
JOURNAL_ENTRY_LINE_NUMBER NUMBER

Journal entry line number, Null
CLEARING_TRX_TYPE CHAR (9)
Transaction type for clearing, STMT_LINE
JOURNAL_CATEGORY VARCHAR2 (0)
Journal category, Null
BASE_AMOUNT NUMBER
Yes Transaction amount in functional currency
RECEIPT_CLASS_ID NUMBER

Receipt class identifier, Null
RECEIPT_METHOD_ID NUMBER

Receipt method identifier, Null
RECEIPT_CLASS_NAME VARCHAR2 (0)
Receipt class name, Null
DEPOSIT_DATE DATE

Deposit date, Null
INVOICE_TEXT VARCHAR2 (30)
Invoice number for finding available transactions by invoice numbers
BANK_ACCOUNT_TEXT VARCHAR2 (30)
Supplier/customer bank account number for finding available transactions by supplier/customer numbers
CUSTOMER_TEXT VARCHAR2 (80)
Customer number for finding available transactions by customer numbers
REVERSED_RECEIPT_FLAG VARCHAR2 (0)
Reversed receipt flag, Null
CHECK_NUMBER NUMBER

Check number, Null
VALUE_DATE DATE

Value date, Null
CE_BANK_ACCT_USE_ID NUMBER

Bank Account Use identifier
LEGAL_ENTITY_ID NUMBER

Legal Entity identifier
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_NAME
,      BANK_BRANCH_NAME
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      USER_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      BATCH_NAME
,      BATCH_ID
,      AGENT_NAME
,      CUSTOMER_NAME
,      PAYMENT_METHOD
,      VENDOR_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      REFERENCE_TYPE_DSP
,      REFERENCE_TYPE
,      REFERENCE_ID
,      ACTUAL_AMOUNT_CLEARED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REMITTANCE_NUMBER
,      CASH_RECEIPT_ID
,      APPLICATION_ID
,      COUNT_CLEARED
,      BANK_CURRENCY_CODE
,      TRX_CURRENCY_TYPE
,      CODE_COMBINATION_ID
,      PERIOD_NAME
,      JOURNAL_ENTRY_NAME
,      DOCUMENT_NUMBER
,      JOURNAL_ENTRY_LINE_NUMBER
,      CLEARING_TRX_TYPE
,      JOURNAL_CATEGORY
,      BASE_AMOUNT
,      RECEIPT_CLASS_ID
,      RECEIPT_METHOD_ID
,      RECEIPT_CLASS_NAME
,      DEPOSIT_DATE
,      INVOICE_TEXT
,      BANK_ACCOUNT_TEXT
,      CUSTOMER_TEXT
,      REVERSED_RECEIPT_FLAG
,      CHECK_NUMBER
,      VALUE_DATE
,      CE_BANK_ACCT_USE_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
FROM APPS.CE_260_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CE_260_TRANSACTIONS_V references the following:

SchemaAPPS
ViewCE_BANK_ACCTS_GT_V
ViewCE_BANK_BRANCHES_V
ViewCE_LOOKUPS
SynonymCE_STATEMENT_HEADERS
SynonymCE_STATEMENT_LINES
SynonymCE_SYSTEM_PARAMETERS
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
APPS.CE_260_TRANSACTIONS_V is referenced by following:

SchemaAPPS
Package BodyCE_AUTO_BANK_MATCH - show dependent code
ViewCE_AVAILABLE_TRANSACTIONS_V