Whse_ Put-away Request

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

Table Type: Company

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

Table Number: 7324

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_ Put-away Request can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Whse_ Put-away Request$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Location Code]
   ,[Zone Code]
   ,[Bin Code]
   ,[Completely Put Away]
   ,[Status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Whse_ Put-away 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_ Put-away Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Put-away Request]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse_ Put-away Request].[Location Code] = [Location].[Code]

Show/hide columns in Whse_ Put-away Request table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse_ Put-away Request].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Put-away Request$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Put-away Request]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse_ Put-away Request].[Location Code] = [Location].[Code]
5Zone Code Searchnvarchar(20)
6Bin Code Searchnvarchar(40)
7Completely Put Away Searchtinyint
8Status Searchint
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Whse_ Put-away Request table

Leave a Reply

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