Warehouse Request

Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse Request

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

Table Type: Company

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

Table Number: 5765

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Document]
   ,[Document Status]
   ,[Location Code]
   ,[Shipment Method Code]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipping Advice]
   ,[Destination Type]
   ,[Destination No_]
   ,[External Document No_]
   ,[Expected Receipt Date]
   ,[Shipment Date]
   ,[Type]
   ,[Completely Handled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Warehouse 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_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Request].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Warehouse Request].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Warehouse Request].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Request].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Request].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Request table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Source Type Primary Key SearchSource TypeNormalInteger4Source Typeint
2Source Subtype Primary Key SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
3Source No. Primary Key SearchSource No.NormalCode20Source No_nvarchar(40)
4Source Document SearchSource DocumentNormalOption4Source Documentint
Available options are:
  • “Sales Order”
  • “Sales Return Order”
  • “Purchase Order”
  • “Purchase Return Order”
  • “Inbound Transfer”
  • “Outbound Transfer”
  • “Prod. Consumption”
  • “Prod. Output”
  • “Service Order”
  • “Assembly Consumption”
  • “Assembly Order”
  • “Job Usage”
5Document Status SearchDocument StatusNormalOption4Document Statusint
Available options are:
  • “Open”
  • “Released”
6Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Warehouse Request].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Request].[Location Code] = [Location].[Code]
7Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Warehouse Request].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Warehouse Request].[Shipment Method Code] = [Shipment Method].[Code]
8Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Warehouse Request].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Warehouse Request].[Shipping Agent Code] = [Shipping Agent].[Code]
9Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
10Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
11Destination Type SearchDestination TypeNormalOption4Destination Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Location”
  • “Item”
  • “Family”
  • “Sales Order”
12Destination No. SearchDestination No.NormalCode20Destination No_nvarchar(40)
13External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
14Expected Receipt Date SearchExpected Receipt DateNormalDate4Expected Receipt Datedatetime
15Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
19Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Inbound”
  • “Outbound”
20Put-away / Pick No. SearchPut-away / Pick No.FlowFieldCode20
41Completely Handled SearchCompletely HandledNormalBoolean4Completely Handledtinyint
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
       [Warehouse Request].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse 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
       [Warehouse Request].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Request]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Request].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Request table

LocationShipment MethodShipping AgentShipping Agent Services
Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse Request

Leave a Reply

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