[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_999_RECONCILED_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_999_RECONCILED_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_999_RECONCILED_VIEW view contains the payment and receipt reconciliation
information from external systems for unreconciling a bank statement. 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) | Statement line identifier | |
| BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier | |
| TRX_ID | NUMBER | Transaction identifier | ||
| TRX_TYPE | VARCHAR2 | (7) | Transaction type | |
| TYPE_MEANING | VARCHAR2 | (7) | Transaction type meaning | |
| TRX_NUMBER | VARCHAR2 | (40) | Transaction number | |
| CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency | |
| 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 | GL date | ||
| STATUS_DSP | VARCHAR2 | (30) | Transaction status description | |
| STATUS | VARCHAR2 | (30) | Transaction status | |
| TRX_DATE | DATE | Transaction date | ||
| CLEARED_DATE | DATE | Cleared date | ||
| MATURITY_DATE | DATE | Transaction maturity 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 | ||
| BATCH_NAME | VARCHAR2 | (81) | Batch name | |
| BATCH_ID | NUMBER | Batch identifier | ||
| AGENT_NAME | VARCHAR2 | (0) | Agent name | |
| CUSTOMER_NAME | VARCHAR2 | (0) | Customer name | |
| VENDOR_NAME | VARCHAR2 | (0) | Vendor name | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| SUPPLIER_ID | NUMBER | Supplier identifier | ||
| REFERENCE_TYPE_DSP | VARCHAR2 | (0) | Reference type description | |
| REFERENCE_TYPE | VARCHAR2 | (0) | Reference type | |
| REFERENCE_ID | NUMBER | Reference identifier | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| STATEMENT_HEADER_ID | NUMBER | (15) | Statement identifier | |
| CASH_RECEIPT_ID | NUMBER | Cash receipt identifier | ||
| BANK_BRANCH_ID | NUMBER | (15) | Bank branch identifier | |
| RECEIPT_DATE | DATE | Receipt date | ||
| POSTED_FLAG | VARCHAR2 | (0) | GL posting flag | |
| POSTED_DATE | DATE | GL posting date | ||
| LINE_TYPE_MEANING | VARCHAR2 | (80) | Statement line transaction type | |
| STATEMENT_LINE_NUMBER | NUMBER | (15) | Statement line number | |
| STATEMENT_LINE_DATE | DATE | Statement line date | ||
| STATEMENT_LINE_AMOUNT | NUMBER | Statement line amount | ||
| STATEMENT_LINE_STATUS_MEANING | VARCHAR2 | (30) | Statement line status meaning | |
| STATEMENT_LINE_TYPE_MEANING | VARCHAR2 | (240) | statement line transaction type meaning | |
| STATEMENT_HEADER_NUMBER | VARCHAR2 | (50) | Statement number | |
| STATEMENT_HEADER_DATE | DATE | Statement date | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | (100) | 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) | Statement line transaction type | |
| REMITTANCE_NUMBER | VARCHAR2 | (0) | Remittance number | |
| CONTROL_END_BALANCE | NUMBER | Statement control ending balance | ||
| APPLICATION_ID | NUMBER | Application identifier | ||
| COUNT_CLEARED | NUMBER | Internal use | ||
| ACTUAL_AMOUNT_CLEARED | NUMBER | Not used | ||
| CLEARING_TRX_TYPE | CHAR | (8) | Transaction type for clearing | |
| 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
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM APPS.CE_999_RECONCILED_V;
APPS
CE_185_RECONCILED_V
CE_999_INTERFACE_V
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
|
|
|
|