Table 167 Job in 22
- App
- Base Application
Fields, 102Keys, 5Procedures, 52Events, 60
Versions171819202122232425262728latest
Source29
Fields, 102
| 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] | - | ||||
| 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 | - | ||||
| 57 | Picture | Blob | Removed 18.0 | ||||
| Replaced by Image field | |||||||
| 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] | - | ||||
| 117 | Reserve | Enum Reserve Method | - | ||||
| 140 | Image | Media | - | ||||
| 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] | - | ||||
| 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 | - | ||||
| 8000 | Id | Guid | Removed 22.0 | ||||
| This functionality will be replaced by the systemID field | |||||||
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Description | - |
| Key3 | Bill-to Customer No. | - |
| Key4 | Description | - |
| Key5 | Status | - |
Procedures, 52
| 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 | - | |||
| UpdateCust | () | public | Pending 20.0 | ||||
| Pending removal, replaced with BillToCustomerNoUpdated and SellToCustomerNoUpdated. | |||||||
| 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 | - | ||||
| IsJobSimplificationAvailable | () | Boolean | 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 | - | |||
Events, 60
| 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 | OnBeforeUpdateCust | (var Record Job, Record Job, var Boolean) | Pending 20.0 | ||||
| Pending removal, replaced with BillToCustomerNoUpdated and SellToCustomerNoUpdated. | |||||||
| Integration event | OnUpdateBillToCustOnAfterAssignBillToContact | (var Record Job, Record Contact) | - | ||||
| Integration event | OnUpdateCustOnBeforeTestBillToCustomerNo | (var Record Job, Record Customer, var Boolean) | Pending 20.0 | ||||
| Pending removal, replaced with BillToCustomerNoUpdated and SellToCustomerNoUpdated. | |||||||
| Integration event | OnUpdateCustOnBeforeAssignIncoiceCurrencyCode | (var Record Job, Record Job, Record Customer, var Boolean) | - | ||||
| Integration event | OnAfterUpdateBillToCust | (var Record Job, Record Customer) | Pending 20.0 | ||||
| Pending removal, replaced with BillToCustomerNoUpdated and SellToCustomerNoUpdated. | |||||||
| 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) | - | ||||
| Integration event | OnBeforeValidateCurrencyCode | (var Record Job, Record Job, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeValidateNo | (var Record Job, var Boolean) | - | ||||
| Integration event | OnBeforeSellToCustomerNoUpdated | (var Record Job, var Record Job, Integer, 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) | - | ||||