Owner Revenue Detail

• period_start (required): Production period start (YYYY-MM-DD)
• period_end (required): Production period end (YYYY-MM-DD)
• company_code (optional): Default '200'
• owner_code (optional): Filter to specific owner
• well_code (optional): Filter to specific well

Output Columns

• Company
• Owner Code
• Owner Name
• Well Code
• Well Name
• Production Date
• Product
• Interest Type
• Decimal Interest
• Net Volume
• Net Value
• Taxes
• Deductions
• Paid Amount
• Suspended
• Netted
• Balance

Excel Output

• Tab: "Owner Revenue Detail"
• Grouping: By owner and well
• Subtotals: By product
• Grand Total: Included
• Freeze: Row 5
• File: Owner Revenue Detail - {period_start} to {period_end}.xlsx

Notes

• Excludes redistributed items (payment_status_id = 8) at model build time
• Detailed reconciliation of all accounting adjustments
• Balance field tracks unresolved suspense or payment variances