home *** CD-ROM | disk | FTP | other *** search

---

/ PC World 1999 December / PCWorld_1999-12_cd.bin / Software / Servis / BS1SB / _SETUP.1 / ARInv.DB (.txt)

< prev

next >

Wrap

Paradox Database Table  |  1999-10-08  |  16KB  |  61 rows

---

#	ARInvoiceID,I,4	CustomerID,I,4	InvoiceNo,A,10	OriginalInvNo,A,10	Description,A,60	InvoiceDate,D,4	InvoiceAmount,$,8	PaidAmount,$,8	DiscTakenAmount,$,8	WriteOffAmount,$,8	Owing,$,8	DiscPC,N,8	DiscDays,S,2	NetDays,S,2	COD,L,1	PurchaseOrderNo,A,10	GLPeriod,S,2	GLYear,S,2	Printed,L,1	Posted,L,1	Tax1ID,I,4	Tax2ID,I,4	Tax1Code,A,1	Tax2Code,A,1	Tax1Rate,N,8	Tax2Rate,N,8	TaxableAmount1,$,8	TaxableAmount2,$,8	TaxableAmount3,$,8	TaxableAmtCode1,A,1	TaxableAmtCode2,A,1	TaxableAmtCode3,A,1
1	1	10001	10002			1999-01-07	746.700000	746.700000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	1	2	G	P	7.000000	7.000000	655.000000	655.000000	655.000000	P	G	H
2	2	10004	10003			1999-01-08	224.250000	224.250000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	3	0	H		15.000000	0.000000	195.000000	195.000000	195.000000	P	G	H
3	3	10003	10004			1999-01-08	224.020000	224.020000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	1	2	G	P	7.000000	7.000000	196.500000	196.500000	196.500000	P	G	H
4	5	10000	10006			1999-01-12	3595.270000	3595.270000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	1	2	G	P	7.000000	7.000000	3153.750000	3153.750000	3153.750000	P	G	H
5	7	10004	10008			1999-01-28	517.500000	517.500000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	3	0	H		15.000000	0.000000	450.000000	450.000000	450.000000	P	G	H
6	8	10002	10009			1999-01-19	773.700000	732.990000	40.710000	0.000000	0.000000	2.000000	10	30	0		1	1999	1	1	0	0			0.000000	0.000000	773.700000	773.700000	773.700000	G	H	P
7	11	10004	10012			1999-02-05	184.000000	184.000000	0.000000	0.000000	0.000000	0.000000	0	0	0		2	1999	1	1	3	0	H		15.000000	0.000000	160.000000	160.000000	160.000000	P	G	H
8	14	10001	10015			1999-02-03	3611.250000	3611.250000	0.000000	0.000000	0.000000	0.000000	0	0	0		2	1999	1	1	1	2	G	P	7.000000	7.000000	3375.000000	3375.000000		G	H
9	15	10003	10016			1999-01-29	5216.250000	5216.250000	0.000000	0.000000	0.000000	0.000000	0	0	0		1	1999	1	1	1	2	G	P	7.000000	7.000000	4875.000000	4875.000000		G	H
10	16	10004	10017			1999-02-26	10781.250000	10781.250000	0.000000	0.000000	0.000000	0.000000	0	0	0		2	1999	1	1	3	0	H		15.000000	0.000000	9375.000000	9375.000000		G	H
11	17	10002	10018			1999-02-23	2449.650000	2449.650000	0.000000	0.000000	0.000000	2.000000	10	30	0		2	1999	1	1	0	0			0.000000	0.000000	639.450000	2449.650000	2449.650000	P	G	H
12	18	10000	10019			1999-02-06	2892.760000	2892.760000	0.000000	0.000000	0.000000	0.000000	0	0	0		2	1999	1	1	1	2	G	P	7.000000	7.000000	2537.500000	2537.500000	2537.500000	P	G	H
13	19	10003	10020			1999-02-10	3769.200000	3769.000000	0.000000	0.200000	0.000000	0.000000	0	0	0		2	1999	1	1	1	2	G	P	7.000000	7.000000	2180.000000	3380.000000	3380.000000	P	G	H
14	20	10003	10021			1999-02-24	3611.250000	3611.250000	0.000000	0.000000	0.000000	0.000000	0	0	0		2	1999	1	1	1	2	G	P	7.000000	7.000000	3375.000000	3375.000000		G	H
15	30	10000	10031			1999-03-09	1754.170000	1754.170000	0.000000	0.000000	0.000000	0.000000	0	30	0		3	1999	1	1	1	2	G	P	7.000000	7.000000	1538.750000	1538.750000	1538.750000	P	G	H
16	31	10001	10032			1999-03-03	2332.600000	2332.600000	0.000000	0.000000	0.000000	0.000000	0	30	0		3	1999	1	1	1	0	G		7.000000	0.000000	2180.000000	2180.000000	680.000000	G	H	P
17	32	10002	10033			1999-03-26	2103.250000	2042.250000	61.000000	0.000000	0.000000	2.000000	10	30	0		3	1999	1	1	0	0			0.000000	0.000000	2103.250000	2103.250000	2103.250000	P	G	H
18	33	10004	10034			1999-03-10	1293.750000	1293.750000	0.000000	0.000000	0.000000	0.000000	0	30	0		3	1999	1	1	3	0	H		15.000000	0.000000	1125.000000	1125.000000		G	H
19	34	10017	10035			1999-03-15	1490.600000	1490.600000	0.000000	0.000000	0.000000	0.000000	0	0	0		3	1999	1	1	0	0			0.000000	0.000000	1490.600000	1490.600000	1490.600000	P	G	H
20	35	10017	10036			1999-04-08	2507.000000	2507.000000	0.000000	0.000000	0.000000	0.000000	0	0	0		4	1999	1	1	0	0			0.000000	0.000000	2507.000000	2507.000000	2507.000000	P	G	H
21	36	10002	10037			1999-04-11	11300.000000	11300.000000	0.000000	0.000000	0.000000	2.000000	10	30	0		4	1999	1	1	0	0			0.000000	0.000000	11300.000000	11300.000000	11300.000000	P	G	H
22	37	10000	10038			1999-04-11	1194.160000	1194.160000	0.000000	0.000000	0.000000	0.000000	0	30	0		4	1999	1	1	1	2	G	P	7.000000	7.000000	1047.500000	1047.500000	1047.500000	P	G	H
23	38	10003	10039			1999-04-21	3420.000000	3420.000000	0.000000	0.000000	0.000000	0.000000	0	30	0		4	1999	1	1	1	2	G	P	7.000000	7.000000	3000.000000	3000.000000	3000.000000	P	G	H
24	39	10001	10040			1999-04-11	401.250000	401.250000	0.000000	0.000000	0.000000	0.000000	0	30	0		4	1999	1	1	1	0	G		7.000000	0.000000	375.000000	375.000000	375.000000	P	G	H
25	40	10017	10041			1999-04-27	5060.000000	5060.000000	0.000000	0.000000	0.000000	0.000000	0	0	0		4	1999	1	1	0	0			0.000000	0.000000	5060.000000	5060.000000	5060.000000	P	G	H
26	41	10002	10042			1999-04-29	2587.500000	2587.500000	0.000000	0.000000	0.000000	2.000000	10	30	0		4	1999	1	1	0	0			0.000000	0.000000	1293.750000	2587.500000	2587.500000	P	G	H
27	42	10000	10043			1999-05-03	3904.500000	3904.500000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	2	G	P	7.000000	7.000000	3425.000000	3425.000000	3425.000000	P	G	H
28	43	10001	10044			1999-05-03	2093.190000	2093.190000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	0	G		7.000000	0.000000	1956.250000	1956.250000	1956.250000	P	G	H
29	44	10003	10045			1999-05-06	3505.500000	3505.500000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	2	G	P	7.000000	7.000000	3075.000000	3075.000000	3075.000000	P	G	H
30	45	10004	10046			1999-05-11	971.870000	971.870000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	3	0	H		15.000000	0.000000	845.100000	845.100000	845.100000	P	G	H
31	46	10002	10047			1999-05-10	2569.000000	2569.000000	0.000000	0.000000	0.000000	2.000000	10	30	0		5	1999	1	1	0	0			0.000000	0.000000	2306.500000	2569.000000	2569.000000	P	G	H
32	47	10003	10048			1999-05-14	1282.500000	1282.500000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	2	G	P	7.000000	7.000000	1125.000000	1125.000000	1125.000000	P	G	H
33	48	10003	10049			1999-05-25	2462.400000	2462.400000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	2	G	P	7.000000	7.000000	2160.000000	2160.000000	2160.000000	P	G	H
34	49	10017	10050			1999-05-19	10179.440000	10179.440000	0.000000	0.000000	0.000000	0.000000	0	0	0		5	1999	1	1	0	0			0.000000	0.000000	10179.440000	10179.440000	10179.440000	P	G	H
35	50	10000	10051			1999-05-28	1319.560000	1319.560000	0.000000	0.000000	0.000000	0.000000	0	30	0		5	1999	1	1	1	2	G	P	7.000000	7.000000	1157.500000	1157.500000	1157.500000	P	G	H
36	51	10017	10052		Credit	1999-05-19	-7755.200000	-7755.200000	0.000000	0.000000	0.000000	0.000000	0	0	0		5	1999	1	1	0	0			0.000000	0.000000	-7755.200000	-7755.200000	-7755.200000	P	G	H
37	52	10004	10053			1999-06-03	1865.880000	1865.880000	0.000000	0.000000	0.000000	0.000000	0	30	0		6	1999	1	1	3	0	H		15.000000	0.000000	1462.500000	1622.500000	1622.500000	P	G	H
38	53	10004	10054			1999-06-17	1417.380000	1417.380000	0.000000	0.000000	0.000000	0.000000	0	30	0		6	1999	1	1	3	0	H		15.000000	0.000000	1192.500000	1232.500000	1232.500000	P	G	H
39	54	10003	10055			1999-06-21	2160.300000	2160.300000	0.000000	0.000000	0.000000	0.000000	0	30	0		6	1999	1	1	1	2	G	P	7.000000	7.000000	1895.000000	1895.000000	1895.000000	P	G	H
40	55	10001	10056			1999-06-28	2677.680000	2677.680000	0.000000	0.000000	0.000000	0.000000	0	30	0		6	1999	1	1	1	0	G		7.000000	0.000000	2502.500000	2502.500000	2502.500000	P	G	H
41	56	10000	10057			1999-07-01	10505.540000	10505.540000	0.000000	0.000000	0.000000	0.000000	0	30	0		7	1999	1	1	1	2	G	P	7.000000	7.000000	9461.000000	9461.000000	5461.000000	G	H	P
42	57	10001	10058			1999-07-02	10202.450000	10202.450000	0.000000	0.000000	0.000000	0.000000	0	30	0		7	1999	1	1	1	0	G		7.000000	0.000000	9535.000000	9535.000000	9535.000000	P	G	H
43	58	10017	10059			1999-07-12	3317.500000	3317.500000	0.000000	0.000000	0.000000	0.000000	0	0	0		7	1999	1	1	0	0			0.000000	0.000000	3317.500000	3317.500000	3317.500000	P	G	H
44	59	10004	10060			1999-07-20	8037.640000	8037.640000	0.000000	0.000000	0.000000	0.000000	0	30	0		7	1999	1	1	3	0	H		15.000000	0.000000	6989.250000	6989.250000	6989.250000	P	G	H
45	60	10001	10061			1999-07-06	222.030000	222.030000	0.000000	0.000000	0.000000	0.000000	0	30	0		7	1999	1	1	1	0	G		7.000000	0.000000	207.500000	207.500000	207.500000	P	G	H
46	61	10000	10062			1999-08-03	11756.260000	11756.260000	0.000000	0.000000	0.000000	0.000000	0	30	0		8	1999	1	1	1	2	G	P	7.000000	7.000000	10312.500000	10312.500000	10312.500000	P	G	H
47	62	10017	10063			1999-08-16	9822.500000				9822.500000	0.000000	0	0	0		8	1999	1	1	0	0			0.000000	0.000000	9822.500000	9822.500000	9822.500000	P	G	H
48	63	10003	10064			1999-08-24	1115.210000				1115.210000	0.000000	0	30	0		8	1999	1	1	1	2	G	P	7.000000	7.000000	978.250000	978.250000	978.250000	P	G	H
49	64	10004	10065			1999-08-20	1104.000000	1104.000000	0.000000	0.000000	0.000000	0.000000	0	30	0		8	1999	1	1	3	0	H		15.000000	0.000000	960.000000	960.000000		G	H
50	65	10002	10066			1999-08-19	1600.600000	1600.600000	0.000000	0.000000	0.000000	2.000000	10	30	0		8	1999	1	1	0	0			0.000000	0.000000	1600.600000	1600.600000	1600.600000	P	G	H
51	66	10002	10067			1999-09-06	1347.500000				1347.500000	2.000000	10	30	0		9	1999	1	1	0	0			0.000000	0.000000	1347.500000	1347.500000	1347.500000	P	G	H
52	67	10000	10068			1999-09-14	2038.760000	2038.760000	0.000000	0.000000	0.000000	0.000000	0	30	0		9	1999	1	1	1	2	G	P	7.000000	7.000000	1037.500000	1837.500000	1837.500000	P	G	H
53	68	10003	10069			1999-09-17	371.930000				371.930000	0.000000	0	30	0		9	1999	1	1	1	2	G	P	7.000000	7.000000	326.250000	326.250000	326.250000	P	G	H
54	69	10001	10070			1999-09-22	638.040000				638.040000	0.000000	0	30	0		9	1999	1	1	1	0	G		7.000000	0.000000	596.300000	596.300000	596.300000	P	G	H
55	70	10004	10071			1999-09-27	460.000000				460.000000	0.000000	0	30	0		9	1999	1	1	3	0	H		15.000000	0.000000	400.000000	400.000000		G	H
56	71	10002	10072			1999-09-29	4150.000000				4150.000000	2.000000	10	30	0		9	1999	1	1	0	0			0.000000	0.000000	4150.000000	4150.000000	4150.000000	P	G	H
57	72	10017	10073			1999-09-30	2120.800000				2120.800000	0.000000	0	0	0		9	1999	1	1	0	0			0.000000	0.000000	2120.800000	2120.800000	2120.800000	P	G	H
58	73	10001	10074			1999-10-04	2127.160000				2127.160000	0.000000	0	30	0		10	1999	1	1	1	0	G		7.000000	0.000000	1908.000000	1988.000000	1988.000000	P	G	H
59	74	10003	10075			1999-10-05	2160.300000				2160.300000	0.000000	0	30	0		10	1999	1	1	1	2	G	P	7.000000	7.000000	1895.000000	1895.000000	1895.000000	P	G	H
60	75	10004	10076			1999-10-07	1279.610000				1279.610000	0.000000	0	30	0		10	1999	1	1	3	0	H		15.000000	0.000000	632.700000	1112.700000	1112.700000	P	G	H