Transfer Receipt Header

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Transfer Receipt 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]
   ,[Shipment Date]
   ,[Receipt Date]
   ,[In-Transit Code]
   ,[Transfer-from Contact]
   ,[Transfer-to Contact]
   ,[External Document No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Partner VAT ID]
   ,[Entry_Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Direct Transfer]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Transfer Receipt 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 Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Header]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Transfer Receipt 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 Receipt 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 Receipt Header].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Transfer Receipt 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)
27Shipment Date Searchdatetime
28Receipt Date Searchdatetime
29In-Transit Code Searchnvarchar(20)
30Transfer-from Contact Searchnvarchar(200)
31Transfer-to Contact Searchnvarchar(200)
32External Document No_ Searchnvarchar(70)
33Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Transfer Receipt Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Transfer Receipt Header].[Shipment Method Code] = [Shipment Method].[Code]
36Transaction Type Searchnvarchar(20)
37Transport Method Searchnvarchar(20)
38Partner VAT ID Searchnvarchar(40)
39Entry_Exit Point Searchnvarchar(20)
40Area Searchnvarchar(20)
41Transaction Specification Searchnvarchar(20)
42Direct Transfer Searchtinyint
43Dimension Set ID Searchint
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Transfer Receipt Header table

Leave a Reply

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