Sales Price Worksheet

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

Table Type: Company

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

Table Number: 7023

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Starting Date]
   ,[Ending Date]
   ,[Sales Type]
   ,[Sales Code]
   ,[Currency Code]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Minimum Quantity]
   ,[Current Unit Price]
   ,[New Unit Price]
   ,[Price Includes VAT]
   ,[Allow Invoice Disc_]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[Sales Description]
   ,[Allow Line Disc_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Price Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Price Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price Worksheet]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Price Worksheet].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Sales Price Worksheet].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Sales Price Worksheet].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Sales Price Worksheet table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Starting Date Primary Key Searchdatetime
3Ending Date Primary Key Searchdatetime
4Sales Type Primary Key Searchint
5Sales Code Primary Key Searchnvarchar(40)
6Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Price Worksheet].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Price Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price Worksheet]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Price Worksheet].[Currency Code] = [Currency].[Code]
7Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Sales Price Worksheet].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Sales Price Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price Worksheet]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Sales Price Worksheet].[Item No_] = [Item].[No_]
8Variant Code Primary Key Searchnvarchar(20)
9Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Price Worksheet].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Price Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price Worksheet]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Price Worksheet].[Unit of Measure Code] = [Unit of Measure].[Code]
10Minimum Quantity Primary Key Searchdecimal(38,38)
11Current Unit Price Searchdecimal(38,38)
12New Unit Price Searchdecimal(38,38)
13Price Includes VAT Searchtinyint
14Allow Invoice Disc_ Searchtinyint
15VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
16Sales Description Searchnvarchar(200)
17Allow Line Disc_ Searchtinyint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Price Worksheet table

Leave a Reply

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