Table 1014 "Job G/L Account Price"

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

Properties

Property	Value
Caption	Project G/L Account 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 general ledger 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	G/L Account No. Δ BC28	Code[20]	Specifies the G/L Account that this price applies to. Choose the field to see the available items.	TableRelation Table 15 “G/L Account” (G/L Account)
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 tithe code for the sales price currency 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”
7	Unit Cost Factor Δ BC28	Decimal	Specifies the unit cost factor, if you have agreed with your customer that he should pay certain expenses by cost value plus a certain percent, to cover your overhead expenses.
8	Line Discount % Δ BC28	Decimal	Specifies a line discount percent that applies to expenses related to this general ledger account. This is useful, for example if you want invoice lines for the project to show a discount percent.
9	Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the item or resource on the line.
10	Description Δ BC24 Δ BC28	Text[100]	Specifies the description of the G/L Account No. you have entered in the G/L Account No. field.	FlowField: lookup(“G/L Account”.Name where(“No.” = field(“G/L Account No.”))); not editable

Keys

Key1: Job No., Job Task No., G/L Account No., Currency Code (clustered)

Events published

OnBeforeCheckGLAccountNotEmpty(var JobGLAccountPrice: Record "Job G/L Account Price"; var IsHandled: Boolean) (integration)

Procedures

2 local procedures, no public ones.

Triggers

OnInsert

Relations

drill-down page Page 1013 “Job G/L Account Prices”
lookup page Page 1013 “Job G/L Account Prices”
Job Task No.: TableRelation Table 1001 “Job Task”
Description: CalcFormula Table 15 “G/L Account”
G/L Account No.: TableRelation Table 15 “G/L Account”
Job No.: TableRelation Table 167 “Job”
Currency Code: TableRelation Table 4 “Currency”

Pages and codeunits on this table

Page 1013 “Job G/L Account 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 G/L Account Price"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.