dbo.tbl_ImportPI_Dtl

458 rows · 37 columns

ready

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

LedId_Party	Party_InvNo	Party_ItemNo	ItemDetailId	BatchNo	ExpDate	Qty	Free	Rate	GrsAmt	STPer
14107	1263709922	10	26463	XCR126003	—	20	0	79.88	1,597.6	2.5
14107	1263709922	11	26537	XTR826003	—	30	0	187.97	5,639.1	2.5
14107	1263709922	12	26464	YTR626006	—	40	0	132.98	5,319.2	2.5
14107	1263709922	13	26434	YTR926002	—	10	0	285.2	2852	2.5
14107	1263709922	14	31153	YTRN25011	—	5	0	216.05	1,080.25	2.5
14107	1263709922	15	31153	YTRN25012	—	55	0	216.05	11,882.75	2.5
14107	1263709922	16	26437	XCRZ25008	—	2	0	280.93	561.86	2.5
14107	1263709922	17	26437	XCRZ25012	—	18	0	308.87	5,559.66	2.5
14107	1263709922	18	22303	YSUX26001	—	26	0	278.88	7,250.88	2.5
14107	1263709922	19	22303	YSUX26011	—	4	6	278.88	1,115.52	2.5
14107	1263709922	20	21322	XSOM26026	—	100	30	45.15	4515	2.5
14107	1263709922	21	21323	XS6S26008	—	20	6	61.04	1,220.8	2.5
14107	1263709922	22	25647	YSPL26004	—	36	0	102.86	3,702.96	2.5
14107	1263709922	23	20395	XSRS26043	—	100	20	125.65	12565	2.5
14107	1263709922	24	20396	XSRU26011	—	42	8	37.69	1,582.98	2.5
14107	1263709922	25	24368	YT1J25003	—	10	0	196.52	1,965.2	2.5
14107	1263709922	26	27344	XSZE26001	—	20	6	104.91	2,098.2	2.5
14107	1263709922	27	20417	XTB126005	—	60	0	65.54	3,932.4	2.5
14107	1263709922	28	20424	KCI26001	—	60	0	117.94	7,076.4	2.5
14107	1263709922	29	20425	K6C26001	—	36	0	104.17	3,750.12	2.5
14107	1263709922	30	30741	YTCW26008	—	80	0	207.58	16,606.4	2.5
14107	1263709922	31	20430	K1T26002	—	30	0	182.82	5,484.6	2.5
14107	1263709922	32	20431	KCT26001	—	21	0	175.76	3,690.96	2.5
14107	1263709922	33	23321	AC926011	—	720	0	165.45	119124	2.5
14107	1263709922	34	30868	XT2426002	—	50	0	227.97	11,398.5	2.5
14107	1263709922	35	30869	A4T26011	—	300	0	200.45	60135	2.5
14107	1263709922	36	30871	XTCU26006	—	30	0	204.37	6,131.1	2.5
14107	1263709922	37	31274	ABZ26008	—	27	3	206.42	5,573.34	2.5
14107	1263709922	38	25055	XP6G25009	—	28	0	258.34	7,233.52	2.5
14107	1263709922	39	28944	BM826129	—	910	0	24.75	22,522.5	2.5
14107	1263709922	40	20357	PGX6010	—	80	0	58.09	4,647.2	2.5
14107	1263709922	41	30742	G6E26014	—	60	0	87.62	5,257.2	2.5
14107	1263709922	42	31006	PGD6008	—	100	0	105.03	10503	2.5
14107	1263709922	43	32577	AOD26004	—	27	3	105.94	2,860.38	2.5
14107	1263709922	44	20362	XOJM26010	—	90	10	130.58	11,752.2	2.5
14107	1263709922	45	20363	ASM26034	—	200	0	41.87	8374	2.5
14107	1263709922	46	20390	BR626026	—	324	36	67.05	21,724.2	2.5
14107	1263709922	47	30424	XTSN26003	—	20	0	91.9	1838	2.5
14107	1263709922	48	32697	BS026003	—	20	2	234.39	4,687.8	2.5
14107	1263709922	1	25260	XTAG26001	—	24	0	118.36	2,840.64	2.5
14107	1263709922	2	25260	XTAG26002	—	15	0	118.36	1,775.4	2.5
14852	MH0126521443	1	27544	CTA26030	2027-12-31	50	0	256.5	12825	2.5
14852	MH0126521443	2	24953	26S3GTB210	2028-06-30	300	0	103.89	31167	2.5
14852	MH0126521443	3	20166	K2601656	2028-05-31	450	0	80.57	36,256.5	2.5
14852	MH0126521443	4	20166	K2601656	2028-05-31	50	0	80.57	4,028.5	0
14852	MH0126521443	5	20159	2600926-1	2027-10-31	50	0	118.04	5902	2.5
14852	MH0126521443	6	29588	M2606748	2029-06-30	204	0	675.02	1,37,704.08	2.5
14852	MH0126521442	1	27404	L1526431	2028-08-31	100	0	514.29	51429	2.5
16014	R/9018	1	22695	FHZ0052	2023-12-31	10	0	265.57	2,655.7	6
16014	R/9018	2	19198	GKD0199A	2024-05-31	10	0	177.04	1,770.4	6

301–350 of 458 rows

LedId_Party	Party_InvNo	Party_ItemNo	ItemDetailId	BatchNo	ExpDate	Qty	Free	Rate	GrsAmt	STPer
14107	1263709922	10	26463	XCR126003	—	20	0	79.88	1,597.6	2.5
14107	1263709922	11	26537	XTR826003	—	30	0	187.97	5,639.1	2.5
14107	1263709922	12	26464	YTR626006	—	40	0	132.98	5,319.2	2.5
14107	1263709922	13	26434	YTR926002	—	10	0	285.2	2852	2.5
14107	1263709922	14	31153	YTRN25011	—	5	0	216.05	1,080.25	2.5
14107	1263709922	15	31153	YTRN25012	—	55	0	216.05	11,882.75	2.5
14107	1263709922	16	26437	XCRZ25008	—	2	0	280.93	561.86	2.5
14107	1263709922	17	26437	XCRZ25012	—	18	0	308.87	5,559.66	2.5
14107	1263709922	18	22303	YSUX26001	—	26	0	278.88	7,250.88	2.5
14107	1263709922	19	22303	YSUX26011	—	4	6	278.88	1,115.52	2.5
14107	1263709922	20	21322	XSOM26026	—	100	30	45.15	4515	2.5
14107	1263709922	21	21323	XS6S26008	—	20	6	61.04	1,220.8	2.5
14107	1263709922	22	25647	YSPL26004	—	36	0	102.86	3,702.96	2.5
14107	1263709922	23	20395	XSRS26043	—	100	20	125.65	12565	2.5
14107	1263709922	24	20396	XSRU26011	—	42	8	37.69	1,582.98	2.5
14107	1263709922	25	24368	YT1J25003	—	10	0	196.52	1,965.2	2.5
14107	1263709922	26	27344	XSZE26001	—	20	6	104.91	2,098.2	2.5
14107	1263709922	27	20417	XTB126005	—	60	0	65.54	3,932.4	2.5
14107	1263709922	28	20424	KCI26001	—	60	0	117.94	7,076.4	2.5
14107	1263709922	29	20425	K6C26001	—	36	0	104.17	3,750.12	2.5
14107	1263709922	30	30741	YTCW26008	—	80	0	207.58	16,606.4	2.5
14107	1263709922	31	20430	K1T26002	—	30	0	182.82	5,484.6	2.5
14107	1263709922	32	20431	KCT26001	—	21	0	175.76	3,690.96	2.5
14107	1263709922	33	23321	AC926011	—	720	0	165.45	119124	2.5
14107	1263709922	34	30868	XT2426002	—	50	0	227.97	11,398.5	2.5
14107	1263709922	35	30869	A4T26011	—	300	0	200.45	60135	2.5
14107	1263709922	36	30871	XTCU26006	—	30	0	204.37	6,131.1	2.5
14107	1263709922	37	31274	ABZ26008	—	27	3	206.42	5,573.34	2.5
14107	1263709922	38	25055	XP6G25009	—	28	0	258.34	7,233.52	2.5
14107	1263709922	39	28944	BM826129	—	910	0	24.75	22,522.5	2.5
14107	1263709922	40	20357	PGX6010	—	80	0	58.09	4,647.2	2.5
14107	1263709922	41	30742	G6E26014	—	60	0	87.62	5,257.2	2.5
14107	1263709922	42	31006	PGD6008	—	100	0	105.03	10503	2.5
14107	1263709922	43	32577	AOD26004	—	27	3	105.94	2,860.38	2.5
14107	1263709922	44	20362	XOJM26010	—	90	10	130.58	11,752.2	2.5
14107	1263709922	45	20363	ASM26034	—	200	0	41.87	8374	2.5
14107	1263709922	46	20390	BR626026	—	324	36	67.05	21,724.2	2.5
14107	1263709922	47	30424	XTSN26003	—	20	0	91.9	1838	2.5
14107	1263709922	48	32697	BS026003	—	20	2	234.39	4,687.8	2.5
14107	1263709922	1	25260	XTAG26001	—	24	0	118.36	2,840.64	2.5
14107	1263709922	2	25260	XTAG26002	—	15	0	118.36	1,775.4	2.5
14852	MH0126521443	1	27544	CTA26030	2027-12-31	50	0	256.5	12825	2.5
14852	MH0126521443	2	24953	26S3GTB210	2028-06-30	300	0	103.89	31167	2.5
14852	MH0126521443	3	20166	K2601656	2028-05-31	450	0	80.57	36,256.5	2.5
14852	MH0126521443	4	20166	K2601656	2028-05-31	50	0	80.57	4,028.5	0
14852	MH0126521443	5	20159	2600926-1	2027-10-31	50	0	118.04	5902	2.5
14852	MH0126521443	6	29588	M2606748	2029-06-30	204	0	675.02	1,37,704.08	2.5
14852	MH0126521442	1	27404	L1526431	2028-08-31	100	0	514.29	51429	2.5
16014	R/9018	1	22695	FHZ0052	2023-12-31	10	0	265.57	2,655.7	6
16014	R/9018	2	19198	GKD0199A	2024-05-31	10	0	177.04	1,770.4	6

301–350 of 458 rows