Service Order Posting Buffer

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

Table Type: Company

Table Name: Service Order Posting Buffer
Database Table Name: CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5933

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 Service Order Posting Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Service Order No_]
   ,[Entry Type]
   ,[Posting Group Type]
   ,[No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Unit of Measure Code]
   ,[Service Item No_]
   ,[Location Code]
   ,[Appl_-to Service Entry]
   ,[Work Type Code]
   ,[Quantity]
   ,[Total Cost]
   ,[Total Price]
   ,[Service Contract No_]
   ,[Qty_ to Invoice]
   ,[Dimension Entry No_]
   ,[Line Discount _]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Posting Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Order Posting Buffer].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Order Posting Buffer].[Location Code] = [Location].[Code]

Show/hide columns in Service Order Posting Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Service Order No_ Primary Key Searchnvarchar(40)
3Entry Type Primary Key Searchint
4Posting Group Type Primary Key Searchint
5No_ Primary Key Searchnvarchar(40)
6Gen_ Bus_ Posting Group Primary Key Searchnvarchar(40)
7Gen_ Prod_ Posting Group Primary Key Searchnvarchar(40)
8Global Dimension 1 Code Primary Key Searchnvarchar(40)
9Global Dimension 2 Code Primary Key Searchnvarchar(40)
10Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Order Posting Buffer].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Posting Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Order Posting Buffer].[Unit of Measure Code] = [Unit of Measure].[Code]
11Service Item No_ Primary Key Searchnvarchar(40)
12Location Code Primary Key Searchnvarchar(40)
Key to join to the Location table.

Show/hide example query

SELECT
       [Service Order Posting Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Service Order Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Posting Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Service Order Posting Buffer].[Location Code] = [Location].[Code]
13Appl_-to Service Entry Primary Key Searchint
14Work Type Code Searchnvarchar(20)
15Quantity Searchdecimal(38,38)
16Total Cost Searchdecimal(38,38)
17Total Price Searchdecimal(38,38)
18Service Contract No_ Searchnvarchar(40)
19Qty_ to Invoice Searchdecimal(38,38)
20Dimension Entry No_ Searchint
21Line Discount _ Searchdecimal(38,38)
22Dimension Set ID Searchint
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Order Posting Buffer table

Leave a Reply

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