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
166660	8	JP0135	2007-05-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
166661	8	JA0106	2007-06-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
166662	8	#JP0106	2008-05-28	—	69.25	55.9216	49.93	48.08	53.8496	44.6429	48.08
166663	8	JP0062	2004-05-28	—	49	41.5632	37.11	35.44	39.6928	34.4911	35.44
166664	8	GN0121	2013-04-28	—	103.15	83.3056	74.38	70.9	79.408	66.4643	70.9
166665	8	GP0076	2018-05-28	—	161.5	129.2032	115.36	110.03	123.2336	104.1339	110.03
166666	8	GN0131	2013-04-28	—	103.15	83.3056	74.38	70.9	79.408	66.4643	70.9
166667	8	GP0148	2010-05-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166668	8	$JB0305	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166669	8	JA0364	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166670	8	GD0368	2019-09-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166671	8	GD0467	2018-09-28	—	161.5	129.2032	115.36	103.82	116.2784	103.8214	103.82
166672	8	JN0103	2005-04-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166673	8	GL0072	2014-03-28	—	103.5	83.5968	74.64	71.2	79.744	66.75	71.2
166674	8	GP0127	2019-05-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166675	8	JN0164	2006-04-28	—	52.9	44.4304	39.67	38.23	42.8176	37.2054	38.23
166676	8	JD0182.	2003-09-28	—	49	41.5072	37.06	35.78	40.0736	34.8214	35.78
166677	8	GP0527	2019-05-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166678	8	GA0045	2016-06-28	—	136	109.8384	98.07	93.56	104.7872	87.7143	93.56
166679	8	GA0024	2015-06-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166680	8	GF0271	2012-11-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166681	8	JL0163	2005-03-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
166682	8	GF0164	2015-11-28	—	124	100.1504	89.42	85.32	95.5584	79.9911	85.32
166683	8	JK0314	2006-02-28	—	52.9	44.4304	39.67	38.23	42.8176	37.2054	38.23
166684	8	GH0150	2011-12-28	—	87.4	70.5824	63.02	60.08	67.2896	56.3214	60.08
166685	8	GN0093	2015-04-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166686	8	GK0510	2012-02-28	—	87.4	70.5824	63.02	60.08	67.2896	56.3214	60.08
166687	8	JB0084	2005-07-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166688	8	JE0142.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
166689	8	GH0029	2010-12-28	—	80	64.6128	57.69	55.62	62.2944	51.6429	55.62
166690	8	GAO261	2012-06-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166691	8	HJ0103	2015-01-28	—	113	91.2688	81.49	77.75	87.08	72.8929	77.75
166692	8	GH0127	2018-12-28	—	164	131.1968	117.14	105.43	118.0816	105.4286	105.43
166693	8	$JB0225	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166694	8	GP0010	2012-05-28	—	93.8	75.7568	67.64	64.47	72.2064	60.4375	64.47
166695	8	GB0079	2010-07-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166696	8	GB0210	2011-07-28	—	87.6	70.7392	63.16	60.22	67.4464	56.4554	60.22
166697	8	GF0012	2013-11-28	—	103.5	83.5968	74.64	71.2	79.744	66.75	71.2
166698	8	GF0187	2008-11-28	—	69.25	55.9216	49.93	48.08	53.8496	44.6429	48.08
166699	8	GF0698	2019-11-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166700	8	GB0164	2015-08-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166701	8	JH0024	2005-12-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166702	8	GD0314.	2015-09-28	—	124	100.1504	89.42	85.32	95.5584	79.9911	85.32
166703	8	JH0265	2006-12-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
166704	8	GA0151	2012-06-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166705	8	JH0092	2003-12-28	—	49	41.5632	37.11	35.44	39.6928	34.4911	35.44
166706	8	JK0023	2005-02-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
166707	8	$JB0215	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166708	8	GJ0308	2010-01-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166709	8	JP0033	2005-05-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22

51–100 of 10,000+ rows

UnqId	ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
166660	8	JP0135	2007-05-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
166661	8	JA0106	2007-06-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
166662	8	#JP0106	2008-05-28	—	69.25	55.9216	49.93	48.08	53.8496	44.6429	48.08
166663	8	JP0062	2004-05-28	—	49	41.5632	37.11	35.44	39.6928	34.4911	35.44
166664	8	GN0121	2013-04-28	—	103.15	83.3056	74.38	70.9	79.408	66.4643	70.9
166665	8	GP0076	2018-05-28	—	161.5	129.2032	115.36	110.03	123.2336	104.1339	110.03
166666	8	GN0131	2013-04-28	—	103.15	83.3056	74.38	70.9	79.408	66.4643	70.9
166667	8	GP0148	2010-05-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166668	8	$JB0305	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166669	8	JA0364	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166670	8	GD0368	2019-09-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166671	8	GD0467	2018-09-28	—	161.5	129.2032	115.36	103.82	116.2784	103.8214	103.82
166672	8	JN0103	2005-04-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166673	8	GL0072	2014-03-28	—	103.5	83.5968	74.64	71.2	79.744	66.75	71.2
166674	8	GP0127	2019-05-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166675	8	JN0164	2006-04-28	—	52.9	44.4304	39.67	38.23	42.8176	37.2054	38.23
166676	8	JD0182.	2003-09-28	—	49	41.5072	37.06	35.78	40.0736	34.8214	35.78
166677	8	GP0527	2019-05-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166678	8	GA0045	2016-06-28	—	136	109.8384	98.07	93.56	104.7872	87.7143	93.56
166679	8	GA0024	2015-06-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166680	8	GF0271	2012-11-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166681	8	JL0163	2005-03-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
166682	8	GF0164	2015-11-28	—	124	100.1504	89.42	85.32	95.5584	79.9911	85.32
166683	8	JK0314	2006-02-28	—	52.9	44.4304	39.67	38.23	42.8176	37.2054	38.23
166684	8	GH0150	2011-12-28	—	87.4	70.5824	63.02	60.08	67.2896	56.3214	60.08
166685	8	GN0093	2015-04-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166686	8	GK0510	2012-02-28	—	87.4	70.5824	63.02	60.08	67.2896	56.3214	60.08
166687	8	JB0084	2005-07-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166688	8	JE0142.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
166689	8	GH0029	2010-12-28	—	80	64.6128	57.69	55.62	62.2944	51.6429	55.62
166690	8	GAO261	2012-06-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166691	8	HJ0103	2015-01-28	—	113	91.2688	81.49	77.75	87.08	72.8929	77.75
166692	8	GH0127	2018-12-28	—	164	131.1968	117.14	105.43	118.0816	105.4286	105.43
166693	8	$JB0225	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166694	8	GP0010	2012-05-28	—	93.8	75.7568	67.64	64.47	72.2064	60.4375	64.47
166695	8	GB0079	2010-07-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166696	8	GB0210	2011-07-28	—	87.6	70.7392	63.16	60.22	67.4464	56.4554	60.22
166697	8	GF0012	2013-11-28	—	103.5	83.5968	74.64	71.2	79.744	66.75	71.2
166698	8	GF0187	2008-11-28	—	69.25	55.9216	49.93	48.08	53.8496	44.6429	48.08
166699	8	GF0698	2019-11-28	—	177.5	142.0048	126.79	114.11	127.8032	114.1071	114.11
166700	8	GB0164	2015-08-28	—	124	100.1504	89.42	85.3	95.536	79.9643	85.3
166701	8	JH0024	2005-12-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
166702	8	GD0314.	2015-09-28	—	124	100.1504	89.42	85.32	95.5584	79.9911	85.32
166703	8	JH0265	2006-12-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
166704	8	GA0151	2012-06-28	—	93.8	75.7568	67.64	64.48	72.2176	60.4464	64.48
166705	8	JH0092	2003-12-28	—	49	41.5632	37.11	35.44	39.6928	34.4911	35.44
166706	8	JK0023	2005-02-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
166707	8	$JB0215	2006-07-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
166708	8	GJ0308	2010-01-28	—	80	64.6128	57.69	55.56	62.2272	51.5893	55.56
166709	8	JP0033	2005-05-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22

51–100 of 10,000+ rows