| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | SrcvCallID | Service Call No. | int | 11 | 0 | OSCL | | | Allow NULL? |
| 2 | Line | Row | int | 6 | 0 | | -1 | | Allow NULL? |
| 3 | PartType | Part Type | char | 1 | 0 | | I | I=Inventory, N=Travel/Labor | Allow NULL? |
| 4 | DocAbs | Document Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 5 | Object | Document Type | nvarchar | 20 | 0 | | 13 | 0, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 165=A/R Correction Invoice, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 234000031=Return Request, 234000032=Goods Return Request, 23=Sales Quotation, 540000006=Purchase Quotation, 67=Inventory Transaction | Allow NULL? |
| 6 | DocPstDate | Document Posting Date | date | 8 | 0 | | | | |
| 7 | ObjectType | Object Type | nvarchar | 20 | 0 | | 191 | | Allow NULL? |
| 8 | LogInstanc | Log Instance | int | 11 | 0 | | | | Allow NULL? |
| 9 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 10 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 11 | UserSign2 | User Signature 2 | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 13 | DocNumber | Document No. | int | 11 | 0 | | | | Allow NULL? |
| 14 | Transfered | Transfered | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 15 | VisOrder | Visual Order | int | 11 | 0 | | | | Allow NULL? |
| 16 | StckTrnDir | Inventory Transaction Direction | char | 1 | 0 | | | N=Transfer from Technician, T=Transfer to Technician | Allow NULL? |
| 17 | Instance | Instance | int | 6 | 0 | | 0 | | Allow NULL? |