Price Worksheet Line

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

Table Type: Company

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

Table Number: 7022

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Price List Code]
   ,[Existing Line]
   ,[Line No_]
   ,[Source Type]
   ,[Source No_]
   ,[Parent Source No_]
   ,[Source ID]
   ,[Asset Type]
   ,[Asset No_]
   ,[Variant Code]
   ,[Currency Code]
   ,[Work Type Code]
   ,[Starting Date]
   ,[Ending Date]
   ,[Minimum Quantity]
   ,[Unit of Measure Code]
   ,[Amount Type]
   ,[Unit Price]
   ,[Cost Factor]
   ,[Unit Cost]
   ,[Line Discount _]
   ,[Allow Line Disc_]
   ,[Allow Invoice Disc_]
   ,[Price Includes VAT]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[VAT Prod_ Posting Group]
   ,[Asset ID]
   ,[Line Amount]
   ,[Price Type]
   ,[Description]
   ,[Status]
   ,[Direct Unit Cost]
   ,[Source Group]
   ,[Existing Unit Price]
   ,[Existing Direct Unit Cost]
   ,[Existing Unit Cost]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Price Worksheet 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_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Price Worksheet Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Price Worksheet Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Price Worksheet Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Price List Code Primary Key Searchnvarchar(40)
3Existing Line Primary Key Searchtinyint
4Line No_ Primary Key Searchint
5Source Type Searchint
6Source No_ Searchnvarchar(40)
7Parent Source No_ Searchnvarchar(40)
8Source ID Searchuniqueidentifier
9Asset Type Searchint
10Asset No_ Searchnvarchar(40)
11Variant Code Searchnvarchar(20)
12Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Price Worksheet Line].[Currency Code] = [Currency].[Code]
13Work Type Code Searchnvarchar(20)
14Starting Date Searchdatetime
15Ending Date Searchdatetime
16Minimum Quantity Searchdecimal(38,38)
17Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Price Worksheet Line].[Unit of Measure Code] = [Unit of Measure].[Code]
18Amount Type Searchint
19Unit Price Searchdecimal(38,38)
20Cost Factor Searchdecimal(38,38)
21Unit Cost Searchdecimal(38,38)
22Line Discount _ Searchdecimal(38,38)
23Allow Line Disc_ Searchtinyint
24Allow Invoice Disc_ Searchtinyint
25Price Includes VAT Searchtinyint
26VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
27VAT Prod_ Posting Group Searchnvarchar(40)
28Asset ID Searchuniqueidentifier
29Line Amount Searchdecimal(38,38)
30Price Type Searchint
31Description Searchnvarchar(200)
32Status Searchint
33Direct Unit Cost Searchdecimal(38,38)
34Source Group Searchint
35Existing Unit Price Searchdecimal(38,38)
36Existing Direct Unit Cost Searchdecimal(38,38)
37Existing Unit Cost Searchdecimal(38,38)
38$systemId Searchuniqueidentifier
39$systemCreatedAt Searchdatetime
40$systemCreatedBy Searchuniqueidentifier
41$systemModifiedAt Searchdatetime
42$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Price Worksheet Line table

Leave a Reply

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