MOP Receipt TEMP WORK (MOPW500)

azurecurve Products Manufacturing (346)3rd PartyMOP Receipt TEMP WORK (MOPW500)

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

Display Name: MOP Receipt TEMP WORK
Physical Name: MOPW500
Technical Name: MOP_Receipt_TEMP_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MOPRCTNM	MOP Receipt Number	String	STR20_Document_Number_Receipt	20
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MOP Receipt TEMP WORK'].ITEMNMBR AS 'MOP Receipt TEMP WORK-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOPW500 AS ['MOP Receipt TEMP WORK'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP Receipt TEMP WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	PICKLISTSEQ	Picklist Seq	Long Integer	LINT_10	10
4	POSITION_NUMBER	Position Number	Integer	INT4_RB_U0	4
5	POSITION_NUMBER2	Position Number2	Integer	INT4_RB_U0	4
6	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MOP Receipt TEMP WORK'].USERID AS 'MOP Receipt TEMP WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOPW500 AS ['MOP Receipt TEMP WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MOP Receipt TEMP WORK'].USERID = ['Users Master'].USERID
7	ITEMDESC	Item Description	String	STR100	100
8	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
9	QTYPLANNEDTOCONSUME	QTY Planned To Consume	Currency	DLR17_QTY_RBS0_STR	17
10	QTYPLANNEDTOBACKFLUSH	QTY Planned To Backflush	Currency	DLR17_QTY_RBS0_UTR	17
11	QTYTOCONSUME	QTY To Consume	Currency	DLR17_QTY_RBS0_UTR	17
12	QTYTOBACKFLUSH	QTY To Backflush	Currency	DLR17_QTY_RBS0_STR	17
13	BACKFLUSHSITEID	Backflush Site ID	String	STR10_Location_Code	10
14	BYPRODUCTSITEID	Byproduct Site ID	String	STR10_Location_Code	10
15	QTYTOUSE	QTY To Use	Currency	DLR17_RBS0_UTR$	17
16	UOFM	U Of M	String	U_Of_M	8
17	MOP_REQUIRED_QUANTITY_I	MOP Required Quantity	Currency	DLR14_RS5	0
18	WIPQUANTITY	WIP Quantity	Currency	DLR17_QTY_RBS0_STR	17
19	QTYAVAIL	QTY Available	Currency	DLR17_QTY_RBS0_UTR	17
20	QTYCONSUMEDTODATE	QTY Consumed To Date	Currency	DLR17_QTY_RBS0_STR	17
21	QTYBACKFLUSHEDTODATE	QTY Backflushed To Date	Currency	DLR17_QTY_RBS0_STR	17
22	QTYSLCTD	QTY Selected	Currency	DLR17_QTY_RBS0_UTR	17
23	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
24	NUMBERSCRAPPED_I	Number Scrapped	Currency	DLR_14_MRP	14
25	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
26	BACKFLUSHCB	Backflush CB	Boolean	CB_Backflush	0
27	ATYALLOC	QTY Allocated	Currency	DLR17_QTY_RBS0_UTR	17
28	PLNDFIXDQTYTOCONS	Planned Fixed Quantity to Consume	Currency	DLR17_QTY_RBS0_UTR	17
29	PLNDFIXDQTYTOBF	Planned Fixed Quantity to Backflush	Currency	DLR17_QTY_RBS0_UTR	17
30	FIXDQTYTOCONS	Fixed Quantity to Consume	Currency	DLR17_QTY_RBS0_UTR	17
31	FIXDQTYTOBF	Fixed Quantity to Backflush	Currency	DLR17_QTY_RBS0_UTR	17
32	QTYSELCTDBF	QTY Selected Backflushed	Currency	DLR17_QTY_RBS0_UTR	17
33	FLOORSTOCK_I	Floor Stock	Boolean	CB	0
34	NONINVENTORY	Non Inventory	Boolean	CB	0
35	STR20DUMMY_I	STR20 Dummy	String	STR20	20
36	ITEMTYPE	Item Type	Integer	DDL_Item_Type	0
37	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['MOP Receipt TEMP WORK'].NOTEINDX AS 'MOP Receipt TEMP WORK-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM MOPW500 AS ['MOP Receipt TEMP WORK'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['MOP Receipt TEMP WORK'].NOTEINDX = ['Record Notes Master'].NOTEINDX
38	SUBASSEMBLYOF_I	Subassembly Of	String	STR30	30

azurecurve Products Manufacturing (346)3rd PartyMOP Receipt TEMP WORK (MOPW500)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply