Inventory Adjmt_ Entry (Order)

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

Table Type: Company

Table Name: Inventory Adjmt_ Entry (Order)
Database Table Name: CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5896

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 Inventory Adjmt_ Entry (Order) can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[Item No_]
   ,[Routing No_]
   ,[Routing Reference No_]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Cost is Adjusted]
   ,[Allow Online Adjustment]
   ,[Unit Cost]
   ,[Direct Cost]
   ,[Indirect Cost]
   ,[Single-Level Material Cost]
   ,[Single-Level Capacity Cost]
   ,[Single-Level Subcontrd_ Cost]
   ,[Single-Level Cap_ Ovhd Cost]
   ,[Single-Level Mfg_ Ovhd Cost]
   ,[Direct Cost (ACY)]
   ,[Indirect Cost (ACY)]
   ,[Single-Lvl Material Cost (ACY)]
   ,[Single-Lvl Capacity Cost (ACY)]
   ,[Single-Lvl Subcontrd Cost(ACY)]
   ,[Single-Lvl Cap_ Ovhd Cost(ACY)]
   ,[Single-Lvl Mfg_ Ovhd Cost(ACY)]
   ,[Completely Invoiced]
   ,[Is Finished]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt_ Entry (Order)]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Inventory Adjmt_ Entry (Order)].[Item No_] = [Item].[No_]

Show/hide columns in Inventory Adjmt_ Entry (Order) table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Order Type Primary Key Searchint
3Order No_ Primary Key Searchnvarchar(40)
4Order Line No_ Primary Key Searchint
5Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Inventory Adjmt_ Entry (Order)].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Inventory Adjmt_ Entry (Order)$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjmt_ Entry (Order)]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Inventory Adjmt_ Entry (Order)].[Item No_] = [Item].[No_]
6Routing No_ Searchnvarchar(40)
7Routing Reference No_ Searchint
8Indirect Cost _ Searchdecimal(38,38)
9Overhead Rate Searchdecimal(38,38)
10Cost is Adjusted Searchtinyint
11Allow Online Adjustment Searchtinyint
12Unit Cost Searchdecimal(38,38)
13Direct Cost Searchdecimal(38,38)
14Indirect Cost Searchdecimal(38,38)
15Single-Level Material Cost Searchdecimal(38,38)
16Single-Level Capacity Cost Searchdecimal(38,38)
17Single-Level Subcontrd_ Cost Searchdecimal(38,38)
18Single-Level Cap_ Ovhd Cost Searchdecimal(38,38)
19Single-Level Mfg_ Ovhd Cost Searchdecimal(38,38)
20Direct Cost (ACY) Searchdecimal(38,38)
21Indirect Cost (ACY) Searchdecimal(38,38)
22Single-Lvl Material Cost (ACY) Searchdecimal(38,38)
23Single-Lvl Capacity Cost (ACY) Searchdecimal(38,38)
24Single-Lvl Subcontrd Cost(ACY) Searchdecimal(38,38)
25Single-Lvl Cap_ Ovhd Cost(ACY) Searchdecimal(38,38)
26Single-Lvl Mfg_ Ovhd Cost(ACY) Searchdecimal(38,38)
27Completely Invoiced Searchtinyint
28Is Finished Searchtinyint
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Inventory Adjmt_ Entry (Order) table

Leave a Reply

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