SV_Extended_Pricing_Matrix_LINE (SV00166)

azurecurveProductsWennSoft Products (131)3rd PartySV_Extended_Pricing_Matrix_LINE (SV00166)

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_LINE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
2WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer8
3WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer8
4Price_Matrix_Entry_1 SearchPrice Matrix Entry 1STR30String30
5Price_Matrix_Entry_2 SearchPrice Matrix Entry 2STR30String30
6Price_Matrix_Entry_3 SearchPrice Matrix Entry 3STR30String30
7Price_Matrix_Entry_4 SearchPrice Matrix Entry 4STR30String30
8Price_Matrix_Entry_5 SearchPrice Matrix Entry 5STR30String30
9Price_Matrix_Entry_6 SearchPrice Matrix Entry 6STR30String30
10Price_Matrix_Entry_7 SearchPrice Matrix Entry 7STR30String30
11SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
12WS_Billing_Method SearchWS Billing MethodDDLInteger0
13Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency14
14ITEMDESC SearchItem DescriptionSTR100String100
15Pricing_Markup_Amount SearchPricing Markup AmountDLR17_RBS0_STR$Currency17
16Pricing_Markup_Percent SearchPricing Markup PercentLI6_S2%Long Integer6
17Pricing_Amount_1 SearchPricing Amount 1DLR14_RBS0_UTR$Currency14
18Pricing_Amount_2 SearchPricing Amount 2DLR14_RBS0_UTR$Currency14
19WS_Bill_Cost_Code SearchWS Bill Cost CodeLI8_U0Long Integer8
20WS_Bill_Other_Cost_Code SearchWS Bill Other Cost CodeLI8_U0Long Integer8
21Min_Amount_Total SearchMin Amount TotalDLR14_RBS0_UTR$Currency14
22Max_Amount_Total SearchMax Amount TotalDLR14_RBS0_UTR$Currency14
23MODIFDT SearchModified DateDTDate8
24Modified_Time SearchModified TimeTM6Time6
25MDFUSRID SearchModified User IDSTR15String15
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
azurecurveProductsWennSoft Products (131)3rd PartySV_Extended_Pricing_Matrix_LINE (SV00166)

Leave a Reply

Your email address will not be published. Required fields are marked *