Service 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
   [timestamp]
   ,[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]
   ,[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 columns in Service Mgt_ Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Fault Reporting Level Searchint
4Link Service to Service Item Searchtinyint
5Salesperson Mandatory Searchtinyint
6Warranty Disc_ _ (Parts) Searchdecimal(38,38)
7Warranty Disc_ _ (Labor) Searchdecimal(38,38)
8Contract Rsp_ Time Mandatory Searchtinyint
9Service Order Starting Fee Searchnvarchar(20)
10Register Contract Changes Searchtinyint
11Contract Inv_ Line Text Code Searchnvarchar(40)
12Contract Line Inv_ Text Code Searchnvarchar(40)
13Contract Inv_ Period Text Code Searchnvarchar(40)
14Contract Credit Line Text Code Searchnvarchar(40)
15Send First Warning To Searchnvarchar(160)
16Send Second Warning To Searchnvarchar(160)
17Send Third Warning To Searchnvarchar(160)
18First Warning Within (Hours) Searchdecimal(38,38)
19Second Warning Within (Hours) Searchdecimal(38,38)
20Third Warning Within (Hours) Searchdecimal(38,38)
21Next Service Calc_ Method Searchint
22Service Order Type Mandatory Searchtinyint
23Service Zones Option Searchint
24Service Order Start Mandatory Searchtinyint
25Service Order Finish Mandatory Searchtinyint
26Resource Skills Option Searchint
27One Service Item Line_Order Searchtinyint
28Unit of Measure Mandatory Searchtinyint
29Fault Reason Code Mandatory Searchtinyint
30Contract Serv_ Ord_ Max_ Days Searchint
31Last Contract Service Date Searchdatetime
32Work Type Code Mandatory Searchtinyint
33Logo Position on Documents Searchint
34Use Contract Cancel Reason Searchtinyint
35Default Response Time (Hours) Searchdecimal(38,38)
36Default Warranty Duration Searchvarchar(32)
37Service Invoice Nos_ Searchnvarchar(40)
38Contract Invoice Nos_ Searchnvarchar(40)
39Service Item Nos_ Searchnvarchar(40)
40Service Order Nos_ Searchnvarchar(40)
41Service Contract Nos_ Searchnvarchar(40)
42Contract Template Nos_ Searchnvarchar(40)
43Troubleshooting Nos_ Searchnvarchar(40)
44Prepaid Posting Document Nos_ Searchnvarchar(40)
45Loaner Nos_ Searchnvarchar(40)
46Serv_ Job Responsibility Code Searchnvarchar(20)
47Contract Value Calc_ Method Searchint
48Contract Value _ Searchdecimal(38,38)
49Service Quote Nos_ Searchnvarchar(40)
50Posted Service Invoice Nos_ Searchnvarchar(40)
51Posted Serv_ Credit Memo Nos_ Searchnvarchar(40)
52Posted Service Shipment Nos_ Searchnvarchar(40)
53Shipment on Invoice Searchtinyint
54Skip Manual Reservation Searchtinyint
55Copy Comments Order to Invoice Searchtinyint
56Copy Comments Order to Shpt_ Searchtinyint
57Service Credit Memo Nos_ Searchnvarchar(40)
58Allow Multiple Posting Groups Searchtinyint
59Serv_ Inv_ Template Name Searchnvarchar(20)
60Serv_ Contr_ Inv_ Templ_ Name Searchnvarchar(20)
61Serv_ Contr_ Cr_M_ Templ_ Name Searchnvarchar(20)
62Serv_ Cr_ Memo Templ_ Name Searchnvarchar(20)
63Copy Line Descr_ to G_L Entry Searchtinyint
64Invoice Posting Setup Searchint
65Copy Time Sheet to Order Searchtinyint
66Base Calendar Code Searchnvarchar(20)
67Contract Credit Memo Nos_ Searchnvarchar(40)
68$systemId Searchuniqueidentifier
69$systemCreatedAt Searchdatetime
70$systemCreatedBy Searchuniqueidentifier
71$systemModifiedAt Searchdatetime
72$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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