Invt_ Document Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvt_ Document Header

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

Table Type: Company

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

Table Number: 5850

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_ Document Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document Type]
   ,[No_]
   ,[Posting Description]
   ,[Document Date]
   ,[Posting Date]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Language Code]
   ,[Salesperson_Purchaser Code]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[External Document No_]
   ,[Whse_ Adj_ Bin Code]
   ,[Posting No_]
   ,[Status]
   ,[Gen_ Bus_ Posting Group]
   ,[No_ Printed]
   ,[Correction]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Invt_ Document Header$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_ Document Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt_ Document Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Invt_ Document Header].[Language Code] = [Language].[Code]

Show/hide columns in Invt_ Document Header table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document Type	int
3	No_	nvarchar(40)
4	Posting Description	nvarchar(200)
5	Document Date	datetime
6	Posting Date	datetime
7	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Invt_ Document Header].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Invt_ Document Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Header] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Invt_ Document Header].[Location Code] = [Location].[Code]
8	Shortcut Dimension 1 Code	nvarchar(40)
9	Shortcut Dimension 2 Code	nvarchar(40)
10	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Invt_ Document Header].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Invt_ Document Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Header] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Invt_ Document Header].[Language Code] = [Language].[Code]
11	Salesperson_Purchaser Code	nvarchar(40)
12	No_ Series	nvarchar(40)
13	Posting No_ Series	nvarchar(40)
14	External Document No_	nvarchar(70)
15	Whse_ Adj_ Bin Code	nvarchar(40)
16	Posting No_	nvarchar(40)
17	Status	int
18	Gen_ Bus_ Posting Group	nvarchar(40)
19	No_ Printed	int
20	Correction	tinyint
21	Dimension Set ID	int
22	$systemId	uniqueidentifier
23	$systemCreatedAt	datetime
24	$systemCreatedBy	uniqueidentifier
25	$systemModifiedAt	datetime
26	$systemModifiedBy	uniqueidentifier