Table Name: OCTT
Table Description: Contract Template
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TmpltName | Template Name | nVarChar | 20 | - | Â | Â | Â |
| Deleted | Deleted | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Renewal | Renewal | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RemindVal | Remind Before Renewal | Int | 6 | - | Â | Â | Â |
| RemindUnit | Remind Unit | VarChar | 1 | - | D | D | Day(s) |
| Â | Â | Â | Â | Â | Â | W | Week(s) |
| Â | Â | Â | Â | Â | Â | M | Month(s) |
| Duration | Duration of Coverage | Int | 6 | - | Â | Â | Â |
| ResponsVal | Resolution Value | Int | 6 | - | Â | Â | Â |
| ResponsUnt | Resolution Unit | VarChar | 1 | - | D | D | Day(s) |
| Â | Â | Â | Â | Â | Â | H | Hour(s) |
| Descriptio | Description | nVarChar | 254 | - | Â | Â | Â |
| PriceList | Price List No. | Int | 6 | - | Â | Â | Â |
| CntrctType | Contract Type | VarChar | 1 | - | S | C | Customer |
| Â | Â | Â | Â | Â | Â | G | Item Group |
| Â | Â | Â | Â | Â | Â | S | Serial Number |
| MonEnabled | Monday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TueEnabled | Tuesday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| WedEnabled | Wednesday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ThuEnabled | Thursday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FriEnabled | Friday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SatEnabled | Saturday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SunEnabled | Sunday Enabled | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MonStart | Monday Start | Int | 6 | - | 800 | Â | Â |
| MonEnd | Monday End | Int | 6 | - | 1700 | Â | Â |
| TueStart | Tuesday Start | Int | 6 | - | 800 | Â | Â |
| TueEnd | Tuesday End | Int | 6 | - | 1700 | Â | Â |
| WedStart | Wednesday Start | Int | 6 | - | 800 | Â | Â |
| WedEnd | Wednesday End | Int | 6 | - | 1700 | Â | Â |
| ThuStart | Thursday Start | Int | 6 | - | 800 | Â | Â |
| ThuEnd | Thursday End | Int | 6 | - | 1700 | Â | Â |
| FriStart | Friday Start | Int | 6 | - | 800 | Â | Â |
| FriEnd | Friday End | Int | 6 | - | 1700 | Â | Â |
| SatStart | Saturday Start | Int | 6 | - | 0 | Â | Â |
| SatEnd | Saturday End | Int | 6 | - | 2359 | Â | Â |
| SunStrart | Sunday Start | Int | 6 | - | 0 | Â | Â |
| SunEnd | Sunday End | Int | 6 | - | 2359 | Â | Â |
| InclParts | Include Parts | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| InclWork | Include Labor | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| InclTravel | Include Travel | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Attachment | Attachments | Text | 16 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| Remark | Remarks | Text | 16 | - | Â | Â | Â |
| InclHldays | Include Holidays | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ResponseV | Response Value | Int | 6 | - | Â | Â | Â |
| ResponseU | Response Unit | VarChar | 1 | - | H | H | Hour(s) |
| Â | Â | Â | Â | Â | Â | D | Day(s) |
| AtcEntry | Attachment Entry | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TmpltName |