Table 5964 Service Contract Line in 19
- App
- Base Application
Fields, 31Keys, 5Procedures, 11Events, 16
Versions171819202122232425262728latest
Source29
Fields, 31
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Contract Type | Enum Service Contract Type | - |
| 2 | Contract No. | Code[20] | - |
| 3 | Line No. | Integer | - |
| 4 | Contract Status | Option | - |
| 5 | Service Item No. | Code[20] | - |
| 6 | Description | Text[100] | - |
| 7 | Serial No. | Code[50] | - |
| 8 | Service Item Group Code | Code[10] | - |
| 9 | Customer No. | Code[20] | - |
| 10 | Ship-to Code | Code[10] | - |
| 11 | Item No. | Code[20] | - |
| 12 | Unit of Measure Code | Code[10] | - |
| 13 | Response Time (Hours) | Decimal | - |
| 14 | Last Planned Service Date | Date | - |
| 15 | Next Planned Service Date | Date | - |
| 16 | Last Service Date | Date | - |
| 17 | Last Preventive Maint. Date | Date | - |
| 18 | Invoiced to Date | Date | - |
| 19 | Credit Memo Date | Date | - |
| 20 | Contract Expiration Date | Date | - |
| 21 | Service Period | DateFormula | - |
| 22 | Line Value | Decimal | - |
| 23 | Line Discount % | Decimal | - |
| 24 | Line Amount | Decimal | - |
| 28 | Variant Code | Code[10] | - |
| 29 | Starting Date | Date | - |
| 30 | New Line | Boolean | - |
| 31 | Credited | Boolean | - |
| 32 | Line Cost | Decimal | - |
| 33 | Line Discount Amount | Decimal | - |
| 34 | Profit | Decimal | - |
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Contract Type, Contract No., Line No. | - |
| Key2 | Contract No., Line No., Contract Type | - |
| Key3 | Service Item No., Contract Status | - |
| Key4 | Contract Type, Contract No., Credited, New Line | - |
| Key5 | Customer No., Ship-to Code | - |
Procedures, 11
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| SetupNewLine | () | public | - | |
| CalculateNextServiceVisit | () | public | - | |
| UpdateContractAnnualAmount | (Boolean) | public | - | |
| HideDialogBox | (Boolean) | public | - | |
| TestStatusOpen | () | public | - | |
| GetStatusCheckSuspended | () | Boolean | public | - |
| SuspendStatusCheck | (Boolean) | public | - | |
| ShowComments | () | public | - | |
| ValidateServicePeriod | (Date) | public | - | |
| CreditMemoBaseExists | () | Boolean | public | - |
| LogContractLineChanges | (Record Service Contract Line) | public | - |
Events, 16
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCalculateNextServiceVisit | (Record Service Contract Header, Record Service Mgt. Setup) | - |
| Integration event | OnAfterGetServiceItem | (Record Service Contract Line, var Record Service Item) | - |
| Integration event | OnAfterSetupNewLine | (var Record Service Contract Line, Record Service Contract Header) | - |
| Integration event | OnAfterTestStatusOpen | (Record Service Contract Line, Integer) | - |
| Integration event | OnBeforeCheckServContractHeader | (Record Service Contract Header, var Boolean) | - |
| Integration event | OnBeforeValidateContractExpirationDate | (var Record Service Contract Line, var Record Service Contract Line, Integer, var Boolean) | - |
| Integration event | OnBeforeValidateLineAmount | (var Record Service Contract Line, var Record Service Contract Line, Integer, var Boolean) | - |
| Integration event | OnBeforeValidateLineDiscountPercent | (var Record Service Contract Line, var Record Service Contract Line, Integer, var Boolean) | - |
| Integration event | OnCalculateOtherLineAmountsOnAfterSetFilters | (var Record Service Contract Line) | - |
| Integration event | OnValidateServiceItemNoOnBeforeCheckSameItemExist | (var Record Service Contract Line, var Boolean) | - |
| Integration event | OnValidateServiceItemNoOnBeforeCheckSameCustomer | (Record Service Item, var Record Service Contract Header, var Boolean) | - |
| Integration event | OnValidateServiceItemNoOnBeforeModify | (Record Service Item, Record Service Contract Header) | - |
| Integration event | OnBeforeCreditMemoBaseExists | (Record Service Contract Line, var Boolean, var Boolean) | - |
| Integration event | OnUpdateContractAnnualAmountOnAfterGetServContractHeader | (var Record Service Contract Line, Record Service Contract Header, var Boolean) | - |
| Integration event | OnValidateServiceItemNoOnAfterCalcServiceItemNoIsNotEmpty | (var Record Service Contract Line, var Boolean) | - |
| Integration event | OnValidateServiceItemNoOnAfterInit | (var Record Service Contract Line, Record Service Contract Line) | - |