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

Table 27 "Item"

Base Application · Microsoft.Inventory.Item

Open in Claude27.mdSource on GitHub

Across versions

  1. BC23present
  2. BC244 fields changed, 3 procedures changed
  3. BC2519 procedures added, 14 events changed
  4. BC2631 fields removed, 19 fields changed
  5. BC2773 fields changed, 15 events added
  6. BC28109 fields changed, 21 procedures removed
  7. BC291 procedures changed, 1 events added
  8. BC301 events added

Neighbourhood 416 connected objects and pages

Table 337 "Reservation Entry" (relates to, 9 links)Reservation EntryTable 32 "Item Ledger Entry" (relates to, 7 links)Item Ledger EntryTable 5802 "Value Entry" (relates to, 7 links)Table 246 "Requisition Line" (relates to, 6 links)Table 204 "Unit of Measure" (relates to, 4 links)Unit of MeasureTable 349 "Dimension Value" (relates to, 4 links)Dimension ValueTable 308 "No. Series" (relates to, 3 links)Table 37 "Sales Line" (relates to, 3 links)Sales LineTable 39 "Purchase Line" (relates to, 3 links)Table 5404 "Item Unit of Measure" (relates to, 3 links)Item Unit of MeasureTable 5741 "Transfer Line" (relates to, 3 links)Page 31 "Item List" (pages and codeunits on it, 2 links)Page 32 "Item Lookup" (pages and codeunits on it, 2 links)Table extension 1854 "ItemForecastExtension" (extended by)Table extension 4412 "SOA Item Ext" (extended by)Codeunit 99000795 "Mfg. Item Integration" (event subscribers, 10 links)Mfg. Item IntegrationCodeunit 99000875 "Prod. Order Availability Mgt." (event subscribers, 7 links)Prod. Order Availability Mgt.Codeunit 6250 "Sust. Certificate Subscribers" (event subscribers, 3 links)Sust. Certificate SubscribersCodeunit 1173 "Document Attachment Mgmt" (event subscribers, 2 links)Codeunit 1520 "Workflow Event Handling" (event subscribers, 2 links)Codeunit 5152 "API - Update Referenced Fields" (event subscribers, 2 links)Codeunit 7006 "Price Helper - V16" (event subscribers, 2 links)Codeunit 408 "DimensionManagement" (calls, 5 links)DimensionManagementCodeunit 1535 "Approvals Mgmt." (calls, 2 links)Codeunit 5465 "Graph Mgt - General Tools" (calls, 2 links)Codeunit 5823 "Cost Adjustment Item Runner" (calls, 2 links)Codeunit 703 "Find Record Management" (calls, 2 links)Codeunit 99000855 "Planning-Get Parameters" (calls, 2 links)Page 456 "No. Series" (calls, 2 links)Table 32 "Item Ledger Entry" (referenced by, 4 links)Item Ledger EntryTable 4771 "Jobs Module Setup" (referenced by, 4 links)Jobs Module SetupTable 90 "BOM Component" (referenced by, 4 links)BOM ComponentTable 4763 "Whse Demo Data Setup" (referenced by, 3 links)Table 4764 "Warehouse Module Setup" (referenced by, 3 links)Warehouse Module SetupTable 4765 "Service Module Setup" (referenced by, 3 links)Table 5108 "Sales Line Archive" (referenced by, 3 links)Table 5802 "Value Entry" (referenced by, 3 links)Table 83 "Item Journal Line" (referenced by, 3 links)(v1.0) Create item defaultDimensions (Learn pages)(v1.0) Create item picture (Learn pages)

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

Learn documents this table through its pages: Page 30 “Item Card” (13 Learn pages), Page 20008 “APIV1 - Items” (12), Page 910 “Assembly Item - Details” (10), Page 30008 “APIV2 - Items” (9), Page 31 “Item List” (8), Page 4410 “SOA Multi Items Availability” (7), Page 32 “Item Lookup” (2), Page 346 “Item Picture” (2), Page 9091 “Item Planning FactBox” (2), Page 157 “Item Availability by Periods” (1), Page 304 “Item Entry Statistics” (1), Page 342 “Check Availability” (1), Page 491 “Items by Location” (1), Page 492 “Item Availability by Location” (1), Page 911 “Component - Item Details” (1), Page 1850 “Sales Forecast” (1), Page 1851 “Sales Forecast No Chart” (1), Page 1872 “Item Availability Check” (1), Page 1873 “Item Availability Check Det.” (1), Page 5414 “Item Availability by Variant” (1), and 4 more pages.

Properties

Property Value
Caption Item
DataClassification CustomerContent
Permissions TableData “Bin Content” = d, TableData “Planning Assignment” = d

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 No. Δ BC25 Δ BC28 Code[20] Specifies the number of the item.
2 No. 2 Δ BC26 Δ BC28 Code[20] Specifies an alternative account number which can be used internally in the company.
3 Description Δ BC25 Δ BC28 Text[100] Specifies a description of the item.
4 Search Description Δ BC26 Δ BC28 Code[100] Specifies a search description that you use to find the item in lists.
5 Description 2 Δ BC25 Δ BC28 Text[50] Specifies information in addition to the description.
6 Assembly BOM Δ BC28 Boolean Specifies if the item is an assembly BOM. FlowField: exist(“BOM Component” where(“Parent Item No.” = field(“No.”))); not editable
8 Base Unit of Measure Δ BC28 Code[10] Specifies the base unit used to measure the item, such as piece, box, or pallet. The base unit of measure also serves as the conversion basis for alternate units of measure. TableRelation Table 204 “Unit of Measure” (Unit of Measure)
9 Price Unit Conversion Integer —
10 Type Δ BC28 Enum “Item Type” Specifies if the item card represents a physical inventory unit (Inventory), a labor time unit (Service), or a physical unit that is not tracked in inventory (Non-Inventory). enum Enum 27 “Item Type”
11 Inventory Posting Group Δ BC28 Code[20] Specifies links between business transactions made for the item and an inventory account in the general ledger, to group amounts for that item type. TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group)
12 Shelf No. Δ BC26 Δ BC28 Code[10] Specifies where to find the item in the warehouse. This is informational only.
14 Item Disc. Group Δ BC28 Code[20] Specifies an item group code that can be used as a criterion to grant a discount when the item is sold to a certain customer. TableRelation Table 341 “Item Discount Group” (Item Discount Group)
15 Allow Invoice Disc. Δ BC28 Boolean Specifies if the item should be included in the calculation of an invoice discount on documents where the item is traded.
16 Statistics Group Δ BC27 Integer Specifies the statistics group.
17 Commission Group Integer —
18 Unit Price Δ BC27 Δ BC28 Decimal Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
19 Price/Profit Calculation Δ BC28 Enum “Item Price Profit Calculation” Specifies the relationship between the Unit Cost, Unit Price, and Profit Percentage fields associated with this item. enum Enum 19 “Item Price Profit Calculation”
20 Profit % Δ BC27 Δ BC28 Decimal Specifies the profit margin that you want to sell the item at. You can enter a profit percentage manually or have it entered according to the Price/Profit Calculation field
21 Costing Method Δ BC28 Enum “Costing Method” Specifies how the item’s cost flow is recorded and whether an actual or budgeted value is capitalized and used in the cost calculation. enum Enum 28 “Costing Method”
22 Unit Cost Δ BC27 Δ BC28 Decimal Specifies the cost of one unit of the item or resource on the line.
24 Standard Cost Δ BC27 Δ BC28 Decimal Specifies the unit cost that is used as an estimation to be adjusted with variances later. It is typically used in assembly and production where costs can vary.
25 Last Direct Cost Δ BC27 Δ BC28 Decimal Specifies the most recent direct unit cost of the item.
28 Indirect Cost % Δ BC27 Δ BC28 Decimal Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item.
29 Cost is Adjusted Δ BC28 Boolean Specifies whether the item’s unit cost has been adjusted, either automatically or manually. not editable
30 Allow Online Adjustment Boolean — not editable
31 Vendor No. Δ BC26 Δ BC28 Code[20] Specifies the vendor code of who supplies this item by default. TableRelation Table 23 “Vendor”
32 Vendor Item No. Δ BC25 Δ BC28 Text[50] Specifies the number that the vendor uses for this item.
33 Lead Time Calculation Δ BC28 DateFormula Specifies a date formula for the amount of time it takes to replenish the item.
34 Reorder Point Δ BC27 Δ BC28 Decimal Specifies a stock quantity that sets the inventory below the level that you must replenish the item.
35 Maximum Inventory Δ BC27 Δ BC28 Decimal Specifies a quantity that you want to use as a maximum inventory level.
36 Reorder Quantity Δ BC27 Δ BC28 Decimal Specifies a standard lot size quantity to be used for all order proposals.
37 Alternative Item No. Δ BC26 Δ BC28 Code[20] Specifies another identifier for this item. TableRelation Table 27 “Item”
38 Unit List Price Δ BC27 Decimal —
39 Duty Due % Δ BC27 Decimal —
40 Duty Code Δ BC26 Code[10] —
41 Gross Weight Δ BC27 Δ BC28 Decimal Specifies the gross weight of the item.
42 Net Weight Δ BC27 Δ BC28 Decimal Specifies the net weight of the item.
43 Units per Parcel Δ BC27 Decimal —
44 Unit Volume Δ BC27 Δ BC28 Decimal Specifies the volume of one unit of the item.
45 Durability Code[10] —
46 Freight Type Code[10] —
47 Tariff No. Δ BC26 Δ BC28 Code[20] Specifies a code for the item’s tariff number. TableRelation Table 260 “Tariff Number” (Tariff Number)
48 Duty Unit Conversion Δ BC27 Decimal —
49 Country/Region Purchased Code Code[10] — TableRelation Table 9 “Country/Region” (Country/Region)
50 Budget Quantity Δ BC27 Decimal —
51 Budgeted Amount Δ BC27 Decimal —
52 Budget Profit Δ BC27 Decimal —
53 Comment Boolean — FlowField: exist(“Comment Line” where(“Table Name” = const(Item), “No.” = field(“No.”))); not editable
54 Blocked Δ BC28 Boolean Specifies that transactions with the item cannot be posted, for example, because the item is in quarantine.
55 Cost is Posted to G/L Δ BC24 Δ BC28 Boolean Specifies that all the inventory costs for this item have been posted to the general ledger. FlowField: - exist(“Post Value Entry to G/L” where(“Item No.” = field(“No.”))); not editable
56 Block Reason Δ BC25 Text[250] —
61 Last DateTime Modified DateTime — not editable
62 Last Date Modified Δ BC28 Date Specifies when the item card was last modified. not editable
63 Last Time Modified Time — not editable
64 Date Filter Date — FlowFilter
65 Global Dimension 1 Filter Code[20] — TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
66 Global Dimension 2 Filter Code[20] — TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter
67 Location Filter Code[10] — TableRelation Table 14 “Location”; FlowFilter
68 Inventory Δ BC27 Δ BC28 Decimal Specifies how many units, such as pieces, boxes, or cans, of the item are in inventory. FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “Variant Code…; not editable
69 Net Invoiced Qty. Δ BC27 Δ BC28 Decimal Specifies how many units of the item in inventory have been invoiced. FlowField: sum(“Item Ledger Entry”.“Invoiced Quantity” where(“Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “V…; not editable
70 Net Change Δ BC27 Decimal Specifies the net change in the inventory of the item during the period entered in the Date Filter field. via Page 4410 “SOA Multi Items Availability” FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “Posting Date…; not editable
71 Purchases (Qty.) Δ BC27 Decimal — FlowField: sum(“Item Ledger Entry”.“Invoiced Quantity” where(“Entry Type” = const(Purchase), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = f…; not editable
72 Sales (Qty.) Δ BC27 Decimal — FlowField: - sum(“Value Entry”.“Invoiced Quantity” where(“Item Ledger Entry Type” = const(Sale), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment”…; not editable
73 Positive Adjmt. (Qty.) Δ BC27 Decimal — FlowField: sum(“Item Ledger Entry”.“Invoiced Quantity” where(“Entry Type” = const(“Positive Adjmt.”), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Ship…; not editable
74 Negative Adjmt. (Qty.) Δ BC27 Decimal — FlowField: - sum(“Item Ledger Entry”.“Invoiced Quantity” where(“Entry Type” = const(“Negative Adjmt.”), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Sh…; not editable
77 Purchases (LCY) Δ BC27 Decimal — FlowField: sum(“Value Entry”.“Purchase Amount (Actual)” where(“Item Ledger Entry Type” = const(Purchase), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop …; not editable
78 Sales (LCY) Δ BC27 Decimal — FlowField: sum(“Value Entry”.“Sales Amount (Actual)” where(“Item Ledger Entry Type” = const(Sale), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipmen…; not editable
79 Positive Adjmt. (LCY) Δ BC27 Decimal — FlowField: sum(“Value Entry”.“Cost Amount (Actual)” where(“Item Ledger Entry Type” = const(“Positive Adjmt.”), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “…; not editable
80 Negative Adjmt. (LCY) Δ BC27 Decimal — FlowField: sum(“Value Entry”.“Cost Amount (Actual)” where(“Item Ledger Entry Type” = const(“Negative Adjmt.”), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “…; not editable
83 COGS (LCY) Δ BC27 Decimal — FlowField: - sum(“Value Entry”.“Cost Amount (Actual)” where(“Item Ledger Entry Type” = const(Sale), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipme…; not editable
84 Qty. on Purch. Order Δ BC27 Δ BC28 Decimal Specifies how many units of the item are inbound on purchase orders, meaning listed on outstanding purchase order lines. FlowField: sum(“Purchase Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(Order), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”)…; not editable
85 Qty. on Sales Order Δ BC27 Δ BC28 Decimal Specifies how many units of the item are allocated to sales orders, meaning listed on outstanding sales orders lines. FlowField: sum(“Sales Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(Order), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “…; not editable
87 Price Includes VAT Δ BC28 Boolean Specifies if the Unit Price and Line Amount fields on sales document lines for this item should be shown with or without VAT.
89 Drop Shipment Filter Boolean — FlowFilter
90 VAT Bus. Posting Gr. (Price) Code[20] Specifies the VAT business posting group for customers for whom you want the sales price including VAT to apply. via Page 30 “Item Card” TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
91 Gen. Prod. Posting Group Δ BC28 Code[20] Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
92 Picture Δ BC28 MediaSet Specifies the picture that has been inserted for the item.
93 Transferred (Qty.) Δ BC27 Decimal — FlowField: sum(“Item Ledger Entry”.“Invoiced Quantity” where(“Entry Type” = const(Transfer), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = f…; not editable
94 Transferred (LCY) Δ BC27 Decimal — FlowField: sum(“Value Entry”.“Sales Amount (Actual)” where(“Item Ledger Entry Type” = const(Transfer), “Item No.” = field(“No.”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Filter”), “Drop Shi…; not editable
95 Country/Region of Origin Code Δ BC28 Code[10] Specifies a code for the country/region where the item was produced or processed. TableRelation Table 9 “Country/Region” (Country/Region)
96 Automatic Ext. Texts Δ BC28 Boolean Specifies that an extended text that you have set up will be added automatically on sales or purchase documents for this item.
97 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series); not editable
98 Tax Group Code Δ BC28 Code[20] Specifies the tax group that is used to calculate and post sales tax. TableRelation Table 321 “Tax Group” (Tax Group)
99 VAT Prod. Posting Group Δ BC28 Code[20] Specifies the VAT product posting group. Links business transactions made for the item, resource, or G/L account with the general ledger, to account for VAT amounts resulting from trade with that record. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
100 Reserve Δ BC28 Enum “Reserve Method” Specifies if and how the item will be reserved. Never: It is not possible to reserve the item. Optional: You can reserve the item manually. Always: The item is automatically reserved from demand, such as sales orders, against inventory, purchase orders, assembly orders, and production orders. enum Enum 100 “Reserve Method”
101 Reserved Qty. on Inventory Δ BC27 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(32), “Source Subtype” = const(“0”), “Reservation Status” = const(Reservation), “Serial No.” = field(“Serial No. Filter”), “Lot No.” = field(“Lot No. Filter”), “Location Code” = field(“Location Filter”), …; not editable
102 Reserved Qty. on Purch. Orders Δ BC27 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(39), “Source Subtype” = const(“1”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Expected Receipt Date” = field(“Date …; not editable
103 Reserved Qty. on Sales Orders Δ BC27 Decimal — FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(37), “Source Subtype” = const(“1”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shipment Date” = field(“Date Filter…; not editable
105 Global Dimension 1 Code Code[20] — TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
106 Global Dimension 2 Code Code[20] — TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
107 Res. Qty. on Outbound Transfer Δ BC27 Decimal — FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(5741), “Source Subtype” = const(“0”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shipment Date” = field(“Date Filt…; not editable
108 Res. Qty. on Inbound Transfer Δ BC27 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(5741), “Source Subtype” = const(“1”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Expected Receipt Date” = field(“Dat…; not editable
109 Res. Qty. on Sales Returns Δ BC27 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(37), “Source Subtype” = const(“5”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shipment Date” = field(“Date Filter”)…; not editable
110 Res. Qty. on Purch. Returns Δ BC27 Decimal — FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(39), “Source Subtype” = const(“5”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Expected Receipt Date” = field(“Dat…; not editable
120 Stockout Warning Δ BC28 Option Specifies if a warning is displayed when you enter a quantity on a sales document that brings the item’s inventory below zero. OptionCaption: Default,No,Yes
121 Prevent Negative Inventory Δ BC28 Option Specifies whether you can post a transaction that will bring the item’s inventory below zero. Negative inventory is always prevented for Consumption and Transfer type transactions. OptionCaption: Default,No,Yes
122 Variant Mandatory if Exists Δ BC28 Option Specifies whether a variant must be selected if variants exist for the item. OptionCaption: Default,No,Yes
521 Application Wksh. User ID Δ BC28 Code[128] Specifies the ID of a user who is working in the Application Worksheet window. DataClassification EndUserIdentifiableInformation
720 Coupled to CRM Δ BC26 Boolean Coupled to Dynamics 365 Sales caption obsolete Removed 26.0; #if not CLEANSCHEMA26; not editable
721 Coupled to Dataverse Δ BC28 Boolean Specifies that the item is coupled to a product in Dynamics 365 Sales. FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::Item))); not editable
910 Assembly Policy Δ BC26 Δ BC28 Enum Microsoft.Assembly.Setup.“Assembly Policy” Specifies which default order flow is used to supply this assembly item. enum Microsoft.Assembly.Setup.“Assembly Policy”
1001 Qty. on Job Order Δ BC24 Δ BC27 Δ BC28 Decimal Specifies how many units of the item are allocated to projects, meaning listed on outstanding project planning lines. FlowField: sum(“Job Planning Line”.“Remaining Qty. (Base)” where(Status = const(Order), Type = const(Item), “No.” = field(“No.”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Planning Date” = field(“Date Filter”), “Unit of Measure Code” = field(“Unit of Measure Filter”…; not editable
1002 Res. Qty. on Job Order Δ BC24 Δ BC27 Decimal Res. Qty. on Project Order caption FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(1003), “Source Subtype” = const(“2”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shipment Date” = field(“Date Filt…; not editable
1217 GTIN Δ BC26 Δ BC28 Code[14] Specifies the number that is used for barcodes etc.
1700 Default Deferral Template Code Δ BC28 Code[10] Specifies the default template that governs how to defer revenues and expenses to the periods when they occurred. TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”)
5400 Low-Level Code Δ BC28 Integer Specifies the item’s level in a bill of material if the item is a component in a production BOM or an assembly BOM. not editable
5401 Lot Size Δ BC26 Δ BC27 Decimal Specifies the default number of units of the item that are processed in one production operation. This affects standard cost calculations and capacity planning. If the item routing includes fixed costs such as setup time, the value in this field is used to calculate the standard cost and distribute … via Page extension 99000750 “Mfg. Item Card”
5402 Serial Nos. Δ BC28 Code[20] Specifies a number series code to assign consecutive serial numbers to items produced. TableRelation Table 308 “No. Series” (No. Series)
5403 Last Unit Cost Calc. Date Date — not editable
5404 Rolled-up Material Cost Δ BC27 Decimal — not editable
5405 Rolled-up Capacity Cost Δ BC27 Decimal — not editable
5407 Scrap % Δ BC26 Δ BC27 Decimal Specifies the percentage of the item that you expect to be scrapped in the production process. via Page extension 99000750 “Mfg. Item Card”
5408 Rolled-up Mat. Non-Invt. Cost + BC26 Δ BC27 Decimal Specifies the Non-inventory material cost of all items at all levels of the parent item’s BOM. not editable
5409 Inventory Value Zero Δ BC28 Boolean Specifies whether the item on inventory must be excluded from inventory valuation. This is relevant if the item is kept on inventory on someone else’s behalf.
5410 Discrete Order Quantity Integer —
5411 Minimum Order Quantity Δ BC27 Δ BC28 Decimal Specifies a minimum allowable quantity for an item order proposal.
5412 Maximum Order Quantity Δ BC27 Δ BC28 Decimal Specifies a maximum allowable quantity for an item order proposal.
5413 Safety Stock Quantity Δ BC27 Δ BC28 Decimal Specifies a quantity of stock to have in inventory to protect against supply-and-demand fluctuations during replenishment lead time.
5414 Order Multiple Δ BC27 Δ BC28 Decimal Specifies a parameter used by the planning system to round the quantity of planned supply orders to a multiple of this value.
5415 Safety Lead Time Δ BC28 DateFormula Specifies a date formula to indicate a safety lead time that can be used as a buffer period for production and other delays.
5417 Flushing Method − BC26 + BC27 Δ BC28 Enum Microsoft.Manufacturing.Setup.“Flushing Method” Specifies how consumption of the item (component) is calculated and handled in production processes. Manual: Enter and post consumption in the consumption journal manually. Forward: Automatically posts consumption according to the production order component lines when the first operation starts. Bac… enum Microsoft.Manufacturing.Setup.“Flushing Method”
5419 Replenishment System Δ BC28 Enum “Replenishment System” Specifies the type of supply order created by the planning system when the item needs to be replenished. enum Enum 5419 “Replenishment System”
5422 Rounding Precision Δ BC26 Δ BC27 Decimal Specifies how calculated consumption quantities are rounded when entered on consumption journal lines. via Page extension 99000750 “Mfg. Item Card”
5423 Bin Filter Code[20] — TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Filter”))); FlowFilter
5424 Variant Filter Code[10] — TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“No.”))); FlowFilter
5425 Sales Unit of Measure Δ BC28 Code[10] Specifies the unit of measure code used when you sell the item. TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5426 Purch. Unit of Measure Δ BC28 Code[10] Specifies the unit of measure code used when you purchase the item. TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5427 Unit of Measure Filter Code[10] — TableRelation Table 204 “Unit of Measure” (Unit of Measure); FlowFilter
5428 Time Bucket Δ BC28 DateFormula Specifies a time period that defines the recurring planning horizon used with Fixed Reorder Qty. or Maximum Qty. reordering policies.
5431 Res. Qty. on Req. Line Δ BC27 Decimal — FlowField: sum(“Reservation Entry”.“Quantity (Base)” where(“Item No.” = field(“No.”), “Source Type” = const(246), “Source Subtype” = filter(“0”), “Reservation Status” = const(Reservation), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Expected Receipt Date” = field(“Dat…; not editable
5440 Reordering Policy Δ BC28 Enum “Reordering Policy” Specifies the reordering policy that is used to calculate the lot size per planning period (time bucket). enum Enum 5440 “Reordering Policy”
5441 Include Inventory Δ BC28 Boolean Specifies that the inventory quantity is included in the projected available balance when replenishment orders are calculated.
5442 Manufacturing Policy Δ BC26 Δ BC28 Enum Microsoft.Manufacturing.Setup.“Manufacturing Policy” Specifies if additional orders for any related components are calculated. enum Microsoft.Manufacturing.Setup.“Manufacturing Policy”
5443 Rescheduling Period Δ BC28 DateFormula Specifies a period within which any suggestion to change a supply date always consists of a Reschedule action and never a Cancel + New action.
5444 Lot Accumulation Period Δ BC28 DateFormula Specifies a period in which multiple demands are accumulated into one supply order when you use the Lot-for-Lot reordering policy.
5445 Dampener Period Δ BC28 DateFormula Specifies a period of time during which you do not want the planning system to propose to reschedule existing supply orders.
5446 Dampener Quantity Δ BC27 Δ BC28 Decimal Specifies a dampener quantity to block insignificant change suggestions for an existing supply, if the change quantity is lower than the dampener quantity.
5447 Overflow Level Δ BC27 Δ BC28 Decimal Specifies a quantity you allow projected inventory to exceed the reorder point, before the system suggests to decrease supply orders.
5449 Planning Transfer Ship. (Qty). Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(“Worksheet Template Name” = filter(<> ‘’), “Journal Batch Name” = filter(<> ‘’), “Replenishment System” = const(Transfer), Type = const(Item), “No.” = field(“No.”), “Variant Code” = field(“Variant Filter”), “Transfer-from Code” = field(“Location Filter”…; not editable
5450 Planning Worksheet (Qty.) Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(“Planning Line Origin” = const(Planning), Type = const(Item), “No.” = field(“No.”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Due Date” = field(“Date Filter”), “Shortcut Dimension 1 Code” = field(“Global Dime…; not editable
5700 Stockkeeping Unit Exists Δ BC28 Boolean Specifies that a stockkeeping unit exists for this item. FlowField: exist(“Stockkeeping Unit” where(“Item No.” = field(“No.”))); not editable
5701 Manufacturer Code Δ BC26 Δ BC28 Code[10] Specifies a code for the manufacturer of the catalog item. TableRelation Table 5720 “Manufacturer”
5702 Item Category Code Δ BC26 Δ BC28 Code[20] Specifies the category that the item belongs to. Item categories also contain any assigned item attributes. TableRelation Table 5722 “Item Category” (Item Category)
5703 Created From Nonstock Item Δ BC28 Boolean Specifies that the item was created from a catalog item. not editable
5706 Substitutes Exist Δ BC28 Boolean Specifies that a substitute exists for this item. FlowField: exist(“Item Substitution” where(Type = const(Item), “No.” = field(“No.”))); not editable
5707 Qty. in Transit Δ BC27 Δ BC28 Decimal Specifies the quantity of the items that are currently in transit. FlowField: sum(“Transfer Line”.“Qty. in Transit (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“No.”), “Transfer-to Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = f…; not editable
5708 Trans. Ord. Receipt (Qty.) Δ BC27 Decimal Specifies the quantity of the items that remains to be received but are not yet shipped as the difference between the Quantity and the Quantity Shipped fields. via Page 30 “Item Card” FlowField: sum(“Transfer Line”.“Outstanding Qty. (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“No.”), “Transfer-to Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = …; not editable
5709 Trans. Ord. Shipment (Qty.) Δ BC27 Decimal Specifies the quantity of the items that remains to be shipped as the difference between the Quantity and the Quantity Shipped fields. via Page 30 “Item Card” FlowField: sum(“Transfer Line”.“Outstanding Qty. (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“No.”), “Transfer-from Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” …; not editable
5711 Purchasing Code Δ BC26 Δ BC28 Code[10] Specifies the code for a special procurement method, such as drop shipment. TableRelation Table 5721 “Purchasing”
5776 Qty. Assigned to ship Δ BC27 Decimal — FlowField: sum(“Warehouse Shipment Line”.“Qty. Outstanding (Base)” where(“Item No.” = field(“No.”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Due Date” = field(“Date Filter”))); not editable
5777 Qty. Picked Δ BC27 Decimal — FlowField: sum(“Warehouse Shipment Line”.“Qty. Picked (Base)” where(“Item No.” = field(“No.”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Due Date” = field(“Date Filter”))); not editable
5801 Excluded from Cost Adjustment + BC24 Δ BC28 Boolean Specifies whether the item is excluded from the cost adjustment process.
6500 Item Tracking Code Δ BC26 Δ BC28 Code[10] Specifies how serial, lot or package numbers assigned to the item are tracked in the supply chain. TableRelation Table 6502 “Item Tracking Code” (Item Tracking Code)
6501 Lot Nos. Δ BC28 Code[20] Specifies the number series code that will be used when assigning lot numbers. TableRelation Table 308 “No. Series” (No. Series)
6502 Expiration Calculation Δ BC28 DateFormula Specifies the date formula for calculating the expiration date on the item tracking line. Note: This field will be ignored if the involved item has Require Expiration Date Entry set to Yes on the Item Tracking Code page.
6503 Lot No. Filter Code[50] — FlowFilter
6504 Serial No. Filter Code[50] — FlowFilter
6515 Package No. Filter Code[50] — FlowFilter
6650 Qty. on Purch. Return Δ BC27 Decimal — FlowField: sum(“Purchase Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(“Return Order”), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location…; not editable
6660 Qty. on Sales Return Δ BC27 Decimal — FlowField: sum(“Sales Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(“Return Order”), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Fi…; not editable
7171 No. of Substitutes Δ BC28 Integer Specifies the number of substitutions that have been registered for the item. FlowField: count(“Item Substitution” where(Type = const(Item), “No.” = field(“No.”))); not editable
7300 Warehouse Class Code Δ BC28 Code[10] Specifies the warehouse class code for the item. TableRelation Table 7304 “Warehouse Class” (Warehouse Class)
7301 Special Equipment Code Δ BC28 Code[10] Specifies the code of the equipment that warehouse employees must use when handling the item. TableRelation Table 7305 “Special Equipment” (Special Equipment)
7302 Put-away Template Code Δ BC28 Code[10] Specifies the code of the put-away template by which the program determines the most appropriate zone and bin for storage of the item after receipt. TableRelation Table 7307 “Put-away Template Header” (Put-away Template Header)
7307 Put-away Unit of Measure Code Δ BC28 Code[10] Specifies the code of the item unit of measure in which the program will put the item away. TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (“No.” = filter(<> ‘’)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
7380 Phys Invt Counting Period Code Δ BC28 Code[10] Specifies the code of the counting period that indicates how often you want to count the item in a physical inventory. TableRelation Table 7381 “Phys. Invt. Counting Period” (Phys. Invt. Counting Period)
7381 Last Counting Period Update Δ BC28 Date Specifies the last date on which you calculated the counting period. It is updated when you use the function Calculate Counting Period. not editable
7383 Last Phys. Invt. Date Δ BC28 Date Specifies the date on which you last posted the results of a physical inventory for the item to the item ledger. FlowField: max(“Phys. Inventory Ledger Entry”.“Posting Date” where(“Item No.” = field(“No.”), “Phys Invt Counting Period Type” = filter(” “ | Item))); not editable
7384 Use Cross-Docking Δ BC28 Boolean Specifies if this item can be cross-docked.
7385 Next Counting Start Date Δ BC28 Date Specifies the starting date of the next counting period. not editable
7386 Next Counting End Date Δ BC28 Date Specifies the ending date of the next counting period. not editable
7387 Unit Group Exists Boolean — FlowField: exist(“Unit Group” where(“Source Id” = field(SystemId), “Source Type” = const(Item))); not editable
7700 Identifier Code Δ BC24 Δ BC28 Code[20] Specifies a unique code for the item in terms that are useful for automatic data capture. FlowField: lookup(“Item Identifier”.Code where(“Item No.” = field(“No.”))); not editable
8001 Unit of Measure Id Guid — TableRelation Table 204 “Unit of Measure” (“Unit of Measure”.SystemId)
8002 Tax Group Id Guid Specifies the ID of the tax group. via Page 20008 “APIV1 - Items” TableRelation Table 321 “Tax Group” (“Tax Group”.SystemId)
8003 Sales Blocked Δ BC28 Boolean Specifies that transactions with the item cannot be sold, for example, because the item is in quarantine.
8004 Purchasing Blocked Δ BC28 Boolean Specifies that the item cannot be entered on purchase documents, except return orders and credit memos, and journals.
8005 Item Category Id Guid — TableRelation Table 5722 “Item Category” (“Item Category”.SystemId); DataClassification SystemMetadata
8006 Inventory Posting Group Id Guid — TableRelation Table 94 “Inventory Posting Group” (“Inventory Posting Group”.SystemId)
8007 Gen. Prod. Posting Group Id Guid — TableRelation Table 251 “Gen. Product Posting Group” (“Gen. Product Posting Group”.SystemId)
8010 Service Blocked + BC24 Δ BC28 Boolean Specifies that the item cannot be entered on service items, service contracts and service documents, except credit memos.
8510 Over-Receipt Code Δ BC28 Code[20] Specifies the policy that will be used for the item if more items than ordered are received. TableRelation Table 8510 “Over-Receipt Code” (Over-Receipt Code)
9110 Qty. on Blanket Sales Order + BC28 Decimal Specifies how many units of the item are allocated to blanket sales orders, meaning listed on outstanding blanket sales order lines. FlowField: sum(“Sales Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(“Blanket Order”), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location F…; not editable
9210 Qty. on Blanket Purch. Order + BC28 Decimal Specifies how many units of the item are allocated to blanket purchase orders, meaning listed on outstanding blanket purchase order lines. FlowField: sum(“Purchase Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(“Blanket Order”), Type = const(Item), “No.” = field(“No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Locatio…; not editable
99000752 Single-Level Material Cost − BC26 + BC27 Decimal — not editable
99000753 Single-Level Capacity Cost − BC26 + BC27 Decimal — not editable
99000754 Single-Level Subcontrd. Cost − BC26 + BC27 Decimal — not editable
99000755 Single-Level Cap. Ovhd Cost − BC26 + BC27 Decimal — not editable
99000756 Single-Level Mfg. Ovhd Cost − BC26 + BC27 Δ BC28 Decimal — not editable
99000757 Overhead Rate Δ BC27 Δ BC28 Decimal Specifies the item’s indirect cost as an absolute amount.
99000758 Rolled-up Subcontracted Cost − BC26 + BC27 Decimal — not editable
99000759 Rolled-up Mfg. Ovhd Cost − BC26 + BC27 Decimal — not editable
99000760 Rolled-up Cap. Overhead Cost − BC26 + BC27 Decimal — not editable
99000761 Planning Issues (Qty.) Δ BC27 Decimal — FlowField: sum(“Planning Component”.“Expected Quantity (Base)” where(“Item No.” = field(“No.”), “Due Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” …; not editable
99000762 Planning Receipt (Qty.) Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“No.”), “Due Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Co…; not editable
99000768 Planning Release (Qty.) Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“No.”), “Starting Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension…; not editable
99000770 Purch. Req. Receipt (Qty.) Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“No.”), “Variant Code” = field(“Variant Filter”), “Location Code” = field(“Location Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut …; not editable
99000771 Purch. Req. Release (Qty.) Δ BC27 Decimal — FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“No.”), “Location Code” = field(“Location Filter”), “Variant Code” = field(“Variant Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut …; not editable
99000773 Order Tracking Policy Δ BC28 Enum “Order Tracking Policy” Specifies if and how order tracking entries are created and maintained between supply and its corresponding demand. enum Enum 99000773 “Order Tracking Policy”
99000774 Prod. Forecast Quantity (Base) − BC26 + BC27 Decimal — FlowField: sum(Microsoft.Manufacturing.Forecast.“Production Forecast Entry”.“Forecast Quantity (Base)” where(“Item No.” = field(“No.”), “Production Forecast Name” = field(“Production Forecast Name”), “Forecast Date” = field(“Date Filter”), “Location Code” = field(“Location Filter”), “Component Forecast” = fiel…
99000775 Production Forecast Name − BC26 + BC27 Code[10] — TableRelation Table 99000851 “Production Forecast Name” (Microsoft.Manufacturing.Forecast.“Production Forecast Name”); FlowFilter
99000776 Component Forecast − BC26 + BC27 Boolean — FlowFilter
99000875 Critical Δ BC28 Boolean Specifies if the item is included in availability calculations to promise a shipment date for its parent item.
99000779 Single-Lvl Mat. Non-Invt. Cost + BC27 Decimal Specifies the total Non-inventory material cost of all components on the parent item’s BOM not editable
99000780 Allow Whse. Overpick + BC27 Boolean Specifies that the record is allowed to be created in the Warehouse Pick list against the Released Production Order more than the quantity defined in the component Line. For example, system will allow to create Pick for 10 units even if the component in the BOM is defined for 3 units.
99008500 Common Item No. Δ BC26 Δ BC28 Code[20] Specifies the unique common item number that the intercompany partners agree upon.

Keys

  • Key1: No. (clustered)
  • Key2: Search Description
  • Key3: Inventory Posting Group
  • Key4: Shelf No.
  • Key5: Vendor No.
  • Key6: Gen. Prod. Posting Group
  • Key7: Low-Level Code
  • Key10: Vendor Item No., Vendor No.
  • Key11: Common Item No.
  • Key13: Cost is Adjusted, Allow Online Adjustment
  • Key14: Description
  • Key15: Base Unit of Measure
  • Key16: Type
  • Key17: SystemModifiedAt
  • Key18: GTIN

Events published

  • OnUpdateItemUnitOfMeasureWeightOnBeforeCalcWeight(var Item: Record Item; var ItemUnitOfMeasure: Record "Item Unit of Measure") + BC29 (integration)
  • OnAfterCheckDocuments(var Item: Record Item; var xItem: Record Item; var CurrentFieldNo: Integer; CheckFieldNo: Integer; CheckFieldCaption: Text) + BC27 − BC27 (integration)
  • OnAfterDeleteRelatedData(Item: Record Item) (integration)
  • OnIsAssemblyItem(Item: Record Item; var Result: Boolean) + BC27 (integration)
  • OnIsMfgItem(Item: Record Item; var Result: Boolean) + BC27 (integration)
  • OnIsProductionBOM(Item: Record Item; var Result: Boolean) + BC27 (internal)
  • OnAfterIsMfgItem(Item: Record Item; var Result: Boolean) (integration)
  • OnAfterIsAssemblyItem(Item: Record Item; var Result: Boolean) (integration)
  • OnAfterValidateShortcutDimCode(var Item: Record Item; xItem: Record Item; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnAfterOnInsert(var Item: Record Item; var xItem: Record Item) (integration)
  • OnAfterSetLastDateTimeModified(var Item: Record Item) (integration)
  • OnBeforeAssistEdit(var Item: Record Item; var xItem: Record Item; var Result: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeCheckSNSpecificTrackingInteger(var Item: Record Item; var IsHandled: Boolean) (integration)
  • OnBeforeCheckUpdateFieldsForNonInventoriableItem(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeCreateItemUnitOfMeasure(var Item: Record Item; var ItemUnitOfMeasure: Record "Item Unit of Measure"; var IsHandled: Boolean) (integration)
  • OnBeforeCreateNewItem(var Item: Record Item; var ItemName: Text[100]) (integration)
  • OnBeforeOnDelete(var Item: Record Item; var IsHandled: Boolean) (integration)
  • OnBeforeOnInsert(var Item: Record Item; var IsHandled: Boolean; xRecItem: Record Item) (integration)
  • OnBeforeTestNoItemLedgEntiesExist(var Item: Record Item; CurrentFieldName: Text[100]; var IsHandled: Boolean) (integration)
  • OnBeforeTestNoOpenDocumentsWithTrackingExist(Item: Record Item; ItemTrackingCode2: Record "Item Tracking Code"; var IsHandled: Boolean) (integration)
  • OnBeforeTestNoOpenEntriesExist(Item: Record Item; var ItemLedgerEntry: Record "Item Ledger Entry"; CurrentFieldName: Text[100]; var IsHandled: Boolean) (integration)
  • OnBeforeTestNoPurchLinesExist(Item: Record Item; CurrentFieldName: Text[100]; var IsHandled: Boolean) (integration)
  • OnBeforeTestNoWhseEntriesExist(Item: Record Item; CurrentFieldName: Text; var IsHandled: Boolean) (integration)
  • OnBeforeUpdateQtyRoundingPrecisionForBaseUoM(var Item: Record Item; xItem: Record Item; var IsHandled: Boolean) (integration)
  • OnBeforeValidateShortcutDimCode(var Item: Record Item; xItem: Record Item; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnBeforeValidateStandardCost(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeValidateBaseUnitOfMeasure(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnValidateReplenishmentSystemCaseElse(var Item: Record Item) (integration)
  • OnValidateReplenishmentSystemCaseTransfer(var Item: Record Item; var IsHandled: Boolean) (integration)
  • OnFindItemVendOnAfterSetFilters(var ItemVend: Record "Item Vendor"; Item: Record Item) (integration)
  • OnPickItemOnBeforeFindFirstItem(var Item: Record Item) + BC28 (integration)
  • OnTryGetItemNoOpenCardOnAfterSetItemFilters(var Item: Record Item; var ItemFilterContains: Text) (integration)
  • OnValidateBaseUnitOfMeasure(var ValidateBaseUnitOfMeasure: Boolean) (integration)
  • OnValidatePhysInvtCountingPeriodCodeOnBeforeConfirmUpdate(var Item: Record Item; xItem: Record Item; PhysInvtCountPeriod: Record "Phys. Invt. Counting Period"; var IsHandled: Boolean) (integration)
  • OnBeforeUpdateReplenishmentSystem(var Item: Record Item; var IsHandled: Boolean; var Result: Boolean) (integration)
  • OnValidateReplenishmentSystemCaseAssemblyr(var Item: Record Item; var IsHandled: Boolean) (integration)
  • OnBeforeValidateUnitCost(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnTryGetItemNoOpenCardWithViewOnBeforeShowCreateItemOption(var Item: Record Item) (integration)
  • OnAfterValidateItemCategoryCode(var Item: Record Item; xItem: Record Item) (integration)
  • OnValidateOrderTrackingPolicyOnBeforeUpdateReservation(var Item: Record Item; var ShouldRaiseRegenerativePlanningMessage: Boolean) (integration)
  • OnCalcVATOnAfterVATPostingSetupGet(var VATPostingSetup: Record "VAT Posting Setup") (integration)
  • OnBeforeCheckDocuments(Item: Record Item; CurrentFieldNo: Integer; var IsHandled: Boolean) + BC25 (integration)
  • OnBeforeCheckReqLine(Item: Record Item; CurrentFieldNo: Integer; CheckFieldNo: Integer; CheckFieldCaption: Text; var IsHandled: Boolean) (integration)
  • OnBeforeCheckItemJnlLine(Item: Record Item; CurrentFieldNo: Integer; CheckFieldNo: Integer; CheckFieldCaption: Text; var IsHandled: Boolean) (integration)
  • OnBeforeIsVariantMandatory(ItemNo: Code[20]; var IsHandled: Boolean; var Result: Boolean) (integration)
  • OnBeforeValidateNo(var IsHandled: Boolean; var Item: Record Item; xItem: Record Item; InventorySetup: Record "Inventory Setup") Δ BC24 + BC27 − BC27 (integration)
  • OnBeforeFindItemVend(var Item: Record Item; var ItemVendor: Record "Item Vendor"; LocationCode: Code[10]; var IsHandled: Boolean) (integration)
  • OnModifyOnBeforePlanningAssignmentItemChange(var Item: Record Item; xItem: Record Item; PlanningAssignment: Record "Planning Assignment"; var IsHandled: Boolean) (integration)
  • OnAfterFindItemVend(var ItemVendor: Record "Item Vendor"; Item: Record Item; StockkeepingUnit: Record "Stockkeeping Unit"; LocationCode: Code[10]) (integration)
  • OnValidateTypeOnBeforeCheckExistsItemLedgerEntry(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeCheckStdCostWksh(var Item: Record Item; CurrentFieldNo: Integer; var IsHandled: Boolean) + BC24 (integration)
  • OnAfterHasBOM(var Item: Record Item; var Result: Boolean) + BC26 (integration)
  • OnAfterHasRoutingNo(var Item: Record Item; var Result: Boolean) + BC27 (integration)
  • OnAfterCheckUpdateFieldsForNonInventoriableItem(var Item: Record Item) + BC26 (integration)
  • OnValidateItemTrackingCodeOnBeforeTestNoEntriesExist(var Item: Record Item; xItem: Record Item; CallingFieldNo: Integer; var IsHandled: Boolean) + BC24 (integration)
  • OnValidateGenProdPostingGroupOnConfirmChange(var Item: Record Item; xItemGenProdPostingGroupCode: Code[20]; var ShouldExit: Boolean) + BC26 (integration)
  • OnAfterUpdateItemCategoryId(var Item: Record Item; var ItemCategory: Record "Item Category") + BC24 (integration)
  • OnFindItemVendOnAfterFindItemVend(var ItemVendor: Record "Item Vendor"; Item: Record Item; var StockkeepingUnit: Record "Stockkeeping Unit"; LocationCode: Code[10]) + BC25 (integration)
  • OnInsertOnAfterAssignNo(var Item: Record Item; xItem: Record Item) + BC26 (integration)
  • OnAssistEditOnAfterAssignNo(var Item: Record Item; xItem: Record Item) + BC26 (integration)
  • OnCalcScheduledReceiptQty(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcQtyOnComponentLines(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcQtyOnProdOrder(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcResQtyonProdOrderComp(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcReservedQtyOnProdOrder(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcPlannedOrderReceiptQty(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcFPOrderReceiptQty(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcRelOrderReceiptQty(var Item: Record Item; var Result: Decimal) + BC27 (integration)
  • OnCalcQtyOnServiceOrder(var Item: Record Item; var Result: Decimal) + BC28 (integration)
  • OnShouldTryCostFromSKUOnCheckSKUCostOnMfg(var ShouldExit: Boolean) + BC27 (internal)
  • OnBeforeGetFirstItemNoFromLookup(ItemText: Text; var FoundItemNo: Code[20]; var SuppressAdvancedItemSearch: Boolean; var IsHandled: Boolean) + BC28 (integration): Raised before the GetFirstItemNoFromLookup procedure resolves an item number from the given text.

Trigger event subscribers

Procedures

  • AssistEdit(): Boolean
  • FindItemVend(var ItemVend: Record "Item Vendor"; LocationCode: Code[10])
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • TestNoEntriesExist(CurrentFieldName: Text[100])
  • TestNoWhseEntriesExist(CurrentFieldName: Text) Δ BC24
  • TestNoOpenEntriesExist(CurrentFieldName: Text[100])
  • ItemSKUGet(var Item: Record Item; LocationCode: Code[10]; VariantCode: Code[10])
  • GetSKU(LocationCode: Code[10]; VariantCode: Code[10]): Record "Stockkeeping Unit" temporary
  • IsMfgItem(): Boolean
  • IsProductionBOM(): Boolean + BC27
  • IsAssemblyItem(): Boolean
  • HasBOM(): Boolean
  • HasRoutingNo(): Boolean + BC27
  • CheckSerialNoQty(ItemNo: Code[20]; FieldName: Text[30]; Quantity: Decimal)
  • CheckBlockedByApplWorksheet()
  • CheckJournalsAndWorksheets(CurrFieldNo: Integer)
  • CheckDocuments(CurrentFieldNo: Integer) + BC27
  • CheckDocuments(CurrentFieldNo: Integer; CheckFieldNo: Integer; CheckFieldCaption: Text) + BC27
  • GetCannotChangeItemWithExistingDocumentLinesErr(): Text + BC25
  • GetCannotDeleteItemWithExistingDocumentLinesErr(): Text + BC25
  • CheckTransLine(CurrentFieldNo: Integer; CheckFieldNo: Integer; CheckFieldCaption: Text)
  • CheckUpdateFieldsForNonInventoriableItem() Δ BC24
  • PreventNegativeInventory(): Boolean
  • CalcVAT(): Decimal Δ BC24
  • CalcUnitPriceExclVAT(): Decimal
  • GetFirstItemNoFromLookup(ItemText: Text): Code[20] + BC27
  • GetItemNo(ItemText: Text): Code[20]
  • ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type")
  • TryGetItemNo(var ReturnValue: Text[50]; ItemText: Text; DefaultCreate: Boolean): Boolean
  • TryGetItemNoOpenCard(var ReturnValue: Text; ItemText: Text; DefaultCreate: Boolean; ShowItemCard: Boolean; ShowCreateItemOption: Boolean): Boolean
  • TryGetItemNoOpenCardWithView(var ReturnValue: Text; ItemText: Text; DefaultCreate: Boolean; ShowItemCard: Boolean; ShowCreateItemOption: Boolean; View: Text): Boolean (internal)
  • ShouldTryCostFromSKU(): Boolean + BC27
  • PickItem(var Item: Record Item): Code[20]
  • SetLastDateTimeModified()
  • SetLastDateTimeFilter(DateFilter: DateTime)
  • UpdateCostIsAdjusted() + BC26
  • UpdateReplenishmentSystem(): Boolean
  • UpdateUnitOfMeasureId()
  • UpdateItemCategoryId()
  • UpdateTaxGroupId()
  • UpdateReferencedIds()
  • GetReferencedIds(var TempField: Record "Field" temporary)
  • IsServiceType(): Boolean
  • IsNonInventoriableType(): Boolean
  • IsInventoriableType(): Boolean
  • IsVariantMandatory(IsTypeItem: Boolean; ItemNo: Code[20]): Boolean
  • IsVariantMandatory(): Boolean
  • IsVariantMandatory(InvtSetupDefaultSetting: boolean): Boolean (internal)
  • CalcScheduledReceiptQty(): Decimal + BC27
  • CalcQtyOnComponentLines(): Decimal + BC27
  • CalcQtyOnProdOrder(): Decimal + BC27
  • CalcResQtyonProdOrderComp(): Decimal + BC27
  • CalcReservedQtyOnProdOrder(): Decimal + BC27
  • CalcPlannedOrderReceiptQty(): Decimal + BC27
  • CalcFPOrderReceiptQty(): Decimal + BC27
  • CalcRelOrderReceiptQty(): Decimal + BC27
  • CalcQtyOnServiceOrder(): Decimal + BC28
  • ExistsItemLedgerEntry(): Boolean
  • ItemTrackingCodeUseExpirationDates(): Boolean
  • UpdateMyItem(CallingFieldNo: Integer) + BC26 Δ BC29

Plus 27 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

265 fields in 209 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

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

Countries that replace it

AU, CA, CH, ES, GB, IT, MX, NZ, RU, US

Deprecations

  • field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”

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

Evidence 1 sources