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
   [timestamp]
   ,[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]

Show/hide columns in Warehouse Receipt Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Location Code Searchnvarchar(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]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7Sorting Method Searchint
8No_ Series Searchnvarchar(40)
9Zone Code Searchnvarchar(20)
10Bin Code Searchnvarchar(40)
11Document Status Searchint
12Posting Date Searchdatetime
13Vendor Shipment No_ Searchnvarchar(70)
14Cross-Dock Zone Code Searchnvarchar(20)
15Cross-Dock Bin Code Searchnvarchar(40)
16Create Posted Header Searchtinyint
17Receiving No_ Searchnvarchar(40)
18Last Receiving No_ Searchnvarchar(40)
19Receiving No_ Series Searchnvarchar(40)
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warehouse Receipt Header table

Leave a Reply

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