tableWarehouseofficial - Microsoftderived - from the source, no model text

Table 7311 "Warehouse Journal Line"

Base Application · Microsoft.Warehouse.Journal

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC251 events added
  4. BC261 procedures added
  5. BC27unchanged
  6. BC2839 fields changed
  7. BC29-30unchanged

Neighbourhood 32 connected objects and pages

Table 7300 "Zone" (relates to, 3 links)ZoneTable 7354 "Bin" (relates to, 2 links)BinTable 14 "Location" (relates to)LocationTable 230 "Source Code" (relates to)Source CodeTable 231 "Reason Code" (relates to)Table 27 "Item" (relates to)ItemTable 308 "No. Series" (relates to)Table 5401 "Item Variant" (relates to)Item VariantTable 5404 "Item Unit of Measure" (relates to)Item Unit of MeasureTable 7302 "Bin Content" (relates to)Bin ContentTable 7303 "Bin Type" (relates to)Table 7309 "Warehouse Journal Template" (relates to)Table 7310 "Warehouse Journal Batch" (relates to)Table 7381 "Phys. Invt. Counting Period" (relates to)Page 7319 "Warehouse Journal Lines" (pages and codeunits on it, 3 links)Warehouse Journal LinesCodeunit 7301 "Whse. Jnl.-Register Line" (pages and codeunits on it)Codeunit 7303 "Whse. Jnl.-Register" (pages and codeunits on it)Codeunit 7304 "Whse. Jnl.-Register Batch" (pages and codeunits on it)Codeunit 7309 "Whse. Jnl.-Register+Print" (pages and codeunits on it)Page 7324 "Whse. Item Journal" (pages and codeunits on it)Page 7326 "Whse. Phys. Invt. Journal" (pages and codeunits on it)Page 7365 "Whse. Reclassification Journal" (pages and codeunits on it)Codeunit 6516 "Package Management" (event subscribers, 6 links)Package ManagementCodeunit 20439 "Qlty. Item Tracking Mgmt." (event subscribers)Codeunit 7302 "WMS Management" (calls, 6 links)WMS ManagementCodeunit 6500 "Item Tracking Management" (calls, 5 links)Item Tracking ManagementCodeunit 5402 "Unit of Measure Management" (calls, 2 links)Unit of Measure ManagementCodeunit 5889 "Phys. Invt. Tracking Mgt." (calls)Page 456 "No. Series" (calls)Page 7329 "Whse. Journal Batches List" (calls)Table 7302 "Bin Content" (referenced by, 4 links)Bin ContentTable 7310 "Warehouse Journal Batch" (referenced by)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Warehouse.Journal · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Warehouse Journal Line
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Journal Template Name Δ BC28 Code[10] Specifies the name of the journal template, the basis of the journal batch, that the entries were posted from. TableRelation Table 7309 “Warehouse Journal Template” (Warehouse Journal Template)
2 Journal Batch Name Δ BC28 Code[10] Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from. TableRelation Table 7310 “Warehouse Journal Batch” (“Warehouse Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)))
3 Line No. Δ BC28 Integer Specifies the number of the warehouse journal line.
4 Registering Date Δ BC28 Date Specifies the date the line is registered.
5 Location Code Δ BC28 Code[10] Specifies the code of the location to which the journal line applies. TableRelation Table 14 “Location”
6 From Zone Code Δ BC28 Code[10] Specifies the code of the zone from which the item on the journal line is taken. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
7 From Bin Code Δ BC28 Code[20] Specifies the code of the bin from which the item on the journal line is taken. TableRelation Table 7302 “Bin Content” (if (“Phys. Inventory” = const(false), “Item No.” = filter(‘’), “From Zone Code” = filter(‘’)) “Bin Content”.“Bin Code” where(“Location Code” = field(“Location Code”)) else if (“Phys. Inventory” = const(false), “Item No.” = filter(<> ‘’), “From Zone Code” = filter(‘’)) “Bin Content”.“Bin Code” where(…)
8 Description Δ BC28 Text[100] Specifies the description of the item.
9 Item No. Δ BC28 Code[20] Specifies the number of the item on the journal line. TableRelation Table 27 “Item” (Item where(Type = const(Inventory)))
10 Quantity Δ BC28 Decimal Specifies the number of units of the item in the adjustment (positive or negative) or the reclassification.
11 Qty. (Base) Δ BC28 Decimal —
12 Qty. (Absolute) Δ BC28 Decimal —
13 Qty. (Absolute, Base) Δ BC28 Decimal Specifies the quantity expressed as an absolute (positive) number, in the base unit of measure. via Page 7319 “Warehouse Journal Lines”
14 Zone Code Δ BC28 Code[10] Specifies the zone code where the bin on this line is located. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
15 Bin Code Δ BC28 Code[20] Specifies the bin where the items are picked or put away. TableRelation Table 7354 “Bin” (if (“Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”)))
20 Source Type Integer — not editable
21 Source Subtype Option — OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable
22 Source No. Code[20] — not editable
23 Source Line No. Integer — not editable
24 Source Subline No. Integer — not editable
25 Source Document Enum “Warehouse Journal Source Document” — enum Enum 7311 “Warehouse Journal Source Document”; not editable
26 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code); not editable
27 To Zone Code Δ BC28 Code[10] Specifies the code of the zone to which the item on the journal line will be moved. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
28 To Bin Code Δ BC28 Code[20] Specifies the code of the bin to which the item on the journal line will be moved. TableRelation Table 7354 “Bin” (if (“To Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“To Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“To Zone Code”)))
29 Reason Code Δ BC28 Code[10] Specifies the reason code for the warehouse journal line. TableRelation Table 231 “Reason Code” (Reason Code)
33 Registering No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
35 From Bin Type Code Code[10] — TableRelation Table 7303 “Bin Type” (Bin Type)
40 Cubage Δ BC28 Decimal Specifies the total cubage of the items on the warehouse journal line. not editable
41 Weight Δ BC28 Decimal Specifies the weight of one item unit when measured in the specified unit of measure. not editable
50 Whse. Document No. Δ BC28 Code[20] Specifies the warehouse document number of the journal line.
51 Whse. Document Type Enum “Warehouse Journal Document Type” — enum Enum 5773 “Warehouse Journal Document Type”
52 Whse. Document Line No. Integer —
53 Qty. (Calculated) Δ BC28 Decimal Specifies the quantity of the bin item that is calculated when you use the function, Calculate Inventory, in the Whse. Physical Inventory Journal. via Page 7326 “Whse. Phys. Invt. Journal” not editable
54 Qty. (Phys. Inventory) Δ BC28 Decimal Specifies the quantity of items in the bin that you have counted. via Page 7326 “Whse. Phys. Invt. Journal”
55 Entry Type Δ BC28 Option Specifies the type of transaction that will be registered from the line. OptionCaption: Negative Adjmt.,Positive Adjmt.,Movement
56 Phys. Inventory Boolean — not editable
60 Reference Document Enum “Whse. Reference Document Type” — enum Enum 5779 “Whse. Reference Document Type”
61 Reference No. Code[20] —
67 User ID Δ BC28 Code[50] Specifies the ID of the user who posted the entry, to be used, for example, in the change log. TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
68 Qty. (Calculated) (Base) Δ BC28 Decimal Specifies the same as for the field in the Item Journal window. via Page 7326 “Whse. Phys. Invt. Journal” not editable
69 Qty. (Phys. Inventory) (Base) Δ BC28 Decimal Specifies the same as for the field in the Item Journal window. via Page 7326 “Whse. Phys. Invt. Journal”
5402 Variant Code Δ BC28 Code[10] Specifies the variant of the item on the line. TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
5404 Qty. per Unit of Measure Δ BC28 Decimal Specifies the number of base units of measure in the unit of measure specified for the item on the journal line. not editable
5407 Unit of Measure Code Δ BC28 Code[10] Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))
5408 Qty. Rounding Precision Δ BC28 Decimal — not editable
5409 Qty. Rounding Precision (Base) Δ BC28 Decimal — not editable
6500 Serial No. Δ BC28 Code[50] Specifies the same as for the field in the Item Journal window.
6501 Lot No. Δ BC28 Code[50] Specifies the same as for the field in the Item Journal window.
6502 Warranty Date Δ BC28 Date Specifies the last day of warranty for the item on the line.
6503 Expiration Date Δ BC28 Date Specifies the last date that the item on the line can be used.
6504 New Serial No. Code[50] —
6505 New Lot No. Code[50] —
6506 New Expiration Date Date —
6515 Package No. Δ BC28 Code[50] Specifies the same as for the field in the Item Journal window.
6516 New Package No. Code[50] —
7380 Phys Invt Counting Period Code Δ BC28 Code[10] Specifies a code for the physical inventory counting period, if the counting period functionality was used when the line was created. TableRelation Table 7381 “Phys. Invt. Counting Period” (Phys. Invt. Counting Period); not editable
7381 Phys Invt Counting Period Type Δ BC28 Option Specifies whether the physical inventory counting period was assigned to a stockkeeping unit or an item. OptionCaption: ,Item,SKU; not editable

Keys

  • Key1: Journal Template Name, Journal Batch Name, Location Code, Line No. (clustered)
  • Key2: Item No., Location Code, Entry Type, From Bin Type Code, Variant Code, Unit of Measure Code
  • Key3: Item No., From Bin Code, Location Code, Entry Type, Variant Code, Unit of Measure Code, Lot No., Serial No., Package No.
  • Key4: Item No., To Bin Code, Location Code, Variant Code, Unit of Measure Code, Lot No., Serial No., Package No.
  • Key5: To Bin Code, Location Code
  • Key6: Location Code, Item No., Variant Code
  • Key7: Location Code, Bin Code, Item No., Variant Code

Events published

  • OnAfterCheckTrackingIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterCopyTrackingFromItemLedgEntry(var WhseJnlLine: Record "Warehouse Journal Line"; ItemLedgEntry: Record "Item Ledger Entry") (integration)
  • OnAfterCopyTrackingFromItemTrackingSetupIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterCopyNewTrackingFromItemTrackingSetupIfRequired(var WhseJnlLine: Record "Warehouse Journal Line"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterCopyTrackingFromWhseActivityLine(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseActivityLine: Record "Warehouse Activity Line") (integration)
  • OnAfterCopyTrackingFromWhseEntry(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseEntry: Record "Warehouse Entry") (integration)
  • OnAfterOpenItemTrackingLines(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseItemTrackingLines: Page "Whse. Item Tracking Lines") (integration)
  • OnAfterOpenJnl(var WarehouseJournalLine: Record "Warehouse Journal Line"; CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]) (integration)
  • OnAfterSetupNewLine(var WarehouseJournalLine: Record "Warehouse Journal Line"; var LastWhseJnlLine: Record "Warehouse Journal Line"; WarehouseJournalTemplate: Record "Warehouse Journal Template") (integration)
  • OnAfterSetName(var RecWarehouseJournalLine: Record "Warehouse Journal Line"; var WarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnAfterSetTrackingFilterFromBinContent(var WarehouseJournalLine: Record "Warehouse Journal Line"; var BinContent: Record "Bin Content") (integration)
  • OnBeforeCheckBin(var WarehouseJournalLine: Record "Warehouse Journal Line"; LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean; var IsHandled: Boolean; CurrentFieldNo: Integer) (integration)
  • OnBeforeCheckIncreaseBin(WarehouseJournalLine: Record "Warehouse Journal Line"; BinCode: Code[20]; StockProposal: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeCheckName(var JnlBatchName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnBeforeCheckQtyPhysInventory(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnBeforeCheckSerialNoTrackedQuantity(var WarehouseJournalLine: Record "Warehouse Journal Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeCheckTemplateName(var JnlTemplateName: Code[10]; var JnlBatchName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnBeforeGetLocation(var Location: Record Location; LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnBeforeGetWhseJnlBatch(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseJnlBatch: Record "Warehouse Journal Batch"; var IsHandled: Boolean) (integration)
  • OnBeforeLookupBinCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnBeforeLookupFromBinCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnBeforeOpenItemTrackingLines(var WarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnBeforeOpenJnl(var WarehouseJournalLine: Record "Warehouse Journal Line"; var CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]) (integration)
  • OnBeforeSetItemFields(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean; xWarehouseJournalLine: Record "Warehouse Journal Line"; Item: Record Item) (integration)
  • OnBeforeTemplateSelectionFromBatch(var WarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseJournalBatch: Record "Warehouse Journal Batch") (integration)
  • OnBeforeValidateQtyBase(var WarehouseJournalLine: Record "Warehouse Journal Line"; xWarehouseJournalLine: Record "Warehouse Journal Line"; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnCheckBinOnBeforeCheckOutboundBin(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnLookupNameOnBeforeSetName(var WarehouseJournalLine: Record "Warehouse Journal Line"; WhseJnlBatch: Record "Warehouse Journal Batch") (integration)
  • OnOpenItemTrackingLinesOnBeforeSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line"; WarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnSetUpNewLineOnAfterWhseJnlLineSetFilters(var RecWarehouseJournalLine: Record "Warehouse Journal Line"; WarehouseJournalLine: Record "Warehouse Journal Line"; LastWarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnTemplateSelectionOnAfterSetFilters(var WarehouseJournalLine: Record "Warehouse Journal Line"; var WhseJnlTemplate: Record "Warehouse Journal Template"; OpenFromBatch: Boolean) (integration)
  • OnValidateQuantityOnAfterCalcBaseQty(var WarehouseJournalLine: Record "Warehouse Journal Line"; xWarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnValidateUnitOfMeasureCodeOnBeforeValidateQuantity(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnValidateToBinCodeOnBeforeSetToZoneCode(var WarehouseJournalLine: Record "Warehouse Journal Line"; var Bin: Record Bin) (integration)
  • OnAfterIsFieldEditable(var WarehouseJournalLine: Record "Warehouse Journal Line"; FieldId: Integer; var IsEditable: Boolean) (integration)
  • OnAfterValidateQtyPhysInventoryBase(var WarehouseJournalLine: Record "Warehouse Journal Line"; PhysInvtEntered: Boolean) (integration)
  • OnBeforeCalcBaseQty(var WarehouseJournalLine: Record "Warehouse Journal Line"; var Qty: Decimal; FromFieldName: Text; ToFieldName: Text) (integration)
  • OnValidateQuantityOnBeforeGetWhseJnlTemplate(var WarehouseJournalLine: Record "Warehouse Journal Line"; var IsHandled: Boolean) (integration)
  • OnBeforeGetBinType(LocationCode: Code[10]; BinCode: Code[20]; var BinTypeCode: Code[10]; var IsHandled: Boolean) + BC25 (integration)

Procedures

  • GetItem(ItemNo: Code[20]; var ItemDescription: Text[100])
  • SetUpNewLine(LastWhseJnlLine: Record "Warehouse Journal Line")
  • SetUpAdjustmentBin()
  • CalcReservEntryQuantity(): Decimal
  • EmptyLine(): Boolean
  • CheckBin(CalledByPosting: Boolean) (internal)
  • GetBinType(LocationCode: Code[10]; BinCode: Code[20]): Code[10]
  • TemplateSelection(PageID: Integer; PageTemplate: Enum "Warehouse Journal Template Type"; var WhseJnlLine: Record "Warehouse Journal Line"): Boolean
  • TemplateSelectionFromBatch(var WhseJnlBatch: Record "Warehouse Journal Batch")
  • OpenJnl(var CurrentJnlBatchName: Code[10]; var CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
  • CheckTemplateName(CurrentJnlTemplateName: Code[10]; var CurrentLocationCode: Code[10]; var CurrentJnlBatchName: Code[10])
  • CheckName(CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
  • SetName(CurrentJnlBatchName: Code[10]; CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
  • LookupName(var CurrentJnlBatchName: Code[10]; var CurrentLocationCode: Code[10]; var WhseJnlLine: Record "Warehouse Journal Line")
  • OpenItemTrackingLines()
  • ItemTrackingReclass(TemplateName: Code[10]; BatchName: Code[10]; LocationCode: Code[10]; LineNo: Integer): Boolean
  • LookupItemTracking(var WhseItemTrackingSetup: Record "Item Tracking Setup")
  • IsReclass(CurrentJnlTemplateName: Code[10]): Boolean
  • SetProposal(NewValue: Boolean)
  • IsOpenedFromBatch(): Boolean
  • CheckTrackingIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • CopyTrackingFromItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry")
  • CopyTrackingFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • CopyNewTrackingFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • CopyTrackingFromWhseActivityLine(WhseActivityLine: Record "Warehouse Activity Line")
  • CopyTrackingFromWhseEntry(WhseEntry: Record "Warehouse Entry")
  • IsQtyPhysInventoryBaseEditable(): Boolean
  • SetSource(SourceType: Integer; SourceSubtype: Integer; SourceNo: Code[20]; SourceLineNo: Integer; SourceSublineNo: Integer)
  • SetTrackingFilterFromBinContent(var BinContent: Record "Bin Content")
  • SetWhseDocument(DocType: Enum "Warehouse Journal Document Type"; DocNo: Code[20]; DocLineNo: Integer)
  • InitExpirationDate()
  • CheckExpirationDateExists(): Boolean

Plus 24 local procedures.

Triggers

OnDelete, OnInsert, OnModify

Relations

Referenced by

5 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Warehouse Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources