Greetings –
We’re having challenges reading some transactional information from our Micros 3700 database to post into our internal data warehouse.
We’ve gotten fairly familiar with the various tables (We’re already pulling transactional Pmix, Tenders, and discounts) but cannot seem to extract two critical components.
First, we can’t seem to extract void details. Ideally we’d like to get trans_dtl.trans_seq, from which we should be able to extract the check number, item number, price, and authorizing manager. For some reason, the void flags (dtl.void_type, sale_dtl.void_cnt, sale_dtl.void_ttl, sale_dtl.mgr_void_cnt, sale_dtl.mgr_void_ttl, and reason_def’s aren’t giving us the results we’d expect.
Second, we’d like to be able to extract issued gift certificates (including the GC number, the selling employee, check, etc).
Can anyone help?
Much appreciated,
Alex
We’re having challenges reading some transactional information from our Micros 3700 database to post into our internal data warehouse.
We’ve gotten fairly familiar with the various tables (We’re already pulling transactional Pmix, Tenders, and discounts) but cannot seem to extract two critical components.
First, we can’t seem to extract void details. Ideally we’d like to get trans_dtl.trans_seq, from which we should be able to extract the check number, item number, price, and authorizing manager. For some reason, the void flags (dtl.void_type, sale_dtl.void_cnt, sale_dtl.void_ttl, sale_dtl.mgr_void_cnt, sale_dtl.mgr_void_ttl, and reason_def’s aren’t giving us the results we’d expect.
Second, we’d like to be able to extract issued gift certificates (including the GC number, the selling employee, check, etc).
Can anyone help?
Much appreciated,
Alex