Table 156 "Resource"

Base Application · Microsoft.Projects.Resources.Resource · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 76 “Resource Card” (5 Learn pages), Page 77 “Resource List” (2), Page 912 “Component - Resource Details” (1).

Properties

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.

Keys

• Key1: No. (clustered)
• Key2: Search Name
• Key3: Gen. Prod. Posting Group
• Key4: Name
• Key5: Type
• Key6: Base Unit of Measure
• Key7: Resource Group No.
• Key8: SystemModifiedAt

Events published

• OnAfterValidateShortcutDimCode(var Resource: Record Resource; var xResource: Record Resource; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeAssistEdit(var Resource: Record Resource; xOldRes: Record Resource; var IsHandled: Boolean; var Result: Boolean) (integration)
• OnBeforeOnInsert(var Resource: Record Resource; var IsHandled: Boolean; var xResource: Record Resource) (integration)
• OnBeforeValidateShortcutDimCode(var Resource: Record Resource; var xResource: Record Resource; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
• OnBeforeValidateTimeSheetApproverUserID(var Resource: Record Resource; var IsHandled: Boolean; xResource: Record Resource) (integration)
• OnBeforeValidateNo(var Resource: Record Resource; xResource: Record Resource; var IsHandled: Boolean) (integration)
• OnBeforeValidateBaseUnitOfMeasure(var Resource: Record Resource; xResource: Record Resource; CallingFieldNo: Integer; var IsHandled: Boolean) (integration)
• OnBeforeValidateCity(var Resource: Record Resource; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
• OnBeforeValidatePostCode(var Resource: Record Resource; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
• OnAfterValidatePostCode(var Resource: Record Resource; xResource: Record Resource) (integration)
• OnValidateResourceGroupNoOnBeforeConfirm(var Resource: Record "Resource"; xResource: Record "Resource"; var IsHandled: Boolean) (integration)
• OnBeforeCreateTimeSheets(var Resource: Record "Resource"; var IsHandled: Boolean) (integration)
• OnBeforeExistUnprocessedTimeSheets(Resource: Record Resource; var Result: Boolean; var IsHandled: boolean) + BC24 (integration)

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeleteResource, Codeunit 6450 “Serv. Integration Mgt.” ResourceOnAfterDelete, Codeunit 7006 “Price Helper - V16” AfterDeleteResource, Codeunit 7019 “Price Helper - V15” AfterDeleteResource
• OnAfterRenameEvent: Codeunit 1173 “Document Attachment Mgmt” MoveAttachedDocumentsOnAfterRenameResource, Codeunit 7006 “Price Helper - V16” AfterRenameResource

Procedures

• AssistEdit(OldRes: Record Resource): Boolean
• ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type")
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
• DisplayMap()
• GetUnitOfMeasureFilter(No: Code[20]; UnitofMeasureCode: Code[10]): Text
• CreateTimeSheets()
• TestNoEntriesExist(CurrentFieldName: Text[100]) (protected)
• CheckResourcePrivacyBlocked(IsPosting: Boolean)

Plus 6 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• drill-down page Page 77 “Resource List”
• lookup page Page 77 “Resource List”
• Qty. on Order (Job): CalcFormula Table 1003 “Job Planning Line”
• Qty. Quoted (Job): CalcFormula Table 1003 “Job Planning Line”
• Resource Group No.: TableRelation Table 152 “Resource Group”
• Capacity: CalcFormula Table 160 “Res. Capacity Entry”
• Default Deferral Template Code: TableRelation Table 1700 “Deferral Template”
• 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”
• Base Unit of Measure: TableRelation Table 204 “Unit of Measure”
• Unit of Measure Filter: TableRelation Table 204 “Unit of Measure”
• City: TableRelation Table 225 “Post Code” (conditional)
• Post Code: TableRelation Table 225 “Post Code” (conditional)
• Vendor No.: TableRelation Table 23 “Vendor”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• No. Series: TableRelation Table 308 “No. Series”
• Tax Group Code: TableRelation Table 321 “Tax Group”
• VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• IC Partner Purch. G/L Acc. No.: TableRelation Table 410 “IC G/L Account”
• Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
• Unit Group Exists: CalcFormula Table 5400 “Unit Group”
• Country/Region Code: TableRelation Table 9 “Country/Region”
• Qty. on Assembly Order: CalcFormula Table 901 “Assembly Line”
• Time Sheet Approver User ID: TableRelation Table 91 “User Setup”
• Time Sheet Owner User ID: TableRelation Table 91 “User Setup”
• Comment: CalcFormula Table 97 “Comment Line”

Referenced by

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

• Table 1008 “Job Assigned Resource”: Resource Name, Resource No.
• Table 167 “Job”: Person Responsible, Resource Filter
• Table 4765 “Service Module Setup”: Resource 1 No., Resource 2 No.
• Table 5135 “Job Archive”: Person Responsible, Resource Filter
• Table 5140 “Job Assigned Resource Archive”: Resource Name, Resource No.
• Table 5400 “Unit Group”: Source Id, Source No.
• Table 5952 “Resource Location”: Resource Name, Resource No.
• Table 950 “Time Sheet Header”: Resource Name, Resource No.
• Table 1003 “Job Planning Line”: No.
• Table 1012 “Job Resource Price”: Code
• Table 111 “Sales Shipment Line”: No.
• Table 113 “Sales Invoice Line”: No.
• Table 115 “Sales Cr.Memo Line”: No.
• Table 121 “Purch. Rcpt. Line”: No.
• Table 123 “Purch. Inv. Line”: No.
• Table 125 “Purch. Cr. Memo Line”: No.
• Table 152 “Resource Group”: No. of Resources Assigned
• Table 160 “Res. Capacity Entry”: Resource No.
• Table 169 “Job Ledger Entry”: No.
• Table 171 “Standard Sales Line”: No.
• Table 201 “Resource Price”: Code
• Table 202 “Resource Cost”: Code
• Table 203 “Res. Ledger Entry”: Resource No.
• Table 205 “Resource Unit of Measure”: Resource No.
• Table 207 “Res. Journal Line”: Resource No.
• Table 210 “Job Journal Line”: No.
• Table 279 “Extended Text Header”: No.
• Table 280 “Extended Text Line”: No.
• Table 335 “Resource Price Change”: Code
• Table 4771 “Jobs Module Setup”: Resource Installer No.
• Table 5108 “Sales Line Archive”: No.
• Table 5137 “Job Planning Line Archive”: No.
• Table 5200 “Employee”: Resource No.
• Table 5802 “Value Entry”: No.
• Table 5832 “Capacity Ledger Entry”: No.
• Table 5841 “Standard Cost Worksheet”: No.
• Table 5870 “BOM Buffer”: No.
• Table 5873 “Compare Cost Shares Buffer”: No.
• Table 5900 “Service Header”: Resource Filter
• Table 5901 “Service Item Line”: Resource Filter
• Table 5907 “Service Ledger Entry”: No.
• Table 5908 “Warranty Ledger Entry”: No.
• Table 5909 “Service Shipment Buffer”: No.
• Table 5950 “Service Order Allocation”: Resource No.
• Table 5958 “Resource Service Zone”: Resource No.
• Table 5989 “Service Shipment Item Line”: Resource Filter
• Table 5990 “Service Shipment Header”: Resource Filter
• Table 5991 “Service Shipment Line”: No.
• Table 5992 “Service Invoice Header”: Resource Filter
• Table 5993 “Service Invoice Line”: No.
• and 25 more objects (25 fields): data/code/relations/29.json

Pages and codeunits on this table

• Page 213 “Resource Capacity” (source table)
• Page 223 “Resource Statistics” (source table)
• Page 225 “Resource Availability” (source table)
• Page 407 “Resource Picture” (source table)
• Page 6004 “Res. Availability (Service)” (source table)
• Page 6006 “Res. Availability - Overview” (source table)
• Page 6013 “Resource Capacity Settings” (source table)
• Page 6023 “Skilled Resource List” (source table)
• Page 76 “Resource Card” (source table)
• Page 77 “Resource List” (source table)
• Page 9107 “Resource Statistics FactBox” (source table)
• Page 9108 “Resource Details FactBox” (source table)
• Page 912 “Component - Resource Details” (source table)
• Page 9229 “Res. Avail. (Service) Matrix” (source table)
• Page 9237 “Resource Capacity Matrix” (source table)
• Page 978 “Time Sheet Setup Resources” (source table)

Extended by

• Table extension 5018 “Serv. Decl. Resource”
• Table extension 6230 “Sust. Resource”
• Table extension 6456 “Serv. Resource”

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, …)
• Page 456 “No. Series” (2 calls: AssistEdit → (object), OnInsert → (object))
• Codeunit 361 “MoveEntries” (1 call: OnDelete → MoveResEntries)
• Codeunit 5330 “CRM Integration Management” (1 call: UpdateResourceUnitGroup → IsIntegrationEnabled)
• Codeunit 7018 “Price UX Management” (1 call: ShowPriceListLines → ShowPriceListLines)
• Codeunit 802 “Online Map Management” (1 call: DisplayMap → MakeSelectionIfMapEnabled)
• Report 950 “Create Time Sheets” (1 call: CreateTimeSheets → (object))

Countries that replace it

AU, NZ

Deprecations

• field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”

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: "Resource"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.