Skip to content

Instantly share code, notes, and snippets.

@meetchandan
Created March 12, 2025 08:58
Show Gist options
  • Save meetchandan/6009abc5293d088801d568b95776a884 to your computer and use it in GitHub Desktop.
Save meetchandan/6009abc5293d088801d568b95776a884 to your computer and use it in GitHub Desktop.
select
mu.id_partner,
mu.statement_date,
mu.statement_nr,
mu.currency_code,
ft.name_en as fee_name,
mu.unique_line_ref1 as item_nr,
mu.delta_amount as amount
from noonbiprosel.mpst_union.mpst_union mu
left join noondwh.mpst.fee_type_v2 ft on ft.zsku= mu.zsku
where ft.name_en in ('Minutes Referral Fee', 'Minutes Referral Fee Adjustment', 'Minutes Replenishment Fee', 'Minutes Coupon Discount', 'Minutes Outbound Fee')
limit 50
@meetchandan
Copy link
Author

meetchandan commented Mar 12, 2025

what details would sellers need

  • price at which it item was sold?
  • commission charged / referral fee
  • outbound fee
    unique on item_nr

storage fee - on a monthly basis?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment