)clear )COPY_ONCE table cleared (11 entries) CLEAR WS )load 1 tb DUMPED 2023-08-12 10:27:24 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/import DUMPED 2023-08-08 17:34:49 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/utf8 DUMPED 2023-07-17 16:44:54 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/utl DUMPED 2023-08-07 15:46:53 (GMT-4) NEW )COPY_ONCE workspace: 3 DALY/lex DUMPED 2023-07-15 15:50:11 (GMT-4) NEW )COPY_ONCE workspace: 3 DALY/date DUMPED 2023-08-03 15:27:19 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/wp DUMPED 2023-08-11 15:08:40 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/html DUMPED 2023-08-11 15:07:27 (GMT-4) NEW )COPY_ONCE workspace: 3 DALY/xml DUMPED 2023-07-17 17:20:38 (GMT-4) html∆a html∆b html∆blockquote html∆body html∆caption html∆cite html∆div html∆em html∆footer html∆h1 html∆h2 html∆h3 html∆h4 html∆h5 html∆head html∆header html∆hr html∆html html∆i html∆li html∆link html∆nav html∆p html∆pre html∆ span html∆strong html∆style html∆td html∆th html∆thead html∆tr html∆title html∆table html∆thead html∆colgroup html∆br html∆hr html∆meta html∆col NEW )COPY_ONCE workspace: 3 DALY/fmt DUMPED 2023-07-15 15:49:46 (GMT-4) NEW )COPY_ONCE workspace: 5 DALY/prompt DUMPED 2023-07-17 17:18:19 (GMT-4) NEW )COPY_ONCE workspace: 3 DALY/seq DUMPED 2023-07-15 15:53:16 (GMT-4) 1 2 3 tb_import_delimited '/home/dalyw/wslib1/test_data/example_tb.csv' No string end found+ 1 2 3 tb_import_delimited '/home/dalyw/wslib1/test_data/example_tb.csv' You must initiate the data base before importing data tb_import_delimited ^ utl∆helpFns 'tb_init' tb_init meta;tmp ⍝ Function to set up the tb database. meta is either a lexicon of company ⍝ (name), end (year end date) and retainedEarnings (account number) ⍝ or a vactor (in order of name, year end, and retained earnings ⍝ 1) Setup dictionaries and data tables: tb_init 'Test Company' '12/31/2008' 3210 1 2 3 tb_import_delimited '/home/dalyw/wslib1/test_data/example_tb.csv' ⍞←tb_tb_show Test Company TB_12/31/2008 Trial Balance 12/31/2008 08/12/2023 AcctNo Title Dr Cr 1000 Clearing account 0 0 1110 DO NOT USE Petty Cash 300 0 1116 CASH OPERATING HUD 0 0 1120 CASH - OPERATING 38,568 0 1121 CASH - OPERATING 0 0 1122 CASH - DEVELOPMENT ACC 0 0 1123 CASH MONEY MARKET DEV 0 0 1126 MORTGAGE SETTLEMENT C 1,886 0 1127 DEFERRED MORTG SETTLE 0 1,842 1130 TENANT ACCOUNTS RECEI 6,561 0 1131 A/R HUD 24,913 0 1132 ACCOUNTS RECEIVABLE -P 0 0 1191 TENANT SECURITY DEPOSI 0 0 1192 TENANT SECURITY DEPOS 20,290 0 1193 ARCHITECTS' RETAINER- 0 0 1195 COMPUTER CONSULT.RET 0 0 1240 PREPAID INSURANCE & T 30,324 0 1242 PREPAID EXPENSES 0 0 1301 NOTES RECEIVABLE 0 0 1311 Insurance escrow 59,157 0 1315 CONSTRUCTION COST ESCR 0 0 1317 OPERATING RESERVE 0 0 1320 REPLACEMENT RESERVE 12,133 0 1324 OPER & MAINT RESERVE - 0 0 1325 REPLACEMENT RESERVE-S 0 0 1330 DEBT SERVICE-CITIZENS 0 0 1390 PLEDGED CD 101,203 0 1410 LAND 24,350 0 1420 BUILDINGS 1,103,515 0 1421 BUILDING IMPROVEMENTS 867,546 0 1422 UNFUNDED IMPROVEMENTS 407,192 0 1431 CLOSING COSTS 0 0 1440 BUILDING EQUIPMENT-PO 175,076 0 1450 FURNITURE & FIXTURES 16,660 0 1465 OFFICE FURNITURE & FI 4,385 0 1480 MOTOR VEHICLES 0 0 1482 ORGANIZATION EXPENSES 0 0 1490 DEVELOPMENT COSTS 0 0 1492 ACCUMULATED DEPRECIATI 0 0 1493 ACCUMULATED AMORTIZATI 0 0 1500 INVESTMENTS 0 0 1501 NOTE RECEIVABLE - DARR 0 0 1502 NOTE RECEIVABLE - ADM 0 0 1503 NOTE RECEIVABLE - PEN 0 0 1508 UNRESTRICTED INVEST. 0 0 1509 BOARD RESTRICTED INVE 0 0 1510 DONOR RESTRICTED INVE 0 0 1511 PENSDALE MINIMUM CAP 0 0 1515 LOAN RECEIVABLE (PT) 0 0 1587 GRANTS RECEIVABLE 0 0 1809 ZONING 0 0 1850 DEVELOPERS FEES 0 0 1855 DEVELOPER FEE 0 0 1861 TAX 0 0 2110 ACCOUNTS PAYABLE 0 76,456 2111 OTHER ACCRUED EXPENSES 0 0 2119 ACCRUED R/E TAXES 0 0 2120 ACCRUED PAYROLL CONTRO 0 4,284 2123 Accrued Mgmt Fees 0 0 2130 ACCRUED INTEREST PAYAB 0 3,755 2131 MORTAGE INTEREST PAYAB 0 0 2137 DUE TO FRP - RDA 0 0 2141 DUE ON SOFT COSTS 0 0 2151 PREPAID RENT 0 0 2152 ACCRUED LIABILITIES 0 17,801 2170 Current Portion Mtg. 0 51,474 2191 TENANT SECURITY DEPOSI 0 6,884 2310 NOTES PAYABLE 0 0 2312 GRANT PAYABLE-LISC (B 0 0 2315 LINE OF CREDIT-SOVEREI 0 0 2317 LINE OF CREDIT - PPB 0 0 2318 LINE OF CREDIT - U.S. 0 0 2320 MORTGAGE PAYABLE 0 315,763 2321 MORTGAGE PAYABLE - R $ 0 0 2322 MORTGAGE PAYABLE 0 0 2324 LOAN PAYABLE - RDA 0 0 2391 LOAN - PHDC 0 188,341 3210 RETAINED EARNINGS/SUR 0 643,617 3235 MISC CLEARING 0 0 4120 RES FOR DEPR-BUILDING 0 948,778 4121 RES. FOR BUILDING IMP. 0 424,317 4140 RES FOR DEPREC 0 133,457 4160 RESERVE FOR DEPRECI 0 8,564 4165 RESERVE FOR DEPR-OFFI 0 612 4180 RES FOR DEPR-MOTOR VE 0 0 4190 ACCUM DEP-MISC FIXED 0 0 4220 Allowance for bad debts 0 19,010 5100 GRANT INCOME 0 0 5120 RENT INCOME-APARTMENTS 0 394,533 5121 TENANT ASSISTANCE - HU 0 693,191 5122 TENANT ASSISTANCE - PH 0 0 5123 RENT INCOME - OTHER S 0 0 5140 COMMERCIAL RENT 0 0 5220 VACANCIES-APARTMENTS 168,373 0 5320 MANAGEMENT FEE 0 0 5410 INTEREST INCOME-PJCT 0 0 5420 INTEREST FROM INVESTM 0 7,639 5440 INCOME FROM INVESTMENT 0 0 5900 OTHER INCOME 0 0 5930 DAMAGES AND CLEANING 0 70 5990 MISC INCOME 0 0 5992 UNRESTRICTED DONATIONS 0 0 5996 PROGRAM & ADMINISTRAT 0 0 6010 OFFICE EXPENSE 0 0 6200 ADMINISTRATIVE EXPENSE 60 0 6210 ADVERTISING 996 0 6310 OFFICE SALARIES 34,843 0 6311 OFFICE SUPPLIES 9,628 0 6313 CONTRACT CASE MGT 0 0 6315 OFFICE EQUIPMENT RENT 1,409 0 6316 STAFF TRAINING/EDUCATI 132 0 6319 STAFF TRANSPORTATION E 0 0 6320 MANAGEMENT FEE 38,155 0 6330 MANAGEMENT SALARIES 40,134 0 6332 PROGRAM MANAGEMENT SA 0 0 6340 LEGAL EXPENSES (PROJEC 1,344 0 6345 PROFESSIONAL FEES 8,915 0 6350 AUDITING EXPENSES 12,291 0 6351 BOOKKEEPING/ACCTG SERV 11,544 0 6360 TELEPHONE & BEEPERS 7,567 0 6370 BAD DEBTS 15,853 0 6371 Postage 686 0 6380 DUES & SUBSCRIPTIONS 0 0 6390 MISC ADMINISTRATION EX 10,435 0 6392 CONFERENCE/ENTERTAINME 1,673 0 6393 BANK CHARGES 42 0 6394 CONFERENCE-DEVELOPMENT 0 0 6395 BOARD EXPENSES 0 0 6420 FUEL OIL/COAL 0 0 6450 ELECTRICITY 65,475 0 6451 WATER & SEWER 61,801 0 6452 GAS - FUEL 90,288 0 6505 COPIER & MAINTENANCE E 0 0 6510 JANITOR PAYROLL 33,332 0 6515 JANITOR & CLEANING SU 8,787 0 6517 JANITOR & CLEANING CO 0 0 6519 EXTERMINATING CONTRAC 871 0 6525 GARBAGE & TRASH REMOVA 6,790 0 6530 SECURITY PAYROLL 63,013 0 6532 SECURITY CONTRACTORS 2,585 0 6536 GROUNDS SUPPLIES 0 0 6537 GROUNDS CONTRACT 2,766 0 6540 REPAIRS PAYROLL 38,452 0 6541 REPAIRS MATERIAL 12,398 0 6542 REPAIRS CONTRACT 22,788 0 6545 ELEVATOR MAINT/CONTRAC 4,724 0 6548 SNOW REMOVAL 200 0 6549 APPLIANCE REPLACEMENT 0 0 6552 PLUMBING MAINTENANCE 656 0 6570 MOTOR VEHICLE REPAIR/ 1,690 0 6571 VEHICLES REPAIR/OPER- 0 0 6590 MISC OPERATING/MAINTEN 0 0 6591 INSPECTIONS 5,492 0 6620 DEPR-BUILDINGS 29,118 0 6621 DEPREC BUILD IMPROVE 36,011 0 6630 ORGANIZATION EXPENSE 11,229 0 6650 DEPR-FURN PJCT/TENANT 1,422 0 6690 Depr Office furniture/fix 612 0 6711 PAYROLL TAXES(PJCT SH 31,535 0 6719 MISC TAXES LICNS PERMI 2,835 0 6720 PROPERTY & LIABILITY I 51,076 0 6721 FIDELITY BOND INSURANC 327 0 6722 WORKERS COMPENSATION 7,999 0 6723 HEALTH INSURANCE 19,448 0 6724 FRINGE BENEFITS 11,264 0 6820 INTEREST ON MORTGAGE 14,039 0 6821 MORTGAGE INTEREST- 0 0 6830 INTEREST ON MORTGAGE 5,358 0 6840 INT.NOTE.PAY.SHORT TER 0 0 6885 LOAN INTEREST 0 0 6890 MISC.FINANCIAL EXPENSE 301 0 6981 PROGRAM PAYROLL 36,911 0 6982 RENTAL SUBSIDY 0 0 6983 ENVIRON/AFTER SCHOOL 0 0 7120 LEGAL EXPENSES 0 0 7211 CAPITAL IMPROVEMENTS 0 0 7212 COMPUTER TECHNOLOGY 0 0 7950 LATE SETTLEMENT EXPENS 659 0 Total 3,940,391 3,940,391 fifo[si=2 len=4 PC=4] is now : TC_END TC_SYMBOL TC_ASSIGN TC_VOID at Prefix.cc:529 VALUE ERROR+ ⍞←tb_tb_show ^