Warehouse Entry

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

Table Type: Company

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

Table Number: 7312

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Journal Batch Name]
   ,[Line No_]
   ,[Registering Date]
   ,[Location Code]
   ,[Zone Code]
   ,[Bin Code]
   ,[Description]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Subline No_]
   ,[Source Document]
   ,[Source Code]
   ,[Reason Code]
   ,[No_ Series]
   ,[Bin Type Code]
   ,[Cubage]
   ,[Weight]
   ,[Journal Template Name]
   ,[Whse_ Document No_]
   ,[Whse_ Document Type]
   ,[Whse_ Document Line No_]
   ,[Entry Type]
   ,[Reference Document]
   ,[Reference No_]
   ,[User ID]
   ,[Variant Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Package No_]
   ,[Phys Invt Counting Period Code]
   ,[Phys Invt Counting Period Type]
   ,[Dedicated]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Warehouse Entry].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Warehouse Entry].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Warehouse Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Journal Batch Name Searchnvarchar(20)
4Line No_ Searchint
5Registering Date Searchdatetime
6Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Warehouse Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Entry].[Location Code] = [Location].[Code]
7Zone Code Searchnvarchar(20)
8Bin Code Searchnvarchar(40)
9Description Searchnvarchar(200)
10Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Warehouse Entry].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Warehouse Entry].[Item No_] = [Item].[No_]
11Quantity Searchdecimal(38,38)
12Qty_ (Base) Searchdecimal(38,38)
13Source Type Searchint
14Source Subtype Searchint
15Source No_ Searchnvarchar(40)
16Source Line No_ Searchint
17Source Subline No_ Searchint
18Source Document Searchint
19Source Code Searchnvarchar(20)
20Reason Code Searchnvarchar(20)
21No_ Series Searchnvarchar(40)
22Bin Type Code Searchnvarchar(20)
23Cubage Searchdecimal(38,38)
24Weight Searchdecimal(38,38)
25Journal Template Name Searchnvarchar(20)
26Whse_ Document No_ Searchnvarchar(40)
27Whse_ Document Type Searchint
28Whse_ Document Line No_ Searchint
29Entry Type Searchint
30Reference Document Searchint
31Reference No_ Searchnvarchar(40)
32User ID Searchnvarchar(100)
33Variant Code Searchnvarchar(20)
34Qty_ per Unit of Measure Searchdecimal(38,38)
35Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Warehouse Entry].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Warehouse Entry].[Unit of Measure Code] = [Unit of Measure].[Code]
36Serial No_ Searchnvarchar(100)
37Lot No_ Searchnvarchar(100)
38Warranty Date Searchdatetime
39Expiration Date Searchdatetime
40Package No_ Searchnvarchar(100)
41Phys Invt Counting Period Code Searchnvarchar(20)
42Phys Invt Counting Period Type Searchint
43Dedicated Searchtinyint
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warehouse Entry table

Leave a Reply

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