VIEW: APPS.IBY_EXT_FD_DOC_1_0_V

Source

View Text - Preformatted

SELECT PAYMENT_ID , DOCUMENT_PAYABLE_ID , PAYMENT_SERVICE_REQUEST_ID , CALLING_APP_DOC_UNIQUE_REF1 , CALLING_APP_DOC_UNIQUE_REF2 , CALLING_APP_DOC_UNIQUE_REF3 , CALLING_APP_DOC_UNIQUE_REF4 , CALLING_APP_DOC_UNIQUE_REF5 , CALLING_APP_ID , PAY_PROC_TRXN_TYPE_CODE , CALLING_APP_DOCUMENT_UNIQUE_ID , CALLING_APP_DOC_REF_NUMBER , BANK_ASSIGNED_REF_CODE , UNIQUE_REMITTANCE_IDENTIFIER , URI_CHECK_DIGIT , DOC_CATEGORY , DOC_SEQUENCE_NAME , DOC_SEQUENCE_VALUE , PO_NUMBER , DOCUMENT_STATUS , DOCUMENT_STATUS_MEANING , DOCUMENT_DATE , DOCUMENT_CREATION_DATE , PAYMENT_DUE_DATE , DOCUMENT_TYPE , DOCUMENT_TYPE_MEANING , DOCUMENT_DESCRIPTION , DOCUMENT_AMOUNT , DOCUMENT_CURRENCY_CODE , PAYMENT_AMOUNT , PAYMENT_CURRENCY_CODE , DISCOUNT_DATE , PAYMENT_CURR_DISCOUNT_TAKEN , DOCUMENT_CURR_CHARGE_AMOUNT , INTEREST_RATE , BANK_CHARGE_BEARER , BANK_CHARGE_BEARER_MEANING , EXCLUSIVE_PAYMENT_FLAG , DELIVERY_CHANNEL_CODE , DELIVERY_CHANNEL_MEANING , DELIVERY_CHANNEL_FORMAT_VALUE , SETTLEMENT_PRIORITY , SETTLEMENT_PRIORITY_MEANING , AMOUNT_WITHHELD , PAYMENT_REASON_CODE , PAYMENT_REASON_MEANING , PAYMENT_REASON_FORMAT_VALUE , PAYMENT_REASON_COMMENTS , REMITTANCE_MESSAGE1 , REMITTANCE_MESSAGE2 , REMITTANCE_MESSAGE3 , DOC_PAYABLE_ATTR_CAT , FORMATTING_PAYMENT_ID , EMPLOYEE_PAYMENT_FLAG , BORDERO_INT_AMT , BORDERO_ABATEMENT, DOCUMENT_CURRency_TAX_AMOUNT, EXPENSE_RPT_CC_NUM, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, DOC_PAYER_LE_NAME, DOC_PAYER_LE_REG_NUM, DOC_PAYER_TAX_REG_NUM FROM IBY_EXT_FD_DOC_1_0_VT order by CALLING_APP_DOC_REF_NUMBER

View Text - HTML Formatted

SELECT PAYMENT_ID
, DOCUMENT_PAYABLE_ID
, PAYMENT_SERVICE_REQUEST_ID
, CALLING_APP_DOC_UNIQUE_REF1
, CALLING_APP_DOC_UNIQUE_REF2
, CALLING_APP_DOC_UNIQUE_REF3
, CALLING_APP_DOC_UNIQUE_REF4
, CALLING_APP_DOC_UNIQUE_REF5
, CALLING_APP_ID
, PAY_PROC_TRXN_TYPE_CODE
, CALLING_APP_DOCUMENT_UNIQUE_ID
, CALLING_APP_DOC_REF_NUMBER
, BANK_ASSIGNED_REF_CODE
, UNIQUE_REMITTANCE_IDENTIFIER
, URI_CHECK_DIGIT
, DOC_CATEGORY
, DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE
, PO_NUMBER
, DOCUMENT_STATUS
, DOCUMENT_STATUS_MEANING
, DOCUMENT_DATE
, DOCUMENT_CREATION_DATE
, PAYMENT_DUE_DATE
, DOCUMENT_TYPE
, DOCUMENT_TYPE_MEANING
, DOCUMENT_DESCRIPTION
, DOCUMENT_AMOUNT
, DOCUMENT_CURRENCY_CODE
, PAYMENT_AMOUNT
, PAYMENT_CURRENCY_CODE
, DISCOUNT_DATE
, PAYMENT_CURR_DISCOUNT_TAKEN
, DOCUMENT_CURR_CHARGE_AMOUNT
, INTEREST_RATE
, BANK_CHARGE_BEARER
, BANK_CHARGE_BEARER_MEANING
, EXCLUSIVE_PAYMENT_FLAG
, DELIVERY_CHANNEL_CODE
, DELIVERY_CHANNEL_MEANING
, DELIVERY_CHANNEL_FORMAT_VALUE
, SETTLEMENT_PRIORITY
, SETTLEMENT_PRIORITY_MEANING
, AMOUNT_WITHHELD
, PAYMENT_REASON_CODE
, PAYMENT_REASON_MEANING
, PAYMENT_REASON_FORMAT_VALUE
, PAYMENT_REASON_COMMENTS
, REMITTANCE_MESSAGE1
, REMITTANCE_MESSAGE2
, REMITTANCE_MESSAGE3
, DOC_PAYABLE_ATTR_CAT
, FORMATTING_PAYMENT_ID
, EMPLOYEE_PAYMENT_FLAG
, BORDERO_INT_AMT
, BORDERO_ABATEMENT
, DOCUMENT_CURRENCY_TAX_AMOUNT
, EXPENSE_RPT_CC_NUM
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, DOC_PAYER_LE_NAME
, DOC_PAYER_LE_REG_NUM
, DOC_PAYER_TAX_REG_NUM
FROM IBY_EXT_FD_DOC_1_0_VT ORDER BY CALLING_APP_DOC_REF_NUMBER