To pull both information about the payment and the order, you have the following options:
- You can pull the Order side of the transaction instead of the payment side. Pull any payment information from the "Sales Order/Sales Order Payment/Revenue" node. Note: If you are also pulling back office payments, you can add the field: "Application Details\Application is not equal to Order." This field will remove any payments that are applied to orders and leave the back office payments in your query results.
- You can also use a Sales Order Query and pull any payment information from the Sales Order Payment Node.