{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"DBFNAME","type":"character","width":8},{"name":"DESCRIPT","type":"character","width":30},{"name":"INDEXNAME","type":"character","width":8},{"name":"INDEXEXP","type":"character","width":64},{"name":"NCXEXP","type":"character","width":64},{"name":"UNIQUE","type":"character","width":1},{"name":"REINDEX","type":"logical","width":1},{"name":"RESET_TYPE","type":"character","width":1}],"n_rows":69,"rows_kept":69,"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"}
["ACCOUNTS","Store Accounts by Date","ACCTDATE","DATEDEL","DATEDEL","0",false,"H"]
["ACCOUNTS","Store Accounts by Name","ACCTNAME","LEFT(UPPER(NAME),8)","LEFT(UPPER(NAME),8)","0",false,null]
["ACCOUNTS","Store Accounts by Customer #","ACCTCUST","CUSTNUMB","CUSTNUMB","0",false,null]
["ACNTPAY","Accounts Payable","ACNTPAY","DUE_DATE",null,"0",false,"H"]
["CATEGORY","SKU Categories","CATEGORY","DEPARTMENT+UPPER(LEFT(DESCRIPT,6))","DEPARTMENT+UPPER(LEFT(DESCRIPT,6))","0",false,"S"]
["CATEGORY","Categories By Dept & Number","CATEGNUM","DEPARTMENT+NUMBER","DEPARTMENT+NUMBER","1",false,"S"]
["CONTROL","Store Information / Settings",null,null,null,null,false,"S"]
["CREDITS","Store Acct Paymnt by Customer","CREDCUST","CUSTNUMB","CUSTNUMB","0",false,"H"]
["CREDITS","Store Acct Paymnt By Date","CREDDATE","DATE_PAID","DATE_PAID","0",false,null]
["CTRLSWIT","System Control Switches","CTRLSWIT","SWITCH_NUM","SWITCH_NUM","1",false,"S"]
["CTRLVAL","Store Control Values","CTRLVAL","VAL_NUM","VAL_NUM","1",false,"S"]
["CUSTOMER","Customer Master File: By Name","CUSTNAME","UPPER(LNAME+LEFT(FNAME,5))","UPPER(LNAME+LEFT(FNAME,5))","0",false,"A"]
["CUSTOMER","Customer Master File:By Number","CUSTNUMB","CUSTNUMB","CUSTNUMB","1",false,null]
["CUSTOMER","Customer Master File: By Phone","CUSTFONE","RIGHT(SPACE(4)+TRIM(HOME_NUM),4)","LEFT(TRIM(HOME_NUM)+'    ', 4)","0",false,null]
["DBFINFO","Database Index Driver","DBFINFO","DBFNAME","DBFNAME","0",false,"S"]
["DEPTS","Department Numbers","DEPTNUM","DEPT_NUM","DEPT_NUM","1",true,"S"]
["DEPTS","Department Names","DEPTNAME","DEPARTMENT","DEPARTMENT","0",true,"S"]
["DISCOUNT","Store Discount Choices",null,null,null,null,false,"S"]
["EMPLOYEE","Employee Numbers","EMPLOYEE","EMPLOY_NUM","EMPLOY_NUM","1",false,"S"]
["EMPLOYEE","Employee Name List","EMPLNAME","UPPER(LEFT(LNAME,6)+LEFT(FNAME,6))","UPPER(LEFT(LNAME,6)+LEFT(FNAME,6))","0",false,"S"]
["EMPLSTAT","Employee Status Codes",null,null,null,null,false,"S"]
["ESTCUST","Customer Estimates : By Name","ESTNAME","UPPER(LNAME+FNAME)","UPPER(LNAME+FNAME)","0",false,"A"]
["ESTCUST","Customer Estimates : By Number","ESTNUMB","ESTNUMB","ESTNUMB","1",false,null]
["ESTIMATE","Estimate Items by Estimate #","ESTIMATE","ESTNUMBER","ESTNUMBER","0",false,"A"]
["INVENTRY","Inventory File By SKU Number","INVENSKU","SKUCODE","SKUCODE","1",false,"S"]
["JOURFORM","Journal Template File",null,null,null,null,false,null]
["JOURNAL","Electronic Journal Invoice #","JOURNAL","INVOICE","INVOICE","0",false,"H"]
["LABORS","Canned Labor Descriptions","LABORS","DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)","DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)","0",false,"S"]
["LABORS","Labor Descriptions by Number","LABORNUM","DEPT+CATEGORY+TYPE","DEPT+CATEGORY+TYPE","1",false,"S"]
["LABRATES","Labor Rates per Hour",null,null,null,null,false,"S"]
["LAYCUST","Layaway Accounts by Name","LAYCUSTC","UPPER(LEFT(LNAME,8)+LEFT(FNAME,8))","UPPER(LEFT(LNAME,8)+LEFT(FNAME,8))","0",false,"H"]
["LAYCUST","Layaway Accounts by Number","LAYCUSTN","LAYNUMB","LAYNUMB","1",false,null]
["LAYCUST","Layaway Accounts by Date","LAYCUSTD","DATE_IN","DATE_IN","0",false,null]
["LAYITEM","Layaway Account Items","LAYITEM","LAYNUMB","LAYNUMB","0",false,"H"]
["LAYPAYMT","Layaway Account Payments","LAYPAYMT","LAYNUMB","LAYNUMB","0",false,"H"]
["LAYPAYMT","Layaway Account Payments Inv.","LAYPYINV","INVOICE","INVOICE","0",false,null]
["MENUS","Menus by Name","MENUS","MENU_FORM","MENU_FORM","0",false,"S"]
["MONTHLOG","Log of Journal Files by Month",null,null,null,null,false,"H"]
["NOTAX","Non-Taxable Sales Journal","NOTAX","CUSTNUMB","CUSTNUMB","0",false,"H"]
["PACKCODE","Stock Pack Codes","PACKCODE","PACK_CODE","PACK_CODE","1",false,"S"]
["PACKCODE","Stock Pack Codes by Value","PACKNUMB","PACK_UNITS","PACK_UNITS","0",false,"S"]
["PACKDBF","Closing File Maintenance","PACKDBF","DBFNAME","DBFNAME","1",false,"S"]
["PAYOUTS","Register Payouts By Date","PAYOUTS","DATE+PAYREASON","DTOS(DATE)+PAYREASON","0",false,"H"]
["PAYOUTS","Payouts by Reason+Date","PAYREASN","PAYREASON+DATE","PAYREASON+DTOS(DATE)","0",false,null]
["PAYOUTS","Payouts Sorted By Vendor","PAYVENDR","STR(VENDOR,5)+DATE+PAYREASON","STR(VENDOR,5)+PAYREASON+DTOS(DATE)","0",false,null]
["PAYTYPES","Payout Types/Reason Codes","PAYTYPES","PAYREASON","PAYREASON","1",false,"S"]
["PAYTYPES","Payout Reason Names Sort","PAYRENAM","UPPER(LEFT(DESCRIPT,8))","UPPER(LEFT(DESCRIPT,8))","0",false,"S"]
["PRINTERS","Printer Driver File",null,null,null,null,false,"S"]
["PRODTOTL","Work File for Sales Analysis",null,null,null,null,false,"H"]
["RECVITEM","PO/Receiving Items","RECVITEM","REF_NUM",null,"0",false,"H"]
["RECVLOG","PO/Receiving Log","RECVLOG","REF_NUM",null,"0",false,"H"]
["SETLIST","SKU Sets List","SETLIST","SET_NUMBER","SET_NUMBER","1",false,"S"]
["SKUFILE","SKU Numbers By Category","SKUCATEG","DEPT+CATEGORY+UPPER(LEFT(DESCRIPT,6))","DEPT+CATEGORY+UPPER(LEFT(DESCRIPT,6))","0",false,"S"]
["SKUFILE","SKU File By SKU Numbers","SKUCODE","SKUCODE","SKUCODE","1",false,"S"]
["SKUSETS","SKU Numbers For Sets","SKUSETS","SET_NUMBER","SET_NUMBER","0",false,"S"]
["TAXCODES","Customer Taxcodes","TAXCODES","TAXTYPE+TAXCATEG",null,"1",false,"S"]
["TENDDATA","Extended Tendering Info","TENDDATA","STR(INVOICE,8)+TENDERNUM","STR(INVOICE,8)+TENDERNUM","0",false,"H"]
["TENDLOG","Transaction Log By Number","TENDNUMB","INVOICE","INVOICE","0",false,"H"]
["TENDLOG","Transaction Log By Date","TENDDATE","DATE","DATE","0",false,null]
["TENDLOG","Transaction Log By Customer","TENDCUST","CUSTNUMB","CUSTNUMB","0",false,null]
["TENDTYPE","Tender Choices File",null,null,null,null,false,"S"]
["TOTAL","Register Totals By Date","TOTALS","DATE","DATE","0",false,"H"]
["VENDORS","Vendors by Number","VENDNUMB","VENDOR","VENDOR","1",false,"A"]
["VENDORS","Vendors by Name","VENDNAME","UPPER(LEFT(NAME,8))","UPPER(LEFT(NAME,8))","0",false,null]
["WEEKCAL","Fiscal Week Calendar","WEEKCAL","END","END","1",false,"S"]
["WORKDATA","Work Station Information",null,null,null,null,false,"S"]
["ZIPCODES","City ZIP / Postal Codes","ZIPCODES","POSTALCODE","POSTALCODE","1",false,"A"]
["REPORTS","Report Menu Options","REPORTS","RPTREFNUM",null,"1",false,"S"]
["RECVLOG","Received Items Log - By Date","RECPDATE","POST_DATE",null,"0",false,null]