Extended 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Table Name Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Language Code Primary Key Searchnvarchar(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]
5Text No_ Primary Key Searchint
6Starting Date Searchdatetime
7Ending Date Searchdatetime
8All Language Codes Searchtinyint
9Description Searchnvarchar(200)
10Sales Quote Searchtinyint
11Sales Invoice Searchtinyint
12Sales Order Searchtinyint
13Sales Credit Memo Searchtinyint
14Purchase Quote Searchtinyint
15Purchase Invoice Searchtinyint
16Purchase Order Searchtinyint
17Purchase Credit Memo Searchtinyint
18Reminder Searchtinyint
19Finance Charge Memo Searchtinyint
20Sales Blanket Order Searchtinyint
21Purchase Blanket Order Searchtinyint
22Prepmt_ Sales Invoice Searchtinyint
23Prepmt_ Sales Credit Memo Searchtinyint
24Prepmt_ Purchase Invoice Searchtinyint
25Prepmt_ Purchase Credit Memo Searchtinyint
26Service Order Searchtinyint
27Service Quote Searchtinyint
28Service Invoice Searchtinyint
29Service Credit Memo Searchtinyint
30Sales Return Order Searchtinyint
31Purchase Return Order Searchtinyint
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Extended Text Header table

Leave a Reply

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