Objects/Tables/Table 156 Resource
Table 156 Resource in 17
Jonas Paprotka, Base Application 17.5.22499.32099, checked
- App
- Base Application
Fields, 59Keys, 8Procedures, 7Events, 7
Versions171819202122232425262728latest
Source29
Fields, 59
| 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 | Pending 15.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] | - |
| 140 | Image | Media | - |
| 150 | Privacy Blocked | 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, 8
| 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 | - |
Procedures, 7
| 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 | - |
Events, 7
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterValidateShortcutDimCode | (var Record Resource, var Record Resource, Integer, var Code[20]) | - |
| Integration event | OnBeforeAssistEdit | (var Record Resource, Record Resource, var Boolean) | - |
| Integration event | OnBeforeOnInsert | (var Record Resource, var Boolean) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Resource, var Record Resource, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateTimeSheetApproverUserID | (var Record Resource, var Boolean) | - |
| Integration event | OnBeforeValidateNo | (var Record Resource, Record Resource, var Boolean) | - |
| Integration event | OnBeforeValidateBaseUnitOfMeasure | (var Record Resource, Record Resource, Integer, var Boolean) | - |