Extended Text Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EExtended Text Header

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

Table Type: Company

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

Table Number: 279

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 Extended Text Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Table Name]
   ,[No_]
   ,[Language Code]
   ,[Text No_]
   ,[Starting Date]
   ,[Ending Date]
   ,[All Language Codes]
   ,[Description]
   ,[Sales Quote]
   ,[Sales Invoice]
   ,[Sales Order]
   ,[Sales Credit Memo]
   ,[Purchase Quote]
   ,[Purchase Invoice]
   ,[Purchase Order]
   ,[Purchase Credit Memo]
   ,[Reminder]
   ,[Finance Charge Memo]
   ,[Sales Blanket Order]
   ,[Purchase Blanket Order]
   ,[Prepmt_ Sales Invoice]
   ,[Prepmt_ Sales Credit Memo]
   ,[Prepmt_ Purchase Invoice]
   ,[Prepmt_ Purchase Credit Memo]
   ,[Service Order]
   ,[Service Quote]
   ,[Service Invoice]
   ,[Service Credit Memo]
   ,[Sales Return Order]
   ,[Purchase Return Order]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Extended Text Header table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Table Name	int
3	No_	nvarchar(40)
4	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Extended Text Header].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Extended Text Header].[Language Code] = [Language].[Code]
5	Text No_	int
6	Starting Date	datetime
7	Ending Date	datetime
8	All Language Codes	tinyint
9	Description	nvarchar(200)
10	Sales Quote	tinyint
11	Sales Invoice	tinyint
12	Sales Order	tinyint
13	Sales Credit Memo	tinyint
14	Purchase Quote	tinyint
15	Purchase Invoice	tinyint
16	Purchase Order	tinyint
17	Purchase Credit Memo	tinyint
18	Reminder	tinyint
19	Finance Charge Memo	tinyint
20	Sales Blanket Order	tinyint
21	Purchase Blanket Order	tinyint
22	Prepmt_ Sales Invoice	tinyint
23	Prepmt_ Sales Credit Memo	tinyint
24	Prepmt_ Purchase Invoice	tinyint
25	Prepmt_ Purchase Credit Memo	tinyint
26	Service Order	tinyint
27	Service Quote	tinyint
28	Service Invoice	tinyint
29	Service Credit Memo	tinyint
30	Sales Return Order	tinyint
31	Purchase Return Order	tinyint
32	$systemId	uniqueidentifier
33	$systemCreatedAt	datetime
34	$systemCreatedBy	uniqueidentifier
35	$systemModifiedAt	datetime
36	$systemModifiedBy	uniqueidentifier