Whse. Internal Put-away Header

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

Table Type: Company

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

Table Number: 7331

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. Internal Put-away Header can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Location Code]
   ,[Assigned User ID]
   ,[Assignment Date]
   ,[Assignment Time]
   ,[No_ Series]
   ,[From Bin Code]
   ,[From Zone Code]
   ,[Due Date]
   ,[Document Status]
   ,[Sorting Method]
   ,[Status]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Whse_ Internal Put-away Header$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_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse. Internal Put-away Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Whse. Internal Put-away Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Internal Put-away Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Internal Put-away Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse. Internal Put-away Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse. Internal Put-away Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse. Internal Put-away Header].[Location Code] = [Location].[Code]
3Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Whse. Internal Put-away Header].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Whse. Internal Put-away Header].[Assigned User ID] = [User Setup].[User ID]
4Assignment Date SearchAssignment DateNormalDate4Assignment Datedatetime
5Assignment Time SearchAssignment TimeNormalTime4Assignment Timedatetime
6No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Whse. Internal Put-away Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Whse. Internal Put-away Header].[No_ Series] = [No. Series].[Code]
7Comment SearchCommentFlowFieldBoolean4
8From Bin Code SearchFrom Bin CodeNormalCode20From Bin Codenvarchar(40)
9From Zone Code SearchFrom Zone CodeNormalCode10From Zone Codenvarchar(20)
10Due Date SearchDue DateNormalDate4Due Datedatetime
11Document Status SearchDocument StatusNormalOption4Document Statusint
Available options are:
  • ” “
  • “Partially Put Away”
  • “Completely Put Away”
12Sorting Method SearchSorting MethodNormalOption4Sorting Methodint
Available options are:
  • “None”
  • “Item”
  • “Shelf or Bin”
  • “Due Date”
13Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
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
       [Whse. Internal Put-away Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Internal Put-away Header].[$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
       [Whse. Internal Put-away Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Internal Put-away Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Internal Put-away Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Internal Put-away Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Whse. Internal Put-away Header table

Leave a Reply

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