IS010201 - Shipping History Line Hist | Prospr

IS010201 - Shipping History Line Hist

Select * from IS010201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SOPNUMBE	SOP Number	String	22	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
DATE1	Date	Date	4	View
DTSEQNUM	Date SEQ Number	Currency	10	View
TIME1	Time	Time	4	View
QUANTITY	QTY	Currency	10	View
SOSHIPPINGWEIGHT_I	SO Shipping Weight	Long Integer	4	View
SHIPPINGUOFM_I	Shipping U Of M	Integer	2	View
UPSZONE	UPS Zone	String	4	View
SOQTYPACKAGES_I	SO Qty Packages	Currency	10	View
SOBOLNUMBER_I	SO BOL Number	String	26	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
USERID	User ID	String	16	View
SHIPMTHD	Shipping Method	String	16	View
SOPFOB_I	SOP_FOB	String	16	View
QTY_In_Variable_U_Of_M	QTY In Variable U Of M	Currency	10	View
Variable_U_Of_M	Variable U Of M	String	10	View
Backout_Extended_Price	Backout Extended Price	Currency	10	View
Tracking_Number	Tracking Number	String	42	View