{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"DATABASE","type":"character","width":12},{"name":"INDEX","type":"character","width":12},{"name":"KEY_FIELD","type":"character","width":80},{"name":"DESCRIP","type":"character","width":40},{"name":"PACK","type":"character","width":1},{"name":"REINDEX","type":"character","width":1}],"n_rows":88,"rows_kept":88,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_absent","reader":"statdb_count/9"}
["FUNCKEYS","FUNCKEYS","FUNC_KEY","FUNCTION KEY ASSIGNMENTS",null,null]
["USERS","USERS1","UPPER(LOCATION)",null,null,null]
["USERS","USERS2","DESCRIP",null,null,null]
["HELP","HELP","FIELD_DB+FIELD_NAME","DATABASE + FIELDNAME",null,null]
["CLIENTS","CLIENTS1","CLIENT","CLIENT NUMBER",null,null]
["CLIENTS","CLIENTS2","UPPER(LEFT(TRIM(LNAME)+TRIM(FNAME)+COMPANY,40))","LAST+FIRST+COMPANY",null,null]
["CLIENTS","CLIENTS3","UPPE(LEFT(TRIM(COMPANY)+TRIM(STATE+CITY)+LNAME+SPAC(40),40))","COMPANY",null,null]
["PROJECT","PROJECT1","PROJECT","PROJECT",null,null]
["PROJECT","PROJECT2","DESCRIP","DESCRIPTION",null,null]
["OBJECTIV","OBJECT1","PROJECT+PROGRAM","PROJECT",null,null]
["OBJECTIV","OBJECT2","DESCRIP","DESCRIP",null,null]
["EVENTS","EVENTS1","PROJECT+PROGRAM+DTOS(DATEIN)","PROJECT",null,null]
["EVENTS","EVENTS2","INV_NUM+IIF(CLIENT#\"SHAR\",PROJECT+PROGRAM+DTOS(DATEIN),SPACE(20))",null,null,null]
["DETAILS","DETAILS2","PROJECT+PROGRAM+DTOS(DATEIN+7*VAL(PRIORITY))",null,null,null]
["DETAILS","DETAILS1","DONEBY+DTOS(DATEIN+7*VAL(PRIORITY))+PROJECT",null,null,null]
["DETAILS","DETAILS3","DTOS(DATEIN+7*VAL(PRIORITY))",null,null,null]
["DISKETTE","DISKETTE","SERIAL",null,null,null]
["ACCOUNTS","ACCOUNT1","ACCOUNT_ID","ACCOUNT NUMBER",null,null]
["ACCOUNTS","ACCOUNT2","DESCRIP","DESCRIPTIVE",null,null]
["ACCTDESC","ACCTDES1","ACCOUNT_ID","\"1,2,3,4 OR 5\"",null,null]
["ACCTDESC","ACCTDES2","DESCRIP","DESCRIPTIVE",null,null]
["LEDGER","LEDGER","ACCOUNT_ID+DTOS(DATE)","GENERAL LEDGER",null,null]
["DEPT","DEPT1","DEPT","DEPARTMENT CODE",null,null]
["DEPT","DEPT2","DESCRIP","DESCRIPTIVE",null,null]
["JOURNAL","JOURNAL","STR(TRANS,4)",null,null,null]
["EMPLOYEE","EMPLOY1","DONEBY",null,null,null]
["PRINTERS","PRINTER1","STR(RECNO(),2)","PRINTER ID NO.",null,null]
["PRINTERS","PRINTER2","UPPER(DESCRIP)","PRINTER DESCRIPTION",null,null]
["EVENTS","EVENTS3","BATCH","BATCH NUMBER",null,null]
["EMPLOYEE","EMPLOY2","NAME",null,null,null]
["INVOICE","INVOICE1","INVOICE",null,null,null]
["INVOICE","INVOICE2","CLIENT+DESCEND(INVOICE)",null,null,null]
["INVOICE","INVOICE3","PROJECT+INVOICE",null,null,null]
["PROGRAMS","PROGRAM1","PROJECT",null,null,null]
["PROGRAMS","PROGRAM2","DESCRIP",null,null,null]
["PROGRAMS","PROGRAM3","TIER+PROJECT",null,null,null]
["ERRTRACK","ERROR1","SERIAL_NUM+DESCEND(DTOS(ENTERED))",null,null,null]
["QUESTION","QUEST1","PROJECT+UPPER(LEFT(DESCRIP,10))",null,null,null]
["CONTACTS","CONTACT1","CLIENT+DESCEND(DTOS(DATE))+DESCEND(CTIME)",null,null,null]
["CLIENTS","CLIENTS4","LEFT(CLIENT,4)+STR(10000-VAL(SUBSTR(CLIENT,5,4)))","INVERSE SORT",null,null]
["SUPPORT","SUPPORT1","SERIAL_NUM",null,null,null]
["SUPPORT","SUPPORT2","CLIENT+SUBSTR(SERIAL_NUM,5,1)+SERIAL_NUM",null,null,null]
["SUPPORT","SUPPORT3","PROJECT+CLIENT",null,null,null]
["CLIENTS","CLIENTS5","SALES_REP+DTOS(DATE)+TIME","NEXT CONTACT",null,null]
["CONTACTS","CONTACT2","PROJECT+DTOS(DATE)",null,null,null]
["QUESTION","QUEST2","PROJECT+UPPER(KEYWORD)",null,null,null]
["ERRTRACK","ERROR2","CLIENT+DESCEND(DTOC(ENTERED))",null,null,null]
["ERRTRACK","ERROR3","PROJECT",null,null,null]
["SUPPORT","SUPPORT4","LEFT(SERIAL_NUM,5)+STR(10000-VAL(SUBS(SERIAL_NUM,6,4)))","INVERSE SORT",null,null]
["CLIENTS","CLIENTS6","STATE+UPPER(CITY)+UPPER(LEFT(COMPANY,20))+UPPER(LNAME)","STATE+CITY+COMPANY",null,null]
["CLIENTS","CLIENTS7","SALES_REP+LEFT(CLIENT,4)+DTOS(DATE)+TIME","NEXT PROJECT",null,null]
["POSTAGE","POSTAGE1","PROJECT+DEPT","PROJECT CODE+COST CENTER",null,null]
["POSTAGE","POSTAGE2","DTOS(DATE)","DATE",null,null]
["INVENTOR","INVENT1","STOCK_NUM","STOCK NUMBER",null,null]
["INVENTOR","INVENT2","DESCRIP","DESCRIPTION",null,null]
["STATE","STATE1","ST_AB","STATE ABBREVIATION",null,null]
["STATE","STATE2","ST_NAME","STATE NAME",null,null]
["SOURCES","SOURCES","STOCK_NUM","STOCK NUMBER",null,null]
["RELEASE","RELEASE1","CODE",null,null,null]
["RELEASE","RELEASE2","DESCRIP",null,null,null]
["CONTACTS","CONTACT3","DONEBY+DESCEND(DTOS(DATE))",null,null,null]
["ERRTRACK","ERROR5","KEYWORDS",null,null,null]
["ERRTRACK","ERROR4","DESCRIP",null,null,null]
["LEASE","LEASE","CLIENT","LEASE",null,null]
["CLIENTS","CLIENTS8","ZIP",null,null,null]
["COMPANY","COMPANY1","COMPNO",null,null,null]
["COMPANY","COMPANY2","UPPER(COMPANY)",null,null,null]
["COMPANY","COMPANY3","UPPER(STATE+CITY+COMPANY)",null,null,null]
["COMPANY","COMPANY4","ZIP",null,null,null]
["COMPANY","COMPANY5","LEFT(COMPNO,4)+STR(10000-VAL(SUBS(COMPNO,5,4)))",null,null,null]
["FILTER","FILTER1","FILE_NAME+FILT_CODE",null,null,null]
["FILTER","FILTER2","FILE_NAME+UPPER(DESCRIP)",null,null,null]
["UPS","UPS1","CLIENT",null,null,null]
["UPS","UPS2","UPPER(LNAME)",null,null,null]
["UPS","UPS3","UPPER(COMPANY)",null,null,null]
["EMPLOYEE","EMPLOY3","SSN","SSN",null,null]
["EMPLOYEE","EMPLOY4","UPPER(LNAME+FNAME)","NAME",null,null]
["PRCLIENT","PRCLIEN1","CLNO","CLIENT NUMBER",null,null]
["PRCLIENT","PRCLIEN2","UPPER(CLIENT)","CLIENT NAME",null,null]
["PAYROLL","PAYROLL1","SSN+DTOS(PAY_DATE)","SSN + PAY DATE",null,null]
["PAYROLL","PAYROLL2","DTOS(PAY_DATE)+SSN","PAY DATE + SSN",null,null]
["PAYROLL","PAYROLL3","CKNO","CKNO",null,null]
["TAXSCHD","TAXSCHD","TAX_AUTH+FIL_STAT",null,null,null]
["HISTORY","HISTORY1","SSN +DTOS(PAY_DATE)","SSN + PAY_DATE",null,null]
["HISTORY","HISTORY2","DTOS(PAY_DATE)+SSN","PAY_DATE + SSN",null,null]
["HISTORY","HISTORY3","CKNO","CKNO",null,null]
["W2YEAR","W2YEAR1","SSN","SSN",null,null]
["INFOREQ","INFOREQ","CLIENT",null,null,null]