Manufacture Order Reporting Options (WOUF0132)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Manufacture Order Reporting Options
Physical Name: WOUF0132
Technical Name: MOP_Report_Options

Group Display Name: Manufacturing MOP
Group Technical Name: Manufacturing MOP

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	REPORTINDEX_I	Report Index	DLR14	Currency	10	14
2	REPORTOPTION_I	Report Option	STR20	String	22	20
3	SORTBY	Sort By	DDL_Sort_By	Integer	2	0
4	ASKECHTM	Ask Each Time	CB_Ask_Each_Time	Boolean	2	0
5	INCLGNDS	Include Legends	CB_Include_Legends	Boolean	2	0
6	PRNTOFIL	Print to File	CB_Print_to_File	Boolean	2	0
7	PRTOPRTR	Print to Printer	CB_Print_to_Printer	Boolean	2	0
8	PRTOSCRN	Print to Screen	CB_Print_to_Screen	Boolean	2	0
9	IFFILXST	If File Existing	GB	Integer	2	0
10	FILEXPNM	File Export Name	STR255	String	256	255
11	EXPTTYPE	Export Type	INT	Integer	2	0
12	MANORDERSTART_I	Manufacture Order Start	STR30_UC	String	32	30
13	MANORDEREND_I	Manufacture Order End	STR30_UC	String	32	30
14	STTITNUM	Start Item Number	STR30_Item_Number	String	32	30
15	ENITMNBR	End Item Number	STR30_Item_Number	String	32	30
16	ROUTINGNAMESTART_I	RoutingName Start	STR30_Item_Number	String	32	30
17	ROUTINGNAMEEND_I	RoutingName End	STR30_Item_Number	String	32	30
18	STRTDATE	Start Date	DT	Date	4	8
19	ENDDATE	End Date	DT	Date	4	8
20	RTSEQNUMSTART_I	rtseqnum Start	STR10	String	12	10
21	RTSEQNUMEND_I	rtseqnum End	STR10	String	12	10
22	START_MO_DESCRIPTION	Start MO Description	STR30	String	32	30
23	END_MO_DESCRIPTION	End MO Description	STR30	String	32	30
24	Start_MO_Status	Start MO Status	DDL_WO_Status	Integer	2	0
25	End_MO_Status	End MO Status	DDL_WO_Status	Integer	2	0
26	STARTWCID_I	Start WC ID	STR10_Location_Code	String	12	10
27	ENDWCID_I	End WC ID	STR10_Location_Code	String	12	10
28	STRTMCID	Start Machine ID	STR10_Location_Code	String	12	10
29	ENDMACID	End Machine ID	STR10_Location_Code	String	12	10
30	Start_MRP_Issue_Date	Start MRP Issue Date	DATE	Date	4	6
31	End_MRP_Issue_Date	End MRP Issue Date	DATE	Date	4	6
32	STVNDRID	Start Vendor ID	STR15_LBU	String	16	15
33	ENDVNDID	End Vendor ID	STR15_LBU	String	16	15
34	START_PICK_NUMBER	Start Pick Number	STR17_LBAU	String	18	17
35	END_PICK_NUMBER	End Pick Number	STR17_LBAU	String	18	17
36	STTUSRID	Start User ID	STR15_User_ID	String	16	15
37	ENDUSRID	End User ID	STR15_User_ID	String	16	15
38	STARTMORECEIPTNUMBER	Start MO Receipt Number	STR20_LBAU	String	22	20
39	ENDMORECEIPTNUMBER	End MO Receipt Number	STR20_LBAU	String	22	20
40	RSRCID	Resource ID	STR30	String	32	30
41	CB_I	CB	CB	Boolean	2	0
42	VIEWTYPE	View Type	INT	Integer	2	0
43	QTYTYPE	QTY Type	DDL_QTY_Type	Integer	2	0
44	CALCMTHD	Calculation Method	Calculation_Method	Integer	2	0
45	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Manufacturing (346)3rd PartyManufacture Order Reporting Options (WOUF0132)

Leave a Reply Cancel reply