[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_260_TRANSACTIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_260_TRANSACTIONS_V
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 | (70) | Invoice number for finding available transactions by invoice numbers | |
| BANK_ACCOUNT_TEXT | VARCHAR2 | (60) | 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 |
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;
APPS
CE_BANK_ACCTS_GT_V
CE_BANK_BRANCHES_V
CE_LOOKUPS
CE_STATEMENT_HEADERS
CE_STATEMENT_LINES
CE_SYSTEM_PARAMETERS
GL_DAILY_CONVERSION_TYPES
GL_SETS_OF_BOOKS
APPS
CE_AUTO_BANK_MATCH
- show dependent code
CE_AVAILABLE_TRANSACTIONS_V
|
|
|
|