Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME27618
Product: MICR for Canadian Payroll (2916)
Series: Purchasing
Display Name: ME_Pinacle_MSTR
Physical Name: ME27618
Technical Name: ME_Pinacle_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ME_Pinacle_MSTR'].VENDORID AS 'ME_Pinacle_MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ME27618 AS ['ME_Pinacle_MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ME_Pinacle_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID2 ME_Pinacle_Template ME_Pinacle_Template STR12 String 12 3 ME_Wire_Type_DDL ME_Wire_Type_DDL ME_Wire_Type_DDL Integer 0 4 ME_Beneficiary_Bank_Name ME_Beneficiary_Bank_Name STR30 String 30 5 ME_Beneficiary_Account ME_Beneficiary_Account STR35_LBU String 35 6 ME_Beneficiary_Bank_Tran ME_Beneficiary_Bank_Transit STR12 String 12 7 ME_Beneficiary_Bank_Addr ME_Beneficiary_Bank_Address STR350 String 35 8 ME_Beneficiary_Bank_Add2 ME_Beneficiary_Bank_Address2 STR350 String 35 9 ME_Beneficiary_Bank_Type ME_Beneficiary_Bank_Type_DDL ME_Bank_Type_DDL Integer 0 10 ME_Charges ME_Charges ME_Charges_DDL Integer 0 11 ME_Advice_Method ME_Advice_Method ME_Advice_Method_DDL Integer 0 12 ME_Advice_Text ME_Advice_Text STR350 String 35 13 ME_Receiving_Bank_Type ME_Receiving_Bank_Type ME_Bank_Type_DDL Integer 0 14 ME_Receiving_Bank_Name ME_Receiving_Bank_Name STR350 String 35 15 ME_Receiving_Bank_Addres ME_Receiving_Bank_Address1 STR350 String 35 16 ME_Receiving_Bank_Addre2 ME_Receiving_Bank_Address2 STR350 String 35 17 ME_Intermediary_Bank_Typ ME_Intermediary_Bank_Type ME_Bank_Type_DDL Integer 0 18 ME_Intermediary_Bank_Nam ME_Intermediary_Bank_Name STR35_LBU String 35 19 ME_Intermediary_Bank_Add ME_Intermediary_Bank_Address STR350 String 35 20 ME_Intermediary_Bank_Ad2 ME_Intermediary_Bank_Address2 STR350 String 35 21 ME_Inactivate_WT ME_Inactivate_WT ME_Inactivate_WT_CB Boolean 0 22 ME_Termination_Date ME_Termination_Date DATE Date 6 23 ME_Setup_Type ME_Setup_Type ME_Setup_Type_DLL Integer 0