QA_HIST_Report_Options (QAUF0132)

azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Report_Options (QAUF0132)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: QA_HIST_Report_Options
Physical Name: QAUF0132
Technical Name: QA_HIST_Report_Options

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTOPTION_I SearchReport OptionSTR20String2220
2REPORTINDEX_I SearchReport IndexDLR14Currency1014
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4SORTBY_I SearchsortbySTR_30String3230
5TEXTREPTS_I SearchtextreptsCBBoolean20
6LEVEL_I SearchLevel0LINT_10Long Integer410
7INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
8PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
9PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
10PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
11IFFILXST SearchIf File ExistingGBInteger20
12FILEXPNM SearchFile Export NameSTR255String256255
13EXPTTYPE SearchExport TypeINTInteger20
14STRTDATE SearchStart DateDTDate48
15ENDDATE SearchEnd DateDTDate48
16STARTDATEINSPECT SearchStart Date InspectedDATEDate46
17ENDDATEINSPECT SearchEnd Date InspectedDATEDate46
18STARTDEFCOD SearchStart Defect CodeSTR10String1210
19ENDDEFCODE SearchEnd Defect CodeSTR10String1210
20STARTDISPCOD SearchStart Disposition CodeSTR10String1210
21ENDDISPCODE SearchEnd Disposition CodeSTR10String1210
22STARTINSPECT SearchStart Inspector IDSTR10String1210
23ENDINSPECT SearchEnd Inspector IDSTR10String1210
24STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
25ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
26STARTPONUMBER_I SearchStart Purchase Order NumberPurchase Order NumberString2220
27ENDPURORDNUM_I SearchEnd Purchase Order NumberPurchase Order NumberString2220
28STRECNUMBER_I SearchStart Receiving NumberSTR20_Document_NumberString2220
29ENDRECEIVINGNUMBER_I SearchEnd Receiving NumberSTR20_Document_NumberString2220
30STVNDRID SearchStart Vendor IDSTR15_LBUString1615
31ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
32Destroyed_in_Testing SearchDestroyed in TestingDestroyed in TestingBoolean20
33FLAGDESTRYTEST SearchFlag Destroyed in TestingBoolean_FlagBoolean20
34Passed_Inspection SearchPassed InspectionCB_Passed_FailedBoolean20
35FLAGPASSEDINSP SearchFlag Passed InspectionBoolean_FlagBoolean20
36QACOMPLETED SearchQA CompletedCBBoolean20
37FLAGQACOMPLETE SearchFlag QA CompletedBoolean_FlagBoolean20
38AQL_Table_Name SearchAQL Table NameSTR20String2220
39STTDOCDT SearchStart Document DateDTDate48
40ENDDOCDT SearchEnd Document DateDTDate48
41STRTORGNTOR SearchStart OriginatorSTR30String3230
42ENDORGNTOR SearchEnd OriginatorSTR30String3230
43STARTEFFECTIVEDATE_I SearchStart Effective DateDT_IDate48
44ENDEFFECTIVEDATE_I SearchEnd Effective DateDT_IDate48
45STTDUEDT SearchStart Due DateDTDate48
46ENDDUEDT SearchEnd Due DateDTDate48
47STTPSTDT SearchStart Post DateDATEDate46
48ENDPSTDT SearchEnd Post DateDATEDate46
49STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
50ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
51STARTNSRNUMI SearchStart NSR NumberSTR20_Document_NumberString2220
52ENDNSRNUMI SearchEnd NSR NumberSTR20_Document_NumberString2220
53STARTSCARNUMI SearchStart SCAR NumberSTR20_Document_NumberString2220
54ENDSCARNUMI SearchEnd SCAR NumberSTR20_Document_NumberString2220
55DEX_ROW_ID Searchintint1010

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.

azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Report_Options (QAUF0132)

Leave a Reply

Your email address will not be published. Required fields are marked *