Getting Room Number From Micros?

[petersoftware]

Hi,
I'm new to this forum but have found it appears to be a great source of Micros information. Recently I have been asked to integrate a system with Micros 3700. The aim of this integration is to get out of the Micros database any charges that have been made to a room. Our Micros is currently integrated with Fidelio and the users can post charges to rooms by typing the room number into the Micros frontend. We are now moving away from Fidelio due to cost but keeping Micros.

I have found the micros.trans_dtl table that contains many of the transactions but I cannot find any reference to charges being made to a room.

Can anyone help?

 

[tektipstim]

are you pushing the info to the PMS on a transaction basis, or are you looking to do a daily import

 

[pmegan]

It depends on how the PMS interface is written. I'd start by looking in the chk_info_dtl table.