Filed Service Contract Header

Dynamics 365 BC Table ReferenceTablesCompany TablesFFiled Service Contract Header

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

Table Type: Company

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

Table Number: 5970

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Filed 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_]
   ,[Name]
   ,[Address]
   ,[Address 2]
   ,[Post Code]
   ,[City]
   ,[Contact Name]
   ,[Your Reference]
   ,[Salesperson Code]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to Post Code]
   ,[Bill-to City]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to Post Code]
   ,[Ship-to City]
   ,[Serv_ Contract Acc_ Gr_ Code]
   ,[Invoice Period]
   ,[Last Invoice Date]
   ,[Next Invoice Date]
   ,[Starting Date]
   ,[Expiration Date]
   ,[First Service Date]
   ,[Max_ Labor Unit Price]
   ,[Calcd_ Annual Amount]
   ,[Annual Amount]
   ,[Amount per Period]
   ,[Combine Invoices]
   ,[Prepaid]
   ,[Next Invoice Period]
   ,[Service Zone Code]
   ,[Language Code]
   ,[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]
   ,[Bill-to County]
   ,[County]
   ,[Ship-to County]
   ,[Country_Region Code]
   ,[Bill-to Country_Region Code]
   ,[Ship-to Country_Region Code]
   ,[Name 2]
   ,[Bill-to Name 2]
   ,[Ship-to Name 2]
   ,[Next Invoice Period Start]
   ,[Next Invoice Period End]
   ,[Entry No_]
   ,[File Date]
   ,[File Time]
   ,[Filed By]
   ,[Reason for Filing]
   ,[Contract Type Relation]
   ,[Contract No_ Relation]
   ,[Dimension Set ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Bill-to Contact]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Filed Service Contract Header].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Filed Service Contract Header].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Filed Service Contract Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Filed Service Contract Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Filed 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
         [Filed 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
         [Filed 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
         [Filed 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
         [Filed 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
         [Filed Service Contract Header].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Filed Service Contract Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Filed 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
         [Filed 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
         [Filed 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
         [Filed Service Contract Header].[Service Order Type] = [Service Order Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Filed Service Contract Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Filed Service Contract Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Filed Service Contract Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Filed Service Contract Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Filed Service Contract Header].[Filed By] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Filed Service Contract Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Filed Service Contract Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Filed Service Contract Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Filed Service Contract Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
2Contract Type SearchContract TypeNormalOption4Contract Typeint
Available options are:
  • “Quote”
  • “Contract”
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
5Status SearchStatusNormalOption4Statusint
Available options are:
  • ” “
  • “Signed”
  • “Canceled”
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
       [Filed Service Contract Header].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Filed Service Contract Header].[Customer No_] = [Customer].[No_]
8Name SearchNameNormalText100Namenvarchar(200)
9Address SearchAddressNormalText100Addressnvarchar(200)
10Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
11Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[Post Code] = [Post Code].[Code]
12City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[City] = [Post Code].[City]
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
       [Filed Service Contract Header].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Filed Service Contract Header].[Bill-to Customer No_] = [Customer].[No_]
17Bill-to Name SearchBill-to NameNormalText100Bill-to Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Bill-to Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Filed Service Contract Header].[Bill-to Name] = [Customer].[Name]
18Bill-to Address SearchBill-to AddressNormalText100Bill-to Addressnvarchar(200)
19Bill-to Address 2 SearchBill-to Address 2NormalText50Bill-to Address 2nvarchar(100)
20Bill-to Post Code SearchBill-to ZIP CodeNormalCode20Bill-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Bill-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[Bill-to Post Code] = [Post Code].[Code]
21Bill-to City SearchBill-to CityNormalText30Bill-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Bill-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[Bill-to City] = [Post Code].[City]
22Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Filed Service Contract Header].[Ship-to Code] = [Ship-to Address].[Code]
23Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
24Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
25Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
26Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[Ship-to Post Code] = [Post Code].[Code]
27Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Filed Service Contract Header].[Ship-to City] = [Post Code].[City]
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
       [Filed Service Contract Header].[Serv_ Contract Acc_ Gr_ Code]
       ,[Service Contract Account Group].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Contract Account Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Contract Account Group]
              ON
                     [Filed 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 AmountNormalDecimal12Calcd_ Annual Amountdecimal(38,38)
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
       [Filed Service Contract Header].[Service Zone Code]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Filed Service Contract Header].[Language Code] = [Language].[Code]
50Cancel Reason Code SearchCancel Reason CodeNormalCode10Cancel Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Cancel Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Filed 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
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
       [Filed Service Contract Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Contract Group Code]
       ,[Contract Group].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contract Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contract Group]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Service Order Type]
       ,[Service Order Type].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Price Inv_ Increase Code]
       ,[Standard Text].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Standard Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Text]
              ON
                     [Filed 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
       [Filed Service Contract Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Filed 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
       [Filed Service Contract Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Filed Service Contract Header].[No_ Series] = [No. Series].[Code]
83Probability SearchProbabilityNormalDecimal12Probabilitydecimal(38,38)
85Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Filed 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 StateNormalText30Bill-to Countynvarchar(60)
90County SearchStateNormalText30Countynvarchar(60)
91Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
92Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Filed Service Contract Header].[Country_Region Code] = [Country/Region].[Code]
93Bill-to Country/Region Code SearchBill-to Country/Region CodeNormalCode10Bill-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Bill-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Filed Service Contract Header].[Bill-to Country_Region Code] = [Country/Region].[Code]
94Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Filed Service Contract Header].[Ship-to Country_Region Code] = [Country/Region].[Code]
95Name 2 SearchName 2NormalText50Name 2nvarchar(100)
96Bill-to Name 2 SearchBill-to Name 2NormalText50Bill-to Name 2nvarchar(100)
97Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
98Next Invoice Period Start SearchNext Invoice Period StartNormalDate4Next Invoice Period Startdatetime
99Next Invoice Period End SearchNext Invoice Period EndNormalDate4Next Invoice Period Enddatetime
100Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
101File Date SearchFile DateNormalDate4File Datedatetime
102File Time SearchFile TimeNormalTime4File Timedatetime
103Filed By SearchFiled ByNormalCode50Filed Bynvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Filed By]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Filed Service Contract Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Service Contract Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Filed Service Contract Header].[Filed By] = [User].[User Name]
104Reason for Filing SearchReason for FilingNormalOption4Reason for Filingint
Available options are:
  • ” “
  • “Contract Signed”
  • “Contract Canceled”
105Contract Type Relation SearchContract Type RelationNormalOption4Contract Type Relationint
Available options are:
  • “Quote”
  • “Contract”
  • “Template”
106Contract No. Relation SearchContract No. RelationNormalCode20Contract No_ Relationnvarchar(40)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

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

Show/hide example query

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

Show/hide tables related from Filed Service Contract Header table

CurrencyLanguagePayment TermsPost CodeResponsibility CenterSalesperson/PurchaserSalesperson/PurchaserService ZoneShip-to Address
Dynamics 365 BC Table ReferenceTablesCompany TablesFFiled Service Contract Header

Leave a Reply

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