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

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Report Options (IV70500)

Leave a Reply Cancel reply