Invt_ Receipt Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvt_ Receipt Header

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

Table Type: Company

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

Table Number: 5852

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[No_]
   ,[Posting Description]
   ,[Document Date]
   ,[Posting Date]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Language Code]
   ,[Purchaser Code]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[External Document No_]
   ,[Posting No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Receipt No_]
   ,[No_ Printed]
   ,[Correction]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Invt_ Receipt Header table

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