Computer Ease Technical Support "Solutions That Make Profits Easier"

ceFoundation Data Dictionary

This page provides information for clients migrating from RCS and Just Ask to ceFoundation and MySQL. ceFoundation uses a database management system from a leader in the database field, MySQL.  This database provides increased performance and advanced data access capabilities.  Further, MySQL coupled with Crystal Reports, Microsoft Access, or other tools provides advanced reporting on information within your ceFoundation application. The below table contains the most common ceFoundation definitions along with their Just Ask equivalents.  If you are re-creating a Just Ask sentence to, say, a Crystal Reports report, the following information will be useful. MySQL Table Name Just Ask File Name Description APVEND APVEND Accounts payable vendor master ARHSINVC ARHIST Accounts receivable invoice history ARHSPYMT ARHIST Accounts receivable payment history AROPINVC AROPEN Accounts receivable open invoice AROPPYMT AROPEN Accounts receivable payment CUSMESS CUSMESS Customer master extra information CUSTFILE CUST Customer master EQPTNON EQNON Non-serial equipment EQPT2 EQPT2 Equipment information extra, both serial and non-serial EQPTSER EQSER Serial equipment HISTCMNT HSCOMM Contract history - comment HISTDELV HSDEL Contract history - delivery information HISTDEP HSDEP Contract history - deposits and payments HISTHDR HSHDR Contract history - header information HISTMILE HSMIL Contract history - meter information HISTPU HSPU Contract history - pickup information HISTRENT HSREN Contract history - rental equipment HISTRT20 HSRET Contract history - retail sales HISTRT21 HSRET Contract history - retail sales HISTRT22 HSRET Contract history - retail sales HISTRT30 HSRET Contract history - retail sales HISTRT31 HSRET Contract history - retail sales HISTRT32 HSRET Contract history - retail sales HISTUSED HSSAL Contract history - new and used sale of equipment HISTSEC HSSEC Contract history - security deposits HISTTOT HSTOT Contract history - totals INVMST20 INV Inventory master INVMST21 INV Inventory master INVMST22 INV Inventory master INVMST30 INV Inventory master INVMST31 INV Inventory master INVMST32 INV Inventory master OPENCMNT OPCOM Open contract - comment OPENDELV OPDEL Open contract - delivery information OPENDEP OPDEP Open contract - deposits and payments OPENHDR OPHDR Open contract - header information OPENMILE OPMIL Open contract - meter information OPENPU OPPU Open contract - pickup information OPENRENT OPREN Open contract - rental equipment OPENRT20 OPRET Open contract - sale of retail items OPENRT21 OPRET Open contract - sale of retail items OPENRT22 OPRET Open contract - sale of retail items OPENRT30 OPRET Open contract - sale of retail items OPENRT31 OPRET Open contract - sale of retail items OPENRT32 OPRET Open contract - sale of retail items OPENUSED OPSAL Open contract - new and used sale of equipment OPENSEC OPSEC Open contract - security deposits OPENTOT OPTOT Open contract - totals PARTS20 PARTS Parts master PARTS21 PARTS Parts master PARTS22 PARTS Parts master PARTS30 PARTS Parts master PARTS31 PARTS Parts master PARTS32 PARTS Parts master