Inventory Adjustment Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory Adjustment Buffer

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

Table Type: Company

Table Name: Inventory Adjustment Buffer
Database Table Name: CRONUS UK Ltd_$Inventory Adjustment Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5895

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 Adjustment Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Adjustment Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Location Code]
   ,[Item Ledger Entry No_]
   ,[Item Ledger Entry Quantity]
   ,[Cost Amount (Actual)]
   ,[Cost Amount (Actual) (ACY)]
   ,[Expected Cost]
   ,[Valued By Average Cost]
   ,[Valuation Date]
   ,[Entry Type]
   ,[Variance Type]
   ,[Cost Amount (Expected)]
   ,[Cost Amount (Expected) (ACY)]
   ,[Variant Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Adjustment 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_$Inventory Adjustment Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjustment Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Inventory Adjustment Buffer].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Inventory Adjustment Buffer].[Location Code] = [Location].[Code]

Show/hide columns in Inventory Adjustment Buffer table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Inventory Adjustment Buffer].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Inventory Adjustment Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjustment Buffer] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Inventory Adjustment Buffer].[Item No_] = [Item].[No_]
4	Posting Date	datetime
5	Document No_	nvarchar(40)
6	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Inventory Adjustment Buffer].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Inventory Adjustment Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Adjustment Buffer] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Inventory Adjustment Buffer].[Location Code] = [Location].[Code]
7	Item Ledger Entry No_	int
8	Item Ledger Entry Quantity	decimal(38,38)
9	Cost Amount (Actual)	decimal(38,38)
10	Cost Amount (Actual) (ACY)	decimal(38,38)
11	Expected Cost	tinyint
12	Valued By Average Cost	tinyint
13	Valuation Date	datetime
14	Entry Type	int
15	Variance Type	int
16	Cost Amount (Expected)	decimal(38,38)
17	Cost Amount (Expected) (ACY)	decimal(38,38)
18	Variant Code	nvarchar(20)
19	$systemId	uniqueidentifier
20	$systemCreatedAt	datetime
21	$systemCreatedBy	uniqueidentifier
22	$systemModifiedAt	datetime
23	$systemModifiedBy	uniqueidentifier