CRP Report Options (CPUF0131)

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

Display Name: CRP Report Options
Physical Name: CPUF0131
Technical Name: CRP_Report_Options

Group Display Name: Manufacturing CRP
Group Technical Name: Manufacturing CRP

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	REPORTOPTION_I	Report Option	STR20	String	20
2	REPORTINDEX_I	Report Index	DLR14	Currency	14
3	ASKECHTM	Ask Each Time	CB_Ask_Each_Time	Boolean	0
4	PRNTOFIL	Print to File	CB_Print_to_File	Boolean	0
5	PRTOPRTR	Print to Printer	CB_Print_to_Printer	Boolean	0
6	PRTOSCRN	Print to Screen	CB_Print_to_Screen	Boolean	0
7	IFFILXST	If File Existing	GB	Integer	0
8	FILEXPNM	File Export Name	STR255	String	255
9	EXPTTYPE	Export Type	INT	Integer	0
10	RNGE	Range	STR132	String	132
11	SORTOPTION_I	Sort Option	INT	Integer	0
12	SORTBY_I	sortby	STR_30	String	30
13	SORTBYNUMBER_I	Sort By Number	INT2	Integer	2
14	FROMWCID_I	from WC ID	STR10_Location_Code	String	10
15	TOWCID_I	to WC ID	STR10_Location_Code	String	10
16	FROMDATE_I	from Date	DT	Date	8
17	TODATE_I	to Date	DT	Date	8
18	DAYSFORWARD_I	Days Forward	INT	Integer	0
19	SHOWFIRMEDEMPLOYEE_I	Show Firmed Employee	CB	Boolean	0
20	SHOWFIRMEDMACHINE_I	Show Firmed Machine	CB	Boolean	0
21	SHOWPLANEMP_I	Show Planned Employee	CB	Boolean	0
22	SHOWPLANNEDMACHINE_I	Show Planned Machine	CB	Boolean	0
23	MFGBUCKET	MFG_Bucket	STR15	String	15
24	RSRCID	Resource ID	STR30	String	30
25	DEX_ROW_ID		int	int	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.