Table 167 Job in 26
- App
- Base Application
- Namespace
- Microsoft.Projects.Project.Job
Fields, 105Keys, 5Procedures, 57Events, 66
Versions171819202122232425262728latest
Source29
Fields, 105
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | No. | Code[20] | - |
| 2 | Search Description | Code[100] | - |
| 3 | Description | Text[100] | - |
| 4 | Description 2 | Text[50] | - |
| 5 | Bill-to Customer No. | Code[20] | - |
| 12 | Creation Date | Date | - |
| 13 | Starting Date | Date | - |
| 14 | Ending Date | Date | - |
| 19 | Status | Enum Job Status | - |
| 20 | Person Responsible | Code[20] | - |
| 21 | Global Dimension 1 Code | Code[20] | - |
| 22 | Global Dimension 2 Code | Code[20] | - |
| 23 | Job Posting Group | Code[20] | - |
| 24 | Blocked | Enum Job Blocked | - |
| 29 | Last Date Modified | Date | - |
| 30 | Comment | Boolean | - |
| 31 | Customer Disc. Group | Code[20] | - |
| 32 | Customer Price Group | Code[10] | - |
| 35 | Location Code | Code[10] | - |
| 36 | Bin Code | Code[20] | - |
| 41 | Language Code | Code[10] | - |
| 49 | Scheduled Res. Qty. | Decimal | - |
| 50 | Resource Filter | Code[20] | - |
| 51 | Posting Date Filter | Date | - |
| 55 | Resource Gr. Filter | Code[20] | - |
| 56 | Scheduled Res. Gr. Qty. | Decimal | - |
| 58 | Bill-to Name | Text[100] | - |
| 59 | Bill-to Address | Text[100] | - |
| 60 | Bill-to Address 2 | Text[50] | - |
| 61 | Bill-to City | Text[30] | - |
| 63 | Bill-to County | Text[30] | - |
| 64 | Bill-to Post Code | Code[20] | - |
| 66 | No. Series | Code[20] | - |
| 67 | Bill-to Country/Region Code | Code[10] | - |
| 68 | Bill-to Name 2 | Text[50] | - |
| 80 | Task Billing Method | Enum Task Billing Method | - |
| 117 | Reserve | Enum Reserve Method | - |
| 140 | Image | Media | - |
| 210 | Ship-to Phone No. | Text[30] | - |
| 1000 | WIP Method | Code[20] | - |
| 1001 | Currency Code | Code[10] | - |
| 1002 | Bill-to Contact No. | Code[20] | - |
| 1003 | Bill-to Contact | Text[100] | - |
| 1004 | Planning Date Filter | Date | - |
| 1005 | Total WIP Cost Amount | Decimal | - |
| 1006 | Total WIP Cost G/L Amount | Decimal | - |
| 1007 | WIP Entries Exist | Boolean | - |
| 1008 | WIP Posting Date | Date | - |
| 1009 | WIP G/L Posting Date | Date | - |
| 1011 | Invoice Currency Code | Code[10] | - |
| 1012 | Exch. Calculation (Cost) | Option | - |
| 1013 | Exch. Calculation (Price) | Option | - |
| 1014 | Allow Schedule/Contract Lines | Boolean | - |
| 1015 | Complete | Boolean | - |
| 1017 | Recog. Sales Amount | Decimal | - |
| 1018 | Recog. Sales G/L Amount | Decimal | - |
| 1019 | Recog. Costs Amount | Decimal | - |
| 1020 | Recog. Costs G/L Amount | Decimal | - |
| 1021 | Total WIP Sales Amount | Decimal | - |
| 1022 | Total WIP Sales G/L Amount | Decimal | - |
| 1023 | WIP Completion Calculated | Boolean | - |
| 1024 | Next Invoice Date | Date | - |
| 1025 | Apply Usage Link | Boolean | - |
| 1026 | WIP Warnings | Boolean | - |
| 1027 | WIP Posting Method | Option | - |
| 1028 | Applied Costs G/L Amount | Decimal | - |
| 1029 | Applied Sales G/L Amount | Decimal | - |
| 1030 | Calc. Recog. Sales Amount | Decimal | - |
| 1031 | Calc. Recog. Costs Amount | Decimal | - |
| 1032 | Calc. Recog. Sales G/L Amount | Decimal | - |
| 1033 | Calc. Recog. Costs G/L Amount | Decimal | - |
| 1034 | WIP Completion Posted | Boolean | - |
| 1035 | Over Budget | Boolean | - |
| 1036 | Project Manager | Code[50] | - |
| 2000 | Sell-to Customer No. | Code[20] | - |
| 2001 | Sell-to Customer Name | Text[100] | - |
| 2002 | Sell-to Customer Name 2 | Text[50] | - |
| 2003 | Sell-to Address | Text[100] | - |
| 2004 | Sell-to Address 2 | Text[50] | - |
| 2005 | Sell-to City | Text[30] | - |
| 2006 | Sell-to Contact | Text[100] | - |
| 2007 | Sell-to Post Code | Code[20] | - |
| 2008 | Sell-to County | Text[30] | - |
| 2009 | Sell-to Country/Region Code | Code[10] | - |
| 2010 | Sell-to Phone No. | Text[30] | - |
| 2011 | Sell-to E-Mail | Text[80] | - |
| 2012 | Sell-to Contact No. | Code[20] | - |
| 3000 | Ship-to Code | Code[10] | - |
| 3001 | Ship-to Name | Text[100] | - |
| 3002 | Ship-to Name 2 | Text[50] | - |
| 3003 | Ship-to Address | Text[100] | - |
| 3004 | Ship-to Address 2 | Text[50] | - |
| 3005 | Ship-to City | Text[30] | - |
| 3006 | Ship-to Contact | Text[100] | - |
| 3007 | Ship-to Post Code | Code[20] | - |
| 3008 | Ship-to County | Text[30] | - |
| 3009 | Ship-to Country/Region Code | Code[10] | - |
| 3997 | No. of Archived Versions | Integer | - |
| 4000 | External Document No. | Code[35] | - |
| 4001 | Payment Method Code | Code[10] | - |
| 4002 | Payment Terms Code | Code[10] | - |
| 4003 | Your Reference | Text[35] | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 7001 | Cost Calculation Method | Enum Price Calculation Method | - |
| 7300 | Completely Picked | Boolean | - |
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Description | - |
| Key3 | Bill-to Customer No. | - |
| Key4 | Description | - |
| Key5 | Status | - |
Procedures, 57
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Job) | Boolean | public | - |
| GetCostCalculationMethod | () | Enum Price Calculation Method | public | - |
| GetPriceCalculationMethod | () | Enum Price Calculation Method | public | - |
| ValidateShortcutDimCode | (Integer, Code[20]) | public | - | |
| UpdateBillToContact | (Code[20]) | public | - | |
| JobLedgEntryExist | () | Boolean | public | - |
| JobPlanningLineExist | () | Boolean | public | - |
| InitWIPFields | () | public | - | |
| TestBlocked | () | public | - | |
| CurrencyUpdatePlanningLines | () | public | - | |
| DisplayMap | () | public | - | |
| GetQuantityAvailable | (Code[20], Code[10], Code[10], Option, Option) | Decimal | public | - |
| CalcAccWIPCostsAmount | () | Decimal | public | - |
| CalcAccWIPSalesAmount | () | Decimal | public | - |
| CalcRecognizedProfitAmount | () | Decimal | public | - |
| CalcRecognizedProfitPercentage | () | Decimal | public | - |
| CalcRecognizedProfitGLAmount | () | Decimal | public | - |
| CalcRecognProfitGLPercentage | () | Decimal | public | - |
| CopyDefaultDimensionsFromCustomer | () | public | - | |
| PercentCompleted | () | Decimal | public | - |
| PercentInvoiced | () | Decimal | public | - |
| PercentOverdue | () | Decimal | public | - |
| UpdateOverBudgetValue | (Code[20], Boolean, Decimal) | public | - | |
| SendRecords | () | public | - | |
| SendProfile | (var Record Document Sending Profile) | public | - | |
| PrintRecords | (Boolean) | public | - | |
| EmailRecords | (Boolean) | public | - | |
| RecalculateJobWIP | () | public | - | |
| UpdateReferencedIds | () | public | - | |
| ShowPriceListLines | (Enum Price Type, Enum Price Asset Type, Enum Price Amount Type) | public | - | |
| UpdateBillToCust | (Code[20]) | public | - | |
| ToPriceSource | (var Record Price Source, Enum Price Type) | public | - | |
| BilltoContactLookup | () | Boolean | public | - |
| TestStatusCompleted | () | public | - | |
| CreateInvtPutAwayPick | () | public | - | |
| SetJobDiffBuff | (var Record Job Difference Buffer, Code[20], Code[20], Option, Option, Code[20], Code[10], Code[10], Code[10], Code[10]) | public | - | |
| SelltoContactLookup | () | Boolean | public | - |
| ShipToAddressEqualsSellToAddress | () | Boolean | public | - |
| BillToAddressEqualsSellToAddress | () | Boolean | public | - |
| SyncShipToWithSellTo | () | public | - | |
| ShipToNameEqualsSellToName | () | Boolean | public | - |
| SetHideValidationDialog | (Boolean) | public | - | |
| GetHideValidationDialog | () | Boolean | public | - |
| CreateWarehousePick | () | public | - | |
| UpdateSellToContact | (Code[20]) | protected | - | |
| SelltoCustomerNoOnAfterValidate | (var Record Job, var Record Job) | public | - | |
| LookupSellToCustomerName | (var Text) | Boolean | public | - |
| CalcJobTaskLinesEditable | () | Boolean | public | - |
| SellToCustomerNoUpdated | (var Record Job, var Record Job) | public | - | |
| ShouldSearchForCustomerByName | (Code[20]) | Boolean | public | - |
| CheckReservationEntries | () | Boolean | public | - |
| PerformAutoReserve | (var Record Job Planning Line) | public | - | |
| GetQtyReservedFromStockState | () | Enum Reservation From Stock | internal | - |
| SalesJobLedgEntryExist | () | Boolean | public | - |
| SalesLineExist | () | Boolean | public | - |
| JobTaskExist | () | Boolean | public | - |
| SetPurchLineFilters | (var Record Purchase Line) | public | - |
Events, 66
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterCalcRecognizedProfitAmount | (var Decimal) | - | ||||
| Integration event | OnAfterValidateShortcutDimCode | (var Record Job, var Record Job, Integer, var Code[20]) | - | ||||
| Integration event | OnAfterChangeJobCompletionStatus | (var Record Job, var Record Job) | - | ||||
| Integration event | OnBeforeChangeJobCompletionStatus | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeCheckContactBillToCustomerBusRelation | (var Record Job, Record Contact, var Boolean) | - | ||||
| Integration event | OnBeforeShowContactBillToCustomerBusRelationMissingError | (var Record Job, Record Contact, var Boolean) | - | ||||
| Integration event | OnBeforeCheckRemoveFromMyJobsFromModify | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeInitJobNo | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeInitBillToCustomerNo | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeRecalculateJobWIP | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeTestBlocked | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateJobTaskDimension | (var Record Job, Integer, Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeValidateBillToCustomerNo | (var Record Job, var Boolean, Record Job, Integer) | - | ||||
| Integration event | OnBeforeValidateBillToContactNo | (var Record Job, Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Job, var Record Job, Integer, var Code[20], var Boolean) | - | ||||
| Integration event | OnUpdateBillToCustOnAfterAssignBillToContact | (var Record Job, Record Contact) | - | ||||
| Integration event | OnUpdateCustOnBeforeAssignIncoiceCurrencyCode | (var Record Job, Record Job, Record Customer, var Boolean) | - | ||||
| Integration event | OnAfterOnInsert | (var Record Job, var Record Job) | - | ||||
| Integration event | OnBeforeInitGlobalDimFromDefalutDim | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateOverBudgetValue | (var Record Job, Code[20], Boolean, Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeValidateStatus | (var Record Job, Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnGetQuantityAvailableOnAfterSetFiltersOnJobLedgerEntry | (Code[20], Code[10], Code[10], Option, Option, var Record Job Ledger Entry) | - | ||||
| Integration event | OnBeforeThrowAssociatedEntriesExistError | (var Record Job, Record Job, Integer, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeBillToCustomerNoUpdated | (var Record Job, var Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnAfterShipToCodeValidate | (var Record Job, Record Ship-to Address) | - | ||||
| Integration event | OnAfterUpdateBillToContact | (var Record Job, Record Job) | - | ||||
| Integration event | OnBeforeCopyDefaultDimensionsFromCustomer | (var Record Job, var Boolean, Integer) | - | ||||
| Integration event | OnBeforePercentCompleted | (var Record Job, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforePercentInvoiced | (var Record Job, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforePercentOverdue | (var Record Job, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeDeleteRelatedJobTasks | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnAfterSellToCustomerNoUpdated | (var Record Job, Record Job, Record Customer) | - | ||||
| Integration event | OnSellToCustomerNoUpdatedOnAfterTransferFieldsFromCust | (var Record Job, Record Job, Record Customer) | - | ||||
| Integration event | OnValidateSellToCustomerNoOnBeforeCheckBlockedCustOnDocs | (var Record Job, var Record Customer, var Boolean) | - | ||||
| Integration event | OnBeforeTestStatusCompleted | (var Record Job, var Boolean) | - | ||||
| Integration event | OnAfterCalcJobTaskLinesEditable | (var Record Job, var Boolean) | - | ||||
| Integration event | OnAfterBillToCustomerNoUpdated | (var Record Job, Record Job, Record Customer, Integer) | - | ||||
| Integration event | OnAfterJobLedgEntryExist | (var Record Job Ledger Entry, var Boolean) | - | ||||
| Integration event | OnAfterJobPlanningLineExist | (var Record Job Planning Line, var Boolean) | - | ||||
| Integration event | OnBeforeAssistEdit | (var Record Job, var Record Job, var Boolean, var Boolean, var Codeunit NoSeriesManagement) | Pending 24.0 | ||||
| Parameter NoSeriesMgt is obsolete and will be removed, update your subscriber accordingly. | |||||||
| Integration event | OnBeforeValidateCurrencyCode | (var Record Job, Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateNo | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeValidateBillToCity | (var Record Job, var Record Post Code, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateBillToPostCode | (var Record Job, var Record Post Code, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateSellToCity | (var Record Job, var Record Post Code, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateShipToCity | (var Record Job, var Record Post Code, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeCheckSellToCustomerAssosEntriesExist | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeCheckBillToCustomerAssosEntriesExist | (var Record Job, var Record Job, var Boolean) | - | ||||
| Integration event | OnCopyDefaultDimensionsFromCustomerOnBeforeUpdateDefaultDim | (var Record Job, Integer) | - | ||||
| Integration event | OnBeforeInitDefaultJobPostingGroup | (var Record Job, var Boolean) | - | ||||
| Integration event | OnValidateStatusOnBeforeConfirm | (var Record Job, Record Job, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeCurrencyUpdatePlanningLines | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBillToCustomerNoUpdatedOnBeforeAssignCurrencyCode | (var Record Job, Record Job, Record Customer, var Boolean) | - | ||||
| Integration event | OnBillToCustomerNoUpdatedOnBeforeUpdateBillToContact | (var Record Job, Record Job, Record Customer, var Boolean) | - | ||||
| Integration event | OnCurrencyUpdatePlanningLinesOnBeforeUpdateJobPlanningLine | (var Record Job, var Record Job Planning Line) | - | ||||
| Integration event | OnBeforeValidateSellToCustomerName | (var Record Job, var Record Customer, var Boolean) | - | ||||
| Integration event | OnBeforeSellToCustomerNoUpdated | (var Record Job, var Record Job, Integer, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeShowSellToContactBusinessRelationNotFoundError | (var Record Job, Record Contact, var Boolean) | - | ||||
| Integration event | OnAfterSyncShipToWithSellTo | (var Record Job) | - | ||||
| Integration event | OnAfterShipToAddressEqualsSellToAddress | (var Record Job, var Boolean) | - | ||||
| Integration event | OnAfterUpdateCostPricesOnRelatedJobPlanningLines | (var Record Job) | - | ||||
| Integration event | OnBeforeUpdateSellToCust | (var Record Job, var Code[20], var Boolean) | - | ||||
| Integration event | OnUpdateCostPricesOnRelatedJobPlanningLinesOnBeforeConfirmUpdate | (var Record Job, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeCheckIfTimeSheetLineLinkExist | (var Record Job, var Boolean) | - | ||||
| Integration event | OnInitJobNoOnAfterAssignNoSeries | (var Record Job, var Record Job, var Record Jobs Setup) | - | ||||
| Integration event | OnBeforeAddToMyJobs | (var Record Job, var Record My Job, Code[50], var Boolean) | - | ||||