Table Name: ACT1
Table Description: Service Contract - Items
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ContractID | Contract No. | Int | 11 | OCTR | Â | Â | Â |
| Line | Row | Int | 11 | - | Â | Â | Â |
| ManufSN | Mfr. Serial No. | nVarChar | 36 | - | Â | Â | Â |
| InternalSN | Serial Number | nVarChar | 36 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| ItemName | Item Description | nVarChar | 200 | - | Â | Â | Â |
| ItemGroup | Item Group | Int | 6 | OITB | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| ItmGrpName | Item Group Name | nVarChar | 20 | - | Â | Â | Â |
| InsID | Customer Equipment Card ID | Int | 11 | OINS | Â | Â | Â |
| TermDate | Termination Date | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance - History | Int | 11 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ContractID |
| Â | Â | Line |
| Â | Â | LogInstanc |