IV_Report_Options (IVUF0130)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: IV_Report_Options
Physical Name: IVUF0130
Technical Name: IV_Report_Options

Group Display Name: Manufacturing Inventory
Group Technical Name: Manufacturing Inventory

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTINDEX_I SearchReport IndexDLR14Currency1014
2REPORTOPTION_I SearchReport OptionSTR20String2220
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
8IFFILXST SearchIf File ExistingGBInteger20
9FILEXPNM SearchFile Export NameSTR255String256255
10EXPTTYPE SearchExport TypeINTInteger20
11STARTITEMNUM_I SearchstartitemnumSTR30_Item_NumberString3230
12STARTCLASSCODE_I SearchstartclasscodeSTR10_Item_Class_CodeString1210
13STARTITEMDESC_I SearchstartitemdescSTR50String5250
14STARTMAKEBUY_I SearchstartmakebuyDDL_Make_Buy_CodeInteger20
15STARTVENDORID_I SearchstartvendoridSTR_15_Vendor_IDString1615
16ENDITEMNUM_I SearchenditemnumSTR30_Item_NumberString3230
17ENDCLASSCODE_I SearchendclasscodeSTR10_Item_Class_CodeString1210
18ENDITEMDESC_I SearchenditemdescSTR50String5250
19ENDMAKEBUY_I SearchendmakebuyDDL_Make_Buy_CodeInteger20
20ENDVENDORID_I SearchendvendoridSTR_15_Vendor_IDString1615
21SORTBY_I SearchsortbySTR_30String3230
22STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
23ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
24STARTABCCODE_I SearchStartABC_CodeDDL_ABC_CodeInteger20
25ENDABCCODE_I SearchEndABC_CodeDDL_ABC_CodeInteger20
26STTUSRID SearchStart User IDSTR15_User_IDString1615
27ENDUSRID SearchEnd User IDSTR15_User_IDString1615
28STRTDATE SearchStart DateDTDate48
29ENDDATE SearchEnd DateDTDate48
30INZROQTY SearchInclude Zero QTYCB_Include_Zero_QTYBoolean20
31PRTSRLOT SearchPrint Serial LotCB_Print_Serial_LotBoolean20
32PRTITQTY SearchPrint Item QuantitiesCB_Print_Item_QTYSBoolean20
33Suppress_Zero_Net_Change SearchSuppress Zero Net Change ItemsCBBoolean20
34RSRCID SearchResource IDSTR30String3230
35DEX_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 *