[Feature] Update determination of discount line item in recharge__charge_line_item_history

[fivetran-catfritz]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Currently, in recharge__charge_line_item_history, the discount line items are calculated. The intent was to provide a separate line item for each discount that may have been used, however this is proving to over-calculate discounts per an investigation with @fivetran-joemarkiewicz today. This is because discounts are reported as percentages from the DISCOUNT table rather than dollar amounts.

This should be revised to provide only one line item for discounts using the total_discounts from charge as the discount amount, so we get the actual amount and not rely on a calculation.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response