Micros Res 3700 Database Table Details

[Robin Hobb]

Dear all,

We are planning to fetch the data from one of our Micros RES 3700 Database so what the tables details to fetch the below mentioned values:

Net Sales
Total Revenue
Total Discounts
Total Voids
Total Returns
Total Charged Tips
Order Types Values
Total Payments

Kindly help. Thanks.

 

[POSKitchen]

There is a hidden/to activate in the poscfg, existing DB Schema Report

https://workdrive.zohopublic.eu/ext...575c6bc7fcd14545ee2e0903bf1e0cf000f23a6bfa765

- One other possibility is to use a 3rd party API application like

https://omnivore.io

- Check_3700 is a special Store Procedure that extract the check details to new tables in a better structure.

- you can use the table and query more information from the definiton tables like micros.rvc_def, micros.uws_def , micros.mi_def, micros.mi_price_def etc...
micros.trans_archive_dtl

- or query over a few tables (but you have to check for duplicates, because of transfer and splitting checks)

only 14 DAYS in the table
micros.dtl
micros.trans_dtl
micros.chk_dtl
micros.chk_info_dtl
micros.chk_xfer_dtl
for more details of these tables you need to query the sequence number for mi_def, maj_grp_def, fam_grp_def, mi_price_def

Tracking Tables and Historical Totals
all Tables start with micros.dly_*
micros.dly_sys_ttl
micros.dly_sys_trk_ttl
micros.dly_rvc_ttl
micros.dly_rvc_trk_ttl
etc.