Table 5940 Service Item in 28
- App
- Base Application
- Namespace
- Microsoft.Service.Item
Fields, 82Keys, 6Procedures, 7Events, 23
Versions171819202122232425262728latest
Source29
Fields, 82
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | - | ||||
| 2 | Serial No. | Code[50] | - | ||||
| 3 | Service Item Group Code | Code[10] | - | ||||
| 4 | Description | Text[100] | - | ||||
| 5 | Description 2 | Text[50] | - | ||||
| 6 | Status | Enum Service Item Status | - | ||||
| 7 | Priority | Enum Service Priority | - | ||||
| 8 | Customer No. | Code[20] | - | ||||
| 9 | Ship-to Code | Code[10] | - | ||||
| 10 | Item No. | Code[20] | - | ||||
| 11 | Unit of Measure Code | Code[10] | - | ||||
| 12 | Location of Service Item | Text[30] | - | ||||
| 13 | Sales Unit Price | Decimal | - | ||||
| 14 | Sales Unit Cost | Decimal | - | ||||
| 15 | Warranty Starting Date (Labor) | Date | - | ||||
| 16 | Warranty Ending Date (Labor) | Date | - | ||||
| 17 | Warranty Starting Date (Parts) | Date | - | ||||
| 18 | Warranty Ending Date (Parts) | Date | - | ||||
| 19 | Warranty % (Parts) | Decimal | - | ||||
| 20 | Warranty % (Labor) | Decimal | - | ||||
| 21 | Response Time (Hours) | Decimal | - | ||||
| 22 | Installation Date | Date | - | ||||
| 23 | Sales Date | Date | - | ||||
| 24 | Last Service Date | Date | - | ||||
| 25 | Default Contract Value | Decimal | - | ||||
| 26 | Default Contract Discount % | Decimal | - | ||||
| 28 | No. of Active Contracts | Integer | - | ||||
| 33 | Vendor No. | Code[20] | - | ||||
| 34 | Vendor Item No. | Code[50] | - | ||||
| 40 | Blocked | Enum Service Item Blocked | - | ||||
| 47 | No. Series | Code[20] | - | ||||
| 48 | Item Description | Text[100] | - | ||||
| 49 | Name | Text[100] | - | ||||
| 50 | Address | Text[100] | - | ||||
| 51 | Address 2 | Text[50] | - | ||||
| 52 | Post Code | Code[20] | - | ||||
| 53 | City | Text[30] | - | ||||
| 54 | Contact | Text[100] | - | ||||
| 55 | Phone No. | Text[30] | - | ||||
| 56 | Ship-to Name | Text[100] | - | ||||
| 57 | Ship-to Address | Text[100] | - | ||||
| 58 | Ship-to Address 2 | Text[50] | - | ||||
| 59 | Ship-to Post Code | Code[20] | - | ||||
| 60 | Ship-to City | Text[30] | - | ||||
| 61 | Ship-to Contact | Text[100] | - | ||||
| 62 | Ship-to Phone No. | Text[30] | - | ||||
| 63 | Usage (Cost) | Decimal | - | ||||
| 64 | Usage (Amount) | Decimal | - | ||||
| 65 | Invoiced Amount | Decimal | - | ||||
| 66 | Total Quantity | Decimal | - | ||||
| 67 | Total Qty. Invoiced | Decimal | - | ||||
| 68 | Resources Used | Decimal | - | ||||
| 69 | Parts Used | Decimal | - | ||||
| 70 | Cost Used | Decimal | - | ||||
| 71 | Vendor Name | Text[100] | - | ||||
| 72 | Vendor Item Name | Text[100] | - | ||||
| 73 | Comment | Boolean | - | ||||
| 74 | Service Item Components | Boolean | - | ||||
| 75 | Preferred Resource | Code[20] | - | ||||
| 76 | Variant Code | Code[10] | - | ||||
| 77 | County | Text[30] | - | ||||
| 78 | Ship-to County | Text[30] | - | ||||
| 79 | Contract Cost | Decimal | - | ||||
| 81 | Country/Region Code | Code[10] | - | ||||
| 82 | Ship-to Country/Region Code | Code[10] | - | ||||
| 83 | Name 2 | Text[50] | - | ||||
| 84 | Ship-to Name 2 | Text[50] | - | ||||
| 85 | Service Price Group Code | Code[10] | - | ||||
| 86 | Default Contract Cost | Decimal | - | ||||
| 87 | Prepaid Amount | Decimal | - | ||||
| 88 | Search Description | Code[100] | - | ||||
| 89 | Service Contracts | Boolean | - | ||||
| 90 | Total Qty. Consumed | Decimal | - | ||||
| 100 | Date Filter | Date | - | ||||
| 101 | Type Filter | Enum Service Ledger Entry Type | - | ||||
| 102 | Contract Filter | Code[20] | - | ||||
| 103 | Service Order Filter | Code[20] | - | ||||
| 104 | Sales/Serv. Shpt. Document No. | Code[20] | - | ||||
| 105 | Sales/Serv. Shpt. Line No. | Integer | - | ||||
| 106 | Shipment Type | Enum Service Item Shipment Type | - | ||||
| 211 | Ship-to E-Mail | Text[80] | - | ||||
| 721 | Coupled to Dataverse | Boolean | Removed 28.0 | ||||
| Field Service is moved to Field Service Integration app. | |||||||
Keys, 6
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Item No., Serial No. | - |
| Key3 | Customer No., Ship-to Code, Item No., Serial No. | - |
| Key4 | Warranty Ending Date (Parts), Customer No., Ship-to Code | - |
| Key5 | Sales/Serv. Shpt. Document No., Sales/Serv. Shpt. Line No. | - |
| Key6 | Service Item Group Code | - |
Procedures, 7
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Service Item) | Boolean | public | - |
| CheckIfCanBeDeleted | () | Text | public | - |
| OmitAssignResSkills | (Boolean) | public | - | |
| MessageIfServItemLinesExist | (Text) | public | - | |
| ErrorIfBlockedForServiceContract | () | internal | - | |
| ErrorIfBlockedForAll | () | internal | - | |
| ServItemLinesExist | () | Boolean | public | - |
Events, 23
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterAssignItemValues | (var Record Service Item, var Record Service Item, Record Item, Integer) | - |
| Integration event | OnAfterDeleteServItemComponents | (var Record Service Item) | - |
| Integration event | OnBeforeMessageIfServItemLinesExist | (Record Service Item, Text[100], var Text, var Boolean) | - |
| Integration event | OnBeforeServItemLinesExistErr | (var Record Service Item, Text[100], var Boolean) | - |
| Integration event | OnBeforeCheckIfCanBeDeleted | (var Record Service Item, var Text, var Boolean) | - |
| Integration event | OnBeforeValidateSerialNo | (var Record Service Item, var Record Service Item, var Boolean) | - |
| Integration event | OnAfterValidatePreferredResource | (var Record Service Item, var Record Service Item) | - |
| Integration event | OnBeforeValidateCustomerNo | (var Record Service Item, Integer, var Boolean) | - |
| Integration event | OnCheckifActiveServContLineExistOnAfterSetFilters | (var Record Service Contract Line) | - |
| Integration event | OnValidateCustomerNoOnAfterCalcShouldConfirmChange | (var Record Service Item, Integer, var Boolean) | - |
| Integration event | OnValidateShiptoCodeOnAfterCalcShouldConfirmChange | (var Record Service Item, Integer, var Boolean) | - |
| Integration event | OnBeforeValidatePreferredResource | (var Record Service Item, var Boolean) | - |
| Integration event | OnBeforeValidateWarrantyStartingDateLabor | (var Record Service Item, var Record Service Item, var Boolean) | - |
| Integration event | OnBeforeValidateWarrantyEndingDateLabor | (var Record Service Item, Record Service Item, var Boolean) | - |
| Integration event | OnBeforeValidateShiptoCode | (var Record Service Item, Record Service Item, var Boolean) | - |
| Integration event | OnValidateItemNoOnBeforeCheckCancelResSkillAssignment | (var Record Service Item, var Codeunit Resource Skill Mgt.) | - |
| Integration event | OnBeforeValidateWarrantyStartingDateParts | (var Record Service Item, var Record Service Item, var Record Item, var Boolean) | - |
| Integration event | OnBeforeInsertServiceItem | (var Record Service Item, var Record Service Item, var Boolean) | - |
| Integration event | OnBeforeDeleteServiceItem | (var Record Service Item, var Record Service Item, var Boolean) | - |
| Integration event | OnBeforeValidateItemNo | (var Record Service Item, var Record Service Item, var Boolean, var Boolean, var Record Resource Skill, var Boolean) | - |
| Integration event | OnBeforeMsgIfServItemLinesExist | (Integer, var Boolean) | - |
| Integration event | OnBeforeValidateWarrantyEndingDateParts | (var Record Service Item, Record Service Item, var Record Item, var Boolean) | - |
| Integration event | OnAfterServItemLinesExist | (var Record Service Item, var Record Service Item Line, Integer, var Boolean) | - |