Filed 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
   [timestamp]
   ,[Entry No_]
   ,[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]
   ,[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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Filed Service Contract Header].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Filed Service Contract Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Filed Service Contract Header].[Bill-to Customer No_] = [Customer].[No_]
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_$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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Filed Service Contract Header].[Currency Code] = [Currency].[Code]
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]

Show/hide columns in Filed Service Contract Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Contract No_ Searchnvarchar(40)
4Contract Type Searchint
5Description Searchnvarchar(200)
6Description 2 Searchnvarchar(100)
7Status Searchint
8Change Status Searchint
9Customer No_ Searchnvarchar(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_]
10Name Searchnvarchar(200)
11Address Searchnvarchar(200)
12Address 2 Searchnvarchar(100)
13Post Code Searchnvarchar(40)
14City Searchnvarchar(60)
15Contact Name Searchnvarchar(200)
16Your Reference Searchnvarchar(70)
17Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Filed Service Contract Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
18Bill-to Customer No_ Searchnvarchar(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_]
19Bill-to Name Searchnvarchar(200)
20Bill-to Address Searchnvarchar(200)
21Bill-to Address 2 Searchnvarchar(100)
22Bill-to Post Code Searchnvarchar(40)
23Bill-to City Searchnvarchar(60)
24Ship-to Code Searchnvarchar(20)
25Ship-to Name Searchnvarchar(200)
26Ship-to Address Searchnvarchar(200)
27Ship-to Address 2 Searchnvarchar(100)
28Ship-to Post Code Searchnvarchar(40)
29Ship-to City Searchnvarchar(60)
30Serv_ Contract Acc_ Gr_ Code Searchnvarchar(20)
31Invoice Period Searchint
32Last Invoice Date Searchdatetime
33Next Invoice Date Searchdatetime
34Starting Date Searchdatetime
35Expiration Date Searchdatetime
36First Service Date Searchdatetime
37Max_ Labor Unit Price Searchdecimal(38,38)
38Calcd_ Annual Amount Searchdecimal(38,38)
39Annual Amount Searchdecimal(38,38)
40Amount per Period Searchdecimal(38,38)
41Combine Invoices Searchtinyint
42Prepaid Searchtinyint
43Next Invoice Period Searchnvarchar(60)
44Service Zone Code Searchnvarchar(20)
45Language Code Searchnvarchar(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]
46Cancel Reason Code Searchnvarchar(20)
47Last Price Update Date Searchdatetime
48Next Price Update Date Searchdatetime
49Last Price Update _ Searchdecimal(38,38)
50Response Time (Hours) Searchdecimal(38,38)
51Contract Lines on Invoice Searchtinyint
52Service Period Searchvarchar(32)
53Payment Terms Code Searchnvarchar(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]
54Invoice after Service Searchtinyint
55Quote Type Searchint
56Allow Unbalanced Amounts Searchtinyint
57Contract Group Code Searchnvarchar(20)
58Service Order Type Searchnvarchar(20)
59Shortcut Dimension 1 Code Searchnvarchar(40)
60Shortcut Dimension 2 Code Searchnvarchar(40)
61Accept Before Searchdatetime
62Automatic Credit Memos Searchtinyint
63Template No_ Searchnvarchar(40)
64Price Update Period Searchvarchar(32)
65Price Inv_ Increase Code Searchnvarchar(40)
66Print Increase Text Searchtinyint
67Currency Code Searchnvarchar(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]
68No_ Series Searchnvarchar(40)
69Probability Searchdecimal(38,38)
70Responsibility Center Searchnvarchar(20)
71Phone No_ Searchnvarchar(60)
72Fax No_ Searchnvarchar(60)
73E-Mail Searchnvarchar(160)
74Bill-to County Searchnvarchar(60)
75County Searchnvarchar(60)
76Ship-to County Searchnvarchar(60)
77Country_Region Code Searchnvarchar(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]
78Bill-to Country_Region Code Searchnvarchar(20)
79Ship-to Country_Region Code Searchnvarchar(20)
80Name 2 Searchnvarchar(100)
81Bill-to Name 2 Searchnvarchar(100)
82Ship-to Name 2 Searchnvarchar(100)
83Next Invoice Period Start Searchdatetime
84Next Invoice Period End Searchdatetime
85File Date Searchdatetime
86File Time Searchdatetime
87Filed By Searchnvarchar(100)
88Reason for Filing Searchint
89Contract Type Relation Searchint
90Contract No_ Relation Searchnvarchar(40)
91Dimension Set ID Searchint
92Contact No_ Searchnvarchar(40)
93Bill-to Contact No_ Searchnvarchar(40)
94Bill-to Contact Searchnvarchar(200)
95$systemId Searchuniqueidentifier
96$systemCreatedAt Searchdatetime
97$systemCreatedBy Searchuniqueidentifier
98$systemModifiedAt Searchdatetime
99$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Filed Service Contract Header table

Leave a Reply

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