PK010033 - Picklist File | Prospr - Dynamics GP Table Reference

PK010033 - Picklist File

Query Builder

Select * from PK010033

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
MRPAMOUNT2_I	MRP_Amount2	Currency	10	View
SUGGESTEDQTY_I	Suggested QTY	Currency	10	View
MRPISSUEDATE_I	MRP_Issue Date	Date	4	View
MRPISSUETIME_I	MRP_Issue Time	Time	4	View
ALLOCATEDATEI	Allocate_Date	Date	4	View
ALLOCATETIMEI	Allocate_Time	Time	4	View
WCID_I	WC ID	String	12	View
BACKFLUSHITEM_I	Backflush Item	Boolean	2	View
ICBACKORDER_I	IC Backorder	Boolean	2	View
ALTERNATE_I	Alternate	Boolean	2	View
ALTERNATEPARTFOR_I	Alternate Part For	String	32	View
ALT_FOR_SEQ_I	Alternate For Sequence	Long Integer	4	View
SUBASSEMBLY_I	Subassembly	Boolean	2	View
SUBASSEMBLYOF_I	Subassembly Of	String	32	View
SUBASSEMBLY_OF_SEQ	Subassembly Of Seq	Long Integer	4	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
CALCMRP_I	Calc MRP	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
RELIEFCOST_I	Relief Cost	Currency	10	View
RETURNTOSTOCK_I	Return To Stock	Currency	10	View
NUMBERSCRAPPED_I	Number Scrapped	Currency	10	View
ACTUAL_CONSUMED_I	Actual Consumed	Currency	10	View
PORDNMBR	Purchase Order Number	String	22	View
POLINE_I	PO Line Item	Integer	2	View
QTY_ALLOWED_I	QTY Allowed	Currency	10	View
CURRENT_CONSUMED_I	Current Consumed	Currency	10	View
CURRENT_RTS_I	Current RTS	Currency	10	View
CURRENT_SCRAPPED_I	Current Scrapped	Currency	10	View
OPTIONED_ITEM_I	Optioned Item	Boolean	2	View
MRKDNAMT	Markdown Amount	Currency	10	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
PROMOTION_ID_I	Promotion ID	String	32	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
NON_INV_CRED_ACCT_IDX_I	Non Inventory Credit Account Index	Long Integer	4	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
QTY_ISSUED_I	QTY Issued	Currency	10	View
QTY_BACKFLUSHED_I	QTY Backflushed	Currency	10	View
NON_INV_ITEM_DESC_I	Non Inventory Item Description	String	52	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
EXPLODE_QTY_I	Explode Quantity	Currency	10	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
BOMSEQ_I	BOM Seq	Long Integer	4	View
POSITION_NUMBER2	Position Number2	Integer	2	View

PK010033 - Picklist File

Query Builder

Customer Service

Information

My Account

Contact Us