Table 5136 Job Task Archive
- App
- Base Application
- Namespace
- Microsoft.Projects.Project.Archive
- Versions
- 24-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Projects/Project/Archive/JobTaskArchive.Table.al600 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Projects.Project.Archive;
using Microsoft.Bank.BankAccount;
using Microsoft.CRM.Contact;
using Microsoft.Finance.Currency;
using Microsoft.Finance.Dimension;
using Microsoft.Foundation.Address;
using Microsoft.Foundation.PaymentTerms;
using Microsoft.Inventory.Location;
using Microsoft.Pricing.Calculation;
using Microsoft.Projects.Project.Job;
using Microsoft.Projects.Project.WIP;
using Microsoft.Purchases.History;
using Microsoft.Sales.Customer;
using Microsoft.Warehouse.Structure;
using System.Globalization;
table 5136 "Job Task Archive"
{
Caption = 'Project Task';
DrillDownPageID = "Job Task Archive Lines";
LookupPageID = "Job Task Archive Lines";
DataClassification = CustomerContent;
fields
{
field(1; "Job No."; Code[20])
{
Caption = 'Project No.';
ToolTip = 'Specifies the number of the related project.';
Editable = false;
NotBlank = true;
TableRelation = "Job Archive";
}
field(2; "Job Task No."; Code[20])
{
Caption = 'Project Task No.';
ToolTip = 'Specifies the number of the related project task.';
NotBlank = true;
}
field(3; Description; Text[100])
{
Caption = 'Description';
ToolTip = '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.';
}
field(4; "Job Task Type"; Enum "Job Task Type")
{
Caption = 'Project Task Type';
ToolTip = '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:';
}
field(6; "WIP-Total"; Option)
{
Caption = 'WIP-Total';
ToolTip = 'Specifies the project tasks you want to group together when calculating Work In Process (WIP) and Recognition.';
OptionCaption = ' ,Total,Excluded';
OptionMembers = " ",Total,Excluded;
}
field(7; "Job Posting Group"; Code[20])
{
Caption = 'Project Posting Group';
ToolTip = 'Specifies the project posting group of the task.';
TableRelation = "Job Posting Group";
}
field(9; "WIP Method"; Code[20])
{
Caption = 'WIP Method';
ToolTip = '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 = "Job WIP Method".Code where(Valid = const(true));
}
field(10; "Schedule (Total Cost)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Budget (Total Cost)';
Editable = false;
FieldClass = FlowField;
}
field(11; "Schedule (Total Price)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Budget (Total Price)';
Editable = false;
FieldClass = FlowField;
}
field(12; "Usage (Total Cost)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Actual (Total Cost)';
}
field(13; "Usage (Total Price)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Actual (Total Price)';
}
field(14; "Contract (Total Cost)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Billable (Total Cost)';
Editable = false;
FieldClass = FlowField;
}
field(15; "Contract (Total Price)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Billable (Total Price)';
Editable = false;
FieldClass = FlowField;
}
field(16; "Contract (Invoiced Price)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Invoiced (Total Price)';
}
field(17; "Contract (Invoiced Cost)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Invoiced (Total Cost)';
}
field(19; "Posting Date Filter"; Date)
{
Caption = 'Posting Date Filter';
FieldClass = FlowFilter;
}
field(20; "Planning Date Filter"; Date)
{
Caption = 'Planning Date Filter';
FieldClass = FlowFilter;
}
field(21; Totaling; Text[250])
{
Caption = 'Totaling';
ToolTip = 'Specifies an interval or a list of project task numbers.';
TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));
ValidateTableRelation = false;
}
field(22; "New Page"; Boolean)
{
Caption = 'New Page';
}
field(23; "No. of Blank Lines"; Integer)
{
BlankZero = true;
Caption = 'No. of Blank Lines';
MinValue = 0;
}
field(24; Indentation; Integer)
{
Caption = 'Indentation';
MinValue = 0;
}
field(30; "Location Code"; Code[10])
{
Caption = 'Location Code';
ToolTip = 'Specifies the location code of the task.';
TableRelation = Location where("Use As In-Transit" = const(false));
DataClassification = CustomerContent;
}
field(31; "Bin Code"; Code[20])
{
Caption = 'Bin Code';
ToolTip = 'Specifies a bin code for specific location of the task.';
TableRelation = Bin.Code where("Location Code" = field("Location Code"));
DataClassification = CustomerContent;
}
field(34; "Recognized Sales Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Recognized Sales Amount';
Editable = false;
}
field(37; "Recognized Costs Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Recognized Costs Amount';
Editable = false;
}
field(41; "Language Code"; Code[10])
{
Caption = 'Language Code';
TableRelation = Language;
DataClassification = CustomerContent;
}
field(56; "Recognized Sales G/L Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Recognized Sales G/L Amount';
Editable = false;
}
field(57; "Recognized Costs G/L Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
BlankZero = true;
Caption = 'Recognized Costs G/L Amount';
Editable = false;
}
field(60; "Global Dimension 1 Code"; Code[20])
{
CaptionClass = '1,1,1';
Caption = 'Global Dimension 1 Code';
ToolTip = '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 = "Dimension Value".Code where("Global Dimension No." = const(1),
Blocked = const(false));
}
field(61; "Global Dimension 2 Code"; Code[20])
{
CaptionClass = '1,1,2';
Caption = 'Global Dimension 2 Code';
ToolTip = '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 = "Dimension Value".Code where("Global Dimension No." = const(2),
Blocked = const(false));
}
field(62; "Outstanding Orders"; Decimal)
{
AutoFormatType = 0;
AccessByPermission = TableData "Purch. Rcpt. Header" = R;
Caption = 'Outstanding Orders';
}
field(63; "Amt. Rcd. Not Invoiced"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = Rec."Invoice Currency Code";
AccessByPermission = TableData "Purch. Rcpt. Header" = R;
Caption = 'Amt. Rcd. Not Invoiced';
}
field(64; "Remaining (Total Cost)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Remaining (Total Cost)';
Editable = false;
FieldClass = FlowField;
}
field(65; "Remaining (Total Price)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
BlankZero = true;
CalcFormula = 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.")));
Caption = 'Remaining (Total Price)';
Editable = false;
FieldClass = FlowField;
}
field(66; "Start Date"; Date)
{
CalcFormula = 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.")));
Caption = 'Start Date';
ToolTip = 'Specifies the start date for the project task. The date is based on the date on the related project planning line.';
Editable = false;
FieldClass = FlowField;
}
field(67; "End Date"; Date)
{
CalcFormula = 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.")));
Caption = 'End Date';
ToolTip = 'Specifies the end date for the project task. The date is based on the date on the related project planning line.';
Editable = false;
FieldClass = FlowField;
}
field(70; "Bill-to Customer No."; Code[20])
{
Caption = 'Bill-to Customer No.';
ToolTip = 'Specifies the number of the customer who pays for the project task.';
TableRelation = Customer;
DataClassification = CustomerContent;
}
field(71; "Bill-to Name"; Text[100])
{
Caption = 'Bill-to Name';
TableRelation = Customer.Name;
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(72; "Bill-to Address"; Text[100])
{
Caption = 'Bill-to Address';
DataClassification = CustomerContent;
}
field(73; "Bill-to Address 2"; Text[50])
{
Caption = 'Bill-to Address 2';
DataClassification = CustomerContent;
}
field(74; "Bill-to City"; Text[30])
{
Caption = 'Bill-to City';
DataClassification = CustomerContent;
TableRelation = 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"));
ValidateTableRelation = false;
}
field(75; "Bill-to County"; Text[30])
{
CaptionClass = '5,3,' + "Bill-to Country/Region Code";
Caption = 'Bill-to County';
DataClassification = CustomerContent;
}
field(76; "Bill-to Post Code"; Code[20])
{
Caption = 'Bill-to Post Code';
TableRelation = 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"));
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(77; "Bill-to Country/Region Code"; Code[10])
{
Caption = 'Bill-to Country/Region Code';
Editable = true;
TableRelation = "Country/Region";
DataClassification = CustomerContent;
}
field(78; "Bill-to Name 2"; Text[50])
{
Caption = 'Bill-to Name 2';
DataClassification = CustomerContent;
ToolTip = 'Specifies an additional part of the name of the customer who pays for the project.';
}
field(79; "Bill-to Contact No."; Code[20])
{
AccessByPermission = TableData Contact = R;
Caption = 'Bill-to Contact No.';
DataClassification = CustomerContent;
}
field(80; "Bill-to Contact"; Text[100])
{
Caption = 'Bill-to Contact';
DataClassification = CustomerContent;
}
field(90; "Sell-to Customer No."; Code[20])
{
Caption = 'Sell-to Customer No.';
ToolTip = 'Specifies the number of the customer who will receive the products and be billed by default for the project task.';
TableRelation = Customer;
DataClassification = CustomerContent;
}
field(91; "Sell-to Customer Name"; Text[100])
{
Caption = 'Sell-to Customer Name';
TableRelation = Customer.Name;
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(92; "Sell-to Customer Name 2"; Text[50])
{
Caption = 'Sell-to Customer Name 2';
DataClassification = CustomerContent;
ToolTip = 'Specifies an additional part of the name of the customer who will receive the products and be billed by default.';
}
field(93; "Sell-to Address"; Text[100])
{
Caption = 'Sell-to Address';
DataClassification = CustomerContent;
}
field(94; "Sell-to Address 2"; Text[50])
{
Caption = 'Sell-to Address 2';
DataClassification = CustomerContent;
}
field(95; "Sell-to City"; Text[30])
{
Caption = 'Sell-to City';
TableRelation = 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"));
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(96; "Sell-to Contact"; Text[100])
{
Caption = 'Sell-to Contact';
DataClassification = CustomerContent;
}
field(97; "Sell-to Post Code"; Code[20])
{
Caption = 'Sell-to Post Code';
TableRelation = 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"));
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(98; "Sell-to County"; Text[30])
{
CaptionClass = '5,2,' + "Sell-to Country/Region Code";
Caption = 'Sell-to County';
DataClassification = CustomerContent;
}
field(99; "Sell-to Country/Region Code"; Code[10])
{
Caption = 'Sell-to Country/Region Code';
TableRelation = "Country/Region";
DataClassification = CustomerContent;
}
field(100; "Sell-to Contact No."; Code[20])
{
Caption = 'Sell-to Contact No.';
TableRelation = Contact;
DataClassification = CustomerContent;
}
field(110; "Ship-to Code"; Code[10])
{
Caption = 'Ship-to Code';
TableRelation = "Ship-to Address".Code where("Customer No." = field("Sell-to Customer No."));
DataClassification = CustomerContent;
}
field(111; "Ship-to Name"; Text[100])
{
Caption = 'Ship-to Name';
DataClassification = CustomerContent;
}
field(112; "Ship-to Name 2"; Text[50])
{
Caption = 'Ship-to Name 2';
DataClassification = CustomerContent;
}
field(113; "Ship-to Address"; Text[100])
{
Caption = 'Ship-to Address';
DataClassification = CustomerContent;
}
field(114; "Ship-to Address 2"; Text[50])
{
Caption = 'Ship-to Address 2';
DataClassification = CustomerContent;
}
field(115; "Ship-to City"; Text[30])
{
Caption = 'Ship-to City';
TableRelation = 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"));
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(116; "Ship-to Contact"; Text[100])
{
Caption = 'Ship-to Contact';
DataClassification = CustomerContent;
}
field(117; "Ship-to Post Code"; Code[20])
{
Caption = 'Ship-to Post Code';
TableRelation = 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"));
ValidateTableRelation = false;
DataClassification = CustomerContent;
}
field(118; "Ship-to County"; Text[30])
{
CaptionClass = '5,4,' + "Ship-to Country/Region Code";
Caption = 'Ship-to County';
DataClassification = CustomerContent;
}
field(119; "Ship-to Country/Region Code"; Code[10])
{
Caption = 'Ship-to Country/Region Code';
TableRelation = "Country/Region";
DataClassification = CustomerContent;
}
field(130; "External Document No."; Code[35])
{
Caption = 'External Document No.';
DataClassification = CustomerContent;
}
field(131; "Payment Method Code"; Code[10])
{
Caption = 'Payment Method Code';
TableRelation = "Payment Method";
DataClassification = CustomerContent;
}
field(132; "Payment Terms Code"; Code[10])
{
Caption = 'Payment Terms Code';
TableRelation = "Payment Terms";
DataClassification = CustomerContent;
}
field(133; "Your Reference"; Text[35])
{
Caption = 'Your Reference';
DataClassification = CustomerContent;
}
field(134; "Price Calculation Method"; Enum "Price Calculation Method")
{
Caption = 'Price Calculation Method';
DataClassification = CustomerContent;
}
field(140; "Invoice Currency Code"; Code[10])
{
Caption = 'Invoice Currency Code';
TableRelation = Currency;
DataClassification = CustomerContent;
}
field(5047; "Version No."; Integer)
{
Caption = 'Version No.';
}
}
keys
{
key(Key1; "Job No.", "Job Task No.", "Version No.")
{
Clustered = true;
}
key(Key2; "Job Task No.")
{
}
}
fieldgroups
{
fieldgroup(DropDown; "Job No.", "Job Task No.", Description, "Job Task Type")
{
}
fieldgroup(Brick; "Job Task No.", Description)
{
}
}
trigger OnDelete()
var
JobPlanningLineArchive: Record "Job Planning Line Archive";
begin
JobPlanningLineArchive.SetRange("Job No.", "Job No.");
JobPlanningLineArchive.SetRange("Job Task No.", "Job Task No.");
JobPlanningLineArchive.SetRange("Version No.", "Version No.");
JobPlanningLineArchive.DeleteAll(true);
end;
}