Table 1013 "Job Item Price"
Base Application · Microsoft.Projects.Project.Pricing
Across versions
- BC23present
- BC245 fields changed
- BC25declaration changed
- BC26declaration changed
- BC27unchanged
- BC2812 fields changed
- BC29-30unchanged
Neighbourhood 8 connected objects and pages
Base Application · Microsoft.Projects.Project.Pricing · captioned “Project Item Price” · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1012 “Job Item Prices” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Project Item 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 item 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 | Item No. Δ BC28 | Code[20] | Specifies the item that this price applies to. Choose the field to see the available items. | TableRelation Table 27 “Item” |
| 4 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 5 | 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. | |
| 6 | Currency Code Δ BC28 | Code[10] | Specifies the default currency code that is defined for a project. Project item prices will only be used if the currency code for the project item is the same as the currency code set for the project. | TableRelation Table 4 “Currency” |
| 7 | Unit Cost Factor Δ BC28 | Decimal | Specifies the unit cost factor, if you have agreed with your customer that he should pay certain item usage by cost value plus a certain percent value to cover your overhead expenses. | |
| 8 | Line Discount % Δ BC28 | Decimal | Specifies a project-specific line discount percent that applies to this line. This is useful, for example, if you want invoice lines for the project to show a discount percent. | |
| 9 | Description Δ BC24 Δ BC28 | Text[100] | Specifies the description of the item you have entered in the Item No. field. | FlowField: lookup(Item.Description where(“No.” = field(“Item No.”))); not editable |
| 10 | Variant Code Δ BC28 | Code[10] | Specifies the variant code if the price that you are setting up should apply to a specific variant of the item. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 11 | Apply Job Price Δ BC24 Δ BC28 | Boolean | Specifies whether the project-specific price or unit cost factor for this item should apply to the project. The default project price that is defined is included when project-related entries are created, but you can modify this value. | |
| 12 | Apply Job Discount Δ BC24 Δ BC28 | Boolean | Specifies the check box for this field if the project-specific discount percent for this item should apply to the project. The default line discount for the line that is defined is included when project entries are created, but you can modify this value. |
Keys
- Key1: Job No., Job Task No., Item No., Variant Code, Unit of Measure Code, Currency Code (clustered)
Events published
OnBeforeCheckItemNoNotEmpty(var JobItemPrice: Record "Job Item Price"; var IsHandled: Boolean)(integration)
Procedures
2 local procedures, no public ones.
Triggers
OnInsert
Relations
- drill-down page Page 1012 “Job Item Prices”
- lookup page Page 1012 “Job Item Prices”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Job No.: TableRelation Table 167 “Job”
- Description: CalcFormula Table 27 “Item”
- Item No.: TableRelation Table 27 “Item”
- Currency Code: TableRelation Table 4 “Currency”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Pages and codeunits on this table
- Page 1012 “Job Item 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 Item Price"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.