Table Name: SCL2
Table Description: Service Call Inventory Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SrcvCallID | Service Call No. | Int | 11 | OSCL | Â | Â | Â |
| Line | Row | Int | 6 | - | -1 | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| ItemName | Item Description | nVarChar | 200 | - | Â | Â | Â |
| TransToTec | Transfer to Technican | Num | 19.6 | - | Â | Â | Â |
| Delivered | Delivered | Num | 19.6 | - | Â | Â | Â |
| RetFromTec | Returned from Technician | Num | 19.6 | - | Â | Â | Â |
| Returned | Returned | Num | 19.6 | - | Â | Â | Â |
| Bill | Bill | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| QtyToBill | Quantity to Bill | Num | 19.6 | - | Â | Â | Â |
| QtyToInv | Invoiced Qty | Num | 19.6 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | - | 191 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UserSign2 | User Signature 2 | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SrcvCallID |
| Â | Â | Line |