Table Name: SCL6
Table Description: Service Call Scheduling
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SrcvCallID | Service Call No. | Int | 11 | OSCL | Â | Â | Â |
| Line | Row | Int | 6 | - | Â | Â | Â |
| Technician | Technician | Int | 11 | OHEM | Â | Â | Â |
| HandledBy | Handled by User | Int | 6 | OUSR | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| StartTime | Start Time | Int | 11 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| EndTime | End Time | Int | 11 | - | Â | Â | Â |
| Duration | Service Call Duration | Num | 19.6 | - | Â | Â | Â |
| Location | Location | Int | 6 | OCLO | -1 | Â | Â |
| AddressId | Address Code | nVarChar | 50 | - | Â | Â | Â |
| Address | Address | nVarChar | 254 | - | Â | Â | Â |
| Reminder | Reminder | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RemQty | Reminder Quantity | Num | 19.6 | - | Â | Â | Â |
| DisplInCal | Display in Calendar | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Unsched | Unscheduled Call | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DurType | Duration UoM | VarChar | 1 | - | M | S | Seconds |
| Â | Â | Â | Â | Â | Â | M | Minutes |
| Â | Â | Â | Â | Â | Â | H | Hours |
| Â | Â | Â | Â | Â | Â | D | Days |
| RemType | Reminder UoM | VarChar | 1 | - | M | S | Seconds |
| Â | Â | Â | Â | Â | Â | M | Minutes |
| Â | Â | Â | Â | Â | Â | H | Hours |
| Â | Â | Â | Â | Â | Â | D | Days |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| RemDate | Reminder Date | Date | 8 | - | Â | Â | Â |
| RemSent | Reminder Sent | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RemTime | Reminder Time | Int | 6 | - | Â | Â | Â |
| Street | Street | nVarChar | 100 | - | Â | Â | Â |
| City | City | nVarChar | 100 | - | Â | Â | Â |
| Room | Room | nVarChar | 50 | - | Â | Â | Â |
| State | State | nVarChar | 3 | OCST | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| Address2 | Address Name 2 | nVarChar | 50 | - | Â | Â | Â |
| Address3 | Address Name 3 | nVarChar | 50 | - | Â | Â | Â |
| AddrType | Address Type | nVarChar | 100 | - | Â | Â | Â |
| StreetNo | Street No. | nVarChar | 100 | - | Â | Â | Â |
| ZipCode | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| Block | Block | nVarChar | 100 | - | Â | Â | Â |
| County | County | nVarChar | 100 | - | Â | Â | Â |
| TaxOffice | Tax Office | nVarChar | 50 | - | Â | Â | Â |
| GlblLocNum | Global Location Number | nVarChar | 50 | - | Â | Â | Â |
| ActualDur | Actual Duration | Num | 19.6 | - | Â | Â | Â |
| ActDurType | Actual Duration UoM | VarChar | 1 | - | M | S | Seconds |
| Â | Â | Â | Â | Â | Â | M | Minutes |
| Â | Â | Â | Â | Â | Â | H | Hours |
| Â | Â | Â | Â | Â | Â | D | Days |
| Close | Close | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Remark | Remarks | nVarChar | 254 | - | Â | Â | Â |
| AddrTypeBS | Address Type | VarChar | 1 | - | Â | S | Ship To |
| Â | Â | Â | Â | Â | Â | B | Bill To |
| SignName | Signature Name | nVarChar | 100 | - | Â | Â | Â |
| SaleOrders | Sales Orders | nVarChar | 100 | - | Â | Â | Â |
| ChkInDate | Check in Date | Date | 8 | - | Â | Â | Â |
| ChkInTime | Check in Time | Int | 11 | - | Â | Â | Â |
| ChkInLoc | Check in Location | nVarChar | 254 | - | Â | Â | Â |
| ChkLontitu | Check in Longitude | nVarChar | 14 | - | Â | Â | Â |
| ChkLatitu | Check in Latitude | nVarChar | 13 | - | Â | Â | Â |
| ChkOutDate | Check out Date | Date | 8 | - | Â | Â | Â |
| ChkOutTime | Check out Time | Int | 11 | - | Â | Â | Â |
| SignData | Signature Data | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SrcvCallID |
| Â | Â | Line |