dbo.tbl_Batch_History

7,81,051 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
8	PK0613	2025-02-28	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PK0624	2026-02-28	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PL0424	2026-03-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PL0473	2025-03-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PL0483	2025-03-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PL0512	2024-03-31	—	252.5	202	180.36	162.32	181.8	162.32	180.36
8	PN0343	2025-04-30	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0353	2025-04-30	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0441	2023-04-30	—	252.5	202	180.36	162.32	181.8	162.32	180.36
8	PN0473	2025-05-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0494	2026-04-30	—	334	267.2	238.57	214.71	240.48	214.71	238.58
8	PN0504	2026-04-30	—	334	267.2	238.57	214.71	240.48	214.71	238.58
8	PN0522	2024-04-30	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0384	2026-05-31	—	334	267.2	238.57	214.71	240.48	214.71	214.71
8	PP0402	2024-05-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0422	2024-05-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0483	2025-05-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	GPO229	2011-05-28	—	87.6	70.7392	63.16	60.88	68.1856	56.5357	60.88
8	GPO248	2020-05-28	—	192	153.5968	137.14	123.43	138.2416	123.4286	123.43
8	GU0015	2017-01-28	—	136	109.8384	98.07	93.59	104.8208	87.7411	93.59
8	HJ0103	2015-01-28	—	113	91.2688	81.49	77.75	87.08	72.8929	77.75
8	JA0106	2007-06-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JA0124	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JA0163	2004-06-28	—	49	41.16	36.75	35.44	39.6928	34.4911	35.44
8	JA0364	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JA0404	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JB0016	2007-07-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JB0023	2004-07-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JB0026	2007-07-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JB0084	2005-07-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0025	2006-08-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
8	JC0044	2005-08-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0054	2005-08-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0086	2007-08-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JC0096	2007-08-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JD0064	2005-09-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JD0163	2004-09-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JD0182.	2003-09-28	—	49	41.5072	37.06	35.78	40.0736	34.8214	35.78
8	JE0064	2005-10-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JE0074	2005-10-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JE0092.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
8	JE0115	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0125	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0142.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
8	JE0263	2004-10-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JE0325	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0345	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0395	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0415	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JF0094	2005-11-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22

51–100 of 10,000+ rows

ItemDetailId	BatchNo	ExpDate	MfgDate	MRP	SPTR	PTR	CP	SCP	NPR	WIP
8	PK0613	2025-02-28	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PK0624	2026-02-28	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PL0424	2026-03-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PL0473	2025-03-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PL0483	2025-03-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PL0512	2024-03-31	—	252.5	202	180.36	162.32	181.8	162.32	180.36
8	PN0343	2025-04-30	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0353	2025-04-30	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0441	2023-04-30	—	252.5	202	180.36	162.32	181.8	162.32	180.36
8	PN0473	2025-05-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	PN0494	2026-04-30	—	334	267.2	238.57	214.71	240.48	214.71	238.58
8	PN0504	2026-04-30	—	334	267.2	238.57	214.71	240.48	214.71	238.58
8	PN0522	2024-04-30	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0384	2026-05-31	—	334	267.2	238.57	214.71	240.48	214.71	214.71
8	PP0402	2024-05-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0422	2024-05-31	—	277	221.6	197.86	178.07	199.44	178.07	197.86
8	PP0483	2025-05-31	—	304	243.21	217.15	195.43	218.88	195.43	217.15
8	GPO229	2011-05-28	—	87.6	70.7392	63.16	60.88	68.1856	56.5357	60.88
8	GPO248	2020-05-28	—	192	153.5968	137.14	123.43	138.2416	123.4286	123.43
8	GU0015	2017-01-28	—	136	109.8384	98.07	93.59	104.8208	87.7411	93.59
8	HJ0103	2015-01-28	—	113	91.2688	81.49	77.75	87.08	72.8929	77.75
8	JA0106	2007-06-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JA0124	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JA0163	2004-06-28	—	49	41.16	36.75	35.44	39.6928	34.4911	35.44
8	JA0364	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JA0404	2005-06-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JB0016	2007-07-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JB0023	2004-07-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JB0026	2007-07-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JB0084	2005-07-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0025	2006-08-28	—	58.3	48.9776	43.73	42.12	47.1744	39.1071	42.12
8	JC0044	2005-08-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0054	2005-08-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JC0086	2007-08-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JC0096	2007-08-28	—	63.15	53.0432	47.36	45.61	51.0832	42.3482	45.61
8	JD0064	2005-09-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JD0163	2004-09-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JD0182.	2003-09-28	—	49	41.5072	37.06	35.78	40.0736	34.8214	35.78
8	JE0064	2005-10-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JE0074	2005-10-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22
8	JE0092.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
8	JE0115	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0125	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0142.	2003-10-28	—	49	41.5632	37.11	35.83	40.1296	34.8661	35.83
8	JE0263	2004-10-28	—	49	41.16	36.75	35.41	39.6592	34.4643	35.41
8	JE0325	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0345	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0395	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JE0415	2006-10-28	—	59.5	49.9744	44.62	42.98	48.1376	39.9107	42.98
8	JF0094	2005-11-28	—	52.9	44.4304	39.67	38.22	42.8064	37.1964	38.22

51–100 of 10,000+ rows