VIEW: IBY.IBY_FNDCPT_SYS_EFT_PF_B#

Source

View Text - Preformatted

select SYS_EFT_PROFILE_CODE SYS_EFT_PROFILE_CODE, PAYMENT_SYSTEM_ID PAYMENT_SYSTEM_ID, VERIFY_FORMAT_CODE VERIFY_FORMAT_CODE, VERIFY_TRANS_PRTCL_CODE VERIFY_TRANS_PRTCL_CODE, VERIFY_ACK_RDR_CODE VERIFY_ACK_RDR_CODE, SETTLE_REQUIRE_VRFY_FLAG SETTLE_REQUIRE_VRFY_FLAG, FUNDS_XFER_FORMAT_CODE FUNDS_XFER_FORMAT_CODE, FUNDS_XFER_TRANS_PRTCL_CODE FUNDS_XFER_TRANS_PRTCL_CODE, FUNDS_XFER_ACK_RDR_CODE FUNDS_XFER_ACK_RDR_CODE, QUERY_FORMAT_CODE QUERY_FORMAT_CODE, QUERY_TRANS_PRTCL_CODE QUERY_TRANS_PRTCL_CODE, QUERY_ACK_RDR_CODE QUERY_ACK_RDR_CODE, GROUP_BY_ORG GROUP_BY_ORG, GROUP_BY_LEGAL_ENTITY GROUP_BY_LEGAL_ENTITY, GROUP_BY_INT_BANK_ACCOUNT GROUP_BY_INT_BANK_ACCOUNT, GROUP_BY_SETTLEMENT_CURR GROUP_BY_SETTLEMENT_CURR, GROUP_BY_SETTLEMENT_DATE GROUP_BY_SETTLEMENT_DATE, LIMIT_BY_AMT_CURR LIMIT_BY_AMT_CURR, LIMIT_BY_EXCH_RATE_TYPE LIMIT_BY_EXCH_RATE_TYPE, LIMIT_BY_TOTAL_AMT LIMIT_BY_TOTAL_AMT, LIMIT_BY_SETTLEMENT_NUM LIMIT_BY_SETTLEMENT_NUM, INACTIVE_DATE INACTIVE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SETTLEMENT_COMPLETE_POINT SETTLEMENT_COMPLETE_POINT, OVERRIDE_PAYER_DELIVERY_FLAG OVERRIDE_PAYER_DELIVERY_FLAG, PAYER_NOTIFICATION_FORMAT PAYER_NOTIFICATION_FORMAT, PAYER_NOTIFICATION_DEL_METHOD PAYER_NOTIFICATION_DEL_METHOD, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ACCOMPANY_LETTER_FORMAT ACCOMPANY_LETTER_FORMAT, AUTOMATIC_PN_SUBMIT_FLAG AUTOMATIC_PN_SUBMIT_FLAG, PAYER_NOTIFICATION_CONDITION PAYER_NOTIFICATION_CONDITION, PN_COND_NUM_OF_RECEIPTS PN_COND_NUM_OF_RECEIPTS, EXCLUDE_TRXN_DET_EXTRACTION EXCLUDE_TRXN_DET_EXTRACTION, ZD_EDITION_NAME ZD_EDITION_NAME from "IBY"."IBY_FNDCPT_SYS_EFT_PF_B"

View Text - HTML Formatted

SELECT SYS_EFT_PROFILE_CODE SYS_EFT_PROFILE_CODE
, PAYMENT_SYSTEM_ID PAYMENT_SYSTEM_ID
, VERIFY_FORMAT_CODE VERIFY_FORMAT_CODE
, VERIFY_TRANS_PRTCL_CODE VERIFY_TRANS_PRTCL_CODE
, VERIFY_ACK_RDR_CODE VERIFY_ACK_RDR_CODE
, SETTLE_REQUIRE_VRFY_FLAG SETTLE_REQUIRE_VRFY_FLAG
, FUNDS_XFER_FORMAT_CODE FUNDS_XFER_FORMAT_CODE
, FUNDS_XFER_TRANS_PRTCL_CODE FUNDS_XFER_TRANS_PRTCL_CODE
, FUNDS_XFER_ACK_RDR_CODE FUNDS_XFER_ACK_RDR_CODE
, QUERY_FORMAT_CODE QUERY_FORMAT_CODE
, QUERY_TRANS_PRTCL_CODE QUERY_TRANS_PRTCL_CODE
, QUERY_ACK_RDR_CODE QUERY_ACK_RDR_CODE
, GROUP_BY_ORG GROUP_BY_ORG
, GROUP_BY_LEGAL_ENTITY GROUP_BY_LEGAL_ENTITY
, GROUP_BY_INT_BANK_ACCOUNT GROUP_BY_INT_BANK_ACCOUNT
, GROUP_BY_SETTLEMENT_CURR GROUP_BY_SETTLEMENT_CURR
, GROUP_BY_SETTLEMENT_DATE GROUP_BY_SETTLEMENT_DATE
, LIMIT_BY_AMT_CURR LIMIT_BY_AMT_CURR
, LIMIT_BY_EXCH_RATE_TYPE LIMIT_BY_EXCH_RATE_TYPE
, LIMIT_BY_TOTAL_AMT LIMIT_BY_TOTAL_AMT
, LIMIT_BY_SETTLEMENT_NUM LIMIT_BY_SETTLEMENT_NUM
, INACTIVE_DATE INACTIVE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SETTLEMENT_COMPLETE_POINT SETTLEMENT_COMPLETE_POINT
, OVERRIDE_PAYER_DELIVERY_FLAG OVERRIDE_PAYER_DELIVERY_FLAG
, PAYER_NOTIFICATION_FORMAT PAYER_NOTIFICATION_FORMAT
, PAYER_NOTIFICATION_DEL_METHOD PAYER_NOTIFICATION_DEL_METHOD
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ACCOMPANY_LETTER_FORMAT ACCOMPANY_LETTER_FORMAT
, AUTOMATIC_PN_SUBMIT_FLAG AUTOMATIC_PN_SUBMIT_FLAG
, PAYER_NOTIFICATION_CONDITION PAYER_NOTIFICATION_CONDITION
, PN_COND_NUM_OF_RECEIPTS PN_COND_NUM_OF_RECEIPTS
, EXCLUDE_TRXN_DET_EXTRACTION EXCLUDE_TRXN_DET_EXTRACTION
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IBY"."IBY_FNDCPT_SYS_EFT_PF_B"