Add cybersource payment transaction fields to combined order mart and its upstream

[rachellougee]

What are the relevant tickets?

https://github.com/mitodl/hq/issues/4775

Description (What does it do?)

Adding a few cybersource transaction fields and unit_price used in https://bi.odl.mit.edu/queries/1189 and https://bi.odl.mit.edu/queries/1190/ to martscombinedorders and its upstream models

• receipt_authorization_code - This is the authorization code from the payment transaction, or the approvalCode from the refund transaction since the mart table is unique on order_id +line_id but MITx Online has two transactions for refunded orders (addressing the issue raised in https://github.mit.edu/mitxonline/mitxonline-issues/issues/218)
• receipt_payment_transaction_uuid
• receipt_payment_transaction_type
• receipt_payment_amount
• receipt_payment_currency
• receipt_payment_card_number
• receipt_payment_card_type
• receipt_payer_name
• receipt_payer_email
• receipt_payer_ip_address
• receipt_payment_method
• unit_price

How can this be tested?

dbt build --select +martscombinedorders

or

dbt build --select intmitxonlineecommerce_order dbt build --select +intmitxonlineecommerce_transaction dbt build --select intmicromastersorders dbt build --select intmitxproecommerce_order dbt build --select +intmitxproecommerce_receipt dbt build --select +intbootcampsecommerce_receipt dbt build --select +intbootcampsecommerce_order dbt build --select martscombinedorders

[rachellougee]

My only question is whether we should remove the fields from staging as well? the main concern is are they currently being used elsewhere? But builds, definitions, and code look great so approving

Thanks for the review. To answer your questions about removing these fields from staging, I've replaced their references with intermediate so there shouldn't be anywhere else. The usage can be found in the lineage graph in the right corner https://mitodl.github.io/ol-data-platform/#!/model/model.open_learning.stg__bootcamps__app__postgres__ecommerce_receipt

https://mitodl.github.io/ol-data-platform/#!/model/model.open_learning.stg__mitxpro__app__postgres__ecommerce_receipt

I figured it's easier to handle these fields directly in intermediate so we don't have to copy paste these fields from staging to intermediate.