Table 1382 "Item Templ."
Base Application · Microsoft.Inventory.Item
Across versions
- BC23present
- BC241 fields added, 1 events added
- BC251 fields removed
- BC266 fields removed, 5 fields changed
- BC274 fields added, 1 fields changed
- BC2883 fields changed
- BC29-30unchanged
Neighbourhood 36 connected objects and pages
Base Application · Microsoft.Inventory.Item · captioned “Item Template” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1378 “Select Item Templ. List” (2 Learn pages), Page 1383 “Item Templ. List” (2), Page 1384 “Item Templ. Card” (2).
Properties
| Property | Value |
|---|---|
| Caption | Item Template |
| 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 | Code Δ BC28 | Code[20] | Specifies the code of the template. | NotBlank |
| 2 | Description Δ BC28 | Text[100] | Specifies the description of the template. | |
| 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 whether 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. Δ 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 whether to include the item when calculating 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 Δ 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 % Δ 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 Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 24 | Standard Cost Δ 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. | |
| 28 | Indirect Cost % Δ 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. | |
| 31 | Vendor No. Δ BC28 | Code[20] | Specifies the vendor code of who supplies this item by default. | TableRelation Table 23 “Vendor” |
| 32 | Vendor Item No. Δ 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 Δ BC28 | Decimal | Specifies a stock quantity that sets the inventory below the level that you must replenish the item. | |
| 35 | Maximum Inventory Δ BC28 | Decimal | Specifies a quantity that you want to use as a maximum inventory level. | |
| 36 | Reorder Quantity Δ BC28 | Decimal | Specifies a standard lot size quantity to be used for all order proposals. | |
| 37 | Alternative Item No. | Code[20] | — | TableRelation Table 27 “Item” |
| 38 | Unit List Price Δ BC28 | Decimal | — | |
| 39 | Duty Due % Δ BC28 | Decimal | — | |
| 40 | Duty Code | Code[10] | — | |
| 41 | Gross Weight Δ BC28 | Decimal | Specifies the gross weight of the item. | |
| 42 | Net Weight Δ BC28 | Decimal | Specifies the net weight of the item. | |
| 43 | Units per Parcel Δ BC28 | Decimal | — | |
| 44 | Unit Volume Δ BC28 | Decimal | Specifies the volume of one unit of the item. | |
| 45 | Durability | Code[10] | — | |
| 46 | Freight Type | Code[10] | — | |
| 47 | Tariff No. Δ BC28 | Code[20] | Specifies a code for the item’s tariff number. | TableRelation Table 260 “Tariff Number” (Tariff Number) |
| 48 | Duty Unit Conversion Δ BC28 | Decimal | — | |
| 49 | Country/Region Purchased Code | Code[10] | — | TableRelation Table 9 “Country/Region” (Country/Region) |
| 50 | Budget Quantity Δ BC28 | Decimal | — | |
| 51 | Budgeted Amount Δ BC28 | Decimal | — | |
| 52 | Budget Profit Δ BC28 | Decimal | — | |
| 54 | Blocked Δ BC28 | Boolean | Specifies that the related record is blocked from being posted in transactions, for example an item that is placed in quarantine. | |
| 56 | Block Reason | Text[250] | — | |
| 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. | |
| 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 1384 “Item Templ. 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) |
| 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 Δ BC28 | Code[20] | Specifies the number series that will be used to assign numbers to items. | TableRelation Table 308 “No. Series” (No. Series) |
| 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 specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | 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” |
| 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))) |
| 120 | Stockout Warning | Option | — | OptionCaption: Default,No,Yes |
| 121 | Prevent Negative Inventory | Option | — | 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 |
| 910 | Assembly Policy Δ BC28 | Enum “Assembly Policy” | Specifies which default order flow is used to supply this assembly item. | enum Enum 910 “Assembly Policy” |
| 1217 | GTIN Δ BC28 | Code[14] | Specifies the Global Trade Item Number (GTIN) for the item. For example, the GTIN is used with bar codes to track items, and when sending and receiving documents electronically. The GTIN number typically contains a Universal Product Code (UPC), or European Article Number (EAN). | |
| 1700 | Default Deferral Template Code Δ BC28 | Code[10] | Specifies how revenue or expenses for the item are deferred to other accounting periods by default. | TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”) |
| 5401 | Lot Size Δ BC26 Δ BC28 | 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 99000752 “Mfg. Item Templ. 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) |
| 5407 | Scrap % Δ BC26 Δ BC28 | Decimal | Specifies the percentage of the item that you expect to be scrapped in the production process. via Page extension 99000752 “Mfg. Item Templ. Card” | |
| 5408 | Rolled-up Mat. Non-Invt. Cost + BC26 Δ BC28 | Decimal | Rolled-up Material Non-Inventory Cost caption | |
| 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 Δ BC28 | Decimal | Specifies a minimum allowable quantity for an item order proposal. | |
| 5412 | Maximum Order Quantity Δ BC28 | Decimal | Specifies a maximum allowable quantity for an item order proposal. | |
| 5413 | Safety Stock Quantity Δ 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 Δ 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 | 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… via Page extension 99000752 “Mfg. Item Templ. Card” | 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 Δ BC28 | Decimal | Specifies how calculated consumption quantities are rounded when entered on consumption journal lines. via Page extension 99000752 “Mfg. Item Templ. Card” | |
| 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. | |
| 5440 | Reordering Policy Δ BC28 | Enum “Reordering Policy” | Specifies the reordering policy. | 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 | Enum Microsoft.Manufacturing.Setup.“Manufacturing Policy” | Specifies if additional orders for any related components are calculated. via Page extension 99000752 “Mfg. Item Templ. Card” | 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 forward. The dampener period limits the number of insignificant rescheduling of existing supply to a later date if that new date is within the dampener period. The dampener per… | |
| 5446 | Dampener Quantity Δ 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 Δ BC28 | Decimal | Specifies a quantity you allow projected inventory to exceed the reorder point, before the system suggests to decrease supply orders. | |
| 5701 | Manufacturer Code Δ BC28 | Code[10] | Specifies a code for the manufacturer of the catalog item. | TableRelation Table 5720 “Manufacturer” |
| 5702 | Item Category Code Δ 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) |
| 5711 | Purchasing Code Δ BC28 | Code[10] | Specifies the code for a special procurement method, such as drop shipment. | TableRelation Table 5721 “Purchasing” |
| 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. | |
| 6500 | Item Tracking Code Δ 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) |
| 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) |
| 7300 | Warehouse Class Code Δ BC28 | Code[10] | Specifies the warehouse class code for the item. | TableRelation Table 7304 “Warehouse Class” (Warehouse Class) |
| 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) |
| 7384 | Use Cross-Docking Δ BC28 | Boolean | Specifies if this item can be cross-docked. | |
| 8003 | Sales Blocked Δ BC28 | Boolean | Specifies that the item cannot be entered on sales documents, except return orders and credit memos, and journals. | |
| 8004 | Purchasing Blocked Δ BC28 | Boolean | Specifies that the item cannot be entered on purchase documents, except return orders and credit memos, and journals. | |
| 8010 | Service Blocked + BC24 | Boolean | Specifies that the item cannot be entered on service items, service contracts and service documents, except credit memos. via Page extension 6464 “Serv. Item Templ. Card” | |
| 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) |
| 99000757 | Overhead Rate Δ BC26 Δ BC28 | Decimal | Specifies the item’s indirect cost as an absolute amount. via Page extension 99000752 “Mfg. Item Templ. Card” | |
| 99000773 | Order Tracking Policy − BC26 + BC27 Δ 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” |
| 99000875 | Critical − BC26 + BC27 Δ BC28 | Boolean | Specifies if the item is included in availability calculations to promise a shipment date for its parent item. | |
| 99008500 | Common Item No. − BC26 + BC27 Δ BC28 | Code[20] | Specifies the unique common item number that the intercompany partners agree upon. |
Keys
- Key1: Code (clustered)
- CategoryKey: Item Category Code
Events published
OnAfterCopyFromTemplate(SourceItemTempl: Record "Item Templ."; var ItemTempl: Record "Item Templ.")(integration)OnCopyTemplateOnBeforeModify(SourceItemTempl: Record "Item Templ."; SavedItemTempl: Record "Item Templ."; var ItemTempl: Record "Item Templ.")(integration)OnBeforeValidateItemField(var ItemTempl: record "Item Templ."; FieldId: Integer; var IsHandled: Boolean)(integration)OnAfterTransferFieldValues(var SrcRecRef: RecordRef; var DestRecRef: RecordRef; Reverse: Boolean)(integration)OnTransferFieldValuesOnBeforeTransferFieldValue(var SrcFieldRef: FieldRef; var DestFieldRef: FieldRef; Reverse: Boolean; var IsHandled: Boolean)+ BC24 (integration)
Procedures
CopyFromTemplate(SourceItemTempl: Record "Item Templ.")ValidateItemField(FieldId: Integer)
Plus 4 local procedures.
Triggers
OnDelete, OnRename
Relations
- drill-down page Page 1383 “Item Templ. List”
- lookup page Page 1383 “Item Templ. List”
- Default Deferral Template Code: TableRelation Table 1700 “Deferral Template”
- Base Unit of Measure: TableRelation Table 204 “Unit of Measure”
- Vendor No.: TableRelation Table 23 “Vendor”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Tariff No.: TableRelation Table 260 “Tariff Number”
- Alternative Item No.: TableRelation Table 27 “Item”
- Lot Nos.: TableRelation Table 308 “No. Series”
- No. Series: TableRelation Table 308 “No. Series”
- Serial Nos.: TableRelation Table 308 “No. Series”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Gr. (Price): TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Item Disc. Group: TableRelation Table 341 “Item Discount Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Manufacturer Code: TableRelation Table 5720 “Manufacturer”
- Purchasing Code: TableRelation Table 5721 “Purchasing”
- Item Category Code: TableRelation Table 5722 “Item Category”
- Item Tracking Code: TableRelation Table 6502 “Item Tracking Code”
- Warehouse Class Code: TableRelation Table 7304 “Warehouse Class”
- Special Equipment Code: TableRelation Table 7305 “Special Equipment”
- Put-away Template Code: TableRelation Table 7307 “Put-away Template Header”
- Phys Invt Counting Period Code: TableRelation Table 7381 “Phys. Invt. Counting Period”
- Over-Receipt Code: TableRelation Table 8510 “Over-Receipt Code”
- Country/Region of Origin Code: TableRelation Table 9 “Country/Region”
- Country/Region Purchased Code: TableRelation Table 9 “Country/Region”
- Inventory Posting Group: TableRelation Table 94 “Inventory Posting Group”
Referenced by
3 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 30102 “Shpfy Shop”: Item Templ. Code
- Table 30128 “Shpfy Shop Collection Map”: Item Templ. Code
- Table 5718 “Nonstock Item”: Item Templ. Code
Pages and codeunits on this table
- Page 1378 “Select Item Templ. List” (source table)
- Page 1383 “Item Templ. List” (source table)
- Page 1384 “Item Templ. Card” (source table)
Extended by
- Table extension 4820 “Intrastat Report Item Templ.”
- Table extension 6453 “Serv. Item Templ.”
- Table extension 8095 “Item Templ.”
- Table extension 99000757 “Mfg. Item Templ.”
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.
- Codeunit 408 “DimensionManagement” (3 calls:
OnRename → RenameDefaultDim,ValidateShortcutDimCode → SaveDefaultDim,ValidateShortcutDimCode → ValidateDimValueCode)
Countries that replace it
AU, CA, CH, ES, GB, IT, MX, NZ, US
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 Templ."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.