Warehouse Receipt Header

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

Table Type: Company

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

Table Number: 7316

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warehouse Receipt 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]
   ,[Sorting Method]
   ,[No_ Series]
   ,[Zone Code]
   ,[Bin Code]
   ,[Document Status]
   ,[Posting Date]
   ,[Vendor Shipment No_]
   ,[Cross-Dock Zone Code]
   ,[Cross-Dock Bin Code]
   ,[Create Posted Header]
   ,[Receiving No_]
   ,[Last Receiving No_]
   ,[Receiving No_ Series]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Receipt 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_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Receipt Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Warehouse Receipt Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Warehouse Receipt Header].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Receipt Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Receipt Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Receipt 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
       [Warehouse Receipt Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Receipt 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
       [Warehouse Receipt Header].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Warehouse Receipt Header].[Assigned User ID] = [User Setup].[User ID]
4Assignment Date SearchAssignment DateNormalDate4Assignment Datedatetime
5Assignment Time SearchAssignment TimeNormalTime4Assignment Timedatetime
6Sorting Method SearchSorting MethodNormalOption4Sorting Methodint
Available options are:
  • “None”
  • “Item”
  • “Document”
  • “Shelf or Bin”
  • “Due Date”
  • “Ship-to”
7No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Receipt Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Receipt Header].[No_ Series] = [No. Series].[Code]
8Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
9Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Warehouse Receipt Header].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Warehouse Receipt Header].[Bin Code] = [Bin].[Code]
10Document Status SearchDocument StatusNormalOption4Document Statusint
Available options are:
  • ” “
  • “Partially Received”
  • “Completely Received”
11Comment SearchCommentFlowFieldBoolean4
12Posting Date SearchPosting DateNormalDate4Posting Datedatetime
13Vendor Shipment No. SearchVendor Shipment No.NormalCode35Vendor Shipment No_nvarchar(70)
16Cross-Dock Zone Code SearchCross-Dock Zone CodeNormalCode10Cross-Dock Zone Codenvarchar(20)
17Cross-Dock Bin Code SearchCross-Dock Bin CodeNormalCode20Cross-Dock Bin Codenvarchar(40)
50Create Posted Header SearchCreate Posted HeaderNormalBoolean4Create Posted Headertinyint
51Receiving No. SearchReceiving No.NormalCode20Receiving No_nvarchar(40)
62Last Receiving No. SearchLast Receiving No.NormalCode20Last Receiving No_nvarchar(40)
Key to join to the Posted Whse. Receipt Header table.

Show/hide example query

SELECT
       [Warehouse Receipt Header].[Last Receiving No_]
       ,[Posted Whse. Receipt Header].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Posted Whse_ Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Header]
              ON
                     [Warehouse Receipt Header].[Last Receiving No_] = [Posted Whse. Receipt Header].[No_]
63Receiving No. Series SearchReceiving No. SeriesNormalCode20Receiving No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Receipt Header].[Receiving No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Receipt Header].[Receiving No_ Series] = [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 Receipt Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Receipt 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
       [Warehouse Receipt Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Receipt Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Receipt Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Receipt Header table

Leave a Reply

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