VIEW: IBY.IBY_FNDCPT_SYS_DC_PF_B#

Source

View Text - Preformatted

select SYS_DC_PROFILE_CODE SYS_DC_PROFILE_CODE, PAYMENT_SYSTEM_ID PAYMENT_SYSTEM_ID, ONLINE_DEB_FORMAT_CODE ONLINE_DEB_FORMAT_CODE, ONLINE_DEB_TRANS_PRTCL_CODE ONLINE_DEB_TRANS_PRTCL_CODE, ONLINE_DEB_ACK_RDR_CODE ONLINE_DEB_ACK_RDR_CODE, SETTLEMENT_REQ_FLAG SETTLEMENT_REQ_FLAG, SETTLEMENT_FORMAT_CODE SETTLEMENT_FORMAT_CODE, SETTLEMENT_TRANS_PRTCL_CODE SETTLEMENT_TRANS_PRTCL_CODE, SETTLEMENT_ACK_RDR_CODE SETTLEMENT_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, 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_DC_PF_B"

View Text - HTML Formatted

SELECT SYS_DC_PROFILE_CODE SYS_DC_PROFILE_CODE
, PAYMENT_SYSTEM_ID PAYMENT_SYSTEM_ID
, ONLINE_DEB_FORMAT_CODE ONLINE_DEB_FORMAT_CODE
, ONLINE_DEB_TRANS_PRTCL_CODE ONLINE_DEB_TRANS_PRTCL_CODE
, ONLINE_DEB_ACK_RDR_CODE ONLINE_DEB_ACK_RDR_CODE
, SETTLEMENT_REQ_FLAG SETTLEMENT_REQ_FLAG
, SETTLEMENT_FORMAT_CODE SETTLEMENT_FORMAT_CODE
, SETTLEMENT_TRANS_PRTCL_CODE SETTLEMENT_TRANS_PRTCL_CODE
, SETTLEMENT_ACK_RDR_CODE SETTLEMENT_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
, 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_DC_PF_B"