Whse_ Cross-Dock Opportunity

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

Table Type: Company

Table Name: Whse_ Cross-Dock Opportunity
Database Table Name: CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5768

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 Whse_ Cross-Dock Opportunity can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Source Template Name]
   ,[Source Name_No_]
   ,[Source Line No_]
   ,[Line No_]
   ,[From Source Type]
   ,[From Source Subtype]
   ,[From Source No_]
   ,[From Source Line No_]
   ,[From Source Subline No_]
   ,[From Source Document]
   ,[To Source Type]
   ,[To Source Subtype]
   ,[To Source No_]
   ,[To Source Line No_]
   ,[To Source Subline No_]
   ,[To Source Document]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Location Code]
   ,[Qty_ Needed]
   ,[Qty_ Needed (Base)]
   ,[Qty_ to Cross-Dock]
   ,[Qty_ to Cross-Dock (Base)]
   ,[To-Src_ Unit of Measure Code]
   ,[To-Src_ Qty_ per Unit of Meas_]
   ,[Due Date]
   ,[Pick Qty_]
   ,[Pick Qty_ (Base)]
   ,[Picked Qty_]
   ,[Picked Qty_ (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Cross-Dock Opportunity]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Whse_ Cross-Dock Opportunity].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Whse_ Cross-Dock Opportunity].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse_ Cross-Dock Opportunity].[Location Code] = [Location].[Code]

Show/hide columns in Whse_ Cross-Dock Opportunity table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Source Template Name Primary Key Searchnvarchar(20)
3Source Name_No_ Primary Key Searchnvarchar(40)
4Source Line No_ Primary Key Searchint
5Line No_ Primary Key Searchint
6From Source Type Searchint
7From Source Subtype Searchint
8From Source No_ Searchnvarchar(40)
9From Source Line No_ Searchint
10From Source Subline No_ Searchint
11From Source Document Searchint
12To Source Type Searchint
13To Source Subtype Searchint
14To Source No_ Searchnvarchar(40)
15To Source Line No_ Searchint
16To Source Subline No_ Searchint
17To Source Document Searchint
18Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse_ Cross-Dock Opportunity].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Cross-Dock Opportunity]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Whse_ Cross-Dock Opportunity].[Item No_] = [Item].[No_]
19Variant Code Searchnvarchar(20)
20Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Whse_ Cross-Dock Opportunity].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Cross-Dock Opportunity]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Whse_ Cross-Dock Opportunity].[Unit of Measure Code] = [Unit of Measure].[Code]
21Qty_ per Unit of Measure Searchdecimal(38,38)
22Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse_ Cross-Dock Opportunity].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Cross-Dock Opportunity]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse_ Cross-Dock Opportunity].[Location Code] = [Location].[Code]
23Qty_ Needed Searchdecimal(38,38)
24Qty_ Needed (Base) Searchdecimal(38,38)
25Qty_ to Cross-Dock Searchdecimal(38,38)
26Qty_ to Cross-Dock (Base) Searchdecimal(38,38)
27To-Src_ Unit of Measure Code Searchnvarchar(20)
28To-Src_ Qty_ per Unit of Meas_ Searchdecimal(38,38)
29Due Date Searchdatetime
30Pick Qty_ Searchdecimal(38,38)
31Pick Qty_ (Base) Searchdecimal(38,38)
32Picked Qty_ Searchdecimal(38,38)
33Picked Qty_ (Base) Searchdecimal(38,38)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Whse_ Cross-Dock Opportunity table

Leave a Reply

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