VIEW: APPS.ECE_PYO_PAYMENT_V

Source

View Text - Preformatted

SELECT PmtGt.COMMUNICATION_METHOD COMMUNICATION_METHOD, PmtGt.TEST_FLAG TEST_FLAG, PmtGt.DOCUMENT_ID DOCUMENT_ID, PmtGt.DOCUMENT_CODE DOCUMENT_CODE, PmtGt.BK_TP_TRANSLATOR_CODE BK_TP_TRANSLATOR_CODE, PmtGt.BK_TP_LOCATION_CODE_EXT BK_TP_LOCATION_CODE_EXT, PmtGt.BK_TP_DESCRIPTION BK_TP_DESCRIPTION, PmtGt.BK_TP_REFERENCE_EXT1 BK_TP_REFERENCE_EXT1, PmtGt.BK_TP_REFERENCE_EXT2 BK_TP_REFERENCE_EXT2, PmtGt.TRANSACTION_DATE TRANSACTION_DATE, PmtGt.TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY, PmtGt.TPH_ATTRIBUTE1 TPH_ATTRIBUTE1, PmtGt.TPH_ATTRIBUTE2 TPH_ATTRIBUTE2, PmtGt.TPH_ATTRIBUTE3 TPH_ATTRIBUTE3, PmtGt.TPH_ATTRIBUTE4 TPH_ATTRIBUTE4, PmtGt.TPH_ATTRIBUTE5 TPH_ATTRIBUTE5, PmtGt.TPH_ATTRIBUTE6 TPH_ATTRIBUTE6, PmtGt.TPH_ATTRIBUTE7 TPH_ATTRIBUTE7, PmtGt.TPH_ATTRIBUTE8 TPH_ATTRIBUTE8, PmtGt.TPH_ATTRIBUTE9 TPH_ATTRIBUTE9, PmtGt.TPH_ATTRIBUTE10 TPH_ATTRIBUTE10, PmtGt.TPH_ATTRIBUTE11 TPH_ATTRIBUTE11, PmtGt.TPH_ATTRIBUTE12 TPH_ATTRIBUTE12, PmtGt.TPH_ATTRIBUTE13 TPH_ATTRIBUTE13, PmtGt.TPH_ATTRIBUTE14 TPH_ATTRIBUTE14, PmtGt.TPH_ATTRIBUTE15 TPH_ATTRIBUTE15, PmtGt.TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY, PmtGt.TPD_ATTRIBUTE1 TPD_ATTRIBUTE1, PmtGt.TPD_ATTRIBUTE2 TPD_ATTRIBUTE2, PmtGt.TPD_ATTRIBUTE3 TPD_ATTRIBUTE3, PmtGt.TPD_ATTRIBUTE4 TPD_ATTRIBUTE4, PmtGt.TPD_ATTRIBUTE5 TPD_ATTRIBUTE5, PmtGt.DOCUMENT_STANDARD DOCUMENT_STANDARD, PmtGt.TRANSACTION_HANDLING_CODE TRANSACTION_HANDLING_CODE, PmtGt.CHECK_AMOUNT CHECK_AMOUNT, PmtGt.CURRENCY_CODE CURRENCY_CODE, PmtGt.EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD, PmtGt.EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT, PmtGt.BANK_BRANCH_TYPE BANK_BRANCH_TYPE, PmtGt.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, PmtGt.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, PmtGt.BANK_EDI_ID_NUMBER BANK_EDI_ID_NUMBER, PmtGt.VENDOR_BANK_BRANCH_TYPE VENDOR_BANK_BRANCH_TYPE, PmtGt.VENDOR_BANK_ACCOUNT_TYPE VENDOR_BANK_ACCOUNT_TYPE, PmtGt.VENDOR_BANK_ACCOUNT_NUM VENDOR_BANK_ACCOUNT_NUM, PmtGt.PAYMENT_DATE PAYMENT_DATE, PmtGt.BANK_NUM BANK_NUM, PmtGt.VENDOR_BANK_NUM VENDOR_BANK_NUM, PmtGt.EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD, PmtGt.EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION, PmtGt.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, PmtGt.CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM, PmtGt.SELECTED_CHECK_ID SELECTED_CHECK_ID, PmtGt.CHECK_NUMBER CHECK_NUMBER, PmtGt.CUSTOMER_NUM CUSTOMER_NUM, PmtGt.SEGMENT1 SEGMENT1, PmtGt.VENDOR_EDI_ID_NUMBER VENDOR_EDI_ID_NUMBER, PmtGt.SEGMENT2 SEGMENT2, PmtGt.SEGMENT3 SEGMENT3, PmtGt.SEGMENT4 SEGMENT4, PmtGt.SEGMENT5 SEGMENT5, PmtGt.BANK_BRANCH_ID BANK_BRANCH_ID, PmtGt.BK_BANK_BRANCH_NAME BK_BANK_BRANCH_NAME, PmtGt.BK_ADDRESS_LINE1 BK_ADDRESS_LINE1, PmtGt.BK_ADDRESS_LINE2 BK_ADDRESS_LINE2, PmtGt.BK_ADDRESS_LINE3 BK_ADDRESS_LINE3, PmtGt.BK_CITY BK_CITY, PmtGt.BK_ZIP BK_ZIP, PmtGt.BK_COUNTRY BK_COUNTRY, PmtGt.BK_STATE BK_STATE, PmtGt.BK_PROVINCE BK_PROVINCE, PmtGt.BK_CONTACT_FIRST_NAME BK_CONTACT_FIRST_NAME, PmtGt.BK_CONTACT_MIDDLE_NAME BK_CONTACT_MIDDLE_NAME, PmtGt.BK_CONTACT_LAST_NAME BK_CONTACT_LAST_NAME, PmtGt.BK_CONTACT_TITLE BK_CONTACT_TITLE, PmtGt.BK_CONTACT_PREFIX BK_CONTACT_PREFIX, PmtGt.BK_CONTACT_AREA_CODE BK_CONTACT_AREA_CODE, PmtGt.BK_CONTACT_PHONE BK_CONTACT_PHONE, PmtGt.VENDOR_SITE_CODE VENDOR_SITE_CODE, PmtGt.VENDOR_NAME VENDOR_NAME, PmtGt.ADDRESS_LINE1 ADDRESS_LINE1, PmtGt.ADDRESS_LINE2 ADDRESS_LINE2, PmtGt.ADDRESS_LINE3 ADDRESS_LINE3, PmtGt.ADDRESS_LINE4 ADDRESS_LINE4, PmtGt.CITY CITY, PmtGt.ZIP ZIP, PmtGt.COUNTRY COUNTRY, PmtGt.STATE STATE, PmtGt.PROVINCE PROVINCE, PmtGt.ABA_GLOBAL_ATTRIBUTE_CATEGORY ABA_GLOBAL_ATTRIBUTE_CATEGORY, PmtGt.ABA_GLOBAL_ATTRIBUTE1 ABA_GLOBAL_ATTRIBUTE1, PmtGt.ABA_GLOBAL_ATTRIBUTE2 ABA_GLOBAL_ATTRIBUTE2, PmtGt.ABA_GLOBAL_ATTRIBUTE3 ABA_GLOBAL_ATTRIBUTE3, PmtGt.ABA_GLOBAL_ATTRIBUTE4 ABA_GLOBAL_ATTRIBUTE4, PmtGt.ABA_GLOBAL_ATTRIBUTE5 ABA_GLOBAL_ATTRIBUTE5, PmtGt.ABA_GLOBAL_ATTRIBUTE6 ABA_GLOBAL_ATTRIBUTE6, PmtGt.ABA_GLOBAL_ATTRIBUTE7 ABA_GLOBAL_ATTRIBUTE7, PmtGt.ABA_GLOBAL_ATTRIBUTE8 ABA_GLOBAL_ATTRIBUTE8, PmtGt.ABA_GLOBAL_ATTRIBUTE9 ABA_GLOBAL_ATTRIBUTE9, PmtGt.ABA_GLOBAL_ATTRIBUTE10 ABA_GLOBAL_ATTRIBUTE10, PmtGt.ABA_GLOBAL_ATTRIBUTE11 ABA_GLOBAL_ATTRIBUTE11, PmtGt.ABA_GLOBAL_ATTRIBUTE12 ABA_GLOBAL_ATTRIBUTE12, PmtGt.ABA_GLOBAL_ATTRIBUTE13 ABA_GLOBAL_ATTRIBUTE13, PmtGt.ABA_GLOBAL_ATTRIBUTE14 ABA_GLOBAL_ATTRIBUTE14, PmtGt.ABA_GLOBAL_ATTRIBUTE15 ABA_GLOBAL_ATTRIBUTE15, PmtGt.ABA_GLOBAL_ATTRIBUTE16 ABA_GLOBAL_ATTRIBUTE16, PmtGt.ABA_GLOBAL_ATTRIBUTE17 ABA_GLOBAL_ATTRIBUTE17, PmtGt.ABA_GLOBAL_ATTRIBUTE18 ABA_GLOBAL_ATTRIBUTE18, PmtGt.ABA_GLOBAL_ATTRIBUTE19 ABA_GLOBAL_ATTRIBUTE19, PmtGt.ABA_GLOBAL_ATTRIBUTE20 ABA_GLOBAL_ATTRIBUTE20, PmtGt.ABAS_GLOBAL_ATTRIBUTE_CATEGORY ABAS_GLOBAL_ATTRIBUTE_CATEGORY, PmtGt.ABAS_GLOBAL_ATTRIBUTE1 ABAS_GLOBAL_ATTRIBUTE1, PmtGt.ABAS_GLOBAL_ATTRIBUTE2 ABAS_GLOBAL_ATTRIBUTE2, PmtGt.ABAS_GLOBAL_ATTRIBUTE3 ABAS_GLOBAL_ATTRIBUTE3, PmtGt.ABAS_GLOBAL_ATTRIBUTE4 ABAS_GLOBAL_ATTRIBUTE4, PmtGt.ABAS_GLOBAL_ATTRIBUTE5 ABAS_GLOBAL_ATTRIBUTE5, PmtGt.ABAS_GLOBAL_ATTRIBUTE6 ABAS_GLOBAL_ATTRIBUTE6, PmtGt.ABAS_GLOBAL_ATTRIBUTE7 ABAS_GLOBAL_ATTRIBUTE7, PmtGt.ABAS_GLOBAL_ATTRIBUTE8 ABAS_GLOBAL_ATTRIBUTE8, PmtGt.ABAS_GLOBAL_ATTRIBUTE9 ABAS_GLOBAL_ATTRIBUTE9, PmtGt.ABAS_GLOBAL_ATTRIBUTE10 ABAS_GLOBAL_ATTRIBUTE10, PmtGt.ABAS_GLOBAL_ATTRIBUTE11 ABAS_GLOBAL_ATTRIBUTE11, PmtGt.ABAS_GLOBAL_ATTRIBUTE12 ABAS_GLOBAL_ATTRIBUTE12, PmtGt.ABAS_GLOBAL_ATTRIBUTE13 ABAS_GLOBAL_ATTRIBUTE13, PmtGt.ABAS_GLOBAL_ATTRIBUTE14 ABAS_GLOBAL_ATTRIBUTE14, PmtGt.ABAS_GLOBAL_ATTRIBUTE15 ABAS_GLOBAL_ATTRIBUTE15, PmtGt.ABAS_GLOBAL_ATTRIBUTE16 ABAS_GLOBAL_ATTRIBUTE16, PmtGt.ABAS_GLOBAL_ATTRIBUTE17 ABAS_GLOBAL_ATTRIBUTE17, PmtGt.ABAS_GLOBAL_ATTRIBUTE18 ABAS_GLOBAL_ATTRIBUTE18, PmtGt.ABAS_GLOBAL_ATTRIBUTE19 ABAS_GLOBAL_ATTRIBUTE19, PmtGt.ABAS_GLOBAL_ATTRIBUTE20 ABAS_GLOBAL_ATTRIBUTE20, PmtGt.PVS_GLOBAL_ATTRIBUTE_CATEGORY PVS_GLOBAL_ATTRIBUTE_CATEGORY, PmtGt.PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1, PmtGt.PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2, PmtGt.PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3, PmtGt.PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4, PmtGt.PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5, PmtGt.PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6, PmtGt.PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7, PmtGt.PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8, PmtGt.PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9, PmtGt.PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10, PmtGt.PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11, PmtGt.PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12, PmtGt.PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13, PmtGt.PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14, PmtGt.PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15, PmtGt.PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16, PmtGt.PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17, PmtGt.PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18, PmtGt.PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19, PmtGt.PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20, PmtGt.BK_EFT_SWIFT_CODE BK_EFT_SWIFT_CODE, PmtGt.SBK_BANK_BRANCH_NUMBER SBK_BANK_BRANCH_NUMBER, PmtGt.SBK_BANK_BRANCH_NAME SBK_BANK_BRANCH_NAME, PmtGt.SBK_ADDRESS_LINE1 SBK_ADDRESS_LINE1, PmtGt.SBK_ADDRESS_LINE2 SBK_ADDRESS_LINE2, PmtGt.SBK_ADDRESS_LINE3 SBK_ADDRESS_LINE3, PmtGt.SBK_CITY SBK_CITY, PmtGt.SBK_STATE SBK_STATE, PmtGt.SBK_ZIP SBK_ZIP, PmtGt.SBK_PROVINCE SBK_PROVINCE, PmtGt.SBK_COUNTRY SBK_COUNTRY, PmtGt.SBK_EFT_SWIFT_CODE SBK_EFT_SWIFT_CODE, PmtGt.BILL_TO_INT_LOCATION_NAME BILL_TO_INT_LOCATION_NAME, PmtGt.BILL_TO_INT_ADDRESS1 BILL_TO_INT_ADDRESS1, PmtGt.BILL_TO_INT_ADDRESS2 BILL_TO_INT_ADDRESS2, PmtGt.BILL_TO_INT_ADDRESS3 BILL_TO_INT_ADDRESS3, PmtGt.BILL_TO_INT_CITY BILL_TO_INT_CITY, PmtGt.BILL_TO_INT_POSTAL_CODE BILL_TO_INT_POSTAL_CODE, PmtGt.BILL_TO_INT_COUNTRY BILL_TO_INT_COUNTRY, PmtGt.FI_VAT_REGISTRATION_NUM FI_VAT_REGISTRATION_NUM, PmtGt.BILL_TO_INT_LOCATION_ID BILL_TO_INT_LOCATION_ID, PmtGt.ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE, PmtGt.BILL_TO_INT_REGION1 BILL_TO_INT_REGION1, PmtGt.BILL_TO_INT_REGION2 BILL_TO_INT_REGION2, PmtGt.BILL_TO_INT_REGION3 BILL_TO_INT_REGION3, PmtGt.MAP_ID MAP_ID, PmtGt.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE, PmtGt.VENDOR_ALTERNATE_NAME VENDOR_ALTERNATE_NAME, PmtGt.VENDOR_ALTERNATE_SITE_CODE VENDOR_ALTERNATE_SITE_CODE, PmtGt.SUPPLIER_CHECK_DIGITS SUPPLIER_CHECK_DIGITS, PmtGt.SBK_BANK_NAME SBK_BANK_NAME, PmtGt.IBAN_NUMBER IBAN_NUMBER, PmtGt.VENDOR_IBAN_NUMBER VENDOR_IBAN_NUMBER, PmtGt.PAYMENT_MEAN PAYMENT_MEAN, PmtGt.PAYMENT_CHANNEL PAYMENT_CHANNEL, PmtGt.VENDOR_ID VENDOR_ID, PmtGt.VENDOR_SITE_ID VENDOR_SITE_ID, PmtGt.PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER, PmtGt.SBK_BANK_CODE SBK_BANK_CODE, PmtGt.PAYMENT_PROCESS_REQUEST_NAME PAYMENT_PROCESS_REQUEST_NAME, PmtGt.PAYMENT_ORG_ID PAYMENT_ORG_ID, PmtGt.BANK_NAME BANK_NAME, PmtGt.BRANCH_NUMBER BRANCH_NUMBER, PmtGt.BANK_ACCOUNT_ID BANK_ACCOUNT_ID, PmtGt.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, PmtGt.BK_ACCT_ATTRIBUTE_CATEGORY BK_ACCT_ATTRIBUTE_CATEGORY, PmtGt.BK_ACCT_ATTRIBUTE1 BK_ACCT_ATTRIBUTE1, PmtGt.BK_ACCT_ATTRIBUTE2 BK_ACCT_ATTRIBUTE2, PmtGt.BK_ACCT_ATTRIBUTE3 BK_ACCT_ATTRIBUTE3, PmtGt.BK_ACCT_ATTRIBUTE4 BK_ACCT_ATTRIBUTE4, PmtGt.BK_ACCT_ATTRIBUTE5 BK_ACCT_ATTRIBUTE5, PmtGt.BK_ACCT_ATTRIBUTE6 BK_ACCT_ATTRIBUTE6, PmtGt.BK_ACCT_ATTRIBUTE7 BK_ACCT_ATTRIBUTE7, PmtGt.BK_ACCT_ATTRIBUTE8 BK_ACCT_ATTRIBUTE8, PmtGt.BK_ACCT_ATTRIBUTE9 BK_ACCT_ATTRIBUTE9, PmtGt.BK_ACCT_ATTRIBUTE10 BK_ACCT_ATTRIBUTE10, PmtGt.BK_ACCT_ATTRIBUTE11 BK_ACCT_ATTRIBUTE11, PmtGt.BK_ACCT_ATTRIBUTE12 BK_ACCT_ATTRIBUTE12, PmtGt.BK_ACCT_ATTRIBUTE13 BK_ACCT_ATTRIBUTE13, PmtGt.BK_ACCT_ATTRIBUTE14 BK_ACCT_ATTRIBUTE14, PmtGt.BK_ACCT_ATTRIBUTE15 BK_ACCT_ATTRIBUTE15, PmtGt.VENDOR_BANK_ACCOUNT_ID VENDOR_BANK_ACCOUNT_ID, PmtGt.SBK_ACCT_ATTRIBUTE_CATEGORY SBK_ACCT_ATTRIBUTE_CATEGORY, PmtGt.SBK_ACCT_ATTRIBUTE1 SBK_ACCT_ATTRIBUTE1, PmtGt.SBK_ACCT_ATTRIBUTE2 SBK_ACCT_ATTRIBUTE2, PmtGt.SBK_ACCT_ATTRIBUTE3 SBK_ACCT_ATTRIBUTE3, PmtGt.SBK_ACCT_ATTRIBUTE4 SBK_ACCT_ATTRIBUTE4, PmtGt.SBK_ACCT_ATTRIBUTE5 SBK_ACCT_ATTRIBUTE5, PmtGt.SBK_ACCT_ATTRIBUTE6 SBK_ACCT_ATTRIBUTE6, PmtGt.SBK_ACCT_ATTRIBUTE7 SBK_ACCT_ATTRIBUTE7, PmtGt.SBK_ACCT_ATTRIBUTE8 SBK_ACCT_ATTRIBUTE8, PmtGt.SBK_ACCT_ATTRIBUTE9 SBK_ACCT_ATTRIBUTE9, PmtGt.SBK_ACCT_ATTRIBUTE10 SBK_ACCT_ATTRIBUTE10, PmtGt.SBK_ACCT_ATTRIBUTE11 SBK_ACCT_ATTRIBUTE11, PmtGt.SBK_ACCT_ATTRIBUTE12 SBK_ACCT_ATTRIBUTE12, PmtGt.SBK_ACCT_ATTRIBUTE13 SBK_ACCT_ATTRIBUTE13, PmtGt.SBK_ACCT_ATTRIBUTE14 SBK_ACCT_ATTRIBUTE14, PmtGt.SBK_ACCT_ATTRIBUTE15 SBK_ACCT_ATTRIBUTE15, PmtGt.VEND_SITE_COUNTY VEND_SITE_COUNTY, PmtGt.VEND_SITE_ATTRIBUTE_CATEGORY VEND_SITE_ATTRIBUTE_CATEGORY, PmtGt.VEND_SITE_ATTRIBUTE1 VEND_SITE_ATTRIBUTE1, PmtGt.VEND_SITE_ATTRIBUTE2 VEND_SITE_ATTRIBUTE2, PmtGt.VEND_SITE_ATTRIBUTE3 VEND_SITE_ATTRIBUTE3, PmtGt.VEND_SITE_ATTRIBUTE4 VEND_SITE_ATTRIBUTE4, PmtGt.VEND_SITE_ATTRIBUTE5 VEND_SITE_ATTRIBUTE5, PmtGt.VEND_SITE_ATTRIBUTE6 VEND_SITE_ATTRIBUTE6, PmtGt.VEND_SITE_ATTRIBUTE7 VEND_SITE_ATTRIBUTE7, PmtGt.VEND_SITE_ATTRIBUTE8 VEND_SITE_ATTRIBUTE8, PmtGt.VEND_SITE_ATTRIBUTE9 VEND_SITE_ATTRIBUTE9, PmtGt.VEND_SITE_ATTRIBUTE10 VEND_SITE_ATTRIBUTE10, PmtGt.VEND_SITE_ATTRIBUTE11 VEND_SITE_ATTRIBUTE11, PmtGt.VEND_SITE_ATTRIBUTE12 VEND_SITE_ATTRIBUTE12, PmtGt.VEND_SITE_ATTRIBUTE13 VEND_SITE_ATTRIBUTE13, PmtGt.VEND_SITE_ATTRIBUTE14 VEND_SITE_ATTRIBUTE14, PmtGt.VEND_SITE_ATTRIBUTE15 VEND_SITE_ATTRIBUTE15, PmtGt.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, PmtGt.VENDOR_ATTRIBUTE_CATEGORY VENDOR_ATTRIBUTE_CATEGORY, PmtGt.VENDOR_ATTRIBUTE1 VENDOR_ATTRIBUTE1, PmtGt.VENDOR_ATTRIBUTE2 VENDOR_ATTRIBUTE2, PmtGt.VENDOR_ATTRIBUTE3 VENDOR_ATTRIBUTE3, PmtGt.VENDOR_ATTRIBUTE4 VENDOR_ATTRIBUTE4, PmtGt.VENDOR_ATTRIBUTE5 VENDOR_ATTRIBUTE5, PmtGt.VENDOR_ATTRIBUTE6 VENDOR_ATTRIBUTE6, PmtGt.VENDOR_ATTRIBUTE7 VENDOR_ATTRIBUTE7, PmtGt.VENDOR_ATTRIBUTE8 VENDOR_ATTRIBUTE8, PmtGt.VENDOR_ATTRIBUTE9 VENDOR_ATTRIBUTE9, PmtGt.VENDOR_ATTRIBUTE10 VENDOR_ATTRIBUTE10, PmtGt.VENDOR_ATTRIBUTE11 VENDOR_ATTRIBUTE11, PmtGt.VENDOR_ATTRIBUTE12 VENDOR_ATTRIBUTE12, PmtGt.VENDOR_ATTRIBUTE13 VENDOR_ATTRIBUTE13, PmtGt.VENDOR_ATTRIBUTE14 VENDOR_ATTRIBUTE14, PmtGt.VENDOR_ATTRIBUTE15 VENDOR_ATTRIBUTE15 FROM IBY_PYO_PAYMENT_GT PmtGt

View Text - HTML Formatted

SELECT PMTGT.COMMUNICATION_METHOD COMMUNICATION_METHOD
, PMTGT.TEST_FLAG TEST_FLAG
, PMTGT.DOCUMENT_ID DOCUMENT_ID
, PMTGT.DOCUMENT_CODE DOCUMENT_CODE
, PMTGT.BK_TP_TRANSLATOR_CODE BK_TP_TRANSLATOR_CODE
, PMTGT.BK_TP_LOCATION_CODE_EXT BK_TP_LOCATION_CODE_EXT
, PMTGT.BK_TP_DESCRIPTION BK_TP_DESCRIPTION
, PMTGT.BK_TP_REFERENCE_EXT1 BK_TP_REFERENCE_EXT1
, PMTGT.BK_TP_REFERENCE_EXT2 BK_TP_REFERENCE_EXT2
, PMTGT.TRANSACTION_DATE TRANSACTION_DATE
, PMTGT.TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, PMTGT.TPH_ATTRIBUTE1 TPH_ATTRIBUTE1
, PMTGT.TPH_ATTRIBUTE2 TPH_ATTRIBUTE2
, PMTGT.TPH_ATTRIBUTE3 TPH_ATTRIBUTE3
, PMTGT.TPH_ATTRIBUTE4 TPH_ATTRIBUTE4
, PMTGT.TPH_ATTRIBUTE5 TPH_ATTRIBUTE5
, PMTGT.TPH_ATTRIBUTE6 TPH_ATTRIBUTE6
, PMTGT.TPH_ATTRIBUTE7 TPH_ATTRIBUTE7
, PMTGT.TPH_ATTRIBUTE8 TPH_ATTRIBUTE8
, PMTGT.TPH_ATTRIBUTE9 TPH_ATTRIBUTE9
, PMTGT.TPH_ATTRIBUTE10 TPH_ATTRIBUTE10
, PMTGT.TPH_ATTRIBUTE11 TPH_ATTRIBUTE11
, PMTGT.TPH_ATTRIBUTE12 TPH_ATTRIBUTE12
, PMTGT.TPH_ATTRIBUTE13 TPH_ATTRIBUTE13
, PMTGT.TPH_ATTRIBUTE14 TPH_ATTRIBUTE14
, PMTGT.TPH_ATTRIBUTE15 TPH_ATTRIBUTE15
, PMTGT.TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY
, PMTGT.TPD_ATTRIBUTE1 TPD_ATTRIBUTE1
, PMTGT.TPD_ATTRIBUTE2 TPD_ATTRIBUTE2
, PMTGT.TPD_ATTRIBUTE3 TPD_ATTRIBUTE3
, PMTGT.TPD_ATTRIBUTE4 TPD_ATTRIBUTE4
, PMTGT.TPD_ATTRIBUTE5 TPD_ATTRIBUTE5
, PMTGT.DOCUMENT_STANDARD DOCUMENT_STANDARD
, PMTGT.TRANSACTION_HANDLING_CODE TRANSACTION_HANDLING_CODE
, PMTGT.CHECK_AMOUNT CHECK_AMOUNT
, PMTGT.CURRENCY_CODE CURRENCY_CODE
, PMTGT.EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD
, PMTGT.EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT
, PMTGT.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, PMTGT.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, PMTGT.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, PMTGT.BANK_EDI_ID_NUMBER BANK_EDI_ID_NUMBER
, PMTGT.VENDOR_BANK_BRANCH_TYPE VENDOR_BANK_BRANCH_TYPE
, PMTGT.VENDOR_BANK_ACCOUNT_TYPE VENDOR_BANK_ACCOUNT_TYPE
, PMTGT.VENDOR_BANK_ACCOUNT_NUM VENDOR_BANK_ACCOUNT_NUM
, PMTGT.PAYMENT_DATE PAYMENT_DATE
, PMTGT.BANK_NUM BANK_NUM
, PMTGT.VENDOR_BANK_NUM VENDOR_BANK_NUM
, PMTGT.EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD
, PMTGT.EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION
, PMTGT.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, PMTGT.CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM
, PMTGT.SELECTED_CHECK_ID SELECTED_CHECK_ID
, PMTGT.CHECK_NUMBER CHECK_NUMBER
, PMTGT.CUSTOMER_NUM CUSTOMER_NUM
, PMTGT.SEGMENT1 SEGMENT1
, PMTGT.VENDOR_EDI_ID_NUMBER VENDOR_EDI_ID_NUMBER
, PMTGT.SEGMENT2 SEGMENT2
, PMTGT.SEGMENT3 SEGMENT3
, PMTGT.SEGMENT4 SEGMENT4
, PMTGT.SEGMENT5 SEGMENT5
, PMTGT.BANK_BRANCH_ID BANK_BRANCH_ID
, PMTGT.BK_BANK_BRANCH_NAME BK_BANK_BRANCH_NAME
, PMTGT.BK_ADDRESS_LINE1 BK_ADDRESS_LINE1
, PMTGT.BK_ADDRESS_LINE2 BK_ADDRESS_LINE2
, PMTGT.BK_ADDRESS_LINE3 BK_ADDRESS_LINE3
, PMTGT.BK_CITY BK_CITY
, PMTGT.BK_ZIP BK_ZIP
, PMTGT.BK_COUNTRY BK_COUNTRY
, PMTGT.BK_STATE BK_STATE
, PMTGT.BK_PROVINCE BK_PROVINCE
, PMTGT.BK_CONTACT_FIRST_NAME BK_CONTACT_FIRST_NAME
, PMTGT.BK_CONTACT_MIDDLE_NAME BK_CONTACT_MIDDLE_NAME
, PMTGT.BK_CONTACT_LAST_NAME BK_CONTACT_LAST_NAME
, PMTGT.BK_CONTACT_TITLE BK_CONTACT_TITLE
, PMTGT.BK_CONTACT_PREFIX BK_CONTACT_PREFIX
, PMTGT.BK_CONTACT_AREA_CODE BK_CONTACT_AREA_CODE
, PMTGT.BK_CONTACT_PHONE BK_CONTACT_PHONE
, PMTGT.VENDOR_SITE_CODE VENDOR_SITE_CODE
, PMTGT.VENDOR_NAME VENDOR_NAME
, PMTGT.ADDRESS_LINE1 ADDRESS_LINE1
, PMTGT.ADDRESS_LINE2 ADDRESS_LINE2
, PMTGT.ADDRESS_LINE3 ADDRESS_LINE3
, PMTGT.ADDRESS_LINE4 ADDRESS_LINE4
, PMTGT.CITY CITY
, PMTGT.ZIP ZIP
, PMTGT.COUNTRY COUNTRY
, PMTGT.STATE STATE
, PMTGT.PROVINCE PROVINCE
, PMTGT.ABA_GLOBAL_ATTRIBUTE_CATEGORY ABA_GLOBAL_ATTRIBUTE_CATEGORY
, PMTGT.ABA_GLOBAL_ATTRIBUTE1 ABA_GLOBAL_ATTRIBUTE1
, PMTGT.ABA_GLOBAL_ATTRIBUTE2 ABA_GLOBAL_ATTRIBUTE2
, PMTGT.ABA_GLOBAL_ATTRIBUTE3 ABA_GLOBAL_ATTRIBUTE3
, PMTGT.ABA_GLOBAL_ATTRIBUTE4 ABA_GLOBAL_ATTRIBUTE4
, PMTGT.ABA_GLOBAL_ATTRIBUTE5 ABA_GLOBAL_ATTRIBUTE5
, PMTGT.ABA_GLOBAL_ATTRIBUTE6 ABA_GLOBAL_ATTRIBUTE6
, PMTGT.ABA_GLOBAL_ATTRIBUTE7 ABA_GLOBAL_ATTRIBUTE7
, PMTGT.ABA_GLOBAL_ATTRIBUTE8 ABA_GLOBAL_ATTRIBUTE8
, PMTGT.ABA_GLOBAL_ATTRIBUTE9 ABA_GLOBAL_ATTRIBUTE9
, PMTGT.ABA_GLOBAL_ATTRIBUTE10 ABA_GLOBAL_ATTRIBUTE10
, PMTGT.ABA_GLOBAL_ATTRIBUTE11 ABA_GLOBAL_ATTRIBUTE11
, PMTGT.ABA_GLOBAL_ATTRIBUTE12 ABA_GLOBAL_ATTRIBUTE12
, PMTGT.ABA_GLOBAL_ATTRIBUTE13 ABA_GLOBAL_ATTRIBUTE13
, PMTGT.ABA_GLOBAL_ATTRIBUTE14 ABA_GLOBAL_ATTRIBUTE14
, PMTGT.ABA_GLOBAL_ATTRIBUTE15 ABA_GLOBAL_ATTRIBUTE15
, PMTGT.ABA_GLOBAL_ATTRIBUTE16 ABA_GLOBAL_ATTRIBUTE16
, PMTGT.ABA_GLOBAL_ATTRIBUTE17 ABA_GLOBAL_ATTRIBUTE17
, PMTGT.ABA_GLOBAL_ATTRIBUTE18 ABA_GLOBAL_ATTRIBUTE18
, PMTGT.ABA_GLOBAL_ATTRIBUTE19 ABA_GLOBAL_ATTRIBUTE19
, PMTGT.ABA_GLOBAL_ATTRIBUTE20 ABA_GLOBAL_ATTRIBUTE20
, PMTGT.ABAS_GLOBAL_ATTRIBUTE_CATEGORY ABAS_GLOBAL_ATTRIBUTE_CATEGORY
, PMTGT.ABAS_GLOBAL_ATTRIBUTE1 ABAS_GLOBAL_ATTRIBUTE1
, PMTGT.ABAS_GLOBAL_ATTRIBUTE2 ABAS_GLOBAL_ATTRIBUTE2
, PMTGT.ABAS_GLOBAL_ATTRIBUTE3 ABAS_GLOBAL_ATTRIBUTE3
, PMTGT.ABAS_GLOBAL_ATTRIBUTE4 ABAS_GLOBAL_ATTRIBUTE4
, PMTGT.ABAS_GLOBAL_ATTRIBUTE5 ABAS_GLOBAL_ATTRIBUTE5
, PMTGT.ABAS_GLOBAL_ATTRIBUTE6 ABAS_GLOBAL_ATTRIBUTE6
, PMTGT.ABAS_GLOBAL_ATTRIBUTE7 ABAS_GLOBAL_ATTRIBUTE7
, PMTGT.ABAS_GLOBAL_ATTRIBUTE8 ABAS_GLOBAL_ATTRIBUTE8
, PMTGT.ABAS_GLOBAL_ATTRIBUTE9 ABAS_GLOBAL_ATTRIBUTE9
, PMTGT.ABAS_GLOBAL_ATTRIBUTE10 ABAS_GLOBAL_ATTRIBUTE10
, PMTGT.ABAS_GLOBAL_ATTRIBUTE11 ABAS_GLOBAL_ATTRIBUTE11
, PMTGT.ABAS_GLOBAL_ATTRIBUTE12 ABAS_GLOBAL_ATTRIBUTE12
, PMTGT.ABAS_GLOBAL_ATTRIBUTE13 ABAS_GLOBAL_ATTRIBUTE13
, PMTGT.ABAS_GLOBAL_ATTRIBUTE14 ABAS_GLOBAL_ATTRIBUTE14
, PMTGT.ABAS_GLOBAL_ATTRIBUTE15 ABAS_GLOBAL_ATTRIBUTE15
, PMTGT.ABAS_GLOBAL_ATTRIBUTE16 ABAS_GLOBAL_ATTRIBUTE16
, PMTGT.ABAS_GLOBAL_ATTRIBUTE17 ABAS_GLOBAL_ATTRIBUTE17
, PMTGT.ABAS_GLOBAL_ATTRIBUTE18 ABAS_GLOBAL_ATTRIBUTE18
, PMTGT.ABAS_GLOBAL_ATTRIBUTE19 ABAS_GLOBAL_ATTRIBUTE19
, PMTGT.ABAS_GLOBAL_ATTRIBUTE20 ABAS_GLOBAL_ATTRIBUTE20
, PMTGT.PVS_GLOBAL_ATTRIBUTE_CATEGORY PVS_GLOBAL_ATTRIBUTE_CATEGORY
, PMTGT.PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1
, PMTGT.PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2
, PMTGT.PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3
, PMTGT.PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4
, PMTGT.PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5
, PMTGT.PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6
, PMTGT.PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7
, PMTGT.PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8
, PMTGT.PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9
, PMTGT.PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10
, PMTGT.PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11
, PMTGT.PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12
, PMTGT.PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13
, PMTGT.PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14
, PMTGT.PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15
, PMTGT.PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16
, PMTGT.PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17
, PMTGT.PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18
, PMTGT.PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19
, PMTGT.PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20
, PMTGT.BK_EFT_SWIFT_CODE BK_EFT_SWIFT_CODE
, PMTGT.SBK_BANK_BRANCH_NUMBER SBK_BANK_BRANCH_NUMBER
, PMTGT.SBK_BANK_BRANCH_NAME SBK_BANK_BRANCH_NAME
, PMTGT.SBK_ADDRESS_LINE1 SBK_ADDRESS_LINE1
, PMTGT.SBK_ADDRESS_LINE2 SBK_ADDRESS_LINE2
, PMTGT.SBK_ADDRESS_LINE3 SBK_ADDRESS_LINE3
, PMTGT.SBK_CITY SBK_CITY
, PMTGT.SBK_STATE SBK_STATE
, PMTGT.SBK_ZIP SBK_ZIP
, PMTGT.SBK_PROVINCE SBK_PROVINCE
, PMTGT.SBK_COUNTRY SBK_COUNTRY
, PMTGT.SBK_EFT_SWIFT_CODE SBK_EFT_SWIFT_CODE
, PMTGT.BILL_TO_INT_LOCATION_NAME BILL_TO_INT_LOCATION_NAME
, PMTGT.BILL_TO_INT_ADDRESS1 BILL_TO_INT_ADDRESS1
, PMTGT.BILL_TO_INT_ADDRESS2 BILL_TO_INT_ADDRESS2
, PMTGT.BILL_TO_INT_ADDRESS3 BILL_TO_INT_ADDRESS3
, PMTGT.BILL_TO_INT_CITY BILL_TO_INT_CITY
, PMTGT.BILL_TO_INT_POSTAL_CODE BILL_TO_INT_POSTAL_CODE
, PMTGT.BILL_TO_INT_COUNTRY BILL_TO_INT_COUNTRY
, PMTGT.FI_VAT_REGISTRATION_NUM FI_VAT_REGISTRATION_NUM
, PMTGT.BILL_TO_INT_LOCATION_ID BILL_TO_INT_LOCATION_ID
, PMTGT.ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE
, PMTGT.BILL_TO_INT_REGION1 BILL_TO_INT_REGION1
, PMTGT.BILL_TO_INT_REGION2 BILL_TO_INT_REGION2
, PMTGT.BILL_TO_INT_REGION3 BILL_TO_INT_REGION3
, PMTGT.MAP_ID MAP_ID
, PMTGT.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, PMTGT.VENDOR_ALTERNATE_NAME VENDOR_ALTERNATE_NAME
, PMTGT.VENDOR_ALTERNATE_SITE_CODE VENDOR_ALTERNATE_SITE_CODE
, PMTGT.SUPPLIER_CHECK_DIGITS SUPPLIER_CHECK_DIGITS
, PMTGT.SBK_BANK_NAME SBK_BANK_NAME
, PMTGT.IBAN_NUMBER IBAN_NUMBER
, PMTGT.VENDOR_IBAN_NUMBER VENDOR_IBAN_NUMBER
, PMTGT.PAYMENT_MEAN PAYMENT_MEAN
, PMTGT.PAYMENT_CHANNEL PAYMENT_CHANNEL
, PMTGT.VENDOR_ID VENDOR_ID
, PMTGT.VENDOR_SITE_ID VENDOR_SITE_ID
, PMTGT.PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
, PMTGT.SBK_BANK_CODE SBK_BANK_CODE
, PMTGT.PAYMENT_PROCESS_REQUEST_NAME PAYMENT_PROCESS_REQUEST_NAME
, PMTGT.PAYMENT_ORG_ID PAYMENT_ORG_ID
, PMTGT.BANK_NAME BANK_NAME
, PMTGT.BRANCH_NUMBER BRANCH_NUMBER
, PMTGT.BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, PMTGT.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, PMTGT.BK_ACCT_ATTRIBUTE_CATEGORY BK_ACCT_ATTRIBUTE_CATEGORY
, PMTGT.BK_ACCT_ATTRIBUTE1 BK_ACCT_ATTRIBUTE1
, PMTGT.BK_ACCT_ATTRIBUTE2 BK_ACCT_ATTRIBUTE2
, PMTGT.BK_ACCT_ATTRIBUTE3 BK_ACCT_ATTRIBUTE3
, PMTGT.BK_ACCT_ATTRIBUTE4 BK_ACCT_ATTRIBUTE4
, PMTGT.BK_ACCT_ATTRIBUTE5 BK_ACCT_ATTRIBUTE5
, PMTGT.BK_ACCT_ATTRIBUTE6 BK_ACCT_ATTRIBUTE6
, PMTGT.BK_ACCT_ATTRIBUTE7 BK_ACCT_ATTRIBUTE7
, PMTGT.BK_ACCT_ATTRIBUTE8 BK_ACCT_ATTRIBUTE8
, PMTGT.BK_ACCT_ATTRIBUTE9 BK_ACCT_ATTRIBUTE9
, PMTGT.BK_ACCT_ATTRIBUTE10 BK_ACCT_ATTRIBUTE10
, PMTGT.BK_ACCT_ATTRIBUTE11 BK_ACCT_ATTRIBUTE11
, PMTGT.BK_ACCT_ATTRIBUTE12 BK_ACCT_ATTRIBUTE12
, PMTGT.BK_ACCT_ATTRIBUTE13 BK_ACCT_ATTRIBUTE13
, PMTGT.BK_ACCT_ATTRIBUTE14 BK_ACCT_ATTRIBUTE14
, PMTGT.BK_ACCT_ATTRIBUTE15 BK_ACCT_ATTRIBUTE15
, PMTGT.VENDOR_BANK_ACCOUNT_ID VENDOR_BANK_ACCOUNT_ID
, PMTGT.SBK_ACCT_ATTRIBUTE_CATEGORY SBK_ACCT_ATTRIBUTE_CATEGORY
, PMTGT.SBK_ACCT_ATTRIBUTE1 SBK_ACCT_ATTRIBUTE1
, PMTGT.SBK_ACCT_ATTRIBUTE2 SBK_ACCT_ATTRIBUTE2
, PMTGT.SBK_ACCT_ATTRIBUTE3 SBK_ACCT_ATTRIBUTE3
, PMTGT.SBK_ACCT_ATTRIBUTE4 SBK_ACCT_ATTRIBUTE4
, PMTGT.SBK_ACCT_ATTRIBUTE5 SBK_ACCT_ATTRIBUTE5
, PMTGT.SBK_ACCT_ATTRIBUTE6 SBK_ACCT_ATTRIBUTE6
, PMTGT.SBK_ACCT_ATTRIBUTE7 SBK_ACCT_ATTRIBUTE7
, PMTGT.SBK_ACCT_ATTRIBUTE8 SBK_ACCT_ATTRIBUTE8
, PMTGT.SBK_ACCT_ATTRIBUTE9 SBK_ACCT_ATTRIBUTE9
, PMTGT.SBK_ACCT_ATTRIBUTE10 SBK_ACCT_ATTRIBUTE10
, PMTGT.SBK_ACCT_ATTRIBUTE11 SBK_ACCT_ATTRIBUTE11
, PMTGT.SBK_ACCT_ATTRIBUTE12 SBK_ACCT_ATTRIBUTE12
, PMTGT.SBK_ACCT_ATTRIBUTE13 SBK_ACCT_ATTRIBUTE13
, PMTGT.SBK_ACCT_ATTRIBUTE14 SBK_ACCT_ATTRIBUTE14
, PMTGT.SBK_ACCT_ATTRIBUTE15 SBK_ACCT_ATTRIBUTE15
, PMTGT.VEND_SITE_COUNTY VEND_SITE_COUNTY
, PMTGT.VEND_SITE_ATTRIBUTE_CATEGORY VEND_SITE_ATTRIBUTE_CATEGORY
, PMTGT.VEND_SITE_ATTRIBUTE1 VEND_SITE_ATTRIBUTE1
, PMTGT.VEND_SITE_ATTRIBUTE2 VEND_SITE_ATTRIBUTE2
, PMTGT.VEND_SITE_ATTRIBUTE3 VEND_SITE_ATTRIBUTE3
, PMTGT.VEND_SITE_ATTRIBUTE4 VEND_SITE_ATTRIBUTE4
, PMTGT.VEND_SITE_ATTRIBUTE5 VEND_SITE_ATTRIBUTE5
, PMTGT.VEND_SITE_ATTRIBUTE6 VEND_SITE_ATTRIBUTE6
, PMTGT.VEND_SITE_ATTRIBUTE7 VEND_SITE_ATTRIBUTE7
, PMTGT.VEND_SITE_ATTRIBUTE8 VEND_SITE_ATTRIBUTE8
, PMTGT.VEND_SITE_ATTRIBUTE9 VEND_SITE_ATTRIBUTE9
, PMTGT.VEND_SITE_ATTRIBUTE10 VEND_SITE_ATTRIBUTE10
, PMTGT.VEND_SITE_ATTRIBUTE11 VEND_SITE_ATTRIBUTE11
, PMTGT.VEND_SITE_ATTRIBUTE12 VEND_SITE_ATTRIBUTE12
, PMTGT.VEND_SITE_ATTRIBUTE13 VEND_SITE_ATTRIBUTE13
, PMTGT.VEND_SITE_ATTRIBUTE14 VEND_SITE_ATTRIBUTE14
, PMTGT.VEND_SITE_ATTRIBUTE15 VEND_SITE_ATTRIBUTE15
, PMTGT.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, PMTGT.VENDOR_ATTRIBUTE_CATEGORY VENDOR_ATTRIBUTE_CATEGORY
, PMTGT.VENDOR_ATTRIBUTE1 VENDOR_ATTRIBUTE1
, PMTGT.VENDOR_ATTRIBUTE2 VENDOR_ATTRIBUTE2
, PMTGT.VENDOR_ATTRIBUTE3 VENDOR_ATTRIBUTE3
, PMTGT.VENDOR_ATTRIBUTE4 VENDOR_ATTRIBUTE4
, PMTGT.VENDOR_ATTRIBUTE5 VENDOR_ATTRIBUTE5
, PMTGT.VENDOR_ATTRIBUTE6 VENDOR_ATTRIBUTE6
, PMTGT.VENDOR_ATTRIBUTE7 VENDOR_ATTRIBUTE7
, PMTGT.VENDOR_ATTRIBUTE8 VENDOR_ATTRIBUTE8
, PMTGT.VENDOR_ATTRIBUTE9 VENDOR_ATTRIBUTE9
, PMTGT.VENDOR_ATTRIBUTE10 VENDOR_ATTRIBUTE10
, PMTGT.VENDOR_ATTRIBUTE11 VENDOR_ATTRIBUTE11
, PMTGT.VENDOR_ATTRIBUTE12 VENDOR_ATTRIBUTE12
, PMTGT.VENDOR_ATTRIBUTE13 VENDOR_ATTRIBUTE13
, PMTGT.VENDOR_ATTRIBUTE14 VENDOR_ATTRIBUTE14
, PMTGT.VENDOR_ATTRIBUTE15 VENDOR_ATTRIBUTE15
FROM IBY_PYO_PAYMENT_GT PMTGT