O365 Item Basket Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OO365 Item Basket Entry

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

Table Type: Company

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

Table Number: 2101

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 O365 Item Basket Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Item No_]
   ,[Quantity]
   ,[Unit Price]
   ,[Line Total]
   ,[Description]
   ,[Base Unit of Measure]
   ,[Picture]
   ,[Brick Text 1]
   ,[Brick Text 2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Item Basket Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [O365 Item Basket Entry].[Base Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Item Basket Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Item Basket Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in O365 Item Basket Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [O365 Item Basket Entry].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Item Basket Entry] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [O365 Item Basket Entry].[Item No_] = [Item].[No_]
3	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
4	Unit Price	Unit Price	Normal	Decimal	12	Unit Price	decimal(38,38)
5	Line Total	Line Total	Normal	Decimal	12	Line Total	decimal(38,38)
6	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Base Unit of Measure	Base Unit of Measure	Normal	Code	10	Base Unit of Measure	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [O365 Item Basket Entry].[Base Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Item Basket Entry] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [O365 Item Basket Entry].[Base Unit of Measure] = [Unit of Measure].[Code]
92	Picture	Picture	Normal	MediaSet	16	Picture	uniqueidentifier
150	Brick Text 1	Brick Text 1	Normal	Text	30	Brick Text 1	nvarchar(60)
151	Brick Text 2	Line Amount	Normal	Text	30	Brick Text 2	nvarchar(60)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [O365 Item Basket Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$O365 Item Basket Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Item Basket Entry] LEFT JOIN [User] AS [User] ON [O365 Item Basket Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier