Inventory Posting Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory Posting Setup

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

Table Type: Company

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

Table Number: 5813

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 Posting Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Location Code]
   ,[Invt_ Posting Group Code]
   ,[Inventory Account]
   ,[Description]
   ,[View All Accounts on Lookup]
   ,[Inventory Account (Interim)]
   ,[WIP Account]
   ,[Material Variance Account]
   ,[Capacity Variance Account]
   ,[Mfg_ Overhead Variance Account]
   ,[Cap_ Overhead Variance Account]
   ,[Subcontracted Variance Account]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Posting Setup$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 Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Inventory Posting Setup].[Location Code] = [Location].[Code]

Show/hide columns in Inventory Posting Setup table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Inventory Posting Setup].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Inventory Posting Setup].[Location Code] = [Location].[Code]
3	Invt_ Posting Group Code	nvarchar(40)
4	Inventory Account	nvarchar(40)
5	Description	nvarchar(200)
6	View All Accounts on Lookup	tinyint
7	Inventory Account (Interim)	nvarchar(40)
8	WIP Account	nvarchar(40)
9	Material Variance Account	nvarchar(40)
10	Capacity Variance Account	nvarchar(40)
11	Mfg_ Overhead Variance Account	nvarchar(40)
12	Cap_ Overhead Variance Account	nvarchar(40)
13	Subcontracted Variance Account	nvarchar(40)
14	$systemId	uniqueidentifier
15	$systemCreatedAt	datetime
16	$systemCreatedBy	uniqueidentifier
17	$systemModifiedAt	datetime
18	$systemModifiedBy	uniqueidentifier