Nonstock Item

Dynamics 365 BC Table ReferenceTablesCompany TablesNNonstock 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: 5718

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

   [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_]
   ,[Item No_ Series]
   ,[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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer]
      ON
         [Nonstock Item].[Manufacturer Code] = [Manufacturer].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Nonstock Item].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Nonstock Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Nonstock Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Nonstock Item table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalCode20Entry No_nvarchar(40)
2Manufacturer Code Primary Key SearchManufacturer CodeNormalCode10Manufacturer Codenvarchar(20)
Key to join to the Manufacturer table.

Show/hide example query

SELECT
	       [Nonstock Item].[Manufacturer Code]
	       ,[Manufacturer].[Code]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [CRONUS UK Ltd_$Manufacturer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer]
	              ON
	                     [Nonstock Item].[Manufacturer Code] = [Manufacturer].[Code]
3Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(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_]
4Vendor Item No. SearchVendor Item No.NormalCode50Vendor Item No_nvarchar(100)
5Description SearchDescriptionNormalText100Descriptionnvarchar(200)
6Unit of Measure SearchUnit of MeasureNormalCode10Unit of Measurenvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
	       [Nonstock Item].[Unit of Measure]
	       ,[Unit of Measure].[Code]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
	              ON
	                     [Nonstock Item].[Unit of Measure] = [Unit of Measure].[Code]
7Published Cost SearchPublished CostNormalDecimal12Published Costdecimal(38,38)
8Negotiated Cost SearchNegotiated CostNormalDecimal12Negotiated Costdecimal(38,38)
9Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
10Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
11Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
12Item Template Code SearchItem Template CodeNormalCode10Item Template Codenvarchar(20)
13Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
14Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
15Bar Code SearchBar CodeNormalCode20Bar Codenvarchar(40)
16Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Nonstock Item].[Item No_] = [Item].[No_]
17Item No. Series SearchItem No. SeriesNormalCode20Item No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Nonstock Item].[Item No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Nonstock Item].[Item No_ Series] = [No. Series].[Code]
53Comment SearchCommentFlowFieldBoolean4
97No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Nonstock Item].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Nonstock Item].[No_ Series] = [No. Series].[Code]
98Item Templ. Code SearchItem Template CodeNormalCode20Item Templ_ Codenvarchar(40)
Key to join to the Item Templ. table.

Show/hide example query

SELECT
	       [Nonstock Item].[Item Templ_ Code]
	       ,[Item Templ.].[Code]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.]
	              ON
	                     [Nonstock Item].[Item Templ_ Code] = [Item Templ.].[Code]
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
	       [Nonstock Item].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Nonstock Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Nonstock Item]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Nonstock Item].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Nonstock Item table

Product Group
Dynamics 365 BC Table ReferenceTablesCompany TablesNNonstock Item

Leave a Reply

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