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

[alaughlin]

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 see any way to relate these records to the original records that were created when these items were ordered. Has anyone figured this out?

Thanks

 

[alaughlin]

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

 

[mvelazquez]

You can give an example?