| 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 |