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
13846	0201135947	1	20477	10T0043	2022-09-30	50	0	72.64	3632	6
13846	0201135947	2	20478	D2050006	2022-09-30	300	0	78.3	23490	6
14107	1263702737	1	23111	XTAK26001	—	21	0	83.51	1,753.71	2.5
14107	1263702737	2	25049	YTAJ26002	—	10	0	138.09	1,380.9	2.5
14107	1263702737	3	20332	ABJ26001	—	30	0	119.85	3,595.5	2.5
14107	1263702737	4	24985	XT1025006	—	10	0	48.28	482.8	2.5
14107	1263702737	5	20439	XT4Y25007	—	30	0	95.62	2,868.6	2.5
14107	1263702737	6	20441	YT4M26001	—	15	0	136.11	2,041.65	2.5
14107	1263702737	7	31767	CNE26002	—	50	0	22.53	1,126.5	2.5
14107	1263702737	8	31085	KCG25016	—	200	0	79.83	15966	2.5
14107	1263702737	9	30978	KKG26003	—	200	0	109.47	21894	2.5
14107	1263702737	10	26441	A1R25008	—	20	0	152.52	3,050.4	2.5
14107	1263702737	11	26537	XTR826002	—	10	0	170.97	1,709.7	2.5
14107	1263702737	12	26464	YTR626002	—	60	0	120.96	7,257.6	2.5
14107	1263702737	13	31153	YTRN25011	—	40	0	216.05	8642	2.5
14107	1263702737	14	26437	XCRZ25012	—	20	0	308.87	6,177.4	2.5
14107	1263702737	15	21362	YSUX25021	—	20	0	160.09	3,201.8	2.5
14107	1263702737	16	21323	XS6S26002	—	20	6	61.04	1,220.8	2.5
14107	1263702737	17	20396	XSRU26004	—	21	4	37.69	791.49	2.5
14107	1263702737	18	30780	XP7425012	—	100	20	421.63	42163	2.5
14107	1263702737	19	20417	XTB126002	—	30	0	59.61	1,788.3	2.5
14107	1263702737	20	20418	XTB326001	—	24	0	87.99	2,111.76	2.5
14107	1263702737	21	29023	XTBC25002	—	10	0	88.74	887.4	2.5
14107	1263702737	22	20425	K6C25003	—	15	0	104.17	1,562.55	2.5
14107	1263702737	23	30716	XT2526001	—	80	0	169.8	13584	2.5
14107	1263702737	24	30741	YTCW26003	—	40	0	207.58	8,303.2	2.5
14107	1263702737	25	20431	KCT26001	—	15	0	175.76	2,636.4	2.5
14107	1263702737	26	27364	XTDS25005	—	10	0	147.65	1,476.5	2.5
14107	1263702737	27	23321	AC926002	—	3000	0	165.45	496350	2.5
14107	1263702737	28	28211	KWC26003	—	240	0	250.8	60192	2.5
14107	1263702737	29	30868	XT2426002	—	40	0	227.97	9,118.8	2.5
14107	1263702737	30	30869	K4T26012	—	300	0	200.45	60135	2.5
14107	1263702737	31	30871	XTCU26003	—	20	0	204.37	4,087.4	2.5
14107	1263702737	32	31750	YO7A26003	—	100	0	129.67	12967	2.5
14107	1263702737	33	31274	ABZ25038	—	54	6	206.42	11,146.68	2.5
14107	1263702737	34	28944	BM826046	—	910	0	24.59	22,376.9	2.5
14107	1263702737	35	30742	G6E26001	—	30	0	87.62	2,628.6	2.5
14107	1263702737	36	31006	PGD6003	—	60	0	105.03	6,301.8	2.5
14107	1263702737	37	20362	XOJM26002	—	90	10	130.58	11,752.2	2.5
14107	1263702737	38	30624	ZSRF26011	—	36	4	162.57	5,852.52	2.5
14107	1263702737	39	20389	BR326022	—	1620	180	34.81	56,392.2	2.5
14107	1263702737	40	20390	BR626002	—	324	36	67.05	21,724.2	2.5
14107	1263702737	41	30424	XTSN25007	—	30	0	83.59	2,507.7	2.5
14107	1263709922	3	23111	XTAK26001	—	15	0	83.51	1,252.65	2.5
14107	1263709922	4	20441	YT4M25002	—	15	0	136.11	2,041.65	2.5
14107	1263709922	5	26438	A2R25014	—	1	0	278.55	278.55	2.5
14107	1263709922	6	26438	A2R26001	—	29	0	278.55	8,077.95	2.5
14107	1263709922	7	26441	A1R25002	—	5	0	138.72	693.6	2.5
14107	1263709922	8	26441	A1R25008	—	30	0	152.52	4,575.6	2.5
14107	1263709922	9	26441	A1R26001	—	5	0	152.52	762.6	2.5

251–300 of 458 rows

LedId_Party	Party_InvNo	Party_ItemNo	ItemDetailId	BatchNo	ExpDate	Qty	Free	Rate	GrsAmt	STPer
13846	0201135947	1	20477	10T0043	2022-09-30	50	0	72.64	3632	6
13846	0201135947	2	20478	D2050006	2022-09-30	300	0	78.3	23490	6
14107	1263702737	1	23111	XTAK26001	—	21	0	83.51	1,753.71	2.5
14107	1263702737	2	25049	YTAJ26002	—	10	0	138.09	1,380.9	2.5
14107	1263702737	3	20332	ABJ26001	—	30	0	119.85	3,595.5	2.5
14107	1263702737	4	24985	XT1025006	—	10	0	48.28	482.8	2.5
14107	1263702737	5	20439	XT4Y25007	—	30	0	95.62	2,868.6	2.5
14107	1263702737	6	20441	YT4M26001	—	15	0	136.11	2,041.65	2.5
14107	1263702737	7	31767	CNE26002	—	50	0	22.53	1,126.5	2.5
14107	1263702737	8	31085	KCG25016	—	200	0	79.83	15966	2.5
14107	1263702737	9	30978	KKG26003	—	200	0	109.47	21894	2.5
14107	1263702737	10	26441	A1R25008	—	20	0	152.52	3,050.4	2.5
14107	1263702737	11	26537	XTR826002	—	10	0	170.97	1,709.7	2.5
14107	1263702737	12	26464	YTR626002	—	60	0	120.96	7,257.6	2.5
14107	1263702737	13	31153	YTRN25011	—	40	0	216.05	8642	2.5
14107	1263702737	14	26437	XCRZ25012	—	20	0	308.87	6,177.4	2.5
14107	1263702737	15	21362	YSUX25021	—	20	0	160.09	3,201.8	2.5
14107	1263702737	16	21323	XS6S26002	—	20	6	61.04	1,220.8	2.5
14107	1263702737	17	20396	XSRU26004	—	21	4	37.69	791.49	2.5
14107	1263702737	18	30780	XP7425012	—	100	20	421.63	42163	2.5
14107	1263702737	19	20417	XTB126002	—	30	0	59.61	1,788.3	2.5
14107	1263702737	20	20418	XTB326001	—	24	0	87.99	2,111.76	2.5
14107	1263702737	21	29023	XTBC25002	—	10	0	88.74	887.4	2.5
14107	1263702737	22	20425	K6C25003	—	15	0	104.17	1,562.55	2.5
14107	1263702737	23	30716	XT2526001	—	80	0	169.8	13584	2.5
14107	1263702737	24	30741	YTCW26003	—	40	0	207.58	8,303.2	2.5
14107	1263702737	25	20431	KCT26001	—	15	0	175.76	2,636.4	2.5
14107	1263702737	26	27364	XTDS25005	—	10	0	147.65	1,476.5	2.5
14107	1263702737	27	23321	AC926002	—	3000	0	165.45	496350	2.5
14107	1263702737	28	28211	KWC26003	—	240	0	250.8	60192	2.5
14107	1263702737	29	30868	XT2426002	—	40	0	227.97	9,118.8	2.5
14107	1263702737	30	30869	K4T26012	—	300	0	200.45	60135	2.5
14107	1263702737	31	30871	XTCU26003	—	20	0	204.37	4,087.4	2.5
14107	1263702737	32	31750	YO7A26003	—	100	0	129.67	12967	2.5
14107	1263702737	33	31274	ABZ25038	—	54	6	206.42	11,146.68	2.5
14107	1263702737	34	28944	BM826046	—	910	0	24.59	22,376.9	2.5
14107	1263702737	35	30742	G6E26001	—	30	0	87.62	2,628.6	2.5
14107	1263702737	36	31006	PGD6003	—	60	0	105.03	6,301.8	2.5
14107	1263702737	37	20362	XOJM26002	—	90	10	130.58	11,752.2	2.5
14107	1263702737	38	30624	ZSRF26011	—	36	4	162.57	5,852.52	2.5
14107	1263702737	39	20389	BR326022	—	1620	180	34.81	56,392.2	2.5
14107	1263702737	40	20390	BR626002	—	324	36	67.05	21,724.2	2.5
14107	1263702737	41	30424	XTSN25007	—	30	0	83.59	2,507.7	2.5
14107	1263709922	3	23111	XTAK26001	—	15	0	83.51	1,252.65	2.5
14107	1263709922	4	20441	YT4M25002	—	15	0	136.11	2,041.65	2.5
14107	1263709922	5	26438	A2R25014	—	1	0	278.55	278.55	2.5
14107	1263709922	6	26438	A2R26001	—	29	0	278.55	8,077.95	2.5
14107	1263709922	7	26441	A1R25002	—	5	0	138.72	693.6	2.5
14107	1263709922	8	26441	A1R25008	—	30	0	152.52	4,575.6	2.5
14107	1263709922	9	26441	A1R26001	—	5	0	152.52	762.6	2.5

251–300 of 458 rows