| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| SOPNUMBE | SOP Number |
String | 22 | View | |
| SOPTYPE | SOP Type 1 = Quote |
Integer | 2 | View | |
| CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| TRXSORCE | TRX Source |
String | 14 | 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 |