Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00200
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM Merchant Setup
Physical Name: CM00200
Technical Name: cmMerchantSetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MerchantID 
MerchantID String STR16_MerchantID 16 2 DSCRIPTN Description String STR30 30 3 EFTHash EFTHash String STR255 255 4 EFTHashCode EFTHashCode String STR4_EFTHashCode 4 5 DATE1 Date Date DT6 6 6 TIME1 Time Time TM6 6 7 ISOCURRC ISO Currency Code String STR3_ISO_Currency_Code 3 8 FilePath FilePath String STR255 255 9 EFTDownLoadFilePath EFTDownLoadFilePath String STR255 255 10 EFTProcessedFilePath EFTProcessedFilePath String STR255 255 11 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CM Merchant Setup'].NOTEINDX AS 'CM Merchant Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CM00200 AS ['CM Merchant Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CM Merchant Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX12 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM Merchant Setup'].CURNCYID AS 'CM Merchant Setup-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CM00200 AS ['CM Merchant Setup']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM Merchant Setup'].CURNCYID = ['Currency Setup'].CURNCYID13 CREATDDT Created Date Date DT 8 14 MODIFDT Modified Date Date DT 8