Table 152 "Resource Group"
Base Application · Microsoft.Projects.Resources.Resource
Across versions
- BC23present
- BC242 fields changed
- BC251 fields removed
- BC26-27unchanged
- BC2811 fields changed
- BC29-30unchanged
Neighbourhood 50 connected objects and pages
Base Application · Microsoft.Projects.Resources.Resource · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 72 “Resource Groups” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Resource Group |
| 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 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | NotBlank |
| 2 | Name Δ BC28 | Text[50] | Specifies a short description of the resource group. | |
| 22 | Date Filter | Date | — | FlowFilter |
| 23 | Capacity Δ BC28 | Decimal | — | FlowField: sum(“Res. Capacity Entry”.Capacity where(“Resource Group No.” = field(“No.”), Date = field(“Date Filter”))) |
| 24 | Qty. on Order (Job) Δ BC24 Δ BC28 | Decimal | Qty. on Order (Project) caption | FlowField: sum(“Job Planning Line”.“Quantity (Base)” where(Status = const(Order), “Schedule Line” = const(true), Type = const(Resource), “Resource Group No.” = field(“No.”), “Planning Date” = field(“Date Filter”))); not editable |
| 25 | Qty. Quoted (Job) Δ BC24 Δ BC28 | Decimal | Qty. Quoted (Project) caption | FlowField: sum(“Job Planning Line”.“Quantity (Base)” where(Status = const(Quote), “Schedule Line” = const(true), Type = const(Resource), “Resource Group No.” = field(“No.”), “Planning Date” = field(“Date Filter”))); not editable |
| 26 | Unit of Measure Filter | Code[10] | — | TableRelation Table 204 “Unit of Measure” (Unit of Measure); FlowFilter |
| 27 | Usage (Qty.) Δ BC28 | Decimal | — | FlowField: sum(“Res. Ledger Entry”.Quantity where(“Entry Type” = const(Usage), Chargeable = field(“Chargeable Filter”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Resource Group No.” = field(“No.”), “Posting Date” = field(“Date Filter”))); not editable |
| 28 | Usage (Cost) Δ BC28 | Decimal | — | FlowField: sum(“Res. Ledger Entry”.“Total Cost” where(“Entry Type” = const(Usage), Chargeable = field(“Chargeable Filter”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Resource Group No.” = field(“No.”), “Posting Date” = field(“Date Filter”))); not editable |
| 29 | Usage (Price) Δ BC28 | Decimal | — | FlowField: sum(“Res. Ledger Entry”.“Total Price” where(“Entry Type” = const(Usage), Chargeable = field(“Chargeable Filter”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Resource Group No.” = field(“No.”), “Posting Date” = field(“Date Filter”))); not editable |
| 30 | Sales (Qty.) Δ BC28 | Decimal | — | FlowField: - sum(“Res. Ledger Entry”.Quantity where(“Entry Type” = const(Sale), “Resource Group No.” = field(“No.”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Posting Date” = field(“Date Filter”))); not editable |
| 31 | Sales (Cost) Δ BC28 | Decimal | — | FlowField: - sum(“Res. Ledger Entry”.“Total Cost” where(“Entry Type” = const(Sale), “Resource Group No.” = field(“No.”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Posting Date” = field(“Date Filter”))); not editable |
| 32 | Sales (Price) Δ BC28 | Decimal | — | FlowField: - sum(“Res. Ledger Entry”.“Total Price” where(“Entry Type” = const(Sale), “Resource Group No.” = field(“No.”), “Unit of Measure Code” = field(“Unit of Measure Filter”), “Posting Date” = field(“Date Filter”))); not editable |
| 33 | Chargeable Filter | Boolean | — | FlowFilter |
| 34 | Global Dimension 1 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 35 | Global Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 36 | No. of Resources Assigned | Integer | — | FlowField: count(Resource where(“Resource Group No.” = field(“No.”))); not editable |
Keys
- Key1: No. (clustered)
Events published
OnAfterValidateShortcutDimCode(var ResourceGroup: Record "Resource Group"; xResourceGroup: Record "Resource Group"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeValidateShortcutDimCode(var ResourceGroup: Record "Resource Group"; xResourceGroup: Record "Resource Group"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteResourceGroup, Codeunit 7019 “Price Helper - V15” AfterDeleteResourceGroup
- OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameResourceGroup
Procedures
ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type")ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
Plus 1 local procedures.
Triggers
OnDelete, OnInsert, OnRename
Relations
- drill-down page Page 72 “Resource Groups”
- lookup page Page 72 “Resource Groups”
- Qty. on Order (Job): CalcFormula Table 1003 “Job Planning Line”
- Qty. Quoted (Job): CalcFormula Table 1003 “Job Planning Line”
- No. of Resources Assigned: CalcFormula Table 156 “Resource”
- Capacity: CalcFormula Table 160 “Res. Capacity Entry”
- Sales (Cost): CalcFormula Table 203 “Res. Ledger Entry”
- Sales (Price): CalcFormula Table 203 “Res. Ledger Entry”
- Sales (Qty.): CalcFormula Table 203 “Res. Ledger Entry”
- Usage (Cost): CalcFormula Table 203 “Res. Ledger Entry”
- Usage (Price): CalcFormula Table 203 “Res. Ledger Entry”
- Usage (Qty.): CalcFormula Table 203 “Res. Ledger Entry”
- Unit of Measure Filter: TableRelation Table 204 “Unit of Measure”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Referenced by
30 fields in 30 objects relate to this table (TableRelation or CalcFormula).
- Table 1003 “Job Planning Line”: Resource Group No.
- Table 1012 “Job Resource Price”: Code
- Table 156 “Resource”: Resource Group No.
- Table 160 “Res. Capacity Entry”: Resource Group No.
- Table 167 “Job”: Resource Gr. Filter
- Table 169 “Job Ledger Entry”: Resource Group No.
- Table 201 “Resource Price”: Code
- Table 202 “Resource Cost”: Code
- Table 203 “Res. Ledger Entry”: Resource Group No.
- Table 207 “Res. Journal Line”: Resource Group No.
- Table 210 “Job Journal Line”: Resource Group No.
- Table 335 “Resource Price Change”: Code
- Table 5135 “Job Archive”: Resource Gr. Filter
- Table 5137 “Job Planning Line Archive”: Resource Group No.
- Table 5900 “Service Header”: Resource Group Filter
- Table 5901 “Service Item Line”: Resource Group Filter
- Table 5950 “Service Order Allocation”: Resource Group No.
- Table 5972 “Contract/Service Discount”: No.
- Table 5976 “Filed Contract/Serv. Discount”: No.
- Table 5989 “Service Shipment Item Line”: Resource Group Filter
- Table 5990 “Service Shipment Header”: Resource Group Filter
- Table 5992 “Service Invoice Header”: Resource Group Filter
- Table 5994 “Service Cr.Memo Header”: Resource Group Filter
- Table 6010 “Service Header Archive”: Resource Group Filter
- Table 6014 “Service Order Allocat. Archive”: Resource Group No.
- Table 6083 “Serv. Price Adjustment Detail”: No.
- Table 7001 “Price List Line”: Product No.
- Table 7008 “Dtld. Price Calculation Setup”: Product No.
- Table 7022 “Price Worksheet Line”: Product No.
- Table 9057 “Job Cue”: Unassigned Resource Groups
Pages and codeunits on this table
- Page 214 “Res. Group Capacity” (source table)
- Page 226 “Res. Group Availability” (source table)
- Page 230 “Res. Gr. Statistics” (source table)
- Page 6010 “Res.Gr. Availability (Service)” (source table)
- Page 6011 “Res.Gr.Availability - Overview” (source table)
- Page 72 “Resource Groups” (source table)
- Page 9221 “Res. Gr. Avail. (Serv.) Matrix” (source table)
- Page 9243 “Res. Group Capacity Matrix” (source 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.
- Codeunit 408 “DimensionManagement” (5 calls:
OnDelete → DeleteDefaultDim,OnInsert → UpdateDefaultDim,OnRename → RenameDefaultDim, …) - Codeunit 7018 “Price UX Management” (1 call:
ShowPriceListLines → ShowPriceListLines)
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: "Resource Group"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.