eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: EC.ECE_AP_CHECKS_INTERFACE#

Source

View Text - Preformatted


select COMMUNICATION_METHOD COMMUNICATION_METHOD, BK_TP_TEST_FLAG BK_TP_TEST_FLAG, DOCUMENT_ID DOCUMENT_ID, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE, DOCUMENT_CODE DOCUMENT_CODE, BK_TP_TRANSLATOR_CODE BK_TP_TRANSLATOR_CODE, BK_TP_LOCATION_CODE_EXT BK_TP_LOCATION_CODE_EXT, BK_TP_DESCRIPTION BK_TP_DESCRIPTION, BK_TP_REFERENCE_EXT1 BK_TP_REFERENCE_EXT1, BK_TP_REFERENCE_EXT2 BK_TP_REFERENCE_EXT2, TRANSACTION_DATE TRANSACTION_DATE, RUN_ID RUN_ID, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5, TRANSACTION_HANDLING_CODE TRANSACTION_HANDLING_CODE, TRANSACTION_HANDLING_CODE_EXT1 TRANSACTION_HANDLING_CODE_EXT1, CHECK_AMOUNT CHECK_AMOUNT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1, EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD, EDI_PAYMENT_METHOD_EXT1 EDI_PAYMENT_METHOD_EXT1, EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT, EDI_PAYMENT_FORMAT_EXT1 EDI_PAYMENT_FORMAT_EXT1, BANK_BRANCH_TYPE BANK_BRANCH_TYPE, BANK_BRANCH_TYPE_EXT1 BANK_BRANCH_TYPE_EXT1, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, BANK_ACCOUNT_TYPE_EXT1 BANK_ACCOUNT_TYPE_EXT1, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_EDI_ID_NUMBER BANK_EDI_ID_NUMBER, VENDOR_BANK_BRANCH_TYPE VENDOR_BANK_BRANCH_TYPE, VENDOR_BANK_BRANCH_TYPE_EXT1 VENDOR_BANK_BRANCH_TYPE_EXT1, VENDOR_BANK_ACCOUNT_TYPE VENDOR_BANK_ACCOUNT_TYPE, VENDOR_BANK_ACCOUNT_TYPE_EXT1 VENDOR_BANK_ACCOUNT_TYPE_EXT1, VENDOR_BANK_ACCOUNT_NUM VENDOR_BANK_ACCOUNT_NUM, PAYMENT_DATE PAYMENT_DATE, BANK_NUM BANK_NUM, VENDOR_BANK_NUM VENDOR_BANK_NUM, EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD, EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION, CHECKRUN_NAME CHECKRUN_NAME, CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM, SELECTED_CHECK_ID SELECTED_CHECK_ID, CHECK_NUMBER CHECK_NUMBER, CUSTOMER_NUM CUSTOMER_NUM, VOID_FLAG VOID_FLAG, VOID_DATE VOID_DATE, SEGMENT1 SEGMENT1, VENDOR_NUMBER_EXT1 VENDOR_NUMBER_EXT1, VENDOR_EDI_ID_NUMBER VENDOR_EDI_ID_NUMBER, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, BANK_ENTITY_SITE_CODE BANK_ENTITY_SITE_CODE, BANK_ENTITY_SITE_CODE_EXT1 BANK_ENTITY_SITE_CODE_EXT1, BANK_NAME BANK_NAME, BK_ADDRESS_LINE1 BK_ADDRESS_LINE1, BK_ADDRESS_LINE2 BK_ADDRESS_LINE2, BK_ADDRESS_LINE3 BK_ADDRESS_LINE3, BK_ADDRESS_LINE4 BK_ADDRESS_LINE4, BK_CITY BK_CITY, BK_ZIP BK_ZIP, BK_COUNTRY BK_COUNTRY, BK_COUNTRY_EXT1 BK_COUNTRY_EXT1, BK_STATE BK_STATE, BK_STATE_EXT1 BK_STATE_EXT1, BK_PROVINCE BK_PROVINCE, BK_PROVINCE_EXT1 BK_PROVINCE_EXT1, BK_CONTACT_FIRST_NAME BK_CONTACT_FIRST_NAME, BK_CONTACT_MIDDLE_NAME BK_CONTACT_MIDDLE_NAME, BK_CONTACT_LAST_NAME BK_CONTACT_LAST_NAME, BK_CONTACT_TITLE BK_CONTACT_TITLE, BK_CONTACT_PREFIX BK_CONTACT_PREFIX, BK_CONTACT_AREA_CODE BK_CONTACT_AREA_CODE, BK_CONTACT_PHONE BK_CONTACT_PHONE, VENDOR_SITE_CODE VENDOR_SITE_CODE, VENDOR_SITE_CODE_EXT1 VENDOR_SITE_CODE_EXT1, VENDOR_NAME VENDOR_NAME, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, ADDRESS_LINE4 ADDRESS_LINE4, CITY CITY, ZIP ZIP, COUNTRY COUNTRY, COUNTRY_EXT1 COUNTRY_EXT1, STATE STATE, STATE_EXT1 STATE_EXT1, PROVINCE PROVINCE, PROVINCE_EXT1 PROVINCE_EXT1, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DOCUMENT_STANDARD DOCUMENT_STANDARD, BK_EFT_SWIFT_CODE BK_EFT_SWIFT_CODE, SBK_BANK_BRANCH_NUMBER SBK_BANK_BRANCH_NUMBER, SBK_BANK_BRANCH_NAME SBK_BANK_BRANCH_NAME, SBK_ADDRESS_LINE1 SBK_ADDRESS_LINE1, SBK_ADDRESS_LINE2 SBK_ADDRESS_LINE2, SBK_ADDRESS_LINE3 SBK_ADDRESS_LINE3, SBK_CITY SBK_CITY, SBK_STATE SBK_STATE, SBK_ZIP SBK_ZIP, SBK_PROVINCE SBK_PROVINCE, SBK_COUNTRY SBK_COUNTRY, SBK_EFT_SWIFT_CODE SBK_EFT_SWIFT_CODE, ABA_GLOBAL_ATTRIBUTE_CATEGORY ABA_GLOBAL_ATTRIBUTE_CATEGORY, ABA_GLOBAL_ATTRIBUTE1 ABA_GLOBAL_ATTRIBUTE1, ABA_GLOBAL_ATTRIBUTE2 ABA_GLOBAL_ATTRIBUTE2, ABA_GLOBAL_ATTRIBUTE3 ABA_GLOBAL_ATTRIBUTE3, ABA_GLOBAL_ATTRIBUTE4 ABA_GLOBAL_ATTRIBUTE4, ABA_GLOBAL_ATTRIBUTE5 ABA_GLOBAL_ATTRIBUTE5, ABA_GLOBAL_ATTRIBUTE6 ABA_GLOBAL_ATTRIBUTE6, ABA_GLOBAL_ATTRIBUTE7 ABA_GLOBAL_ATTRIBUTE7, ABA_GLOBAL_ATTRIBUTE8 ABA_GLOBAL_ATTRIBUTE8, ABA_GLOBAL_ATTRIBUTE9 ABA_GLOBAL_ATTRIBUTE9, ABA_GLOBAL_ATTRIBUTE10 ABA_GLOBAL_ATTRIBUTE10, ABA_GLOBAL_ATTRIBUTE11 ABA_GLOBAL_ATTRIBUTE11, ABA_GLOBAL_ATTRIBUTE12 ABA_GLOBAL_ATTRIBUTE12, ABA_GLOBAL_ATTRIBUTE13 ABA_GLOBAL_ATTRIBUTE13, ABA_GLOBAL_ATTRIBUTE14 ABA_GLOBAL_ATTRIBUTE14, ABA_GLOBAL_ATTRIBUTE15 ABA_GLOBAL_ATTRIBUTE15, ABA_GLOBAL_ATTRIBUTE16 ABA_GLOBAL_ATTRIBUTE16, ABA_GLOBAL_ATTRIBUTE17 ABA_GLOBAL_ATTRIBUTE17, ABA_GLOBAL_ATTRIBUTE18 ABA_GLOBAL_ATTRIBUTE18, ABA_GLOBAL_ATTRIBUTE19 ABA_GLOBAL_ATTRIBUTE19, ABA_GLOBAL_ATTRIBUTE20 ABA_GLOBAL_ATTRIBUTE20, ABAS_GLOBAL_ATTRIBUTE_CATEGORY ABAS_GLOBAL_ATTRIBUTE_CATEGORY, ABAS_GLOBAL_ATTRIBUTE1 ABAS_GLOBAL_ATTRIBUTE1, ABAS_GLOBAL_ATTRIBUTE2 ABAS_GLOBAL_ATTRIBUTE2, ABAS_GLOBAL_ATTRIBUTE3 ABAS_GLOBAL_ATTRIBUTE3, ABAS_GLOBAL_ATTRIBUTE4 ABAS_GLOBAL_ATTRIBUTE4, ABAS_GLOBAL_ATTRIBUTE5 ABAS_GLOBAL_ATTRIBUTE5, ABAS_GLOBAL_ATTRIBUTE6 ABAS_GLOBAL_ATTRIBUTE6, ABAS_GLOBAL_ATTRIBUTE7 ABAS_GLOBAL_ATTRIBUTE7, ABAS_GLOBAL_ATTRIBUTE8 ABAS_GLOBAL_ATTRIBUTE8, ABAS_GLOBAL_ATTRIBUTE9 ABAS_GLOBAL_ATTRIBUTE9, ABAS_GLOBAL_ATTRIBUTE10 ABAS_GLOBAL_ATTRIBUTE10, ABAS_GLOBAL_ATTRIBUTE11 ABAS_GLOBAL_ATTRIBUTE11, ABAS_GLOBAL_ATTRIBUTE12 ABAS_GLOBAL_ATTRIBUTE12, ABAS_GLOBAL_ATTRIBUTE13 ABAS_GLOBAL_ATTRIBUTE13, ABAS_GLOBAL_ATTRIBUTE14 ABAS_GLOBAL_ATTRIBUTE14, ABAS_GLOBAL_ATTRIBUTE15 ABAS_GLOBAL_ATTRIBUTE15, ABAS_GLOBAL_ATTRIBUTE16 ABAS_GLOBAL_ATTRIBUTE16, ABAS_GLOBAL_ATTRIBUTE17 ABAS_GLOBAL_ATTRIBUTE17, ABAS_GLOBAL_ATTRIBUTE18 ABAS_GLOBAL_ATTRIBUTE18, ABAS_GLOBAL_ATTRIBUTE19 ABAS_GLOBAL_ATTRIBUTE19, ABAS_GLOBAL_ATTRIBUTE20 ABAS_GLOBAL_ATTRIBUTE20, PVS_GLOBAL_ATTRIBUTE_CATEGORY PVS_GLOBAL_ATTRIBUTE_CATEGORY, PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1, PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2, PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3, PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4, PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5, PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6, PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7, PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8, PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9, PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10, PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11, PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12, PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13, PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14, PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15, PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16, PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17, PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18, PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19, PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20, BILL_TO_INT_LOCATION_NAME BILL_TO_INT_LOCATION_NAME, BILL_TO_INT_ADDRESS1 BILL_TO_INT_ADDRESS1, BILL_TO_INT_ADDRESS2 BILL_TO_INT_ADDRESS2, BILL_TO_INT_ADDRESS3 BILL_TO_INT_ADDRESS3, BILL_TO_INT_CITY BILL_TO_INT_CITY, BILL_TO_INT_POSTAL_CODE BILL_TO_INT_POSTAL_CODE, BILL_TO_INT_COUNTRY BILL_TO_INT_COUNTRY, BILL_TO_INT_COUNTRY_EXT1 BILL_TO_INT_COUNTRY_EXT1, FI_VAT_REGISTRATION_NUM FI_VAT_REGISTRATION_NUM, BILL_TO_INT_REGION1 BILL_TO_INT_REGION1, BILL_TO_INT_REGION1_EXT1 BILL_TO_INT_REGION1_EXT1, BILL_TO_INT_REGION2 BILL_TO_INT_REGION2, BILL_TO_INT_REGION2_EXT1 BILL_TO_INT_REGION2_EXT1, BILL_TO_INT_REGION3 BILL_TO_INT_REGION3, BILL_TO_INT_REGION3_EXT1 BILL_TO_INT_REGION3_EXT1, BILL_TO_INT_LOCATION_ID BILL_TO_INT_LOCATION_ID, BILL_TO_INT_EDI_LOCATION_CODE BILL_TO_INT_EDI_LOCATION_CODE, MAP_ID MAP_ID, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE, VENDOR_ALTERNATE_NAME VENDOR_ALTERNATE_NAME, VENDOR_ALTERNATE_SITE_CODE VENDOR_ALTERNATE_SITE_CODE, SUPPLIER_CHECK_DIGITS SUPPLIER_CHECK_DIGITS, SBK_BANK_NAME SBK_BANK_NAME, IBAN_NUMBER IBAN_NUMBER, VENDOR_IBAN_NUMBER VENDOR_IBAN_NUMBER from "EC"."ECE_AP_CHECKS_INTERFACE"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, BK_TP_TEST_FLAG BK_TP_TEST_FLAG
, DOCUMENT_ID DOCUMENT_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_PURPOSE_CODE DOCUMENT_PURPOSE_CODE
, DOCUMENT_CODE DOCUMENT_CODE
, BK_TP_TRANSLATOR_CODE BK_TP_TRANSLATOR_CODE
, BK_TP_LOCATION_CODE_EXT BK_TP_LOCATION_CODE_EXT
, BK_TP_DESCRIPTION BK_TP_DESCRIPTION
, BK_TP_REFERENCE_EXT1 BK_TP_REFERENCE_EXT1
, BK_TP_REFERENCE_EXT2 BK_TP_REFERENCE_EXT2
, TRANSACTION_DATE TRANSACTION_DATE
, RUN_ID RUN_ID
, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5
, TRANSACTION_HANDLING_CODE TRANSACTION_HANDLING_CODE
, TRANSACTION_HANDLING_CODE_EXT1 TRANSACTION_HANDLING_CODE_EXT1
, CHECK_AMOUNT CHECK_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CODE_EXT1 CURRENCY_CODE_EXT1
, EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD
, EDI_PAYMENT_METHOD_EXT1 EDI_PAYMENT_METHOD_EXT1
, EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT
, EDI_PAYMENT_FORMAT_EXT1 EDI_PAYMENT_FORMAT_EXT1
, BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, BANK_BRANCH_TYPE_EXT1 BANK_BRANCH_TYPE_EXT1
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, BANK_ACCOUNT_TYPE_EXT1 BANK_ACCOUNT_TYPE_EXT1
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_EDI_ID_NUMBER BANK_EDI_ID_NUMBER
, VENDOR_BANK_BRANCH_TYPE VENDOR_BANK_BRANCH_TYPE
, VENDOR_BANK_BRANCH_TYPE_EXT1 VENDOR_BANK_BRANCH_TYPE_EXT1
, VENDOR_BANK_ACCOUNT_TYPE VENDOR_BANK_ACCOUNT_TYPE
, VENDOR_BANK_ACCOUNT_TYPE_EXT1 VENDOR_BANK_ACCOUNT_TYPE_EXT1
, VENDOR_BANK_ACCOUNT_NUM VENDOR_BANK_ACCOUNT_NUM
, PAYMENT_DATE PAYMENT_DATE
, BANK_NUM BANK_NUM
, VENDOR_BANK_NUM VENDOR_BANK_NUM
, EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION
, CHECKRUN_NAME CHECKRUN_NAME
, CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM
, SELECTED_CHECK_ID SELECTED_CHECK_ID
, CHECK_NUMBER CHECK_NUMBER
, CUSTOMER_NUM CUSTOMER_NUM
, VOID_FLAG VOID_FLAG
, VOID_DATE VOID_DATE
, SEGMENT1 SEGMENT1
, VENDOR_NUMBER_EXT1 VENDOR_NUMBER_EXT1
, VENDOR_EDI_ID_NUMBER VENDOR_EDI_ID_NUMBER
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, BANK_ENTITY_SITE_CODE BANK_ENTITY_SITE_CODE
, BANK_ENTITY_SITE_CODE_EXT1 BANK_ENTITY_SITE_CODE_EXT1
, BANK_NAME BANK_NAME
, BK_ADDRESS_LINE1 BK_ADDRESS_LINE1
, BK_ADDRESS_LINE2 BK_ADDRESS_LINE2
, BK_ADDRESS_LINE3 BK_ADDRESS_LINE3
, BK_ADDRESS_LINE4 BK_ADDRESS_LINE4
, BK_CITY BK_CITY
, BK_ZIP BK_ZIP
, BK_COUNTRY BK_COUNTRY
, BK_COUNTRY_EXT1 BK_COUNTRY_EXT1
, BK_STATE BK_STATE
, BK_STATE_EXT1 BK_STATE_EXT1
, BK_PROVINCE BK_PROVINCE
, BK_PROVINCE_EXT1 BK_PROVINCE_EXT1
, BK_CONTACT_FIRST_NAME BK_CONTACT_FIRST_NAME
, BK_CONTACT_MIDDLE_NAME BK_CONTACT_MIDDLE_NAME
, BK_CONTACT_LAST_NAME BK_CONTACT_LAST_NAME
, BK_CONTACT_TITLE BK_CONTACT_TITLE
, BK_CONTACT_PREFIX BK_CONTACT_PREFIX
, BK_CONTACT_AREA_CODE BK_CONTACT_AREA_CODE
, BK_CONTACT_PHONE BK_CONTACT_PHONE
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, VENDOR_SITE_CODE_EXT1 VENDOR_SITE_CODE_EXT1
, VENDOR_NAME VENDOR_NAME
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, ADDRESS_LINE4 ADDRESS_LINE4
, CITY CITY
, ZIP ZIP
, COUNTRY COUNTRY
, COUNTRY_EXT1 COUNTRY_EXT1
, STATE STATE
, STATE_EXT1 STATE_EXT1
, PROVINCE PROVINCE
, PROVINCE_EXT1 PROVINCE_EXT1
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DOCUMENT_STANDARD DOCUMENT_STANDARD
, BK_EFT_SWIFT_CODE BK_EFT_SWIFT_CODE
, SBK_BANK_BRANCH_NUMBER SBK_BANK_BRANCH_NUMBER
, SBK_BANK_BRANCH_NAME SBK_BANK_BRANCH_NAME
, SBK_ADDRESS_LINE1 SBK_ADDRESS_LINE1
, SBK_ADDRESS_LINE2 SBK_ADDRESS_LINE2
, SBK_ADDRESS_LINE3 SBK_ADDRESS_LINE3
, SBK_CITY SBK_CITY
, SBK_STATE SBK_STATE
, SBK_ZIP SBK_ZIP
, SBK_PROVINCE SBK_PROVINCE
, SBK_COUNTRY SBK_COUNTRY
, SBK_EFT_SWIFT_CODE SBK_EFT_SWIFT_CODE
, ABA_GLOBAL_ATTRIBUTE_CATEGORY ABA_GLOBAL_ATTRIBUTE_CATEGORY
, ABA_GLOBAL_ATTRIBUTE1 ABA_GLOBAL_ATTRIBUTE1
, ABA_GLOBAL_ATTRIBUTE2 ABA_GLOBAL_ATTRIBUTE2
, ABA_GLOBAL_ATTRIBUTE3 ABA_GLOBAL_ATTRIBUTE3
, ABA_GLOBAL_ATTRIBUTE4 ABA_GLOBAL_ATTRIBUTE4
, ABA_GLOBAL_ATTRIBUTE5 ABA_GLOBAL_ATTRIBUTE5
, ABA_GLOBAL_ATTRIBUTE6 ABA_GLOBAL_ATTRIBUTE6
, ABA_GLOBAL_ATTRIBUTE7 ABA_GLOBAL_ATTRIBUTE7
, ABA_GLOBAL_ATTRIBUTE8 ABA_GLOBAL_ATTRIBUTE8
, ABA_GLOBAL_ATTRIBUTE9 ABA_GLOBAL_ATTRIBUTE9
, ABA_GLOBAL_ATTRIBUTE10 ABA_GLOBAL_ATTRIBUTE10
, ABA_GLOBAL_ATTRIBUTE11 ABA_GLOBAL_ATTRIBUTE11
, ABA_GLOBAL_ATTRIBUTE12 ABA_GLOBAL_ATTRIBUTE12
, ABA_GLOBAL_ATTRIBUTE13 ABA_GLOBAL_ATTRIBUTE13
, ABA_GLOBAL_ATTRIBUTE14 ABA_GLOBAL_ATTRIBUTE14
, ABA_GLOBAL_ATTRIBUTE15 ABA_GLOBAL_ATTRIBUTE15
, ABA_GLOBAL_ATTRIBUTE16 ABA_GLOBAL_ATTRIBUTE16
, ABA_GLOBAL_ATTRIBUTE17 ABA_GLOBAL_ATTRIBUTE17
, ABA_GLOBAL_ATTRIBUTE18 ABA_GLOBAL_ATTRIBUTE18
, ABA_GLOBAL_ATTRIBUTE19 ABA_GLOBAL_ATTRIBUTE19
, ABA_GLOBAL_ATTRIBUTE20 ABA_GLOBAL_ATTRIBUTE20
, ABAS_GLOBAL_ATTRIBUTE_CATEGORY ABAS_GLOBAL_ATTRIBUTE_CATEGORY
, ABAS_GLOBAL_ATTRIBUTE1 ABAS_GLOBAL_ATTRIBUTE1
, ABAS_GLOBAL_ATTRIBUTE2 ABAS_GLOBAL_ATTRIBUTE2
, ABAS_GLOBAL_ATTRIBUTE3 ABAS_GLOBAL_ATTRIBUTE3
, ABAS_GLOBAL_ATTRIBUTE4 ABAS_GLOBAL_ATTRIBUTE4
, ABAS_GLOBAL_ATTRIBUTE5 ABAS_GLOBAL_ATTRIBUTE5
, ABAS_GLOBAL_ATTRIBUTE6 ABAS_GLOBAL_ATTRIBUTE6
, ABAS_GLOBAL_ATTRIBUTE7 ABAS_GLOBAL_ATTRIBUTE7
, ABAS_GLOBAL_ATTRIBUTE8 ABAS_GLOBAL_ATTRIBUTE8
, ABAS_GLOBAL_ATTRIBUTE9 ABAS_GLOBAL_ATTRIBUTE9
, ABAS_GLOBAL_ATTRIBUTE10 ABAS_GLOBAL_ATTRIBUTE10
, ABAS_GLOBAL_ATTRIBUTE11 ABAS_GLOBAL_ATTRIBUTE11
, ABAS_GLOBAL_ATTRIBUTE12 ABAS_GLOBAL_ATTRIBUTE12
, ABAS_GLOBAL_ATTRIBUTE13 ABAS_GLOBAL_ATTRIBUTE13
, ABAS_GLOBAL_ATTRIBUTE14 ABAS_GLOBAL_ATTRIBUTE14
, ABAS_GLOBAL_ATTRIBUTE15 ABAS_GLOBAL_ATTRIBUTE15
, ABAS_GLOBAL_ATTRIBUTE16 ABAS_GLOBAL_ATTRIBUTE16
, ABAS_GLOBAL_ATTRIBUTE17 ABAS_GLOBAL_ATTRIBUTE17
, ABAS_GLOBAL_ATTRIBUTE18 ABAS_GLOBAL_ATTRIBUTE18
, ABAS_GLOBAL_ATTRIBUTE19 ABAS_GLOBAL_ATTRIBUTE19
, ABAS_GLOBAL_ATTRIBUTE20 ABAS_GLOBAL_ATTRIBUTE20
, PVS_GLOBAL_ATTRIBUTE_CATEGORY PVS_GLOBAL_ATTRIBUTE_CATEGORY
, PVS_GLOBAL_ATTRIBUTE1 PVS_GLOBAL_ATTRIBUTE1
, PVS_GLOBAL_ATTRIBUTE2 PVS_GLOBAL_ATTRIBUTE2
, PVS_GLOBAL_ATTRIBUTE3 PVS_GLOBAL_ATTRIBUTE3
, PVS_GLOBAL_ATTRIBUTE4 PVS_GLOBAL_ATTRIBUTE4
, PVS_GLOBAL_ATTRIBUTE5 PVS_GLOBAL_ATTRIBUTE5
, PVS_GLOBAL_ATTRIBUTE6 PVS_GLOBAL_ATTRIBUTE6
, PVS_GLOBAL_ATTRIBUTE7 PVS_GLOBAL_ATTRIBUTE7
, PVS_GLOBAL_ATTRIBUTE8 PVS_GLOBAL_ATTRIBUTE8
, PVS_GLOBAL_ATTRIBUTE9 PVS_GLOBAL_ATTRIBUTE9
, PVS_GLOBAL_ATTRIBUTE10 PVS_GLOBAL_ATTRIBUTE10
, PVS_GLOBAL_ATTRIBUTE11 PVS_GLOBAL_ATTRIBUTE11
, PVS_GLOBAL_ATTRIBUTE12 PVS_GLOBAL_ATTRIBUTE12
, PVS_GLOBAL_ATTRIBUTE13 PVS_GLOBAL_ATTRIBUTE13
, PVS_GLOBAL_ATTRIBUTE14 PVS_GLOBAL_ATTRIBUTE14
, PVS_GLOBAL_ATTRIBUTE15 PVS_GLOBAL_ATTRIBUTE15
, PVS_GLOBAL_ATTRIBUTE16 PVS_GLOBAL_ATTRIBUTE16
, PVS_GLOBAL_ATTRIBUTE17 PVS_GLOBAL_ATTRIBUTE17
, PVS_GLOBAL_ATTRIBUTE18 PVS_GLOBAL_ATTRIBUTE18
, PVS_GLOBAL_ATTRIBUTE19 PVS_GLOBAL_ATTRIBUTE19
, PVS_GLOBAL_ATTRIBUTE20 PVS_GLOBAL_ATTRIBUTE20
, BILL_TO_INT_LOCATION_NAME BILL_TO_INT_LOCATION_NAME
, BILL_TO_INT_ADDRESS1 BILL_TO_INT_ADDRESS1
, BILL_TO_INT_ADDRESS2 BILL_TO_INT_ADDRESS2
, BILL_TO_INT_ADDRESS3 BILL_TO_INT_ADDRESS3
, BILL_TO_INT_CITY BILL_TO_INT_CITY
, BILL_TO_INT_POSTAL_CODE BILL_TO_INT_POSTAL_CODE
, BILL_TO_INT_COUNTRY BILL_TO_INT_COUNTRY
, BILL_TO_INT_COUNTRY_EXT1 BILL_TO_INT_COUNTRY_EXT1
, FI_VAT_REGISTRATION_NUM FI_VAT_REGISTRATION_NUM
, BILL_TO_INT_REGION1 BILL_TO_INT_REGION1
, BILL_TO_INT_REGION1_EXT1 BILL_TO_INT_REGION1_EXT1
, BILL_TO_INT_REGION2 BILL_TO_INT_REGION2
, BILL_TO_INT_REGION2_EXT1 BILL_TO_INT_REGION2_EXT1
, BILL_TO_INT_REGION3 BILL_TO_INT_REGION3
, BILL_TO_INT_REGION3_EXT1 BILL_TO_INT_REGION3_EXT1
, BILL_TO_INT_LOCATION_ID BILL_TO_INT_LOCATION_ID
, BILL_TO_INT_EDI_LOCATION_CODE BILL_TO_INT_EDI_LOCATION_CODE
, MAP_ID MAP_ID
, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, VENDOR_ALTERNATE_NAME VENDOR_ALTERNATE_NAME
, VENDOR_ALTERNATE_SITE_CODE VENDOR_ALTERNATE_SITE_CODE
, SUPPLIER_CHECK_DIGITS SUPPLIER_CHECK_DIGITS
, SBK_BANK_NAME SBK_BANK_NAME
, IBAN_NUMBER IBAN_NUMBER
, VENDOR_IBAN_NUMBER VENDOR_IBAN_NUMBER
FROM "EC"."ECE_AP_CHECKS_INTERFACE"