[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_222_BATCHES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CE_222_BATCHES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_222_BATCHES_V view contains AR remittance batches that are available for reconciling a bank statement. These selected AR batches from this view are consolidated with other transactions, such as AP payment batches, if any, into the CE_AVAILABLE_BATCHES_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 |
| BATCH_ID | NUMBER | (15) | Yes | Batch identifier |
| TRX_NUMBER | VARCHAR2 | (30) | Transaction number, bank deposit number or batch name | |
| TRX_TYPE | VARCHAR2 | (30) | Yes | Transaction type, RECEIPT |
| TYPE_MEANING | VARCHAR2 | (80) | Yes | Transaction type description, Receipt |
| TRX_DATE | DATE | Yes | Transaction date, batch date | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Transaction currency code |
| AMOUNT | NUMBER | Transaction amount, Null | ||
| BANK_ACCOUNT_AMOUNT | NUMBER | Transaction amount in bank currency, Null | ||
| AMOUNT_CLEARED | NUMBER | Cleared amount in bank currency including bank charges and errors, Null | ||
| ACTUAL_AMOUNT_CLEARED | NUMBER | Not used | ||
| GL_DATE | DATE | GL date | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type | |
| USER_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | User-defined currency exchange rate type | |
| EXCHANGE_RATE_DATE | DATE | Date used in determining the currency exchange rate | ||
| EXCHANGE_RATE | NUMBER | Currency exchange rate | ||
| BANK_CHARGES | NUMBER | Bank charge amount | ||
| BANK_ERRORS | NUMBER | Bank error amount | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| CREATION_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
| CLEARED_AMOUNT | NUMBER | Not used | ||
| REMITTANCE_NUMBER | VARCHAR2 | (30) | Remittance number, bank deposit number | |
| APPLICATION_ID | NUMBER | Application identifier, 222 | ||
| COUNT_CLEARED | NUMBER | Internal use | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank account number | |
| BANK_NAME | VARCHAR2 | (360) | Yes | Bank name |
| BANK_BRANCH_NAME | VARCHAR2 | (360) | Yes | Bank branch name |
| BANK_CURRENCY_CODE | VARCHAR2 | (15) | Bank currency code | |
| BATCH_NUMBER | VARCHAR2 | (20) | Yes | Batch number |
| TRX_CURRENCY_TYPE | VARCHAR2 | (10) | Transaction currency type | |
| CE_BANK_ACCT_USE_ID | NUMBER | (15) | Yes | Bank Account Use identifier |
| ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, MULTI_SELECT
, BANK_ACCOUNT_ID
, BANK_ACCOUNT_NAME
, BATCH_ID
, TRX_NUMBER
, TRX_TYPE
, TYPE_MEANING
, TRX_DATE
, CURRENCY_CODE
, AMOUNT
, BANK_ACCOUNT_AMOUNT
, AMOUNT_CLEARED
, ACTUAL_AMOUNT_CLEARED
, GL_DATE
, EXCHANGE_RATE_TYPE
, USER_EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
, EXCHANGE_RATE
, BANK_CHARGES
, BANK_ERRORS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CLEARED_AMOUNT
, REMITTANCE_NUMBER
, APPLICATION_ID
, COUNT_CLEARED
, BANK_ACCOUNT_NUM
, BANK_NAME
, BANK_BRANCH_NAME
, BANK_CURRENCY_CODE
, BATCH_NUMBER
, TRX_CURRENCY_TYPE
, CE_BANK_ACCT_USE_ID
, ORG_ID
FROM APPS.CE_222_BATCHES_V;
APPS
AR_BATCHES_ALL
CE_BANK_ACCOUNTS
CE_BANK_ACCT_USES_ALL
CE_LOOKUPS
CE_SYSTEM_PARAMETERS
GL_DAILY_CONVERSION_TYPES
GL_SETS_OF_BOOKS
HZ_PARTIES
MO_GLOBAL
- show dependent code
APPS
CE_AUTO_BANK_MATCH
- show dependent code
CE_AVAILABLE_BATCHES_V
|
|
|
|