Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/QADUF132
Product: Manufacturing (346)
Series: 3rd Party
Display Name: Report_Options Group Display Name: Manufacturing QA
Physical Name: QADUF132
Technical Name: QA_Report_Options
Group Technical Name: Manufacturing QA
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 | SORTBY_I ![]() | sortby | STR_30 | String | 30 | |
5 | TEXTREPTS_I ![]() | textrepts | CB | Boolean | 0 | |
6 | LEVEL_I ![]() | Level0 | LINT_10 | Long Integer | 10 | |
7 | INCLGNDS ![]() | Include Legends | CB_Include_Legends | Boolean | 0 | |
8 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
9 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
10 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
11 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
12 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
13 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
14 | STRTDATE ![]() | Start Date | DT | Date | 8 | |
15 | ENDDATE ![]() | End Date | DT | Date | 8 | |
16 | STARTDATEINSPECT ![]() | Start Date Inspected | DATE | Date | 6 | |
17 | ENDDATEINSPECT ![]() | End Date Inspected | DATE | Date | 6 | |
18 | STARTDEFCOD ![]() | Start Defect Code | STR10 | String | 10 | |
19 | ENDDEFCODE ![]() | End Defect Code | STR10 | String | 10 | |
20 | STARTDISPCOD ![]() | Start Disposition Code | STR10 | String | 10 | |
21 | ENDDISPCODE ![]() | End Disposition Code | STR10 | String | 10 | |
22 | STARTINSPECT ![]() | Start Inspector ID | STR10 | String | 10 | |
23 | ENDINSPECT ![]() | End Inspector ID | STR10 | String | 10 | |
24 | STTITNUM ![]() | Start Item Number | STR30_Item_Number | String | 30 | |
25 | ENITMNBR ![]() | End Item Number | STR30_Item_Number | String | 30 | |
26 | STRPONUM ![]() | Start PO Number | STR17_POP_Number | String | 17 | |
27 | ENDPONUM ![]() | End PO Number | STR17_POP_Number | String | 17 | |
28 | StartPOPRcptNum ![]() | Start POP Receipt Number | STR17_POP_Number | String | 17 | |
29 | EndPOPRcptNum ![]() | End POP Receipt Number | STR17_POP_Number | String | 17 | |
30 | STVNDRID ![]() | Start Vendor ID | STR15_LBU | String | 15 | |
31 | ENDVNDID ![]() | End Vendor ID | STR15_LBU | String | 15 | |
32 | Destroyed_in_Testing ![]() | Destroyed in Testing | Destroyed in Testing | Boolean | 0 | |
33 | FLAGDESTRYTEST ![]() | Flag Destroyed in Testing | Boolean_Flag | Boolean | 0 | |
34 | Passed_Inspection ![]() | Passed Inspection | CB_Passed_Failed | Boolean | 0 | |
35 | FLAGPASSEDINSP ![]() | Flag Passed Inspection | Boolean_Flag | Boolean | 0 | |
36 | QACOMPLETED ![]() | QA Completed | CB | Boolean | 0 | |
37 | FLAGQACOMPLETE ![]() | Flag QA Completed | Boolean_Flag | Boolean | 0 | |
38 | AQL_Table_Name ![]() | AQL Table Name | STR20 | String | 20 | |
39 | STTDOCDT ![]() | Start Document Date | DT | Date | 8 | |
40 | ENDDOCDT ![]() | End Document Date | DT | Date | 8 | |
41 | STRTORGNTOR ![]() | Start Originator | STR30 | String | 30 | |
42 | ENDORGNTOR ![]() | End Originator | STR30 | String | 30 | |
43 | STARTEFFECTIVEDATE_I ![]() | Start Effective Date | DT_I | Date | 8 | |
44 | ENDEFFECTIVEDATE_I ![]() | End Effective Date | DT_I | Date | 8 | |
45 | STTDUEDT ![]() | Start Due Date | DT | Date | 8 | |
46 | ENDDUEDT ![]() | End Due Date | DT | Date | 8 | |
47 | STTPSTDT ![]() | Start Post Date | DATE | Date | 6 | |
48 | ENDPSTDT ![]() | End Post Date | DATE | Date | 6 | |
49 | STTLOCCD ![]() | Start Location Code | STR10_Location_Code | String | 10 | |
50 | ENLOCNCD ![]() | End Location Code | STR10_Location_Code | String | 10 | |
51 | STARTNSRNUMI ![]() | Start NSR Number | STR20_Document_Number | String | 20 | |
52 | ENDNSRNUMI ![]() | End NSR Number | STR20_Document_Number | String | 20 | |
53 | STARTSCARNUMI ![]() | Start SCAR Number | STR20_Document_Number | String | 20 | |
54 | ENDSCARNUMI ![]() | End SCAR Number | STR20_Document_Number | String | 20 | |
55 | RSRCID ![]() | Resource ID | STR30 | String | 30 | |
56 | 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. |