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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Starting Date  | datetime | ||||
| 3 | Ending Date | datetime | ||||
| 4 | Sales Type | int | ||||
| 5 | Sales Code | nvarchar(40) | ||||
| 6 | Currency Code | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[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] | ||||||
| 7 | Item No_ | nvarchar(40) | ||||
Key to join to the Item table.Show/hide example querySELECT
[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_] | ||||||
| 8 | Variant Code | nvarchar(20) | ||||
| 9 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[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] | ||||||
| 10 | Minimum Quantity | decimal(38,38) | ||||
| 11 | Current Unit Price | decimal(38,38) | ||||
| 12 | New Unit Price | decimal(38,38) | ||||
| 13 | Price Includes VAT | tinyint | ||||
| 14 | Allow Invoice Disc_ | tinyint | ||||
| 15 | VAT Bus_ Posting Gr_ (Price) | nvarchar(40) | ||||
| 16 | Sales Description | nvarchar(200) | ||||
| 17 | Allow Line Disc_ | tinyint | ||||
| 18 | $systemId | uniqueidentifier | ||||
| 19 | $systemCreatedAt | datetime | ||||
| 20 | $systemCreatedBy | uniqueidentifier | ||||
| 21 | $systemModifiedAt | datetime | ||||
| 22 | $systemModifiedBy | uniqueidentifier | ||||