Direct Trans_ Header

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

Table Type: Company

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

Table Number: 5856

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 Direct Trans_ Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Transfer-from Code]
   ,[Transfer-from Name]
   ,[Transfer-from Name 2]
   ,[Transfer-from Address]
   ,[Transfer-from Address 2]
   ,[Transfer-from Post Code]
   ,[Transfer-from City]
   ,[Transfer-from County]
   ,[Trsf_-from Country_Region Code]
   ,[Transfer-to Code]
   ,[Transfer-to Name]
   ,[Transfer-to Name 2]
   ,[Transfer-to Address]
   ,[Transfer-to Address 2]
   ,[Transfer-to Post Code]
   ,[Transfer-to City]
   ,[Transfer-to County]
   ,[Trsf_-to Country_Region Code]
   ,[Transfer Order Date]
   ,[Posting Date]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Transfer Order No_]
   ,[No_ Series]
   ,[Transfer-from Contact]
   ,[Transfer-to Contact]
   ,[External Document No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Direct Trans_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Direct Trans_ Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Transfer-from Code Searchnvarchar(20)
4Transfer-from Name Searchnvarchar(200)
5Transfer-from Name 2 Searchnvarchar(100)
6Transfer-from Address Searchnvarchar(200)
7Transfer-from Address 2 Searchnvarchar(100)
8Transfer-from Post Code Searchnvarchar(40)
9Transfer-from City Searchnvarchar(60)
10Transfer-from County Searchnvarchar(60)
11Trsf_-from Country_Region Code Searchnvarchar(20)
12Transfer-to Code Searchnvarchar(20)
13Transfer-to Name Searchnvarchar(200)
14Transfer-to Name 2 Searchnvarchar(100)
15Transfer-to Address Searchnvarchar(200)
16Transfer-to Address 2 Searchnvarchar(100)
17Transfer-to Post Code Searchnvarchar(40)
18Transfer-to City Searchnvarchar(60)
19Transfer-to County Searchnvarchar(60)
20Trsf_-to Country_Region Code Searchnvarchar(20)
21Transfer Order Date Searchdatetime
22Posting Date Searchdatetime
23Shortcut Dimension 1 Code Searchnvarchar(40)
24Shortcut Dimension 2 Code Searchnvarchar(40)
25Transfer Order No_ Searchnvarchar(40)
26No_ Series Searchnvarchar(40)
27Transfer-from Contact Searchnvarchar(200)
28Transfer-to Contact Searchnvarchar(200)
29External Document No_ Searchnvarchar(70)
30Dimension Set ID Searchint
31$systemId Searchuniqueidentifier
32$systemCreatedAt Searchdatetime
33$systemCreatedBy Searchuniqueidentifier
34$systemModifiedAt Searchdatetime
35$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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