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
   [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 Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Whse. Cross-Dock Opportunity].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse. Cross-Dock Opportunity].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Cross-Dock Opportunity].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Cross-Dock Opportunity].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse. Cross-Dock Opportunity table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Source Template Name Primary Key SearchSource Template NameNormalCode10Source Template Namenvarchar(20)
2Source Name/No. Primary Key SearchSource Name/No.NormalCode20Source Name_No_nvarchar(40)
3Source Line No. Primary Key SearchSource Line No.NormalInteger4Source Line No_int
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5From Source Type SearchFrom Source TypeNormalInteger4From Source Typeint
6From Source Subtype SearchFrom Source SubtypeNormalOption4From Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
7From Source No. SearchFrom Source No.NormalCode20From Source No_nvarchar(40)
8From Source Line No. SearchFrom Source Line No.NormalInteger4From Source Line No_int
9From Source Subline No. SearchFrom Source Subline No.NormalInteger4From Source Subline No_int
10From Source Document SearchFrom Source DocumentNormalOption4From Source Documentint
Available options are:
  • “”
  • “Sales Order”
  • “Sales Return Order”
  • “Purchase Order”
  • “Purchase Return Order”
  • “Inbound Transfer”
  • “Outbound Transfer”
  • “Prod. Consumption”
  • “Prod. Output”
  • “Item Ledger Entry”
  • “Assembly Consumption”
  • “Assembly Order”
11To Source Type SearchTo Source TypeNormalInteger4To Source Typeint
12To Source Subtype SearchTo Source SubtypeNormalOption4To Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
13To Source No. SearchTo Source No.NormalCode20To Source No_nvarchar(40)
14To Source Line No. SearchTo Source Line No.NormalInteger4To Source Line No_int
15To Source Subline No. SearchTo Source Subline No.NormalInteger4To Source Subline No_int
16To Source Document SearchTo Source DocumentNormalOption4To Source Documentint
Available options are:
  • “”
  • “Sales Order”
  • “Purchase Return OrderOutbound Transfer”
  • “Prod. Order Comp.”
  • “Service OrderAssembly Consumption”
  • “Assembly Order”
17Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Whse. Cross-Dock Opportunity].[Item No_] = [Item].[No_]
18Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Whse. Cross-Dock Opportunity].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Cross-Dock Opportunity]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Whse. Cross-Dock Opportunity].[Variant Code] = [Item Variant].[Code]
19Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
20Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
21Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
24Qty. Needed SearchQty. NeededNormalDecimal12Qty_ Neededdecimal(38,38)
25Qty. Needed (Base) SearchQty. Needed (Base)NormalDecimal12Qty_ Needed (Base)decimal(38,38)
26Qty. to Cross-Dock SearchQty. to Cross-DockNormalDecimal12Qty_ to Cross-Dockdecimal(38,38)
27Qty. to Cross-Dock (Base) SearchQty. to Cross-Dock (Base)NormalDecimal12Qty_ to Cross-Dock (Base)decimal(38,38)
28Qty. Cross-Docked (Base) SearchQty. Cross-Docked (Base)FlowFieldDecimal12
29Total Qty. Needed (Base) SearchTotal Qty. Needed (Base)FlowFieldDecimal12
36Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
37Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
39To-Src. Unit of Measure Code SearchTo-Src. Unit of Measure CodeNormalCode10To-Src_ Unit of Measure Codenvarchar(20)
40To-Src. Qty. per Unit of Meas. SearchTo-Src. Qty. per Unit of Meas.NormalDecimal12To-Src_ Qty_ per Unit of Meas_decimal(38,38)
41Due Date SearchDue DateNormalDate4Due Datedatetime
42Pick Qty. SearchPick Qty.NormalDecimal12Pick Qty_decimal(38,38)
43Pick Qty. (Base) SearchPick Qty. (Base)NormalDecimal12Pick Qty_ (Base)decimal(38,38)
44Picked Qty. SearchPicked Qty.NormalDecimal12Picked Qty_decimal(38,38)
45Picked Qty. (Base) SearchPicked Qty. (Base)NormalDecimal12Picked Qty_ (Base)decimal(38,38)
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
       [Whse. Cross-Dock Opportunity].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Cross-Dock Opportunity]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Cross-Dock Opportunity].[$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
       [Whse. Cross-Dock Opportunity].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Cross-Dock Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Cross-Dock Opportunity]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Cross-Dock Opportunity].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Whse. Cross-Dock Opportunity table

Leave a Reply

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