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 | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
REPTING | Repeating 0 = Non-repeating document |
Boolean | 2 | View | |
TRXFREQU | TRX Frequency 1 = Weekly |
Integer | 2 | View | |
TIMETREP | Times To Repeat |
Integer | 2 | View | |
DYSTINCR | Days to Increment |
Integer | 2 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
QTYTBAOR | QTY To Back Order |
Currency | 10 | View | |
DUEDATE | Due Date |
Date | 4 | View | |
STSDESCR | Status Description |
String | 32 | View | |
Status | Status |
Integer | 2 | View | |
CALCMRP_I | Calc MRP |
Boolean | 2 | View | |
MRPEXCEPTIONSARRAY_1 | MRP_Exceptions_Array[1] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_2 | MRP_Exceptions_Array[2] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_3 | MRP_Exceptions_Array[3] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_4 | MRP_Exceptions_Array[4] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_5 | MRP_Exceptions_Array[5] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_6 | MRP_Exceptions_Array[6] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_7 | MRP_Exceptions_Array[7] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_8 | MRP_Exceptions_Array[8] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_9 | MRP_Exceptions_Array[9] |
Integer | 2 | View | |
MRPEXCEPTIONSARRAY_10 | MRP_Exceptions_Array[10] |
Integer | 2 | View | |
BUYERID | Buyer ID |
String | 16 | View | |
PLANNERID | Planner ID |
String | 16 | View |