| 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 | |
| ITEMNMBR | Item Number |
String | 32 | View | |
| PROMOSTS | PromotionStatus |
Integer | 2 | View | |
| PROMOTYP | PromotionType |
Integer | 2 | View | |
| PSITMVAL | PriceSheetItemValue |
Currency | 10 | View | |
| FREEITEM | FreeItem |
String | 32 | View | |
| FREEUOFM | FreeItemUofM |
String | 10 | View | |
| PRMCMSEQ | PromotionComponentSequence |
Long Integer | 4 | View | |
| PRMLISEQ | PromotionLineItemSequence |
Long Integer | 4 | View |