| 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 | |
| USRDAT01 | User Defined Date 1  | 
									Date | 4 | View | |
| USRDAT02 | User Defined Date 2  | 
									Date | 4 | View | |
| USRTAB01 | User Defined Table 1  | 
									String | 22 | View | |
| USRTAB09 | User Defined Table 2  | 
									String | 22 | View | |
| USRTAB03 | User Defined Table 3  | 
									String | 22 | View | |
| USERDEF1 | User Defined 1  | 
									String | 22 | View | |
| USERDEF2 | User Defined 2  | 
									String | 22 | View | |
| USRDEF03 | User Defined 3  | 
									String | 22 | View | |
| USRDEF04 | User Defined 4  | 
									String | 22 | View | |
| USRDEF05 | User Defined 5  | 
									String | 22 | View | |
| COMMENT_1 | Comment[1]  | 
									String | 52 | View | |
| COMMENT_2 | Comment[2]  | 
									String | 52 | View | |
| COMMENT_3 | Comment[3]  | 
									String | 52 | View | |
| COMMENT_4 | Comment[4]  | 
									String | 52 | View | |
| CMMTTEXT | Comment Text  | 
									Text | 2 | View |