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 Group Display Name: Inventory Report Options
Physical Name: IV70500
Technical Name: IV_Options_ROPT
Group Technical Name: Inventory Report Options
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PRTBYSIT ![]() | Print by Site | GB | Integer | 0 | |
2 | PRNTOPTN ![]() | Print Option | GB | Integer | 0 | |
3 | STTGNDSC ![]() | Start Generic Description | STR10 | String | 10 | |
4 | ENGENDSC ![]() | End Generic Description | STR10 | String | 10 | |
5 | ENUSRCAT ![]() | End User Category | STR10 | String | 10 | |
6 | ENUSRCAT_1 ![]() | End User Category[1] | STR10 | String | 10 | |
7 | ENUSRCAT_2 ![]() | End User Category[2] | STR10 | String | 10 | |
8 | ENUSRCAT_3 ![]() | End User Category[3] | STR10 | String | 10 | |
9 | ENUSRCAT_4 ![]() | End User Category[4] | STR10 | String | 10 | |
10 | ENUSRCAT_5 ![]() | End User Category[5] | STR10 | String | 10 | |
11 | ENUSRCAT_6 ![]() | End User Category[6] | STR10 | String | 10 | |
12 | KITSRTBY ![]() | Kit Sort By | GB | Integer | 0 | |
13 | STRTUCAT ![]() | Start User Category | STR10 | String | 10 | |
14 | STRTUCAT_1 ![]() | Start User Category[1] | STR10 | String | 10 | |
15 | STRTUCAT_2 ![]() | Start User Category[2] | STR10 | String | 10 | |
16 | STRTUCAT_3 ![]() | Start User Category[3] | STR10 | String | 10 | |
17 | STRTUCAT_4 ![]() | Start User Category[4] | STR10 | String | 10 | |
18 | STRTUCAT_5 ![]() | Start User Category[5] | STR10 | String | 10 | |
19 | STRTUCAT_6 ![]() | Start User Category[6] | STR10 | String | 10 | |
20 | STTITNUM ![]() | Start Item Number | STR30_Item_Number | String | 30 | |
21 | ENITMNBR ![]() | End Item Number | STR30_Item_Number | String | 30 | |
22 | PRVDRINF ![]() | Print Vendor Information | GB | Integer | 0 | |
23 | PRTDSCNT ![]() | Print Discontinued | CB_Discontinued | Boolean | 0 | |
24 | FINRPTNM ![]() | Financial Report Name | STR30 | String | 30 | |
25 | PRNTNOTS ![]() | Print Notes | CB_Print_Notes | Boolean | 0 | |
26 | PRNTTYPE ![]() | Print Type | GB | Integer | 0 | |
27 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
28 | INCLGNDS ![]() | Include Legends | CB_Include_Legends | Boolean | 0 | |
29 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
30 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
31 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
32 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
33 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
34 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
35 | RPTGRIND ![]() | Report Group Index | INT | Integer | 0 | |
36 | STTCLASS ![]() | Start Class | STR10_Item_Class_Code | String | 10 | |
37 | ENDCLASS ![]() | End Class | STR10_Item_Class_Code | String | 10 | |
38 | STTSCHED ![]() | Start Schedule | STR10_Schedule | String | 10 | |
39 | ENSCHDUL ![]() | End Schedule | STR10_Schedule | String | 10 | |
40 | STTLOCCD ![]() | Start Location Code | STR10_Location_Code | String | 10 | |
41 | ENLOCNCD ![]() | End Location Code | STR10_Location_Code | String | 10 | |
42 | STTLOTTY ![]() | Start Lot Type | STR10_Lot_Type | String | 10 | |
43 | ENLOTTYP ![]() | End Lot Type | STR10_Lot_Type | String | 10 | |
44 | STRTNGDT ![]() | Starting Date | DT | Date | 8 | |
45 | ENDINGDT ![]() | Ending Date | DT | Date | 8 | |
46 | ENDTKNDT ![]() | End Token Date | DDL_End_Dates | Integer | 0 | |
47 | STTOKNDT ![]() | Start Token Date | DDL_Start_Dates | Integer | 0 | |
48 | STRCTNUM ![]() | Start Receipt Number | STR20_Document_Number | String | 20 | |
49 | ENRCTNBR ![]() | End Receipt Number | STR20_Document_Number | String | 20 | |
50 | RTPACHIN ![]() | Report Palette Choice Index | INT | Integer | 0 | |
51 | RTGRSBIN ![]() | Report Group Sub Index | DLR14 | Currency | 14 | |
52 | SORTBY ![]() | Sort By | DDL_Sort_By | Integer | 0 | |
53 | PRTSRLOT ![]() | Print Serial Lot | CB_Print_Serial_Lot | Boolean | 0 | |
54 | INZROQTY ![]() | Include Zero QTY | CB_Include_Zero_QTY | Boolean | 0 | |
55 | PRTITQTY ![]() | Print Item Quantities | CB_Print_Item_QTYS | Boolean | 0 | |
56 | STTBINUM ![]() | Start Bin Number | STR20 | String | 20 | |
57 | ENBINNBR ![]() | End Bin Number | STR20 | String | 20 | |
58 | STDOCNUM ![]() | Start Document Number | STR20 | String | 20 | |
59 | ENDOCNUM ![]() | End Document Number | STR20 | String | 20 | |
60 | STDOCTYP ![]() | Start Document Type | INT1 | Integer | 1 | |
61 | ENDOCTYP ![]() | End Document Type | INT1 | Integer | 1 | |
62 | STTMODUL ![]() | Start Module | STR3 | String | 3 | |
63 | ENDMODUL ![]() | End Module | STR3 | String | 3 | |
64 | STRXSRC ![]() | Start TRX Source | STR13 | String | 13 | |
65 | ENTRXSRC ![]() | End TRX Source | STR13 | String | 13 | |
66 | STBCHSRC ![]() | Start Batch Source | STR15 | String | 15 | |
67 | ENBCHSRC ![]() | End Batch Source | STR15 | String | 15 | |
68 | STBCHNUM ![]() | Start Batch Number | STR15_LBAU | String | 15 | |
69 | ENDBNMBR ![]() | End Batch Number | STR15_LBAU | String | 15 | |
70 | STVNDRID ![]() | Start Vendor ID | STR15_LBU | String | 15 | |
71 | ENDVNDID ![]() | End Vendor ID | STR15_LBU | String | 15 | |
72 | INQTYREQ ![]() | Include QTY Requisitioned | CB_QTY_Requisitioned | Boolean | 0 | |
73 | INZRORLV ![]() | Include Zero Reorder Level | CB_Zero_Reorder | Boolean | 0 | |
74 | CALSGQTY ![]() | Calc Suggested QTYS | GB | Integer | 0 | |
75 | RCPTOPTS ![]() | Receipt Options | DDL_Print_Option | Integer | 0 | |
76 | VENDROPT ![]() | Vendor Options | DDL_Vendor_Option | Integer | 0 | |
77 | SEGSRTBY ![]() | Segment Sort By | INT1 | Integer | 1 | |
78 | STTACNUM ![]() | Start Account Number | Account_Number | Composite | 80 | |
79 | STTACNUM_1 ![]() | Start Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
80 | STTACNUM_2 ![]() | Start Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
81 | STTACNUM_3 ![]() | Start Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
82 | STTACNUM_4 ![]() | Start Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
83 | STTACNUM_5 ![]() | Start Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
84 | STTACNUM_6 ![]() | Start Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
85 | STTACNUM_7 ![]() | Start Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
86 | STTACNUM_8 ![]() | Start Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
87 | STTACNUM_9 ![]() | Start Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
88 | STTACNUM_10 ![]() | Start Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
89 | EACCNBR ![]() | End Account Number | Account_Number | Composite | 80 | |
90 | EACCNBR_1 ![]() | End Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
91 | EACCNBR_2 ![]() | End Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
92 | EACCNBR_3 ![]() | End Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
93 | EACCNBR_4 ![]() | End Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
94 | EACCNBR_5 ![]() | End Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
95 | EACCNBR_6 ![]() | End Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
96 | EACCNBR_7 ![]() | End Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
97 | EACCNBR_8 ![]() | End Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
98 | EACCNBR_9 ![]() | End Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
99 | EACCNBR_10 ![]() | End Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
100 | SEGMNTRG ![]() | Using Segment Range | INT | Integer | 0 | |
101 | Start_PriceLevel ![]() | Start PriceLevel | STR10_PriceLevel | String | 10 | |
102 | End_PriceLevel ![]() | End PriceLevel | STR10_PriceLevel | String | 10 | |
103 | Start_QTY_Type ![]() | Start QTY Type | DDL_QTY_Type | Integer | 0 | |
104 | End_QTY_Type ![]() | End QTY Type | DDL_QTY_Type | Integer | 0 | |
105 | Start_Component_Item_Num ![]() | Start Component Item Number | STR30_Item_Number | String | 30 | |
106 | End_Component_Item_Numbe ![]() | End Component Item Number | STR30_Item_Number | String | 30 | |
107 | BM_Assembly_Journal ![]() | BM Assembly Journal | CB_BM_Assembly_Journal | Boolean | 0 | |
108 | BM_Distribution_Detail ![]() | BM Distribution Detail | CB_BM_Distribution_Detail | Boolean | 0 | |
109 | BM_Bill_Status_Active ![]() | BM Bill Status Active | BM Bill Status Active | Boolean | 0 | |
110 | BM_Bill_Status_Pending ![]() | BM Bill Status Pending | BM Bill Status Pending | Boolean | 0 | |
111 | BM_Bill_Status_Obsolete ![]() | BM Bill Status Obsolete | BM Bill Status Obsolete | Boolean | 0 | |
112 | BM_Comp_Status_Active ![]() | BM Comp Status Active | BM Comp Status Active | Boolean | 0 | |
113 | BM_Comp_Status_Pending ![]() | BM Comp Status Pending | BM Comp Status Pending | Boolean | 0 | |
114 | BM_Comp_Status_Obsolete ![]() | BM Comp Status Obsolete | BM Comp Status Obsolete | Boolean | 0 | |
115 | BM_Comp_Type_Misc_Charge ![]() | BM Comp Type Misc Charges | BM Comp Type Misc Charges | Boolean | 0 | |
116 | BM_Comp_Type_Services ![]() | BM Comp Type Services | BM Comp Type Services | Boolean | 0 | |
117 | BM_Comp_Type_Flat_Fee ![]() | BM Comp Type Flat Fee | BM Comp Type Flat Fee | Boolean | 0 | |
118 | BM_Print_Notes_Bill ![]() | BM Print Notes Bill | BM Print Notes Bill | Boolean | 0 | |
119 | BM_Print_Notes_Comp ![]() | BM Print Notes Comp | BM Print Notes Comp | Boolean | 0 | |
120 | BM_Print_Cost_Options ![]() | BM Print Cost Options | GB | Integer | 0 | |
121 | Max_Levels ![]() | Max Levels | DDL_Max_Levels | Integer | 0 | |
122 | DATE1 ![]() | Date | DT6 | Date | 6 | |
123 | BMTRXSTATNOTREL ![]() | BM Trx Status Not Released | CB_BM_Trx_Status_Not_Released | Boolean | 0 | |
124 | BMTRXSTATREL ![]() | BM Trx Status Released | CB_BM_Trx_Status_Released | Boolean | 0 | |
125 | OPTIONS ![]() | Options | DDL | Integer | 0 | |
126 | Start_TRX_ID ![]() | Start TRX ID | STR17_TRX_ID | String | 17 | |
127 | End_TRX_ID ![]() | End TRX ID | STR17_TRX_ID | String | 17 | |
128 | Starting_TRX_Date ![]() | Starting TRX Date | DT_Date | Date | 6 | |
129 | Ending_TRX_Date ![]() | Ending TRX Date | DT_Date | Date | 6 | |
130 | STRTSRLT ![]() | Start Serial/Lot Number | STR20 | String | 20 | |
131 | ENDSERLT ![]() | End Serial/Lot Number | STR20 | String | 20 | |
132 | StartPriceGroup ![]() | Start Price Group | STR10_LBAU | String | 10 | |
133 | EndPriceGroup ![]() | End Price Group | STR10_LBAU | String | 10 | |
134 | STCURRID ![]() | Start Currency ID | STR15_Currency_ID | String | 15 | |
135 | ENDCURID ![]() | End Currency ID | STR15_Currency_ID | String | 15 | |
136 | STRTABCCD ![]() | Start ABC Code | DDL_ABC_Code | Integer | 0 | |
137 | ENDABCCD ![]() | End ABC Code | DDL_ABC_Code | Integer | 0 | |
138 | STRTSTCKCNTID ![]() | Start Stock Count ID | STR15_LBAU | String | 15 | |
139 | ENDSTCKCNTID ![]() | End Stock Count ID | STR15_LBAU | String | 15 | |
140 | Start_Landed_Cost_ID ![]() | Start Landed Cost ID | STR15_LBAU | String | 15 | |
141 | End_Landed_Cost_ID ![]() | End Landed Cost ID | STR15_LBAU | String | 15 | |
142 | Start_LandedCostGroupID ![]() | Start Landed Cost Group ID | STR15_LBAU | String | 15 | |
143 | End_LandedCostGroupID ![]() | End Landed Cost Group ID | STR15_LBAU | String | 15 | |
144 | ASOFDATE ![]() | As Of Date | DATE | Date | 6 | |
145 | INZRQTYI ![]() | Include Zero Qty Items | CB_IncludeZeroQtyItems | Boolean | 0 | |
146 | STARTBIN ![]() | Start Bin | STR15_Bin | String | 15 | |
147 | ENDBIN ![]() | End Bin | STR15_Bin | String | 15 | |
148 | LNGSTRTDESC ![]() | Long Start Description | STR100 | String | 100 | |
149 | LNGENDDESC ![]() | Long End Description | STR100 | String | 100 | |
150 | USEGLPOSTINGDATE ![]() | Use GL Posting Date | CB_Use_GL_Posting_Date | Boolean | 0 | |
151 | INNGVQTY ![]() | Include Negative QTY | CB_Include_Negative_QTY | Boolean | 0 | |
152 | COSTAVGPERIODIC ![]() | Cost For Periodic Average Items | DDL_CostItems | Integer | 0 | |
153 | PRTINACT ![]() | Print Inactive | CB_Inactive_Items | Boolean | 0 | |
154 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |