数据格式解析与业务规则处理指南

轻易云数据集成平台在处理电商退货业务时，需要解析以下JSON数据结构并执行特定业务规则。该平台通过智能化数据处理引擎，能够高效执行复杂业务逻辑，确保数据处理的准确性和一致性。

数据结构说明

{
  "as_date": "2023-12-28 20:39:05",
  "as_id": 870174131,
  "buyer_apply_refund": "579.0",
  "buyer_receive_refund": "0.0",
  "confirm_date": "2024-01-01 10:51:13",
  "created": "2023-12-28 20:39:19",
  "currency": "",
  "free_amount": "0.0",
  "freight": "0",
  "good_status": "SELLER_RECEIVED",
  "items": [
    {
      "amount": "579",
      "as_id": 870174131,
      "asi_id": 870185928,
      "i_id": "T23WA37719",
      "name": "NORNS LADY/诺恩 秋冬新款大衣 T23WA37719 驼色 M",
      "outer_oi_id": "P718618651395344101_XHS-1UJO5VW57SAU",
      "pic": "http://qimg.xiaohongshu.com/arkgoods/1040g0o030s89g6f82g005p0o2fl4c9krngbegn0?itemId=656d2a401d547d0001c08fc5&imageView2/1/w/320/h/320/q/90.jpeg",
      "price": "579",
      "properties_value": "驼色 M(90-110斤)",
      "qty": 1,
      "r_qty": 1,
      "receive_date": "2024-01-01 10:51:13",
      "shop_amount": "579",
      "shop_sku_id": "df95c3c140a4a4b1e2c42587130954",
      "sku_id": "T23WA37719C6M",
      "sku_type": "normal",
      "type": "退货"
    }
  ],
  "l_id": "SF1678324944379",
  "labels": "ShopDown",
  "logistics_company": "顺丰速运",
  "modified": "2024-01-01 11:27:54",
  "node": "问题类型不存在",
  "o_id": 2631116,
  "order_label": "发货后售后",
  "order_status": "Sent",
  "order_type": "普通订单",
  "outer_as_id": "R9534410167144930",
  "payment": "0",
  "question_type": "多拍/拍错/不想要",
  "refund": "579",
  "refund_version": "0",
  "remark": "",
  "shop_buyer_id": "5b2be54d2720f8a01926f0960db956d9",
  "shop_freight": "0.0",
  "shop_id": "14793704",
  "shop_name": "Right Thirty R30服饰的店",
  "shop_status": "SUCCESS",
  "shop_type": "普通退货",
  "so_id": "P718618651395344101",
  "status": "Confirmed",
  "ts": "7417261917",
  "type": "普通退货",
  "urefund": "0.0",
  "warehouse": "浙江濮院分仓销退仓",
  "wh_id": 2,
  "wms_co_id": 12851795
}

业务规则处理流程

轻易云数据集成平台通过可视化规则引擎，可配置以下业务处理逻辑：

1. 折扣金额处理规则

   • 当账户折扣金额(bill_dis_amount)大于0时：最终金额 = 折扣金额 - 运费
   • 当账户折扣金额小于0时：直接取折扣金额值

2. 税费计算规则

   • 计算商品分录行(material_entity)的税费总额：税费总额 = tax_price × qty（结果保留浮点数精度）

3. 退款金额逻辑

   • 当退款金额大于折扣金额时：取折扣金额值
   • 否则：取0值

4. 运费处理规则

   • 存在退费(urefund)时：最终金额 = 原始金额 - 运费
   • 存在运费(freight)时：最终金额 = 原始金额 + 运费

5. 尾差处理机制

   • 当税费总额 - 折扣总额的差值不超过0.001时：保持当前行税费值不变
   • 当存在尾差时：
     • 将首个物料实体的tax_price字段设置为调整后的refund值
     • 其他物料实体的tax_price字段统一设置为0

轻易云数据集成平台通过内置的规则引擎和异常处理机制，能够自动执行这些复杂业务逻辑，确保数据处理结果的准确性。平台支持实时监控处理过程，并提供详细的日志记录，便于业务人员追踪和审计。