[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_999_INTERFACE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_999_INTERFACE_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_999_INTERFACE_V view contains payments and receipts from external systems for reconciliation. In order for reconciliation to work properly, you need to follow these steps:
1. Identify the transaction table(s) that you need to reconcile against your bank statement.
2. Map the transaction table(s) to this view by replacing it with an Oracle database object named CE_999_INTERFACE_V. All the columns of the original view must exist in the new view.
3. The Reconciliation Open Interface is extensible. When you use Oracle Cash Management to reconcile or unreconcile your external transactions, you can perform additional logic during reconciliation or unreconciliation. If you wish to add custom logic (for example, to perform accounting), Oracle Cash Management provides one database package: CE_999_PKG. This database package contains three procedures: Lock Row for transaction locking, Clear for performing any logic when clearing, and Unclear for performing any logic when unclearing your external transactions.
Steps 1 and 2 are mandatory, and step 3 is optional but recommended.
Changing this view requires knowledge of Oracle Database, Oracle tools, and Application Architecture.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Database row identifier | |
| TRX_ID | NUMBER | Transaction identifier | ||
| BANK_ACCOUNT_ID | NUMBER | Bank account identifier | ||
| TRX_TYPE | VARCHAR2 | (1) | Transaction type | |
| TRX_TYPE_DSP | VARCHAR2 | (1) | Transaction type description | |
| TRX_NUMBER | VARCHAR2 | (1) | Transaction number | |
| TRX_DATE | DATE | Transaction date | ||
| CURRENCY_CODE | VARCHAR2 | (1) | Transaction currency code | |
| STATUS | VARCHAR2 | (1) | Transaction status | |
| STATUS_DSP | VARCHAR2 | (1) | Transaction status description | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (1) | Currency exchange rate type | |
| EXCHANGE_RATE_DATE | DATE | Date used in determining currency exchange rate | ||
| EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
| AMOUNT | NUMBER | Transaction amount | ||
| CLEARED_AMOUNT | NUMBER | Cleared amount in bank currency including bank charges and errors | ||
| CHARGES_AMOUNT | NUMBER | Bank charge amount | ||
| ERROR_AMOUNT | NUMBER | Bank error amount | ||
| ACCTD_AMOUNT | NUMBER | Transaction amount in bank currency | ||
| ACCTD_CLEARED_AMOUNT | NUMBER | Cleared amount in bank currency | ||
| ACCTD_CHARGES_AMOUNT | NUMBER | Bank charges in bank currency | ||
| ACCTD_ERROR_AMOUNT | NUMBER | Bank errors in bank currency | ||
| GL_DATE | DATE | GL date | ||
| CLEARED_DATE | DATE | Cleared date | ||
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TRX_ID
, BANK_ACCOUNT_ID
, TRX_TYPE
, TRX_TYPE_DSP
, TRX_NUMBER
, TRX_DATE
, CURRENCY_CODE
, STATUS
, STATUS_DSP
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
, EXCHANGE_RATE
, AMOUNT
, CLEARED_AMOUNT
, CHARGES_AMOUNT
, ERROR_AMOUNT
, ACCTD_AMOUNT
, ACCTD_CLEARED_AMOUNT
, ACCTD_CHARGES_AMOUNT
, ACCTD_ERROR_AMOUNT
, GL_DATE
, CLEARED_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.CE_999_INTERFACE_V;
SYS
DUAL
APPS
CEBV_ECT
CEFV_ECT
CE_999_RECONCILED_V
CE_999_REVERSAL_V
CE_999_TRANSACTIONS_V
|
|
|
|