FND Design Data [Home] [Help]

View: CE_RECONCILED_TRANSACTIONS_V

Product: CE - Cash Management
Description: Reconciled transactions
Implementation/DBA Data: ViewAPPS.CE_RECONCILED_TRANSACTIONS_V
View Text

SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID FROM CE_101_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID FROM CE_200_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID FROM CE_222_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64D */ STATEMENT_COMPLETE_FLAG
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_260_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64D */ STATEMENT_COMPLETE_FLAG
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_260_CF_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64E */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_801_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64E */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_801_EFT_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_999_RECONCILED_V

Columns

Name
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
EXCHANGE_RATE_DSP
STATEMENT_COMPLETE_FLAG
VALUE_DATE
CE_BANK_ACCT_USE_ID
ORG_ID
LEGAL_ENTITY_ID