Table 5700 "Stockkeeping Unit"

Base Application · Microsoft.Inventory.Location · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Stockkeeping Unit
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. Δ BC25 Δ BC28	Code[20]	Specifies the item number to which the SKU applies.	TableRelation Table 27 “Item” (Item where(Type = const(Inventory))); NotBlank
2	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”)))
3	Location Code Δ BC28	Code[10]	Specifies the location code (for example, the warehouse or distribution center) to which the SKU applies.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
4	Description Δ BC24 Δ BC25 Δ BC26 Δ BC28	Text[100]	Specifies the description from the Item Card.	FlowField: lookup(Item.Description where(“No.” = field(“Item No.”))); not editable
5	Description 2 Δ BC24 Δ BC25 Δ BC26	Text[50]	—	FlowField: lookup(Item.“Description 2” where(“No.” = field(“Item No.”))); not editable
6	Assembly BOM Δ BC28	Boolean	Specifies if the item is an assembly BOM.	FlowField: exist(“BOM Component” where(“Parent Item No.” = field(“Item No.”))); not editable
12	Shelf No. Δ BC28	Code[10]	Specifies where to find the SKU in the warehouse.
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. Warning: If the SKU is supplied through production, then this field is not used when invoicing and adjusting the actual cost of the produce…
25	Last Direct Cost Δ BC28	Decimal	Specifies the most recent direct unit cost that was paid for the SKU.
31	Vendor No. Δ BC28	Code[20]	Specifies for the SKU, the same as the field does on the item card.	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 Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
35	Maximum Inventory Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
36	Reorder Quantity Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
53	Comment	Boolean	—	FlowField: exist(“Stockkeeping Unit Comment Line” where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Location Code” = field(“Location Code”))); not editable
62	Last Date Modified Δ BC28	Date	Specifies when the SKU card was last modified.	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
68	Inventory Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.	FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Drop Shipment” = field(“Drop Shipment Filter”), “Variant C…; not editable
84	Qty. on Purch. Order Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.	FlowField: sum(“Purchase Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(Order), Type = const(Item), “No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filte…; not editable
85	Qty. on Sales Order Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.	FlowField: sum(“Sales Line”.“Outstanding Qty. (Base)” where(“Document Type” = const(Order), Type = const(Item), “No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”)…; not editable
89	Drop Shipment Filter	Boolean	—	FlowFilter
910	Assembly Policy Δ BC28	Enum “Assembly Policy”	Specifies which default order flow is used to supply this SKU by assembly.	enum Enum 910 “Assembly Policy”
977	Qty. on Assembly Order Δ BC28	Decimal	Specifies how many units of the SKU are allocated to assembly orders, which is how many are listed on outstanding assembly order headers.	FlowField: sum(“Assembly Header”.“Remaining Quantity (Base)” where(“Document Type” = const(Order), “Item No.” = field(“Item No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Location Code”), “Varia…; not editable
978	Qty. on Asm. Component Δ BC28	Decimal	Specifies how many item units are allocated as assembly components, which is how many units are on outstanding assembly order lines.	FlowField: sum(“Assembly Line”.“Remaining Quantity (Base)” where(“Document Type” = const(Order), Type = const(Item), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “No.” = field(“Item No.”), “Location Code” = field(“Location C…; not editable
1001	Qty. on Job Order Δ BC24 Δ 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(“Item No.”), “Location Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Planning Date” = field(“Date Filter”))); not editable
5400	Transfer-Level Code	Integer	—	not editable
5401	Lot Size Δ BC26 Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
5410	Discrete Order Quantity	Integer	—
5411	Minimum Order Quantity Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
5412	Maximum Order Quantity Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
5413	Safety Stock Quantity Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
5414	Order Multiple Δ BC28	Decimal	Specifies for the SKU, the same as the field does on the item card.
5415	Safety Lead Time Δ BC28	DateFormula	Specifies for the SKU, the same as the field does on the item card.
5416	Components at Location Δ BC28	Code[10]	Specifies the inventory location from where the production order components are to be taken when producing this SKU.	TableRelation Table 14 “Location”
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 that is created by the planning system when the SKU needs to be replenished.	enum Enum 5419 “Replenishment System”
5423	Bin Filter	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))); FlowFilter
5428	Time Bucket Δ BC28	DateFormula	Specifies a time period for the recurring planning horizon of the SKU when you use Fixed Reorder Qty. or Maximum Qty. reordering policies.
5440	Reordering Policy Δ BC28	Enum “Reordering Policy”	Specifies for the SKU, the same as the field does on the item card.	enum Enum 5440 “Reordering Policy”
5441	Include Inventory Δ BC28	Boolean	Specifies for the SKU, the same as the field does on the item card.
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 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, if the quantity by which the supply would change 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 existing supply orders.
5448	Plan Minimal Supply + BC24	Boolean	—
5700	Transfer-from Code Δ BC28	Code[10]	Specifies the code of the location that items are transferred from.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
5701	Qty. in Transit Δ BC28	Decimal	Specifies the quantity of the SKUs in transit. These items have been shipped, but not yet received.	FlowField: sum(“Transfer Line”.“Qty. in Transit (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“Item No.”), “Transfer-to Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = …; not editable
5702	Trans. Ord. Receipt (Qty.) Δ BC28	Decimal	Specifies the quantity of the item units that remains to be received but are not yet shipped as the difference between the Quantity and the Quantity Shipped fields. via Page 5700 “Stockkeeping Unit Card”	FlowField: sum(“Transfer Line”.“Outstanding Qty. (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“Item No.”), “Transfer-to Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” =…; not editable
5703	Trans. Ord. Shipment (Qty.) Δ BC28	Decimal	Specifies the quantity of the item units that remains to be shipped as the difference between the Quantity and the Quantity Shipped fields. via Page 5700 “Stockkeeping Unit Card”	FlowField: sum(“Transfer Line”.“Outstanding Qty. (Base)” where(“Derived From Line No.” = const(0), “Item No.” = field(“Item No.”), “Transfer-from Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code”…; not editable
7301	Special Equipment Code Δ BC28	Code[10]	Specifies the code of the equipment that you need to use when working with the SKU.	TableRelation Table 7305 “Special Equipment” (Special Equipment)
7302	Put-away Template Code Δ BC28	Code[10]	Specifies the put-away template that the program uses when it performs a put-away for the SKU.	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 unit of measure that the program uses when it performs a put-away for the SKU.	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))
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 SKU 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.	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 SKU to the item ledger.	FlowField: max(“Phys. Inventory Ledger Entry”.“Posting Date” where(“Item No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Phys Invt Counting Period Type” = filter(” “ \| SKU))); not editable
7384	Use Cross-Docking Δ BC28	Boolean	Specifies if the SKU can be cross-docked.
7385	Next Counting Start Date Δ BC28	Date	Specifies the starting date of the next counting period.
7386	Next Counting End Date Δ BC28	Date	Specifies the ending date of the next counting period.
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(“Item No.”), “Location Code” = field(“Location Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension …; 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(“Item No.”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Location Code” = field(“Lo…; not editable
99000770	Purch. Req. Receipt (Qty.) Δ BC28	Decimal	—	FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Fi…
99000771	Purch. Req. Release (Qty.) Δ BC28	Decimal	—	FlowField: sum(“Requisition Line”.“Quantity (Base)” where(Type = const(Item), “No.” = field(“Item No.”), “Location Code” = field(“Location Code”), “Variant Code” = field(“Variant Code”), “Shortcut Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Shortcut Dimension 2 Code” = field(“Global Dimension 2 Fi…
5404	Rolled-up Material Cost + BC26 Δ BC28	Decimal	—	not editable
5405	Rolled-up Capacity Cost + BC26 Δ BC28	Decimal	—	not editable
5407	Scrap % + BC26 Δ BC28	Decimal	—
5408	Rolled-up Mat. Non-Invt. Cost + BC26 Δ BC28	Decimal	Rolled-up Material Non-Inventory Cost caption	not editable
99000752	Single-Level Material Cost + BC27 Δ BC28	Decimal	—	not editable
99000753	Single-Level Capacity Cost + BC27 Δ BC28	Decimal	—	not editable
99000754	Single-Level Subcontrd. Cost + BC27 Δ BC28	Decimal	—	not editable
99000755	Single-Level Cap. Ovhd Cost + BC27 Δ BC28	Decimal	—	not editable
99000756	Single-Level Mfg. Ovhd Cost + BC27 Δ BC28	Decimal	—	not editable
99000758	Rolled-up Subcontracted Cost + BC27 Δ BC28	Decimal	—	not editable
99000759	Rolled-up Mfg. Ovhd Cost + BC27 Δ BC28	Decimal	—	not editable
99000760	Rolled-up Cap. Overhead Cost + BC27 Δ BC28	Decimal	—	not editable
99000779	Single-Lvl Mat. Non-Invt. Cost + BC27 Δ BC28	Decimal	Single-Level Material Non-Inventory Cost caption	not editable

Keys

Key1: Location Code, Item No., Variant Code (clustered)
Key2: Replenishment System, Vendor No., Transfer-from Code
Key3: Item No., Location Code, Variant Code
Key4: Item No., Transfer-Level Code

Events published

OnAfterCopyFromItem(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item) (integration)
OnBeforeCopyFromItem(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item; var IsHandled: Boolean) (integration)
OnBeforeCheckTransferRoute(var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean) (integration)
OnBeforeValidateStandardCost(var StockkeepingUnit: Record "Stockkeeping Unit"; xStockkeepingUnit: Record "Stockkeeping Unit"; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
- subscribers: Codeunit 99000758 “Mfg. Cost Calculation Mgt.” OnBeforeValidateSKUStandardCost
OnValidateTransferfromCodeOnBeforeModify(var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean) (integration)
OnValidateReplenishmentSystemCaseElse(var StockkeepingUnit: Record "Stockkeeping Unit") (integration)

Trigger event subscribers

OnAfterValidateEvent(Item No.): Codeunit 99000795 “Mfg. Item Integration” OnAfterValidateEventItemNo
OnAfterValidateEvent(Location Code): Codeunit 99000795 “Mfg. Item Integration” LocationOnAfterValidateEventLocationCode
OnAfterValidateEvent(Variant Code): Codeunit 99000795 “Mfg. Item Integration” LocationOnAfterValidateEventVariantCode

Procedures

IsMfgSKU(): Boolean + BC26
IsAssemblySKU(): Boolean + BC26
TestNoEntriesExist(CurrentFieldName: Text[100]) (protected)
UpdateTempSKUTransferLevels(FromSKU: Record "Stockkeeping Unit"; var TempToSKU: Record "Stockkeeping Unit" temporary; FromLocationCode: Code[10]): Boolean
SetHideValidationDialog(NewHideValidationDialog: Boolean)
CopyFromItem(Item: Record Item)
TransferManufCostsFromItem(Item: Record Item) + BC27

Plus 5 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

drill-down page Page 5701 “Stockkeeping Unit List”
lookup page Page 5701 “Stockkeeping Unit List”
Qty. on Job Order: CalcFormula Table 1003 “Job Planning Line”
Components at Location: TableRelation Table 14 “Location”
Location Code: TableRelation Table 14 “Location”
Transfer-from Code: TableRelation Table 14 “Location”
Vendor No.: TableRelation Table 23 “Vendor”
Purch. Req. Receipt (Qty.): CalcFormula Table 246 “Requisition Line”
Purch. Req. Release (Qty.): CalcFormula Table 246 “Requisition Line”
Description: CalcFormula Table 27 “Item”
Item No.: TableRelation Table 27 “Item”
Last Phys. Invt. Date: CalcFormula Table 281 “Phys. Inventory Ledger Entry”
Inventory: CalcFormula Table 32 “Item Ledger Entry”
Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
Qty. on Blanket Sales Order: CalcFormula Table 37 “Sales Line”
Qty. on Sales Order: CalcFormula Table 37 “Sales Line”
Qty. on Blanket Purch. Order: CalcFormula Table 39 “Purchase Line”
Qty. on Purch. Order: CalcFormula Table 39 “Purchase Line”
Variant Code: TableRelation Table 5401 “Item Variant”
Put-away Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Comment: CalcFormula Table 5701 “Stockkeeping Unit Comment Line”
Qty. in Transit: CalcFormula Table 5741 “Transfer Line”
Trans. Ord. Receipt (Qty.): CalcFormula Table 5741 “Transfer Line”
Trans. Ord. Shipment (Qty.): CalcFormula Table 5741 “Transfer Line”
Special Equipment Code: TableRelation Table 7305 “Special Equipment”
Put-away Template Code: TableRelation Table 7307 “Put-away Template Header”
Bin Filter: TableRelation Table 7354 “Bin”
Phys Invt Counting Period Code: TableRelation Table 7381 “Phys. Invt. Counting Period”
Assembly BOM: CalcFormula Table 90 “BOM Component”
Qty. on Assembly Order: CalcFormula Table 900 “Assembly Header”
Qty. on Asm. Component: CalcFormula Table 901 “Assembly Line”

Referenced by

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

Table 27 “Item”: Stockkeeping Unit Exists
Table 7354 “Bin”: Variant Filter

Pages and codeunits on this table

Page 5700 “Stockkeeping Unit Card” (source table)
Page 5701 “Stockkeeping Unit List” (source 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: "Stockkeeping Unit"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.