[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_260_RECONCILED_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_260_RECONCILED_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_260_RECONCILED_V view contains the bank statement reconciliation information for unreconciling a bank error reconciliation. The reconciliation data selected in this view is
consolidated with other transaction reconciliation data, such as GL journal entries, if any, into the CE_RECONCILED_TRANSACTIONS_V view.
| 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 identifier |
| BANK_ACCOUNT_ID | NUMBER | (15) | Yes | Bank account identifier |
| 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 | |
| TRX_CURRENCY_TYPE | VARCHAR2 | (10) | Transaction currency type | |
| AMOUNT | NUMBER | Transaction amount | ||
| BANK_ACCOUNT_AMOUNT | NUMBER | Yes | 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) | Yes | Transaction status description |
| STATUS | VARCHAR2 | (30) | Yes | Transaction status |
| TRX_DATE | DATE | Yes | Transaction date | |
| CLEARED_DATE | DATE | Yes | Cleared date | |
| MATURITY_DATE | DATE | Maturity date, effective 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 charges amount | ||
| BANK_ERRORS | NUMBER | Bank errors amount, 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 | |
| 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 |
| 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 | Cash receipt identifier, Null | ||
| BANK_BRANCH_ID | NUMBER | (15) | Yes | Bank branch identifier |
| RECEIPT_DATE | DATE | Receipt date, Null | ||
| POSTED_FLAG | VARCHAR2 | (0) | GL posting flag, Null | |
| POSTED_DATE | DATE | GL posting date, Null | ||
| 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 | (0) | Remittance number, Null | |
| CONTROL_END_BALANCE | NUMBER | Statement control ending balance | ||
| APPLICATION_ID | NUMBER | Application identifier, 260 | ||
| COUNT_CLEARED | NUMBER | Internal use | ||
| ACTUAL_AMOUNT_CLEARED | NUMBER | Not used | ||
| CLEARING_TRX_TYPE | CHAR | (9) | Transaction type for clearing | |
| STATEMENT_COMPLETE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the statement is completed or not, Y or N | |
| REQUEST_ID | NUMBER | (15) | Reconciliation request identifier | |
| CE_BANK_ACCT_USE_ID | NUMBER | Bank Account Use identifier | ||
| ORG_ID | NUMBER | Organization identifier | ||
| LEGAL_ENTITY_ID | NUMBER | Legal Entity identifier |
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
, STATEMENT_COMPLETE_FLAG
, REQUEST_ID
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM APPS.CE_260_RECONCILED_V;
APPS
CE_BANK_ACCTS_GT_V
CE_LOOKUPS
CE_STATEMENT_HEADERS
CE_STATEMENT_LINES
CE_STATEMENT_RECONCILS_ALL
CE_SYSTEM_PARAMETERS
CE_TRANSACTION_CODES
GL_DAILY_CONVERSION_TYPES
GL_SETS_OF_BOOKS
APPS
CE_RECONCILED_TRANSACTIONS_V
|
|
|
|