Table 1001 Job Task in 27
- App
- Base Application
- Namespace
- Microsoft.Projects.Project.Job
Fields, 75Keys, 3Procedures, 27Events, 22
Versions171819202122232425262728latest
Source29
Fields, 75
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | Job No. | Code[20] | - | ||||
| 2 | Job Task No. | Code[20] | - | ||||
| 3 | Description | Text[100] | - | ||||
| 4 | Job Task Type | Enum Job Task Type | - | ||||
| 6 | WIP-Total | Option | - | ||||
| 7 | Job Posting Group | Code[20] | - | ||||
| 9 | WIP Method | Code[20] | - | ||||
| 10 | Schedule (Total Cost) | Decimal | - | ||||
| 11 | Schedule (Total Price) | Decimal | - | ||||
| 12 | Usage (Total Cost) | Decimal | - | ||||
| 13 | Usage (Total Price) | Decimal | - | ||||
| 14 | Contract (Total Cost) | Decimal | - | ||||
| 15 | Contract (Total Price) | Decimal | - | ||||
| 16 | Contract (Invoiced Price) | Decimal | - | ||||
| 17 | Contract (Invoiced Cost) | Decimal | - | ||||
| 19 | Posting Date Filter | Date | - | ||||
| 20 | Planning Date Filter | Date | - | ||||
| 21 | Totaling | Text[250] | - | ||||
| 22 | New Page | Boolean | - | ||||
| 23 | No. of Blank Lines | Integer | - | ||||
| 24 | Indentation | Integer | - | ||||
| 30 | Location Code | Code[10] | - | ||||
| 31 | Bin Code | Code[20] | - | ||||
| 34 | Recognized Sales Amount | Decimal | - | ||||
| 37 | Recognized Costs Amount | Decimal | - | ||||
| 41 | Language Code | Code[10] | - | ||||
| 56 | Recognized Sales G/L Amount | Decimal | - | ||||
| 57 | Recognized Costs G/L Amount | Decimal | - | ||||
| 60 | Global Dimension 1 Code | Code[20] | - | ||||
| 61 | Global Dimension 2 Code | Code[20] | - | ||||
| 62 | Outstanding Orders | Decimal | - | ||||
| 63 | Amt. Rcd. Not Invoiced | Decimal | - | ||||
| 64 | Remaining (Total Cost) | Decimal | - | ||||
| 65 | Remaining (Total Price) | Decimal | - | ||||
| 66 | Start Date | Date | - | ||||
| 67 | End Date | Date | - | ||||
| 70 | Bill-to Customer No. | Code[20] | - | ||||
| 71 | Bill-to Name | Text[100] | - | ||||
| 72 | Bill-to Address | Text[100] | - | ||||
| 73 | Bill-to Address 2 | Text[50] | - | ||||
| 74 | Bill-to City | Text[30] | - | ||||
| 75 | Bill-to County | Text[30] | - | ||||
| 76 | Bill-to Post Code | Code[20] | - | ||||
| 77 | Bill-to Country/Region Code | Code[10] | - | ||||
| 78 | Bill-to Name 2 | Text[50] | - | ||||
| 79 | Bill-to Contact No. | Code[20] | - | ||||
| 80 | Bill-to Contact | Text[100] | - | ||||
| 90 | Sell-to Customer No. | Code[20] | - | ||||
| 91 | Sell-to Customer Name | Text[100] | - | ||||
| 92 | Sell-to Customer Name 2 | Text[50] | - | ||||
| 93 | Sell-to Address | Text[100] | - | ||||
| 94 | Sell-to Address 2 | Text[50] | - | ||||
| 95 | Sell-to City | Text[30] | - | ||||
| 96 | Sell-to Contact | Text[100] | - | ||||
| 97 | Sell-to Post Code | Code[20] | - | ||||
| 98 | Sell-to County | Text[30] | - | ||||
| 99 | Sell-to Country/Region Code | Code[10] | - | ||||
| 100 | Sell-to Contact No. | Code[20] | - | ||||
| 110 | Ship-to Code | Code[10] | - | ||||
| 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] | - | ||||
| 116 | Ship-to Contact | Text[100] | - | ||||
| 117 | Ship-to Post Code | Code[20] | - | ||||
| 118 | Ship-to County | Text[30] | - | ||||
| 119 | Ship-to Country/Region Code | Code[10] | - | ||||
| 130 | External Document No. | Code[35] | - | ||||
| 131 | Payment Method Code | Code[10] | - | ||||
| 132 | Payment Terms Code | Code[10] | - | ||||
| 133 | Your Reference | Text[35] | - | ||||
| 134 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 140 | Invoice Currency Code | Code[10] | - | ||||
| 721 | Coupled to Dataverse | Boolean | Pending 25.0 | ||||
| Field Service is moved to Field Service Integration app. | |||||||
Keys, 3
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Job No., Job Task No. | - |
| Key2 | Job Task No. | - |
| Key3 | SystemCreatedAt | - |
Procedures, 27
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| CalcEACTotalCost | () | Decimal | public | - |
| CalcEACTotalPrice | () | Decimal | public | - |
| Caption | () | Text | public | - |
| InitWIPFields | () | public | - | |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| ClearTempDim | () | public | - | |
| ApplyPurchaseLineFilters | (var Record Purchase Line, Code[20], Code[20]) | public | - | |
| ToPriceSource | (var Record Price Source, Enum Price Type) | public | - | |
| JobPlanningLineExist | () | Boolean | public | - |
| SalesJobLedgEntryExist | () | Boolean | public | - |
| SalesLineExist | () | Boolean | public | - |
| ShouldSearchForCustomerByName | (Code[20]) | Boolean | public | - |
| UpdateSellToContact | (Code[20]) | protected | - | |
| BilltoContactLookup | () | Boolean | public | - |
| LookupSellToCustomerName | (var Text) | Boolean | public | - |
| SelltoCustomerNoOnAfterValidate | (var Record Job Task, var Record Job Task) | public | - | |
| SelltoContactLookup | () | Boolean | public | - |
| ShipToNameEqualsSellToName | () | Boolean | public | - |
| BillToAddressEqualsSellToAddress | () | Boolean | public | - |
| ShipToAddressEqualsSellToAddress | () | Boolean | public | - |
| SyncShipToWithSellTo | () | public | - | |
| JobLedgEntryExist | () | Boolean | public | - |
| JobPlanLineExist | () | Boolean | public | - |
| SendProfile | (var Record Document Sending Profile) | public | - | |
| SetHideValidationDialog | (Boolean) | public | - | |
| GetHideValidationDialog | () | Boolean | public | - |
| SuspendDeletionCheck | (Boolean) | public | - |
Events, 22
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterValidateShortcutDimCode | (var Record Job Task, var Record Job Task, Integer, var Code[20]) | - |
| Integration event | OnBeforeOnInsert | (var Record Job Task, var Boolean) | - |
| Integration event | OnInitWIPFieldsOnBeforeModify | (var Record Job Task) | - |
| Integration event | OnAfterOnInsert | (var Record Job Task, var Record Job Task) | - |
| Integration event | OnBeforeValidateJobTaskNo | (var Record Job Task, var Record Job Task, Integer, var Boolean) | - |
| Integration event | OnAfterApplyPurchaseLineFilters | (var Record Job Task, var Record Purchase Line) | - |
| Integration event | OnBeforeOnModify | (var Record Job Task, Record Job Task, var Boolean) | - |
| Integration event | OnBeforeValidateJobPostingGroup | (var Record Job Task, Record Job Task, Integer, var Boolean) | - |
| Integration event | OnJobLedgEntriesExistOnAfterSetFilter | (var Record Job Task, var Record Job Ledger Entry) | - |
| Integration event | OnBeforeCaption | (Record Job Task, var Boolean, var Text) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Job Task, var Record Job Task, Integer, var Code[20], Record Job Task, var Boolean) | - |
| Integration event | OnAfterShipToAddressEqualsSellToAddress | (var Record Job Task, var Boolean) | - |
| Integration event | OnAfterSyncShipToWithSellTo | (var Record Job Task) | - |
| Integration event | OnUpdateCostPricesOnRelatedJobPlanningLinesOnBeforeConfirmUpdate | (var Record Job Task, var Boolean, var Boolean) | - |
| Integration event | OnBeforeCheckSellToCustomerAssosEntriesExist | (var Record Job Task, Record Job Task, var Boolean) | - |
| Integration event | OnBeforeCheckBillToCustomerAssosEntriesExist | (var Record Job Task, Record Job Task, var Boolean) | - |
| Integration event | OnBeforeSellToCustomerNoUpdated | (var Record Job Task, var Record Job Task, Integer) | - |
| Integration event | OnAfterSellToCustomerNoUpdated | (var Record Job Task, Record Job Task, var Record Customer) | - |
| Integration event | OnAfterShipToCodeValidate | (var Record Job Task, var Record Ship-to Address) | - |
| Integration event | OnBeforeBillToCustomerNoUpdated | (var Record Job Task, Record Job Task, Integer) | - |
| Integration event | OnBillToCustomerNoUpdatedOnAfterCopyFieldsFromBillToCustomer | (var Record Job Task, Record Job Task, var Record Job, var Record Customer) | - |
| Integration event | OnAfterBillToCustomerNoUpdated | (var Record Job Task, Record Job Task, var Record Customer, Integer) | - |