dbo.tbl_Batch_History_Previous

2,93,254 rows · 17 columns

ready

Read-only. Up to 100 rows a page, 5,000 in an export.

UnqId	ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
66808	9	GA0358	2019-06-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66809	9	GE0351	2012-10-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66810	9	GE0045	2016-10-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66811	9	GE0096	2017-10-28	—	90.5	72.1168	64.39	61.99	69.4288	58.3929	61.99
66812	9	GH0202	2013-12-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66813	9	GA0347.	2018-06-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66814	9	GJ0153	2015-01-28	—	69	55.72	49.75	47.49	53.1888	44.5179	47.49
66815	9	GH0022	2013-12-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66816	9	GP0154	2016-05-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66817	9	GK0377	2019-02-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66818	9	GH0037	2008-12-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66819	9	GL0337	2009-03-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66820	9	GL0230	2012-03-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66821	9	GL0038	2020-03-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66822	9	GA0072	2013-06-28	—	63	50.8816	45.43	43.31	48.5072	40.6071	43.31
66823	9	GJ0328	2010-01-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66824	9	GP0576	2018-05-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66825	9	GN0321	2013-04-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66826	9	GB0049	2010-07-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66827	9	GK0188	2010-02-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66828	9	GB0105	2016-07-28	—	83.5	67.4352	60.21	57.46	64.3552	53.8661	57.46
66829	9	GH0364	2015-12-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66830	9	GH0786.	2017-12-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66831	9	GB0029	2020-07-28	—	117	93.5984	83.57	75.21	84.2352	75.2143	75.21
66832	9	GE0213	2014-11-28	—	69	55.72	49.75	47.49	53.1888	44.5179	47.49
66833	9	GC0088	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66834	9	GK0230	2012-03-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66835	9	GL0051	2013-03-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66836	9	GC0085	2016-08-28	—	83.5	67.4352	60.21	57.47	64.3664	53.875	57.47
66837	9	GE0181	2012-10-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66838	9	GE0123	2014-10-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66839	9	GC0397	2008-08-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66840	9	GE0072	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66841	9	GNO118	2020-04-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66842	9	GK0285	2017-02-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66843	9	GF0158	2019-11-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66844	9	GB0174	2015-07-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66845	9	GE0052	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66846	9	GL0073	2015-03-28	—	69.5	56.1232	50.11	47.83	53.5696	44.8393	47.83
66847	9	GA0041	2012-06-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66848	9	GF0340	2011-11-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66849	9	GE0062	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66850	9	GH0058	2009-12-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66851	9	GK0209	2011-02-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66852	9	GN0231	2013-04-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66853	9	GC0220	2011-08-28	—	53.3	43.0416	38.43	36.65	41.048	0	36.65
66854	9	GB0203	2014-07-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66855	9	GC0173	2014-08-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66856	9	GF0188	2019-11-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66857	9	GD0031	2012-09-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4

351–400 of 10,000+ rows

UnqId	ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
66808	9	GA0358	2019-06-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66809	9	GE0351	2012-10-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66810	9	GE0045	2016-10-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66811	9	GE0096	2017-10-28	—	90.5	72.1168	64.39	61.99	69.4288	58.3929	61.99
66812	9	GH0202	2013-12-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66813	9	GA0347.	2018-06-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66814	9	GJ0153	2015-01-28	—	69	55.72	49.75	47.49	53.1888	44.5179	47.49
66815	9	GH0022	2013-12-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66816	9	GP0154	2016-05-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66817	9	GK0377	2019-02-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66818	9	GH0037	2008-12-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66819	9	GL0337	2009-03-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66820	9	GL0230	2012-03-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66821	9	GL0038	2020-03-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66822	9	GA0072	2013-06-28	—	63	50.8816	45.43	43.31	48.5072	40.6071	43.31
66823	9	GJ0328	2010-01-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66824	9	GP0576	2018-05-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66825	9	GN0321	2013-04-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66826	9	GB0049	2010-07-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66827	9	GK0188	2010-02-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66828	9	GB0105	2016-07-28	—	83.5	67.4352	60.21	57.46	64.3552	53.8661	57.46
66829	9	GH0364	2015-12-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66830	9	GH0786.	2017-12-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66831	9	GB0029	2020-07-28	—	117	93.5984	83.57	75.21	84.2352	75.2143	75.21
66832	9	GE0213	2014-11-28	—	69	55.72	49.75	47.49	53.1888	44.5179	47.49
66833	9	GC0088	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66834	9	GK0230	2012-03-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66835	9	GL0051	2013-03-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66836	9	GC0085	2016-08-28	—	83.5	67.4352	60.21	57.47	64.3664	53.875	57.47
66837	9	GE0181	2012-10-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66838	9	GE0123	2014-10-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66839	9	GC0397	2008-08-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66840	9	GE0072	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66841	9	GNO118	2020-04-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66842	9	GK0285	2017-02-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66843	9	GF0158	2019-11-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66844	9	GB0174	2015-07-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66845	9	GE0052	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66846	9	GL0073	2015-03-28	—	69.5	56.1232	50.11	47.83	53.5696	44.8393	47.83
66847	9	GA0041	2012-06-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66848	9	GF0340	2011-11-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66849	9	GE0062	2013-10-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66850	9	GH0058	2009-12-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66851	9	GK0209	2011-02-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66852	9	GN0231	2013-04-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66853	9	GC0220	2011-08-28	—	53.3	43.0416	38.43	36.65	41.048	0	36.65
66854	9	GB0203	2014-07-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66855	9	GC0173	2014-08-28	—	69.2	55.888	49.9	47.63	53.3456	44.6518	47.63
66856	9	GF0188	2019-11-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66857	9	GD0031	2012-09-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4

351–400 of 10,000+ rows