Warehouse 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
   [timestamp]
   ,[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 columns in Warehouse Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Whse_ Receipt Nos_ Searchnvarchar(40)
4Whse_ Put-away Nos_ Searchnvarchar(40)
5Whse_ Pick Nos_ Searchnvarchar(40)
6Whse_ Ship Nos_ Searchnvarchar(40)
7Registered Whse_ Pick Nos_ Searchnvarchar(40)
8Registered Whse_ Put-away Nos_ Searchnvarchar(40)
9Require Receive Searchtinyint
10Require Put-away Searchtinyint
11Require Pick Searchtinyint
12Require Shipment Searchtinyint
13Last Whse_ Posting Ref_ No_ Searchint
14Receipt Posting Policy Searchint
15Shipment Posting Policy Searchint
16Last Whse_ Posting Ref_ Seq_ Searchnvarchar(80)
17Posted Whse_ Receipt Nos_ Searchnvarchar(40)
18Posted Whse_ Shipment Nos_ Searchnvarchar(40)
19Whse_ Internal Put-away Nos_ Searchnvarchar(40)
20Whse_ Internal Pick Nos_ Searchnvarchar(40)
21Whse_ Movement Nos_ Searchnvarchar(40)
22Registered Whse_ Movement Nos_ Searchnvarchar(40)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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