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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Primary Key  | nvarchar(20) |
| 3 | Whse_ Receipt Nos_ | nvarchar(40) |
| 4 | Whse_ Put-away Nos_ | nvarchar(40) |
| 5 | Whse_ Pick Nos_ | nvarchar(40) |
| 6 | Whse_ Ship Nos_ | nvarchar(40) |
| 7 | Registered Whse_ Pick Nos_ | nvarchar(40) |
| 8 | Registered Whse_ Put-away Nos_ | nvarchar(40) |
| 9 | Require Receive | tinyint |
| 10 | Require Put-away | tinyint |
| 11 | Require Pick | tinyint |
| 12 | Require Shipment | tinyint |
| 13 | Last Whse_ Posting Ref_ No_ | int |
| 14 | Receipt Posting Policy | int |
| 15 | Shipment Posting Policy | int |
| 16 | Last Whse_ Posting Ref_ Seq_ | nvarchar(80) |
| 17 | Posted Whse_ Receipt Nos_ | nvarchar(40) |
| 18 | Posted Whse_ Shipment Nos_ | nvarchar(40) |
| 19 | Whse_ Internal Put-away Nos_ | nvarchar(40) |
| 20 | Whse_ Internal Pick Nos_ | nvarchar(40) |
| 21 | Whse_ Movement Nos_ | nvarchar(40) |
| 22 | Registered Whse_ Movement Nos_ | nvarchar(40) |
| 23 | $systemId | uniqueidentifier |
| 24 | $systemCreatedAt | datetime |
| 25 | $systemCreatedBy | uniqueidentifier |
| 26 | $systemModifiedAt | datetime |
| 27 | $systemModifiedBy | uniqueidentifier |