Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME318302
Product: Assign By Checkbook (3183)
Series: Purchasing
Display Name: Voucher Pay Select Defaults
Physical Name: ME318302
Technical Name: ME_VPS_DefaultsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Voucher Pay Select Defaults'].CMPANYID AS 'Voucher Pay Select Defaults-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
ME318302 AS ['Voucher Pay Select Defaults']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Voucher Pay Select Defaults'].CMPANYID = ['Company Master'].CMPANYID2 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Voucher Pay Select Defaults'].USERID AS 'Voucher Pay Select Defaults-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME318302 AS ['Voucher Pay Select Defaults']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Voucher Pay Select Defaults'].USERID = ['Users Master'].USERID3 ME_EFTs_Only ME_EFTs_Only Boolean Boolean 0 4 ME_Group_by_Remit_To ME_Group_by_Remit_To Boolean Boolean 0 5 ME_Select_By_Vendor_Chec ME_Select_By_Vendor_Checkbook Boolean Boolean 0 6 ME_Select_by_Voucher_Che ME_Select_by_Voucher_Checkbook Boolean Boolean 0