Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alaughlin

    Micros 3700 - Get individual payments for a ticket

    hosehead78, thanks so much!
  2. alaughlin

    Micros 3700 - Get individual payments for a ticket

    I suppose that's what I need? But even a more detailed breakdown probably Basically if there's 3 payments applied to a check: 1. Cash, $5.00, $2.00 tip 2. Cash, $7.50, $3.00 tip 3. Visa, $5.00, $3.00 tip I need those 3 separate records
  3. alaughlin

    Micros 3700 - Get individual payments for a ticket

    Hey all, I see that in the table micros.dtl, a record with a dtl_type of 'T' is inserted when a ticket is paid off and closed, with the tender type and final amount. However, I'm looking to grab all the individual payments on a ticket and can't seem to find that anywhere. Can someone point me...
  4. alaughlin

    Get all current items on a check in Micros 3700 (besides split/voided items)

    Let me clarify, this is just a problem with items removed via a split I can easily grab voided items using the void_type column
  5. alaughlin

    Get all current items on a check in Micros 3700 (besides split/voided items)

    Hey all, I've been able to query the database for all the items on a specific check. The problem is, this result also includes items there removed via a split. I've discovered some rows that are created when this split happens, with a record_type of "N" and a dtl_type of "D". However, I don't...
  6. alaughlin

    Decoding Aloha's TRANS.LOG

    thread693-1701321 Hello everyone, I've referenced a previous thread, where user hellbender3069 started to decode Aloha's TRANS.LOG file. I'm attempting to interpret other actions in the log file, and I'm wondering how hellbender3069 figured out how to interpret the binary data. Has anyone else...

Part and Inventory Search

Back
Top