Nonstock Item

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

Table Type: Company

Table Name: Nonstock Item
Database Table Name: CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Nonstock Item can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Manufacturer Code]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Description]
   ,[Unit of Measure]
   ,[Published Cost]
   ,[Negotiated Cost]
   ,[Unit Price]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Item Template Code]
   ,[Product Group Code]
   ,[Last Date Modified]
   ,[Bar Code]
   ,[Item No_]
   ,[No_ Series]
   ,[Item Templ_ Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
LEFT JOIN
   [CRONUS UK Ltd_$Manufacturer] AS [Manufactuer]
      ON
         [Nonstock Item].[Manufacturer Code] = [Manufactuer].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Nonstock Item].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Nonstock Item].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Nonstock Item].[Item No_] = [Item].[No_]

Show/hide columns in Nonstock Item table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchnvarchar(40)
3Manufacturer Code Searchnvarchar(20)
Key to join to the Manufactuer table.

Show/hide example query

SELECT
       [Nonstock Item].[Manufacturer Code]
       ,[Manufactuer].[Code]
FROM
       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
LEFT JOIN
       [CRONUS UK Ltd_$Manufacturer] AS [Manufactuer]
              ON
                     [Nonstock Item].[Manufacturer Code] = [Manufactuer].[Code]
4Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Nonstock Item].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Nonstock Item].[Vendor No_] = [Vendor].[No_]
5Vendor Item No_ Searchnvarchar(100)
6Description Searchnvarchar(200)
7Unit of Measure Searchnvarchar(20)
8Published Cost Searchdecimal(38,38)
9Negotiated Cost Searchdecimal(38,38)
10Unit Price Searchdecimal(38,38)
11Gross Weight Searchdecimal(38,38)
12Net Weight Searchdecimal(38,38)
13Item Template Code Searchnvarchar(20)
14Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Nonstock Item].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Nonstock Item].[Product Group Code] = [Product Group].[Code]
15Last Date Modified Searchdatetime
16Bar Code Searchnvarchar(40)
17Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Nonstock Item].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Nonstock Item].[Item No_] = [Item].[No_]
18No_ Series Searchnvarchar(40)
19Item Templ_ Code Searchnvarchar(40)
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Nonstock Item table

Leave a Reply

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