MOP_PickDoc_Line (MOP1210)

azurecurve Products Manufacturing (346)3rd PartyMOP_PickDoc_Line (MOP1210)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1210

Display Name: MOP_PickDoc_Line
Physical Name: MOP1210
Technical Name: MOP_PickDoc_Line

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PICKNUMBER	Pick Number	String	STR17_LBAU_Pick_Number	17
2	PICKDOCLINENUM	Pick Doc Line Number	Long Integer	LI_Sequence_Number	10
3	POSITION_NUMBER	Position Number	Integer	INT4_RB_U0	4
4	ORIGPICKNUMBER	Originating Pick Number	String	STR17_LBAU_Pick_Number	17
5	ORIG_PICK_DOC_LINE_NUM	Originating Pick Doc Line Number	Long Integer	LI_Sequence_Number	10
6	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
7	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MOP_PickDoc_Line'].ITEMNMBR AS 'MOP_PickDoc_Line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOP1210 AS ['MOP_PickDoc_Line'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP_PickDoc_Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
8	PICKLISTSEQ	Picklist Seq	Long Integer	LINT_10	10
9	TRXQTY	TRX QTY	Currency	DLR17_QTY_RBS0_STR	17
10	UOFM	U Of M	String	U_Of_M	8
11	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MOP_PickDoc_Line'].USERID AS 'MOP_PickDoc_Line-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOP1210 AS ['MOP_PickDoc_Line'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MOP_PickDoc_Line'].USERID = ['Users Master'].USERID
12	DATEPICKED	Date Picked	Date	Date	6
13	TO_SITE_I	To Site	String	STR10_Location_Code	10
14	FROM_SITE_I	From Site	String	STR10_Location_Code	10
15	QTYBSUOM	QTY In Base U Of M	Currency	DLR17_QTY_RBS0_STR	17
16	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
17	ATYALLOC	QTY Allocated	Currency	DLR17_QTY_RBS0_UTR	17
18	JOBNUMBER_I	Job Num	String	STR30	30
19	BINNMBR	Bin Number	String	STR20	20
20	PENDING_QTY_I	Pending Quantity	Currency	DLR17_QTY_RBS0_UTR	17
21	QTYSLCTD	QTY Selected	Currency	DLR17_QTY_RBS0_UTR	17
22	TRX_TYPE	TRX Type	Integer	DDL_TRX_Type_I	0
23	QTYPICKED	QTY Picked	Currency	DLR17_QTY_RBS0_STR	17
24	MRPAMOUNT_I	MRP_Amount	Currency	DLR_14_MRP	14
25	REQDATE	Required Date	Date	DATE_L	0
26	SUBASSEMBLYOF_I	Subassembly Of	String	STR30	30
27	ALTERNATEPARTFOR_I	Alternate Part For	String	STR30_Item_Number	30
28	ALT_FOR_SEQ_I	Alternate For Sequence	Long Integer	LINT_10	10
29	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
30	BACKFLUSHITEM_I	Backflush Item	Boolean	CB_Backflush Item	0
31	QTY_ISSUED_I	QTY Issued	Currency	DLR17_QTY_RBS0_UTR	17

azurecurve Products Manufacturing (346)3rd PartyMOP_PickDoc_Line (MOP1210)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply