EXPV1003 - Picklist File | Prospr - Dynamics GP Table Reference

EXPV1003 - Picklist File

Query Builder

Select * from EXPV1003

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
SEQ_I	Seq	Long Integer	4	View
MANUFACTUREORDERST_I	Manufacture Order Status	Integer	2	View
PPN_I	PPN	String	32	View
ITEMNMBR	Item Number	String	32	View
POSITION_NUMBER	Position Number	Integer	2	View
ROUTINGNAME_I	RoutingName	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
MRPAMOUNT_I	MRP_Amount	Currency	10	View
MRPISSUEDATE_I	MRP_Issue Date	Date	4	View
ALLOCATEDATEI	Allocate_Date	Date	4	View
WCID_I	WC ID	String	12	View
BACKFLUSHITEM_I	Backflush Item	Boolean	2	View
ALTERNATE_I	Alternate	Boolean	2	View
ALTERNATEPARTFOR_I	Alternate Part For	String	32	View
SUBASSEMBLY_I	Subassembly	Boolean	2	View
SUBASSEMBLYOF_I	Subassembly Of	String	32	View
BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	2	View
BOMSINGLELOT_I	BOM_Single_Lot	Boolean	2	View
LOCNCODE	Location Code	String	12	View
ALLOCATED_I	Allocated	Boolean	2	View
ISSUED_I	Issued	Boolean	2	View
FLOORSTOCK_I	Floor Stock	Boolean	2	View
PHANTOM_I	Phantom	Boolean	2	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
ALLOCATEUID_I	Allocate UID	String	16	View
ISSUEDUID_I	Issued UID	String	16	View
NUMBERSCRAPPED_I	Number Scrapped	Currency	10	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
ACTUAL_CONSUMED_CHECK_I	Actual Consumed Check	Boolean	2	View
REQDATE	Required Date	Date	4	View
UOFM	U Of M	String	10	View
ATYALLOC	QTY Allocated	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
QTY_ISSUED_I	QTY Issued	Currency	10	View
QTY_BACKFLUSHED_I	QTY Backflushed	Currency	10	View
ITEMDESC	Item Description	String	102	View
LINK_TO_SEQUENCE_I	Link To Sequence	Long Integer	4	View
FIXED_QTY_I	Fixed Quantity	Currency	10	View
LEADTIMEOFFSET_I	Lead Time Offset	Currency	10	View
OFFSET_FROM_I	Offset From	Integer	2	View
BOMUSERDEF1_I	BOM User Def1	String	32	View
BOMUSERDEF2_I	BOM User Def2	String	32	View
BOMSEQ_I	BOM Seq	Long Integer	4	View
QTYREMAI	QTY Remaining	Currency	10	View

EXPV1003 - Picklist File

Query Builder

Customer Service

Information

My Account

Contact Us