任务描述
暂无
需求描述

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:

escrow_list
object[]
escrow_amount
float
20865.0
The total amount that the seller is expected to receive for the order.
currency
string
VND
The currency used for calculating escrow amount.
order_sn
string
220404NF3CFFNY
Shopee's unique identifier for an order.

接口详情2:

offline_adjustment_list
object[]
The list of offline adjustments.
adjustment_amount
float
2.0
The amount of offline adjustments.
module
string
Commission Fee
The reason for offline adjustment.
remark
string
DRC commission fee adjustment
The remark for the reason.
scenario
string
Commission Fee Adjustment
The scenario of adjustment.
adjustment_level
string
shop
Dimension of offline adjustment. Available value: shop, order.
order_sn
string
220322JUMMT0S0
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)

验收标准
暂无
历史记录  
  1. 2022-11-21 09:19:34, 由 林鸿贵 创建。
  2. 2022-11-21 09:20:04, 由 林鸿贵 指派给 林鸿贵。
    修改了 指派给,旧值为 "xuruifeng",新值为 "linhonggui"。
  3. 2022-11-21 09:20:55, 由 林鸿贵 编辑。
    修改了 开发组 ,旧值为 "",新值为 "1"。
    修改了 截止日期,旧值为 "0000-00-00",新值为 "2022-11-29"。
    修改了 任务名称,区别为:
    001- 虾皮payout详情对接
    001+ 虾皮payout详情对接---测试执行
    001- 虾皮payout详情对接
    001+ 虾皮payout详情对接---测试执行
    修改了 任务描述,区别为:
    001- 1.1. 背景
    001+
    002-
    003- 背景:现有虾皮接口账单报告数据,进行更新调优
    004-
    005- 1.2.验收目标
    006-
    007- 1. 虾皮Payout ,对应详情费用对接 ( 2个接口 )
    008- 2. 现有虾皮Payout 报告逻辑调整
    009- 3. 添加自定义报告,对应按时间条件下载数据
    010-
    011- 2. 功能设计
    012- 2.1. 业务流程
    013- 无
    014- 2.2.1 操作路径
    015- 1. 自定义报告 ---虾皮Payout报告
    016- 2. 自定义报告 ---虾皮Payout详情报告
    017-
    018- 2.2.3虾皮Payout ,对应详情费用对接 ( 2个接口 )
    019- 2.2.3.1 功能点描述:
    020- 原设计:无
    021-
    022- 新增:这个主接口[RB_Shopee_Payout_Detail]是已经下载了,这次是关联主接口的详情信息下载。
    023- <a href="https://open.shopee.com/documents/v2/v2.payment.get_payout_detail?module=97&amp;type=1">Documentation - Shopee Open Platform https://open.shopee.com/documents/v2/v2.payment.get_payout_detail?module=97&amp;type=1
    024- 接口详情1:
    025-
    026-
    027-
    028-
    029- escrow_list
    030-
    031-
    032-
    033-
    034-
    035-
    036- object[]
    037-
    038-
    039-
    040-
    041-
    042-
    043-
    044-
    045-
    046-
    047-
    048-
    049-
    050-
    051-
    052-
    053-
    054-
    055-
    056-
    057-
    058-
    059-
    060-
    061-
    062-
    063-
    064-
    065-
    066-
    067-
    068-
    069-
    070-
    071-
    072-
    073-
    074-
    075-
    076-
    077- escrow_amount
    078-
    079-
    080-
    081-
    082-
    083-
    084- float
    085-
    086-
    087-
    088-
    089-
    090-
    091- 20865.0
    092-
    093-
    094-
    095-
    096-
    097- The total amount that the seller is expected to receive for the order.
    098-
    099-
    100-
    101-
    102-
    103-
    104-
    105-
    106-
    107-
    108-
    109-
    110-
    111-
    112-
    113-
    114-
    115-
    116-
    117-
    118-
    119-
    120-
    121-
    122-
    123-
    124-
    125- currency
    126-
    127-
    128-
    129-
    130-
    131-
    132- string
    133-
    134-
    135-
    136-
    137-
    138-
    139- VND
    140-
    141-
    142-
    143-
    144-
    145- The currency used for calculating escrow amount.
    146-
    147-
    148-
    149-
    150-
    151-
    152-
    153-
    154-
    155-
    156-
    157-
    158-
    159-
    160-
    161-
    162-
    163-
    164-
    165-
    166-
    167-
    168-
    169-
    170-
    171-
    172-
    173- order_sn
    174-
    175-
    176-
    177-
    178-
    179-
    180- string
    181-
    182-
    183-
    184-
    185-
    186-
    187- 220404NF3CFFNY
    188-
    189-
    190-
    191-
    192-
    193- Shopee's unique identifier for an order.
    194-
    195-
    196-
    197-
    198- 接口详情2:
    199-
    200-
    201-
    202-
    203- offline_adjustment_list
    204-
    205-
    206-
    207-
    208-
    209-
    210- object[]
    211-
    212-
    213-
    214-
    215-
    216-
    217-
    218-
    219-
    220-
    221-
    222-
    223- The list of offline adjustments.
    224-
    225-
    226-
    227-
    228-
    229-
    230-
    231-
    232-
    233-
    234-
    235-
    236-
    237-
    238-
    239-
    240-
    241-
    242-
    243-
    244-
    245-
    246-
    247-
    248-
    249- adjustment_amount
    250-
    251-
    252-
    253-
    254-
    255-
    256- float
    257-
    258-
    259-
    260-
    261-
    262-
    263- 2.0
    264-
    265-
    266-
    267-
    268-
    269- The amount of offline adjustments.
    270-
    271-
    272-
    273-
    274-
    275-
    276-
    277-
    278-
    279-
    280-
    281-
    282-
    283-
    284-
    285-
    286-
    287-
    288-
    289-
    290-
    291-
    292-
    293-
    294-
    295- module
    296-
    297-
    298-
    299-
    300-
    301-
    302- string
    303-
    304-
    305-
    306-
    307-
    308-
    309- Commission Fee
    310-
    311-
    312-
    313-
    314-
    315- The reason for offline adjustment.
    316-
    317-
    318-
    319-
    320-
    321-
    322-
    323-
    324-
    325-
    326-
    327-
    328-
    329-
    330-
    331-
    332-
    333-
    334-
    335-
    336-
    337-
    338-
    339-
    340-
    341- remark
    342-
    343-
    344-
    345-
    346-
    347-
    348- string
    349-
    350-
    351-
    352-
    353-
    354-
    355- DRC commission fee adjustment
    356-
    357-
    358-
    359-
    360-
    361- The remark for the reason.
    362-
    363-
    364-
    365-
    366-
    367-
    368-
    369-
    370-
    371-
    372-
    373-
    374-
    375-
    376-
    377-
    378-
    379-
    380-
    381-
    382-
    383-
    384-
    385-
    386-
    387- scenario
    388-
    389-
    390-
    391-
    392-
    393-
    394- string
    395-
    396-
    397-
    398-
    399-
    400-
    401- Commission Fee Adjustment
    402-
    403-
    404-
    405-
    406-
    407- The scenario of adjustment.
    408-
    409-
    410-
    411-
    412-
    413-
    414-
    415-
    416-
    417-
    418-
    419-
    420-
    421-
    422-
    423-
    424-
    425-
    426-
    427-
    428-
    429-
    430-
    431-
    432-
    433- adjustment_level
    434-
    435-
    436-
    437-
    438-
    439-
    440- string
    441-
    442-
    443-
    444-
    445-
    446-
    447- shop
    448-
    449-
    450-
    451-
    452-
    453- Dimension of offline adjustment. Available value: shop, order.
    454-
    455-
    456-
    457-
    458-
    459-
    460-
    461-
    462-
    463-
    464-
    465-
    466-
    467-
    468-
    469-
    470-
    471-
    472-
    473-
    474-
    475-
    476-
    477-
    478-
    479- order_sn
    480-
    481-
    482-
    483-
    484-
    485-
    486- string
    487-
    488-
    489-
    490-
    491-
    492-
    493- 220322JUMMT0S0
    494-
    495-
    496-
    497-
    498-
    499- Shopee's unique identifier for an order.
    500-
    501-
    502-
    503-
    504-
    505- 2.2.3现有虾皮Payout 报告逻辑调整
    506- 2.2.3.1 功能点描述:
    507- 原设计:存在重复,及下漏数据,
    508- <img src="/zentao/file-read-222499.png" alt="" />
    509- <img src="/zentao/file-read-222500.png" alt="" />
    510-
    511- 调整:按字段应不会出现重复,并且下载数据无遗漏
    512- "payout_info":
    513- "from_currency":"VND",
    514- "payout_currency":"USD",
    515- "from_amount":591797912,
    516- "payout_amount":25678.64,
    517- "exchange_rate":"0.00",
    518- "payout_time":1651842208,
    519- "pay_service":"Payoneer",
    520- "payee_id":"279016275538"
    521-
    522-
    523-
    524-
    525-
    526- 2.2.3添加自定义报告,对应按时间条件下载数据
    527- 2.2.3.1 功能点描述:
    528- 原设计:无
    529-
    530- 新增
    531- 增加 1份自定义报告,实现按业务时间,来源渠道进行下载。
    532- 1. 虾皮V2payout报告(RB_Shopee_Payout_Detail)
    001- <h2 style="color:#141414;font-size:14px;background-color:#FFFFFF;margin-left:1cm;text-indent:-1cm;">1.1. 背景</h2>
    001+
    002- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"><br /></p>
    003- <p style="font-size:14px;background-color:#FFFFFF;"> 背景:现有虾皮接口账单报告数据,进行更新调优</p>
    004- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    005- <p class="MsoListParagraph" style="font-size:14px;text-indent:0cm;background-color:#FFFFFF;"><span style="font-size:16px;"><span style="font-weight:700;">1.2.验收目标</span></span></p>
    006- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    007- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"> 1. 虾皮Payout ,对应详情费用对接 ( 2个接口 )<span style="color:#113366;font-family:Roboto;"> </span></p>
    008- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"><span style="color:#113366;font-family:Roboto;"><span style="font-size:14px;background-color:#FFFFFF;"> 2. 现有虾皮Payout 报告逻辑调整</span><br /></span></p>
    009- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"><span style="color:#113366;font-family:Roboto;"><span style="color:#113366;font-family:Roboto;"></span><span style="color:#113366;font-family:Roboto;"> 3. 添加自定义报告,对应按时间条件下载数据</span></span></p>
    010- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"><br /></p>
    011- <p class="MsoListParagraph" style="font-size:14px;text-indent:0cm;background-color:#FFFFFF;"><span style="font-size:16px;"><span style="font-weight:700;">2. 功能设计</span></span></p>
    012- <h2 style="color:#141414;font-size:14px;background-color:#FFFFFF;margin-left:1cm;text-indent:-1cm;">2.1. 业务流程</h2>
    013- <p style="font-size:14px;background-color:#FFFFFF;">无</p>
    014- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.1 操作路径</h3>
    015- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#000000;">1. 自定义报告 ---</span><span style="font-size:12px;background-color:#D2E0F0;">虾皮Payout报告</span></p>
    016- <p style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:12px;background-color:#D2E0F0;"><span style="font-size:14px;color:#000000;">2. 自定义报告 ---</span><span style="font-size:12px;background-color:#D2E0F0;">虾皮Payout详情报告</span><br /></span></p>
    017- <p class="p" style="margin-left:0pt;font-size:14px;text-indent:0pt;background-color:#FFFFFF;"><br /></p>
    018- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3<span style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:14px;background-color:#FFFFFF;">虾皮Payout ,对应详情费用对接 ( 2个接口 )</span><span style="font-size:14px;color:#113366;font-family:Roboto;"> </span></span></span></h3>
    019- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3.1 功能点描述:</h3>
    020- <p style="font-size:14px;background-color:#FFFFFF;">原设计:无</p>
    021- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    022- <p style="font-size:14px;background-color:#FFFFFF;">新增:这个主接口<span style="font-size:14px;background-color:#FFFFFF;">[RB_Shopee_Payout_Detail]</span>是已经下载了,这次是关联主接口的详情信息下载。</p>
    023- <p style="font-size:14px;background-color:#FFFFFF;"><a href="https://open.shopee.com/documents/v2/v2.payment.get_payout_detail?module=97&amp;type=1">Documentation - Shopee Open Platform</a> https://open.shopee.com/documents/v2/v2.payment.get_payout_detail?module=97&amp;type=1</p>
    024- <p style="font-size:14px;background-color:#FFFFFF;">接口详情1:</p>
    025- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#113366;font-family:Roboto;">
    026- </span></p><table class="basic-table" style="padding:0px;color:#333333;border-collapse:separate;font-family:Roboto;"><tbody class="basic-table-body"><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    027- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    028- <div class="table-cell-container" style="margin:0px;padding:0px;">
    029- <div class="table-cell-content" style="margin:0px;padding:0px;">escrow_list</div>
    030- </div>
    031- </div>
    032- </td>
    033- <td class="basic-table-data-cell expandable-td">
    034- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    035- <div class="table-cell-container" style="margin:0px;padding:0px;">
    036- <div class="table-cell-content" style="margin:0px;padding:0px;">object[]</div>
    037- </div>
    038- </div>
    039- </td>
    040- <td class="basic-table-data-cell expandable-td">
    041- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    042- <div class="table-cell-container" style="margin:0px;padding:0px;">
    043- <div class="table-cell-content" style="margin:0px;padding:0px;"></div>
    044- </div>
    045- </div>
    046- </td>
    047- <td class="basic-table-data-cell expandable-td">
    048- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    049- <div class="discription-rich-text" style="margin:0px;padding:0px;"></div>
    050- </div>
    051- </td>
    052- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    053- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    054- <div class="indentations-box" style="margin:0px;padding:0px;">
    055- <div class="indentation-box" style="margin:0px;padding:0px;">
    056- <div style="margin:0px;padding:0px;"></div>
    057- </div>
    058- <div class="indentation-box" style="margin:0px;padding:0px;">
    059- <div style="margin:0px;padding:0px;"></div>
    060- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    061- </div>
    062- <div class="indentation-box" style="margin:0px;padding:0px;">
    063- <div style="margin:0px;padding:0px;"></div>
    064- <div class="ancestor-box" style="margin:0px;padding:0px;">
    065- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    066- </div>
    067- </div>
    068- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    069- <div style="margin:0px;padding:0px;"></div>
    070- <div class="ancestor-box" style="margin:0px;padding:0px;">
    071- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    072- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    073- </div>
    074- </div>
    075- </div>
    076- <div class="table-cell-container" style="margin:0px;padding:0px;">
    077- <div class="table-cell-content" style="margin:0px;padding:0px;">escrow_amount</div>
    078- </div>
    079- </div>
    080- </td>
    081- <td class="basic-table-data-cell expandable-td">
    082- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    083- <div class="table-cell-container" style="margin:0px;padding:0px;">
    084- <div class="table-cell-content" style="margin:0px;padding:0px;">float</div>
    085- </div>
    086- </div>
    087- </td>
    088- <td class="basic-table-data-cell expandable-td">
    089- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    090- <div class="table-cell-container" style="margin:0px;padding:0px;">
    091- <div class="table-cell-content" style="margin:0px;padding:0px;">20865.0</div>
    092- </div>
    093- </div>
    094- </td>
    095- <td class="basic-table-data-cell expandable-td">
    096- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    097- <div class="discription-rich-text" style="margin:0px;padding:0px;">The total amount that the seller is expected to receive for the order.</div>
    098- </div>
    099- </td>
    100- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    101- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    102- <div class="indentations-box" style="margin:0px;padding:0px;">
    103- <div class="indentation-box" style="margin:0px;padding:0px;">
    104- <div style="margin:0px;padding:0px;"></div>
    105- </div>
    106- <div class="indentation-box" style="margin:0px;padding:0px;">
    107- <div style="margin:0px;padding:0px;"></div>
    108- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    109- </div>
    110- <div class="indentation-box" style="margin:0px;padding:0px;">
    111- <div style="margin:0px;padding:0px;"></div>
    112- <div class="ancestor-box" style="margin:0px;padding:0px;">
    113- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    114- </div>
    115- </div>
    116- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    117- <div style="margin:0px;padding:0px;"></div>
    118- <div class="ancestor-box" style="margin:0px;padding:0px;">
    119- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    120- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    121- </div>
    122- </div>
    123- </div>
    124- <div class="table-cell-container" style="margin:0px;padding:0px;">
    125- <div class="table-cell-content" style="margin:0px;padding:0px;">currency</div>
    126- </div>
    127- </div>
    128- </td>
    129- <td class="basic-table-data-cell expandable-td">
    130- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    131- <div class="table-cell-container" style="margin:0px;padding:0px;">
    132- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    133- </div>
    134- </div>
    135- </td>
    136- <td class="basic-table-data-cell expandable-td">
    137- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    138- <div class="table-cell-container" style="margin:0px;padding:0px;">
    139- <div class="table-cell-content" style="margin:0px;padding:0px;">VND</div>
    140- </div>
    141- </div>
    142- </td>
    143- <td class="basic-table-data-cell expandable-td">
    144- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    145- <div class="discription-rich-text" style="margin:0px;padding:0px;">The currency used for calculating escrow amount.</div>
    146- </div>
    147- </td>
    148- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    149- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    150- <div class="indentations-box" style="margin:0px;padding:0px;">
    151- <div class="indentation-box" style="margin:0px;padding:0px;">
    152- <div style="margin:0px;padding:0px;"></div>
    153- </div>
    154- <div class="indentation-box" style="margin:0px;padding:0px;">
    155- <div style="margin:0px;padding:0px;"></div>
    156- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    157- </div>
    158- <div class="indentation-box" style="margin:0px;padding:0px;">
    159- <div style="margin:0px;padding:0px;"></div>
    160- <div class="ancestor-box" style="margin:0px;padding:0px;">
    161- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    162- </div>
    163- </div>
    164- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    165- <div style="margin:0px;padding:0px;"></div>
    166- <div class="ancestor-box" style="margin:0px;padding:0px;">
    167- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    168- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    169- </div>
    170- </div>
    171- </div>
    172- <div class="table-cell-container" style="margin:0px;padding:0px;">
    173- <div class="table-cell-content" style="margin:0px;padding:0px;">order_sn</div>
    174- </div>
    175- </div>
    176- </td>
    177- <td class="basic-table-data-cell expandable-td">
    178- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    179- <div class="table-cell-container" style="margin:0px;padding:0px;">
    180- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    181- </div>
    182- </div>
    183- </td>
    184- <td class="basic-table-data-cell expandable-td">
    185- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    186- <div class="table-cell-container" style="margin:0px;padding:0px;">
    187- <div class="table-cell-content" style="margin:0px;padding:0px;">220404NF3CFFNY</div>
    188- </div>
    189- </div>
    190- </td>
    191- <td class="basic-table-data-cell expandable-td">
    192- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    193- <div class="discription-rich-text" style="margin:0px;padding:0px;">Shopee's unique identifier for an order.</div>
    194- </div>
    195- </td>
    196- </tr></tbody></table>
    197- <p style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:14px;background-color:#FFFFFF;"></span></p>
    198- <p style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:14px;background-color:#FFFFFF;"><span style="font-size:14px;background-color:#FFFFFF;">接口详情2</span>:</span></p>
    199- <p style="font-size:14px;background-color:#FFFFFF;">
    200- </p><table class="basic-table" style="padding:0px;color:#333333;border-collapse:separate;font-family:Roboto;"><tbody class="basic-table-body"><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    201- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    202- <div class="table-cell-container" style="margin:0px;padding:0px;">
    203- <div class="table-cell-content" style="margin:0px;padding:0px;">offline_adjustment_list</div>
    204- </div>
    205- </div>
    206- </td>
    207- <td class="basic-table-data-cell expandable-td">
    208- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    209- <div class="table-cell-container" style="margin:0px;padding:0px;">
    210- <div class="table-cell-content" style="margin:0px;padding:0px;">object[]</div>
    211- </div>
    212- </div>
    213- </td>
    214- <td class="basic-table-data-cell expandable-td">
    215- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    216- <div class="table-cell-container" style="margin:0px;padding:0px;">
    217- <div class="table-cell-content" style="margin:0px;padding:0px;"></div>
    218- </div>
    219- </div>
    220- </td>
    221- <td class="basic-table-data-cell expandable-td">
    222- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    223- <div class="discription-rich-text" style="margin:0px;padding:0px;">The list of offline adjustments.</div>
    224- </div>
    225- </td>
    226- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    227- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    228- <div class="indentations-box" style="margin:0px;padding:0px;">
    229- <div class="indentation-box" style="margin:0px;padding:0px;">
    230- <div style="margin:0px;padding:0px;"></div>
    231- </div>
    232- <div class="indentation-box" style="margin:0px;padding:0px;">
    233- <div style="margin:0px;padding:0px;"></div>
    234- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    235- </div>
    236- <div class="indentation-box" style="margin:0px;padding:0px;">
    237- <div style="margin:0px;padding:0px;"></div>
    238- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    239- </div>
    240- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    241- <div style="margin:0px;padding:0px;"></div>
    242- <div class="ancestor-box" style="margin:0px;padding:0px;">
    243- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    244- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    245- </div>
    246- </div>
    247- </div>
    248- <div class="table-cell-container" style="margin:0px;padding:0px;">
    249- <div class="table-cell-content" style="margin:0px;padding:0px;">adjustment_amount</div>
    250- </div>
    251- </div>
    252- </td>
    253- <td class="basic-table-data-cell expandable-td">
    254- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    255- <div class="table-cell-container" style="margin:0px;padding:0px;">
    256- <div class="table-cell-content" style="margin:0px;padding:0px;">float</div>
    257- </div>
    258- </div>
    259- </td>
    260- <td class="basic-table-data-cell expandable-td">
    261- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    262- <div class="table-cell-container" style="margin:0px;padding:0px;">
    263- <div class="table-cell-content" style="margin:0px;padding:0px;">2.0</div>
    264- </div>
    265- </div>
    266- </td>
    267- <td class="basic-table-data-cell expandable-td">
    268- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    269- <div class="discription-rich-text" style="margin:0px;padding:0px;">The amount of offline adjustments.</div>
    270- </div>
    271- </td>
    272- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    273- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    274- <div class="indentations-box" style="margin:0px;padding:0px;">
    275- <div class="indentation-box" style="margin:0px;padding:0px;">
    276- <div style="margin:0px;padding:0px;"></div>
    277- </div>
    278- <div class="indentation-box" style="margin:0px;padding:0px;">
    279- <div style="margin:0px;padding:0px;"></div>
    280- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    281- </div>
    282- <div class="indentation-box" style="margin:0px;padding:0px;">
    283- <div style="margin:0px;padding:0px;"></div>
    284- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    285- </div>
    286- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    287- <div style="margin:0px;padding:0px;"></div>
    288- <div class="ancestor-box" style="margin:0px;padding:0px;">
    289- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    290- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    291- </div>
    292- </div>
    293- </div>
    294- <div class="table-cell-container" style="margin:0px;padding:0px;">
    295- <div class="table-cell-content" style="margin:0px;padding:0px;">module</div>
    296- </div>
    297- </div>
    298- </td>
    299- <td class="basic-table-data-cell expandable-td">
    300- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    301- <div class="table-cell-container" style="margin:0px;padding:0px;">
    302- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    303- </div>
    304- </div>
    305- </td>
    306- <td class="basic-table-data-cell expandable-td">
    307- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    308- <div class="table-cell-container" style="margin:0px;padding:0px;">
    309- <div class="table-cell-content" style="margin:0px;padding:0px;">Commission Fee</div>
    310- </div>
    311- </div>
    312- </td>
    313- <td class="basic-table-data-cell expandable-td">
    314- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    315- <div class="discription-rich-text" style="margin:0px;padding:0px;">The reason for offline adjustment.</div>
    316- </div>
    317- </td>
    318- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    319- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    320- <div class="indentations-box" style="margin:0px;padding:0px;">
    321- <div class="indentation-box" style="margin:0px;padding:0px;">
    322- <div style="margin:0px;padding:0px;"></div>
    323- </div>
    324- <div class="indentation-box" style="margin:0px;padding:0px;">
    325- <div style="margin:0px;padding:0px;"></div>
    326- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    327- </div>
    328- <div class="indentation-box" style="margin:0px;padding:0px;">
    329- <div style="margin:0px;padding:0px;"></div>
    330- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    331- </div>
    332- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    333- <div style="margin:0px;padding:0px;"></div>
    334- <div class="ancestor-box" style="margin:0px;padding:0px;">
    335- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    336- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    337- </div>
    338- </div>
    339- </div>
    340- <div class="table-cell-container" style="margin:0px;padding:0px;">
    341- <div class="table-cell-content" style="margin:0px;padding:0px;">remark</div>
    342- </div>
    343- </div>
    344- </td>
    345- <td class="basic-table-data-cell expandable-td">
    346- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    347- <div class="table-cell-container" style="margin:0px;padding:0px;">
    348- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    349- </div>
    350- </div>
    351- </td>
    352- <td class="basic-table-data-cell expandable-td">
    353- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    354- <div class="table-cell-container" style="margin:0px;padding:0px;">
    355- <div class="table-cell-content" style="margin:0px;padding:0px;">DRC commission fee adjustment</div>
    356- </div>
    357- </div>
    358- </td>
    359- <td class="basic-table-data-cell expandable-td">
    360- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    361- <div class="discription-rich-text" style="margin:0px;padding:0px;">The remark for the reason.</div>
    362- </div>
    363- </td>
    364- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    365- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    366- <div class="indentations-box" style="margin:0px;padding:0px;">
    367- <div class="indentation-box" style="margin:0px;padding:0px;">
    368- <div style="margin:0px;padding:0px;"></div>
    369- </div>
    370- <div class="indentation-box" style="margin:0px;padding:0px;">
    371- <div style="margin:0px;padding:0px;"></div>
    372- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    373- </div>
    374- <div class="indentation-box" style="margin:0px;padding:0px;">
    375- <div style="margin:0px;padding:0px;"></div>
    376- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    377- </div>
    378- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    379- <div style="margin:0px;padding:0px;"></div>
    380- <div class="ancestor-box" style="margin:0px;padding:0px;">
    381- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    382- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    383- </div>
    384- </div>
    385- </div>
    386- <div class="table-cell-container" style="margin:0px;padding:0px;">
    387- <div class="table-cell-content" style="margin:0px;padding:0px;">scenario</div>
    388- </div>
    389- </div>
    390- </td>
    391- <td class="basic-table-data-cell expandable-td">
    392- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    393- <div class="table-cell-container" style="margin:0px;padding:0px;">
    394- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    395- </div>
    396- </div>
    397- </td>
    398- <td class="basic-table-data-cell expandable-td">
    399- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    400- <div class="table-cell-container" style="margin:0px;padding:0px;">
    401- <div class="table-cell-content" style="margin:0px;padding:0px;">Commission Fee Adjustment</div>
    402- </div>
    403- </div>
    404- </td>
    405- <td class="basic-table-data-cell expandable-td">
    406- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    407- <div class="discription-rich-text" style="margin:0px;padding:0px;">The scenario of adjustment.</div>
    408- </div>
    409- </td>
    410- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    411- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    412- <div class="indentations-box" style="margin:0px;padding:0px;">
    413- <div class="indentation-box" style="margin:0px;padding:0px;">
    414- <div style="margin:0px;padding:0px;"></div>
    415- </div>
    416- <div class="indentation-box" style="margin:0px;padding:0px;">
    417- <div style="margin:0px;padding:0px;"></div>
    418- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    419- </div>
    420- <div class="indentation-box" style="margin:0px;padding:0px;">
    421- <div style="margin:0px;padding:0px;"></div>
    422- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    423- </div>
    424- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    425- <div style="margin:0px;padding:0px;"></div>
    426- <div class="ancestor-box" style="margin:0px;padding:0px;">
    427- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    428- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    429- </div>
    430- </div>
    431- </div>
    432- <div class="table-cell-container" style="margin:0px;padding:0px;">
    433- <div class="table-cell-content" style="margin:0px;padding:0px;">adjustment_level</div>
    434- </div>
    435- </div>
    436- </td>
    437- <td class="basic-table-data-cell expandable-td">
    438- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    439- <div class="table-cell-container" style="margin:0px;padding:0px;">
    440- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    441- </div>
    442- </div>
    443- </td>
    444- <td class="basic-table-data-cell expandable-td">
    445- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    446- <div class="table-cell-container" style="margin:0px;padding:0px;">
    447- <div class="table-cell-content" style="margin:0px;padding:0px;">shop</div>
    448- </div>
    449- </div>
    450- </td>
    451- <td class="basic-table-data-cell expandable-td">
    452- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    453- <div class="discription-rich-text" style="margin:0px;padding:0px;">Dimension of offline adjustment. Available value: shop, order.</div>
    454- </div>
    455- </td>
    456- </tr><tr class="basic-table-row"><td class="basic-table-data-cell expandable-td">
    457- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    458- <div class="indentations-box" style="margin:0px;padding:0px;">
    459- <div class="indentation-box" style="margin:0px;padding:0px;">
    460- <div style="margin:0px;padding:0px;"></div>
    461- </div>
    462- <div class="indentation-box" style="margin:0px;padding:0px;">
    463- <div style="margin:0px;padding:0px;"></div>
    464- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    465- </div>
    466- <div class="indentation-box" style="margin:0px;padding:0px;">
    467- <div style="margin:0px;padding:0px;"></div>
    468- <div class="ancestor-box" style="margin:0px;padding:0px;"></div>
    469- </div>
    470- <div class="indentation-box" style="margin:0px 4px 0px 0px;padding:0px;">
    471- <div style="margin:0px;padding:0px;"></div>
    472- <div class="ancestor-box" style="margin:0px;padding:0px;">
    473- <div class="ancestor-line" style="margin:0px;padding:0px;"></div>
    474- <div class="horizontal-line" style="margin:0px;padding:0px;"></div>
    475- </div>
    476- </div>
    477- </div>
    478- <div class="table-cell-container" style="margin:0px;padding:0px;">
    479- <div class="table-cell-content" style="margin:0px;padding:0px;">order_sn</div>
    480- </div>
    481- </div>
    482- </td>
    483- <td class="basic-table-data-cell expandable-td">
    484- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    485- <div class="table-cell-container" style="margin:0px;padding:0px;">
    486- <div class="table-cell-content" style="margin:0px;padding:0px;">string</div>
    487- </div>
    488- </div>
    489- </td>
    490- <td class="basic-table-data-cell expandable-td">
    491- <div class="expandable-td-container" style="margin:0px;padding:0px;">
    492- <div class="table-cell-container" style="margin:0px;padding:0px;">
    493- <div class="table-cell-content" style="margin:0px;padding:0px;">220322JUMMT0S0</div>
    494- </div>
    495- </div>
    496- </td>
    497- <td class="basic-table-data-cell expandable-td">
    498- <div class="content-slot-td-container" style="margin:0px;padding:0px;">
    499- <div class="discription-rich-text" style="margin:0px;padding:0px;">Shopee's unique identifier for an order.</div>
    500- </div>
    501- </td>
    502- </tr></tbody></table><p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    503- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    504- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    505- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3<span style="color:#113366;font-family:Roboto;font-size:14px;background-color:#FFFFFF;">现有虾皮Payout 报告逻辑调整</span><span style="color:#113366;font-family:Roboto;"> </span></h3>
    506- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3.1 功能点描述:</h3>
    507- <p style="font-size:14px;background-color:#FFFFFF;">原设计:存在重复,及下漏数据,</p>
    508- <p style="font-size:14px;background-color:#FFFFFF;"><img src="/zentao/file-read-222499.png" alt="" /></p>
    509- <p style="font-size:14px;background-color:#FFFFFF;"><img src="/zentao/file-read-222500.png" alt="" /></p>
    510- <p><br /></p>
    511- <p style="font-size:14px;background-color:#FFFFFF;">调整:按字段应不会出现重复,并且下载数据无遗漏</p>
    512- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"payout_info":</span></span></p>
    513- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"from_currency":"VND",</span></span></p>
    514- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"payout_currency":"USD",</span></span></p>
    515- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"from_amount":591797912,</span></span></p>
    516- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"payout_amount":25678.64,</span></span></p>
    517- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"exchange_rate":"0.00",</span></span></p>
    518- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"payout_time":1651842208,</span></span></p>
    519- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"pay_service":"Payoneer",</span></span></p>
    520- <p style="font-size:14px;background-color:#FFFFFF;"><span style="color:#333333;font-family:Roboto;"><span style="color:#333333;font-family:Roboto;">"payee_id":"279016275538"</span></span></p>
    521- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    522- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    523- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    524- <p style="font-size:14px;background-color:#FFFFFF;"><span style="font-weight:700;color:#113366;font-family:Roboto;"><br /></span></p>
    525- <p style="font-size:14px;background-color:#FFFFFF;"><span style="font-weight:700;color:#113366;font-family:Roboto;"> </span></p>
    526- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3<span style="color:#113366;font-family:Roboto;"><span style="color:#113366;font-family:Roboto;">添加自定义报告,对应按时间条件下载数据</span></span><span style="color:#113366;font-family:Roboto;"> </span></h3>
    527- <h3 style="color:#141414;font-size:14px;background-color:#FFFFFF;">2.2.3.1 功能点描述:</h3>
    528- <p style="font-size:14px;background-color:#FFFFFF;">原设计:无</p>
    529- <p style="font-size:14px;background-color:#FFFFFF;"><br /></p>
    530- <p style="font-size:14px;background-color:#FFFFFF;">新增</p>
    531- <p style="font-size:14px;background-color:#FFFFFF;">增加 1份自定义报告,实现按业务时间,来源渠道进行下载。</p>
    532- <p style="font-size:14px;background-color:#FFFFFF;">1. 虾皮V2payout报告(<span style="color:#113366;font-family:Roboto;"><span style="font-size:14px;background-color:#FFFFFF;">RB_Shopee_Payout_Detail</span></span>)</p>
  4. 2022-11-21 14:38:40, 由 林鸿贵 添加备注。

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

  5. 2022-11-24 20:09:55, 由 林鸿贵 完成。
    修改了 总计消耗,旧值为 "0",新值为 "5"。
    修改了 实际完成,旧值为 "",新值为 "2022-11-24 20:08:33"。
    修改了 任务状态,旧值为 "wait",新值为 "done"。
    修改了 实际开始,旧值为 "0000-00-00 00:00:00",新值为 "2022-11-24 20:09:55"。
    修改了 预计剩余,旧值为 "16",新值为 "0"。
    修改了 由谁完成,旧值为 "",新值为 "linhonggui"。

    验证场景:

    1、执行服务后查看对应表是否有新增数据


    SELECT * from  RB_Shopee_Payout_Detail;

    SELECT * from  RB_Shopee_Payout_Escrow;

    SELECT * from  RB_Shopee_Payout_Adjustment;


    2、自定义报告上线由开发自己配置


  6. 2022-11-24 20:09:59, 由 林鸿贵 关闭。
    修改了 任务状态,旧值为 "done",新值为 "closed"。
    修改了 指派给 ,旧值为 "linhonggui",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "linhonggui"。
    修改了 关闭时间,旧值为 "0000-00-00 00:00:00",新值为 "2022-11-24 20:09:59"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
所属迭代 技术研发中心 11月第2版本(2022年)
所属模块 /
相关需求 虾皮payout详情对接
指派给 Closed 于 2022-11-24 20:09:59
任务类型 测试
任务标签 初始
开发组 百货开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给
由谁创建 林鸿贵 于 2022-11-21 09:19:34
由谁完成 林鸿贵 于 2022-11-24 20:08:33
由谁取消 暂无
由谁关闭 林鸿贵 于 2022-11-24 20:09:59
关闭原因 已完成
最后编辑 林鸿贵 于 2022-11-24 20:09:59
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 16工时
总计消耗 5工时
预计剩余 0工时
预计开始 0000-00-00
实际开始 2022-11-24
截止日期 2022-11-29