Zone

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

Table Type: Company

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

Table Number: 7300

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Location Code]
   ,[Code]
   ,[Description]
   ,[Bin Type Code]
   ,[Warehouse Class Code]
   ,[Special Equipment Code]
   ,[Zone Ranking]
   ,[Cross-Dock Bin Zone]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Zone$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Zone]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Zone].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Zone].[Warehouse Class Code] = [Warehouse Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Zone].[Special Equipment Code] = [Special Equipment].[Code]

Show/hide columns in Zone table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Location Code Primary Key Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Zone].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Zone]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Zone].[Location Code] = [Location].[Code]
3Code Primary Key Searchnvarchar(20)
4Description Searchnvarchar(200)
5Bin Type Code Searchnvarchar(20)
6Warehouse Class Code Searchnvarchar(20)
Key to join to the Warehouse Class table.

Show/hide example query

SELECT
       [Zone].[Warehouse Class Code]
       ,[Warehouse Class].[Code]
FROM
       [CRONUS UK Ltd_$Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Zone]
LEFT JOIN
       [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
              ON
                     [Zone].[Warehouse Class Code] = [Warehouse Class].[Code]
7Special Equipment Code Searchnvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Zone].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Zone]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Zone].[Special Equipment Code] = [Special Equipment].[Code]
8Zone Ranking Searchint
9Cross-Dock Bin Zone Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Zone table

Leave a Reply

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