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
   [timestamp]
   ,[Entry No_]
   ,[Line No_]
   ,[Contract Type]
   ,[Contract 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]
   ,[$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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Filed Contract Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Filed Contract Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Filed Contract Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Filed Contract Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Line No_ Primary Key Searchint
4Contract Type Searchint
5Contract No_ Searchnvarchar(40)
6Contract Status Searchint
7Service Item No_ Searchnvarchar(40)
8Description Searchnvarchar(200)
9Serial No_ Searchnvarchar(100)
10Service Item Group Code Searchnvarchar(20)
11Customer No_ Searchnvarchar(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_]
12Ship-to Code Searchnvarchar(20)
13Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Filed Contract Line].[Item No_] = [Item].[No_]
14Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Filed Contract Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Filed Contract Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Filed Contract Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Filed Contract Line].[Unit of Measure Code] = [Unit of Measure].[Code]
15Response Time (Hours) Searchdecimal(38,38)
16Last Planned Service Date Searchdatetime
17Next Planned Service Date Searchdatetime
18Last Service Date Searchdatetime
19Last Preventive Maint_ Date Searchdatetime
20Invoiced to Date Searchdatetime
21Credit Memo Date Searchdatetime
22Contract Expiration Date Searchdatetime
23Service Period Searchvarchar(32)
24Line Value Searchdecimal(38,38)
25Line Discount _ Searchdecimal(38,38)
26Line Amount Searchdecimal(38,38)
27Variant Code Searchnvarchar(20)
28Starting Date Searchdatetime
29New Line Searchtinyint
30Credited Searchtinyint
31Line Cost Searchdecimal(38,38)
32Line Discount Amount Searchdecimal(38,38)
33Profit Searchdecimal(38,38)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Filed Contract Line table

Leave a Reply

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