Price Worksheet Line

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

Table Type: Company

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

Table Number: 7022

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Price List Code]
   ,[Line No_]
   ,[Source Type]
   ,[Source No_]
   ,[Parent Source No_]
   ,[Source ID]
   ,[Asset Type]
   ,[Asset No_]
   ,[Variant Code]
   ,[Currency Code]
   ,[Work Type Code]
   ,[Starting Date]
   ,[Ending Date]
   ,[Minimum Quantity]
   ,[Unit of Measure Code]
   ,[Amount Type]
   ,[Unit Price]
   ,[Cost Factor]
   ,[Unit Cost]
   ,[Line Discount _]
   ,[Allow Line Disc_]
   ,[Allow Invoice Disc_]
   ,[Price Includes VAT]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[VAT Prod_ Posting Group]
   ,[Asset ID]
   ,[Line Amount]
   ,[Price Type]
   ,[Description]
   ,[Status]
   ,[Direct Unit Cost]
   ,[Source Group]
   ,[Product No_]
   ,[Assign-to No_]
   ,[Assign-to Parent No_]
   ,[Variant Code Lookup]
   ,[Unit of Measure Code Lookup]
   ,[Existing Line]
   ,[Existing Unit Price]
   ,[Existing Direct Unit Cost]
   ,[Existing Unit Cost]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
   [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
      ON
         [Price Worksheet Line].[Price List Code] = [Price List Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Price Worksheet Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Price Worksheet Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
      ON
         [Price Worksheet Line].[Work Type Code] = [Work Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Price Worksheet Line].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Price Worksheet Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Price Worksheet Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Price Worksheet Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Price List Code Primary Key SearchPrice List CodeNormalCode20Price List Codenvarchar(40)
Key to join to the Price List Header table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Price List Code]
       ,[Price List Header].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
              ON
                     [Price Worksheet Line].[Price List Code] = [Price List Header].[Code]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Source Type SearchAssign-to TypeNormalOption4Source Typeint
Available options are:
  • “All”
  • “All Customers”
  • “Customer”
  • “Customer Price Group”
  • “Customer Disc. Group”
  • “All Vendors”
  • “Vendor”
  • “All Jobs”
  • “Job”
  • “Job Task”
  • “Campaign”
  • “Contact”
4Source No. SearchAssign-to No.NormalCode20Source No_nvarchar(40)
5Parent Source No. SearchAssign-to Parent No.NormalCode20Parent Source No_nvarchar(40)
6Source ID SearchAssign-to IDNormalGUID16Source IDuniqueidentifier
7Asset Type SearchProduct TypeNormalOption4Asset Typeint
Available options are:
  • ” “
  • “Item”
  • “Item Discount Group”
  • “Resource”
  • “Resource Group”
  • “Service Cost”
  • “G/L Account”
8Asset No. SearchProduct No.NormalCode20Asset No_nvarchar(40)
9Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Price Worksheet Line].[Variant Code] = [Item Variant].[Code]
10Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Price Worksheet Line].[Currency Code] = [Currency].[Code]
11Work Type Code SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Work Type Code]
       ,[Work Type].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Type]
              ON
                     [Price Worksheet Line].[Work Type Code] = [Work Type].[Code]
12Starting Date SearchStarting DateNormalDate4Starting Datedatetime
13Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Price Worksheet Line].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Price Worksheet Line].[Ending Date] = [Inventory Period].[Ending Date]
14Minimum Quantity SearchMinimum QuantityNormalDecimal12Minimum Quantitydecimal(38,38)
15Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
16Amount Type SearchDefinesNormalOption4Amount Typeint
Available options are:
  • “Any”
  • “Price”
  • “Cost”
  • “Discount”
17Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
18Cost Factor SearchCost FactorNormalDecimal12Cost Factordecimal(38,38)
19Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
20Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
21Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
22Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
23Price Includes VAT SearchPrice Includes TaxNormalBoolean4Price Includes VATtinyint
24VAT Bus. Posting Gr. (Price) SearchTax Bus. Posting Gr. (Price)NormalCode20VAT Bus_ Posting Gr_ (Price)nvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Price Worksheet Line].[VAT Bus_ Posting Gr_ (Price)]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Price Worksheet Line].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code]
25VAT Prod. Posting Group SearchTax Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Price Worksheet Line].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Price Worksheet Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
26Asset ID SearchAsset IDNormalGUID16Asset IDuniqueidentifier
27Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
28Price Type SearchPrice TypeNormalOption4Price Typeint
Available options are:
  • “Any”
  • “Sale”
  • “Purchase”
29Description SearchDescriptionNormalText100Descriptionnvarchar(200)
30Status SearchStatusNormalOption4Statusint
Available options are:
  • “Draft”
  • “Active”
  • “Inactive”
31Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
32Source Group SearchSource GroupNormalOption4Source Groupint
Available options are:
  • “All”
  • “Customer”
  • “Vendor”
  • “Job”
33Product No. SearchProduct No.NormalCode20Product No_nvarchar(40)
34Assign-to No. SearchAssign-to No.NormalCode20Assign-to No_nvarchar(40)
35Assign-to Parent No. SearchAssign-to Parent No.NormalCode20Assign-to Parent No_nvarchar(40)
36Variant Code Lookup SearchVariant CodeNormalCode10Variant Code Lookupnvarchar(20)
37Unit of Measure Code Lookup SearchUnit of Measure CodeNormalCode10Unit of Measure Code Lookupnvarchar(20)
100Existing Line Primary Key SearchExisting LineNormalBoolean4Existing Linetinyint
101Existing Unit Price SearchExisting Unit PriceNormalDecimal12Existing Unit Pricedecimal(38,38)
102Existing Direct Unit Cost SearchExisting Direct Unit CostNormalDecimal12Existing Direct Unit Costdecimal(38,38)
103Existing Unit Cost SearchExisting Unit CostNormalDecimal12Existing Unit Costdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Price Worksheet Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Price Worksheet Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Price Worksheet Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Price Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price Worksheet Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Price Worksheet Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Price Worksheet Line table

Leave a Reply

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