Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM00105
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM National Accounts Master
Physical Name: RM00105
Technical Name: RM_NationalAccounts_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CPRCSTNM 
Corporate Customer Number String STR15_RM_Customer_Number 15 2 NAALLOWRECEIPTS NAAllowReceipts Boolean CB_NAAllowReceipts 0 3 NACREDITCHECK NACreditCheck Boolean CB_NACreditCheck 0 4 NAFINANCECHARGE NAFinanceCharge Boolean CB_NAFinanceCharge 0 5 NAHOLDINACTIVE NAHoldInactive Boolean CB_NAHoldInactive 0 6 NADEFPARENTVEN NADefaultParentsVendor Boolean CB_NADefaultParentsVendor 0 7 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['RM National Accounts Master'].NOTEINDX AS 'RM National Accounts Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RM00105 AS ['RM National Accounts Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM National Accounts Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX8 CREATDDT Created Date Date DT 8 9 MODIFDT Modified Date Date DT 8