Price List Line

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

Table Type: Company

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

Table Number: 7001

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Price List Code]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Price List 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 List Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Line]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Price List Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Price List Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Price List Line table

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

Show/hide example query

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

Show/hide example query

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

Show/hide tables related from Price List Line table

Leave a Reply

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