Filed Contract Line

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

Table Type: Company

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

Table Number: 5971

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Contract Type]
   ,[Contract No_]
   ,[Line No_]
   ,[Contract Status]
   ,[Service Item No_]
   ,[Description]
   ,[Serial No_]
   ,[Service Item Group Code]
   ,[Customer No_]
   ,[Ship-to Code]
   ,[Item No_]
   ,[Unit of Measure Code]
   ,[Response Time (Hours)]
   ,[Last Planned Service Date]
   ,[Next Planned Service Date]
   ,[Last Service Date]
   ,[Last Preventive Maint_ Date]
   ,[Invoiced to Date]
   ,[Credit Memo Date]
   ,[Contract Expiration Date]
   ,[Service Period]
   ,[Line Value]
   ,[Line Discount _]
   ,[Line Amount]
   ,[Variant Code]
   ,[Starting Date]
   ,[New Line]
   ,[Credited]
   ,[Line Cost]
   ,[Line Discount Amount]
   ,[Profit]
   ,[Entry No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Filed Contract Line$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 Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Filed Contract Line].[Service Item Group Code] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Filed Contract Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Filed Contract Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Filed Contract Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Filed Contract Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Filed Contract Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Contract Type SearchContract TypeNormalOption4Contract Typeint
Available options are:
  • “Quote”
  • “Contract”
2Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Contract Status SearchContract StatusNormalOption4Contract Statusint
Available options are:
  • ” “
  • “Signed”
  • “Cancelled”
5Service Item No. SearchService Item No.NormalCode20Service Item No_nvarchar(40)
Key to join to the Service Item table.

Show/hide example query

SELECT
       [Filed Contract Line].[Service Item No_]
       ,[Service Item].[No_]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item]
              ON
                     [Filed Contract Line].[Service Item No_] = [Service Item].[No_]
6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
8Service Item Group Code SearchService Item Group CodeNormalCode10Service Item Group Codenvarchar(20)
Key to join to the Service Item Group table.

Show/hide example query

SELECT
       [Filed Contract Line].[Service Item Group Code]
       ,[Service Item Group].[Code]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
              ON
                     [Filed Contract Line].[Service Item Group Code] = [Service Item Group].[Code]
9Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

SELECT
       [Filed Contract Line].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Filed Contract Line].[Ship-to Code] = [Ship-to Address].[Code]
11Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Filed Contract Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Filed Contract Line].[Item No_] = [Item].[No_]
12Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
13Response Time (Hours) SearchResponse Time (Hours)NormalDecimal12Response Time (Hours)decimal(38,38)
14Last Planned Service Date SearchLast Planned Service DateNormalDate4Last Planned Service Datedatetime
15Next Planned Service Date SearchNext Planned Service DateNormalDate4Next Planned Service Datedatetime
16Last Service Date SearchLast Service DateNormalDate4Last Service Datedatetime
17Last Preventive Maint. Date SearchLast Preventive Maint. DateNormalDate4Last Preventive Maint_ Datedatetime
18Invoiced to Date SearchInvoiced to DateNormalDate4Invoiced to Datedatetime
19Credit Memo Date SearchCredit Memo DateNormalDate4Credit Memo Datedatetime
20Contract Expiration Date SearchContract Expiration DateNormalDate4Contract Expiration Datedatetime
21Service Period SearchService PeriodNormalDateFormula32Service Periodvarchar(32)
22Line Value SearchLine ValueNormalDecimal12Line Valuedecimal(38,38)
23Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
24Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
28Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Filed Contract Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Filed Contract Line].[Variant Code] = [Item Variant].[Code]
29Starting Date SearchStarting DateNormalDate4Starting Datedatetime
30New Line SearchNew LineNormalBoolean4New Linetinyint
31Credited SearchCreditedNormalBoolean4Creditedtinyint
32Line Cost SearchLine CostNormalDecimal12Line Costdecimal(38,38)
33Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
34Profit SearchProfitNormalDecimal12Profitdecimal(38,38)
100Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
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 Contract Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Filed Contract Line].[$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 Contract Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Filed Contract Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Filed Contract Line table

Leave a Reply

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