O365 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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [O365 Item Basket Entry].[Item No_] = [Item].[No_]

Show/hide columns in O365 Item Basket Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item No_ Primary Key Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [O365 Item Basket Entry].[Item No_] = [Item].[No_]
3Quantity Searchdecimal(38,38)
4Unit Price Searchdecimal(38,38)
5Line Total Searchdecimal(38,38)
6Description Searchnvarchar(200)
7Base Unit of Measure Searchnvarchar(20)
8Picture Searchuniqueidentifier
9Brick Text 1 Searchnvarchar(60)
10Brick Text 2 Searchnvarchar(60)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from O365 Item Basket Entry table

Leave a Reply

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