| # | JVID,I,4 | GLYear,S,2 | GLPeriod,S,2 | JVNumber,I,4 | Source,A,2 | TransType,A,3 | TransDate,D,4 | TransDescription,A,60 | VendorID,I,4 | APInvoiceID,I,4 | ChequeID,I,4 | CustomerID,I,4 | ARInvoiceID,I,4 | PaymentID,I,4 | JVAmount,$,8 | Posted,L,1 | AutoReverse,L,1
|
|---|
| 1 | 0 | 1997 | 7 | 1001 | GL | JV | 1997-07-01 | To record opening balances | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 4123.470000 | 1 | 0 |
| 2 | 1 | 1997 | 7 | 1002 | AP | Inv | 1997-08-05 | AP Invoice 8745963 | 45 | 0 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 14500.000000 | 1 | 0 |
| 3 | 2 | 1997 | 7 | 1003 | AP | Inv | 1997-08-05 | AP Invoice 12489 | 42 | 1 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 59.280000 | 1 | 0 |
| 4 | 3 | 1997 | 7 | 1004 | AP | Inv | 1997-08-05 | AP Invoice 859423 | 45 | 2 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 7250.000000 | 1 | 0 |
| 5 | 4 | 1997 | 7 | 1005 | AP | Inv | 1997-08-05 | AP Invoice 158 | 44 | 3 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 695.500000 | 1 | 0 |
| 6 | 5 | 1997 | 7 | 1006 | AP | Inv | 1997-08-05 | AP Invoice 12345 | 43 | 4 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 7.430000 | 1 | 0 |
| 7 | 6 | 1997 | 7 | 1007 | AP | Inv | 1997-08-05 | AP Invoice 23456 | 43 | 5 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 7.430000 | 1 | 0 |
| 8 | 7 | 1997 | 7 | 1008 | AP | Inv | 1997-08-05 | AP Invoice 34567 | 43 | 6 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 14.860000 | 1 | 0 |
| 9 | 9 | 1997 | 7 | 1010 | AR | Inv | 1997-08-05 | AR Invoice 10001 | -2147483648 | -2147483648 | -2147483648 | 62 | 0 | -2147483648 | 3712.000000 | 1 | 0 |
| 10 | 10 | 1997 | 7 | 1011 | AR | Inv | 1997-08-05 | AR Invoice 10002 | -2147483648 | -2147483648 | -2147483648 | 64 | 1 | -2147483648 | 10817.000000 | 1 | 0 |
| 11 | 11 | 1997 | 7 | 1012 | AR | Inv | 1997-08-05 | AR Invoice 10003 | -2147483648 | -2147483648 | -2147483648 | 62 | 2 | -2147483648 | 5510.000000 | 1 | 0 |
| 12 | 12 | 1997 | 7 | 1013 | AR | Inv | 1997-08-05 | AR Invoice 10004 | -2147483648 | -2147483648 | -2147483648 | 61 | 3 | -2147483648 | 149.800000 | 1 | 0 |
| 13 | 13 | 1997 | 7 | 1014 | AR | Inv | 1997-08-05 | AR Invoice 10005 | -2147483648 | -2147483648 | -2147483648 | 61 | 4 | -2147483648 | 32.100000 | 1 | 0 |
| 14 | 14 | 1997 | 7 | 1015 | AR | Inv | 1997-08-05 | AR Invoice 10006 | -2147483648 | -2147483648 | -2147483648 | 61 | 5 | -2147483648 | 727.600000 | 1 | 0 |
| 15 | 15 | 1997 | 7 | 1016 | GL | JV | 1997-07-31 | To reconcile bank to July 31, 1997 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 1456.000000 | 1 | 0 |
| 16 | 16 | 1997 | 8 | 1017 | AR | Pmt | 1997-08-05 | AR Cheque 57894 | -2147483648 | -2147483648 | -2147483648 | 61 | -2147483648 | 0 | 149.800000 | 1 | 0 |
| 17 | 17 | 1997 | 8 | 1018 | AR | Pmt | 1997-08-05 | AR Cheque 36987 | -2147483648 | -2147483648 | -2147483648 | 64 | -2147483648 | 1 | 5000.000000 | 1 | 0 |
| 18 | 18 | 1997 | 8 | 1019 | AP | Chq | 1997-08-05 | AP Cheque 25825 | 43 | -2147483648 | 0 | -2147483648 | -2147483648 | -2147483648 | 14.860000 | 1 | 0 |
| 19 | 19 | 1997 | 8 | 1020 | AP | Chq | 1997-08-05 | AP Cheque 25826 | 44 | -2147483648 | 1 | -2147483648 | -2147483648 | -2147483648 | 695.500000 | 1 | 0 |
| 20 | 20 | 1997 | 8 | 1021 | AR | Inv | 1997-08-06 | AR Invoice 10007 | -2147483648 | -2147483648 | -2147483648 | 65 | 6 | -2147483648 | 136.800000 | 1 | 0 |
| 21 | 21 | 1997 | 8 | 1022 | AR | Inv | 1997-08-06 | AR Invoice 10008 | -2147483648 | -2147483648 | -2147483648 | 65 | 7 | -2147483648 | 27.360000 | 1 | 0 |
| 22 | 22 | 1997 | 8 | 1023 | AR | Inv | 1997-08-06 | AR Invoice 10009 | -2147483648 | -2147483648 | -2147483648 | 64 | 8 | -2147483648 | 22601.640000 | 1 | 0 |
| 23 | 23 | 1997 | 8 | 1024 | AP | Inv | 1997-08-06 | AP Invoice 58796 | 43 | 7 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 26.750000 | 1 | 0 |
| 24 | 24 | 1997 | 8 | 1025 | AP | Inv | 1997-08-06 | AP Invoice 245 | 44 | 8 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 321.000000 | 1 | 0 |
| 25 | 25 | 1997 | 8 | 1026 | AP | Inv | 1997-08-06 | AP Invoice 78596 | 42 | 9 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 519.840000 | 1 | 0 |
| 26 | 26 | 1997 | 8 | 1027 | GL | JV | 1997-08-06 | To record cash receipt | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 1400.000000 | 1 | 0 |
| 27 | 27 | 1997 | 8 | 1028 | GL | JV | 1997-08-06 | To record depreciation for August 97 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 185.000000 | 1 | 0 |
| 28 | 28 | 1997 | 7 | 1029 | GL | JV | 1997-07-31 | To accrue payables | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 605.290000 | 1 | 1 |
| 29 | 29 | 1997 | 8 | 1030 | AP | Inv | 1997-08-06 | AP Invoice Jul 97 | 46 | 10 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 16.580000 | 1 | 0 |
| 30 | 30 | 1997 | 8 | 1031 | AP | Inv | 1997-08-06 | AP Invoice July/31 97 | 47 | 11 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 25.140000 | 1 | 0 |
| 31 | 31 | 1997 | 8 | 1032 | AP | Inv | 1997-08-06 | AP Invoice 743 | 48 | 12 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 900.000000 | 1 | 0 |
| 32 | 32 | 1997 | 7 | 1033 | GL | JV | 1997-07-31 | To record COGS | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 19000.000000 | 1 | 0 |
| 33 | 33 | 1997 | 8 | 1034 | AP | Inv | 1997-08-06 | AP Invoice 85479 | 45 | 13 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 18850.000000 | 1 | 0 |
| 34 | 34 | 1997 | 7 | 1035 | AP | Inv | 1997-08-07 | AP Invoice 98745 | 45 | 14 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 14276.700000 | 1 | 0 |
| 35 | 35 | 1997 | 8 | 1036 | GL | JV | 1997-08-07 | To record COGS | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 15000.000000 | 1 | 0 |
| 36 | 36 | 1997 | 7 | 1037 | GL | JV | 1997-08-07 | To record dereciation for July 97 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | -2147483648 | 181.250000 | 1 | 0
|
(.txt)