[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CEFV_BANK_STATEMENT_LINES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CE.CEFV_BANK_STATEMENT_LINES
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This shows statement reconciliation information. Statement reconciliation records the reconciliation detail of a transaction against a bank statement line.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STATEMENT_LINE_ID | NUMBER | (15) | Yes | System-assigned statement line identifier |
| LINE_NUMBER | NUMBER | (15) | Yes | Statement line number |
| TRANSACTION_DATE | DATE | Yes | Line transaction date, used to update AP checks cleared date and AR receipts cleared date if EFFECTIVE_DATE is null | |
| TRANSACTION_TYPE | VARCHAR2 | (80) | Yes | Transaction type, lookup type BANK_TRX_TYPE |
| TRANSACTION_CODE | VARCHAR2 | (30) | Bank transaction code identifier | |
| AMOUNT | NUMBER | Yes | Statement line amount | |
| RECONCILIATION_STATUS | VARCHAR2 | (80) | Yes | Statement line status, lookup type STATEMENT_LINE_STATUS |
| EFFECTIVE_DATE | DATE | Statement line effective date, used to update AR receipts clearing date. | ||
| TRANSACTION_NUMBER | VARCHAR2 | (240) | Transaction number that identifies the transaction to be matched against the statement line. | |
| DESCRIPTION | VARCHAR2 | (255) | Statement line description. | |
| AGENT | VARCHAR2 | (80) | Customer number for finding available transactions by customer numbers | |
| AGENT_BANK_ACCOUNT_NUMBER | VARCHAR2 | (60) | Supplier/Customer bank account number for finding available transactions by supplier/customer numbers. | |
| INVOICE_NUMBER | VARCHAR2 | (70) | Invoice number for finding available transactions by invoice number | |
| CURRENCY_CODE | VARCHAR2 | (15) | Statement line currency code | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency conversion rate type | |
| EXCHANGE_RATE | NUMBER | Currency conversion rate | ||
| EXCHANGE_DATE | DATE | Date used in determining the currency exchange rate | ||
| TRANSACTION_AMOUNT | NUMBER | Statement line amount in currency code | ||
| CHARGES | NUMBER | Bank charges amount. | ||
| STATEMENT_NUMBER | VARCHAR2 | (50) | Yes | A number or code assigned by the bank to uniquely identify the bank statement. |
| STATEMENT_DATE | DATE | Yes | Bank Statement generation date. | |
| STATEMENT_ID | NUMBER | (15) | Yes | Bank statement identifier. |
| CREATED_DATE | DATE | Yes | Standard WHO column. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| LAST_UPDATED_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT STATEMENT_LINE_ID
, LINE_NUMBER
, TRANSACTION_DATE
, TRANSACTION_TYPE
, TRANSACTION_CODE
, AMOUNT
, RECONCILIATION_STATUS
, EFFECTIVE_DATE
, TRANSACTION_NUMBER
, DESCRIPTION
, AGENT
, AGENT_BANK_ACCOUNT_NUMBER
, INVOICE_NUMBER
, CURRENCY_CODE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_DATE
, TRANSACTION_AMOUNT
, CHARGES
, STATEMENT_NUMBER
, STATEMENT_DATE
, STATEMENT_ID
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
FROM APPS.CEFV_BANK_STATEMENT_LINES;
APPS
CE_LOOKUPS
CE_STATEMENT_HEADERS
CE_STATEMENT_LINES
CE_TRANSACTION_CODES
GL_DAILY_CONVERSION_TYPES
APPS.CEFV_BANK_STATEMENT_LINES is not referenced by any database object
|
|
|
|