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

---

/ Windows 95 Secrets / Secrets1.iso / Finance / Book / BS1 / DISK2 / _SETUP.2 / Group2 / GLHist.DB (.txt)

< prev

next >

Wrap

Paradox Database Table  |  1997-08-23  |  20.0 KB  |  127 rows

---

#	GLHistID,+,4	GLAccount,A,10	GLYear,S,2	GLPeriod,S,2	Source,A,2	TransType,A,3	JVNumber,I,4	TransDate,D,4	Amount,$,8	TransDescription,A,60	VendorID,I,4	APInvoiceID,I,4	ChequeID,I,4	CustomerID,I,4	ARInvoiceID,I,4	PaymentID,I,4
1	1930	1006	1997	7	GL	JV	1001	1997-07-01	635.230000	To record opening balances	0	0	0	0	0	0
2	1931	1112	1997	7	GL	JV	1001	1997-07-01	2856.000000	To record opening balances	0	0	0	0	0	0
3	1932	4000	1997	7	GL	JV	1001	1997-07-01	-3491.230000	To record opening balances	0	0	0	0	0	0
4	1933	5114	1997	7	GL	JV	1001	1997-07-01	54.000000	To record opening balances	0	0	0	0	0	0
5	1934	5112	1997	7	GL	JV	1001	1997-07-01	30.000000	To record opening balances	0	0	0	0	0	0
6	1935	5111	1997	7	GL	JV	1001	1997-07-01	548.240000	To record opening balances	0	0	0	0	0	0
7	1936	2032	1997	7	GL	JV	1001	1997-07-01	-632.240000	To record opening balances	0	0	0	0	0	0
8	1937	1721	1997	7	AP	Inv	1002	1997-08-05	14500.000000	AP Invoice 8745963	45	0	0	0	0	0
9	1938	2032	1997	7	AP	Inv	1002	1997-08-05	-10000.000000	AP Invoice 8745963	45	0	0	0	0	0
10	1939	2034	1997	7	AP	Inv	1002	1997-08-05	-4500.000000	AP Invoice 8745963	45	0	0	0	0	0
11	1940	5111	1997	7	AP	Inv	1003	1997-08-05	55.640000	AP Invoice 12489	42	1	0	0	0	0
12	1941	1125	1997	7	AP	Inv	1003	1997-08-05	3.640000	AP Invoice 12489	42	1	0	0	0	0
13	1942	2032	1997	7	AP	Inv	1003	1997-08-05	-59.280000	AP Invoice 12489	42	1	0	0	0	0
14	1943	1200	1997	7	AP	Inv	1004	1997-08-05	7250.000000	AP Invoice 859423	45	2	0	0	0	0
15	1944	2032	1997	7	AP	Inv	1004	1997-08-05	-5000.000000	AP Invoice 859423	45	2	0	0	0	0
16	1945	2034	1997	7	AP	Inv	1004	1997-08-05	-2250.000000	AP Invoice 859423	45	2	0	0	0	0
17	1946	5118	1997	7	AP	Inv	1005	1997-08-05	650.000000	AP Invoice 158	44	3	0	0	0	0
18	1947	1125	1997	7	AP	Inv	1005	1997-08-05	45.500000	AP Invoice 158	44	3	0	0	0	0
19	1948	2032	1997	7	AP	Inv	1005	1997-08-05	-695.500000	AP Invoice 158	44	3	0	0	0	0
20	1949	5112	1997	7	AP	Inv	1006	1997-08-05	6.950000	AP Invoice 12345	43	4	0	0	0	0
21	1950	1125	1997	7	AP	Inv	1006	1997-08-05	0.480000	AP Invoice 12345	43	4	0	0	0	0
22	1951	2032	1997	7	AP	Inv	1006	1997-08-05	-7.430000	AP Invoice 12345	43	4	0	0	0	0
23	1952	5112	1997	7	AP	Inv	1007	1997-08-05	6.950000	AP Invoice 23456	43	5	0	0	0	0
24	1953	1125	1997	7	AP	Inv	1007	1997-08-05	0.480000	AP Invoice 23456	43	5	0	0	0	0
25	1954	2032	1997	7	AP	Inv	1007	1997-08-05	-7.430000	AP Invoice 23456	43	5	0	0	0	0
26	1955	5112	1997	7	AP	Inv	1008	1997-08-05	13.900000	AP Invoice 34567	43	6	0	0	0	0
27	1956	1125	1997	7	AP	Inv	1008	1997-08-05	0.960000	AP Invoice 34567	43	6	0	0	0	0
28	1957	2032	1997	7	AP	Inv	1008	1997-08-05	-14.860000	AP Invoice 34567	43	6	0	0	0	0
29	1958	4000	1997	7	AR	Inv	1010	1997-08-05	-232.000000	AR Invoice 10001	0	0	0	62	0	0
30	1959	4000	1997	7	AR	Inv	1010	1997-08-05	-3480.000000	AR Invoice 10001	0	0	0	62	0	0
31	1960	1112	1997	7	AR	Inv	1010	1997-08-05	2560.000000	AR Invoice 10001	0	0	0	62	0	0
32	1961	1113	1997	7	AR	Inv	1010	1997-08-05	1152.000000	AR Invoice 10001	0	0	0	62	0	0
33	1962	4000	1997	7	AR	Inv	1011	1997-08-05	-4800.000000	AR Invoice 10002	0	0	0	64	1	0
34	1963	4000	1997	7	AR	Inv	1011	1997-08-05	-3750.000000	AR Invoice 10002	0	0	0	64	1	0
35	1964	4000	1997	7	AR	Inv	1011	1997-08-05	-1000.000000	AR Invoice 10002	0	0	0	64	1	0
36	1965	2040	1997	7	AR	Inv	1011	1997-08-05	-668.500000	AR Invoice 10002	0	0	0	64	1	0
37	1966	2041	1997	7	AR	Inv	1011	1997-08-05	-598.500000	AR Invoice 10002	0	0	0	64	1	0
38	1967	1112	1997	7	AR	Inv	1011	1997-08-05	10817.000000	AR Invoice 10002	0	0	0	64	1	0
39	1968	4000	1997	7	AR	Inv	1012	1997-08-05	-1160.000000	AR Invoice 10003	0	0	0	62	2	0
40	1969	4000	1997	7	AR	Inv	1012	1997-08-05	-4350.000000	AR Invoice 10003	0	0	0	62	2	0
41	1970	1112	1997	7	AR	Inv	1012	1997-08-05	3800.000000	AR Invoice 10003	0	0	0	62	2	0
42	1971	1113	1997	7	AR	Inv	1012	1997-08-05	1710.000000	AR Invoice 10003	0	0	0	62	2	0
43	1972	4000	1997	7	AR	Inv	1013	1997-08-05	-20.000000	AR Invoice 10004	0	0	0	61	3	0
44	1973	4000	1997	7	AR	Inv	1013	1997-08-05	-120.000000	AR Invoice 10004	0	0	0	61	3	0
45	1974	2040	1997	7	AR	Inv	1013	1997-08-05	-9.800000	AR Invoice 10004	0	0	0	61	3	0
46	1975	1112	1997	7	AR	Inv	1013	1997-08-05	149.800000	AR Invoice 10004	0	0	0	61	3	0
47	1976	4000	1997	7	AR	Inv	1014	1997-08-05	-30.000000	AR Invoice 10005	0	0	0	61	4	0
48	1977	2040	1997	7	AR	Inv	1014	1997-08-05	-2.100000	AR Invoice 10005	0	0	0	61	4	0
49	1978	1112	1997	7	AR	Inv	1014	1997-08-05	32.100000	AR Invoice 10005	0	0	0	61	4	0
50	1979	4000	1997	7	AR	Inv	1015	1997-08-05	-300.000000	AR Invoice 10006	0	0	0	61	5	0
51	1980	4000	1997	7	AR	Inv	1015	1997-08-05	-80.000000	AR Invoice 10006	0	0	0	61	5	0
52	1981	4000	1997	7	AR	Inv	1015	1997-08-05	-300.000000	AR Invoice 10006	0	0	0	61	5	0
53	1982	2040	1997	7	AR	Inv	1015	1997-08-05	-47.600000	AR Invoice 10006	0	0	0	61	5	0
54	1983	1112	1997	7	AR	Inv	1015	1997-08-05	727.600000	AR Invoice 10006	0	0	0	61	5	0
55	1984	5115	1997	7	GL	JV	1016	1997-07-31	24.250000	To reconcile bank to July 31, 1997	0	0	0	0	0	0
56	1985	1112	1997	7	GL	JV	1016	1997-07-31	-1456.000000	To reconcile bank to July 31, 1997	0	0	0	0	0	0
57	1986	1006	1997	7	GL	JV	1016	1997-07-31	1431.750000	To reconcile bank to July 31, 1997	0	0	0	0	0	0
58	1987	1112	1997	8	AR	Pmt	1017	1997-08-05	-149.800000	AR Cheque 57894	0	0	0	61	0	0
59	1988	1006	1997	8	AR	Pmt	1017	1997-08-05	149.800000	AR Cheque 57894	0	0	0	61	0	0
60	1989	1112	1997	8	AR	Pmt	1018	1997-08-05	-5000.000000	AR Cheque 36987	0	0	0	64	0	1
61	1990	1006	1997	8	AR	Pmt	1018	1997-08-05	5000.000000	AR Cheque 36987	0	0	0	64	0	1
62	1991	2032	1997	8	AP	Chq	1019	1997-08-05	14.860000	AP Cheque 25825	43	0	0	0	0	0
63	1992	1006	1997	8	AP	Chq	1019	1997-08-05	-14.860000	AP Cheque 25825	43	0	0	0	0	0
64	1993	2032	1997	8	AP	Chq	1020	1997-08-05	695.500000	AP Cheque 25826	44	0	1	0	0	0
65	1994	1006	1997	8	AP	Chq	1020	1997-08-05	-695.500000	AP Cheque 25826	44	0	1	0	0	0
66	1995	4000	1997	8	AR	Inv	1021	1997-08-06	-120.000000	AR Invoice 10007	0	0	0	65	6	0
67	1996	2040	1997	8	AR	Inv	1021	1997-08-06	-8.400000	AR Invoice 10007	0	0	0	65	6	0
68	1997	2041	1997	8	AR	Inv	1021	1997-08-06	-8.400000	AR Invoice 10007	0	0	0	65	6	0
69	1998	1112	1997	8	AR	Inv	1021	1997-08-06	136.800000	AR Invoice 10007	0	0	0	65	6	0
70	1999	4000	1997	8	AR	Inv	1022	1997-08-06	24.000000	AR Invoice 10008	0	0	0	65	7	0
71	2000	2040	1997	8	AR	Inv	1022	1997-08-06	1.680000	AR Invoice 10008	0	0	0	65	7	0
72	2001	2041	1997	8	AR	Inv	1022	1997-08-06	1.680000	AR Invoice 10008	0	0	0	65	7	0
73	2002	1112	1997	8	AR	Inv	1022	1997-08-06	-27.360000	AR Invoice 10008	0	0	0	65	7	0
74	2003	4000	1997	8	AR	Inv	1023	1997-08-06	-800.000000	AR Invoice 10009	0	0	0	64	8	0
75	2004	4000	1997	8	AR	Inv	1023	1997-08-06	-18750.000000	AR Invoice 10009	0	0	0	64	8	0
76	2005	4000	1997	8	AR	Inv	1023	1997-08-06	-276.000000	AR Invoice 10009	0	0	0	64	8	0
77	2006	2040	1997	8	AR	Inv	1023	1997-08-06	-1387.820000	AR Invoice 10009	0	0	0	64	8	0
78	2007	2041	1997	8	AR	Inv	1023	1997-08-06	-1387.820000	AR Invoice 10009	0	0	0	64	8	0
79	2008	1112	1997	8	AR	Inv	1023	1997-08-06	22601.640000	AR Invoice 10009	0	0	0	64	8	0
80	2009	5112	1997	8	AP	Inv	1024	1997-08-06	25.000000	AP Invoice 58796	43	7	0	0	0	0
81	2010	1125	1997	8	AP	Inv	1024	1997-08-06	1.750000	AP Invoice 58796	43	7	0	0	0	0
82	2011	2032	1997	8	AP	Inv	1024	1997-08-06	-26.750000	AP Invoice 58796	43	7	0	0	0	0
83	2012	5118	1997	8	AP	Inv	1025	1997-08-06	300.000000	AP Invoice 245	44	8	0	0	0	0
84	2013	1125	1997	8	AP	Inv	1025	1997-08-06	21.000000	AP Invoice 245	44	8	0	0	0	0
85	2014	2032	1997	8	AP	Inv	1025	1997-08-06	-321.000000	AP Invoice 245	44	8	0	0	0	0
86	2015	5111	1997	8	AP	Inv	1026	1997-08-06	56.000000	AP Invoice 78596	42	9	0	0	0	0
87	2016	1721	1997	8	AP	Inv	1026	1997-08-06	431.920000	AP Invoice 78596	42	9	0	0	0	0
88	2017	1125	1997	8	AP	Inv	1026	1997-08-06	31.920000	AP Invoice 78596	42	9	0	0	0	0
89	2018	2032	1997	8	AP	Inv	1026	1997-08-06	-519.840000	AP Invoice 78596	42	9	0	0	0	0
90	2019	1006	1997	8	GL	JV	1027	1997-08-06	1400.000000	To record cash receipt	0	0	0	0	0	0
91	2020	1112	1997	8	GL	JV	1027	1997-08-06	-1400.000000	To record cash receipt	0	0	0	0	0	0
92	2021	7121	1997	8	GL	JV	1028	1997-08-06	185.000000	To record depreciation for August 97	0	0	0	0	0	0
93	2022	1821	1997	8	GL	JV	1028	1997-08-06	-185.000000	To record depreciation for August 97	0	0	0	0	0	0
94	2023	5113	1997	7	GL	JV	1029	1997-07-31	24.950000	To accrue payables	0	0	0	0	0	0
95	2024	5113	1997	8	GL	JVR	1029	1997-07-31	-24.950000	To accrue payables	0	0	0	0	0	0
96	2025	6002	1997	7	GL	JV	1029	1997-07-31	16.720000	To accrue payables	0	0	0	0	0	0
97	2026	6002	1997	8	GL	JVR	1029	1997-07-31	-16.720000	To accrue payables	0	0	0	0	0	0
98	2027	6000	1997	7	GL	JV	1029	1997-07-31	450.000000	To accrue payables	0	0	0	0	0	0
99	2028	6000	1997	8	GL	JVR	1029	1997-07-31	-450.000000	To accrue payables	0	0	0	0	0	0
100	2029	5116	1997	7	GL	JV	1029	1997-07-31	27.930000	To accrue payables	0	0	0	0	0	0
101	2030	5116	1997	8	GL	JVR	1029	1997-07-31	-27.930000	To accrue payables	0	0	0	0	0	0
102	2031	5110	1997	7	GL	JV	1029	1997-07-31	85.690000	To accrue payables	0	0	0	0	0	0
103	2032	5110	1997	8	GL	JVR	1029	1997-07-31	-85.690000	To accrue payables	0	0	0	0	0	0
104	2033	2033	1997	7	GL	JV	1029	1997-07-31	-605.290000	To accrue payables	0	0	0	0	0	0
105	2034	2033	1997	8	GL	JVR	1029	1997-07-31	605.290000	To accrue payables	0	0	0	0	0	0
106	2035	6002	1997	8	AP	Inv	1030	1997-08-06	15.500000	AP Invoice Jul 97	46	10	0	0	0	0
107	2036	1125	1997	8	AP	Inv	1030	1997-08-06	1.080000	AP Invoice Jul 97	46	10	0	0	0	0
108	2037	2032	1997	8	AP	Inv	1030	1997-08-06	-16.580000	AP Invoice Jul 97	46	10	0	0	0	0
109	2038	5113	1997	8	AP	Inv	1031	1997-08-06	23.500000	AP Invoice July/31 97	47	11	0	0	0	0
110	2039	1125	1997	8	AP	Inv	1031	1997-08-06	1.640000	AP Invoice July/31 97	47	11	0	0	0	0
111	2040	2032	1997	8	AP	Inv	1031	1997-08-06	-25.140000	AP Invoice July/31 97	47	11	0	0	0	0
112	2041	6000	1997	8	AP	Inv	1032	1997-08-06	450.000000	AP Invoice 743	48	12	0	0	0	0
113	2042	6000	1997	8	AP	Inv	1032	1997-08-06	450.000000	AP Invoice 743	48	12	0	0	0	0
114	2043	2032	1997	8	AP	Inv	1032	1997-08-06	-900.000000	AP Invoice 743	48	12	0	0	0	0
115	2044	5000	1997	7	GL	JV	1033	1997-07-31	19000.000000	To record COGS	0	0	0	0	0	0
116	2045	1200	1997	7	GL	JV	1033	1997-07-31	-19000.000000	To record COGS	0	0	0	0	0	0
117	2046	1200	1997	8	AP	Inv	1034	1997-08-06	18850.000000	AP Invoice 85479	45	13	0	0	0	0
118	2047	2032	1997	8	AP	Inv	1034	1997-08-06	-13000.000000	AP Invoice 85479	45	13	0	0	0	0
119	2048	2034	1997	8	AP	Inv	1034	1997-08-06	-5850.000000	AP Invoice 85479	45	13	0	0	0	0
120	2049	1200	1997	7	AP	Inv	1035	1997-08-07	14276.700000	AP Invoice 98745	45	14	0	0	0	0
121	2050	2032	1997	7	AP	Inv	1035	1997-08-07	-9846.000000	AP Invoice 98745	45	14	0	0	0	0
122	2051	2034	1997	7	AP	Inv	1035	1997-08-07	-4430.700000	AP Invoice 98745	45	14	0	0	0	0
123	2052	5000	1997	8	GL	JV	1036	1997-08-07	15000.000000	To record COGS	0	0	0	0	0	0
124	2053	1200	1997	8	GL	JV	1036	1997-08-07	-15000.000000	To record COGS	0	0	0	0	0	0
125	2054	7121	1997	7	GL	JV	1037	1997-08-07	181.250000	To record dereciation for July 97	0	0	0	0	0	0
126	2055	1821	1997	7	GL	JV	1037	1997-08-07	-181.250000	To record dereciation for July 97	0	0	0	0	0	0