Table 5841 "Standard Cost Worksheet"
Base Application · Microsoft.Manufacturing.StandardCost
Across versions
- BC23present
- BC24declaration changed
- BC251 fields changed, 1 procedures added
- BC2620 fields changed, 3 procedures removed
- BC271 procedures added, 1 events added
- BC2831 fields changed
- BC29-30unchanged
Neighbourhood 8 connected objects and pages
Base Application · Microsoft.Manufacturing.StandardCost · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5841 “Standard Cost Worksheet” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Standard Cost Worksheet |
| 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 |
|---|---|---|---|---|
| 2 | Standard Cost Worksheet Name | Code[10] | — | TableRelation Table 5840 “Standard Cost Worksheet Name” (Standard Cost Worksheet Name) |
| 3 | Type Δ BC25 Δ BC28 | Enum “Standard Cost Source Type” | Specifies the type of worksheet line. | enum Enum 5841 “Standard Cost Source Type” |
| 4 | No. Δ BC26 Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Table 156 “Resource”, Table 27 “Item” (if (Type = const(Item)) Item else if (Type = const(Resource)) Resource); NotBlank |
| 5 | Description Δ BC28 | Text[100] | Specifies the description of the worksheet line. | |
| 6 | Implemented Δ BC28 | Boolean | Specifies that you have run the Implement Standard Cost Changes batch job. | not editable |
| 7 | Replenishment System Δ BC28 | Enum “Replenishment System” | Specifies the replenishment method for the items, for example, purchase or prod. order. | enum Enum 5419 “Replenishment System”; not editable |
| 11 | 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. | not editable |
| 12 | New Standard Cost Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | |
| 13 | 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. | not editable |
| 14 | New Indirect Cost % Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | |
| 15 | Overhead Rate Δ BC28 | Decimal | Specifies the overhead rate. | not editable |
| 16 | New Overhead Rate Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | |
| 21 | Single-Lvl Material Cost Δ BC28 | Decimal | Specifies the single-level material cost of the item. | not editable |
| 22 | New Single-Lvl Material Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 23 | Single-Lvl Cap. Cost Δ BC26 Δ BC28 | Decimal | Specifies the single-level capacity cost of the item. | not editable |
| 24 | New Single-Lvl Cap. Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 25 | Single-Lvl Subcontrd Cost Δ BC26 Δ BC28 | Decimal | Specifies the single-level subcontracted cost of the item. | not editable |
| 26 | New Single-Lvl Subcontrd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 27 | Single-Lvl Cap. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the single-level capacity overhead cost of the item. | not editable |
| 28 | New Single-Lvl Cap. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 29 | Single-Lvl Mfg. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the single-level manufacturing overhead cost of the item. | not editable |
| 30 | New Single-Lvl Mfg. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 41 | Rolled-up Material Cost Δ BC26 Δ BC28 | Decimal | Specifies the rolled-up material cost of the item. | not editable |
| 42 | New Rolled-up Material Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated rolled-up material cost based on either the batch job or what you have entered manually. | not editable |
| 43 | Rolled-up Cap. Cost Δ BC26 Δ BC28 | Decimal | Specifies the rolled-up capacity cost of the item. | not editable |
| 44 | New Rolled-up Cap. Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 45 | Rolled-up Subcontrd Cost Δ BC26 Δ BC28 | Decimal | Specifies the rolled-up subcontracted cost of the item. | not editable |
| 46 | New Rolled-up Subcontrd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 47 | Rolled-up Cap. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the rolled-up capacity overhead cost of the item. | not editable |
| 48 | New Rolled-up Cap. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
| 49 | Rolled-up Mfg. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the rolled-up manufacturing overhead cost of the item. | not editable |
| 50 | New Rolled-up Mfg. Ovhd Cost Δ BC26 Δ BC28 | Decimal | Specifies the updated value based on either the batch job or what you have entered manually. | not editable |
Keys
- Key1: Standard Cost Worksheet Name, Type, No. (clustered)
Events published
OnAfterTransferStandardCostFromItem(var StandardCostWorksheet: Record "Standard Cost Worksheet"; var Item: Record Item)Δ BC26 (integration)OnAfterTransferManufCostsFromItem(var StandardCostWorksheet: Record "Standard Cost Worksheet"; Item: Record Item)− BC26 + BC27 (integration)OnAfterGetItemCosts(var StandardCostWorksheet: Record "Standard Cost Worksheet"; var Item: Record Item)+ BC26 (integration)- subscribers: Codeunit 912 “Calculate Assembly Cost” OnAfterGetItemCosts
OnBeforeGetItemCosts(var StandardCostWorksheet: Record "Standard Cost Worksheet"; var Item: Record Item)(integration)OnBeforeGetResourceCosts(var StandardCostWorksheet: Record "Standard Cost Worksheet"; var Resource: Record Resource)+ BC25 (integration)
Trigger event subscribers
- OnAfterValidateEvent(No.): Codeunit 5812 “Calculate Standard Cost” OnValidateNoByType
Procedures
TransferManufCostsFromItem(var Item: Record Item)− BC26 + BC27
Plus 5 local procedures.
Triggers
OnInsert
Relations
- No.: TableRelation Table 156 “Resource” (conditional)
- No.: TableRelation Table 27 “Item” (conditional)
- Standard Cost Worksheet Name: TableRelation Table 5840 “Standard Cost Worksheet Name”
Pages and codeunits on this table
- Page 5841 “Standard Cost Worksheet” (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: "Standard Cost Worksheet"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.