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 TypeLength
1PRTBYSIT SearchPrint by SiteGBInteger0
2PRNTOPTN SearchPrint OptionGBInteger0
3STTGNDSC SearchStart Generic DescriptionSTR10String10
4ENGENDSC SearchEnd Generic DescriptionSTR10String10
5ENUSRCAT SearchEnd User CategorySTR10String10
6ENUSRCAT_1 SearchEnd User Category[1]STR10String10
7ENUSRCAT_2 SearchEnd User Category[2]STR10String10
8ENUSRCAT_3 SearchEnd User Category[3]STR10String10
9ENUSRCAT_4 SearchEnd User Category[4]STR10String10
10ENUSRCAT_5 SearchEnd User Category[5]STR10String10
11ENUSRCAT_6 SearchEnd User Category[6]STR10String10
12KITSRTBY SearchKit Sort ByGBInteger0
13STRTUCAT SearchStart User CategorySTR10String10
14STRTUCAT_1 SearchStart User Category[1]STR10String10
15STRTUCAT_2 SearchStart User Category[2]STR10String10
16STRTUCAT_3 SearchStart User Category[3]STR10String10
17STRTUCAT_4 SearchStart User Category[4]STR10String10
18STRTUCAT_5 SearchStart User Category[5]STR10String10
19STRTUCAT_6 SearchStart User Category[6]STR10String10
20STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
21ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
22PRVDRINF SearchPrint Vendor InformationGBInteger0
23PRTDSCNT SearchPrint DiscontinuedCB_DiscontinuedBoolean0
24FINRPTNM SearchFinancial Report NameSTR30String30
25PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
26PRNTTYPE SearchPrint TypeGBInteger0
27ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
28INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
29PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
30PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
31PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
32IFFILXST SearchIf File ExistingGBInteger0
33FILEXPNM SearchFile Export NameSTR255String255
34EXPTTYPE SearchExport TypeINTInteger0
35RPTGRIND SearchReport Group IndexINTInteger0
36STTCLASS SearchStart ClassSTR10_Item_Class_CodeString10
37ENDCLASS SearchEnd ClassSTR10_Item_Class_CodeString10
38STTSCHED SearchStart ScheduleSTR10_ScheduleString10
39ENSCHDUL SearchEnd ScheduleSTR10_ScheduleString10
40STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
41ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
42STTLOTTY SearchStart Lot TypeSTR10_Lot_TypeString10
43ENLOTTYP SearchEnd Lot TypeSTR10_Lot_TypeString10
44STRTNGDT SearchStarting DateDTDate8
45ENDINGDT SearchEnding DateDTDate8
46ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger0
47STTOKNDT SearchStart Token DateDDL_Start_DatesInteger0
48STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString20
49ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString20
50RTPACHIN SearchReport Palette Choice IndexINTInteger0
51RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
52SORTBY SearchSort ByDDL_Sort_ByInteger0
53PRTSRLOT SearchPrint Serial LotCB_Print_Serial_LotBoolean0
54INZROQTY SearchInclude Zero QTYCB_Include_Zero_QTYBoolean0
55PRTITQTY SearchPrint Item QuantitiesCB_Print_Item_QTYSBoolean0
56STTBINUM SearchStart Bin NumberSTR20String20
57ENBINNBR SearchEnd Bin NumberSTR20String20
58STDOCNUM SearchStart Document NumberSTR20String20
59ENDOCNUM SearchEnd Document NumberSTR20String20
60STDOCTYP SearchStart Document TypeINT1Integer1
61ENDOCTYP SearchEnd Document TypeINT1Integer1
62STTMODUL SearchStart ModuleSTR3String3
63ENDMODUL SearchEnd ModuleSTR3String3
64STRXSRC SearchStart TRX SourceSTR13String13
65ENTRXSRC SearchEnd TRX SourceSTR13String13
66STBCHSRC SearchStart Batch SourceSTR15String15
67ENBCHSRC SearchEnd Batch SourceSTR15String15
68STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
69ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
70STVNDRID SearchStart Vendor IDSTR15_LBUString15
71ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
72INQTYREQ SearchInclude QTY RequisitionedCB_QTY_RequisitionedBoolean0
73INZRORLV SearchInclude Zero Reorder LevelCB_Zero_ReorderBoolean0
74CALSGQTY SearchCalc Suggested QTYSGBInteger0
75RCPTOPTS SearchReceipt OptionsDDL_Print_OptionInteger0
76VENDROPT SearchVendor OptionsDDL_Vendor_OptionInteger0
77SEGSRTBY SearchSegment Sort ByINT1Integer1
78STTACNUM SearchStart Account NumberAccount_NumberComposite 80
79STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
80STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
81STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
82STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
83STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
84STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
85STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
86STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
87STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
88STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
89EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
90EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
91EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
92EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
93EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
94EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
95EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
96EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
97EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
98EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
99EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
100SEGMNTRG SearchUsing Segment RangeINTInteger0
101Start_PriceLevel SearchStart PriceLevelSTR10_PriceLevelString10
102End_PriceLevel SearchEnd PriceLevelSTR10_PriceLevelString10
103Start_QTY_Type SearchStart QTY TypeDDL_QTY_TypeInteger0
104End_QTY_Type SearchEnd QTY TypeDDL_QTY_TypeInteger0
105Start_Component_Item_Num SearchStart Component Item NumberSTR30_Item_NumberString30
106End_Component_Item_Numbe SearchEnd Component Item NumberSTR30_Item_NumberString30
107BM_Assembly_Journal SearchBM Assembly JournalCB_BM_Assembly_JournalBoolean0
108BM_Distribution_Detail SearchBM Distribution DetailCB_BM_Distribution_DetailBoolean0
109BM_Bill_Status_Active SearchBM Bill Status ActiveBM Bill Status ActiveBoolean0
110BM_Bill_Status_Pending SearchBM Bill Status PendingBM Bill Status PendingBoolean0
111BM_Bill_Status_Obsolete SearchBM Bill Status ObsoleteBM Bill Status ObsoleteBoolean0
112BM_Comp_Status_Active SearchBM Comp Status ActiveBM Comp Status ActiveBoolean0
113BM_Comp_Status_Pending SearchBM Comp Status PendingBM Comp Status PendingBoolean0
114BM_Comp_Status_Obsolete SearchBM Comp Status ObsoleteBM Comp Status ObsoleteBoolean0
115BM_Comp_Type_Misc_Charge SearchBM Comp Type Misc ChargesBM Comp Type Misc ChargesBoolean0
116BM_Comp_Type_Services SearchBM Comp Type ServicesBM Comp Type ServicesBoolean0
117BM_Comp_Type_Flat_Fee SearchBM Comp Type Flat FeeBM Comp Type Flat FeeBoolean0
118BM_Print_Notes_Bill SearchBM Print Notes BillBM Print Notes BillBoolean0
119BM_Print_Notes_Comp SearchBM Print Notes CompBM Print Notes CompBoolean0
120BM_Print_Cost_Options SearchBM Print Cost OptionsGBInteger0
121Max_Levels SearchMax LevelsDDL_Max_LevelsInteger0
122DATE1 SearchDateDT6Date6
123BMTRXSTATNOTREL SearchBM Trx Status Not ReleasedCB_BM_Trx_Status_Not_ReleasedBoolean0
124BMTRXSTATREL SearchBM Trx Status ReleasedCB_BM_Trx_Status_ReleasedBoolean0
125OPTIONS SearchOptionsDDLInteger0
126Start_TRX_ID SearchStart TRX IDSTR17_TRX_IDString17
127End_TRX_ID SearchEnd TRX IDSTR17_TRX_IDString17
128Starting_TRX_Date SearchStarting TRX DateDT_DateDate6
129Ending_TRX_Date SearchEnding TRX DateDT_DateDate6
130STRTSRLT SearchStart Serial/Lot NumberSTR20String20
131ENDSERLT SearchEnd Serial/Lot NumberSTR20String20
132StartPriceGroup SearchStart Price GroupSTR10_LBAUString10
133EndPriceGroup SearchEnd Price GroupSTR10_LBAUString10
134STCURRID SearchStart Currency IDSTR15_Currency_IDString15
135ENDCURID SearchEnd Currency IDSTR15_Currency_IDString15
136STRTABCCD SearchStart ABC CodeDDL_ABC_CodeInteger0
137ENDABCCD SearchEnd ABC CodeDDL_ABC_CodeInteger0
138STRTSTCKCNTID SearchStart Stock Count IDSTR15_LBAUString15
139ENDSTCKCNTID SearchEnd Stock Count IDSTR15_LBAUString15
140Start_Landed_Cost_ID SearchStart Landed Cost IDSTR15_LBAUString15
141End_Landed_Cost_ID SearchEnd Landed Cost IDSTR15_LBAUString15
142Start_LandedCostGroupID SearchStart Landed Cost Group IDSTR15_LBAUString15
143End_LandedCostGroupID SearchEnd Landed Cost Group IDSTR15_LBAUString15
144ASOFDATE SearchAs Of DateDATEDate6
145INZRQTYI SearchInclude Zero Qty ItemsCB_IncludeZeroQtyItemsBoolean0
146STARTBIN SearchStart BinSTR15_BinString15
147ENDBIN SearchEnd BinSTR15_BinString15
148LNGSTRTDESC SearchLong Start DescriptionSTR100String100
149LNGENDDESC SearchLong End DescriptionSTR100String100
150USEGLPOSTINGDATE SearchUse GL Posting DateCB_Use_GL_Posting_DateBoolean0
151INNGVQTY SearchInclude Negative QTYCB_Include_Negative_QTYBoolean0
152COSTAVGPERIODIC SearchCost For Periodic Average ItemsDDL_CostItemsInteger0
153PRTINACT SearchPrint InactiveCB_Inactive_ItemsBoolean0
154DEX_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.

Leave a Reply

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