Purch_ Price Line Disc_ Buff_

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

Table Type: Company

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

Table Number: 1315

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 Purch_ Price Line Disc_ Buff_ can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line Type]
   ,[Starting Date]
   ,[Currency Code]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Minimum Quantity]
   ,[Item No_]
   ,[Vendor No_]
   ,[Line Discount _]
   ,[Direct Unit Cost]
   ,[Ending Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purch_ Price 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_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Price Line Disc_ Buff_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch_ Price 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
         [Purch_ Price Line Disc_ Buff_].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Purch_ Price Line Disc_ Buff_].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Price Line Disc_ Buff_].[Vendor No_] = [Vendor].[No_]

Show/hide columns in Purch_ Price Line Disc_ Buff_ table

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

Show/hide example query

SELECT
       [Purch_ Price Line Disc_ Buff_].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Price Line Disc_ Buff_]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purch_ Price Line Disc_ Buff_].[Currency Code] = [Currency].[Code]
5Variant Code Primary Key Searchnvarchar(40)
6Unit of Measure Code Primary Key Searchnvarchar(40)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Purch_ Price Line Disc_ Buff_].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Price Line Disc_ Buff_]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Purch_ Price Line Disc_ Buff_].[Unit of Measure Code] = [Unit of Measure].[Code]
7Minimum Quantity Primary Key Searchdecimal(38,38)
8Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Purch_ Price Line Disc_ Buff_].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Price Line Disc_ Buff_]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Purch_ Price Line Disc_ Buff_].[Item No_] = [Item].[No_]
9Vendor No_ Primary Key Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch_ Price Line Disc_ Buff_].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Price Line Disc_ Buff_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Price Line Disc_ Buff_]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purch_ Price Line Disc_ Buff_].[Vendor No_] = [Vendor].[No_]
10Line Discount _ Searchdecimal(38,38)
11Direct Unit Cost Searchdecimal(38,38)
12Ending Date Searchdatetime
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purch_ Price Line Disc_ Buff_ table

Leave a Reply

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