Table 5135 Job Archive

Base Application, Microsoft.Projects.Project.Archive

97 fields

IdNameTypeVersions
1No.Code[20]new in 24
2Search DescriptionCode[100]new in 24
3DescriptionText[100]new in 24
4Description 2Text[50]new in 24
5Bill-to Customer No.Code[20]new in 24
12Creation DateDatenew in 24
13Starting DateDatenew in 24
14Ending DateDatenew in 24
19StatusEnum "Job Status"new in 24
20Person ResponsibleCode[20]new in 24
21Global Dimension 1 CodeCode[20]new in 24
22Global Dimension 2 CodeCode[20]new in 24
23Job Posting GroupCode[20]new in 24
24BlockedEnum "Job Blocked"new in 24
29Last Date ModifiedDatenew in 24
30CommentBooleannew in 24
31Customer Disc. GroupCode[20]new in 24
32Customer Price GroupCode[10]new in 24
35Location CodeCode[10]new in 24
36Bin CodeCode[20]new in 24
41Language CodeCode[10]new in 24
49Scheduled Res. Qty.Decimalnew in 24
50Resource FilterCode[20]new in 24
51Posting Date FilterDatenew in 24
55Resource Gr. FilterCode[20]new in 24
56Scheduled Res. Gr. Qty.Decimalnew in 24
58Bill-to NameText[100]new in 24
59Bill-to AddressText[100]new in 24
60Bill-to Address 2Text[50]new in 24
61Bill-to CityText[30]new in 24
63Bill-to CountyText[30]new in 24
64Bill-to Post CodeCode[20]new in 24
66No. SeriesCode[20]new in 24
67Bill-to Country/Region CodeCode[10]new in 24
68Bill-to Name 2Text[50]new in 24
80Task Billing MethodEnum "Task Billing Method"new in 24
117ReserveEnum "Reserve Method"new in 24
140ImageMedianew in 24
210Ship-to Phone No.Text[30]new in 25
1000WIP MethodCode[20]new in 24
1001Currency CodeCode[10]new in 24
1002Bill-to Contact No.Code[20]new in 24
1003Bill-to ContactText[100]new in 24
1004Planning Date FilterDatenew in 24
1008WIP Posting DateDatenew in 24
1011Invoice Currency CodeCode[10]new in 24
1012Exch. Calculation (Cost)Optionnew in 24
1013Exch. Calculation (Price)Optionnew in 24
1014Allow Schedule/Contract LinesBooleannew in 24
1015CompleteBooleannew in 24
1024Next Invoice DateDatenew in 24
1025Apply Usage LinkBooleannew in 24
1027WIP Posting MethodOptionnew in 24
1030Calc. Recog. Sales AmountDecimalnew in 24
1031Calc. Recog. Costs AmountDecimalnew in 24
1032Calc. Recog. Sales G/L AmountDecimalnew in 24
1033Calc. Recog. Costs G/L AmountDecimalnew in 24
1035Over BudgetBooleannew in 24
1036Project ManagerCode[50]new in 24
2000Sell-to Customer No.Code[20]new in 24
2001Sell-to Customer NameText[100]new in 24
2002Sell-to Customer Name 2Text[50]new in 24
2003Sell-to AddressText[100]new in 24
2004Sell-to Address 2Text[50]new in 24
2005Sell-to CityText[30]new in 24
2006Sell-to ContactText[100]new in 24
2007Sell-to Post CodeCode[20]new in 24
2008Sell-to CountyText[30]new in 24
2009Sell-to Country/Region CodeCode[10]new in 24
2010Sell-to Phone No.Text[30]new in 24
2011Sell-to E-MailText[80]new in 24
2012Sell-to Contact No.Code[20]new in 24
3000Ship-to CodeCode[10]new in 24
3001Ship-to NameText[100]new in 24
3002Ship-to Name 2Text[50]new in 24
3003Ship-to AddressText[100]new in 24
3004Ship-to Address 2Text[50]new in 24
3005Ship-to CityText[30]new in 24
3006Ship-to ContactText[100]new in 24
3007Ship-to Post CodeCode[20]new in 24
3008Ship-to CountyText[30]new in 24
3009Ship-to Country/Region CodeCode[10]new in 24
3997No. of Archived VersionsIntegernew in 24
3998Source Doc. ExistsBooleannew in 24
3999Last Archived DateDateTimenew in 24
4000External Document No.Code[35]new in 24
4001Payment Method CodeCode[10]new in 24
4002Payment Terms CodeCode[10]new in 24
4003Your ReferenceText[35]new in 24
5043Interaction ExistBooleannew in 24
5044Time ArchivedTimenew in 24
5045Date ArchivedDatenew in 24
5046Archived ByCode[50]new in 24
5047Version No.Integernew in 24
7000Price Calculation MethodEnum "Price Calculation Method"new in 24
7001Cost Calculation MethodEnum "Price Calculation Method"new in 24
7300Completely PickedBooleannew in 24