MOP_Comp_Trx_PickDoc_Tab_WORK (MOPW300)

azurecurve Products Manufacturing (346)3rd PartyMOP_Comp_Trx_PickDoc_Tab_WORK (MOPW300)

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

Display Name: MOP_Comp_Trx_PickDoc_Tab_WORK
Physical Name: MOPW300
Technical Name: MOP_Comp_Trx_PickDoc_Tab_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID2_I	User ID2	String	STR15_User_ID	15
2	PICKNUMBER	Pick Number	String	STR17_LBAU_Pick_Number	17
3	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
4	PICKLISTSEQ	Picklist Seq	Long Integer	LINT_10	10
5	PICKDOCLINENUM	Pick Doc Line Number	Long Integer	LI_Sequence_Number	10
6	DSCRIPTN	Description	String	STR30	30
7	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MOP_Comp_Trx_PickDoc_Tab_WORK'].ITEMNMBR AS 'MOP_Comp_Trx_PickDoc_Tab_WORK-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOPW300 AS ['MOP_Comp_Trx_PickDoc_Tab_WORK'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP_Comp_Trx_PickDoc_Tab_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
8	ITEMDESC	Item Description	String	STR100	100
9	POSITION_NUMBER	Position Number	Integer	INT4_RB_U0	4
10	ORIGPICKNUMBER	Originating Pick Number	String	STR17_LBAU_Pick_Number	17
11	ORIG_PICK_DOC_LINE_NUM	Originating Pick Doc Line Number	Long Integer	LI_Sequence_Number	10
12	BOMTYPE_I	BOM Type	Integer	DDL_BOM_Type	0
13	TRXQTY	TRX QTY	Currency	DLR17_QTY_RBS0_STR	17
14	UOFM	U Of M	String	U_Of_M	8
15	TO_SITE_I	To Site	String	STR10_Location_Code	10
16	FROM_SITE_I	From Site	String	STR10_Location_Code	10
17	MOP_REQUIRED_QUANTITY_I	MOP Required Quantity	Currency	DLR14_RS5	0
18	U_Of_M_2	U Of M 2	String	U_Of_M	8
19	REQDATE	Required Date	Date	DATE_L	0
20	FGDITMNM	Finished Good Item Number	String	Item_Number	30
21	ALTERNATEPARTFOR_I	Alternate Part For	String	STR30_Item_Number	30
22	ALT_FOR_SEQ_I	Alternate For Sequence	Long Integer	LINT_10	10
23	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
24	BACKFLUSHCB	Backflush CB	Boolean	CB_Backflush	0
25	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MOP_Comp_Trx_PickDoc_Tab_WORK'].USERID AS 'MOP_Comp_Trx_PickDoc_Tab_WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOPW300 AS ['MOP_Comp_Trx_PickDoc_Tab_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MOP_Comp_Trx_PickDoc_Tab_WORK'].USERID = ['Users Master'].USERID
26	DATEPICKED	Date Picked	Date	Date	6
27	QTYBSUOM	QTY In Base U Of M	Currency	DLR17_QTY_RBS0_STR	17
28	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
29	QTYSLCTD	QTY Selected	Currency	DLR17_QTY_RBS0_UTR	17
30	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
31	CB_I	CB	Boolean	CB	0
32	STR20DUMMY_I	STR20 Dummy	String	STR20	20
33	JOBNUMBER_I	Job Num	String	STR30	30
34	INITIAL_QTY_I	Initial QTY	Currency	DLR17_QTY_RBS0_STR	17

azurecurve Products Manufacturing (346)3rd PartyMOP_Comp_Trx_PickDoc_Tab_WORK (MOPW300)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply