Warehouse Journal Line

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

Table Type: Company

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

Table Number: 7311

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

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

Show/hide columns in Warehouse Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name Primary Key SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Registering Date SearchRegistering DateNormalDate4Registering Datedatetime
5Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Warehouse Journal Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Journal Line].[Location Code] = [Location].[Code]
6From Zone Code SearchFrom Zone CodeNormalCode10From Zone Codenvarchar(20)
7From Bin Code SearchFrom Bin CodeNormalCode20From Bin Codenvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Warehouse Journal Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Warehouse Journal Line].[Item No_] = [Item].[No_]
10Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
11Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
12Qty. (Absolute) SearchQty. (Absolute)NormalDecimal12Qty_ (Absolute)decimal(38,38)
13Qty. (Absolute, Base) SearchQty. (Absolute, Base)NormalDecimal12Qty_ (Absolute, Base)decimal(38,38)
14Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
15Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Warehouse Journal Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Warehouse Journal Line].[Bin Code] = [Bin].[Code]
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 Journal Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Warehouse Journal Line].[Source Code] = [Source Code].[Code]
27To Zone Code SearchTo Zone CodeNormalCode10To Zone Codenvarchar(20)
28To Bin Code SearchTo Bin CodeNormalCode20To Bin Codenvarchar(40)
29Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Warehouse Journal Line].[From Bin Type Code]
       ,[Bin Type].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
              ON
                     [Warehouse Journal Line].[From Bin Type Code] = [Bin Type].[Code]
40Cubage SearchCubageNormalDecimal12Cubagedecimal(38,38)
41Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
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
53Qty. (Calculated) SearchQty. (Calculated)NormalDecimal12Qty_ (Calculated)decimal(38,38)
54Qty. (Phys. Inventory) SearchQty. (Phys. Inventory)NormalDecimal12Qty_ (Phys_ Inventory)decimal(38,38)
55Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • “Negative Adjmt.”
  • “Positive Adjmt.”
  • “Movement”
56Phys. Inventory SearchPhys. InventoryNormalBoolean4Phys_ Inventorytinyint
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)
68Qty. (Calculated) (Base) SearchQty. (Calculated) (Base)NormalDecimal12Qty_ (Calculated) (Base)decimal(38,38)
69Qty. (Phys. Inventory) (Base) SearchQty. (Phys. Inventory) (Base)NormalDecimal12Qty_ (Phys_ Inventory) (Base)decimal(38,38)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Warehouse Journal Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Warehouse Journal Line].[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)
5408Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5409Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
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
6504New Serial No. SearchNew Serial No.NormalCode50New Serial No_nvarchar(100)
6505New Lot No. SearchNew Lot No.NormalCode50New Lot No_nvarchar(100)
6506New Expiration Date SearchNew Expiration DateNormalDate4New Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6516New Package No. SearchNew Package No.NormalCode50New Package 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 Journal Line].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Warehouse Journal Line].[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”
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 Journal Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Journal Line].[$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 Journal Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Journal Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Journal Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Journal Line table

Leave a Reply

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