Invt_ 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Posting Description Searchnvarchar(200)
5Document Date Searchdatetime
6Posting Date Searchdatetime
7Location Code Searchnvarchar(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]
8Shortcut Dimension 1 Code Searchnvarchar(40)
9Shortcut Dimension 2 Code Searchnvarchar(40)
10Language Code Searchnvarchar(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]
11Salesperson_Purchaser Code Searchnvarchar(40)
12No_ Series Searchnvarchar(40)
13Posting No_ Series Searchnvarchar(40)
14External Document No_ Searchnvarchar(70)
15Whse_ Adj_ Bin Code Searchnvarchar(40)
16Posting No_ Searchnvarchar(40)
17Status Searchint
18Gen_ Bus_ Posting Group Searchnvarchar(40)
19No_ Printed Searchint
20Correction Searchtinyint
21Dimension Set ID Searchint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Invt_ Document Header table

Leave a Reply

Your email address will not be published. Required fields are marked *