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 TypeLength
1REPORTOPTION_I SearchReport OptionSTR20String20
2REPORTINDEX_I SearchReport IndexDLR14Currency14
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
4SORTBY_I SearchsortbySTR_30String30
5TEXTREPTS_I SearchtextreptsCBBoolean0
6LEVEL_I SearchLevel0LINT_10Long Integer10
7INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
8PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
9PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
10PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
11IFFILXST SearchIf File ExistingGBInteger0
12FILEXPNM SearchFile Export NameSTR255String255
13EXPTTYPE SearchExport TypeINTInteger0
14STRTDATE SearchStart DateDTDate8
15ENDDATE SearchEnd DateDTDate8
16STARTDATEINSPECT SearchStart Date InspectedDATEDate6
17ENDDATEINSPECT SearchEnd Date InspectedDATEDate6
18STARTDEFCOD SearchStart Defect CodeSTR10String10
19ENDDEFCODE SearchEnd Defect CodeSTR10String10
20STARTDISPCOD SearchStart Disposition CodeSTR10String10
21ENDDISPCODE SearchEnd Disposition CodeSTR10String10
22STARTINSPECT SearchStart Inspector IDSTR10String10
23ENDINSPECT SearchEnd Inspector IDSTR10String10
24STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
25ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
26STARTPONUMBER_I SearchStart Purchase Order NumberPurchase Order NumberString20
27ENDPURORDNUM_I SearchEnd Purchase Order NumberPurchase Order NumberString20
28STRECNUMBER_I SearchStart Receiving NumberSTR20_Document_NumberString20
29ENDRECEIVINGNUMBER_I SearchEnd Receiving NumberSTR20_Document_NumberString20
30STVNDRID SearchStart Vendor IDSTR15_LBUString15
31ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
32Destroyed_in_Testing SearchDestroyed in TestingDestroyed in TestingBoolean0
33FLAGDESTRYTEST SearchFlag Destroyed in TestingBoolean_FlagBoolean0
34Passed_Inspection SearchPassed InspectionCB_Passed_FailedBoolean0
35FLAGPASSEDINSP SearchFlag Passed InspectionBoolean_FlagBoolean0
36QACOMPLETED SearchQA CompletedCBBoolean0
37FLAGQACOMPLETE SearchFlag QA CompletedBoolean_FlagBoolean0
38AQL_Table_Name SearchAQL Table NameSTR20String20
39STTDOCDT SearchStart Document DateDTDate8
40ENDDOCDT SearchEnd Document DateDTDate8
41STRTORGNTOR SearchStart OriginatorSTR30String30
42ENDORGNTOR SearchEnd OriginatorSTR30String30
43STARTEFFECTIVEDATE_I SearchStart Effective DateDT_IDate8
44ENDEFFECTIVEDATE_I SearchEnd Effective DateDT_IDate8
45STTDUEDT SearchStart Due DateDTDate8
46ENDDUEDT SearchEnd Due DateDTDate8
47STTPSTDT SearchStart Post DateDATEDate6
48ENDPSTDT SearchEnd Post DateDATEDate6
49STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
50ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
51STARTNSRNUMI SearchStart NSR NumberSTR20_Document_NumberString20
52ENDNSRNUMI SearchEnd NSR NumberSTR20_Document_NumberString20
53STARTSCARNUMI SearchStart SCAR NumberSTR20_Document_NumberString20
54ENDSCARNUMI SearchEnd SCAR NumberSTR20_Document_NumberString20
55DEX_ROW_ID Searchintint10

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 *