MOPW300 - MOP_Comp_Trx_PickDoc_Tab_WORK | Prospr

MOPW300 - MOP_Comp_Trx_PickDoc_Tab_WORK

Select * from MOPW300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID2_I	User ID2	String	16	View
PICKNUMBER	Pick Number	String	18	View
MANUFACTUREORDER_I	Manufacture Order	String	32	View
PICKLISTSEQ	Picklist Seq	Long Integer	4	View
PICKDOCLINENUM	Pick Doc Line Number	Long Integer	4	View
DSCRIPTN	Description	String	32	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
POSITION_NUMBER	Position Number	Integer	2	View
ORIGPICKNUMBER	Originating Pick Number	String	18	View
ORIG_PICK_DOC_LINE_NUM	Originating Pick Doc Line Number	Long Integer	4	View
BOMTYPE_I	BOM Type	Integer	2	View
TRXQTY	TRX QTY	Currency	10	View
UOFM	U Of M	String	10	View
TO_SITE_I	To Site	String	12	View
FROM_SITE_I	From Site	String	12	View
MOP_REQUIRED_QUANTITY_I	MOP Required Quantity	Currency	10	View
U_Of_M_2	U Of M 2	String	10	View
REQDATE	Required Date	Date	4	View
FGDITMNM	Finished Good Item Number	String	32	View
ALTERNATEPARTFOR_I	Alternate Part For	String	32	View
ALT_FOR_SEQ_I	Alternate For Sequence	Long Integer	4	View
BOMSINGLELOT_I	BOM_Single_Lot	Boolean	2	View
BACKFLUSHCB	Backflush CB	Boolean	2	View
USERID	User ID	String	16	View
DATEPICKED	Date Picked	Date	4	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
QTYSLCTD	QTY Selected	Currency	10	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
CB_I	CB	Boolean	2	View
STR20DUMMY_I	STR20 Dummy	String	22	View
JOBNUMBER_I	Job Num	String	32	View
INITIAL_QTY_I	Initial QTY	Currency	10	View