Inventory Report Options (IV70500)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Report Options
Physical Name: IV70500
Technical Name: IV_Options_ROPT

Group Display Name: Inventory Report Options
Group Technical Name: Inventory Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PRTBYSIT SearchPrint by SiteGBInteger20
2PRNTOPTN SearchPrint OptionGBInteger20
3STTGNDSC SearchStart Generic DescriptionSTR10String1210
4ENGENDSC SearchEnd Generic DescriptionSTR10String1210
5ENUSRCAT SearchEnd User CategorySTR10String1210
6ENUSRCAT_1 SearchEnd User Category[1]STR10String1210
7ENUSRCAT_2 SearchEnd User Category[2]STR10String1210
8ENUSRCAT_3 SearchEnd User Category[3]STR10String1210
9ENUSRCAT_4 SearchEnd User Category[4]STR10String1210
10ENUSRCAT_5 SearchEnd User Category[5]STR10String1210
11ENUSRCAT_6 SearchEnd User Category[6]STR10String1210
12KITSRTBY SearchKit Sort ByGBInteger20
13STRTUCAT SearchStart User CategorySTR10String1210
14STRTUCAT_1 SearchStart User Category[1]STR10String1210
15STRTUCAT_2 SearchStart User Category[2]STR10String1210
16STRTUCAT_3 SearchStart User Category[3]STR10String1210
17STRTUCAT_4 SearchStart User Category[4]STR10String1210
18STRTUCAT_5 SearchStart User Category[5]STR10String1210
19STRTUCAT_6 SearchStart User Category[6]STR10String1210
20STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
21ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
22PRVDRINF SearchPrint Vendor InformationGBInteger20
23PRTDSCNT SearchPrint DiscontinuedCB_DiscontinuedBoolean20
24FINRPTNM SearchFinancial Report NameSTR30String3230
25PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
26PRNTTYPE SearchPrint TypeGBInteger20
27ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
28INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
29PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
30PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
31PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
32IFFILXST SearchIf File ExistingGBInteger20
33FILEXPNM SearchFile Export NameSTR255String256255
34EXPTTYPE SearchExport TypeINTInteger20
35RPTGRIND SearchReport Group IndexINTInteger20
36STTCLASS SearchStart ClassSTR10_Item_Class_CodeString1210
37ENDCLASS SearchEnd ClassSTR10_Item_Class_CodeString1210
38STTSCHED SearchStart ScheduleSTR10_ScheduleString1210
39ENSCHDUL SearchEnd ScheduleSTR10_ScheduleString1210
40STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
41ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
42STTLOTTY SearchStart Lot TypeSTR10_Lot_TypeString1210
43ENLOTTYP SearchEnd Lot TypeSTR10_Lot_TypeString1210
44STRTNGDT SearchStarting DateDTDate48
45ENDINGDT SearchEnding DateDTDate48
46ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger20
47STTOKNDT SearchStart Token DateDDL_Start_DatesInteger20
48STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString2220
49ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString2220
50RTPACHIN SearchReport Palette Choice IndexINTInteger20
51RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
52SORTBY SearchSort ByDDL_Sort_ByInteger20
53PRTSRLOT SearchPrint Serial LotCB_Print_Serial_LotBoolean20
54INZROQTY SearchInclude Zero QTYCB_Include_Zero_QTYBoolean20
55PRTITQTY SearchPrint Item QuantitiesCB_Print_Item_QTYSBoolean20
56STTBINUM SearchStart Bin NumberSTR20String2220
57ENBINNBR SearchEnd Bin NumberSTR20String2220
58STDOCNUM SearchStart Document NumberSTR20String2220
59ENDOCNUM SearchEnd Document NumberSTR20String2220
60STDOCTYP SearchStart Document TypeINT1Integer21
61ENDOCTYP SearchEnd Document TypeINT1Integer21
62STTMODUL SearchStart ModuleSTR3String43
63ENDMODUL SearchEnd ModuleSTR3String43
64STRXSRC SearchStart TRX SourceSTR13String1413
65ENTRXSRC SearchEnd TRX SourceSTR13String1413
66STBCHSRC SearchStart Batch SourceSTR15String1615
67ENBCHSRC SearchEnd Batch SourceSTR15String1615
68STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
69ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
70STVNDRID SearchStart Vendor IDSTR15_LBUString1615
71ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
72INQTYREQ SearchInclude QTY RequisitionedCB_QTY_RequisitionedBoolean20
73INZRORLV SearchInclude Zero Reorder LevelCB_Zero_ReorderBoolean20
74CALSGQTY SearchCalc Suggested QTYSGBInteger20
75RCPTOPTS SearchReceipt OptionsDDL_Print_OptionInteger20
76VENDROPT SearchVendor OptionsDDL_Vendor_OptionInteger20
77SEGSRTBY SearchSegment Sort ByINT1Integer21
78STTACNUM SearchStart Account NumberAccount_NumberComposite 8080
79STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
80STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
81STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
82STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
83STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
84STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
85STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
86STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
87STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
88STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
89EACCNBR SearchEnd Account NumberAccount_NumberComposite 8080
90EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
91EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
92EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
93EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
94EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
95EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
96EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
97EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
98EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
99EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
100SEGMNTRG SearchUsing Segment RangeINTInteger20
101Start_PriceLevel SearchStart PriceLevelSTR10_PriceLevelString1210
102End_PriceLevel SearchEnd PriceLevelSTR10_PriceLevelString1210
103Start_QTY_Type SearchStart QTY TypeDDL_QTY_TypeInteger20
104End_QTY_Type SearchEnd QTY TypeDDL_QTY_TypeInteger20
105Start_Component_Item_Num SearchStart Component Item NumberSTR30_Item_NumberString3230
106End_Component_Item_Numbe SearchEnd Component Item NumberSTR30_Item_NumberString3230
107BM_Assembly_Journal SearchBM Assembly JournalCB_BM_Assembly_JournalBoolean20
108BM_Distribution_Detail SearchBM Distribution DetailCB_BM_Distribution_DetailBoolean20
109BM_Bill_Status_Active SearchBM Bill Status ActiveBM Bill Status ActiveBoolean20
110BM_Bill_Status_Pending SearchBM Bill Status PendingBM Bill Status PendingBoolean20
111BM_Bill_Status_Obsolete SearchBM Bill Status ObsoleteBM Bill Status ObsoleteBoolean20
112BM_Comp_Status_Active SearchBM Comp Status ActiveBM Comp Status ActiveBoolean20
113BM_Comp_Status_Pending SearchBM Comp Status PendingBM Comp Status PendingBoolean20
114BM_Comp_Status_Obsolete SearchBM Comp Status ObsoleteBM Comp Status ObsoleteBoolean20
115BM_Comp_Type_Misc_Charge SearchBM Comp Type Misc ChargesBM Comp Type Misc ChargesBoolean20
116BM_Comp_Type_Services SearchBM Comp Type ServicesBM Comp Type ServicesBoolean20
117BM_Comp_Type_Flat_Fee SearchBM Comp Type Flat FeeBM Comp Type Flat FeeBoolean20
118BM_Print_Notes_Bill SearchBM Print Notes BillBM Print Notes BillBoolean20
119BM_Print_Notes_Comp SearchBM Print Notes CompBM Print Notes CompBoolean20
120BM_Print_Cost_Options SearchBM Print Cost OptionsGBInteger20
121Max_Levels SearchMax LevelsDDL_Max_LevelsInteger20
122DATE1 SearchDateDT6Date46
123BMTRXSTATNOTREL SearchBM Trx Status Not ReleasedCB_BM_Trx_Status_Not_ReleasedBoolean20
124BMTRXSTATREL SearchBM Trx Status ReleasedCB_BM_Trx_Status_ReleasedBoolean20
125OPTIONS SearchOptionsDDLInteger20
126Start_TRX_ID SearchStart TRX IDSTR17_TRX_IDString2017
127End_TRX_ID SearchEnd TRX IDSTR17_TRX_IDString2017
128Starting_TRX_Date SearchStarting TRX DateDT_DateDate46
129Ending_TRX_Date SearchEnding TRX DateDT_DateDate46
130STRTSRLT SearchStart Serial/Lot NumberSTR20String2220
131ENDSERLT SearchEnd Serial/Lot NumberSTR20String2220
132StartPriceGroup SearchStart Price GroupSTR10_LBAUString1210
133EndPriceGroup SearchEnd Price GroupSTR10_LBAUString1210
134STCURRID SearchStart Currency IDSTR15_Currency_IDString1615
135ENDCURID SearchEnd Currency IDSTR15_Currency_IDString1615
136STRTABCCD SearchStart ABC CodeDDL_ABC_CodeInteger20
137ENDABCCD SearchEnd ABC CodeDDL_ABC_CodeInteger20
138STRTSTCKCNTID SearchStart Stock Count IDSTR15_LBAUString1615
139ENDSTCKCNTID SearchEnd Stock Count IDSTR15_LBAUString1615
140Start_Landed_Cost_ID SearchStart Landed Cost IDSTR15_LBAUString1615
141End_Landed_Cost_ID SearchEnd Landed Cost IDSTR15_LBAUString1615
142Start_LandedCostGroupID SearchStart Landed Cost Group IDSTR15_LBAUString1615
143End_LandedCostGroupID SearchEnd Landed Cost Group IDSTR15_LBAUString1615
144ASOFDATE SearchAs Of DateDATEDate46
145INZRQTYI SearchInclude Zero Qty ItemsCB_IncludeZeroQtyItemsBoolean20
146STARTBIN SearchStart BinSTR15_BinString1615
147ENDBIN SearchEnd BinSTR15_BinString1615
148LNGSTRTDESC SearchLong Start DescriptionSTR100String102100
149LNGENDDESC SearchLong End DescriptionSTR100String102100
150USEGLPOSTINGDATE SearchUse GL Posting DateCB_Use_GL_Posting_DateBoolean20
151INNGVQTY SearchInclude Negative QTYCB_Include_Negative_QTYBoolean20
152COSTAVGPERIODIC SearchCost For Periodic Average ItemsDDL_CostItemsInteger20
153PRTINACT SearchPrint InactiveCB_Inactive_ItemsBoolean20
154DEX_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 *