Ship-to Address – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShip-to Address

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

Table Type: Company

Table Name: Ship-to Address
Database Table Name: CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 222

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 Ship-to Address can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Customer No_]
   ,[Code]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact]
   ,[Phone No_]
   ,[Telex No_]
   ,[Shipment Method Code]
   ,[Shipping Agent Code]
   ,[Place of Export]
   ,[Country_Region Code]
   ,[Last Date Modified]
   ,[Location Code]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[GLN]
   ,[Post Code]
   ,[County]
   ,[E-Mail]
   ,[Home Page]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Shipping Agent Service Code]
   ,[Service Zone Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Ship-to Address].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Ship-to Address].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Ship-to Address].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Ship-to Address].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Ship-to Address].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Ship-to Address].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Ship-to Address].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]

Show/hide columns in Ship-to Address table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Ship-to Address].[Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Ship-to Address].[Customer No_] = [Customer].[No_]
3	Code	nvarchar(20)
4	Name	nvarchar(200)
5	Name 2	nvarchar(100)
6	Address	nvarchar(200)
7	Address 2	nvarchar(100)
8	City	nvarchar(60)
9	Contact	nvarchar(200)
10	Phone No_	nvarchar(60)
11	Telex No_	nvarchar(60)
12	Shipment Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Ship-to Address].[Shipment Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Ship-to Address].[Shipment Method Code] = [Shipment Method].[Code]
13	Shipping Agent Code	nvarchar(20)
	Key to join to the Shipping Agent table. Show/hide example query SELECT [Ship-to Address].[Shipping Agent Code] ,[Shipping Agent].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent] ON [Ship-to Address].[Shipping Agent Code] = [Shipping Agent].[Code]
14	Place of Export	nvarchar(40)
15	Country_Region Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Ship-to Address].[Country_Region Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Ship-to Address].[Country_Region Code] = [Country_Region].[Code]
16	Last Date Modified	datetime
17	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Ship-to Address].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Ship-to Address].[Location Code] = [Location].[Code]
18	Fax No_	nvarchar(60)
19	Telex Answer Back	nvarchar(40)
20	GLN	nvarchar(26)
21	Post Code	nvarchar(40)
22	County	nvarchar(60)
23	E-Mail	nvarchar(160)
24	Home Page	nvarchar(160)
25	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Ship-to Address].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Ship-to Address].[Tax Area Code] = [Tax Area].[Code]
26	Tax Liable	tinyint
27	Shipping Agent Service Code	nvarchar(20)
	Key to join to the Shipping Agent Services table. Show/hide example query SELECT [Ship-to Address].[Shipping Agent Service Code] ,[Shipping Agent Services].[Code] FROM [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services] ON [Ship-to Address].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
28	Service Zone Code	nvarchar(20)
29	$systemId	uniqueidentifier
30	$systemCreatedAt	datetime
31	$systemCreatedBy	uniqueidentifier
32	$systemModifiedAt	datetime
33	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Ship-to Address table

Country_Region Customer Location Shipment Method Shipping Agent Shipping Agent Services Tax Area

Dynamics 365 BC Table Reference Tables Company Tables SShip-to Address

Leave a Reply Cancel reply