Table 167 Job in 18
- App
- Base Application
Fields, 74Keys, 5Procedures, 35Events, 24
Versions171819202122232425262728latest
Source29
Fields, 74
| 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] | - | ||||
| 7000 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 7001 | Cost Calculation Method | Enum Price Calculation Method | - | ||||
| 8000 | Id | Guid | Pending 15.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, 35
| 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 | - | |
| 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 | - |
Events, 24
| 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 | OnBeforeCopyDefaultDimensionsFromCustomer | (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) | - |
| Integration event | OnUpdateBillToCustOnAfterAssignBillToContact | (var Record Job, Record Contact) | - |
| Integration event | OnUpdateCustOnBeforeTestBillToCustomerNo | (var Record Job, Record Customer, var Boolean) | - |
| Integration event | OnUpdateCustOnBeforeAssignIncoiceCurrencyCode | (var Record Job, Record Job, Record Customer, var Boolean) | - |
| Integration event | OnAfterUpdateBillToCust | (var Record Job, Record Customer) | - |
| 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) | - |