Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1304
Table Type: Company
Table Name: Sales Price and Line Disc Buff
Database Table Name: CRONUS UK Ltd_$Sales Price and Line Disc Buff$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 and Line Disc Buff can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[Code]
,[Sales Code]
,[Currency Code]
,[Starting Date]
,[Line Discount _]
,[Unit Price]
,[Price Includes VAT]
,[Allow Invoice Disc_]
,[VAT Bus_ Posting Gr_ (Price)]
,[Sales Type]
,[Minimum Quantity]
,[Ending Date]
,[Type]
,[Line Type]
,[Loaded Item No_]
,[Loaded Disc_ Group]
,[Loaded Customer No_]
,[Loaded Price Group]
,[Unit of Measure Code]
,[Variant Code]
,[Allow Line Disc_]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$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 and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Sales Price and Line Disc Buff].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Sales Price and Line Disc Buff].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Sales Price and Line Disc Buff].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[User] AS [User]
ON
[Sales Price and Line Disc Buff].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Sales Price and Line Disc Buff].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Sales Price and Line Disc Buff table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Code | Code | Normal | Code | 20 | Code | nvarchar(40) |
2 | Sales Code | Sales Code | Normal | Code | 20 | Sales Code | nvarchar(40) |
3 | Currency Code | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Sales Price and Line Disc Buff].[Currency Code] = [Currency].[Code] | |||||||
4 | Starting Date | Starting Date | Normal | Date | 4 | Starting Date | datetime |
5 | Line Discount % | Line Discount % | Normal | Decimal | 12 | Line Discount _ | decimal(38,38) |
6 | Unit Price | Unit Price | Normal | Decimal | 12 | Unit Price | decimal(38,38) |
7 | Price Includes VAT | Price Includes Tax | Normal | Boolean | 4 | Price Includes VAT | tinyint |
10 | Allow Invoice Disc. | Allow Invoice Disc. | Normal | Boolean | 4 | Allow Invoice Disc_ | tinyint |
11 | VAT Bus. Posting Gr. (Price) | Tax Bus. Posting Gr. (Price) | Normal | Code | 20 | VAT Bus_ Posting Gr_ (Price) | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[VAT Bus_ Posting Gr_ (Price)]
,[VAT Business Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
ON
[Sales Price and Line Disc Buff].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code] | |||||||
13 | Sales Type | Sales Type | Normal | Option | 4 | Sales Type | int |
Available options are:
| |||||||
14 | Minimum Quantity | Minimum Quantity | Normal | Decimal | 12 | Minimum Quantity | decimal(38,38) |
15 | Ending Date | Ending Date | Normal | Date | 4 | Ending Date | datetime |
Key to join to the Inventory Period table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[Ending Date]
,[Inventory Period].[Ending Date]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
ON
[Sales Price and Line Disc Buff].[Ending Date] = [Inventory Period].[Ending Date] | |||||||
21 | Type | Type | Normal | Option | 4 | Type | int |
Available options are:
| |||||||
1300 | Line Type | Line Type | Normal | Option | 4 | Line Type | int |
Available options are:
| |||||||
1301 | Loaded Item No. | Loaded Item No. | Normal | Code | 20 | Loaded Item No_ | nvarchar(40) |
1302 | Loaded Disc. Group | Loaded Disc. Group | Normal | Code | 20 | Loaded Disc_ Group | nvarchar(40) |
1303 | Loaded Customer No. | Loaded Customer No. | Normal | Code | 20 | Loaded Customer No_ | nvarchar(40) |
1304 | Loaded Price Group | Loaded Price Group | Normal | Code | 20 | Loaded Price Group | nvarchar(40) |
5400 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
5700 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
Key to join to the Item Variant table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[Variant Code]
,[Item Variant].[Code]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Sales Price and Line Disc Buff].[Variant Code] = [Item Variant].[Code] | |||||||
7001 | Allow Line Disc. | Allow Line Disc. | Normal | Boolean | 4 | Allow Line Disc_ | tinyint |
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[User] AS [User]
ON
[Sales Price and Line Disc Buff].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Sales Price and Line Disc Buff].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Sales Price and Line Disc Buff$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Price and Line Disc Buff]
LEFT JOIN
[User] AS [User]
ON
[Sales Price and Line Disc Buff].[$systemModifiedBy] = [User].[User Security ID] |