ECM_Report_Options (ECUF0132)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: ECM_Report_Options
Physical Name: ECUF0132
Technical Name: ECM_Report_Options

Group Display Name: Manufacturing ECM
Group Technical Name: Manufacturing ECM

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
6RPTGRIND SearchReport Group IndexINTInteger20
7LEVEL_I SearchLevel0LINT_10Long Integer410
8STARTITEMNUM_I SearchstartitemnumSTR30_Item_NumberString3230
9ENDITEMNUM_I SearchenditemnumSTR30_Item_NumberString3230
10STARTEFFDATE_I SearchstarteffdateDTDate48
11ENDEFFDATE_I SearchendeffdateDTDate48
12SYSDATEPLUS_I SearchsysdateplusINT5Integer24
13SYSDATEMINUS_I SearchsysdateminusINT5Integer24
14STARTECNUMBER SearchstartecnumberSTR15String1615
15ENDECNUMBER SearchendecnumberSTR15String1615
16STARTBUYERID SearchStart Buyer IDSTR15_User_IDString1615
17ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString1615
18STARTPLANNERCODE_I SearchStart Planner CodeSTR3_UCString43
19ENDPLANNERCODE_I SearchEnd Planner CodeSTR3_UCString43
20STARTDISPCOD SearchStart Disposition CodeSTR10String1210
21ENDDISPCODE SearchEnd Disposition CodeSTR10String1210
22startecostatus SearchstartecostatusDDL_ECO_StatusInteger20
23endecostatus SearchendecostatusDDL_ECO_StatusInteger20
24INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
25PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
26PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
27PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
28IFFILXST SearchIf File ExistingGBInteger20
29FILEXPNM SearchFile Export NameSTR255String256255
30EXPTTYPE SearchExport TypeINTInteger20
31RSRCID SearchResource IDSTR30String3230
32DEX_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.

Leave a Reply

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