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
66858	9	GC0188	2009-08-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66859	9	GK0045	2017-02-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66860	9	GL0049	2011-03-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66861	9	GC0039	2010-08-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66862	9	GP0058	2010-05-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66863	9	GP0132	2014-05-28	—	63.25	51.0832	45.61	43.55	48.776	40.8304	43.55
66864	9	GA0044	2015-06-28	—	69.5	56.1232	50.11	47.84	53.5808	44.8482	47.84
66865	9	GN0219	2011-04-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66866	9	GH0527	2018-12-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66867	9	GJ0077	2009-01-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66868	9	GL0022	2014-03-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66869	9	GE0236	2017-10-28	—	90.5	72.1168	64.39	61.99	69.4288	58.3929	61.99
66870	9	GL0746	2018-03-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66871	9	GE0364	2015-10-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66872	9	GP0276	2018-05-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66873	9	GF0274	2015-11-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66874	9	GN0355	2017-04-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66875	9	GB0242	2013-07-28	—	63	50.8816	45.43	43.33	48.5296	40.625	43.33
66876	9	GL0207	2019-03-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66877	9	GP0635	2017-05-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66878	9	GF0291	2012-11-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66879	9	GB0220	2011-07-28	—	53.5	43.0416	38.43	36.65	41.048	34.3571	36.65
66880	9	GEO198	2019-10-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66881	9	GA0128	2009-06-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66882	9	GC0108	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66883	9	GB0107	2018-07-28	—	97.5	77.9968	69.64	66.45	74.424	62.8929	66.45
66884	9	GK0360	2012-02-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66885	9	GK0082	2014-02-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66886	9	GA0313	2014-06-28	—	63.25	51.0832	45.61	43.55	48.776	40.8304	43.55
66887	9	GK0346	2018-02-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66888	9	GK0138	2020-02-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66889	9	GL0217	2019-03-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66890	9	GLO285	2017-03-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66891	9	GA0347	2008-06-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66892	9	GA0506	2017-06-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66893	9	GF0052	2013-11-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66894	9	GLO465	2017-03-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66895	9	GK0350	2012-02-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66896	9	GB0069	2020-07-28	—	117	93.5984	83.57	75.21	84.2352	75.2143	75.21
66897	9	GP0363	2015-05-28	—	69.5	56.1232	50.11	47.84	53.5808	44.8482	47.84
66898	9	GC0118	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66899	9	GA0095	2016-06-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66900	9	GP0507	2019-05-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66901	9	GPO238	2020-05-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66902	9	GE0107	2018-10-28	—	97.5	77.9968	69.64	62.68	70.2016	62.6786	62.68
66903	9	GE0236.	2017-10-28	—	90.5	72.744	64.95	61.99	69.4288	58.3929	61.99
66904	9	GK0323	2015-02-28	—	69.5	56.1232	50.11	47.83	53.5696	44.8393	47.83
66905	9	GA0218	2009-06-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66906	9	GJ0281	2013-01-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66907	9	GA0120	2011-06-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2

401–450 of 10,000+ rows

UnqId	ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
66858	9	GC0188	2009-08-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66859	9	GK0045	2017-02-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66860	9	GL0049	2011-03-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66861	9	GC0039	2010-08-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66862	9	GP0058	2010-05-28	—	48.85	39.4576	35.23	33.94	38.0128	31.5179	33.94
66863	9	GP0132	2014-05-28	—	63.25	51.0832	45.61	43.55	48.776	40.8304	43.55
66864	9	GA0044	2015-06-28	—	69.5	56.1232	50.11	47.84	53.5808	44.8482	47.84
66865	9	GN0219	2011-04-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2
66866	9	GH0527	2018-12-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66867	9	GJ0077	2009-01-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66868	9	GL0022	2014-03-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66869	9	GE0236	2017-10-28	—	90.5	72.1168	64.39	61.99	69.4288	58.3929	61.99
66870	9	GL0746	2018-03-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66871	9	GE0364	2015-10-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66872	9	GP0276	2018-05-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66873	9	GF0274	2015-11-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66874	9	GN0355	2017-04-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66875	9	GB0242	2013-07-28	—	63	50.8816	45.43	43.33	48.5296	40.625	43.33
66876	9	GL0207	2019-03-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66877	9	GP0635	2017-05-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66878	9	GF0291	2012-11-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66879	9	GB0220	2011-07-28	—	53.5	43.0416	38.43	36.65	41.048	34.3571	36.65
66880	9	GEO198	2019-10-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66881	9	GA0128	2009-06-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66882	9	GC0108	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66883	9	GB0107	2018-07-28	—	97.5	77.9968	69.64	66.45	74.424	62.8929	66.45
66884	9	GK0360	2012-02-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66885	9	GK0082	2014-02-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66886	9	GA0313	2014-06-28	—	63.25	51.0832	45.61	43.55	48.776	40.8304	43.55
66887	9	GK0346	2018-02-28	—	90.5	72.3968	64.64	61.69	69.0928	58.3839	61.69
66888	9	GK0138	2020-02-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66889	9	GL0217	2019-03-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66890	9	GLO285	2017-03-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66891	9	GA0347	2008-06-28	—	42.3	34.16	30.5	29.38	32.9056	27.2857	29.38
66892	9	GA0506	2017-06-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66893	9	GF0052	2013-11-28	—	63.25	51.0832	45.61	43.52	48.7424	40.8036	43.52
66894	9	GLO465	2017-03-28	—	83.5	67.4352	60.21	57.48	64.3776	53.8839	57.48
66895	9	GK0350	2012-02-28	—	53.3	43.0416	38.43	36.65	41.048	34.3571	36.65
66896	9	GB0069	2020-07-28	—	117	93.5984	83.57	75.21	84.2352	75.2143	75.21
66897	9	GP0363	2015-05-28	—	69.5	56.1232	50.11	47.84	53.5808	44.8482	47.84
66898	9	GC0118	2019-08-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66899	9	GA0095	2016-06-28	—	76	61.376	54.8	52.31	58.5872	49.0446	52.31
66900	9	GP0507	2019-05-28	—	99.5	79.5984	71.07	63.96	71.6352	63.9643	63.96
66901	9	GPO238	2020-05-28	—	106.5	85.1984	76.07	68.46	76.6752	68.4643	68.46
66902	9	GE0107	2018-10-28	—	97.5	77.9968	69.64	62.68	70.2016	62.6786	62.68
66903	9	GE0236.	2017-10-28	—	90.5	72.744	64.95	61.99	69.4288	58.3929	61.99
66904	9	GK0323	2015-02-28	—	69.5	56.1232	50.11	47.83	53.5696	44.8393	47.83
66905	9	GA0218	2009-06-28	—	44.4	35.8624	32.02	30.85	34.552	28.6429	30.85
66906	9	GJ0281	2013-01-28	—	57.3	46.2784	41.32	39.4	44.128	36.9375	39.4
66907	9	GA0120	2011-06-28	—	53.5	43.2096	38.58	37.2	41.664	34.5446	37.2

401–450 of 10,000+ rows