业务需求
需求描述

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

需求风险:无

目标用户:财务

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

详细内容:

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


相关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+采集时间+回款日期


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





验收标准
价值描述
财务核对沃尔玛紫鸟账单是需要一个个去下载账单进行核对,这会影响财务核对账单的效率。优化后预计可节省0.5人天/月
历史记录  
  1. 2023-01-28 16:18:25, 由 梁贵荣 创建。
  2. 2023-01-29 13:59:50, 由 梁贵荣 编辑。
    修改了 所属模块,旧值为 "1678",新值为 "1679"。
  3. 2023-01-31 08:50:10, 由 刘灿 编辑。
    修改了 指派给,旧值为 "Admin186",新值为 "lihuiyun"。
  4. 2023-01-31 13:48:40, 由 梁贵荣 变更。
    修改了 版本号 ,旧值为 "1",新值为 "2"。
    修改了 需求描述,区别为:
    010- 当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    010+ 1、当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表2、当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    011- 当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    011+ 3、当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    013- US回款账单(回款账单结果表字段):
    013+ 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    014- Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    014+
    015-
    015+ US回款账单(回款账单结果表字段):
    016-
    016+ Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    017- CA站点回款账单(CA站回款账单结果表1):
    017+
    018- Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    018+
    019-
    019+ CA站点回款账单(CA站回款账单结果表1):
    020-
    020+ Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    021-
    021+
    022- CA站点账单汇总(CA站回款账单结果表2):
    022+
    023- Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    023+
    024-
    024+ CA站点账单汇总(CA站回款账单结果表2):
    025-
    025+ Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    026-
    026+
    027-
    027+
    028+
    029+
    010- <p><span style="font-size:14px;"><span style="font-size:14px;">当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    010+ <p><span style="font-size:14px;"><span style="font-size:14px;">1、当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">2、当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    011- <p><span style="font-size:14px;"><span style="font-size:14px;">当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    011+ <p><span style="font-size:14px;"><span style="font-size:14px;">3、当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    013- <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    013+ <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    014- <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p><div><br /></div>
    014+ <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    015- <br />
    015+ <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    016- <p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    016+ <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p>
    017- <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    017+ <div><br /></div>
    018- <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    018+ <br /><p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    019- <div></div>
    019+ <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    020- <p><br /></p>
    020+ <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    021- <p><img src="{238790.png}" alt="" /></p>
    021+ <div></div>
    022- <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    022+ <p><br /></p>
    023- <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    023+ <p><img src="{238790.png}" alt="" /></p>
    024- <p><span style="font-size:14px;"><br /></span></p>
    024+ <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    025- <p><span style="font-size:14px;"></span></p>
    025+ <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    026- <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    026+ <p><span style="font-size:14px;"><br /></span></p>
    027- <p><span style="font-size:14px;"><br /><br /></span></p>
    027+ <p><span style="font-size:14px;"></span></p>
    028+ <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    029+ <p><span style="font-size:14px;"><br /><br /></span></p>
  5. 2023-01-31 17:54:47, 由 梁贵荣 变更。
    修改了 版本号 ,旧值为 "2",新值为 "3"。
    修改了 需求描述,区别为:
    002-
    002+ 需求风险:无
    003- 需求风险:无
    003+ 目标用户:财务
    004- 需求内容:
    004+ 影响页面:无,不涉及页面改动
    005- 每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表
    005+
    006-
    006+ 详细内容:
    007- 相关RAP
    007+ 每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表
    008- Walmart-CA站放款账单下载(RPA_ID:1656941496)放款账单下载-US(RPA_ID:165900062)
    008+
    009-
    009+ 相关RAP
    010- 1、当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表2、当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    010+ Walmart-CA站放款账单下载(RPA_ID:1656941496)放款账单下载-US(RPA_ID:165900062)
    011- 3、当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    011+
    012-
    012+ 1、当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表2、当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    013- 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    013+ 3、当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    015- US回款账单(回款账单结果表字段):
    015+ 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    016- Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    016+
    017-
    017+ US回款账单(回款账单结果表字段):
    018-
    018+ Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    019- CA站点回款账单(CA站回款账单结果表1):
    019+
    020- Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    020+
    021-
    021+ CA站点回款账单(CA站回款账单结果表1):
    022-
    022+ Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    023-
    023+
    024- CA站点账单汇总(CA站回款账单结果表2):
    024+
    025- Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    025+
    026-
    026+ CA站点账单汇总(CA站回款账单结果表2):
    027-
    027+ Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    028-
    028+
    029-
    029+
    030+
    031+
    002- <p><br /></p>
    002+ <p><span style="font-size:14px;">需求风险:无</span></p>
    003- <p><span style="font-size:14px;">需求风险:无</span></p>
    003+ <p><span style="font-size:14px;">目标用户:财务</span></p>
    004- <p><span style="font-size:14px;">需求内容:</span></p>
    004+ <p><span style="font-size:14px;">影响页面:无,不涉及页面改动</span></p>
    005- <p><span style="font-size:14px;">每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表</span></p>
    005+ <p><span style="font-size:14px;"><br /></span></p>
    006- <p><span style="font-size:14px;"><br /></span></p>
    006+ <p><span style="font-size:14px;">详细内容:</span></p>
    007- <p><span style="font-size:14px;">相关RAP</span></p>
    007+ <p><span style="font-size:14px;">每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表</span></p>
    008- <p><span style="font-size:14px;">Walmart-CA站放款账单下载(<span style="font-size:14px;">RPA_ID:1656941496</span>)<br />放款账单下载-US(<span style="font-size:14px;">RPA_ID:165900062</span>)</span></p>
    008+ <p><span style="font-size:14px;"><br /></span></p>
    009- <p><br /></p>
    009+ <p><span style="font-size:14px;">相关RAP</span></p>
    010- <p><span style="font-size:14px;"><span style="font-size:14px;">1、当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">2、当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    010+ <p><span style="font-size:14px;">Walmart-CA站放款账单下载(<span style="font-size:14px;">RPA_ID:1656941496</span>)<br />放款账单下载-US(<span style="font-size:14px;">RPA_ID:165900062</span>)</span></p>
    011- <p><span style="font-size:14px;"><span style="font-size:14px;">3、当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    011+ <p><br /></p>
    012- <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    012+ <p><span style="font-size:14px;"><span style="font-size:14px;">1、当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">2、当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    013- <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    013+ <p><span style="font-size:14px;"><span style="font-size:14px;">3、当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    015- <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    015+ <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    016- <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p>
    016+ <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    017- <div><br /></div>
    017+ <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    018- <br /><p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    018+ <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p>
    019- <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    019+ <div><br /></div>
    020- <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    020+ <br /><p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    021- <div></div>
    021+ <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    022- <p><br /></p>
    022+ <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    023- <p><img src="{238790.png}" alt="" /></p>
    023+ <div></div>
    024- <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    024+ <p><br /></p>
    025- <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    025+ <p><img src="{238790.png}" alt="" /></p>
    026- <p><span style="font-size:14px;"><br /></span></p>
    026+ <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    027- <p><span style="font-size:14px;"></span></p>
    027+ <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    028- <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    028+ <p><span style="font-size:14px;"><br /></span></p>
    029- <p><span style="font-size:14px;"><br /><br /></span></p>
    029+ <p><span style="font-size:14px;"></span></p>
    030+ <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    031+ <p><span style="font-size:14px;"><br /><br /></span></p>
  6. 2023-01-31 17:57:27, 由 梁贵荣 变更。
    修改了 版本号 ,旧值为 "3",新值为 "4"。
    修改了 需求描述,区别为:
    001- 需求背景:每个月需要下载一次紫鸟的回款账单,而在财务同事核对沃尔玛紫鸟账单时需要一个个去下载账单进行核对以保持数据的准确性,这会降低财务核对账单的效率且无法快速结账。
    001+ 需求背景:每个月需要下载一次紫鸟的回款账单,而在财务同事核对沃尔玛紫鸟账单时需要一个个去下载账单进行核对以保持数据的准确性,这会降低财务核对账单的效率且无法快速结账。
    002- 需求风险:无
    002+ 需求风险:无
    003- 目标用户:财务
    003+ 目标用户:财务
    004- 影响页面:无,不涉及页面改动
    004+ 影响页面:无,不涉及页面改动或页面关联的数据改动
    005-
    005+ 详细内容:
    006- 详细内容:
    006+ 每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表
    007- 每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表
    007+
    008-
    008+ 相关RAP
    009- 相关RAP
    009+ Walmart-CA站放款账单下载(RPA_ID:1656941496)放款账单下载-US(RPA_ID:165900062)
    010- Walmart-CA站放款账单下载(RPA_ID:1656941496)放款账单下载-US(RPA_ID:165900062)
    010+
    011-
    011+ 1、当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表2、当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    012- 1、当下载US站点的放款账单时,获取回来的CSV文件包含“Payment-Details-Report”时,解析到US站回款账单结果表2、当下载CA站点的放款账单时,获取回来的CSV文件包含“Payment_Reports”时,解析到CA站回款账单结果表1
    012+ 3、当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    013- 3、当下载CA站点的放款账单时,获取回来的CSV文件没有包含“Payment_Reports”时,解析到CA站回款账单结果表2
    013+
    014-
    014+ 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    015- 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    015+
    016-
    016+ US回款账单(回款账单结果表字段):
    017- US回款账单(回款账单结果表字段):
    017+ Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    018- Walmart.com Order #Walmart.com Order Line #Walmart.com PO #Walmart.com P.O. Line #Partner Order #Transaction TypeTransaction Date TimeShipped QtyPartner Item IDPartner GTINPartner Item nameProduct tax codeShipping tax codeGift wrap tax codeShip to stateShip to countyCounty CodeShip to cityZip codeshipping_methodTotal tender to / from customerPayable to Partner from SaleCommission from SaleCommission RateGross Sales RevenueRefunded Retail SalesSales refund for EscalationGross Shipping RevenueGross Shipping RefundedShipping refund for EscalationNet Shipping RevenueGross Fee RevenueGross Fee RefundedFee refund for EscalationNet Fee RevenueGift Wrap QuantityGross Gift-Wrap RevenueGross Gift-Wrap RefundedGift wrap refund for EscalationNet Gift Wrap RevenueTax on Sales RevenueTax on Shipping RevenueTax on Gift-Wrap RevenueTax on Fee RevenueEffective tax rateTax on Refunded SalesTax on Shipping RefundTax on Gift-Wrap RefundTax on Fee RefundTax on Sales refund for EscalationTax on Shipping Refund for EscalationTax on Gift-Wrap Refund for escalationTax on Fee Refund for escalationTotal NET Tax CollectedTax WithheldAdjustment DescriptionAdjustment CodeOriginal Item priceOriginal Commission AmountSpec CategoryContract CategoryProduct TypeFlex Commission RuleReturn Reason CodeReturn Reason DescriptionFee Withheld FlagFulfillment TypeFulfillment DetailsCommission Incentive ProgramCommission SavingCustomer Promo Type
    018+
    019-
    019+
    020-
    020+ CA站点回款账单(CA站回款账单结果表1):
    021- CA站点回款账单(CA站回款账单结果表1):
    021+ Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    022- Sales Order IDSales Order Line NumberPurchase Order IDPurchase Order Line NumberTransaction TypeCustomer Invoice NumberCustomer Invoice DateSeller Invoice NumberSeller Invoice DateSeller Invoice Disposition DateShipped QtyOffer IDWalmart SKU IDSeller SKU IDProduct Tax CodeItem NameGTINShip To CityShip to ProvincePostal CodeShipping MethodLine AmountLine Shipping ChargeLine FeeLine TaxPST/QST Remit by SellerPST/QST Remit by WalmartGST/HST Remit by SellerGST/HST Remit by WalmartTender From CustomerReferral RateReferral AmountEffective Tax RateReferral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)WFS Fee TypeWFS Fee AmountWFS PST/QST (QST-1016551356TQ0001)WFS GST/HST (GST/HST - 137466199RT0001)WFS Transaction IDPayable To Partner
    022+
    023-
    023+
    024-
    024+
    025-
    025+ CA站点账单汇总(CA站回款账单结果表2):
    026- CA站点账单汇总(CA站回款账单结果表2):
    026+ Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    027- Settlement DateOpening BalanceNet SalesTotal from Other ActivitiesPaid to YouClosing Balance
    027+
    028-
    028+
    029-
    029+
    030-
    030+
    031-
    001- <p><span style="font-size:14px;">需求背景:每个月需要下载一次紫鸟的回款账单,而在财务同事核对沃尔玛紫鸟账单时需要一个个去下载账单进行核对以保持数据的准确性,这会降低财务核对账单的效率且无法快速结账。</span></p>
    001+ <p><span style="font-size:14px;"><strong>需求背景:</strong>每个月需要下载一次紫鸟的回款账单,而在财务同事核对沃尔玛紫鸟账单时需要一个个去下载账单进行核对以保持数据的准确性,这会降低财务核对账单的效率且无法快速结账。</span></p>
    002- <p><span style="font-size:14px;">需求风险:无</span></p>
    002+ <p><span style="font-size:14px;"><strong>需求风险:</strong>无</span></p>
    003- <p><span style="font-size:14px;">目标用户:财务</span></p>
    003+ <p><span style="font-size:14px;"><strong>目标用户:</strong>财务</span></p>
    004- <p><span style="font-size:14px;">影响页面:无,不涉及页面改动</span></p>
    004+ <p><span style="font-size:14px;"><strong>影响页面:</strong>无,不涉及页面改动或页面关联的数据改动</span></p>
    005- <p><span style="font-size:14px;"><br /></span></p>
    005+ <p><span style="font-size:14px;"><strong>详细内容:</strong></span></p>
    006- <p><span style="font-size:14px;">详细内容:</span></p>
    006+ <p><span style="font-size:14px;">每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表</span></p>
    007- <p><span style="font-size:14px;">每月制定计划去拉取沃尔玛店铺的回款账单数据时,对获取回来的数据表进行解析到表</span></p>
    007+ <p><span style="font-size:14px;"><br /></span></p>
    008- <p><span style="font-size:14px;"><br /></span></p>
    008+ <p><span style="font-size:14px;">相关RAP</span></p>
    009- <p><span style="font-size:14px;">相关RAP</span></p>
    009+ <p><span style="font-size:14px;">Walmart-CA站放款账单下载(<span style="font-size:14px;">RPA_ID:1656941496</span>)<br />放款账单下载-US(<span style="font-size:14px;">RPA_ID:165900062</span>)</span></p>
    010- <p><span style="font-size:14px;">Walmart-CA站放款账单下载(<span style="font-size:14px;">RPA_ID:1656941496</span>)<br />放款账单下载-US(<span style="font-size:14px;">RPA_ID:165900062</span>)</span></p>
    010+ <p><br /></p>
    011- <p><br /></p>
    011+ <p><span style="font-size:14px;"><span style="font-size:14px;">1、当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">2、当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    012- <p><span style="font-size:14px;"><span style="font-size:14px;">1、当下载US站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件包含“</span><span style="font-size:14px;"><span style="font-size:14px;">Payment-Details-Report</span></span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到US站回款账单结果表</span><br /><span style="font-size:14px;">2、当下载CA站点的放款账单时,</span>获取回来的CSV文件包含“<span style="font-size:14px;">Payment_Reports</span>”时,解析到CA站回款账单结果表1</span></p>
    012+ <p><span style="font-size:14px;"><span style="font-size:14px;">3、当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    013- <p><span style="font-size:14px;"><span style="font-size:14px;">3、当下载CA站点的放款账单时,</span><span style="font-size:14px;">获取回来的CSV文件<span style="color:#009900;">没有包含</span>“</span><span style="font-size:14px;">Payment_Reports</span><span style="font-size:14px;"></span><span style="font-size:14px;">”时,解析到CA站回款账单结果表2</span></span></p>
    013+ <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    014- <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    014+ <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    015- <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    015+ <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    016- <p><span style="font-size:14px;"><span style="font-size:14px;"><br /></span></span></p>
    016+ <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    017- <p><span style="font-size:14px;"><span style="font-size:14px;">US回款账单(<span style="font-size:14px;">回款账单结果表字段</span>):</span></span></p>
    017+ <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p>
    018- <p><span style="font-size:14px;"><span style="font-size:14px;">Walmart.com Order #<br />Walmart.com Order Line #<br />Walmart.com PO #<br />Walmart.com P.O. Line #<br />Partner Order #<br />Transaction Type<br />Transaction Date Time<br />Shipped Qty<br />Partner Item ID<br />Partner GTIN<br />Partner Item name<br />Product tax code<br />Shipping tax code<br />Gift wrap tax code<br />Ship to state<br />Ship to county<br />County Code<br />Ship to city<br />Zip code<br />shipping_method<br />Total tender to / from customer<br />Payable to Partner from Sale<br />Commission from Sale<br />Commission Rate<br />Gross Sales Revenue<br />Refunded Retail Sales<br />Sales refund for Escalation<br />Gross Shipping Revenue<br />Gross Shipping Refunded<br />Shipping refund for Escalation<br />Net Shipping Revenue<br />Gross Fee Revenue<br />Gross Fee Refunded<br />Fee refund for Escalation<br />Net Fee Revenue<br />Gift Wrap Quantity<br />Gross Gift-Wrap Revenue<br />Gross Gift-Wrap Refunded<br />Gift wrap refund for Escalation<br />Net Gift Wrap Revenue<br />Tax on Sales Revenue<br />Tax on Shipping Revenue<br />Tax on Gift-Wrap Revenue<br />Tax on Fee Revenue<br />Effective tax rate<br />Tax on Refunded Sales<br />Tax on Shipping Refund<br />Tax on Gift-Wrap Refund<br />Tax on Fee Refund<br />Tax on Sales refund for Escalation<br />Tax on Shipping Refund for Escalation<br />Tax on Gift-Wrap Refund for escalation<br />Tax on Fee Refund for escalation<br />Total NET Tax Collected<br />Tax Withheld<br />Adjustment Description<br />Adjustment Code<br />Original Item price<br />Original Commission Amount<br />Spec Category<br />Contract Category<br />Product Type<br />Flex Commission Rule<br />Return Reason Code<br />Return Reason Description<br />Fee Withheld Flag<br />Fulfillment Type<br />Fulfillment Details<br />Commission Incentive Program<br />Commission Saving<br />Customer Promo Type<br /></span></span></p>
    018+ <div><br /></div>
    019- <div><br /></div>
    019+ <br /><p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    020- <br /><p><span style="font-size:14px;"><span style="font-size:14px;"><img src="{238791.png}" alt="" /><br /></span></span></p>
    020+ <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    021- <p>CA站点回款账单(<span style="font-size:14px;">CA站回款账单结果表1</span>):</p>
    021+ <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    022- <p>Sales Order ID<br />Sales Order Line Number<br />Purchase Order ID<br />Purchase Order Line Number<br />Transaction Type<br />Customer Invoice Number<br />Customer Invoice Date<br />Seller Invoice Number<br />Seller Invoice Date<br />Seller Invoice Disposition Date<br />Shipped Qty<br />Offer ID<br />Walmart SKU ID<br />Seller SKU ID<br />Product Tax Code<br />Item Name<br />GTIN<br />Ship To City<br />Ship to Province<br />Postal Code<br />Shipping Method<br />Line Amount<br />Line Shipping Charge<br />Line Fee<br />Line Tax<br />PST/QST Remit by Seller<br />PST/QST Remit by Walmart<br />GST/HST Remit by Seller<br />GST/HST Remit by Walmart<br />Tender From Customer<br />Referral Rate<br />Referral Amount<br />Effective Tax Rate<br />Referral Tax Amount (GST/HST-137466199RT0001 QST-1016551356TQ0001)<br />WFS Fee Type<br />WFS Fee Amount<br />WFS PST/QST (QST-1016551356TQ0001)<br />WFS GST/HST (GST/HST - 137466199RT0001)<br />WFS Transaction ID<br />Payable To Partner</p>
    022+ <div></div>
    023- <div></div>
    023+ <p><br /></p>
    024- <p><br /></p>
    024+ <p><img src="{238790.png}" alt="" /></p>
    025- <p><img src="{238790.png}" alt="" /></p>
    025+ <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    026- <p><span style="font-size:14px;">CA站点账单汇总(<span style="font-size:14px;">CA站回款账单结果表2</span>):</span></p>
    026+ <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    027- <p><span style="font-size:14px;">Settlement Date<br />Opening Balance<br />Net Sales<br />Total from Other Activities<br />Paid to You<br />Closing Balance</span></p>
    027+ <p><span style="font-size:14px;"><br /></span></p>
    028- <p><span style="font-size:14px;"><br /></span></p>
    028+ <p><span style="font-size:14px;"></span></p>
    029- <p><span style="font-size:14px;"></span></p>
    029+ <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    030- <p><span style="font-size:14px;"><img src="{238792.png}" alt="" /><br /></span></p>
    030+ <p><span style="font-size:14px;"><br /><br /></span></p>
    031- <p><span style="font-size:14px;"><br /><br /></span></p>
  7. 2023-01-31 18:00:06, 由 梁贵荣 编辑。
    修改了 所属计划,旧值为 "699",新值为 "712"。
    修改了 预计工时,旧值为 "8",新值为 "16"。
  8. 2023-02-01 16:58:12, 由 梁贵荣 变更。
    修改了 版本号 ,旧值为 "4",新值为 "5"。
    修改了 需求描述,区别为:
    014- 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期
    014+ 解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期+计划ID
    014- <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期</p>
    014+ <p>解析要求:原表全字段解析+来源渠道+SelllerIDs+采集时间+回款日期+计划ID</p>
  9. 2023-02-03 10:48:21, 由 李会云 记录评审结果,结果为 确认通过。
    修改了 评审时间,旧值为 "0000-00-00",新值为 "2023-02-03"。
    修改了 指派给 ,旧值为 "lihuiyun",新值为 "liangguirong"。
    修改了 当前状态,旧值为 "draft",新值为 "active"。
    修改了 由谁评审,旧值为 "",新值为 "lihuiyun"。
  10. 2023-02-06 11:15:44, 由 梁贵荣 编辑。
    修改了 关键词,旧值为 "",新值为 "2月7日"。
  11. 2023-02-06 11:24:08, 由 梁贵荣 指派给 何智军。
    修改了 指派给,旧值为 "liangguirong",新值为 "hezhijun"。
  12. 2023-02-06 11:52:47, 由 zhengqiao 关联到迭代 技术研发中心 2月分支版本(2023年) 。
  13. 2023-02-06 14:35:06, 由 许瑞丰 添加备注。
    紫鸟采集的沃尔玛平台的三份报告解析到ERP存储  12H
  14. 2023-02-07 11:19:16, 由 周杰 编辑。
    修改了 预计工时,旧值为 "16",新值为 "11"。
    需求评审工时:11小时
  15. 2023-02-14 13:44:47, 由 梁贵荣 编辑。
    修改了 所属模块,旧值为 "1679",新值为 "1707"。
  16. 2023-03-01 15:04:55, 由 周杰 编辑。
    修改了 所处阶段 ,旧值为 "tested",新值为 "released"。
    修改了 设置阶段者,旧值为 "",新值为 "zhoujie"。
  17. 2023-05-13 16:43:46, 由 周杰 关闭,原因为 已完成 。
    修改了 由谁关闭,旧值为 "",新值为 "zhoujie"。
    修改了 关闭日期,旧值为 "0000-00-00 00:00:00",新值为 "2023-05-13 16:43:44"。
    修改了 指派给 ,旧值为 "hezhijun",新值为 "closed"。
    修改了 当前状态,旧值为 "active",新值为 "closed"。
    修改了 所处阶段,旧值为 "released",新值为 "closed"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
迭代版本 2023年2月第2个迭代
提报业务部门
提报人员 梁贵荣
需求来源 公司战略需求
所属项目 技术中心-需求池
所属模块 系统运维
所属计划
业务价值
开发组
受益业务部门 技术研发中心
验收人员
业务目标类型
中心业务目标
业务价值 控制风险
每月价值量 0.5人天/月
每月节省人数 0
优先级 P2
价值类型
预计工时 11
成本
ROI
操作手册 否
高价值
主被动
复杂度
工作流ID
工作流创建时间
更新点
是否高危 否
评分
当前状态 已关闭
所处阶段 已关闭
关键词 2月7日
评审次数
计划上线
上线时间 2023-02-07
计划验收时间
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给
由谁创建 梁贵荣 于 2023-01-28 16:18:25
指派给 Closed 于 2023-11-16 18:57:28
由谁评审 李会云
评审时间 2023-02-03
由谁关闭 周杰 于 2023-05-13 16:43:44
关闭原因 已完成
最后修改 周杰 于 2023-11-16 18:57:28