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