MPS Transaction Log (MF010430)

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

Display Name: MPS Transaction Log
Physical Name: MF010430
Technical Name: MF_TRX_Log

Group Display Name: Manufacturing MPS
Group Technical Name: Manufacturing MPS

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PLANNAME_I	Plan Name	String	STR15	15
2	MFLINEITEM_I	MF Line Item	Integer	INT3	3
3	DATE1	Date	Date	DT6	6
4	POSTEDDT	Posted Date	Date	DATE	6
5	TIME1	Time	Time	TM6	6
6	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MPS Transaction Log'].USERID AS 'MPS Transaction Log-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MF010430 AS ['MPS Transaction Log'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MPS Transaction Log'].USERID = ['Users Master'].USERID
7	SUCCESSFULTRX_I	SuccessfulTrx	Boolean	CB	0
8	TRANSACTIONRESULT_I	Transaction Result	Integer	Transaction Result	0
9	STARTQTY_I	Start QTY	Currency	DLR_14_MRP	14
10	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
11	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MPS Transaction Log'].ITEMNMBR AS 'MPS Transaction Log-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MF010430 AS ['MPS Transaction Log'] INNER JOIN IV00101 AS ['Item Master'] ON ['MPS Transaction Log'].ITEMNMBR = ['Item Master'].ITEMNMBR
12	ROUTINGNAME_I	RoutingName	String	STR30_Item_Number	30
13	SCHEDULINGPREFEREN_I	Scheduling Preference	String	STR20	20
14	DRAWFROMSITE_I	Draw From Site	String	STR10_Location_Code	10
15	POSTTOSITE_I	Post To Site	String	STR10_Location_Code	10
16	BOMCAT_I	BOM Cat	Integer	DDL_BOM_Cat	0
17	BOMNAME_I	BOM Name	String	STR15_LBU	15
18	COMMENTS1000_I	Comments1000	Text	TXT1000	1000