DBA Data[Home] [Help]

VIEW: IBY.IBY_UPG_GDFS#

Source

View Text - Preformatted

select CUST_ACCOUNT_ID CUST_ACCOUNT_ID, ACCT_SITE_USE_ID ACCT_SITE_USE_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, DIRDEB_INSTRUCTION_CODE DIRDEB_INSTRUCTION_CODE, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2, PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE, 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 from "IBY"."IBY_UPG_GDFS"
View Text - HTML Formatted

SELECT CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, ACCT_SITE_USE_ID ACCT_SITE_USE_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, DIRDEB_INSTRUCTION_CODE DIRDEB_INSTRUCTION_CODE
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, BANK_INSTRUCTION1_CODE BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTION2_CODE BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTION_DETAILS BANK_INSTRUCTION_DETAILS
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE1
, PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE2
, PAYMENT_TEXT_MESSAGE3 PAYMENT_TEXT_MESSAGE3
, PAYMENT_FORMAT_CODE PAYMENT_FORMAT_CODE
, DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE
, 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
FROM "IBY"."IBY_UPG_GDFS"