Table 5971 Filed Contract Line in 17
- App
- Base Application
Versions171819202122232425262728latest
Source29
Fields, 32
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Contract Type | Option | - |
| 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 | - |
| 100 | Entry No. | Integer | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No., Line No. | - |