PR_Suppliers_Work (MRP1030)

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

Display Name: PR_Suppliers_Work
Physical Name: MRP1030
Technical Name: PR_Suppliers_Work

Group Display Name: Manufacturing PR
Group Technical Name: Manufacturing PR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PR_Suppliers_Work'].USERID AS 'PR_Suppliers_Work-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MRP1030 AS ['PR_Suppliers_Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PR_Suppliers_Work'].USERID = ['Users Master'].USERID
2	CB_I	CB	Boolean	CB	0
3	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PR_Suppliers_Work'].VENDORID AS 'PR_Suppliers_Work-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM MRP1030 AS ['PR_Suppliers_Work'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PR_Suppliers_Work'].VENDORID = ['PM Vendor Master File'].VENDORID
4	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
5	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
6	ACTIONTAKEN_I	Action Taken	Integer	DDL_PR_Action_Taken	0
7	MARKLINEGREEN_I	Markline Green	Integer	Markline_Green	0
8	PROCESSED	Processed	Boolean	Boolean	0