I need to write a query containing the following on each line:

1. The DocNum of each ORPC, OPCH and OPOR,

2. The NumAtCard from OPCH

3. The DocTotal from OPCH / ORPC or from OPOR if OPCH does not yet exist.

Is this possible?