GP Item

Dynamics 365 BC Table ReferenceTablesCompany TablesGGP Item

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

Table Type: Company

Table Name: GP Item
Database Table Name:

Table Number: 4095

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

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [GP Item]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Item table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No SearchItem NumberNormalCode75
2Description Primary Key SearchItem DescriptionNormalText50
3SearchDescription SearchSearch DescriptionNormalCode50
4ShortName SearchShort NameNormalText50
5BaseUnitOfMeasure SearchBase Unit of MeasureNormalCode10
6ItemType SearchItem TypeNormalInteger4
7CostingMethod SearchCosting MethodNormalText50
8CurrentCost SearchCurrent CostNormalDecimal12
9StandardCost SearchStandard CostNormalDecimal12
10UnitListPrice SearchUnit List PriceNormalDecimal12
11ShipWeight SearchShipping WeightNormalDecimal12
12InActive SearchBlockedNormalBoolean4
13QuantityOnHand SearchQuantity on HandNormalDecimal12
14SalesUnitOfMeasure SearchSales Unit of MeasureNormalCode10
15PurchUnitOfMeasure SearchPurchase Unit of MeasureNormalCode10
16ItemTrackingCode SearchItem Tracking CodeNormalCode10
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [GP Item].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [GP Item]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [GP Item].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16
Dynamics 365 BC Table ReferenceTablesCompany TablesGGP Item

Leave a Reply

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