Report_Options (QADUF132)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Report_Options
Physical Name: QADUF132
Technical Name: QA_Report_Options

Group Display Name: Manufacturing QA
Group Technical Name: Manufacturing QA

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	REPORTOPTION_I	Report Option	STR20	String	22	20
2	REPORTINDEX_I	Report Index	DLR14	Currency	10	14
3	ASKECHTM	Ask Each Time	CB_Ask_Each_Time	Boolean	2	0
4	SORTBY_I	sortby	STR_30	String	32	30
5	TEXTREPTS_I	textrepts	CB	Boolean	2	0
6	LEVEL_I	Level0	LINT_10	Long Integer	4	10
7	INCLGNDS	Include Legends	CB_Include_Legends	Boolean	2	0
8	PRNTOFIL	Print to File	CB_Print_to_File	Boolean	2	0
9	PRTOPRTR	Print to Printer	CB_Print_to_Printer	Boolean	2	0
10	PRTOSCRN	Print to Screen	CB_Print_to_Screen	Boolean	2	0
11	IFFILXST	If File Existing	GB	Integer	2	0
12	FILEXPNM	File Export Name	STR255	String	256	255
13	EXPTTYPE	Export Type	INT	Integer	2	0
14	STRTDATE	Start Date	DT	Date	4	8
15	ENDDATE	End Date	DT	Date	4	8
16	STARTDATEINSPECT	Start Date Inspected	DATE	Date	4	6
17	ENDDATEINSPECT	End Date Inspected	DATE	Date	4	6
18	STARTDEFCOD	Start Defect Code	STR10	String	12	10
19	ENDDEFCODE	End Defect Code	STR10	String	12	10
20	STARTDISPCOD	Start Disposition Code	STR10	String	12	10
21	ENDDISPCODE	End Disposition Code	STR10	String	12	10
22	STARTINSPECT	Start Inspector ID	STR10	String	12	10
23	ENDINSPECT	End Inspector ID	STR10	String	12	10
24	STTITNUM	Start Item Number	STR30_Item_Number	String	32	30
25	ENITMNBR	End Item Number	STR30_Item_Number	String	32	30
26	STRPONUM	Start PO Number	STR17_POP_Number	String	18	17
27	ENDPONUM	End PO Number	STR17_POP_Number	String	18	17
28	StartPOPRcptNum	Start POP Receipt Number	STR17_POP_Number	String	18	17
29	EndPOPRcptNum	End POP Receipt Number	STR17_POP_Number	String	18	17
30	STVNDRID	Start Vendor ID	STR15_LBU	String	16	15
31	ENDVNDID	End Vendor ID	STR15_LBU	String	16	15
32	Destroyed_in_Testing	Destroyed in Testing	Destroyed in Testing	Boolean	2	0
33	FLAGDESTRYTEST	Flag Destroyed in Testing	Boolean_Flag	Boolean	2	0
34	Passed_Inspection	Passed Inspection	CB_Passed_Failed	Boolean	2	0
35	FLAGPASSEDINSP	Flag Passed Inspection	Boolean_Flag	Boolean	2	0
36	QACOMPLETED	QA Completed	CB	Boolean	2	0
37	FLAGQACOMPLETE	Flag QA Completed	Boolean_Flag	Boolean	2	0
38	AQL_Table_Name	AQL Table Name	STR20	String	22	20
39	STTDOCDT	Start Document Date	DT	Date	4	8
40	ENDDOCDT	End Document Date	DT	Date	4	8
41	STRTORGNTOR	Start Originator	STR30	String	32	30
42	ENDORGNTOR	End Originator	STR30	String	32	30
43	STARTEFFECTIVEDATE_I	Start Effective Date	DT_I	Date	4	8
44	ENDEFFECTIVEDATE_I	End Effective Date	DT_I	Date	4	8
45	STTDUEDT	Start Due Date	DT	Date	4	8
46	ENDDUEDT	End Due Date	DT	Date	4	8
47	STTPSTDT	Start Post Date	DATE	Date	4	6
48	ENDPSTDT	End Post Date	DATE	Date	4	6
49	STTLOCCD	Start Location Code	STR10_Location_Code	String	12	10
50	ENLOCNCD	End Location Code	STR10_Location_Code	String	12	10
51	STARTNSRNUMI	Start NSR Number	STR20_Document_Number	String	22	20
52	ENDNSRNUMI	End NSR Number	STR20_Document_Number	String	22	20
53	STARTSCARNUMI	Start SCAR Number	STR20_Document_Number	String	22	20
54	ENDSCARNUMI	End SCAR Number	STR20_Document_Number	String	22	20
55	RSRCID	Resource ID	STR30	String	32	30
56	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 PartyReport_Options (QADUF132)

Leave a Reply Cancel reply