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 TypeSQL DB LengthKeyable Length
1Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString1615
2WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
3WS_Other_Cost_Sub_Code SearchWS Other Cost Sub CodeLI8_U0Long Integer48
4Price_Matrix_Entry_1 SearchPrice Matrix Entry 1STR30String3230
5Price_Matrix_Entry_2 SearchPrice Matrix Entry 2STR30String3230
6Price_Matrix_Entry_3 SearchPrice Matrix Entry 3STR30String3230
7Price_Matrix_Entry_4 SearchPrice Matrix Entry 4STR30String3230
8Price_Matrix_Entry_5 SearchPrice Matrix Entry 5STR30String3230
9Price_Matrix_Entry_6 SearchPrice Matrix Entry 6STR30String3230
10Price_Matrix_Entry_7 SearchPrice Matrix Entry 7STR30String3230
11SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
12WS_Billing_Method SearchWS Billing MethodDDLInteger20
13Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency1014
14ITEMDESC SearchItem DescriptionSTR100String102100
15Pricing_Markup_Amount SearchPricing Markup AmountDLR17_RBS0_STR$Currency1017
16Pricing_Markup_Percent SearchPricing Markup PercentLI6_S2%Long Integer46
17Pricing_Amount_1 SearchPricing Amount 1DLR14_RBS0_UTR$Currency1014
18Pricing_Amount_2 SearchPricing Amount 2DLR14_RBS0_UTR$Currency1014
19WS_Bill_Cost_Code SearchWS Bill Cost CodeLI8_U0Long Integer48
20WS_Bill_Other_Cost_Code SearchWS Bill Other Cost CodeLI8_U0Long Integer48
21Min_Amount_Total SearchMin Amount TotalDLR14_RBS0_UTR$Currency1014
22Max_Amount_Total SearchMax Amount TotalDLR14_RBS0_UTR$Currency1014
23MODIFDT SearchModified DateDTDate48
24Modified_Time SearchModified TimeTM6Time46
25MDFUSRID SearchModified User IDSTR15String1615
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 *