Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00167
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Extended_Pricing_Matrix_SETP
Physical Name: SV00167
Technical Name: SV_Extended_Pricing_Matrix_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Pricing_Matrix_Name 
Pricing Matrix Name STR15_RM_Customer_Number String 15 2 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 3 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 4 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 5 Price_Matrix_Option Price Matrix Option STR30 String 30 6 Price_Matrix_Option_Req Price Matrix Option Required CB Boolean 0 7 MODIFDT Modified Date DT Date 8 8 Modified_Time Modified Time TM6 Time 6 9 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Extended_Pricing_Matrix_SETP'].MDFUSRID AS 'SV_Extended_Pricing_Matrix_SETP-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00167 AS ['SV_Extended_Pricing_Matrix_SETP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Extended_Pricing_Matrix_SETP'].MDFUSRID = ['Users Master'].USERID