Warehouse Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse Setup

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

Table Type: Company

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

Table Number: 5769

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Whse_ Receipt Nos_]
   ,[Whse_ Put-away Nos_]
   ,[Whse_ Pick Nos_]
   ,[Whse_ Ship Nos_]
   ,[Registered Whse_ Pick Nos_]
   ,[Registered Whse_ Put-away Nos_]
   ,[Require Receive]
   ,[Require Put-away]
   ,[Require Pick]
   ,[Require Shipment]
   ,[Last Whse_ Posting Ref_ No_]
   ,[Receipt Posting Policy]
   ,[Shipment Posting Policy]
   ,[Last Whse_ Posting Ref_ Seq_]
   ,[Posted Whse_ Receipt Nos_]
   ,[Posted Whse_ Shipment Nos_]
   ,[Whse_ Internal Put-away Nos_]
   ,[Whse_ Internal Pick Nos_]
   ,[Whse_ Movement Nos_]
   ,[Registered Whse_ Movement Nos_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Warehouse Setup$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 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Whse. Receipt Nos. SearchWhse. Receipt Nos.NormalCode20Whse_ Receipt Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Receipt Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Receipt Nos_] = [No. Series].[Code]
3Whse. Put-away Nos. SearchWhse. Put-away Nos.NormalCode20Whse_ Put-away Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Put-away Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Put-away Nos_] = [No. Series].[Code]
5Whse. Pick Nos. SearchWhse. Pick Nos.NormalCode20Whse_ Pick Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Pick Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Pick Nos_] = [No. Series].[Code]
6Whse. Ship Nos. SearchWhse. Ship Nos.NormalCode20Whse_ Ship Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Ship Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Ship Nos_] = [No. Series].[Code]
7Registered Whse. Pick Nos. SearchRegistered Whse. Pick Nos.NormalCode20Registered Whse_ Pick Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Registered Whse_ Pick Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Registered Whse_ Pick Nos_] = [No. Series].[Code]
10Registered Whse. Put-away Nos. SearchRegistered Whse. Put-away Nos.NormalCode20Registered Whse_ Put-away Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Registered Whse_ Put-away Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Registered Whse_ Put-away Nos_] = [No. Series].[Code]
13Require Receive SearchRequire ReceiveNormalBoolean4Require Receivetinyint
14Require Put-away SearchRequire Put-awayNormalBoolean4Require Put-awaytinyint
15Require Pick SearchRequire PickNormalBoolean4Require Picktinyint
16Require Shipment SearchRequire ShipmentNormalBoolean4Require Shipmenttinyint
17Last Whse. Posting Ref. No. SearchLast Whse. Posting Ref. No.NormalInteger4Last Whse_ Posting Ref_ No_int
18Receipt Posting Policy SearchReceipt Posting PolicyNormalOption4Receipt Posting Policyint
Available options are:
  • “Posting errors are not processed”
  • “Stop and show the first posting error”
19Shipment Posting Policy SearchShipment Posting PolicyNormalOption4Shipment Posting Policyint
Available options are:
  • “Posting errors are not processed”
  • “Stop and show the first posting error”
20Last Whse. Posting Ref. Seq. SearchLast Whse. Posting Ref. Seq.NormalCode40Last Whse_ Posting Ref_ Seq_nvarchar(80)
7301Posted Whse. Receipt Nos. SearchPosted Whse. Receipt Nos.NormalCode20Posted Whse_ Receipt Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Posted Whse_ Receipt Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Posted Whse_ Receipt Nos_] = [No. Series].[Code]
7303Posted Whse. Shipment Nos. SearchPosted Whse. Shipment Nos.NormalCode20Posted Whse_ Shipment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Posted Whse_ Shipment Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Posted Whse_ Shipment Nos_] = [No. Series].[Code]
7304Whse. Internal Put-away Nos. SearchWhse. Internal Put-away Nos.NormalCode20Whse_ Internal Put-away Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Internal Put-away Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Internal Put-away Nos_] = [No. Series].[Code]
7306Whse. Internal Pick Nos. SearchWhse. Internal Pick Nos.NormalCode20Whse_ Internal Pick Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Internal Pick Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Internal Pick Nos_] = [No. Series].[Code]
7308Whse. Movement Nos. SearchWhse. Movement Nos.NormalCode20Whse_ Movement Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Whse_ Movement Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Whse_ Movement Nos_] = [No. Series].[Code]
7309Registered Whse. Movement Nos. SearchRegistered Whse. Movement Nos.NormalCode20Registered Whse_ Movement Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Setup].[Registered Whse_ Movement Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Setup].[Registered Whse_ Movement Nos_] = [No. Series].[Code]
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 Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Setup].[$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 Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse Setup

Leave a Reply

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