Table Resource
Properties
| Name | Value |
|---|---|
| Caption | Resource |
| DataCaptionFields | 1,3 |
| DrillDownPageID | Page Microsoft.Projects.Resources.Resource."Resource List" |
| LookupPageID | Page Microsoft.Projects.Resources.Resource."Resource List" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "No." | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. |
| Type | Enum Microsoft.Projects.Resources.Resource."Resource Type" | Specifies whether the resource is a person or a machine. |
| Name | Text[100] | Specifies a description of the resource. |
| "Search Name" | Code[100] | Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field. |
| "Name 2" | Text[50] | Specifies information in addition to the description. |
| Address | Text[100] | Specifies the address or location of the resource, if applicable. |
| "Address 2" | Text[50] | Specifies additional address information. |
| City | Text[30] | Specifies the city of the resource's address. |
| "Social Security No." | Text[30] | Specifies the person's social security number or the machine's serial number. |
| "Job Title" | Text[30] | Specifies the person's job title. |
| Education | Text[30] | Specifies the training, education, or certification level of the person. |
| "Contract Class" | Text[30] | Specifies the contract class for the person. |
| "Employment Date" | Date | Specifies the date when the person began working for you or the date when the machine was placed in service. |
| "Resource Group No." | Code[20] | Specifies the resource group that this resource is assigned to. |
| "Global Dimension 1 Code" | Code[20] | |
| "Global Dimension 2 Code" | Code[20] | |
| "Base Unit of Measure" | Code[10] | Specifies the base unit used to measure the resource, such as hour, piece, or kilometer. |
| "Direct Unit Cost" | Decimal | Specifies the cost of one unit of the selected item or resource. |
| "Indirect Cost %" | 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. |
| "Unit Cost" | Decimal | Specifies the cost of one unit of the item or resource on the line. |
| "Profit %" | Decimal | Specifies the profit margin that you want to sell the resource at. You can enter a profit percentage manually or have it entered according to the Price/Profit Calculation field |
| "Price/Profit Calculation" | Option | Specifies the relationship between the Unit Cost, Unit Price, and Profit Percentage fields associated with this resource. |
| "Unit Price" | Decimal | Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. |
| "Vendor No." | Code[20] | |
| "Last Date Modified" | Date | Specifies the date of the most recent change of information in the Resource Card window. |
| Comment | Boolean | |
| Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. |
| "Date Filter" | Date | |
| "Unit of Measure Filter" | Code[10] | |
| Capacity | Decimal | |
| "Qty. on Order (Job)" | Decimal | |
| "Qty. Quoted (Job)" | Decimal | |
| "Usage (Qty.)" | Decimal | |
| "Usage (Cost)" | Decimal | |
| "Usage (Price)" | Decimal | |
| "Sales (Qty.)" | Decimal | |
| "Sales (Cost)" | Decimal | |
| "Sales (Price)" | Decimal | |
| "Chargeable Filter" | Boolean | |
| "Gen. Prod. Posting Group" | Code[20] | Specifies the item's product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. |
| "Post Code" | Code[20] | Specifies the postal code. |
| County | Text[30] | Specifies a special region, to which the resource belongs. |
| "Automatic Ext. Texts" | Boolean | Specifies that an Extended Text Header will be added on sales or purchase documents for this resource. |
| "No. Series" | Code[20] | |
| "Tax Group Code" | Code[20] | |
| "VAT Prod. Posting Group" | Code[20] | Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. |
| "Country/Region Code" | Code[10] | Specifies the country/region of the address. |
| "IC Partner Purch. G/L Acc. No." | Code[20] | Specifies the intercompany g/l account number in your partner's company that the amount for this resource is posted to. |
| "Unit Group Exists" | Boolean | |
| Image | Media | Specifies the picture that has been inserted for the resource. |
| "Privacy Blocked" | Boolean | Specifies whether to limit access to data for the data subject during daily operations. This is useful, for example, when protecting data from changes while it is under privacy review. |
| "Coupled to CRM" | Boolean | |
| "Coupled to Dataverse" | Boolean | Specifies that the resource is coupled to an entity in Dataverse. |
| "Qty. on Assembly Order" | Decimal | |
| "Use Time Sheet" | Boolean | Specifies whether a resource uses time sheets to record the time they use on tasks. |
| "Time Sheet Owner User ID" | Code[50] | Specifies the name of the owner of the time sheet. |
| "Time Sheet Approver User ID" | Code[50] | Specifies the ID of the approver of the time sheet. |
| "Default Deferral Template Code" | Code[10] | Specifies the default template that governs how to defer revenues and expenses to the periods when they occurred. |
| 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
AssistEdit
procedure AssistEdit(OldRes: Record Resource): Boolean
Parameters
| Name | Type | Description |
|---|---|---|
| OldRes | Table Microsoft.Projects.Resources.Resource.Resource |
Returns
| Type | Description |
|---|---|
| Boolean |
ShowPriceListLines
procedure ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type")
Parameters
| Name | Type | Description |
|---|---|---|
| PriceType | Enum Microsoft.Pricing.PriceList."Price Type" | |
| AmountType | Enum Microsoft.Pricing.PriceList."Price Amount Type" |
ValidateShortcutDimCode
procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
| Name | Type | Description |
|---|---|---|
| FieldNumber | Integer | |
| ShortcutDimCode | Code[20] |
DisplayMap
procedure DisplayMap()
GetUnitOfMeasureFilter
procedure GetUnitOfMeasureFilter(No: Code[20]; UnitofMeasureCode: Code[10]): Text
Parameters
| Name | Type | Description |
|---|---|---|
| No | Code[20] | |
| UnitofMeasureCode | Code[10] |
Returns
| Type | Description |
|---|---|
| Text |
CreateTimeSheets
procedure CreateTimeSheets()
CheckResourcePrivacyBlocked
procedure CheckResourcePrivacyBlocked(IsPosting: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| IsPosting | Boolean |
Events
OnAfterValidateShortcutDimCode
[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var Resource: Record Resource; var xResource: Record Resource; FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource | |
| FieldNumber | Integer | |
| ShortcutDimCode | Code[20] |
OnBeforeAssistEdit
[IntegrationEvent(False,False)]
local procedure OnBeforeAssistEdit(var Resource: Record Resource; xOldRes: Record Resource; var IsHandled: Boolean; var Result: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xOldRes | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean | |
| Result | Boolean |
OnBeforeOnInsert
[IntegrationEvent(False,False)]
local procedure OnBeforeOnInsert(var Resource: Record Resource; var IsHandled: Boolean; var xResource: Record Resource)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource |
OnBeforeValidateShortcutDimCode
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var Resource: Record Resource; var xResource: Record Resource; FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource | |
| FieldNumber | Integer | |
| ShortcutDimCode | Code[20] |
OnBeforeValidateTimeSheetApproverUserID
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateTimeSheetApproverUserID(var Resource: Record Resource; var IsHandled: Boolean; xResource: Record Resource)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource |
OnBeforeValidateNo
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateNo(var Resource: Record Resource; xResource: Record Resource; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean |
OnBeforeValidateBaseUnitOfMeasure
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateBaseUnitOfMeasure(var Resource: Record Resource; xResource: Record Resource; CallingFieldNo: Integer; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource | |
| CallingFieldNo | Integer | |
| IsHandled | Boolean |
OnBeforeValidateCity
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateCity(var Resource: Record Resource; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| PostCode | Table Microsoft.Foundation.Address."Post Code" | |
| CurrentFieldNo | Integer | |
| IsHandled | Boolean |
OnBeforeValidatePostCode
[IntegrationEvent(False,False)]
local procedure OnBeforeValidatePostCode(var Resource: Record Resource; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| PostCode | Table Microsoft.Foundation.Address."Post Code" | |
| CurrentFieldNo | Integer | |
| IsHandled | Boolean |
OnAfterValidatePostCode
[IntegrationEvent(False,False)]
local procedure OnAfterValidatePostCode(var Resource: Record Resource; xResource: Record Resource)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource |
OnValidateResourceGroupNoOnBeforeConfirm
[IntegrationEvent(True,False)]
local procedure OnValidateResourceGroupNoOnBeforeConfirm(var Resource: Record Resource; xResource: Record Resource; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| xResource | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean |
OnBeforeCreateTimeSheets
[IntegrationEvent(False,False)]
local procedure OnBeforeCreateTimeSheets(var Resource: Record Resource; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| IsHandled | Boolean |
OnBeforeExistUnprocessedTimeSheets
[IntegrationEvent(False,False)]
local procedure OnBeforeExistUnprocessedTimeSheets(Resource: Record Resource; var Result: Boolean; var IsHandled: Boolean)
Parameters
| Name | Type | Description |
|---|---|---|
| Resource | Table Microsoft.Projects.Resources.Resource.Resource | |
| Result | Boolean | |
| IsHandled | Boolean |