Table "Job Task Archive"

ID 5136
Namespace: Microsoft.Projects.Project.Archive

Properties

Name Value
Caption Project Task
DrillDownPageID Page Microsoft.Projects.Project.Archive."Job Task Archive Lines"
LookupPageID Page Microsoft.Projects.Project.Archive."Job Task Archive Lines"
DataClassification CustomerContent

Fields

Name Type Description
"Job No." Code[20]
"Job Task No." Code[20]
Description Text[100]
"Job Task Type" Enum Microsoft.Projects.Project.Job."Job Task Type"
"WIP-Total" Option
"Job Posting Group" Code[20]
"WIP Method" Code[20]
"Schedule (Total Cost)" Decimal
"Schedule (Total Price)" Decimal
"Usage (Total Cost)" Decimal
"Usage (Total Price)" Decimal
"Contract (Total Cost)" Decimal
"Contract (Total Price)" Decimal
"Contract (Invoiced Price)" Decimal
"Contract (Invoiced Cost)" Decimal
"Posting Date Filter" Date
"Planning Date Filter" Date
Totaling Text[250]
"New Page" Boolean
"No. of Blank Lines" Integer
Indentation Integer
"Location Code" Code[10]
"Bin Code" Code[20]
"Recognized Sales Amount" Decimal
"Recognized Costs Amount" Decimal
"Language Code" Code[10]
"Recognized Sales G/L Amount" Decimal
"Recognized Costs G/L Amount" Decimal
"Global Dimension 1 Code" Code[20]
"Global Dimension 2 Code" Code[20]
"Outstanding Orders" Decimal
"Amt. Rcd. Not Invoiced" Decimal
"Remaining (Total Cost)" Decimal
"Remaining (Total Price)" Decimal
"Start Date" Date
"End Date" Date
"Bill-to Customer No." Code[20]
"Bill-to Name" Text[100]
"Bill-to Address" Text[100]
"Bill-to Address 2" Text[50]
"Bill-to City" Text[30]
"Bill-to County" Text[30]
"Bill-to Post Code" Code[20]
"Bill-to Country/Region Code" Code[10]
"Bill-to Name 2" Text[50]

Specifies an additional part of the name of the customer who pays for the project.

"Bill-to Contact No." Code[20]
"Bill-to Contact" Text[100]
"Sell-to Customer No." Code[20]
"Sell-to Customer Name" Text[100]
"Sell-to Customer Name 2" Text[50]

Specifies an additional part of the name of the customer who will receive the products and be billed by default.

"Sell-to Address" Text[100]
"Sell-to Address 2" Text[50]
"Sell-to City" Text[30]
"Sell-to Contact" Text[100]
"Sell-to Post Code" Code[20]
"Sell-to County" Text[30]
"Sell-to Country/Region Code" Code[10]
"Sell-to Contact No." Code[20]
"Ship-to Code" Code[10]
"Ship-to Name" Text[100]
"Ship-to Name 2" Text[50]
"Ship-to Address" Text[100]
"Ship-to Address 2" Text[50]
"Ship-to City" Text[30]
"Ship-to Contact" Text[100]
"Ship-to Post Code" Code[20]
"Ship-to County" Text[30]
"Ship-to Country/Region Code" Code[10]
"External Document No." Code[35]
"Payment Method Code" Code[10]
"Payment Terms Code" Code[10]
"Your Reference" Text[35]
"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Invoice Currency Code" Code[10]
"Version No." Integer
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

See also