There are 2 files you will need to query, MNBDD and RMCACL.
MNBDD file holds the billing details of all invoices.
RMCACL file holds the name of the CAT/CLASS/SUB-CLASS. Using the part# in the MNBDD file, you can determine which CAT/CLASS/SUB-CLASS it is.
Selection Criteria:
BDBC = T (T means rental invoices)
BDIN = ? (question mark here indicates non-serialized item)
- You may also want to add a date range
The part number is in the BDDES field, and the sale amount is in the BDPRC field.
How to Join the files:
In order to get the CAT/CLASS/SUB-CLASS, you will need to join this file to the RMCACL file.
Join as follows:
BDCO = RBCO
BDDIV = RBDIV
BDBR = RBBR
BDDES = RBPART