Quick question for those that may be able to help.
I have been going through some of the truckloads of tables that Micros employs and I'm stuck at the moment.
Are there any ways in which items are linked to other items when they are being used as modifiers?
For example, if a user rings in a "Margarita" and then modifies it with a "w/Patron" modifier are they linked other than simply being the next increment for D_dtl_seq when they are both making use of the same Transaction number?
I would essentially like to not simply have a report that says X number of items were rang in and then Y number of modifiers were rang in as that doesn't correlate the two for me. Instead, I would like to find out how many "Margaritas w/Patron" bartenders have rang in for the week.
I have been going through some of the truckloads of tables that Micros employs and I'm stuck at the moment.
Are there any ways in which items are linked to other items when they are being used as modifiers?
For example, if a user rings in a "Margarita" and then modifies it with a "w/Patron" modifier are they linked other than simply being the next increment for D_dtl_seq when they are both making use of the same Transaction number?
I would essentially like to not simply have a report that says X number of items were rang in and then Y number of modifiers were rang in as that doesn't correlate the two for me. Instead, I would like to find out how many "Margaritas w/Patron" bartenders have rang in for the week.