Table "Stockkeeping Unit"
Properties
| Name | Value |
|---|---|
| Caption | Stockkeeping Unit |
| DrillDownPageID | Page Microsoft.Inventory.Location."Stockkeeping Unit List" |
| LookupPageID | Page Microsoft.Inventory.Location."Stockkeeping Unit List" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Item No." | Code[20] | Specifies the item number to which the SKU applies. |
| "Variant Code" | Code[10] | Specifies the variant of the item on the line. |
| "Location Code" | Code[10] | Specifies the location code (for example, the warehouse or distribution center) to which the SKU applies. |
| Description | Text[100] | Specifies the description from the Item Card. |
| "Description 2" | Text[50] | |
| "Assembly BOM" | Boolean | Specifies if the item is an assembly BOM. |
| "Shelf No." | Code[10] | Specifies where to find the SKU in the warehouse. |
| "Unit Cost" | Decimal | Specifies the cost of one unit of the item or resource on the line. |
| "Standard Cost" | 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 produced item. Instead, the Standard Cost field on the underlying item card is used, and any variances are calculated against the cost shares of that item. |
| "Last Direct Cost" | Decimal | Specifies the most recent direct unit cost that was paid for the SKU. |
| "Vendor No." | Code[20] | Specifies for the SKU, the same as the field does on the item card. |
| "Vendor Item No." | Text[50] | Specifies the number that the vendor uses for this item. |
| "Lead Time Calculation" | DateFormula | Specifies a date formula for the amount of time it takes to replenish the item. |
| "Reorder Point" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Maximum Inventory" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Reorder Quantity" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| Comment | Boolean | |
| "Last Date Modified" | Date | Specifies when the SKU card was last modified. |
| "Date Filter" | Date | |
| "Global Dimension 1 Filter" | Code[20] | |
| "Global Dimension 2 Filter" | Code[20] | |
| Inventory | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Qty. on Purch. Order" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Qty. on Sales Order" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Drop Shipment Filter" | Boolean | |
| "Assembly Policy" | Enum Microsoft.Assembly.Setup."Assembly Policy" | Specifies which default order flow is used to supply this SKU by assembly. |
| "Qty. on Assembly Order" | Decimal | Specifies how many units of the SKU are allocated to assembly orders, which is how many are listed on outstanding assembly order headers. |
| "Qty. on Asm. Component" | Decimal | Specifies how many item units are allocated as assembly components, which is how many units are on outstanding assembly order lines. |
| "Qty. on Job Order" | Decimal | Specifies how many units of the item are allocated to projects, meaning listed on outstanding project planning lines. |
| "Transfer-Level Code" | Integer | |
| "Lot Size" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Discrete Order Quantity" | Integer | |
| "Minimum Order Quantity" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Maximum Order Quantity" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Safety Stock Quantity" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Order Multiple" | Decimal | Specifies for the SKU, the same as the field does on the item card. |
| "Safety Lead Time" | DateFormula | Specifies for the SKU, the same as the field does on the item card. |
| "Components at Location" | Code[10] | Specifies the inventory location from where the production order components are to be taken when producing this SKU. |
| "Flushing Method" | 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. Backward: Automatically calculates and posts consumption according to the production order component lines when the production order is finished. Pick + Forward / Pick + Backward: Variations with warehousing. |
| "Replenishment System" | Enum Microsoft.Inventory.Item."Replenishment System" | Specifies the type of supply order that is created by the planning system when the SKU needs to be replenished. |
| "Bin Filter" | Code[20] | |
| "Time Bucket" | DateFormula | Specifies a time period for the recurring planning horizon of the SKU when you use Fixed Reorder Qty. or Maximum Qty. reordering policies. |
| "Reordering Policy" | Enum Microsoft.Inventory.Item."Reordering Policy" | Specifies for the SKU, the same as the field does on the item card. |
| "Include Inventory" | Boolean | Specifies for the SKU, the same as the field does on the item card. |
| "Manufacturing Policy" | Enum Microsoft.Manufacturing.Setup."Manufacturing Policy" | Specifies if additional orders for any related components are calculated. |
| "Rescheduling Period" | 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. |
| "Lot Accumulation Period" | DateFormula | Specifies a period in which multiple demands are accumulated into one supply order when you use the Lot-for-Lot reordering policy. |
| "Dampener Period" | 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 period function is only initiated if the supply can be rescheduled to a later date and not if the supply can be rescheduled to an earlier date. Accordingly, if the suggested new supply date is after the dampener period, then the rescheduling suggestion is not blocked. If the lot accumulation period is less than the dampener period, then the dampener period is dynamically set to equal the lot accumulation period. This is not shown in the value that you enter in the Dampener Period field. The last demand in the lot accumulation period is used to determine whether a potential supply date is in the dampener period. If this field is empty, then the value in the Default Dampener Period field in the Manufacturing Setup window applies. The value that you enter in the Dampener Period field must be a date formula, and one day (1D) is the shortest allowed period. |
| "Dampener Quantity" | 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. |
| "Overflow Level" | Decimal | Specifies a quantity you allow projected inventory to exceed the reorder point before the system suggests to decrease existing supply orders. |
| "Plan Minimal Supply" | Boolean | |
| "Transfer-from Code" | Code[10] | Specifies the code of the location that items are transferred from. |
| "Qty. in Transit" | Decimal | Specifies the quantity of the SKUs in transit. These items have been shipped, but not yet received. |
| "Trans. Ord. Receipt (Qty.)" | Decimal | |
| "Trans. Ord. Shipment (Qty.)" | Decimal | |
| "Special Equipment Code" | Code[10] | Specifies the code of the equipment that you need to use when working with the SKU. |
| "Put-away Template Code" | Code[10] | Specifies the put-away template that the program uses when it performs a put-away for the SKU. |
| "Put-away Unit of Measure Code" | Code[10] | Specifies the code of the unit of measure that the program uses when it performs a put-away for the SKU. |
| "Phys Invt Counting Period Code" | Code[10] | Specifies the code of the counting period that indicates how often you want to count the SKU in a physical inventory. |
| "Last Counting Period Update" | Date | Specifies the last date on which you calculated the counting period. |
| "Last Phys. Invt. Date" | Date | Specifies the date on which you last posted the results of a physical inventory for the SKU to the item ledger. |
| "Use Cross-Docking" | Boolean | Specifies if the SKU can be cross-docked. |
| "Next Counting Start Date" | Date | Specifies the starting date of the next counting period. |
| "Next Counting End Date" | Date | Specifies the ending date of the next counting period. |
| "Qty. on Blanket Sales Order" | Decimal | Specifies how many units of the item are allocated to blanket sales orders, meaning listed on outstanding blanket sales order lines. |
| "Qty. on Blanket Purch. Order" | Decimal | Specifies how many units of the item are allocated to blanket purchase orders, meaning listed on outstanding blanket purchase order lines. |
| "Purch. Req. Receipt (Qty.)" | Decimal | |
| "Purch. Req. Release (Qty.)" | Decimal | |
| "Rolled-up Material Cost" | Decimal | |
| "Rolled-up Capacity Cost" | Decimal | |
| "Scrap %" | Decimal | |
| "Rolled-up Mat. Non-Invt. Cost" | Decimal | |
| "Single-Level Material Cost" | Decimal | |
| "Single-Level Capacity Cost" | Decimal | |
| "Single-Level Subcontrd. Cost" | Decimal | |
| "Single-Level Cap. Ovhd Cost" | Decimal | |
| "Single-Level Mfg. Ovhd Cost" | Decimal | |
| "Rolled-up Subcontracted Cost" | Decimal | |
| "Rolled-up Mfg. Ovhd Cost" | Decimal | |
| "Rolled-up Cap. Overhead Cost" | Decimal | |
| "Single-Lvl Mat. Non-Invt. Cost" | Decimal | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
IsMfgSKU
procedure IsMfgSKU(): BooleanReturns
| Type | Description |
|---|---|
| Boolean |
IsAssemblySKU
procedure IsAssemblySKU(): BooleanReturns
| Type | Description |
|---|---|
| Boolean |
UpdateTempSKUTransferLevels
procedure UpdateTempSKUTransferLevels(FromSKU: Record "Stockkeeping Unit"; var TempToSKU: Record "Stockkeeping Unit" temporary; FromLocationCode: Code[10]): BooleanParameters
| Name | Type | Description |
|---|---|---|
| FromSKU | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| TempToSKU | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| FromLocationCode | Code[10] |
Returns
| Type | Description |
|---|---|
| Boolean |
SetHideValidationDialog
procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| NewHideValidationDialog | Boolean |
CopyFromItem
procedure CopyFromItem(Item: Record Item)Parameters
| Name | Type | Description |
|---|---|---|
| Item | Table Microsoft.Inventory.Item.Item |
TransferManufCostsFromItem
procedure TransferManufCostsFromItem(Item: Record Item)Parameters
| Name | Type | Description |
|---|---|---|
| Item | Table Microsoft.Inventory.Item.Item |
Events
OnAfterCopyFromItem
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromItem(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item)Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| Item | Table Microsoft.Inventory.Item.Item |
OnBeforeCopyFromItem
[IntegrationEvent(False,False)]
local procedure OnBeforeCopyFromItem(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| Item | Table Microsoft.Inventory.Item.Item | |
| IsHandled | Boolean |
OnBeforeCheckTransferRoute
[IntegrationEvent(False,False)]
local procedure OnBeforeCheckTransferRoute(var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| IsHandled | Boolean |
OnBeforeValidateStandardCost
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateStandardCost(var StockkeepingUnit: Record "Stockkeeping Unit"; xStockkeepingUnit: Record "Stockkeeping Unit"; CallingFieldNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| xStockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| CallingFieldNo | Integer | |
| IsHandled | Boolean |
OnValidateTransferfromCodeOnBeforeModify
[IntegrationEvent(False,False)]
local procedure OnValidateTransferfromCodeOnBeforeModify(var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" | |
| IsHandled | Boolean |
OnValidateReplenishmentSystemCaseElse
[IntegrationEvent(False,False)]
local procedure OnValidateReplenishmentSystemCaseElse(var StockkeepingUnit: Record "Stockkeeping Unit")Parameters
| Name | Type | Description |
|---|---|---|
| StockkeepingUnit | Table Microsoft.Inventory.Location."Stockkeeping Unit" |