tableInventoryofficial - Microsoftderived - from the source, no model text

Table 921 "Item Turnover Buffer"

Base Application · Microsoft.Inventory.Analysis

Across versions

  1. BC23-26present
  2. BC272 fields changed
  3. BC286 fields changed
  4. BC29-30unchanged

Neighbourhood 1 connected objects and pages

Page 354 "Item Turnover Lines" (pages and codeunits on it)Item Turnover Lines

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

Properties

Property Value
DataClassification SystemMetadata

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
5 Period Type Option —
6 Period Name Δ BC28 Text[50] Specifies the name of the period defined on the line, related to year-to-date inventory turnover.
7 Period Start Δ BC28 Date Specifies the start date of the period defined on the line, related to year-to-date inventory turnover.
8 Period End Date —
10 Purchases (Qty.) Δ BC28 Decimal Specifies how many units of the item have been purchased. The program automatically calculates and updates the contents of the field, using the Invoiced Quantity field in the Item Ledger Entry table for those entries of the Purchase type. via Page 354 “Item Turnover Lines”
11 Purchases (LCY) Δ BC27 Δ BC28 Decimal Specifies the total purchase amount, in LCY, of the item that has been purchased. The program automatically calculates and updates the contents of the field, using the Sales Amount (Actual) field in the Value Entry table for those entries that have been posted as purchases. via Page 354 “Item Turnover Lines”
12 Sales (Qty.) Δ BC28 Decimal Specifies how many units of the item have been sold. The program automatically calculates and updates the contents of the field, using the Invoiced Quantity field in the Item Ledger Entry table for those entries of the Sales type. via Page 354 “Item Turnover Lines”
13 Sales (LCY) Δ BC27 Δ BC28 Decimal Specifies the sales amount, in LCY, of the item that has been sold. The program automatically calculates and updates the contents of the field, using the Sales Amount (Actual) field in the Value Entry table for those entries that have been posted as sales. via Page 354 “Item Turnover Lines”

Keys

  • Key1: Period Type, Period Start (clustered)

Pages and codeunits on this table

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

Evidence 1 sources