Invt_ Posting Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvt_ Posting Buffer

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

Table Type: Company

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

Table Number: 48

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Posting Date]
   ,[Account Type]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Dimension Set ID]
   ,[Negative]
   ,[Bal_ Account Type]
   ,[Dimension Entry No_]
   ,[Amount]
   ,[Amount (ACY)]
   ,[Interim Account]
   ,[Account No_]
   ,[Entry No_]
   ,[Job No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Invt_ Posting Buffer table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Posting Date	datetime
3	Account Type	int
4	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Invt_ Posting Buffer].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Invt_ Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Posting Buffer] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Invt_ Posting Buffer].[Location Code] = [Location].[Code]
5	Inventory Posting Group	nvarchar(40)
6	Gen_ Bus_ Posting Group	nvarchar(40)
7	Gen_ Prod_ Posting Group	nvarchar(40)
8	Dimension Set ID	int
9	Negative	tinyint
10	Bal_ Account Type	int
11	Dimension Entry No_	int
12	Amount	decimal(38,38)
13	Amount (ACY)	decimal(38,38)
14	Interim Account	tinyint
15	Account No_	nvarchar(40)
16	Entry No_	int
17	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Invt_ Posting Buffer].[Job No_] ,[Job].[Job No_] FROM [CRONUS UK Ltd_$Invt_ Posting Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Posting Buffer] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Invt_ Posting Buffer].[Job No_] = [Job].[Job No_]
18	$systemId	uniqueidentifier
19	$systemCreatedAt	datetime
20	$systemCreatedBy	uniqueidentifier
21	$systemModifiedAt	datetime
22	$systemModifiedBy	uniqueidentifier