Table 1012 "Job Resource Price"

Base Application · Microsoft.Projects.Project.Pricing · captioned “Project Resource Price” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Project Resource Price
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	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”; NotBlank
2	Job Task No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the project task if the resource price should only apply to a specific project task.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
3	Type Δ BC28	Option	Specifies whether the price that you are setting up for the project should apply to a resource, to a resource group, or to all resources and resource groups.	OptionCaption: Resource,Group(Resource),All
4	Code Δ BC28	Code[20]	Specifies the resource or resource group that this price applies to. The No. must correspond to your selection in the Type field.	TableRelation Table 152 “Resource Group”, Table 156 “Resource” (if (Type = const(Resource)) Resource else if (Type = const(“Group(Resource)”)) “Resource Group”)
5	Work Type Code Δ BC28	Code[10]	Specifies which work type the resource applies to. Prices are updated based on this entry.	TableRelation Table 200 “Work Type” (Work Type)
6	Unit Price Δ BC28	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.
7	Currency Code Δ BC28	Code[10]	Specifies the code for the currency of the sales price if the price that you have set up in this line is in a foreign currency. Choose the field to see the available currency codes.	TableRelation Table 4 “Currency”
8	Unit Cost Factor Δ BC28	Decimal	Specifies the unit cost factor. If you have agreed with you customer that he should pay for certain resource usage by cost value plus a certain percent value to cover your overhead expenses, you can set up a unit cost factor in this field.
9	Line Discount % Δ BC28	Decimal	Specifies a line discount percent that applies to this resource, or resource group. This is useful, for example if you want invoice lines for the project to show a discount percent.
10	Description Δ BC28	Text[100]	Specifies the description of the resource, or resource group, you have entered in the Code field.	not editable
11	Apply Job Price Δ BC24 Δ BC28	Boolean	Specifies whether the price for this resource, or resource group, should apply to the project, even if the price is zero.
12	Apply Job Discount Δ BC24 Δ BC28	Boolean	Specifies whether to apply a discount to the project. Select this field if the discount percent for this resource or resource group should apply to the project, even if the discount percent is zero.

Keys

Key1: Job No., Job Task No., Type, Code, Work Type Code, Currency Code (clustered)

Procedures

1 local procedures, no public ones.

Triggers

OnInsert, OnModify

Relations

drill-down page Page 1011 “Job Resource Prices”
lookup page Page 1011 “Job Resource Prices”
Job Task No.: TableRelation Table 1001 “Job Task”
Code: TableRelation Table 152 “Resource Group” (conditional)
Code: TableRelation Table 156 “Resource” (conditional)
Job No.: TableRelation Table 167 “Job”
Work Type Code: TableRelation Table 200 “Work Type”
Currency Code: TableRelation Table 4 “Currency”

Pages and codeunits on this table

Page 1011 “Job Resource Prices” (source table)

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