Table 5940 Service Item in 22
- App
- Base Application
Fields, 79Keys, 6Procedures, 4Events, 21
Versions171819202122232425262728latest
Source29
Fields, 79
| 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 | Option | - |
| 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] | - |
| 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 | Option | - |
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, 4
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Service Item) | Boolean | public | - |
| CheckIfCanBeDeleted | () | Text | public | - |
| OmitAssignResSkills | (Boolean) | public | - | |
| MessageIfServItemLinesExist | (Text) | public | - |
Events, 21
| 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) | - |