Why Are Some Refunded or Cancelled Shopify Orders Missing From the Destination?

We sync refunded and canceled orders to different tables based on the reason:

• Out-of-stock refunds appear in the ORDER_ADJUSTMENT table, not in the ORDER_LINE_REFUND table.
• Canceled orders appear in the ORDER_LINE_REFUND table, not in the ORDER_ADJUSTMENT table.