Whse. Pick Request

Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse. Pick Request

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

Table Type: Company

Table Name: Whse. Pick Request
Database Table Name: CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7325

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[Document Subtype]
   ,[Document No_]
   ,[Location Code]
   ,[Zone Code]
   ,[Bin Code]
   ,[Status]
   ,[Completely Picked]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Whse_ Pick Request$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_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Pick Request]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Whse. Pick Request].[Document Type] = [Sales Header].[Document Type]
      AND
         [Whse. Pick Request].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Whse. Pick Request].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Whse. Pick Request].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse. Pick Request].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Whse. Pick Request].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Whse. Pick Request].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Whse. Pick Request].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Pick Request].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Pick Request].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse. Pick Request table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Shipment”
  • “Internal Pick”
  • “Production”
  • “Assembly”
  • “Job”
2Document Subtype Primary Key SearchDocument SubtypeNormalOption4Document Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse. Pick Request].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Pick Request]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse. Pick Request].[Location Code] = [Location].[Code]
5Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
6Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Whse. Pick Request].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Pick Request]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Whse. Pick Request].[Bin Code] = [Bin].[Code]
7Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
8Completely Picked SearchCompletely PickedNormalBoolean4Completely Pickedtinyint
9Shipment Method Code SearchShipment Method CodeFlowFieldCode10
10Shipping Agent Code SearchShipping Agent CodeFlowFieldCode10
11Shipping Agent Service Code SearchShipping Agent Service CodeFlowFieldCode10
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. Pick Request].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Pick Request]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Pick Request].[$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. Pick Request].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Pick Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Pick Request]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Pick Request].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Whse. Pick Request table

LocationSales HeaderSales Header ArchiveShipment MethodShipping AgentShipping Agent Services
Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse. Pick Request

Leave a Reply

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