Service Line

Dynamics 365 BC Table ReferenceTablesCompany TablesSService 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

   [Document Type]
   ,[Customer No_]
   ,[Document No_]
   ,[Line 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_]
   ,[Order 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]
   ,[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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Line].[Document No_] = [Sales Header].[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 Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Service Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Line].[Shortcut Dimension 2 Code] = [Dimension].[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_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Service Line].[Work Type Code] = [Work Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Service Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Service Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Service Line].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Service Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Service Line].[Transaction Specification] = [Transaction Specification].[Code]
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_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
      ON
         [Service Line].[VAT Clause Code] = [VAT Clause].[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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Service Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Line].[Responsibility Center] = [Responsibility Center].[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_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Service Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
      ON
         [Service Line].[Service Price Group Code] = [Service Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Area]
      ON
         [Service Line].[Fault Area Code] = [Fault Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Symptom Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Symptom Code]
      ON
         [Service Line].[Symptom Code] = [Symptom Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
      ON
         [Service Line].[Resolution Code] = [Resolution Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
      ON
         [Service Line].[Fault Reason Code] = [Fault Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Service Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
2Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(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_]
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Resource”
  • “Cost”
  • “G/L Account”
6No. SearchNo.NormalCode20No_nvarchar(40)
7Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
8Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Service Line].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Service Line].[Posting Group] = [Customer Posting Group].[Code]
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
13Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Line].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Outstanding Quantity SearchOutstanding QuantityNormalDecimal12Outstanding Quantitydecimal(38,38)
17Qty. to Invoice SearchQty. to InvoiceNormalDecimal12Qty_ to Invoicedecimal(38,38)
18Qty. to Ship SearchQty. to ShipNormalDecimal12Qty_ to Shipdecimal(38,38)
22Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
23Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
25VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
27Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
28Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
29Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
30Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
32Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
34Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
35Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
36Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
37Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
40Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
41Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
42Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Service Line].[Job No_]
       ,[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].[No_]
46Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
47Job Line Type SearchJob Line TypeNormalOption4Job Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
52Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
       [Service Line].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Service Line].[Work Type Code] = [Work Type].[Code]
57Outstanding Amount SearchOutstanding AmountNormalDecimal12Outstanding Amountdecimal(38,38)
58Qty. Shipped Not Invoiced SearchQty. Shipped Not InvoicedNormalDecimal12Qty_ Shipped Not Invoiceddecimal(38,38)
59Shipped Not Invoiced SearchShipped Not InvoicedNormalDecimal12Shipped Not Invoiceddecimal(38,38)
60Quantity Shipped SearchQuantity ShippedNormalDecimal12Quantity Shippeddecimal(38,38)
61Quantity Invoiced SearchQuantity InvoicedNormalDecimal12Quantity Invoiceddecimal(38,38)
63Shipment No. SearchShipment No.NormalCode20Shipment No_nvarchar(40)
64Shipment Line No. SearchShipment Line No.NormalInteger4Shipment Line No_int
65Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
68Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(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_]
69Inv. Discount Amount SearchInv. Discount AmountNormalDecimal12Inv_ Discount Amountdecimal(38,38)
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Service Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Service Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Service Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Service Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
77VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
78Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Service Line].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Service Line].[Transaction Type] = [Transaction Type].[Code]
79Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Service Line].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Service Line].[Transport Method] = [Transport Method].[Code]
80Attached to Line No. SearchAttached to Line No.NormalInteger4Attached to Line No_int
81Exit Point SearchExit PointNormalCode10Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Service Line].[Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Service Line].[Exit Point] = [Entry/Exit Point].[Code]
82Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Service Line].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Service Line].[Area] = [Area].[Code]
83Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Service Line].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Service Line].[Transaction Specification] = [Transaction Specification].[Code]
85Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
86Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
87Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
88VAT Clause Code SearchTax Clause CodeNormalCode20VAT Clause Codenvarchar(40)
Key to join to the VAT Clause table.

Show/hide example query

SELECT
       [Service Line].[VAT Clause Code]
       ,[VAT Clause].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Clause$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Clause]
              ON
                     [Service Line].[VAT Clause Code] = [VAT Clause].[Code]
89VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Service Line].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Service Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
90VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Service Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Service Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
91Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
92Outstanding Amount (LCY) SearchOutstanding Amount ($)NormalDecimal12Outstanding Amount (LCY)decimal(38,38)
93Shipped Not Invoiced (LCY) SearchShipped Not Invoiced ($)NormalDecimal12Shipped Not Invoiced (LCY)decimal(38,38)
95Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
96Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
99VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
100Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
101System-Created Entry SearchSystem-Created EntryNormalBoolean4
103Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
104VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
105Inv. Disc. Amount to Invoice SearchInv. Disc. Amount to InvoiceNormalDecimal12Inv_ Disc_ Amount to Invoicedecimal(38,38)
106VAT Identifier SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
145Pmt. Discount Amount SearchPmt. Discount AmountNormalDecimal12Pmt_ Discount Amountdecimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
950Time Sheet No. SearchTime Sheet No.NormalCode20Time Sheet No_nvarchar(40)
951Time Sheet Line No. SearchTime Sheet Line No.NormalInteger4Time Sheet Line No_int
952Time Sheet Date SearchTime Sheet DateNormalDate4Time Sheet Datedatetime
1019Job Planning Line No. SearchJob Planning Line No.NormalInteger4Job Planning Line No_int
1030Job Remaining Qty. SearchJob Remaining Qty.NormalDecimal12Job Remaining Qty_decimal(38,38)
1031Job Remaining Qty. (Base) SearchJob Remaining Qty. (Base)NormalDecimal12Job Remaining Qty_ (Base)decimal(38,38)
1032Job Remaining Total Cost SearchJob Remaining Total CostNormalDecimal12Job Remaining Total Costdecimal(38,38)
1033Job Remaining Total Cost (LCY) SearchJob Remaining Total Cost ($)NormalDecimal12Job Remaining Total Cost (LCY)decimal(38,38)
1034Job Remaining Line Amount SearchJob Remaining Line AmountNormalDecimal12Job Remaining Line Amountdecimal(38,38)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Service Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Service Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Service Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Service Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Planned SearchPlannedNormalBoolean4Plannedtinyint
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5408Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5409Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5415Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5416Outstanding Qty. (Base) SearchOutstanding Qty. (Base)NormalDecimal12Outstanding Qty_ (Base)decimal(38,38)
5417Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
5418Qty. to Ship (Base) SearchQty. to Ship (Base)NormalDecimal12Qty_ to Ship (Base)decimal(38,38)
5458Qty. Shipped Not Invd. (Base) SearchQty. Shipped Not Invd. (Base)NormalDecimal12Qty_ Shipped Not Invd_ (Base)decimal(38,38)
5460Qty. Shipped (Base) SearchQty. Shipped (Base)NormalDecimal12Qty_ Shipped (Base)decimal(38,38)
5461Qty. Invoiced (Base) SearchQty. Invoiced (Base)NormalDecimal12Qty_ Invoiced (Base)decimal(38,38)
5495Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Line].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Line].[Responsibility Center] = [Responsibility Center].[Code]
5702Substitution Available SearchSubstitution AvailableFlowFieldBoolean4
5709Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5750Whse. Outstanding Qty. (Base) SearchWhse. Outstanding Qty. (Base)FlowFieldDecimal12
5752Completely Shipped SearchCompletely ShippedNormalBoolean4Completely Shippedtinyint
5790Requested Delivery Date SearchRequested Delivery DateNormalDate4Requested Delivery Datedatetime
5791Promised Delivery Date SearchPromised Delivery DateNormalDate4Promised Delivery Datedatetime
5792Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
5794Planned Delivery Date SearchPlanned Delivery DateNormalDate4Planned Delivery Datedatetime
5796Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Service Line].[Shipping Agent Code] = [Shipping Agent].[Code]
5797Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
5811Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
5902Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
       [Service Line].[Service Item No_]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Service Line].[Service Item No_] = [Service Item].[No_]
5903Appl.-to Service Entry SearchAppl.-to Service EntryNormalInteger4Appl_-to Service Entryint
5904Service Item Line No. SearchService Item Line No.NormalInteger4Service Item Line No_int
5905Service Item Serial No. SearchService Item Serial No.NormalCode50Service Item Serial No_nvarchar(100)
5906Service Item Line Description SearchService Item Line DescriptionFlowFieldText100
5907Serv. Price Adjmt. Gr. Code SearchServ. Price Adjmt. Gr. CodeNormalCode10Serv_ Price Adjmt_ Gr_ Codenvarchar(20)
Key to join to the Service Price Adjustment Group table.

Show/hide example query

SELECT
       [Service Line].[Serv_ Price Adjmt_ Gr_ Code]
       ,[Service Price Adjustment Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Adjustment Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Adjustment Group]
              ON
                     [Service Line].[Serv_ Price Adjmt_ Gr_ Code] = [Service Price Adjustment Group].[Code]
5908Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5909Order Date SearchOrder DateNormalDate4Order Datedatetime
5910Needed by Date SearchNeeded by DateNormalDate4Needed by Datedatetime
5916Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Line].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Line].[Ship-to Code] = [Ship-to Address].[Code]
5917Qty. to Consume SearchQty. to ConsumeNormalDecimal12Qty_ to Consumedecimal(38,38)
5918Quantity Consumed SearchQuantity ConsumedNormalDecimal12Quantity Consumeddecimal(38,38)
5919Qty. to Consume (Base) SearchQty. to Consume (Base)NormalDecimal12Qty_ to Consume (Base)decimal(38,38)
5920Qty. Consumed (Base) SearchQty. Consumed (Base)NormalDecimal12Qty_ Consumed (Base)decimal(38,38)
5928Service Price Group Code SearchService Price Group CodeNormalCode10Service Price Group Codenvarchar(20)
Key to join to the Service Price Group table.

Show/hide example query

SELECT
       [Service Line].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Line].[Service Price Group Code] = [Service Price Group].[Code]
5929Fault Area Code SearchFault Area CodeNormalCode10Fault Area Codenvarchar(20)
Key to join to the Fault Area table.

Show/hide example query

SELECT
       [Service Line].[Fault Area Code]
       ,[Fault Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Area]
              ON
                     [Service Line].[Fault Area Code] = [Fault Area].[Code]
5930Symptom Code SearchSymptom CodeNormalCode10Symptom Codenvarchar(20)
Key to join to the Symptom Code table.

Show/hide example query

SELECT
       [Service Line].[Symptom Code]
       ,[Symptom Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Symptom Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Symptom Code]
              ON
                     [Service Line].[Symptom Code] = [Symptom Code].[Code]
5931Fault Code SearchFault CodeNormalCode10Fault Codenvarchar(20)
5932Resolution Code SearchResolution CodeNormalCode10Resolution Codenvarchar(20)
Key to join to the Resolution Code table.

Show/hide example query

SELECT
       [Service Line].[Resolution Code]
       ,[Resolution Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Resolution Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resolution Code]
              ON
                     [Service Line].[Resolution Code] = [Resolution Code].[Code]
5933Exclude Warranty SearchExclude WarrantyNormalBoolean4Exclude Warrantytinyint
5934Warranty SearchWarrantyNormalBoolean4Warrantytinyint
5936Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
5938Contract Disc. % SearchContract Disc. %NormalDecimal12Contract Disc_ _decimal(38,38)
5939Warranty Disc. % SearchWarranty Disc. %NormalDecimal12Warranty Disc_ _decimal(38,38)
5965Component Line No. SearchComponent Line No.NormalInteger4Component Line No_int
5966Spare Part Action SearchSpare Part ActionNormalOption4Spare Part Actionint
Available options are:
  • ” “
  • “Permanent”
  • “Temporary”
  • “Component Replaced”
  • “Component Installed”
5967Fault Reason Code SearchFault Reason CodeNormalCode10Fault Reason Codenvarchar(20)
Key to join to the Fault Reason Code table.

Show/hide example query

SELECT
       [Service Line].[Fault Reason Code]
       ,[Fault Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Fault Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fault Reason Code]
              ON
                     [Service Line].[Fault Reason Code] = [Fault Reason Code].[Code]
5968Replaced Item No. SearchReplaced Item No.NormalCode20Replaced Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Service Line].[Replaced Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Service Line].[Replaced Item No_] = [Item].[No_]
5969Exclude Contract Discount SearchExclude Contract DiscountNormalBoolean4Exclude Contract Discounttinyint
5970Replaced Item Type SearchReplaced Item TypeNormalOption4Replaced Item Typeint
Available options are:
  • ” “
  • “Service Item”
  • “Item”
5994Price Adjmt. Status SearchPrice Adjmt. StatusNormalOption4Price Adjmt_ Statusint
Available options are:
  • ” “
  • “Adjusted”
  • “Modified”
5997Line Discount Type SearchLine Discount TypeNormalOption4Line Discount Typeint
Available options are:
  • ” “
  • “Warranty Disc.”
  • “Contract Disc.”
  • “Line Disc.”
  • “Manual”
5999Copy Components From SearchCopy Components FromNormalOption4Copy Components Fromint
Available options are:
  • “None”
  • “Item BOM”
  • “Old Service Item”
  • “Old Serv.Item w/o Serial No.”
6608Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Service Line].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Service Line].[Return Reason Code] = [Return Reason].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7002Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[Code]
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].[Code]
7300Qty. Picked SearchQty. PickedNormalDecimal12Qty_ Pickeddecimal(38,38)
7301Qty. Picked (Base) SearchQty. Picked (Base)NormalDecimal12Qty_ Picked (Base)decimal(38,38)
7302Completely Picked SearchCompletely PickedNormalBoolean4Completely Pickedtinyint
7303Pick Qty. (Base) SearchPick Qty. (Base)NormalDecimal12Pick Qty_ (Base)decimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Line table

CurrencyCustomer Price GroupItem CategoryLocationProduct GroupResponsibility CenterSales HeaderSales Header ArchiveShip-to AddressShipping AgentShipping Agent ServicesTax AreaTax GroupUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Line

Leave a Reply

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