Table 5136 "Job Task Archive"

Base Application · Microsoft.Projects.Project.Archive · captioned “Project Task” · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Project Task
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. Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 5135 “Job Archive” (Job Archive); not editable; NotBlank
2	Job Task No. Δ BC28	Code[20]	Specifies the number of the related project task.	NotBlank
3	Description Δ BC28	Text[100]	Specifies a description of the project task. You can enter anything that is meaningful in describing the task. The description is copied and used in descriptions on the project planning line.
4	Job Task Type Δ BC28	Enum “Job Task Type”	Specifies the purpose of the account. Newly created accounts are automatically assigned the Posting account type, but you can change this. Choose the field to select one of the following five options:	enum Enum 1001 “Job Task Type”
6	WIP-Total Δ BC28	Option	Specifies the project tasks you want to group together when calculating Work In Process (WIP) and Recognition.	OptionCaption: ,Total,Excluded
7	Job Posting Group Δ BC28	Code[20]	Specifies the project posting group of the task.	TableRelation Table 208 “Job Posting Group” (Job Posting Group)
9	WIP Method Δ BC28	Code[20]	Specifies the name of the Work in Process calculation method that is associated with a project. The value in this field comes from the WIP method specified on the project card.	TableRelation Table 1006 “Job WIP Method” (“Job WIP Method”.Code where(Valid = const(true)))
10	Schedule (Total Cost) Δ BC28	Decimal	Specifies, in the local currency, the total budgeted cost for the project task during the time period in the Planning Date Filter field. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
11	Schedule (Total Price) Δ BC28	Decimal	Specifies, in local currency, the total budgeted price for the project task during the time period in the Planning Date Filter field. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
12	Usage (Total Cost) Δ BC28	Decimal	Specifies, in local currency, the total cost of the usage of items, resources and general ledger expenses posted on the project task during the time period in the Posting Date Filter field. via Page 5178 “Job Task Archive Lines”
13	Usage (Total Price) Δ BC28	Decimal	Specifies, in the local currency, the total price of the usage of items, resources and general ledger expenses posted on the project task during the time period in the Posting Date Filter field. via Page 5178 “Job Task Archive Lines”
14	Contract (Total Cost) Δ BC28	Decimal	Specifies, in local currency, the total billable cost for the project task during the time period in the Planning Date Filter field. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Contract Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
15	Contract (Total Price) Δ BC28	Decimal	Specifies, in the local currency, the total billable price for the project task during the time period in the Planning Date Filter field. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Contract Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
16	Contract (Invoiced Price) Δ BC28	Decimal	Specifies, in the local currency, the total billable price for the project task that has been invoiced during the time period in the Posting Date Filter field. via Page 5178 “Job Task Archive Lines”
17	Contract (Invoiced Cost) Δ BC28	Decimal	Specifies, in the local currency, the total billable cost for the project task that has been invoiced during the time period in the Posting Date Filter field. via Page 5178 “Job Task Archive Lines”
19	Posting Date Filter	Date	—	FlowFilter
20	Planning Date Filter	Date	—	FlowFilter
21	Totaling Δ BC28	Text[250]	Specifies an interval or a list of project task numbers.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
22	New Page	Boolean	—
23	No. of Blank Lines	Integer	—
24	Indentation	Integer	—
30	Location Code Δ BC28	Code[10]	Specifies the location code of the task.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
31	Bin Code Δ BC28	Code[20]	Specifies a bin code for specific location of the task.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
34	Recognized Sales Amount Δ BC28	Decimal	—	not editable
37	Recognized Costs Amount Δ BC28	Decimal	—	not editable
41	Language Code	Code[10]	—	TableRelation Table 8 “Language”
56	Recognized Sales G/L Amount Δ BC28	Decimal	—	not editable
57	Recognized Costs G/L Amount Δ BC28	Decimal	—	not editable
60	Global Dimension 1 Code Δ BC28	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
61	Global Dimension 2 Code Δ BC28	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
62	Outstanding Orders Δ BC28	Decimal	—
63	Amt. Rcd. Not Invoiced Δ BC28	Decimal	—
64	Remaining (Total Cost) Δ BC28	Decimal	Specifies the remaining total cost (LCY) as the sum of costs from project planning lines associated with the project task. The calculation occurs when you have specified that there is a usage link between the project ledger and the project planning lines. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Remaining Total Cost (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
65	Remaining (Total Price) Δ BC28	Decimal	Specifies the remaining total price (LCY) as the sum of prices from project planning lines associated with the project task. The calculation occurs when you have specified that there is a usage link between the project ledger and the project planning lines. via Page 5178 “Job Task Archive Lines”	FlowField: sum(“Job Planning Line Archive”.“Remaining Line Amount (LCY)” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Job Task No.” = field(filter(Totaling)), “Schedule Line” = const(true), “Planning Date” = field(“Planning Date Filter”), “Version No.” = field(“Version No.”))); not editable
66	Start Date Δ BC28	Date	Specifies the start date for the project task. The date is based on the date on the related project planning line.	FlowField: min(“Job Planning Line Archive”.“Planning Date” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Version No.” = field(“Version No.”))); not editable
67	End Date Δ BC28	Date	Specifies the end date for the project task. The date is based on the date on the related project planning line.	FlowField: max(“Job Planning Line Archive”.“Planning Date” where(“Job No.” = field(“Job No.”), “Job Task No.” = field(“Job Task No.”), “Version No.” = field(“Version No.”))); not editable
70	Bill-to Customer No. Δ BC28	Code[20]	Specifies the number of the customer who pays for the project task.	TableRelation Table 18 “Customer”
71	Bill-to Name	Text[100]	—	TableRelation Customer.Name
72	Bill-to Address	Text[100]	—
73	Bill-to Address 2	Text[50]	—
74	Bill-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Bill-to Country/Region Code”)))
75	Bill-to County	Text[30]	—
76	Bill-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Bill-to Country/Region Code” = const(‘’)) “Post Code” else if (“Bill-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Bill-to Country/Region Code”)))
77	Bill-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
78	Bill-to Name 2 Δ BC27	Text[50]	Specifies an additional part of the name of the customer who pays for the project.
79	Bill-to Contact No.	Code[20]	—
80	Bill-to Contact	Text[100]	—
90	Sell-to Customer No. Δ BC28	Code[20]	Specifies the number of the customer who will receive the products and be billed by default for the project task.	TableRelation Table 18 “Customer”
91	Sell-to Customer Name	Text[100]	—	TableRelation Customer.Name
92	Sell-to Customer Name 2 Δ BC27	Text[50]	Specifies an additional part of the name of the customer who will receive the products and be billed by default.
93	Sell-to Address	Text[100]	—
94	Sell-to Address 2	Text[50]	—
95	Sell-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Sell-to Country/Region Code”)))
96	Sell-to Contact	Text[100]	—
97	Sell-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Sell-to Country/Region Code” = const(‘’)) “Post Code” else if (“Sell-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Sell-to Country/Region Code”)))
98	Sell-to County	Text[30]	—
99	Sell-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
100	Sell-to Contact No.	Code[20]	—	TableRelation Table 5050 “Contact”
110	Ship-to Code	Code[10]	—	TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Sell-to Customer No.”)))
111	Ship-to Name	Text[100]	—
112	Ship-to Name 2	Text[50]	—
113	Ship-to Address	Text[100]	—
114	Ship-to Address 2	Text[50]	—
115	Ship-to City	Text[30]	—	TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code”.City else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Ship-to Country/Region Code”)))
116	Ship-to Contact	Text[100]	—
117	Ship-to Post Code	Code[20]	—	TableRelation Table 225 “Post Code” (if (“Ship-to Country/Region Code” = const(‘’)) “Post Code” else if (“Ship-to Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Ship-to Country/Region Code”)))
118	Ship-to County	Text[30]	—
119	Ship-to Country/Region Code	Code[10]	—	TableRelation Table 9 “Country/Region” (Country/Region)
130	External Document No.	Code[35]	Specifies a document number that refers to the customer’s or vendor’s numbering system. via Page 5181 “Job Task Archive Lines Subform”
131	Payment Method Code	Code[10]	—	TableRelation Table 289 “Payment Method” (Payment Method)
132	Payment Terms Code	Code[10]	—	TableRelation Table 3 “Payment Terms” (Payment Terms)
133	Your Reference	Text[35]	Specifies the customer’s reference. The content will be printed on sales documents. via Page 5181 “Job Task Archive Lines Subform”
134	Price Calculation Method	Enum “Price Calculation Method”	—	enum Enum 7000 “Price Calculation Method”
140	Invoice Currency Code	Code[10]	—	TableRelation Table 4 “Currency”
5047	Version No.	Integer	—

Keys

Key1: Job No., Job Task No., Version No. (clustered)
Key2: Job Task No.

Triggers

OnDelete

Relations

drill-down page Page 5178 “Job Task Archive Lines”
lookup page Page 5178 “Job Task Archive Lines”
Totaling: TableRelation Table 1001 “Job Task”
WIP Method: TableRelation Table 1006 “Job WIP Method”
Location Code: TableRelation Table 14 “Location”
Bill-to Customer No.: TableRelation Table 18 “Customer”
Sell-to Customer No.: TableRelation Table 18 “Customer”
Job Posting Group: TableRelation Table 208 “Job Posting Group”
Ship-to Code: TableRelation Table 222 “Ship-to Address”
Bill-to City: TableRelation Table 225 “Post Code” (conditional)
Bill-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Sell-to City: TableRelation Table 225 “Post Code” (conditional)
Sell-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Ship-to City: TableRelation Table 225 “Post Code” (conditional)
Ship-to Post Code: TableRelation Table 225 “Post Code” (conditional)
Payment Method Code: TableRelation Table 289 “Payment Method”
Payment Terms Code: TableRelation Table 3 “Payment Terms”
Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Invoice Currency Code: TableRelation Table 4 “Currency”
Sell-to Contact No.: TableRelation Table 5050 “Contact”
Job No.: TableRelation Table 5135 “Job Archive”
Contract (Total Cost): CalcFormula Table 5137 “Job Planning Line Archive”
Contract (Total Price): CalcFormula Table 5137 “Job Planning Line Archive”
End Date: CalcFormula Table 5137 “Job Planning Line Archive”
Remaining (Total Cost): CalcFormula Table 5137 “Job Planning Line Archive”
Remaining (Total Price): CalcFormula Table 5137 “Job Planning Line Archive”
Schedule (Total Cost): CalcFormula Table 5137 “Job Planning Line Archive”
Schedule (Total Price): CalcFormula Table 5137 “Job Planning Line Archive”
Start Date: CalcFormula Table 5137 “Job Planning Line Archive”
Bin Code: TableRelation Table 7354 “Bin”
Language Code: TableRelation Table 8 “Language”
Bill-to Country/Region Code: TableRelation Table 9 “Country/Region”
Sell-to Country/Region Code: TableRelation Table 9 “Country/Region”
Ship-to Country/Region Code: TableRelation Table 9 “Country/Region”

Referenced by

5 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 5135 “Job Archive”: Calc. Recog. Costs Amount, Calc. Recog. Costs G/L Amount, Calc. Recog. Sales Amount, Calc. Recog. Sales G/L Amount
Table 5137 “Job Planning Line Archive”: Job Task No.

Pages and codeunits on this table

Page 5178 “Job Task Archive Lines” (source table)
Page 5181 “Job Task Archive Lines Subform” (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 Task Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.