Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00166
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Extended_Pricing_Matrix_LINE
Physical Name: SV00166
Technical Name: SV_Extended_Pricing_Matrix_LINESeq 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 Price_Matrix_Entry_1 Price Matrix Entry 1 STR30 String 30 5 Price_Matrix_Entry_2 Price Matrix Entry 2 STR30 String 30 6 Price_Matrix_Entry_3 Price Matrix Entry 3 STR30 String 30 7 Price_Matrix_Entry_4 Price Matrix Entry 4 STR30 String 30 8 Price_Matrix_Entry_5 Price Matrix Entry 5 STR30 String 30 9 Price_Matrix_Entry_6 Price Matrix Entry 6 STR30 String 30 10 Price_Matrix_Entry_7 Price Matrix Entry 7 STR30 String 30 11 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 12 WS_Billing_Method WS Billing Method DDL Integer 0 13 Billing_Amount Billing Amount DLR14_RBS0_STR$ Currency 14 14 ITEMDESC Item Description STR100 String 100 15 Pricing_Markup_Amount Pricing Markup Amount DLR17_RBS0_STR$ Currency 17 16 Pricing_Markup_Percent Pricing Markup Percent LI6_S2% Long Integer 6 17 Pricing_Amount_1 Pricing Amount 1 DLR14_RBS0_UTR$ Currency 14 18 Pricing_Amount_2 Pricing Amount 2 DLR14_RBS0_UTR$ Currency 14 19 WS_Bill_Cost_Code WS Bill Cost Code LI8_U0 Long Integer 8 20 WS_Bill_Other_Cost_Code WS Bill Other Cost Code LI8_U0 Long Integer 8 21 Min_Amount_Total Min Amount Total DLR14_RBS0_UTR$ Currency 14 22 Max_Amount_Total Max Amount Total DLR14_RBS0_UTR$ Currency 14 23 MODIFDT Modified Date DT Date 8 24 Modified_Time Modified Time TM6 Time 6 25 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Extended_Pricing_Matrix_LINE'].MDFUSRID AS 'SV_Extended_Pricing_Matrix_LINE-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00166 AS ['SV_Extended_Pricing_Matrix_LINE']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Extended_Pricing_Matrix_LINE'].MDFUSRID = ['Users Master'].USERID