深圳智汇创想科技有限公司

需求背景：每个月需要下载一次紫鸟的回款账单，而在财务同事核对沃尔玛紫鸟账单时需要一个个去下载账单进行核对以保持数据的准确性，这会降低财务核对账单的效率且无法快速结账。

需求风险：无

目标用户：财务

影响页面：无，不涉及页面改动或页面关联的数据改动

详细内容：

每月制定计划去拉取沃尔玛店铺的回款账单数据时，对获取回来的数据表进行解析到表

相关RAP

Walmart-CA站放款账单下载（RPA_ID：1656941496）
放款账单下载-US（RPA_ID：165900062）

1、当下载US站点的放款账单时，获取回来的CSV文件包含“Payment-Details-Report”时，解析到US站回款账单结果表
2、当下载CA站点的放款账单时，获取回来的CSV文件包含“Payment_Reports”时，解析到CA站回款账单结果表1

3、当下载CA站点的放款账单时，获取回来的CSV文件没有包含“Payment_Reports”时，解析到CA站回款账单结果表2

解析要求：原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期+计划ID

US回款账单（回款账单结果表字段）：

Walmart.com Order #
Walmart.com Order Line #
Walmart.com PO #
Walmart.com P.O. Line #
Partner Order #
Transaction Type
Transaction Date Time
Shipped Qty
Partner Item ID
Partner GTIN
Partner Item name
Product tax code
Shipping tax code
Gift wrap tax code
Ship to state
Ship to county
County Code
Ship to city
Zip code
shipping_method
Total tender to / from customer
Payable to Partner from Sale
Commission from Sale
Commission Rate
Gross Sales Revenue
Refunded Retail Sales
Sales refund for Escalation
Gross Shipping Revenue
Gross Shipping Refunded
Shipping refund for Escalation
Net Shipping Revenue
Gross Fee Revenue
Gross Fee Refunded
Fee refund for Escalation
Net Fee Revenue
Gift Wrap Quantity
Gross Gift-Wrap Revenue
Gross Gift-Wrap Refunded
Gift wrap refund for Escalation
Net Gift Wrap Revenue
Tax on Sales Revenue
Tax on Shipping Revenue
Tax on Gift-Wrap Revenue
Tax on Fee Revenue
Effective tax rate
Tax on Refunded Sales
Tax on Shipping Refund
Tax on Gift-Wrap Refund
Tax on Fee Refund
Tax on Sales refund for Escalation
Tax on Shipping Refund for Escalation
Tax on Gift-Wrap Refund for escalation
Tax on Fee Refund for escalation
Total NET Tax Collected
Tax Withheld
Adjustment Description
Adjustment Code
Original Item price
Original Commission Amount
Spec Category
Contract Category
Product Type
Flex Commission Rule
Return Reason Code
Return Reason Description
Fee Withheld Flag
Fulfillment Type
Fulfillment Details
Commission Incentive Program
Commission Saving
Customer Promo Type

CA站点回款账单（CA站回款账单结果表1）：

Sales Order ID
Sales Order Line Number
Purchase Order ID
Purchase Order Line Number
Transaction Type
Customer Invoice Number
Customer Invoice Date
Seller Invoice Number
Seller Invoice Date
Seller Invoice Disposition Date
Shipped Qty
Offer ID
Walmart SKU ID
Seller SKU ID
Product Tax Code
Item Name
GTIN
Ship To City
Ship to Province
Postal Code
Shipping Method
Line Amount
Line Shipping Charge
Line Fee
Line Tax
PST/QST Remit by Seller
PST/QST Remit by Walmart
GST/HST Remit by Seller
GST/HST Remit by Walmart
Tender From Customer
Referral Rate
Referral Amount
Effective Tax Rate
Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)
WFS Fee Type
WFS Fee Amount
WFS PST/QST (QST-1016551356TQ0001)
WFS GST/HST (GST/HST - 137466199RT0001)
WFS Transaction ID
Payable To Partner

CA站点账单汇总（CA站回款账单结果表2）：

Settlement Date
Opening Balance
Net Sales
Total from Other Activities
Paid to You
Closing Balance