DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CE_801_RECONCILED_V

Object Details
Object Name: CE_801_RECONCILED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_801_RECONCILED_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The CE_801_RECONCILED_V view contains the Payroll payments reconciliation information that is used for unreconciling a bank statement. The reconciliation data selected in this view is
consolidated with other transaction reconciliation data, such as AP payments, if any, into the CE_RECONCILED_TRANSACTIONS_V view.


[View Source]

Columns
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 (15)
Transaction identifier, assignment action identifier
TRX_TYPE CHAR (7)
Transaction type, PAYMENT
TYPE_MEANING VARCHAR2 (80)
Transaction type meaning, Payment
TRX_NUMBER VARCHAR2 (30)
Transaction number, serial number
CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
TRX_CURRENCY_TYPE VARCHAR2 (10)
Transaction currency type
AMOUNT NUMBER

Transaction amount
BANK_ACCOUNT_AMOUNT NUMBER

Transaction amount in bank currency
AMOUNT_CLEARED NUMBER

Reconciled amount in bank currency including bank charges and errors
GL_DATE DATE

GL date, Null
STATUS_DSP VARCHAR2 (80)
Transaction status description
STATUS VARCHAR2 (1)
Transaction status
TRX_DATE DATE

Transaction date
CLEARED_DATE DATE

Date this payment was reconciled
MATURITY_DATE DATE

Maturity date, Null
EXCHANGE_RATE_DATE DATE

Date used in determining currency exchange rate, Null
EXCHANGE_RATE_TYPE VARCHAR2 (0)
Currency exchange rate type, Null
EXCHANGE_RATE NUMBER

Currency exchange rate, Null
BANK_CHARGES NUMBER

Bank charge amount, Null
BANK_ERRORS NUMBER

Bank error amount, Null
BATCH_NAME VARCHAR2 (0)
Batch name, Null
BATCH_ID NUMBER

Batch identifier, Null
AGENT_NAME VARCHAR2 (0)
Agent name, Null
CUSTOMER_NAME VARCHAR2 (0)
Customer name, Null
VENDOR_NAME VARCHAR2 (0)
Vendor name, Null
CUSTOMER_ID NUMBER

Customer identifier, Null
SUPPLIER_ID NUMBER

Vendor identifier, Null
REFERENCE_TYPE_DSP VARCHAR2 (0)
Reference type description, Null
REFERENCE_TYPE VARCHAR2 (0)
Reference type, Null
REFERENCE_ID NUMBER

Reference identifier
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
STATEMENT_HEADER_ID NUMBER (15)
Statement identifier
CASH_RECEIPT_ID NUMBER

Cash receipt identifier, Null
BANK_BRANCH_ID NUMBER (15)
Bank branch identifier
RECEIPT_DATE DATE

Date earned
POSTED_FLAG VARCHAR2 (0)
GlL posting flag, Null
POSTED_DATE DATE

GL posting date
LINE_TYPE_MEANING VARCHAR2 (80)
Statement line type meaning
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
STATEMENT_LINE_TYPE_MEANING VARCHAR2 (240)
Statement line Transaction Code type meaning
STATEMENT_HEADER_NUMBER VARCHAR2 (50)
Statement header number
STATEMENT_HEADER_DATE DATE

Statement header 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)
Line transaction type
REMITTANCE_NUMBER VARCHAR2 (0)
Remittance number, Null
CONTROL_END_BALANCE NUMBER

Control end balance
APPLICATION_ID NUMBER

Application identifier, 801
COUNT_CLEARED NUMBER

Internal use
ACTUAL_AMOUNT_CLEARED NUMBER

Not used
CLEARING_TRX_TYPE CHAR (3)
Transaction type for clearing, PAYMENT
REQUST_ID NUMBER (15)
Reconciliation request identifier
CE_BANK_ACCT_USE_ID NUMBER (15)
Bank Account Use identifier
ORG_ID NUMBER (15)
Organization identifier
LEGAL_ENTITY_ID NUMBER

Legal Entity identifier
Query Text

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
,      REQUST_ID
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
FROM APPS.CE_801_RECONCILED_V;

Dependencies

[top of page]

APPS.CE_801_RECONCILED_V references the following:

SchemaAPPS
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
ViewCE_LOOKUPS
SynonymCE_SECURITY_PROFILES_GT
SynonymCE_STATEMENT_HEADERS
SynonymCE_STATEMENT_LINES
SynonymCE_STATEMENT_RECONCILS_ALL
SynonymCE_SYSTEM_PARAMETERS
SynonymCE_TRANSACTION_CODES
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymPAY_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_CE_RECONCILED_PAYMENTS
SynonymPAY_ORG_PAYMENT_METHODS_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PRE_PAYMENTS
APPS.CE_801_RECONCILED_V is referenced by following:

SchemaAPPS
ViewCE_RECONCILED_TRANSACTIONS_V