Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1188
Product: Cashbook (1058)
Series: Company
Display Name: Euro Address Electronic Funds Transfer Master
Physical Name: CBEU1188
Technical Name: CB_Euro_AddressEFTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SERIES 
Series DDL_Series Integer 0 2 CustomerVendor_ID Customer/Vendor ID STR15 String 15 3 ADRSCODE Address Code STR15_Address_Code String 15 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Euro Address Electronic Funds Transfer Master'].VENDORID AS 'Euro Address Electronic Funds Transfer Master-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CBEU1188 AS ['Euro Address Electronic Funds Transfer Master']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Euro Address Electronic Funds Transfer Master'].VENDORID = ['PM Vendor Master File'].VENDORID5 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Euro Address Electronic Funds Transfer Master'].CUSTNMBR AS 'Euro Address Electronic Funds Transfer Master-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CBEU1188 AS ['Euro Address Electronic Funds Transfer Master']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Euro Address Electronic Funds Transfer Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 EFTBankType EFT Bank Type DDL_EFTBankType Integer 0 7 FRGNBANK Foreign Bank CB_Foreign_Bank Boolean 0 8 INACTIVE Inactive CB_Inactive Boolean 0 9 BANKNAME Bank Name STR30 String 30 10 EFTBankAcct EFT Bank Account STR34 String 34 11 EFTBankBranch EFT Bank Branch STR15 String 15 12 GIROPostType GIRO Post Type DDL_GIROPostType Integer 0 13 EFTBankCode EFT Bank Code STR15 String 15 14 EFTBankBranchCode EFT Bank Branch Code STR5_GPA String 5 15 EFTBankCheckDigit EFT Bank Check Digit STR2_LBA String 2 16 IntlBankAcctNum International Bank Account Number STR34 String 34 17 SWIFTADDR Swift Address STR11 String 11 18 CustVendCountryCode Customer/Vendor Country Code Country Code String 3 19 DeliveryCountryCode Delivery Country Code Country Code String 3 20 BNKCTRCD Bank Country Code Country Code String 3 21 CBANKCD Central Bank Code Central Bank Code String 8 22 ADDRESS1 Address 1 STR60 String 60 23 ADDRESS2 Address 2 STR60 String 60 24 ADDRESS3 Address 3 STR60 String 60 25 ADDRESS4 Address 4 STR60 String 60 26 RegCode1 Regulatory Code 1 STR30 String 30 27 RegCode2 Regulatory Code 2 STR30 String 30 28 BankInfo7 Bank Info 7 DDL Integer 0