Invt_ Post to G_L Test Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvt_ Post to G_L Test Buffer

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

Table Type: Company

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

Table Number: 5822

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_ Post to G_L Test Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Invt_ Post to G_L Test Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Line No_]
   ,[Account No_]
   ,[Posting Date]
   ,[Document No_]
   ,[Description]
   ,[Amount]
   ,[Source Code]
   ,[System-Created Entry]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Additional-Currency Posting]
   ,[Source Currency Code]
   ,[Source Currency Amount]
   ,[Value Entry No_]
   ,[Location Code]
   ,[Invt_ Posting Group Code]
   ,[Inventory Account Type]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Invt_ Post to G_L Test Buffer table

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