Extended Text Header

Dynamics 365 BC Table ReferenceTablesCompany TablesEExtended 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

   [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]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Extended Text Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Extended Text Header].[Reminder] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Extended Text Header].[Finance Charge Memo] = [Source Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Extended Text Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Extended Text Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Extended Text Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table Name Primary Key SearchTable NameNormalOption4Table Nameint
Available options are:
  • “Standard Text”
  • “G/L Account”
  • “Item”
  • “Resource”
  • “VAT Clause”
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Language Code Primary Key SearchLanguage CodeNormalCode10Language Codenvarchar(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]
4Text No. Primary Key SearchText No.NormalInteger4Text No_int
5Starting Date SearchStarting DateNormalDate4Starting Datedatetime
6Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Extended Text Header].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Extended Text Header].[Ending Date] = [Inventory Period].[Ending Date]
7All Language Codes SearchAll Language CodesNormalBoolean4All Language Codestinyint
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Sales Quote SearchSales QuoteNormalBoolean4Sales Quotetinyint
12Sales Invoice SearchSales InvoiceNormalBoolean4Sales Invoicetinyint
13Sales Order SearchSales OrderNormalBoolean4Sales Ordertinyint
14Sales Credit Memo SearchSales Credit MemoNormalBoolean4Sales Credit Memotinyint
15Purchase Quote SearchPurchase QuoteNormalBoolean4Purchase Quotetinyint
16Purchase Invoice SearchPurchase InvoiceNormalBoolean4Purchase Invoicetinyint
17Purchase Order SearchPurchase OrderNormalBoolean4Purchase Ordertinyint
18Purchase Credit Memo SearchPurchase Credit MemoNormalBoolean4Purchase Credit Memotinyint
19Reminder SearchReminderNormalBoolean4Remindertinyint
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Extended Text Header].[Reminder]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Extended Text Header].[Reminder] = [Source Code].[Code]
20Finance Charge Memo SearchFinance Charge MemoNormalBoolean4Finance Charge Memotinyint
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Extended Text Header].[Finance Charge Memo]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Extended Text Header].[Finance Charge Memo] = [Source Code].[Code]
21Sales Blanket Order SearchSales Blanket OrderNormalBoolean4Sales Blanket Ordertinyint
22Purchase Blanket Order SearchPurchase Blanket OrderNormalBoolean4Purchase Blanket Ordertinyint
23Prepmt. Sales Invoice SearchPrepmt. Sales InvoiceNormalBoolean4Prepmt_ Sales Invoicetinyint
24Prepmt. Sales Credit Memo SearchPrepmt. Sales Credit MemoNormalBoolean4Prepmt_ Sales Credit Memotinyint
25Prepmt. Purchase Invoice SearchPrepmt. Purchase InvoiceNormalBoolean4Prepmt_ Purchase Invoicetinyint
26Prepmt. Purchase Credit Memo SearchPrepmt. Purchase Credit MemoNormalBoolean4Prepmt_ Purchase Credit Memotinyint
5900Service Order SearchService OrderNormalBoolean4Service Ordertinyint
5901Service Quote SearchService QuoteNormalBoolean4Service Quotetinyint
5902Service Invoice SearchService InvoiceNormalBoolean4Service Invoicetinyint
5903Service Credit Memo SearchService Credit MemoNormalBoolean4Service Credit Memotinyint
6600Sales Return Order SearchSales Return OrderNormalBoolean4Sales Return Ordertinyint
6605Purchase Return Order SearchPurchase Return OrderNormalBoolean4Purchase Return Ordertinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Extended Text Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Extended Text Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Extended Text Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Extended Text Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Extended Text Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Extended Text Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Extended Text Header table

Language
Dynamics 365 BC Table ReferenceTablesCompany TablesEExtended Text Header

Leave a Reply

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