Service Mgt. Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesSService Mgt. Setup

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

Table Type: Company

Table Name: Service Mgt. Setup
Database Table Name: CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5911

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Fault Reporting Level]
   ,[Link Service to Service Item]
   ,[Salesperson Mandatory]
   ,[Warranty Disc_ _ (Parts)]
   ,[Warranty Disc_ _ (Labor)]
   ,[Contract Rsp_ Time Mandatory]
   ,[Service Order Starting Fee]
   ,[Register Contract Changes]
   ,[Contract Inv_ Line Text Code]
   ,[Contract Line Inv_ Text Code]
   ,[Contract Inv_ Period Text Code]
   ,[Contract Credit Line Text Code]
   ,[Send First Warning To]
   ,[Send Second Warning To]
   ,[Send Third Warning To]
   ,[First Warning Within (Hours)]
   ,[Second Warning Within (Hours)]
   ,[Third Warning Within (Hours)]
   ,[Next Service Calc_ Method]
   ,[Service Order Type Mandatory]
   ,[Service Zones Option]
   ,[Service Order Start Mandatory]
   ,[Service Order Finish Mandatory]
   ,[Resource Skills Option]
   ,[One Service Item Line_Order]
   ,[Unit of Measure Mandatory]
   ,[Fault Reason Code Mandatory]
   ,[Contract Serv_ Ord_  Max_ Days]
   ,[Last Contract Service Date]
   ,[Work Type Code Mandatory]
   ,[Logo Position on Documents]
   ,[Use Contract Cancel Reason]
   ,[Default Response Time (Hours)]
   ,[Default Warranty Duration]
   ,[Service Invoice Nos_]
   ,[Contract Invoice Nos_]
   ,[Service Item Nos_]
   ,[Service Order Nos_]
   ,[Service Contract Nos_]
   ,[Contract Template Nos_]
   ,[Troubleshooting Nos_]
   ,[Prepaid Posting Document Nos_]
   ,[Loaner Nos_]
   ,[Serv_ Job Responsibility Code]
   ,[Contract Value Calc_ Method]
   ,[Contract Value _]
   ,[Service Quote Nos_]
   ,[Posted Service Invoice Nos_]
   ,[Posted Serv_ Credit Memo Nos_]
   ,[Posted Service Shipment Nos_]
   ,[Shipment on Invoice]
   ,[Skip Manual Reservation]
   ,[Copy Comments Order to Invoice]
   ,[Copy Comments Order to Shpt_]
   ,[Service Credit Memo Nos_]
   ,[Allow Multiple Posting Groups]
   ,[Check Multiple Posting Groups]
   ,[Serv_ Inv_ Template Name]
   ,[Serv_ Contr_ Inv_ Templ_ Name]
   ,[Serv_ Contr_ Cr_M_ Templ_ Name]
   ,[Serv_ Cr_ Memo Templ_ Name]
   ,[Copy Line Descr_ to G_L Entry]
   ,[Invoice Posting Setup]
   ,[Copy Time Sheet to Order]
   ,[Base Calendar Code]
   ,[Contract Credit Memo Nos_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Mgt_ Setup$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 Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost]
      ON
         [Service Mgt. Setup].[Service Order Starting Fee] = [Service Cost].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
      ON
         [Service Mgt. Setup].[Contract Credit Line Text Code] = [Standard Text].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Service Mgt. Setup].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Mgt. Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Mgt. Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Mgt. Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
4Fault Reporting Level SearchFault Reporting LevelNormalOption4Fault Reporting Levelint
Available options are:
  • “None”
  • “Fault”
  • “Fault+Symptom”
  • “Fault+Symptom+Area (IRIS)”
5Link Service to Service Item SearchLink Service to Service ItemNormalBoolean4Link Service to Service Itemtinyint
7Salesperson Mandatory SearchSalesperson MandatoryNormalBoolean4Salesperson Mandatorytinyint
8Warranty Disc. % (Parts) SearchWarranty Disc. % (Parts)NormalDecimal12Warranty Disc_ _ (Parts)decimal(38,38)
9Warranty Disc. % (Labor) SearchWarranty Disc. % (Labor)NormalDecimal12Warranty Disc_ _ (Labor)decimal(38,38)
11Contract Rsp. Time Mandatory SearchContract Rsp. Time MandatoryNormalBoolean4Contract Rsp_ Time Mandatorytinyint
13Service Order Starting Fee SearchService Order Starting FeeNormalCode10Service Order Starting Feenvarchar(20)
Key to join to the Service Cost table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Order Starting Fee]
       ,[Service Cost].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Service Cost$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cost]
              ON
                     [Service Mgt. Setup].[Service Order Starting Fee] = [Service Cost].[Code]
14Register Contract Changes SearchRegister Contract ChangesNormalBoolean4Register Contract Changestinyint
15Contract Inv. Line Text Code SearchContract Inv. Line Text CodeNormalCode20Contract Inv_ Line Text Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Inv_ Line Text Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Mgt. Setup].[Contract Inv_ Line Text Code] = [Standard Text].[Code]
16Contract Line Inv. Text Code SearchContract Line Inv. Text CodeNormalCode20Contract Line Inv_ Text Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Line Inv_ Text Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Mgt. Setup].[Contract Line Inv_ Text Code] = [Standard Text].[Code]
19Contract Inv. Period Text Code SearchContract Inv. Period Text CodeNormalCode20Contract Inv_ Period Text Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Inv_ Period Text Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Mgt. Setup].[Contract Inv_ Period Text Code] = [Standard Text].[Code]
20Contract Credit Line Text Code SearchContract Credit Line Text CodeNormalCode20Contract Credit Line Text Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Credit Line Text Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Mgt. Setup].[Contract Credit Line Text Code] = [Standard Text].[Code]
23Send First Warning To SearchSend First Warning ToNormalText80Send First Warning Tonvarchar(160)
24Send Second Warning To SearchSend Second Warning ToNormalText80Send Second Warning Tonvarchar(160)
25Send Third Warning To SearchSend Third Warning ToNormalText80Send Third Warning Tonvarchar(160)
26First Warning Within (Hours) SearchFirst Warning Within (Hours)NormalDecimal12First Warning Within (Hours)decimal(38,38)
27Second Warning Within (Hours) SearchSecond Warning Within (Hours)NormalDecimal12Second Warning Within (Hours)decimal(38,38)
28Third Warning Within (Hours) SearchThird Warning Within (Hours)NormalDecimal12Third Warning Within (Hours)decimal(38,38)
29Next Service Calc. Method SearchNext Service Calc. MethodNormalOption4Next Service Calc_ Methodint
Available options are:
  • “Planned”
  • “Actual”
30Service Order Type Mandatory SearchService Order Type MandatoryNormalBoolean4Service Order Type Mandatorytinyint
31Service Zones Option SearchService Zones OptionNormalOption4Service Zones Optionint
Available options are:
  • “Code Shown”
  • “Warning Displayed”
  • “Not Used”
32Service Order Start Mandatory SearchService Order Start MandatoryNormalBoolean4Service Order Start Mandatorytinyint
33Service Order Finish Mandatory SearchService Order Finish MandatoryNormalBoolean4Service Order Finish Mandatorytinyint
36Resource Skills Option SearchResource Skills OptionNormalOption4Resource Skills Optionint
Available options are:
  • “Code Shown”
  • “Warning Displayed”
  • “Not Used”
37One Service Item Line/Order SearchOne Service Item Line/OrderNormalBoolean4One Service Item Line_Ordertinyint
38Unit of Measure Mandatory SearchUnit of Measure MandatoryNormalBoolean4Unit of Measure Mandatorytinyint
39Fault Reason Code Mandatory SearchFault Reason Code MandatoryNormalBoolean4Fault Reason Code Mandatorytinyint
40Contract Serv. Ord. Max. Days SearchContract Serv. Ord. Max. DaysNormalInteger4Contract Serv_ Ord_ Max_ Daysint
41Last Contract Service Date SearchLast Contract Service DateNormalDate4Last Contract Service Datedatetime
42Work Type Code Mandatory SearchWork Type Code MandatoryNormalBoolean4Work Type Code Mandatorytinyint
43Logo Position on Documents SearchLogo Position on DocumentsNormalOption4Logo Position on Documentsint
Available options are:
  • “No Logo”
  • “Left”
  • “Center”
  • “Right”
44Use Contract Cancel Reason SearchUse Contract Cancel ReasonNormalBoolean4Use Contract Cancel Reasontinyint
45Default Response Time (Hours) SearchDefault Response Time (Hours)NormalDecimal12Default Response Time (Hours)decimal(38,38)
52Default Warranty Duration SearchDefault Warranty DurationNormalDateFormula32Default Warranty Durationvarchar(32)
54Service Invoice Nos. SearchService Invoice Nos.NormalCode20Service Invoice Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Invoice Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Invoice Nos_] = [No. Series].[Code]
55Contract Invoice Nos. SearchContract Invoice Nos.NormalCode20Contract Invoice Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Invoice Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Contract Invoice Nos_] = [No. Series].[Code]
56Service Item Nos. SearchService Item Nos.NormalCode20Service Item Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Item Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Item Nos_] = [No. Series].[Code]
57Service Order Nos. SearchService Order Nos.NormalCode20Service Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Order Nos_] = [No. Series].[Code]
58Service Contract Nos. SearchService Contract Nos.NormalCode20Service Contract Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Contract Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Contract Nos_] = [No. Series].[Code]
59Contract Template Nos. SearchContract Template Nos.NormalCode20Contract Template Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Template Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Contract Template Nos_] = [No. Series].[Code]
60Troubleshooting Nos. SearchTroubleshooting Nos.NormalCode20Troubleshooting Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Troubleshooting Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Troubleshooting Nos_] = [No. Series].[Code]
61Prepaid Posting Document Nos. SearchPrepaid Posting Document Nos.NormalCode20Prepaid Posting Document Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Prepaid Posting Document Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Prepaid Posting Document Nos_] = [No. Series].[Code]
62Loaner Nos. SearchLoaner Nos.NormalCode20Loaner Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Loaner Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Loaner Nos_] = [No. Series].[Code]
63Serv. Job Responsibility Code SearchServ. Job Responsibility CodeNormalCode10Serv_ Job Responsibility Codenvarchar(20)
Key to join to the Job Responsibility table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Serv_ Job Responsibility Code]
       ,[Job Responsibility].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Job Responsibility$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Responsibility]
              ON
                     [Service Mgt. Setup].[Serv_ Job Responsibility Code] = [Job Responsibility].[Code]
64Contract Value Calc. Method SearchContract Value Calc. MethodNormalOption4Contract Value Calc_ Methodint
Available options are:
  • “None”
  • “Based on Unit Price”
  • “Based on Unit Cost”
65Contract Value % SearchContract Value %NormalDecimal12Contract Value _decimal(38,38)
66Service Quote Nos. SearchService Quote Nos.NormalCode20Service Quote Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Quote Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Quote Nos_] = [No. Series].[Code]
68Posted Service Invoice Nos. SearchPosted Service Invoice Nos.NormalCode20Posted Service Invoice Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Posted Service Invoice Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Posted Service Invoice Nos_] = [No. Series].[Code]
69Posted Serv. Credit Memo Nos. SearchPosted Serv. Credit Memo Nos.NormalCode20Posted Serv_ Credit Memo Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Posted Serv_ Credit Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Posted Serv_ Credit Memo Nos_] = [No. Series].[Code]
70Posted Service Shipment Nos. SearchPosted Service Shipment Nos.NormalCode20Posted Service Shipment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Posted Service Shipment Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Posted Service Shipment Nos_] = [No. Series].[Code]
76Shipment on Invoice SearchShipment on InvoiceNormalBoolean4Shipment on Invoicetinyint
77Skip Manual Reservation SearchSkip Manual ReservationNormalBoolean4Skip Manual Reservationtinyint
81Copy Comments Order to Invoice SearchCopy Comments Order to InvoiceNormalBoolean4Copy Comments Order to Invoicetinyint
82Copy Comments Order to Shpt. SearchCopy Comments Order to Shpt.NormalBoolean4Copy Comments Order to Shpt_tinyint
85Service Credit Memo Nos. SearchService Credit Memo Nos.NormalCode20Service Credit Memo Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Service Credit Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Service Credit Memo Nos_] = [No. Series].[Code]
175Allow Multiple Posting Groups SearchAllow Multiple Posting GroupsNormalBoolean4Allow Multiple Posting Groupstinyint
176Check Multiple Posting Groups SearchCheck Multiple Posting GroupsNormalOption4Check Multiple Posting Groupsint
Available options are:
  • “Alternative Groups”
200Serv. Inv. Template Name SearchServ. Invoice Template NameNormalCode10Serv_ Inv_ Template Namenvarchar(20)
201Serv. Contr. Inv. Templ. Name SearchServ. Contract Invoice Template NameNormalCode10Serv_ Contr_ Inv_ Templ_ Namenvarchar(20)
202Serv. Contr. Cr.M. Templ. Name SearchServ. Contract Cr. Memo Template NameNormalCode10Serv_ Contr_ Cr_M_ Templ_ Namenvarchar(20)
203Serv. Cr. Memo Templ. Name SearchServ. Cr. Memo Template NameNormalCode10Serv_ Cr_ Memo Templ_ Namenvarchar(20)
210Copy Line Descr. to G/L Entry SearchCopy Line Descr. to G/L EntryNormalBoolean4Copy Line Descr_ to G_L Entrytinyint
810Invoice Posting Setup SearchInvoice Posting SetupNormalOption4Invoice Posting Setupint
Available options are:
  • “Invoice Posting (Default)”
  • “Invoice Posting (v.19)”
950Copy Time Sheet to Order SearchCopy Time Sheet to OrderNormalBoolean4Copy Time Sheet to Ordertinyint
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Service Mgt. Setup].[Base Calendar Code] = [Base Calendar].[Code]
7601Contract Credit Memo Nos. SearchContract Credit Memo Nos.NormalCode20Contract Credit Memo Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Mgt. Setup].[Contract Credit Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Mgt. Setup].[Contract Credit Memo Nos_] = [No. Series].[Code]
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 Mgt. Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Mgt. Setup].[$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 Mgt. Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Mgt_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Mgt. Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Mgt. Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Mgt. Setup

Leave a Reply

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