Service Item

Dynamics 365 BC Table ReferenceTablesCompany TablesSService Item

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

Table Type: Company

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

Table Number: 5940

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 Item can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Serial No_]
   ,[Service Item Group Code]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Priority]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[Item No_]
   ,[Unit of Measure Code]
   ,[Location of Service Item]
   ,[Sales Unit Price]
   ,[Sales Unit Cost]
   ,[Warranty Starting Date (Labor)]
   ,[Warranty Ending Date (Labor)]
   ,[Warranty Starting Date (Parts)]
   ,[Warranty Ending Date (Parts)]
   ,[Warranty _ (Parts)]
   ,[Warranty _ (Labor)]
   ,[Response Time (Hours)]
   ,[Installation Date]
   ,[Sales Date]
   ,[Last Service Date]
   ,[Default Contract Value]
   ,[Default Contract Discount _]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[No_ Series]
   ,[Vendor Item Name]
   ,[Preferred Resource]
   ,[Variant Code]
   ,[Service Price Group Code]
   ,[Default Contract Cost]
   ,[Search Description]
   ,[Sales_Serv_ Shpt_ Document No_]
   ,[Sales_Serv_ Shpt_ Line No_]
   ,[Shipment Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Item$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 Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Service Item].[Service Item Group Code] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Item].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Item].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Item].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Item].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Item].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Service Item].[Preferred Resource] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Service Item].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
      ON
         [Service Item].[Service Price Group Code] = [Service Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
      ON
         [Service Item].[Service Order Filter] = [Service Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Item table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
3Service Item Group Code SearchService Item Group CodeNormalCode10Service Item Group Codenvarchar(20)
Key to join to the Service Item Group table.

Show/hide example query

SELECT
       [Service Item].[Service Item Group Code]
       ,[Service Item Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
              ON
                     [Service Item].[Service Item Group Code] = [Service Item Group].[Code]
4Description SearchDescriptionNormalText100Descriptionnvarchar(200)
5Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
6Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Own Service Item”
  • “Installed”
  • “Temporarily Installed”
  • “Defective”
7Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “Low”
  • “Medium”
  • “High”
8Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Item].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Item].[Customer No_] = [Customer].[No_]
9Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Item].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Item].[Ship-to Code] = [Ship-to Address].[Code]
10Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Service Item].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Service Item].[Item No_] = [Item].[No_]
11Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
12Location of Service Item SearchLocation of Service ItemNormalText30Location of Service Itemnvarchar(60)
13Sales Unit Price SearchSales Unit PriceNormalDecimal12Sales Unit Pricedecimal(38,38)
14Sales Unit Cost SearchSales Unit CostNormalDecimal12Sales Unit Costdecimal(38,38)
15Warranty Starting Date (Labor) SearchWarranty Starting Date (Labor)NormalDate4Warranty Starting Date (Labor)datetime
16Warranty Ending Date (Labor) SearchWarranty Ending Date (Labor)NormalDate4Warranty Ending Date (Labor)datetime
17Warranty Starting Date (Parts) SearchWarranty Starting Date (Parts)NormalDate4Warranty Starting Date (Parts)datetime
18Warranty Ending Date (Parts) SearchWarranty Ending Date (Parts)NormalDate4Warranty Ending Date (Parts)datetime
19Warranty % (Parts) SearchWarranty % (Parts)NormalDecimal12Warranty _ (Parts)decimal(38,38)
20Warranty % (Labor) SearchWarranty % (Labor)NormalDecimal12Warranty _ (Labor)decimal(38,38)
21Response Time (Hours) SearchResponse Time (Hours)NormalDecimal12Response Time (Hours)decimal(38,38)
22Installation Date SearchInstallation DateNormalDate4Installation Datedatetime
23Sales Date SearchSales DateNormalDate4Sales Datedatetime
24Last Service Date SearchLast Service DateNormalDate4Last Service Datedatetime
25Default Contract Value SearchDefault Contract ValueNormalDecimal12Default Contract Valuedecimal(38,38)
26Default Contract Discount % SearchDefault Contract Discount %NormalDecimal12Default Contract Discount _decimal(38,38)
28No. of Active Contracts SearchNo. of Active ContractsFlowFieldInteger4
33Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Service Item].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Service Item].[Vendor No_] = [Vendor].[No_]
34Vendor Item No. SearchVendor Item No.NormalCode50Vendor Item No_nvarchar(100)
47No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Item].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Item].[No_ Series] = [No. Series].[Code]
48Item Description SearchItem DescriptionFlowFieldText100
49Name SearchNameFlowFieldText100
50Address SearchAddressFlowFieldText100
51Address 2 SearchAddress 2FlowFieldText50
52Post Code SearchZIP CodeFlowFieldCode20
53City SearchCityFlowFieldText30
54Contact SearchContactFlowFieldText100
55Phone No. SearchPhone No.FlowFieldText30
56Ship-to Name SearchShip-to NameFlowFieldText100
57Ship-to Address SearchShip-to AddressFlowFieldText100
58Ship-to Address 2 SearchShip-to Address 2FlowFieldText50
59Ship-to Post Code SearchShip-to ZIP CodeFlowFieldCode20
60Ship-to City SearchShip-to CityFlowFieldText30
61Ship-to Contact SearchShip-to ContactFlowFieldText100
62Ship-to Phone No. SearchShip-to Phone No.FlowFieldText30
63Usage (Cost) SearchUsage (Cost)FlowFieldDecimal12
64Usage (Amount) SearchUsage (Amount)FlowFieldDecimal12
65Invoiced Amount SearchInvoiced AmountFlowFieldDecimal12
66Total Quantity SearchTotal QuantityFlowFieldDecimal12
67Total Qty. Invoiced SearchTotal Qty. InvoicedFlowFieldDecimal12
68Resources Used SearchResources UsedFlowFieldDecimal12
69Parts Used SearchParts UsedFlowFieldDecimal12
70Cost Used SearchCost UsedFlowFieldDecimal12
71Vendor Name SearchVendor NameFlowFieldText100
72Vendor Item Name SearchVendor Item NameNormalText100Vendor Item Namenvarchar(200)
73Comment SearchCommentFlowFieldBoolean4
74Service Item Components SearchService Item ComponentsFlowFieldBoolean4
75Preferred Resource SearchPreferred ResourceNormalCode20Preferred Resourcenvarchar(40)
Key to join to the Resource table.

Show/hide example query

SELECT
       [Service Item].[Preferred Resource]
       ,[Resource].[No_]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
              ON
                     [Service Item].[Preferred Resource] = [Resource].[No_]
76Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Service Item].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Service Item].[Variant Code] = [Item Variant].[Code]
77County SearchStateFlowFieldText30
78Ship-to County SearchShip-to StateFlowFieldText30
79Contract Cost SearchContract CostFlowFieldDecimal12
81Country/Region Code SearchCountry/Region CodeFlowFieldCode10
82Ship-to Country/Region Code SearchShip-to Country/Region CodeFlowFieldCode10
83Name 2 SearchName 2FlowFieldText50
84Ship-to Name 2 SearchShip-to Name 2FlowFieldText50
85Service 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 Item].[Service Price Group Code]
       ,[Service Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [CRONUS UK Ltd_$Service Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Price Group]
              ON
                     [Service Item].[Service Price Group Code] = [Service Price Group].[Code]
86Default Contract Cost SearchDefault Contract CostNormalDecimal12Default Contract Costdecimal(38,38)
87Prepaid Amount SearchPrepaid AmountFlowFieldDecimal12
88Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
89Service Contracts SearchService ContractsFlowFieldBoolean4
90Total Qty. Consumed SearchTotal Qty. ConsumedFlowFieldDecimal12
100Date Filter SearchDate FilterFlowFilterDate4
101Type Filter SearchType FilterFlowFilterOption4
102Contract Filter SearchContract FilterFlowFilterCode20
103Service Order Filter SearchService Order FilterFlowFilterCode20
104Sales/Serv. Shpt. Document No. SearchSales/Serv. Shpt. Document No.NormalCode20Sales_Serv_ Shpt_ Document No_nvarchar(40)
105Sales/Serv. Shpt. Line No. SearchSales/Serv. Shpt. Line No.NormalInteger4Sales_Serv_ Shpt_ Line No_int
106Shipment Type SearchShipment TypeNormalOption4Shipment Typeint
Available options are:
  • “Sales”
  • “Service”
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 Item].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Item].[$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 Item].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Item].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Item table

Post CodeShip-to AddressUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Item

Leave a Reply

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