Service Line

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5902

Table Type: Company

Table Name: Service Line
Database Table Name: CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5902

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Service Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Line No_]
   ,[Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Outstanding Quantity]
   ,[Qty_ to Invoice]
   ,[Qty_ to Ship]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Job No_]
   ,[Job Task No_]
   ,[Job Line Type]
   ,[Work Type Code]
   ,[Outstanding Amount]
   ,[Qty_ Shipped Not Invoiced]
   ,[Shipped Not Invoiced]
   ,[Quantity Shipped]
   ,[Quantity Invoiced]
   ,[Shipment No_]
   ,[Shipment Line No_]
   ,[Bill-to Customer No_]
   ,[Inv_ Discount Amount]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Currency Code]
   ,[Outstanding Amount (LCY)]
   ,[Shipped Not Invoiced (LCY)]
   ,[Reserve]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[Inv_ Disc_ Amount to Invoice]
   ,[VAT Identifier]
   ,[Pmt_ Discount Amount]
   ,[Dimension Set ID]
   ,[Time Sheet No_]
   ,[Time Sheet Line No_]
   ,[Time Sheet Date]
   ,[Job Planning Line No_]
   ,[Job Remaining Qty_]
   ,[Job Remaining Qty_ (Base)]
   ,[Job Remaining Total Cost]
   ,[Job Remaining Total Cost (LCY)]
   ,[Job Remaining Line Amount]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Planned]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Quantity (Base)]
   ,[Outstanding Qty_ (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Qty_ to Ship (Base)]
   ,[Qty_ Shipped Not Invd_ (Base)]
   ,[Qty_ Shipped (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[Responsibility Center]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Product Group Code]
   ,[Completely Shipped]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Planned Delivery Date]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Appl_-from Item Entry]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Line No_]
   ,[Service Item Serial No_]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[Posting Date]
   ,[Order Date]
   ,[Needed by Date]
   ,[Ship-to Code]
   ,[Qty_ to Consume]
   ,[Quantity Consumed]
   ,[Qty_ to Consume (Base)]
   ,[Qty_ Consumed (Base)]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Exclude Warranty]
   ,[Warranty]
   ,[Contract No_]
   ,[Contract Disc_ _]
   ,[Warranty Disc_ _]
   ,[Component Line No_]
   ,[Spare Part Action]
   ,[Fault Reason Code]
   ,[Replaced Item No_]
   ,[Exclude Contract Discount]
   ,[Replaced Item Type]
   ,[Price Adjmt_ Status]
   ,[Line Discount Type]
   ,[Copy Components From]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Completely Picked]
   ,[Pick Qty_ (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Service Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Service Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Service Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Service Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Service Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Service Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Service Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Service Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Service Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Line].[Customer No_] = [Customer].[No_]
6Type Searchint
7No_ Searchnvarchar(40)
8Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Service Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Service Line].[Location Code] = [Location].[Code]
9Posting Group Searchnvarchar(40)
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Unit of Measure Searchnvarchar(100)
13Quantity Searchdecimal(38,38)
14Outstanding Quantity Searchdecimal(38,38)
15Qty_ to Invoice Searchdecimal(38,38)
16Qty_ to Ship Searchdecimal(38,38)
17Unit Price Searchdecimal(38,38)
18Unit Cost (LCY) Searchdecimal(38,38)
19VAT _ Searchdecimal(38,38)
20Line Discount _ Searchdecimal(38,38)
21Line Discount Amount Searchdecimal(38,38)
22Amount Searchdecimal(38,38)
23Amount Including VAT Searchdecimal(38,38)
24Allow Invoice Disc_ Searchtinyint
25Gross Weight Searchdecimal(38,38)
26Net Weight Searchdecimal(38,38)
27Units per Parcel Searchdecimal(38,38)
28Unit Volume Searchdecimal(38,38)
29Appl_-to Item Entry Searchint
30Shortcut Dimension 1 Code Searchnvarchar(40)
31Shortcut Dimension 2 Code Searchnvarchar(40)
32Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Service Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Service Line].[Customer Price Group] = [Customer Price Group].[Code]
33Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Service Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Service Line].[Job No_] = [Job].[Job No_]
34Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Service Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Service Line].[Job Task No_] = [Job Task].[Job Task No_]
35Job Line Type Searchint
36Work Type Code Searchnvarchar(20)
37Outstanding Amount Searchdecimal(38,38)
38Qty_ Shipped Not Invoiced Searchdecimal(38,38)
39Shipped Not Invoiced Searchdecimal(38,38)
40Quantity Shipped Searchdecimal(38,38)
41Quantity Invoiced Searchdecimal(38,38)
42Shipment No_ Searchnvarchar(40)
43Shipment Line No_ Searchint
44Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Line].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Line].[Bill-to Customer No_] = [Customer].[No_]
45Inv_ Discount Amount Searchdecimal(38,38)
46Gen_ Bus_ Posting Group Searchnvarchar(40)
47Gen_ Prod_ Posting Group Searchnvarchar(40)
48VAT Calculation Type Searchint
49Transaction Type Searchnvarchar(20)
50Transport Method Searchnvarchar(20)
51Attached to Line No_ Searchint
52Exit Point Searchnvarchar(20)
53Area Searchnvarchar(20)
54Transaction Specification Searchnvarchar(20)
55Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Service Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Service Line].[Tax Area Code] = [Tax Area].[Code]
56Tax Liable Searchtinyint
57Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Service Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Service Line].[Tax Group Code] = [Tax Group].[Code]
58VAT Clause Code Searchnvarchar(40)
59VAT Bus_ Posting Group Searchnvarchar(40)
60VAT Prod_ Posting Group Searchnvarchar(40)
61Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Service Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Service Line].[Currency Code] = [Currency].[Code]
62Outstanding Amount (LCY) Searchdecimal(38,38)
63Shipped Not Invoiced (LCY) Searchdecimal(38,38)
64Reserve Searchint
65VAT Base Amount Searchdecimal(38,38)
66Unit Cost Searchdecimal(38,38)
67System-Created Entry Searchtinyint
68Line Amount Searchdecimal(38,38)
69VAT Difference Searchdecimal(38,38)
70Inv_ Disc_ Amount to Invoice Searchdecimal(38,38)
71VAT Identifier Searchnvarchar(40)
72Pmt_ Discount Amount Searchdecimal(38,38)
73Dimension Set ID Searchint
74Time Sheet No_ Searchnvarchar(40)
75Time Sheet Line No_ Searchint
76Time Sheet Date Searchdatetime
77Job Planning Line No_ Searchint
78Job Remaining Qty_ Searchdecimal(38,38)
79Job Remaining Qty_ (Base) Searchdecimal(38,38)
80Job Remaining Total Cost Searchdecimal(38,38)
81Job Remaining Total Cost (LCY) Searchdecimal(38,38)
82Job Remaining Line Amount Searchdecimal(38,38)
83Variant Code Searchnvarchar(20)
84Bin Code Searchnvarchar(40)
85Qty_ per Unit of Measure Searchdecimal(38,38)
86Planned Searchtinyint
87Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Line].[Unit of Measure Code] = [Unit of Measure].[Code]
88Qty_ Rounding Precision Searchdecimal(38,38)
89Qty_ Rounding Precision (Base) Searchdecimal(38,38)
90Quantity (Base) Searchdecimal(38,38)
91Outstanding Qty_ (Base) Searchdecimal(38,38)
92Qty_ to Invoice (Base) Searchdecimal(38,38)
93Qty_ to Ship (Base) Searchdecimal(38,38)
94Qty_ Shipped Not Invd_ (Base) Searchdecimal(38,38)
95Qty_ Shipped (Base) Searchdecimal(38,38)
96Qty_ Invoiced (Base) Searchdecimal(38,38)
97Responsibility Center Searchnvarchar(20)
98Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Service Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Service Line].[Item Category Code] = [Item Category].[Code]
99Nonstock Searchtinyint
100Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Service Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Service Line].[Product Group Code] = [Product Group].[Code]
101Completely Shipped Searchtinyint
102Requested Delivery Date Searchdatetime
103Promised Delivery Date Searchdatetime
104Shipping Time Searchvarchar(32)
105Planned Delivery Date Searchdatetime
106Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Service Line].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Service Line].[Shipping Agent Code] = [Shipping Agent].[Code]
107Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Service Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Service Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
108Appl_-from Item Entry Searchint
109Service Item No_ Searchnvarchar(40)
110Appl_-to Service Entry Searchint
111Service Item Line No_ Searchint
112Service Item Serial No_ Searchnvarchar(100)
113Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
114Posting Date Searchdatetime
115Order Date Searchdatetime
116Needed by Date Searchdatetime
117Ship-to Code Searchnvarchar(20)
118Qty_ to Consume Searchdecimal(38,38)
119Quantity Consumed Searchdecimal(38,38)
120Qty_ to Consume (Base) Searchdecimal(38,38)
121Qty_ Consumed (Base) Searchdecimal(38,38)
122Service Price Group Code Searchnvarchar(20)
123Fault Area Code Searchnvarchar(20)
124Symptom Code Searchnvarchar(20)
125Fault Code Searchnvarchar(20)
126Resolution Code Searchnvarchar(20)
127Exclude Warranty Searchtinyint
128Warranty Searchtinyint
129Contract No_ Searchnvarchar(40)
130Contract Disc_ _ Searchdecimal(38,38)
131Warranty Disc_ _ Searchdecimal(38,38)
132Component Line No_ Searchint
133Spare Part Action Searchint
134Fault Reason Code Searchnvarchar(20)
135Replaced Item No_ Searchnvarchar(40)
136Exclude Contract Discount Searchtinyint
137Replaced Item Type Searchint
138Price Adjmt_ Status Searchint
139Line Discount Type Searchint
140Copy Components From Searchint
141Return Reason Code Searchnvarchar(20)
142Price Calculation Method Searchint
143Allow Line Disc_ Searchtinyint
144Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Service Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
145Qty_ Picked Searchdecimal(38,38)
146Qty_ Picked (Base) Searchdecimal(38,38)
147Completely Picked Searchtinyint
148Pick Qty_ (Base) Searchdecimal(38,38)
149$systemId Searchuniqueidentifier
150$systemCreatedAt Searchdatetime
151$systemCreatedBy Searchuniqueidentifier
152$systemModifiedAt Searchdatetime
153$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Line table

Leave a Reply

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