Warehouse Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse 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

   [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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Warehouse Entry].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Warehouse Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Warehouse Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
      ON
         [Warehouse Entry].[Bin Type Code] = [Bin Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Warehouse Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Warehouse Entry].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Line No. SearchLine No.NormalInteger4Line No_int
4Registering Date SearchRegistering DateNormalDate4Registering Datedatetime
5Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
6Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
7Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Warehouse Entry].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Warehouse Entry].[Bin Code] = [Bin].[Code]
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Warehouse Entry].[Item No_] = [Item].[No_]
10Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
11Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
20Source Type SearchSource TypeNormalInteger4Source Typeint
21Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
22Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
23Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
24Source Subline No. SearchSource Subline No.NormalInteger4Source Subline No_int
25Source Document SearchSource DocumentNormalOption4Source Documentint
Available options are:
  • “”
  • “S. Order”
  • “S. Invoice”
  • “S. Credit Memo”
  • “S. Return Order”
  • “P. Order”
  • “P. Invoice”
  • “P. Credit Memo”
  • “P. Return Order”
  • “Inb. Transfer”
  • “Outb. Transfer”
  • “Prod. Consumption”
  • “Item Jnl.”
  • “Phys. Invt. Jnl.”
  • “Reclass. Jnl.”
  • “Consumption Jnl.”
  • “Output Jnl.”
  • “BOM Jnl.”
  • “Serv. Order”
  • “Job Jnl.”
  • “Assembly Consumption”
  • “Assembly Order”
  • “Job Usage”
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Warehouse Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Warehouse Entry].[Source Code] = [Source Code].[Code]
29Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Warehouse Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Warehouse Entry].[Reason Code] = [Reason Code].[Code]
33No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Entry].[No_ Series] = [No. Series].[Code]
35Bin Type Code SearchBin Type CodeNormalCode10Bin Type Codenvarchar(20)
Key to join to the Bin Type table.

Show/hide example query

SELECT
       [Warehouse Entry].[Bin Type Code]
       ,[Bin Type].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
              ON
                     [Warehouse Entry].[Bin Type Code] = [Bin Type].[Code]
40Cubage SearchCubageNormalDecimal12Cubagedecimal(38,38)
41Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
45Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
50Whse. Document No. SearchWhse. Document No.NormalCode20Whse_ Document No_nvarchar(40)
51Whse. Document Type SearchWhse. Document TypeNormalOption4Whse_ Document Typeint
Available options are:
  • “Whse. Journal”
  • “Receipt”
  • “Shipment”
  • “Internal Put-away”
  • “Internal Pick”
  • “Production”
  • “Whse. Phys. Inventory”
  • ” “
  • “Assembly”
  • “Job”
52Whse. Document Line No. SearchWhse. Document Line No.NormalInteger4Whse_ Document Line No_int
55Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Negative Adjmt.”
  • “Positive Adjmt.”
  • “Movement”
60Reference Document SearchReference DocumentNormalOption4Reference Documentint
Available options are:
  • ” “
  • “Posted Rcpt.”
  • “Posted P. Inv.”
  • “Posted Rtrn. Rcpt.”
  • “Posted P. Cr. Memo”
  • “Posted Shipment”
  • “Posted S. Inv.”
  • “Posted Rtrn. Shipment”
  • “Posted S. Cr. Memo”
  • “Posted T. Receipt”
  • “Posted T. Shipment”
  • “Item Journal”
  • “Prod.”
  • “Put-away”
  • “Pick”
  • “Movement”
  • “BOM Journal”
  • “Job Journal”
  • “Assembly”
61Reference No. SearchReference No.NormalCode20Reference No_nvarchar(40)
67User ID SearchUser IDNormalCode50User IDnvarchar(100)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Warehouse Entry].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Warehouse Entry].[Variant Code] = [Item Variant].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
6500Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6502Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
6503Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(20)
Key to join to the Phys. Invt. Counting Period table.

Show/hide example query

SELECT
       [Warehouse Entry].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Warehouse Entry].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381Phys Invt Counting Period Type SearchPhys Invt Counting Period TypeNormalOption4Phys Invt Counting Period Typeint
Available options are:
  • ” “
  • “Item”
  • “SKU”
7382Dedicated SearchDedicatedNormalBoolean4Dedicatedtinyint
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 Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Entry].[$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 Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Entry table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesWWarehouse Entry

Leave a Reply

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