Micros 3700 database Get Order details

[RitwickGupta]

I am wondering how to get details of an order from a micros 3700 database. I want to perform a function where I can get details of all the orders created between two specific time period. Details like

1. Order number and Check number
2. Customer Info
3. Menu items details, quantity, price
4. Discounts
5. Payment details

Is there a documentation which explains exactly what is stored in each table in the Database?

Thanks

 

[Moregelen]

Take a look at Sybase on your test server. You can use it to browse the table structure. The Chk_Dtl table will contain information about the check, but you will have to go to another table linked to chk_dtl to get anything more informative. You are also really better off using the transaction archive tables if you're trying to rebuild a check.

There really ins't any documentation anywhere on the table structure; or if there is, I have no idea where it might be. Basically you just have to browse the tables to find what you want.

 

[RitwickGupta]

Yeah. I have been going through different tables trying to make sense. I check the trans_archive_dtl table, but it's not up to date, i.e. it does not have the very recent checks. why is that? Any idea?

 

[Moregelen]

You will have to run the stored procedure to post all of that information. It is an easier table to deal with, but it is setup similar to polling. You have to setup an autosequence to post the information every 10/15 minutes (or have your script do it).

 

[RitwickGupta]

On another note, I made an interface in Micros POS Configurator and am trying to TxMsg some info to an server. I can easily send all that information though TxMsg on local ip address i.e. 127.0.0.1:8099 but I am not able to send it to an external server. Do you have any idea why? My POS is in Demo mode, can that be an issue?

Thanks a lot

 

[Moregelen]

Shouldn't make a difference; if you can send messages at all shouldn't matter where you are sending them. Check your various firewall rules for the other server.

 

[RitwickGupta]

Hmmm that's weird. I tried sending packets through hyperterminal to the same server and it worked, but doesn't work when using micros. Even though time out is 60 seconds, it says "No response" after like 5 seconds. :S

 

[jmercado27]

Hello Moregelen and RitwickGupta

I am so glad I found this forum I was wondering if you could tell me:

What is the name of the stored Proc to get the
Current Menu items details, quantity, price (excluding items that have been moved from one ticket to another or split)
in other words, the current state of a check, Of any open check?

Any help you can provide would be very much appreciated.

Thank you!!!