1.1. 背景
背景:现有虾皮接口账单报告数据,进行更新调优
1.2. 验收目标
1. 虾皮Payout ,对应详情费用对接 ( 2个接口 )
2. 现有虾皮Payout 报告逻辑调整
3. 添加自定义报告,对应按时间条件下载数据
2. 功能设计
2.1. 业务流程
无
2.2.1 操作路径
1. 自定义报告 ---虾皮Payout报告
2. 自定义报告 ---虾皮Payout详情报告
2.2.3 虾皮Payout ,对应详情费用对接 ( 2个接口 )
2.2.3.1 功能点描述:
原设计:无
新增:这个主接口[RB_Shopee_Payout_Detail]是已经下载了,这次是关联主接口的详情信息下载。
Documentation - Shopee Open Platform https://open.shopee.com/documents/v2/v2.payment.get_payout_detail?module=97&type=1
接口详情1:
|
|
|||
|
The total amount that the seller is expected to receive for the order.
|
|||
|
The currency used for calculating escrow amount.
|
|||
|
Shopee's unique identifier for an order.
|
接口详情2:
|
The list of offline adjustments.
|
|||
|
The amount of offline adjustments.
|
|||
|
The reason for offline adjustment.
|
|||
|
The remark for the reason.
|
|||
|
The scenario of adjustment.
|
|||
|
Dimension of offline adjustment. Available value: shop, order.
|
|||
|
Shopee's unique identifier for an order.
|
2.2.3 现有虾皮Payout 报告逻辑调整
2.2.3.1 功能点描述:
原设计:存在重复,及下漏数据,


调整:按字段应不会出现重复,并且下载数据无遗漏
"payout_info":
"from_currency":"VND",
"payout_currency":"USD",
"from_amount":591797912,
"payout_amount":25678.64,
"exchange_rate":"0.00",
"payout_time":1651842208,
"pay_service":"Payoneer",
"payee_id":"279016275538"
2.2.3 添加自定义报告,对应按时间条件下载数据
2.2.3.1 功能点描述:
原设计:无
新增
增加 1份自定义报告,实现按业务时间,来源渠道进行下载。
1. 虾皮V2payout报告(RB_Shopee_Payout_Detail)


https://alidocs.dingtalk.com/i/nodes/OBldywvrKxo89qvjeMpw8Qk2ngpNbLz4?iframeQuery=mode%3D2%26sheetId%3Dsheet1