Transfer Header

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

Table Type: Company

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

Table Number: 5740

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Transfer 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]
   ,[Posting Date]
   ,[Shipment Date]
   ,[Receipt Date]
   ,[Status]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[In-Transit Code]
   ,[No_ Series]
   ,[Last Shipment No_]
   ,[Last Receipt No_]
   ,[Transfer-from Contact]
   ,[Transfer-to Contact]
   ,[External Document No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipping Time]
   ,[Shipment Method Code]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Partner VAT ID]
   ,[Entry_Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Direct Transfer]
   ,[Dimension Set ID]
   ,[Shipping Advice]
   ,[Posting from Whse_ Ref_]
   ,[Outbound Whse_ Handling Time]
   ,[Inbound Whse_ Handling Time]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Transfer 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_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Transfer Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Transfer Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Transfer Header].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Transfer 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)
21Posting Date Searchdatetime
22Shipment Date Searchdatetime
23Receipt Date Searchdatetime
24Status Searchint
25Shortcut Dimension 1 Code Searchnvarchar(40)
26Shortcut Dimension 2 Code Searchnvarchar(40)
27In-Transit Code Searchnvarchar(20)
28No_ Series Searchnvarchar(40)
29Last Shipment No_ Searchnvarchar(40)
30Last Receipt No_ Searchnvarchar(40)
31Transfer-from Contact Searchnvarchar(200)
32Transfer-to Contact Searchnvarchar(200)
33External Document No_ Searchnvarchar(70)
34Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Transfer Header].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Transfer Header].[Shipping Agent Code] = [Shipping Agent].[Code]
35Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Transfer Header].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Transfer Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
36Shipping Time Searchvarchar(32)
37Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Transfer Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Transfer Header].[Shipment Method Code] = [Shipment Method].[Code]
38Transaction Type Searchnvarchar(20)
39Transport Method Searchnvarchar(20)
40Partner VAT ID Searchnvarchar(40)
41Entry_Exit Point Searchnvarchar(20)
42Area Searchnvarchar(20)
43Transaction Specification Searchnvarchar(20)
44Direct Transfer Searchtinyint
45Dimension Set ID Searchint
46Shipping Advice Searchint
47Posting from Whse_ Ref_ Searchint
48Outbound Whse_ Handling Time Searchvarchar(32)
49Inbound Whse_ Handling Time Searchvarchar(32)
50Assigned User ID Searchnvarchar(100)
51$systemId Searchuniqueidentifier
52$systemCreatedAt Searchdatetime
53$systemCreatedBy Searchuniqueidentifier
54$systemModifiedAt Searchdatetime
55$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Transfer Header table

Leave a Reply

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