Service Contract Header

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

Table Type: Company

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

Table Number: 5965

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Contract No_]
   ,[Contract Type]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Change Status]
   ,[Customer No_]
   ,[Contact Name]
   ,[Your Reference]
   ,[Salesperson Code]
   ,[Bill-to Customer No_]
   ,[Ship-to Code]
   ,[Serv_ Contract Acc_ Gr_ Code]
   ,[Invoice Period]
   ,[Last Invoice Date]
   ,[Next Invoice Date]
   ,[Starting Date]
   ,[Expiration Date]
   ,[First Service Date]
   ,[Max_ Labor Unit Price]
   ,[Annual Amount]
   ,[Amount per Period]
   ,[Combine Invoices]
   ,[Prepaid]
   ,[Next Invoice Period]
   ,[Service Zone Code]
   ,[Language Code]
   ,[Format Region]
   ,[Cancel Reason Code]
   ,[Last Price Update Date]
   ,[Next Price Update Date]
   ,[Last Price Update _]
   ,[Response Time (Hours)]
   ,[Contract Lines on Invoice]
   ,[Service Period]
   ,[Payment Terms Code]
   ,[Invoice after Service]
   ,[Quote Type]
   ,[Allow Unbalanced Amounts]
   ,[Contract Group Code]
   ,[Service Order Type]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Accept Before]
   ,[Automatic Credit Memos]
   ,[Template No_]
   ,[Price Update Period]
   ,[Price Inv_ Increase Code]
   ,[Print Increase Text]
   ,[Currency Code]
   ,[No_ Series]
   ,[Probability]
   ,[Responsibility Center]
   ,[Phone No_]
   ,[Fax No_]
   ,[E-Mail]
   ,[Next Invoice Period Start]
   ,[Next Invoice Period End]
   ,[Payment Method Code]
   ,[Dimension Set ID]
   ,[Direct Debit Mandate ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Bill-to Contact]
   ,[Last Invoice Period End]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [] AS [Service Contract Header]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Service Contract Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Contract Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Contract Header].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Contract Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Contract Header].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Contract Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Service Contract Header].[Cancel Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Service Contract Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
      ON
         [Service Contract Header].[Contract Group Code] = [Contract Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
      ON
         [Service Contract Header].[Service Order Type] = [Service Order Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Contract Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Contract Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Contract Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Contract Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Service Contract Header].[Reason Code Filter] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [Service Contract Header].[Item Filter] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Service Contract Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Contract Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Contract Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Contract Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Contract No. Primary Key SearchContract No.NormalCode20Contract No_nvarchar(40)
2Contract Type Primary Key SearchContract TypeNormalOption4Contract Typeint
Available options are:
  • “Quote”
  • “Contract”
  • “Template”
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
5Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Signed”
  • “Cancelled”
6Change Status SearchChange StatusNormalOption4Change Statusint
Available options are:
  • “Open”
  • “Locked”
7Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Contract Header].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Contract Header].[Customer No_] = [Customer].[No_]
8Name SearchNameFlowFieldText100
9Address SearchAddressFlowFieldText100
10Address 2 SearchAddress 2FlowFieldText50
11Post Code SearchZIP CodeFlowFieldCode20
12City SearchCityFlowFieldText30
13Contact Name SearchContact NameNormalText100Contact Namenvarchar(200)
14Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
15Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Service Contract Header].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Service Contract Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
16Bill-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 Contract Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Contract Header].[Bill-to Customer No_] = [Customer].[No_]
17Bill-to Name SearchBill-to NameFlowFieldText100
18Bill-to Address SearchBill-to AddressFlowFieldText100
19Bill-to Address 2 SearchBill-to Address 2FlowFieldText50
20Bill-to Post Code SearchBill-to ZIP CodeFlowFieldCode20
21Bill-to City SearchBill-to CityFlowFieldText30
22Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Contract Header].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Contract Header].[Ship-to Code] = [Ship-to Address].[Code]
23Ship-to Name SearchShip-to NameFlowFieldText100
24Ship-to Address SearchShip-to AddressFlowFieldText100
25Ship-to Address 2 SearchShip-to Address 2FlowFieldText50
26Ship-to Post Code SearchShip-to ZIP CodeFlowFieldCode20
27Ship-to City SearchShip-to CityFlowFieldText30
28Serv. Contract Acc. Gr. Code SearchServ. Contract Acc. Gr. CodeNormalCode10Serv_ Contract Acc_ Gr_ Codenvarchar(20)
Key to join to the Service Contract Account Group table.

Show/hide example query

SELECT
       [Service Contract Header].[Serv_ Contract Acc_ Gr_ Code]
       ,[Service Contract Account Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Contract Account Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Account Group]
              ON
                     [Service Contract Header].[Serv_ Contract Acc_ Gr_ Code] = [Service Contract Account Group].[Code]
32Invoice Period SearchInvoice PeriodNormalOption4Invoice Periodint
Available options are:
  • “Month”
  • “Two Months”
  • “Quarter”
  • “Half Year”
  • “Year”
  • “None”
33Last Invoice Date SearchLast Invoice DateNormalDate4Last Invoice Datedatetime
34Next Invoice Date SearchNext Invoice DateNormalDate4Next Invoice Datedatetime
35Starting Date SearchStarting DateNormalDate4Starting Datedatetime
36Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
38First Service Date SearchFirst Service DateNormalDate4First Service Datedatetime
39Max. Labor Unit Price SearchMax. Labor Unit PriceNormalDecimal12Max_ Labor Unit Pricedecimal(38,38)
40Calcd. Annual Amount SearchCalcd. Annual AmountFlowFieldDecimal12
42Annual Amount SearchAnnual AmountNormalDecimal12Annual Amountdecimal(38,38)
43Amount per Period SearchAmount per PeriodNormalDecimal12Amount per Perioddecimal(38,38)
44Combine Invoices SearchCombine InvoicesNormalBoolean4Combine Invoicestinyint
45Prepaid SearchPrepaidNormalBoolean4Prepaidtinyint
46Next Invoice Period SearchNext Invoice PeriodNormalText30Next Invoice Periodnvarchar(60)
47Service Zone Code SearchService Zone CodeNormalCode10Service Zone Codenvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
       [Service Contract Header].[Service Zone Code]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Service Contract Header].[Service Zone Code] = [Service Zone].[Code]
48Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Service Contract Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Service Contract Header].[Language Code] = [Language].[Code]
49Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
50Cancel Reason Code SearchCancel Reason CodeNormalCode10Cancel Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Service Contract Header].[Cancel Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Service Contract Header].[Cancel Reason Code] = [Reason Code].[Code]
51Last Price Update Date SearchLast Price Update DateNormalDate4Last Price Update Datedatetime
52Next Price Update Date SearchNext Price Update DateNormalDate4Next Price Update Datedatetime
53Last Price Update % SearchLast Price Update %NormalDecimal12Last Price Update _decimal(38,38)
55Response Time (Hours) SearchResponse Time (Hours)NormalDecimal12Response Time (Hours)decimal(38,38)
56Contract Lines on Invoice SearchContract Lines on InvoiceNormalBoolean4Contract Lines on Invoicetinyint
57No. of Posted Invoices SearchNo. of Posted InvoicesFlowFieldInteger4
58No. of Unposted Invoices SearchNo. of Unposted InvoicesFlowFieldInteger4
59Service Period SearchService PeriodNormalDateFormula32Service Periodvarchar(32)
60Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Service Contract Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Service Contract Header].[Payment Terms Code] = [Payment Terms].[Code]
62Invoice after Service SearchInvoice after ServiceNormalBoolean4Invoice after Servicetinyint
63Quote Type SearchQuote TypeNormalOption4Quote Typeint
Available options are:
  • “Quote 1”
  • “Quote 2”
  • “Quote 3”
  • “Quote 4”
  • “Quote 5”
  • “Quote 6”
  • “Quote 7”
  • “Quote 8”
64Allow Unbalanced Amounts SearchAllow Unbalanced AmountsNormalBoolean4Allow Unbalanced Amountstinyint
65Contract Group Code SearchContract Group CodeNormalCode10Contract Group Codenvarchar(20)
Key to join to the Contract Group table.

Show/hide example query

SELECT
       [Service Contract Header].[Contract Group Code]
       ,[Contract Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
              ON
                     [Service Contract Header].[Contract Group Code] = [Contract Group].[Code]
66Service Order Type SearchService Order TypeNormalCode10Service Order Typenvarchar(20)
Key to join to the Service Order Type table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Service Contract Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Contract Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
69Accept Before SearchAccept BeforeNormalDate4Accept Beforedatetime
71Automatic Credit Memos SearchAutomatic Credit MemosNormalBoolean4Automatic Credit Memostinyint
74Template No. SearchTemplate No.NormalCode20Template No_nvarchar(40)
75Price Update Period SearchPrice Update PeriodNormalDateFormula32Price Update Periodvarchar(32)
79Price Inv. Increase Code SearchPrice Inv. Increase CodeNormalCode20Price Inv_ Increase Codenvarchar(40)
Key to join to the Standard Text table.

Show/hide example query

SELECT
       [Service Contract Header].[Price Inv_ Increase Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Service Contract Header].[Price Inv_ Increase Code] = [Standard Text].[Code]
80Print Increase Text SearchPrint Increase TextNormalBoolean4Print Increase Texttinyint
81Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Service Contract Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Service Contract Header].[Currency Code] = [Currency].[Code]
82No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Contract Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Contract Header].[No_ Series] = [No. Series].[Code]
83Probability SearchProbabilityNormalDecimal12Probabilitydecimal(38,38)
84Comment SearchCommentFlowFieldBoolean4
85Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Contract Header].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Contract Header].[Responsibility Center] = [Responsibility Center].[Code]
86Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
87Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
88E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
89Bill-to County SearchBill-to StateFlowFieldText30
90County SearchStateFlowFieldText30
91Ship-to County SearchShip-to StateFlowFieldText30
92Country/Region Code SearchCountry/Region CodeFlowFieldCode10
93Bill-to Country/Region Code SearchBill-to Country/Region CodeFlowFieldCode10
94Ship-to Country/Region Code SearchShip-to Country/Region CodeFlowFieldCode10
95Name 2 SearchName 2FlowFieldText50
96Bill-to Name 2 SearchBill-to Name 2FlowFieldText50
97Ship-to Name 2 SearchShip-to Name 2FlowFieldText50
98Next Invoice Period Start SearchNext Invoice Period StartNormalDate4Next Invoice Period Startdatetime
99Next Invoice Period End SearchNext Invoice Period EndNormalDate4Next Invoice Period Enddatetime
100Contract Invoice Amount SearchContract Invoice AmountFlowFieldDecimal12
101Contract Prepaid Amount SearchContract Prepaid AmountFlowFieldDecimal12
102Contract Discount Amount SearchContract Discount AmountFlowFieldDecimal12
103Contract Cost Amount SearchContract Cost AmountFlowFieldDecimal12
104Contract Gain/Loss Amount SearchContract Gain/Loss AmountFlowFieldDecimal12
106No. of Posted Credit Memos SearchNo. of Posted Credit MemosFlowFieldInteger4
107No. of Unposted Credit Memos SearchNo. of Unposted Credit MemosFlowFieldInteger4
140Type Filter SearchType FilterFlowFilterOption4
141Reason Code Filter SearchReason Code FilterFlowFilterCode10
142Posted Service Order Filter SearchPosted Service Order FilterFlowFilterCode20
143Date Filter SearchDate FilterFlowFilterDate4
144Item Filter SearchItem FilterFlowFilterCode20
204Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Service Contract Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Service Contract Header].[Payment Method Code] = [Payment Method].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Contract Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Contract Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
5050Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Service Contract Header].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Service Contract Header].[Contact No_] = [Contact].[No_]
5051Bill-to Contact No. SearchBill-to Contact No.NormalCode20Bill-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Service Contract Header].[Bill-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Service Contract Header].[Bill-to Contact No_] = [Contact].[No_]
5052Bill-to Contact SearchBill-to ContactNormalText100Bill-to Contactnvarchar(200)
5053Last Invoice Period End SearchLast Invoice Period EndNormalDate4Last Invoice Period Enddatetime
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 Contract Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Contract Header].[$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 Contract Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Contract Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Contract Header table

Leave a Reply

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