BC Observatoryunofficial, made by waldo
tableInventoryofficial - Microsoftderived - from the source, no model text

Table 520 "Availability Info. Buffer"

Base Application · Microsoft.Inventory.Availability

Open in Claude520.mdSource on GitHub

Across versions

  1. BC23present
  2. BC241 fields changed
  3. BC2515 procedures removed, 4 events added
  4. BC261 events added
  5. BC27unchanged
  6. BC2825 fields changed
  7. BC29-30unchanged

Neighbourhood 15 connected objects and pages

Table 337 "Reservation Entry" (relates to, 15 links)Reservation EntryTable 6505 "Lot No. Information" (relates to, 3 links)Lot No. InformationTable 14 "Location" (relates to)LocationTable 27 "Item" (relates to)ItemTable 32 "Item Ledger Entry" (relates to)Item Ledger EntryTable 5401 "Item Variant" (relates to)Item VariantPage 514 "Item Avail. by Lot No. Lines" (pages and codeunits on it)Item Avail. by Lot No. LinesTable extension 20404 "Qlty. Avail. Info. Buffer" (extended by)Qlty. Avail. Info. BufferCodeunit 99000872 "Sales Availability Mgt." (event subscribers, 4 links)Sales Availability Mgt.Codeunit 99000875 "Prod. Order Availability Mgt." (event subscribers, 4 links)Prod. Order Availability Mgt.Codeunit 99000973 "Purch. Availability Mgt." (event subscribers, 4 links)Purch. Availability Mgt.Codeunit 99000874 "Assembly Availability Mgt." (event subscribers, 3 links)Assembly Availability Mgt.Codeunit 99000876 "Transfer Availability Mgt." (event subscribers, 3 links)Transfer Availability Mgt.Codeunit 99000871 "Job Planning Availability Mgt." (event subscribers, 2 links)Codeunit 6452 "Serv. Availability Mgt." (event subscribers)Serv. Availability Mgt.

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.Inventory.Availability · captioned “Availability Information Buffer” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Availability Information Buffer
TableType Temporary
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 Item No. Code[20] — TableRelation Table 27 “Item”; NotBlank
3 Lot No. Δ BC28 Code[50] Specifies a location code for the warehouse or distribution center where your items are handled and stored before being sold.
4 Serial No. Code[50] —
5 Package No. Code[50] —
6 Expiration Date Δ BC28 Date Specifies expiration date for the specified lot.
7 Quality Δ BC28 Option Specifies the test quality of the specified lot. FlowField: lookup(“Lot No. Information”.“Test Quality” where(“Item No.” = field(“Item No.”), “Lot No.” = field(“Lot No.”))); OptionCaption: ,Good,Average,Bad
8 Certificate Number Δ BC28 Code[20] Specifies the certificate number of the specified lot. FlowField: lookup(“Lot No. Information”.“Certificate Number” where(“Item No.” = field(“Item No.”), “Lot No.” = field(“Lot No.”)))
9 Blocked Boolean — FlowField: lookup(“Lot No. Information”.Blocked where(“Item No.” = field(“Item No.”), “Lot No.” = field(“Lot No.”)))
20 Inventory Δ BC28 Decimal — FlowField: sum(“Item Ledger Entry”.“Remaining Quantity” where(“Item No.” = field(“Item No.”), Open = const(true), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant Code” = field(“Variant Code Filter”))); not editable
21 Date Filter Date — FlowFilter
23 Variant Code Filter Code[10] — TableRelation Table 5401 “Item Variant” (Item Variant); FlowFilter
24 Location Code Filter Code[10] — TableRelation Table 14 “Location”; FlowFilter
25 Lot No. Filter Code[50] — FlowFilter
30 Qty. In Hand Δ BC28 Decimal Specifies the inventory level of an item.
31 Gross Requirement Δ BC28 Decimal Specifies the sum of the total demand for the item. The gross requirement consists of independent demand (which include sales orders, service orders, transfer orders, and demand forecasts) and dependent demand (which include production order components for planned, firm planned, and released product…
32 Planned Order Receipt Δ BC28 Decimal Specifies the item’s availability figures for the planned order receipt.
33 Scheduled Receipt Δ BC28 Decimal Specifies the sum of items from replenishment orders.
34 Available Inventory Δ BC28 Decimal Specifies the quantity of the item that is currently in inventory and not reserved for other demand.
503 Qty. on Sales Order Δ BC28 Decimal Qty. on Sales Orders caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(37), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant …; not editable
504 Qty. on Service Order Δ BC28 Decimal Qty. on Service Orders caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5902), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Varian…; not editable
505 Qty. on Job Order Δ BC24 Δ BC28 Decimal Qty. on Project Order caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(1003), “Source Subtype” = const(“2”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Varian…; not editable
506 Qty. on Component Lines Δ BC28 Decimal Res. Qty. on Prod. Order Comp. caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5407), “Source Subtype” = filter(“1” .. “3”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”),…; not editable
507 Qty. on Trans. Order Shipment Δ BC25 Δ BC28 Decimal Qty. on Transfer Order Shipment caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5741), “Source Subtype” = const(“0”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Varian…; not editable
509 Qty. on Asm. Component Δ BC28 Decimal Qty. on Asm. Comp. caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(901), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant…; not editable
510 Qty. on Purch. Return Δ BC28 Decimal Qty. on Purch. Returns caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(39), “Source Subtype” = const(“5”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant …; not editable
511 Qty. on Purch. Order Δ BC28 Decimal Qty. on Purch. Orders caption FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(39), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant Co…; not editable
512 Planned Order Receipt (Qty.) Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5406), “Source Subtype” = const(“1”), “Reservation Status” = const(Prospect), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant Code” = field(“Variant Co…; not editable
513 Purch. Req. Receipt (Qty.) Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(246), “Source Subtype” = const(“0”), “Reservation Status” = const(Prospect), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant Code” = field(“Variant Cod…; not editable
514 Qty. on Prod. Receipt Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5406), “Source Subtype” = filter(“2” .. “3”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “…; not editable
516 Qty. on Trans. Order Receipt Δ BC25 Δ BC28 Decimal Qty. on Transfer Order Receipt caption FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5741), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant …; not editable
517 Qty. on Assembly Order Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(900), “Source Subtype” = const(“1”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant C…; not editable
518 Qty. on Sales Return Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(37), “Source Subtype” = const(“5”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “Variant Co…; not editable
99000777 Qty. on Prod. Order Δ BC28 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“Item No.”), “Source Type” = const(5406), “Source Subtype” = filter(“1” .. “3”), “Reservation Status” = filter(Reservation | Tracking | Surplus), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Code Filter”), “…; not editable

Keys

  • Key1: Lot No., Serial No., Package No. (clustered)

Events published

Procedures

  • LookupInventory(var ItemLedgerEntry: Record "Item Ledger Entry") (internal)
  • LookupGrossRequirement(var TempReservationEntry: Record "Reservation Entry" temporary) (internal)
  • LookupPlannedOrderReceipt(var TempReservationEntry: Record "Reservation Entry" temporary) (internal)
  • LookupScheduledReceipt(var TempReservationEntry: Record "Reservation Entry" temporary) (internal)
  • LookupAvailableInventory(var TempReservationEntry: Record "Reservation Entry" temporary) (internal)
  • AddEntriesForLookUp(var TempReservationEntry: Record "Reservation Entry" temporary; SourceType: Integer; SourceSubTypeFilter: Text; ReservationStatusFilter: Text; DateFilterOption: Enum "Reservation Date Filter") + BC25 − BC25
  • GetRangeFilter(FromVariant: Variant; ToVariant: Variant): Text Δ BC25
  • GetOptionFilter(Option1Variant: Variant; Option2Variant: Variant; Option3Variant: Variant): Text Δ BC25

Relations

Pages and codeunits on this table

Extended by

Ask your agent

Procedure bodies are not stored here (D10). 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: "Availability Info. Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources