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

---

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

< prev

next >

Wrap

Paradox Database Table  |  1999-10-08  |  14KB  |  80 rows

---

#	APInvoiceID,I,4	VendorID,I,4	InvoiceNo,A,10	Description,A,50	InvoiceDate,D,4	DueDate,D,4	DiscountDate,D,4	InvoiceAmount,$,8	PaidAmount,$,8	DiscountAmount,$,8	DiscPC,N,8	DiscountTaken,L,1	Owing,$,8	PurchaseOrderNo,A,10	GLPeriod,S,2	GLYear,S,2	Posted,L,1
1	0	10001	Jan 99		1999-01-01	1999-01-01	0000-00-00	750.000000	750.000000				0.000000		1	1999	1
2	1	10001	Feb 99		1999-02-01	1999-02-01	0000-00-00	750.000000	750.000000				0.000000		2	1999	1
3	2	10001	Mar 99		1999-03-01	1999-03-01	0000-00-00	750.000000	750.000000				0.000000		3	1999	1
4	12	10002	Jan 99		1999-01-01	1999-01-11	0000-00-00	144.450000	144.450000				0.000000		1	1999	1
5	13	10002	Feb 99		1999-02-03	1999-02-13	0000-00-00	144.450000	144.450000				0.000000		2	1999	1
6	14	10002	Mar 99		1999-03-03	1999-03-13	0000-00-00	144.450000	144.450000				0.000000		3	1999	1
7	24	10004	106123		1999-01-16	1999-01-21	0000-00-00	77.040000	77.040000				0.000000		1	1999	1
8	25	10004	106234		1999-01-28	1999-02-02	0000-00-00	62.060000	62.060000				0.000000		1	1999	1
9	26	10004	107458		1999-02-13	1999-02-18	0000-00-00	100.580000	100.580000				0.000000		2	1999	1
10	27	10004	107896		1999-02-27	1999-03-04	0000-00-00	52.430000	52.430000				0.000000		2	1999	1
11	28	10006	985632		1999-01-20	1999-02-14	0000-00-00	298.520000	298.520000				0.000000		1	1999	1
12	29	10006	985978		1999-01-23	1999-02-17	0000-00-00	67.410000	67.410000				0.000000		1	1999	1
13	30	10006	986489		1999-02-18	1999-03-15	0000-00-00	3691.500000	3691.500000				0.000000		2	1999	1
14	31	10005	100589		1999-01-05	1999-01-30	0000-00-00	535.000000	535.000000				0.000000		1	1999	1
15	32	10008	Jan 30/99		1999-01-30	1999-02-09	0000-00-00	123.570000	123.570000				0.000000		1	1999	1
16	33	10008	Feb 28/99		1999-02-28	1999-03-10	0000-00-00	428.390000	428.390000				0.000000		2	1999	1
17	34	10000	2589		1999-01-07	1999-02-01	0000-00-00	34.200000	34.200000				0.000000		1	1999	1
18	35	10000	2645		1999-01-27	1999-02-21	0000-00-00	144.780000	144.780000				0.000000		1	1999	1
19	36	10000	2873		1999-02-18	1999-03-15	0000-00-00	102.600000	102.600000				0.000000		2	1999	1
20	42	10007	89456378A	Inventory	1998-01-02	1998-01-09	1998-01-12	0.000000			2.000000		0.000000		1	1998	1
21	49	10000	3011		1999-03-11	1999-04-05	0000-00-00	64.200000	64.200000				0.000000		3	1999	1
22	50	10004	108235		1999-03-17	1999-03-22	0000-00-00	26.750000	26.750000				0.000000		3	1999	1
23	51	10004	108967		1999-03-31	1999-04-05	0000-00-00	58.850000	58.850000				0.000000		3	1999	1
24	52	10008	Mar 31/99		1999-02-21	1999-03-03	0000-00-00	312.760000	312.760000				0.000000		2	1999	1
25	53	10013	101589		1999-01-01	1999-01-26	0000-00-00	1282.130000	1282.130000				0.000000		1	1999	1
26	54	10007	9856	Inventory	1999-01-01	1999-01-08	1999-01-11	2416.900000	2416.900000	48.340000	2.000000		0.000000		1	1999	1
27	55	10013	102489		1999-02-01	1999-02-26	0000-00-00	2151.000000	2151.000000				0.000000		2	1999	1
28	56	10007	9981	Inventory	1999-02-01	1999-02-08	1999-02-11	1710.850000	1710.850000	34.220000	2.000000		0.000000		2	1999	1
29	57	10013	103156		1999-03-01	1999-03-26	0000-00-00	1502.250000	1502.250000				0.000000		3	1999	1
30	58	10007	10159	Inventory	1999-03-01	1999-03-08	1999-03-11	2062.060000	2062.060000	41.240000	2.000000		0.000000		3	1999	1
31	59	10007	10278	Inventory	1999-04-01	1999-04-08	1999-04-11	2062.060000	2062.060000	41.240000	2.000000		0.000000		4	1999	1
32	60	10013	10489	Inventory	1999-04-01	1999-04-26	0000-00-00	1502.250000	1502.250000				0.000000		4	1999	1
33	61	10001	Apr 99		1999-04-01	1999-04-01	0000-00-00	750.000000	750.000000				0.000000		4	1999	1
34	62	10007	10315	Inventory	1999-04-11	1999-04-18	1999-04-21	841.890000	825.050000	16.840000	2.000000	1	0.000000		4	1999	1
35	63	10007	10348	Inventory	1999-04-15	1999-04-22	1999-04-25	351.720000	351.720000	7.030000	2.000000		0.000000		4	1999	1
36	64	10000	3589		1999-04-11	1999-05-06	0000-00-00	64.200000	64.200000				0.000000		4	1999	1
37	65	10004	109857		1999-04-12	1999-04-17	0000-00-00	26.750000	26.750000				0.000000		4	1999	1
38	66	10004	109996		1999-04-30	1999-05-05	0000-00-00	107.000000	107.000000				0.000000		4	1999	1
39	67	10005	5874	trademark	1999-04-15	1999-05-10	0000-00-00	321.000000	321.000000				0.000000		4	1999	1
40	68	10006	10548		1999-04-08	1999-05-03	0000-00-00	17.100000	17.100000				0.000000		4	1999	1
41	69	10006	10641		1999-04-11	1999-05-06	0000-00-00	28.500000	28.500000				0.000000		4	1999	1
42	70	10002	Apr 99		1999-04-02	1999-04-12	0000-00-00	144.450000	144.450000				0.000000		4	1999	1
43	71	10008	Apr 99		1999-04-29	1999-05-09	0000-00-00	312.760000	312.760000				0.000000		4	1999	1
44	72	10011	Jan-Mar 99		1999-03-31	1999-03-31	0000-00-00	18000.000000	18000.000000				0.000000		3	1999	1
45	73	10002	May 99		1999-05-03	1999-05-13	0000-00-00	144.450000	144.450000				0.000000		5	1999	1
46	74	10008	May 99		1999-05-03	1999-05-13	0000-00-00	312.760000	312.760000				0.000000		5	1999	1
47	75	10004	110009		1999-05-14	1999-05-19	0000-00-00	53.500000	53.500000				0.000000		5	1999	1
48	76	10004	1124568		1999-05-31	1999-06-05	0000-00-00	554.260000	554.260000				0.000000		5	1999	1
49	77	10013	10628		1999-05-01	1999-05-26	0000-00-00	13134.250000	13134.250000				0.000000		5	1999	1
50	78	10007	10489	Inventory	1999-05-01	1999-05-08	1999-05-11	10424.250000	10424.250000	208.490000	2.000000		0.000000		5	1999	1
51	79	10001	May 99		1999-05-01	1999-05-01	0000-00-00	750.000000	750.000000				0.000000		5	1999	1
52	81	10015	5879	Inventory	1999-06-01	1999-06-16	0000-00-00	23050.000000	23050.000000				0.000000		6	1999	1
53	82	10013	10782	Inventory	1999-06-01	1999-06-26	0000-00-00	8977.500000	8977.500000				0.000000		6	1999	1
54	83	10002	Jun 99		1999-06-01	1999-06-11	0000-00-00	144.450000	144.450000				0.000000		6	1999	1
55	84	10004	1126789		1999-06-15	1999-06-20	0000-00-00	53.500000	53.500000				0.000000		6	1999	1
56	85	10004	1127045		1999-06-30	1999-07-05	0000-00-00	187.250000	187.250000				0.000000		6	1999	1
57	86	10008	Jun 99		1999-06-01	1999-06-11	0000-00-00	424.790000	424.790000				0.000000		6	1999	1
58	87	10001	Jun 99		1999-06-01	1999-06-01	0000-00-00	750.000000	750.000000				0.000000		6	1999	1
59	88	10015	5911	Inventory	1999-07-01	1999-07-16	0000-00-00	23050.000000	23050.000000				0.000000		7	1999	1
60	89	10013	10814	Inventory	1999-07-15	1999-08-09	0000-00-00	628.630000	628.630000				0.000000		7	1999	1
61	90	10004	1128011		1999-07-15	1999-07-20	0000-00-00	64.200000	64.200000				0.000000		7	1999	1
62	91	10008	Jul 99		1999-07-01	1999-07-11	0000-00-00	294.250000	294.250000				0.000000		7	1999	1
63	92	10001	Jul 99		1999-07-01	1999-07-01	0000-00-00	750.000000	750.000000				0.000000		7	1999	1
64	93	10002	Jul 99		1999-07-01	1999-07-11	0000-00-00	144.450000	144.450000				0.000000		7	1999	1
65	94	10013	11478	Inventory	1999-08-02	1999-08-27	0000-00-00	13869.880000	13869.880000				0.000000		8	1999	1
66	95	10015	5989	Inventory	1999-08-03	1999-08-18	0000-00-00	5296.500000	5296.500000				0.000000		8	1999	1
67	96	10004	1129012		1999-08-16	1999-08-21	0000-00-00	347.750000	347.750000				0.000000		8	1999	1
68	97	10004	1130005		1999-08-31	1999-09-05	0000-00-00	135.890000	135.890000				0.000000		8	1999	1
69	98	10008	Aug 99		1999-08-02	1999-08-12	0000-00-00	374.500000	374.500000				0.000000		8	1999	1
70	99	10001	Aug 99		1999-08-01	1999-08-01	0000-00-00	750.000000	750.000000				0.000000		8	1999	1
71	100	10002	Aug 99		1999-08-01	1999-08-11	0000-00-00	144.450000	144.450000				0.000000		8	1999	1
72	101	10005	6248		1999-08-17	1999-09-11	0000-00-00	107.000000	107.000000				0.000000		8	1999	1
73	102	10015	6017		1999-09-01	1999-09-16	0000-00-00	13542.190000	13542.190000				0.000000		9	1999	1
74	103	10001	Sep 99		1999-09-01	1999-09-01	0000-00-00	750.000000	750.000000				0.000000		9	1999	1
75	104	10011	Sep 99		1999-09-15	1999-09-15	0000-00-00	10000.000000	10000.000000				0.000000		9	1999	1
76	105	10008	Sep 99		1999-09-30	1999-10-10	0000-00-00	374.500000	374.500000				0.000000		9	1999	1
77	106	10002	Sep 99		1999-09-01	1999-09-11	0000-00-00	144.450000	144.450000				0.000000		9	1999	1
78	107	10002	Oct 99		1999-10-01	1999-10-11	0000-00-00	144.450000					144.450000		10	1999	1
79	108	10001	Oct 99		1999-10-01	1999-10-01	0000-00-00	800.000000					800.000000		10	1999	1