tableWarehouseofficial - Microsoftderived - from the source, no model text

Table 7312 "Warehouse Entry"

Base Application · Microsoft.Warehouse.Ledger

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC253 procedures added, 2 fields added
  4. BC263 procedures changed
  5. BC271 procedures changed
  6. BC2833 fields changed
  7. BC29unchanged
  8. BC301 procedures removed

Neighbourhood 19 connected objects and pages

Table 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)No. SeriesTable 5401 "Item Variant" (relates to)Item VariantTable 5404 "Item Unit of Measure" (relates to)Item Unit of MeasureTable 7300 "Zone" (relates to)Table 7303 "Bin Type" (relates to)Bin TypeTable 7313 "Warehouse Register" (relates to)Warehouse RegisterTable 7354 "Bin" (relates to)Table 7381 "Phys. Invt. Counting Period" (relates to)Page 7318 "Warehouse Entries" (pages and codeunits on it, 3 links)Warehouse EntriesCodeunit 6516 "Package Management" (event subscribers, 15 links)Package ManagementCodeunit 20 "Posting Preview Event Handler" (event subscribers, 2 links)Posting Preview Event HandlerCodeunit 9500 "Sequence No. Mgt." (calls, 3 links)Sequence No. Mgt.Codeunit 703 "Find Record Management" (calls)Table 7302 "Bin Content" (referenced by, 2 links)Bin ContentTable 7313 "Warehouse Register" (referenced by, 2 links)Warehouse Register

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.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Warehouse Entry
DataClassification CustomerContent
Permissions TableData “Warehouse Entry” = ri

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 Entry No. Δ BC28 Integer Specifies the number of the entry, as assigned from the specified number series when the entry was created.
2 Journal Batch Name Δ BC28 Code[10] Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from.
3 Line No. Δ BC28 Integer Specifies the line number of the warehouse document line or warehouse journal line that was registered.
4 Registering Date Δ BC28 Date Specifies the date the entry was registered.
5 Location Code Δ BC28 Code[10] Specifies the code of the location to which the entry is linked. TableRelation Table 14 “Location”
6 Zone Code Δ BC28 Code[10] Specifies the code of the zone to which the entry is linked. TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
7 Bin Code Δ BC28 Code[20] Specifies the bin where the items are picked or put away. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
8 Description Δ BC28 Text[100] Specifies a description of the warehouse entry.
9 Item No. Δ BC28 Code[20] Specifies the number of the item in the entry. TableRelation Table 27 “Item”
10 Quantity Δ BC28 Decimal Specifies the number of units of the item in the warehouse entry.
11 Qty. (Base) Δ BC28 Decimal Specifies the quantity of the entry, in the base unit of measure. via Page 7318 “Warehouse Entries”
12 Warehouse Register No. + BC25 Integer — TableRelation Table 7313 “Warehouse Register” (Warehouse Register); not editable
13 SIFT Bucket No. + BC25 Integer Specifies an automatically generated number that is used by the system to enable better concurrency. not editable
20 Source Type Δ BC28 Integer Specifies the table number that is the source of the entry line, for example, 39 for a purchase line, 37 for a sales line.
21 Source Subtype Δ BC28 Option Specifies the source subtype of the document to which the warehouse entry line relates. OptionCaption: 0,1,2,3,4,5,6,7,8,9,10
22 Source No. Δ BC28 Code[20] Specifies the number of the source document that the entry originates from.
23 Source Line No. Δ BC28 Integer Specifies the line number of the source document that the entry originates from.
24 Source Subline No. Δ BC28 Integer Specifies the source subline number of the document from which the entry originates.
25 Source Document Δ BC28 Enum “Warehouse Journal Source Document” Specifies the type of document that the line relates to. enum Enum 7311 “Warehouse Journal Source Document”
26 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code)
29 Reason Code Δ BC28 Code[10] Specifies the reason code, a supplementary source code that enables you to trace the entry. TableRelation Table 231 “Reason Code” (Reason Code)
33 No. Series Δ BC28 Code[20] Specifies the number series from which entry or record numbers are assigned to new entries or records. TableRelation Table 308 “No. Series” (No. Series)
35 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 entry line.
41 Weight Δ BC28 Decimal Specifies the weight of one item unit when measured in the specified unit of measure.
45 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.
50 Whse. Document No. Δ BC28 Code[20] Specifies the number of the warehouse document from which this entry originated.
51 Whse. Document Type Δ BC28 Enum “Warehouse Journal Document Type” Specifies the type of the document from which this entry originated. enum Enum 5773 “Warehouse Journal Document Type”
52 Whse. Document Line No. Integer —
55 Entry Type Δ BC28 Option Specifies the entry type, which can be Negative Adjmt., Positive Adjmt., or Movement. OptionCaption: Negative Adjmt.,Positive Adjmt.,Movement
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
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 that are in the unit of measure specified for the item on the line.
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.”)))
6500 Serial No. Δ BC28 Code[50] Specifies the serial number.
6501 Lot No. Δ BC28 Code[50] Specifies the lot number assigned to the warehouse entry.
6502 Warranty Date Date —
6503 Expiration Date Δ BC28 Date Specifies the expiration date of the serial number.
6515 Package No. Δ BC28 Code[50] Specifies the package number assigned to the warehouse entry.
7380 Phys Invt Counting Period Code Code[10] — TableRelation Table 7381 “Phys. Invt. Counting Period” (Phys. Invt. Counting Period); not editable
7381 Phys Invt Counting Period Type Option — OptionCaption: ,Item,SKU; not editable
7382 Dedicated Boolean — not editable

Keys

  • Key1: Entry No. (clustered)
  • Key2: Reference No., Registering Date
  • Key3: Source Type, Source Subtype, Source No., Source Line No., Source Subline No., Source Document, Bin Code
  • Key4: Serial No., Item No., Variant Code, Location Code, Bin Code
  • Key5: Item No., Bin Code, Location Code, Variant Code, Unit of Measure Code, Lot No., Serial No., Entry Type, Dedicated, Package No., Bin Type Code, SIFT Bucket No.
  • Key7: Bin Code, Location Code, Item No., SIFT Bucket No.
  • Key8: Location Code, Item No., Variant Code, Zone Code, Bin Code, Lot No., SIFT Bucket No.
  • key9: Warehouse Register No.

Events published

  • OnAfterClearTrackingFilter(var WarehouseEntry: Record "Warehouse Entry") (integration)
  • OnAfterCopyTrackingFromWhseEntry(var WarehouseEntry: Record "Warehouse Entry"; FromWarehouseEntry: Record "Warehouse Entry") (integration)
  • OnAfterCopyTrackingFromWhseJnlLine(var WarehouseEntry: Record "Warehouse Entry"; WarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnAfterCopyTrackingFromNewWhseJnlLine(var WarehouseEntry: Record "Warehouse Entry"; WarehouseJournalLine: Record "Warehouse Journal Line") (integration)
  • OnAfterSetTrackingFilterFromBinContent(var WarehouseEntry: Record "Warehouse Entry"; var BinContent: Record "Bin Content") (integration)
  • OnAfterSetTrackingFilterFromBinContentBuffer(var WarehouseEntry: Record "Warehouse Entry"; BinContentBuffer: Record "Bin Content Buffer") (integration)
  • OnAfterSetTrackingFilterFromReservEntryIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; ReservEntry: Record "Reservation Entry") (integration)
  • OnAfterSetTrackingFilterFromItemFilters(var WarehouseEntry: Record "Warehouse Entry"; var Item: Record Item) (integration)
  • OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterSetTrackingFilterFromItemTrackingSetupIfRequired(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterSetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank(var WarehouseEntry: Record "Warehouse Entry"; WhseItemTrackingSetup: Record "Item Tracking Setup") (integration)
  • OnAfterSetTrackingFilterFromWhseEntry(var WhseEntry: Record "Warehouse Entry"; FromWhseEntry: Record "Warehouse Entry") (integration)
  • OnAfterSetTrackingFilterIfNotBlank(var WhseEntry: Record "Warehouse Entry") (integration)
  • OnAfterTrackingExists(WhseEntry: Record "Warehouse Entry"; var IsTrackingExists: Boolean) (integration)

Trigger event subscribers

Procedures

  • InsertRecord(UseLegacyPosting: Boolean) + BC25 + BC25 Δ BC26 Δ BC27 − BC30 (obsolete 27.0: This function is deprecated. Concurrent warehouse posting is always on.)
  • InsertRecord() + BC25 + BC25 Δ BC26 Δ BC27 − BC30
  • GetNextEntryNo(): Integer + BC25 Δ BC26
  • GetLastEntryNo(): Integer Δ BC26
  • ClearTrackingFilter()
  • CopyTrackingFromWhseEntry(WhseEntry: Record "Warehouse Entry")
  • CopyTrackingFromWhseJnlLine(WhseJnlLine: Record "Warehouse Journal Line")
  • CopyTrackingFromNewWhseJnlLine(WhseJnlLine: Record "Warehouse Journal Line")
  • SetCalculationFilters(ItemNo: Code[20]; LocationCode: Code[10]; VariantCode: Code[10]; WhseItemTrackingSetup: Record "Item Tracking Setup"; ExcludeDedicatedBinContent: Boolean)
  • SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)
  • SetTrackingFilterIfNotBlank()
  • SetTrackingFilterFromBinContent(var BinContent: Record "Bin Content")
  • SetTrackingFilterFromBinContentBuffer(BinContentBuffer: Record "Bin Content Buffer")
  • SetTrackingFilterFromItemTrackingSetupIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • SetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • SetTrackingFilterFromItemTrackingSetupIfRequiredIfNotBlank(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • SetTrackingFilterFromWhseEntry(FromWhseEntry: Record "Warehouse Entry")
  • SetTrackingFilterFromReservEntryIfNotBlank(ReservEntry: Record "Reservation Entry")
  • SetTrackingFIlterFromItemFilters(var Item: Record Item)
  • SetTrackingFilterFromItemTrackingSetupIfNotBlank(WhseItemTrackingSetup: Record "Item Tracking Setup")
  • TrackingExists(): Boolean
  • Lock()
  • SetTrackingFilterFromWhseEntryForSerialOrLotTrackedItem(FromWhseEntry: Record "Warehouse Entry")

Triggers

OnInsert

Relations

Referenced by

4 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.

Recent changes

Deprecations

  • procedure InsertRecord: Pending 27.0 (#if not CLEAN27), “This function is deprecated. Concurrent warehouse posting is always on.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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 Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources