dbo.tbl_Batch_History

7,81,180 rows · 17 columns

ready

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

ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	4198001A	2006-11-28	—	79.98	68.9248	61.54	59.08	66.1696	57.5	59.08
233	1201000095	2013-12-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000339	2014-01-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000446	2014-02-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000685	2014-03-28	—	89.5	72.2848	64.54	61.37	68.7344	57.5357	61.37
233	1201001241	2014-06-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1201001492	2014-08-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1201002043	2014-10-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000088	2014-12-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000089	2014-12-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000466	2015-03-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000637	2015-04-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301001104	2015-06-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301001464	2015-07-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1301001856	2015-09-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000038	2015-12-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000185	2016-01-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000581	2016-02-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000804	2016-03-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401001393	2016-06-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401001571	2016-07-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401002174	2016-09-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1401002321	2016-10-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1401002485	2016-11-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1501000096	2016-12-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1501000200	2017-01-28	—	116.85	95.3344	85.12	80.95	90.664	75.8929	80.95
233	1501000566	2017-03-28	—	116.7	95.2112	85.01	81.29	91.0448	75.9554	81.29
233	1501001074	2017-06-28	—	116.7	95.2112	85.01	81.29	91.0448	76.2054	81.29
233	1501001339	2017-08-28	—	116.7	95.2112	85.01	81.29	91.0448	76.2054	81.29
233	1501001514	2017-09-28	—	127.75	104.2272	93.06	89	99.68	83.4375	89
233	1601000023	2017-12-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000065	2018-01-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000216	2018-03-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000381	2018-05-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000721	2018-07-28	—	127.75	103.2528	92.19	88.17	98.7504	83.4464	88.17
233	1608000967	2018-09-28	—	127.75	103.2528	92.19	88.17	98.7504	83.4464	88.17
233	1608001135	2018-10-28	—	139.9	113.0864	100.97	96.56	108.1472	91.3839	96.56
233	1708000119	2019-01-28	—	139.9	113.0864	100.97	96.56	108.1472	91.3839	96.56
233	1708000374	2019-03-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708000906	2019-06-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001234	2019-08-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001237	2019-08-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001712	2019-11-28	—	153.2	122.5616	109.43	98.49	110.3088	98.4911	98.49
233	2513000305	2027-11-30	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2513000135	2027-08-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	#6733013A	2008-09-28	—	87.5	70.5488	62.99	60.48	67.7376	56.1607	60.48
233	#6733014A	2008-10-28	—	87.5	70.6608	63.09	60.57	67.8384	56.2411	60.57

9,651–9,700 of 10,000+ rows

ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	4198001A	2006-11-28	—	79.98	68.9248	61.54	59.08	66.1696	57.5	59.08
233	1201000095	2013-12-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000339	2014-01-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000446	2014-02-28	—	89	71.8816	64.18	61.03	68.3536	57.2143	61.03
233	1201000685	2014-03-28	—	89.5	72.2848	64.54	61.37	68.7344	57.5357	61.37
233	1201001241	2014-06-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1201001492	2014-08-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1201002043	2014-10-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000088	2014-12-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000089	2014-12-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000466	2015-03-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301000637	2015-04-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301001104	2015-06-28	—	97.5	78.7472	70.31	66.86	74.8832	62.6786	66.86
233	1301001464	2015-07-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1301001856	2015-09-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000038	2015-12-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000185	2016-01-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000581	2016-02-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401000804	2016-03-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401001393	2016-06-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401001571	2016-07-28	—	106.75	86.2176	76.98	73.21	81.9952	68.6339	73.21
233	1401002174	2016-09-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1401002321	2016-10-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1401002485	2016-11-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1501000096	2016-12-28	—	116.85	95.368	85.15	80.97	90.6864	75.9107	80.97
233	1501000200	2017-01-28	—	116.85	95.3344	85.12	80.95	90.664	75.8929	80.95
233	1501000566	2017-03-28	—	116.7	95.2112	85.01	81.29	91.0448	75.9554	81.29
233	1501001074	2017-06-28	—	116.7	95.2112	85.01	81.29	91.0448	76.2054	81.29
233	1501001339	2017-08-28	—	116.7	95.2112	85.01	81.29	91.0448	76.2054	81.29
233	1501001514	2017-09-28	—	127.75	104.2272	93.06	89	99.68	83.4375	89
233	1601000023	2017-12-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000065	2018-01-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000216	2018-03-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000381	2018-05-28	—	127.75	103.7456	92.63	88.58	99.2096	83.4375	88.58
233	1608000721	2018-07-28	—	127.75	103.2528	92.19	88.17	98.7504	83.4464	88.17
233	1608000967	2018-09-28	—	127.75	103.2528	92.19	88.17	98.7504	83.4464	88.17
233	1608001135	2018-10-28	—	139.9	113.0864	100.97	96.56	108.1472	91.3839	96.56
233	1708000119	2019-01-28	—	139.9	113.0864	100.97	96.56	108.1472	91.3839	96.56
233	1708000374	2019-03-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708000906	2019-06-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001234	2019-08-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001237	2019-08-28	—	139.9	111.9216	99.93	89.94	100.7328	89.9375	89.94
233	1708001712	2019-11-28	—	153.2	122.5616	109.43	98.49	110.3088	98.4911	98.49
233	2513000305	2027-11-30	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2513000135	2027-08-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	2508000734	2027-05-31	—	271.03	216.83	206.5	185.85	195.14	185.85	185.85
233	#6733013A	2008-09-28	—	87.5	70.5488	62.99	60.48	67.7376	56.1607	60.48
233	#6733014A	2008-10-28	—	87.5	70.6608	63.09	60.57	67.8384	56.2411	60.57

9,651–9,700 of 10,000+ rows