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 | |
CUSTNMBR | Customer Number |
String | 16 | View | |
CUSTNAME | Customer Name |
String | 66 | View | |
CSTPONBR | Customer PO Number |
String | 22 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
UOFM | U Of M |
String | 10 | View | |
PRCLEVEL | PriceLevel |
String | 12 | View | |
EXTDCOST | Extended Cost |
Currency | 10 | View | |
XTNDPRCE | Extended Price |
Currency | 10 | View | |
QTYFULFI | QTY Fulfilled |
Currency | 10 | View |