[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_999_REVERSAL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_999_REVERSAL_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_999_REVERSAL_V contains payments and receipts from external systems for unclearing. The transactions selected in this view are consolidated with other transactions, such as AP payments, if any, into the CE_REVERSAL_TRANSACTIONS 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 |
| TRX_ID | NUMBER | Transaction identifier, check identifier | ||
| TRX_TYPE | VARCHAR2 | (1) | Transaction type, CASH or PAYMENT | |
| TYPE_MEANING | VARCHAR2 | (1) | Transaction type meaning, Cash or Payment | |
| TRX_NUMBER | VARCHAR2 | (1) | Transaction number, receipt or check number | |
| CURRENCY_CODE | VARCHAR2 | (1) | Transaction currency code | |
| 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 | (1) | Transaction status description | |
| STATUS | VARCHAR2 | (1) | Transaction status | |
| TRX_DATE | DATE | Transaction date | ||
| CLEARED_DATE | DATE | Cleared Date | ||
| MATURITY_DATE | DATE | Maturity date, due date | ||
| BATCH_NAME | VARCHAR2 | (0) | Batch name | |
| AGENT_NAME | VARCHAR2 | (0) | Agent name, customer name | |
| CUSTOMER_ID | NUMBER | Customer identifier, Null | ||
| SUPPLIER_ID | NUMBER | Supplier identifier, Null | ||
| 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 | ||
| PAYMENT_METHOD | VARCHAR2 | (0) | Payment method, Null | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank account number | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (100) | Yes | Bank account name |
| BANK_CURRENCY_CODE | VARCHAR2 | (15) | Bank currency code | |
| BANK_NAME | VARCHAR2 | (360) | Yes | Bank name |
| REVERSAL_CATEGORY | VARCHAR2 | (0) | Reversal category, Null | |
| REVERSAL_CATEGORY_ID | VARCHAR2 | (0) | Reversal category identifier, Null | |
| REVERSAL_REASON | VARCHAR2 | (0) | Reason for reversal, Null | |
| REVERSAL_REASON_ID | VARCHAR2 | (0) | Reversal reason identifier, Null | |
| REVERSAL_COMMENTS | VARCHAR2 | (0) | Comments for reversal, Null | |
| PAYMENT_METHOD_ID | VARCHAR2 | (0) | Payment method identifier, Null | |
| BATCH_ID | VARCHAR2 | (0) | Batch identifier, Null | |
| CASH_RECEIPT_ID | NUMBER | Cash receipt identifier, Null | ||
| APPLICATION_ID | NUMBER | Application identifier, 999 | ||
| REMITTANCE_NUMBER | VARCHAR2 | (0) | Remittance number, bank deposit number, Null | |
| AGENT_NUMBER | VARCHAR2 | (0) | Agent number, customer number, Null | |
| TRX_RECONCILED_FLAG | CHAR | (1) | Flag to indicate whether the statement line is reconciled or not, Y or N | |
| STATEMENT_LINE_ID | NUMBER | Statement line identifier, Null | ||
| STATEMENT_NUMBER | VARCHAR2 | (0) | Statement number, Null | |
| STATEMENT_LINE_AMOUNT | NUMBER | Statement line amount, Null | ||
| TRX_CURRENCY_TYPE | VARCHAR2 | (10) | Transaction currency type | |
| BASE_AMOUNT | NUMBER | Transaction amount in functional currency | ||
| VALUE_DATE | DATE | Value date | ||
| CE_BANK_ACCT_USE_ID | VARCHAR2 | (0) | Bank Account Use 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
, 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
, BATCH_NAME
, AGENT_NAME
, CUSTOMER_ID
, SUPPLIER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PAYMENT_METHOD
, BANK_ACCOUNT_NUM
, BANK_ACCOUNT_NAME
, BANK_CURRENCY_CODE
, BANK_NAME
, REVERSAL_CATEGORY
, REVERSAL_CATEGORY_ID
, REVERSAL_REASON
, REVERSAL_REASON_ID
, REVERSAL_COMMENTS
, PAYMENT_METHOD_ID
, BATCH_ID
, CASH_RECEIPT_ID
, APPLICATION_ID
, REMITTANCE_NUMBER
, AGENT_NUMBER
, TRX_RECONCILED_FLAG
, STATEMENT_LINE_ID
, STATEMENT_NUMBER
, STATEMENT_LINE_AMOUNT
, TRX_CURRENCY_TYPE
, BASE_AMOUNT
, VALUE_DATE
, CE_BANK_ACCT_USE_ID
, ORG_ID
FROM APPS.CE_999_REVERSAL_V;
APPS
CE_999_INTERFACE_V
CE_BANK_ACCTS_GT_V
CE_BANK_BRANCHES_V
CE_STATEMENT_RECONCILS_ALL
CE_SYSTEM_PARAMETERS
GL_SETS_OF_BOOKS
APPS
CE_REVERSAL_TRANSACTIONS_V
|
|
|
|