Table 156 Resource in 22
- App
- Base Application
Fields, 62Keys, 9Procedures, 8Events, 12
Versions171819202122232425262728latest
Source29
Fields, 62
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | - | ||||
| 2 | Type | Enum Resource Type | - | ||||
| 3 | Name | Text[100] | - | ||||
| 4 | Search Name | Code[100] | - | ||||
| 5 | Name 2 | Text[50] | - | ||||
| 6 | Address | Text[100] | - | ||||
| 7 | Address 2 | Text[50] | - | ||||
| 8 | City | Text[30] | - | ||||
| 9 | Social Security No. | Text[30] | - | ||||
| 10 | Job Title | Text[30] | - | ||||
| 11 | Education | Text[30] | - | ||||
| 12 | Contract Class | Text[30] | - | ||||
| 13 | Employment Date | Date | - | ||||
| 14 | Resource Group No. | Code[20] | - | ||||
| 16 | Global Dimension 1 Code | Code[20] | - | ||||
| 17 | Global Dimension 2 Code | Code[20] | - | ||||
| 18 | Base Unit of Measure | Code[10] | - | ||||
| 19 | Direct Unit Cost | Decimal | - | ||||
| 20 | Indirect Cost % | Decimal | - | ||||
| 21 | Unit Cost | Decimal | - | ||||
| 22 | Profit % | Decimal | - | ||||
| 23 | Price/Profit Calculation | Option | - | ||||
| 24 | Unit Price | Decimal | - | ||||
| 25 | Vendor No. | Code[20] | - | ||||
| 26 | Last Date Modified | Date | - | ||||
| 27 | Comment | Boolean | - | ||||
| 38 | Blocked | Boolean | - | ||||
| 39 | Date Filter | Date | - | ||||
| 40 | Unit of Measure Filter | Code[10] | - | ||||
| 41 | Capacity | Decimal | - | ||||
| 42 | Qty. on Order (Job) | Decimal | - | ||||
| 43 | Qty. Quoted (Job) | Decimal | - | ||||
| 44 | Usage (Qty.) | Decimal | - | ||||
| 45 | Usage (Cost) | Decimal | - | ||||
| 46 | Usage (Price) | Decimal | - | ||||
| 47 | Sales (Qty.) | Decimal | - | ||||
| 48 | Sales (Cost) | Decimal | - | ||||
| 49 | Sales (Price) | Decimal | - | ||||
| 50 | Chargeable Filter | Boolean | - | ||||
| 51 | Gen. Prod. Posting Group | Code[20] | - | ||||
| 52 | Picture | Blob | Removed 18.0 | ||||
| Replaced by Image field | |||||||
| 53 | Post Code | Code[20] | - | ||||
| 54 | County | Text[30] | - | ||||
| 55 | Automatic Ext. Texts | Boolean | - | ||||
| 56 | No. Series | Code[20] | - | ||||
| 57 | Tax Group Code | Code[20] | - | ||||
| 58 | VAT Prod. Posting Group | Code[20] | - | ||||
| 59 | Country/Region Code | Code[10] | - | ||||
| 60 | IC Partner Purch. G/L Acc. No. | Code[20] | - | ||||
| 61 | Unit Group Exists | Boolean | - | ||||
| 140 | Image | Media | - | ||||
| 150 | Privacy Blocked | Boolean | - | ||||
| 720 | Coupled to CRM | Boolean | Pending 23.0 | ||||
| Replaced by flow field Coupled to Dataverse | |||||||
| 721 | Coupled to Dataverse | Boolean | - | ||||
| 900 | Qty. on Assembly Order | Decimal | - | ||||
| 950 | Use Time Sheet | Boolean | - | ||||
| 951 | Time Sheet Owner User ID | Code[50] | - | ||||
| 952 | Time Sheet Approver User ID | Code[50] | - | ||||
| 1700 | Default Deferral Template Code | Code[10] | - | ||||
| 5900 | Qty. on Service Order | Decimal | - | ||||
| 5901 | Service Zone Filter | Code[10] | - | ||||
| 5902 | In Customer Zone | Boolean | - | ||||
Keys, 9
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Name | - |
| Key3 | Gen. Prod. Posting Group | - |
| Key4 | Name | - |
| Key5 | Type | - |
| Key6 | Base Unit of Measure | - |
| Key7 | Resource Group No. | - |
| Key8 | SystemModifiedAt | - |
| Key9 | Coupled to CRM | - |
Procedures, 8
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Resource) | Boolean | public | - |
| ShowPriceListLines | (Enum Price Type, Enum Price Amount Type) | public | - | |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| DisplayMap | () | public | - | |
| GetUnitOfMeasureFilter | (Code[20], Code[10]) | Text | public | - |
| CreateTimeSheets | () | public | - | |
| CheckResourcePrivacyBlocked | (Boolean) | public | - | |
| TestNoEntriesExist | (Text[100]) | protected | - |
Events, 12
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterValidateShortcutDimCode | (var Record Resource, var Record Resource, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Resource, var Record Resource, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateNo | (var Record Resource, Record Resource, var Boolean) | - |
| Integration event | OnBeforeValidateBaseUnitOfMeasure | (var Record Resource, Record Resource, Integer, var Boolean) | - |
| Integration event | OnBeforeOnInsert | (var Record Resource, var Boolean, var Record Resource) | - |
| Integration event | OnBeforeValidateTimeSheetApproverUserID | (var Record Resource, var Boolean, Record Resource) | - |
| Integration event | OnBeforeAssistEdit | (var Record Resource, Record Resource, var Boolean, var Boolean) | - |
| Integration event | OnBeforeValidateCity | (var Record Resource, var Record Post Code, Integer, var Boolean) | - |
| Integration event | OnBeforeValidatePostCode | (var Record Resource, var Record Post Code, Integer, var Boolean) | - |
| Integration event | OnAfterValidatePostCode | (var Record Resource, Record Resource) | - |
| Integration event | OnValidateResourceGroupNoOnBeforeConfirm | (var Record Resource, Record Resource, var Boolean) | - |
| Integration event | OnBeforeCreateTimeSheets | (var Record Resource, var Boolean) | - |