Sales Price and Line Disc Buff

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

Table Number: 1304

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
   [timestamp]
   ,[Line Type]
   ,[Type]
   ,[Code]
   ,[Sales Type]
   ,[Sales Code]
   ,[Starting Date]
   ,[Currency Code]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Minimum Quantity]
   ,[Loaded Item No_]
   ,[Loaded Disc_ Group]
   ,[Loaded Customer No_]
   ,[Loaded Price Group]
   ,[Line Discount _]
   ,[Unit Price]
   ,[Price Includes VAT]
   ,[Allow Invoice Disc_]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[Ending Date]
   ,[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Sales Price and Line Disc Buff].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Price and Line Disc Buff].[Loaded Customer No_] = [Customer].[No_]

Show/hide columns in Sales Price and Line Disc Buff table

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

Show/hide example query

SELECT
       [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]
9Variant Code Primary Key Searchnvarchar(20)
10Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Price and Line Disc Buff].[Unit of Measure Code]
       ,[Unit of Measure].[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Price and Line Disc Buff].[Unit of Measure Code] = [Unit of Measure].[Code]
11Minimum Quantity Primary Key Searchdecimal(38,38)
12Loaded Item No_ Primary Key Searchnvarchar(40)
13Loaded Disc_ Group Primary Key Searchnvarchar(40)
14Loaded Customer No_ Primary Key Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Price and Line Disc Buff].[Loaded Customer No_]
       ,[Customer].[No_]
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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Price and Line Disc Buff].[Loaded Customer No_] = [Customer].[No_]
15Loaded Price Group Primary Key Searchnvarchar(40)
16Line Discount _ Searchdecimal(38,38)
17Unit Price Searchdecimal(38,38)
18Price Includes VAT Searchtinyint
19Allow Invoice Disc_ Searchtinyint
20VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
21Ending Date Searchdatetime
22Allow Line Disc_ Searchtinyint
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Price and Line Disc Buff table

Leave a Reply

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