| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SOPTYPE | SOP Type 1 = Quote |
Integer | 2 | View | |
| SOPNUMBE | SOP Number |
String | 22 | View | |
| CONSTS | Contract Record Type |
Integer | 2 | View | |
| CONTNBR | Contract Number |
String | 12 | View | |
| USERID | User ID |
String | 16 | View |