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 SiteIntegerGB0
2PRNTOPTN SearchPrint OptionIntegerGB0
3STTGNDSC SearchStart Generic DescriptionStringSTR1010
4ENGENDSC SearchEnd Generic DescriptionStringSTR1010
5ENUSRCAT SearchEnd User CategorySTR10String10
6ENUSRCAT_1 SearchEnd User Category[1]StringSTR1010
7ENUSRCAT_2 SearchEnd User Category[2]StringSTR1010
8ENUSRCAT_3 SearchEnd User Category[3]StringSTR1010
9ENUSRCAT_4 SearchEnd User Category[4]StringSTR1010
10ENUSRCAT_5 SearchEnd User Category[5]StringSTR1010
11ENUSRCAT_6 SearchEnd User Category[6]StringSTR1010
12KITSRTBY SearchKit Sort ByIntegerGB0
13STRTUCAT_1 SearchStart User Category[1]StringSTR1010
14STRTUCAT_2 SearchStart User Category[2]StringSTR1010
15STRTUCAT SearchStart User CategorySTR10String10
16STRTUCAT_3 SearchStart User Category[3]StringSTR1010
17STRTUCAT_4 SearchStart User Category[4]StringSTR1010
18STRTUCAT_5 SearchStart User Category[5]StringSTR1010
19STRTUCAT_6 SearchStart User Category[6]StringSTR1010
20STTITNUM SearchStart Item NumberStringSTR30_Item_Number30
21ENITMNBR SearchEnd Item NumberStringSTR30_Item_Number30
22PRVDRINF SearchPrint Vendor InformationIntegerGB0
23PRTDSCNT SearchPrint DiscontinuedBooleanCB_Discontinued0
24FINRPTNM SearchFinancial Report NameStringSTR3030
25PRNTNOTS SearchPrint NotesBooleanCB_Print_Notes0
26PRNTTYPE SearchPrint TypeIntegerGB0
27ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
28INCLGNDS SearchInclude LegendsBooleanCB_Include_Legends0
29PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
30PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
31PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
32IFFILXST SearchIf File ExistingIntegerGB0
33FILEXPNM SearchFile Export NameStringSTR255255
34EXPTTYPE SearchExport TypeIntegerINT0
35RPTGRIND SearchReport Group IndexIntegerINT0
36STTCLASS SearchStart ClassStringSTR10_Item_Class_Code10
37ENDCLASS SearchEnd ClassStringSTR10_Item_Class_Code10
38STTSCHED SearchStart ScheduleStringSTR10_Schedule10
39ENSCHDUL SearchEnd ScheduleStringSTR10_Schedule10
40STTLOCCD SearchStart Location CodeStringSTR10_Location_Code10
41ENLOCNCD SearchEnd Location CodeStringSTR10_Location_Code10
42STTLOTTY SearchStart Lot TypeStringSTR10_Lot_Type10
43ENLOTTYP SearchEnd Lot TypeStringSTR10_Lot_Type10
44STRTNGDT SearchStarting DateDateDT8
45ENDINGDT SearchEnding DateDateDT8
46ENDTKNDT SearchEnd Token DateIntegerDDL_End_Dates0
47STTOKNDT SearchStart Token DateIntegerDDL_Start_Dates0
48STRCTNUM SearchStart Receipt NumberStringSTR20_Document_Number20
49ENRCTNBR SearchEnd Receipt NumberStringSTR20_Document_Number20
50RTPACHIN SearchReport Palette Choice IndexIntegerINT0
51RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
52SORTBY SearchSort ByIntegerDDL_Sort_By0
53PRTSRLOT SearchPrint Serial LotBooleanCB_Print_Serial_Lot0
54INZROQTY SearchInclude Zero QTYBooleanCB_Include_Zero_QTY0
55PRTITQTY SearchPrint Item QuantitiesBooleanCB_Print_Item_QTYS0
56STTBINUM SearchStart Bin NumberStringSTR2020
57ENBINNBR SearchEnd Bin NumberStringSTR2020
58STDOCNUM SearchStart Document NumberStringSTR2020
59ENDOCNUM SearchEnd Document NumberStringSTR2020
60STDOCTYP SearchStart Document TypeIntegerINT11
61ENDOCTYP SearchEnd Document TypeIntegerINT11
62STTMODUL SearchStart ModuleStringSTR33
63ENDMODUL SearchEnd ModuleStringSTR33
64STRXSRC SearchStart TRX SourceStringSTR1313
65ENTRXSRC SearchEnd TRX SourceStringSTR1313
66STBCHSRC SearchStart Batch SourceStringSTR1515
67ENBCHSRC SearchEnd Batch SourceStringSTR1515
68STBCHNUM SearchStart Batch NumberStringSTR15_LBAU15
69ENDBNMBR SearchEnd Batch NumberStringSTR15_LBAU15
70STVNDRID SearchStart Vendor IDStringSTR15_LBU15
71ENDVNDID SearchEnd Vendor IDStringSTR15_LBU15
72INQTYREQ SearchInclude QTY RequisitionedBooleanCB_QTY_Requisitioned0
73INZRORLV SearchInclude Zero Reorder LevelBooleanCB_Zero_Reorder0
74CALSGQTY SearchCalc Suggested QTYSIntegerGB0
75RCPTOPTS SearchReceipt OptionsIntegerDDL_Print_Option0
76VENDROPT SearchVendor OptionsIntegerDDL_Vendor_Option0
77SEGSRTBY SearchSegment Sort ByIntegerINT11
78STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
79STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
80STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
81STTACNUM SearchStart Account NumberAccount_NumberComposite 80
82STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
83STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
84STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
85STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
86STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
87STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
88STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
89EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
90EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
91EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
92EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
93EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
94EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
95EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
96EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
97EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
98EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
99EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
100SEGMNTRG SearchUsing Segment RangeIntegerINT0
101Start_PriceLevel SearchStart PriceLevelStringSTR10_PriceLevel10
102End_PriceLevel SearchEnd PriceLevelStringSTR10_PriceLevel10
103Start_QTY_Type SearchStart QTY TypeIntegerDDL_QTY_Type0
104End_QTY_Type SearchEnd QTY TypeIntegerDDL_QTY_Type0
105Start_Component_Item_Num SearchStart Component Item NumberStringSTR30_Item_Number30
106End_Component_Item_Numbe SearchEnd Component Item NumberStringSTR30_Item_Number30
107BM_Assembly_Journal SearchBM Assembly JournalBooleanCB_BM_Assembly_Journal0
108BM_Distribution_Detail SearchBM Distribution DetailBooleanCB_BM_Distribution_Detail0
109BM_Bill_Status_Active SearchBM Bill Status ActiveBooleanBM Bill Status Active0
110BM_Bill_Status_Pending SearchBM Bill Status PendingBooleanBM Bill Status Pending0
111BM_Bill_Status_Obsolete SearchBM Bill Status ObsoleteBooleanBM Bill Status Obsolete0
112BM_Comp_Status_Active SearchBM Comp Status ActiveBooleanBM Comp Status Active0
113BM_Comp_Status_Pending SearchBM Comp Status PendingBooleanBM Comp Status Pending0
114BM_Comp_Status_Obsolete SearchBM Comp Status ObsoleteBooleanBM Comp Status Obsolete0
115BM_Comp_Type_Misc_Charge SearchBM Comp Type Misc ChargesBooleanBM Comp Type Misc Charges0
116BM_Comp_Type_Services SearchBM Comp Type ServicesBooleanBM Comp Type Services0
117BM_Comp_Type_Flat_Fee SearchBM Comp Type Flat FeeBooleanBM Comp Type Flat Fee0
118BM_Print_Notes_Bill SearchBM Print Notes BillBooleanBM Print Notes Bill0
119BM_Print_Notes_Comp SearchBM Print Notes CompBooleanBM Print Notes Comp0
120BM_Print_Cost_Options SearchBM Print Cost OptionsIntegerGB0
121Max_Levels SearchMax LevelsIntegerDDL_Max_Levels0
122DATE1 SearchDateDateDT66
123BMTRXSTATNOTREL SearchBM Trx Status Not ReleasedBooleanCB_BM_Trx_Status_Not_Released0
124BMTRXSTATREL SearchBM Trx Status ReleasedBooleanCB_BM_Trx_Status_Released0
125OPTIONS SearchOptionsIntegerDDL0
126Start_TRX_ID SearchStart TRX IDStringSTR17_TRX_ID17
127End_TRX_ID SearchEnd TRX IDStringSTR17_TRX_ID17
128Starting_TRX_Date SearchStarting TRX DateDateDT_Date6
129Ending_TRX_Date SearchEnding TRX DateDateDT_Date6
130STRTSRLT SearchStart Serial/Lot NumberStringSTR2020
131ENDSERLT SearchEnd Serial/Lot NumberStringSTR2020
132StartPriceGroup SearchStart Price GroupStringSTR10_LBAU10
133EndPriceGroup SearchEnd Price GroupStringSTR10_LBAU10
134STCURRID SearchStart Currency IDStringSTR15_Currency_ID15
135ENDCURID SearchEnd Currency IDStringSTR15_Currency_ID15
136STRTABCCD SearchStart ABC CodeIntegerDDL_ABC_Code0
137ENDABCCD SearchEnd ABC CodeIntegerDDL_ABC_Code0
138STRTSTCKCNTID SearchStart Stock Count IDStringSTR15_LBAU15
139ENDSTCKCNTID SearchEnd Stock Count IDStringSTR15_LBAU15
140Start_Landed_Cost_ID SearchStart Landed Cost IDStringSTR15_LBAU15
141End_Landed_Cost_ID SearchEnd Landed Cost IDStringSTR15_LBAU15
142Start_LandedCostGroupID SearchStart Landed Cost Group IDStringSTR15_LBAU15
143End_LandedCostGroupID SearchEnd Landed Cost Group IDStringSTR15_LBAU15
144ASOFDATE SearchAs Of DateDateDATE6
145INZRQTYI SearchInclude Zero Qty ItemsBooleanCB_IncludeZeroQtyItems0
146STARTBIN SearchStart BinStringSTR15_Bin15
147ENDBIN SearchEnd BinStringSTR15_Bin15
148LNGSTRTDESC SearchLong Start DescriptionStringSTR100100
149LNGENDDESC SearchLong End DescriptionStringSTR100100
150USEGLPOSTINGDATE SearchUse GL Posting DateBooleanCB_Use_GL_Posting_Date0
151INNGVQTY SearchInclude Negative QTYBooleanCB_Include_Negative_QTY0
152COSTAVGPERIODIC SearchCost For Periodic Average ItemsIntegerDDL_CostItems0
153PRTINACT SearchPrint InactiveBooleanCB_Inactive_Items0

Leave a Reply

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