Transfer Shipment Header

Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Shipment Header

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

Table Type: Company

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

Table Number: 5744

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [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 Shipment 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 Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Shipment Header].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Transfer Shipment Header].[Transfer-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Transfer Shipment Header].[Transfer-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Transfer Shipment Header].[Transfer-to Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Transfer Shipment Header].[Transfer-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Transfer Shipment Header].[Transfer-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Shipment Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Transfer Shipment Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Transfer Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Transfer Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Transfer Shipment Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Transfer Shipment Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Transfer Shipment Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Transfer Shipment Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Transfer Shipment Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
      ON
         [Transfer Shipment Header].[Vehicle Code] = [Fixed Asset].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Shipment Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Transfer Shipment Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Transfer Shipment Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-from Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Transfer Shipment Header].[Transfer-from Code] = [Location].[Code]
3Transfer-from Name SearchTransfer-from NameNormalText100Transfer-from Namenvarchar(200)
4Transfer-from Name 2 SearchTransfer-from Name 2NormalText50Transfer-from Name 2nvarchar(100)
5Transfer-from Address SearchTransfer-from AddressNormalText100Transfer-from Addressnvarchar(200)
6Transfer-from Address 2 SearchTransfer-from Address 2NormalText50Transfer-from Address 2nvarchar(100)
7Transfer-from Post Code SearchTransfer-from ZIP CodeNormalCode20Transfer-from Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-from Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Transfer Shipment Header].[Transfer-from Post Code] = [Post Code].[Code]
8Transfer-from City SearchTransfer-from CityNormalText30Transfer-from Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-from City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Transfer Shipment Header].[Transfer-from City] = [Post Code].[City]
9Transfer-from County SearchTransfer-from StateNormalText30Transfer-from Countynvarchar(60)
10Trsf.-from Country/Region Code SearchTrsf.-from Country/Region CodeNormalCode10Trsf_-from Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Trsf_-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Transfer Shipment Header].[Trsf_-from Country_Region Code] = [Country/Region].[Code]
11Transfer-to Code SearchTransfer-to CodeNormalCode10Transfer-to Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-to Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Transfer Shipment Header].[Transfer-to Code] = [Location].[Code]
12Transfer-to Name SearchTransfer-to NameNormalText100Transfer-to Namenvarchar(200)
13Transfer-to Name 2 SearchTransfer-to Name 2NormalText50Transfer-to Name 2nvarchar(100)
14Transfer-to Address SearchTransfer-to AddressNormalText100Transfer-to Addressnvarchar(200)
15Transfer-to Address 2 SearchTransfer-to Address 2NormalText50Transfer-to Address 2nvarchar(100)
16Transfer-to Post Code SearchTransfer-to ZIP CodeNormalCode20Transfer-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Transfer Shipment Header].[Transfer-to Post Code] = [Post Code].[Code]
17Transfer-to City SearchTransfer-to CityNormalText30Transfer-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Transfer Shipment Header].[Transfer-to City] = [Post Code].[City]
18Transfer-to County SearchTransfer-to StateNormalText30Transfer-to Countynvarchar(60)
19Trsf.-to Country/Region Code SearchTrsf.-to Country/Region CodeNormalCode10Trsf_-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Trsf_-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Transfer Shipment Header].[Trsf_-to Country_Region Code] = [Country/Region].[Code]
20Transfer Order Date SearchTransfer Order DateNormalDate4Transfer Order Datedatetime
21Posting Date SearchPosting DateNormalDate4Posting Datedatetime
22Comment SearchCommentFlowFieldBoolean4
23Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Transfer Shipment Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
24Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Transfer Shipment Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
25Transfer Order No. SearchTransfer Order No.NormalCode20Transfer Order No_nvarchar(40)
Key to join to the Transfer Header table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transfer Order No_]
       ,[Transfer Header].[No_]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transfer Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Header]
              ON
                     [Transfer Shipment Header].[Transfer Order No_] = [Transfer Header].[No_]
26No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Transfer Shipment Header].[No_ Series] = [No. Series].[Code]
27Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
28Receipt Date SearchReceipt DateNormalDate4Receipt Datedatetime
29In-Transit Code SearchIn-Transit CodeNormalCode10In-Transit Codenvarchar(20)
30Transfer-from Contact SearchTransfer-from ContactNormalText100Transfer-from Contactnvarchar(200)
31Transfer-to Contact SearchTransfer-to ContactNormalText100Transfer-to Contactnvarchar(200)
32External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
33Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

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

Show/hide example query

SELECT
       [Transfer Shipment Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Transfer Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
47Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Transfer Shipment Header].[Transaction Type] = [Transaction Type].[Code]
48Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Transfer Shipment Header].[Transport Method] = [Transport Method].[Code]
49Partner VAT ID SearchPartner Tax IDNormalCode20Partner VAT IDnvarchar(40)
59Entry/Exit Point SearchEntry/Exit PointNormalCode10Entry_Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Entry_Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Transfer Shipment Header].[Entry_Exit Point] = [Entry/Exit Point].[Code]
63Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Transfer Shipment Header].[Area] = [Area].[Code]
64Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Transfer Shipment Header].[Transaction Specification] = [Transaction Specification].[Code]
70Direct Transfer SearchDirect TransferNormalBoolean4Direct Transfertinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Transfer Shipment Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Transfer Shipment Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
10020Original Document XML SearchOriginal Document XMLNormalBLOB8
10022Original String SearchOriginal StringNormalBLOB8
10023Digital Stamp SAT SearchDigital Stamp SATNormalBLOB8
10024Certificate Serial No. SearchCertificate Serial No.NormalText250
10025Signed Document XML SearchSigned Document XMLNormalBLOB8
10026Digital Stamp PAC SearchDigital Stamp PACNormalBLOB8
10030Electronic Document Status SearchElectronic Document StatusNormalOption4
10031Date/Time Stamped SearchDate/Time StampedNormalText50
10033Date/Time Canceled SearchDate/Time CanceledNormalText50
10035Error Code SearchError CodeNormalCode10
10036Error Description SearchError DescriptionNormalText250
10037Date/Time Stamp Received SearchDate/Time Stamp ReceivedNormalDateTime8
10038Date/Time Cancel Sent SearchDate/Time Cancel SentNormalDateTime8
10040PAC Web Service Name SearchPAC Web Service NameNormalText50
10041QR Code SearchQR CodeNormalBLOB8
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
10043Date/Time First Req. Sent SearchDate/Time First Req. SentNormalText50
10044Transport Operators SearchTransport OperatorsFlowFieldInteger4
10045Transit-from Date/Time SearchTransit-from Date/TimeNormalDateTime8
10046Transit Hours SearchTransit HoursNormalInteger4
10047Transit Distance SearchTransit DistanceNormalDecimal12
10048Insurer Name SearchInsurer NameNormalText50
10049Insurer Policy Number SearchInsurer Policy NumberNormalText30
10050Foreign Trade SearchForeign TradeNormalBoolean4
10051Vehicle Code SearchVehicle CodeNormalCode20
10052Trailer 1 SearchTrailer 1NormalCode20
10053Trailer 2 SearchTrailer 2NormalCode20
10056Medical Insurer Name SearchMedical Insurer NameNormalText50
10057Medical Ins. Policy Number SearchMedical Ins. Policy NumberNormalText30
10058SAT Weight Unit Of Measure SearchSAT Weight Unit Of MeasureNormalCode10
27002CFDI Cancellation Reason Code SearchCFDI Cancelation ReasonNormalCode10
27003Substitution Document No. SearchSubstitution Document No.NormalCode20
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
27007CFDI Cancellation ID SearchCFDI Cancelation IDNormalText50
27008Marked as Canceled SearchMarked as CanceledNormalBoolean4
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
       [Transfer Shipment Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer Shipment 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
       [Transfer Shipment Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Transfer Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transfer Shipment Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Transfer Shipment Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Transfer Shipment Header table

Shipment MethodShipping AgentShipping Agent Services
Dynamics 365 BC Table ReferenceTablesCompany TablesTTransfer Shipment Header

Leave a Reply

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