hotpot填充品牌单预付金额
direct-us
hotpot修改国内外账号时间属性ad_typesss_username
topmedia-platform：更新账号汇总表
Task：AsyncMediaAccountInfo
SNS
拉account_daily_invoice_report_data 拿revenue
读topmedia_account_info表
充值/减款
dashboard和hotpot报表
授信变更
程序审批：授信是否足够
select sum(balance)from (SELECT case when task_type = 'recharge' then amount_usd else -amount_usd end as balance FROM `hp_fund_task` WHERE (`id` IN (SELECT DISTINCT `parent_id` FROM `hp_fund_sub_task` WHERE `sss_adv_id` = '9094')) AND (`task_status` = 'finished') ORDER BY `updated_time` DESC LIMIT 20) a
DB:hp_recharge_record
API：refresh-account-info/settlement
Task：AsyncSettlementAccountInfo
API：refresh-account-info/balance
adv_credit_balance
aws_sns_send_record
facebook：facebook_account
API调用
topmedia-task：更新媒体余额表
5 分钟一次
tencent：tencent_funds
DB:hp_fund_task
Doris：bi_3ss_fn_adv_credit_info
开始
select *from aws_sns_send_recordwhere sender = 'topmedia-platform' and message_type='sss_user_name:balance'order by created_at desc;
topmedia_account_info
hotpot 审批通过并充值完成
35 * * * *
接口，提供实时授信
3S：by username刷授信
头条：toutiao_advertiser_balance
拉CRM拿授信
hotpot
hotpot新增/编辑，国内/海外账号
hotpot/rechage-system/子账户
SNS
CRM
tiktok：tiktok_advertiser_balance
http://3s-yapi.mobvista.com/project/257/interface/api/4899
agency 发起充值/减款请求
Task：更新余额表
大媒体
