轻易云
注册体验

领星ERPWalmart - 查询结算账单列表接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
多平台 / 财务 / Walmart财务 · POST · 请求参数 16 个(必填 2) · 响应参数 77 个 · 限流令牌桶容量 1
更新日期
2026-11-21

Walmart - 查询结算账单列表

POST/basicOpen/multiplatformFinance/walmart/bill/statement/list
加工厂
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/multiplatformFinance/walmart/bill/statement/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/walmart/bill/statement/list?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n  \"sids\": [],\n  \"amountTypes\": [],\n  \"currencyCode\": \"\",\n  \"fulfillmentTypes\": [],\n  \"transactionDescriptions\": [],\n  \"transactionTypes\": [\"Other\"],\n  \"startDate\": \"2026-01-01\",\n  \"endDate\": \"2026-06-29\",\n  \"offset\": 0,\n  \"length\": 20\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583",
    "response_time": "2026-05-25 12:00:00",
    "data": {
      "list": [
        {
          "amount": 35.5,
          "amountType": "Commission",
          "baseCommissionRate": 0.15,
          "campaignId": "C10001",
          "chargeSavings": 2,
          "commissionIncentiveProgram": "Incentive",
          "commissionRate": 0.12,
          "commissionRule": "Standard",
          "commissionSaving": 1.5,
          "companyId": 10001,
          "contractCategory": "Electronics",
          "currency": "USD",
          "currencyIcon": "$",
          "customerOrderLineNo": "COL-10001",
          "customerOrderNo": "CO-10001",
          "customerPromoType": "Coupon",
          "deleteFlag": 0,
          "fulfillmentDetails": "WFS fulfillment",
          "fulfillmentType": "WFS",
          "id": 100001,
          "incentiveProgramName": "Pro Seller",
          "itemCondition": "New",
          "originalCharge": 10,
          "originalCommission": 6,
          "partnerGtin": "00012345678905",
          "partnerItemId": "MSKU-001",
          "partnerItemName": "Wireless Mouse",
          "periodEndDate": "2026-01-31",
          "periodStartDate": "2026-01-01",
          "platformCode": "walmart",
          "productTaxCode": "2038710",
          "productType": "Mouse",
          "purchaseOrderLineNo": "POL-10001",
          "purchaseOrderNo": "PO-10001",
          "remark": "normal",
          "reportDate": "2026-01-31",
          "reportId": 90001,
          "reportKey": "RPT-202601",
          "shipQty": 2,
          "shipToCity": "Los Angeles",
          "shipToCountry": "US",
          "shipToState": "CA",
          "shipToZipcode": "90001",
          "shippingMethod": "Standard",
          "site": "US",
          "siteCode": "US",
          "siteDisplay": "美国",
          "storeId": 123456,
          "storeName": "Walmart US Store",
          "totalPayable": 120.5,
          "totalWalmartFundedSavingsProgram": 3,
          "transactionDescription": "Item Sale",
          "transactionKey": "TXN-10001",
          "transactionPostedTimestamp": "2026-01-15 10:30:00",
          "transactionReasonDescription": "Product charge",
          "transactionType": "Sales",
          "uniqueNo": "UNQ-10001"
        }
      ],
      "totalCount": 1,
      "totalSum": {
        "amount": 35.5,
        "chargeSavings": 2,
        "commissionSaving": 1.5,
        "currency": "USD",
        "currencyIcon": "$",
        "originalCharge": 10,
        "originalCommission": 6,
        "shipQty": 2,
        "totalCount": 1,
        "totalPayable": 120.5,
        "totalWalmartFundedSavingsProgram": 3
      }
    }
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1amountTypes金额类型数组array<any>—可选金额类型数组
2currencyCode目标货币代码string—可选目标货币代码
3endDate结束时间string—可选结束时间,格式:yyyy-MM-dd
4fulfillmentTypes发货类型数组array<any>—可选发货类型数组
5length分页大小integer—必填分页大小,默认 20,最大 200
6offset分页偏移量integer—必填分页偏移量,默认 0
7searchExactly是否精确匹配boolean—可选是否精确匹配
8searchMultiValue多个搜索值array<any>—可选多个搜索值,精确匹配时使用
9searchSingleValue单个搜索值string—可选单个搜索值
10searchType搜索类型integer—可选搜索类型 1:平台单号 2:客户单号 3:MSKU 4:GTIN 5:商品标题 6:账期ID
11sids店铺ID数组array<any>—可选店铺ID数组,数组元素为查询多平台店铺信息接口返回的沃尔玛店铺 store_id
12sortField排序字段string—可选排序字段
13sortType排序方向string—可选排序方向 1:升序 0:降序
14startDate开始时间string—可选开始时间,格式:yyyy-MM-dd
15transactionDescriptions交易描述数组array<any>—可选交易描述数组
16transactionTypes交易类型数组array<any>—可选交易类型数组 Sale Refund Campaigns Adjustment Service Fee Customer Fee Misc Adjustment Dispute Settlement Prepaid Prepaid Recouped Rewards Other

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer0必填状态码,0:成功
2message消息提示stringsuccess必填消息提示
3error_details数据校验失败时的错误详情array<any>—必填数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583必填请求链路id
5response_time响应时间string2026-05-25 12:00:00必填响应时间
6data响应数据object—必填响应数据
6.1list列表数据array<object>—必填列表数据
6.1.1amount金额number35.5必填金额
6.1.2amountType费用名称stringCommission必填费用名称
6.1.3baseCommissionRate基础佣金费率number0.15必填基础佣金费率
6.1.4campaignId广告活动IDstringC10001必填广告活动ID
6.1.5chargeSavings费用补贴number2必填费用补贴
6.1.6commissionIncentiveProgram平台激励项目stringIncentive必填平台激励项目
6.1.7commissionRate佣金费率number0.12必填佣金费率
6.1.8commissionRule佣金规则stringStandard必填佣金规则
6.1.9commissionSaving佣金折扣number1.5必填佣金折扣
6.1.10companyId公司IDinteger10001必填公司ID
6.1.11contractCategory品类大类stringElectronics必填品类大类
6.1.12currency币种stringUSD必填币种
6.1.13currencyIcon币种图标string$必填币种图标
6.1.14customerOrderLineNo客户子单号stringCOL-10001必填客户子单号
6.1.15customerOrderNo客户单号stringCO-10001必填客户单号
6.1.16customerPromoType卖家促销类型stringCoupon必填卖家促销类型
6.1.17deleteFlag删除标识integer0必填删除标识
6.1.18fulfillmentDetails发货说明stringWFS fulfillment必填发货说明
6.1.19fulfillmentType发货类型stringWFS必填发货类型
6.1.20id主键IDinteger100001必填主键ID
6.1.21incentiveProgramName激励项目名称stringPro Seller必填激励项目名称
6.1.22itemCondition商品属性stringNew必填商品属性
6.1.23originalCharge费用原值number10必填费用原值
6.1.24originalCommission佣金原值number6必填佣金原值
6.1.25partnerGtinpartnerGtinstring00012345678905必填GTIN
6.1.26partnerItemIdpartnerItemIdstringMSKU-001必填MSKU
6.1.27partnerItemName商品标题stringWireless Mouse必填商品标题
6.1.28periodEndDate周期结束日期string2026-01-31必填周期结束日期
6.1.29periodStartDate周期开始日期string2026-01-01必填周期开始日期
6.1.30platformCode平台码stringwalmart必填平台码
6.1.31productTaxCode商品税代码string2038710必填商品税代码
6.1.32productType品类小类stringMouse必填品类小类
6.1.33purchaseOrderLineNo平台子单号stringPOL-10001必填平台子单号
6.1.34purchaseOrderNo平台单号stringPO-10001必填平台单号
6.1.35remark备注stringnormal必填备注
6.1.36reportDate报告日期string2026-01-31必填报告日期
6.1.37reportId报告IDinteger90001必填报告ID
6.1.38reportKey报告唯一键stringRPT-202601必填报告唯一键
6.1.39shipQty发货量integer2必填发货量
6.1.40shipToCity收货城市stringLos Angeles必填收货城市
6.1.41shipToCountry收货国stringUS必填收货国
6.1.42shipToState收货省州stringCA必填收货省州
6.1.43shipToZipcode收货邮编string90001必填收货邮编
6.1.44shippingMethod发货方式stringStandard必填发货方式
6.1.45site站点代码stringUS必填站点代码
6.1.46siteCode站点stringUS必填站点
6.1.47siteDisplay站点中文展示string美国必填站点中文展示
6.1.48storeId店铺IDinteger123456必填店铺ID
6.1.49storeName店铺名stringWalmart US Store必填店铺名
6.1.50totalPayable结算金额number120.5必填结算金额
6.1.51totalWalmartFundedSavingsProgram平台补贴number3必填平台补贴
6.1.52transactionDescription交易描述stringItem Sale必填交易描述
6.1.53transactionKey结算IDstringTXN-10001必填结算ID
6.1.54transactionPostedTimestamp结算时间string2026-01-15 10:30:00必填结算时间
6.1.55transactionReasonDescription交易说明stringProduct charge必填交易说明
6.1.56transactionType交易类型stringSales必填交易类型
6.1.57uniqueNo唯一标识stringUNQ-10001必填唯一标识
6.2totalCount总记录数integer1必填总记录数
6.3totalSum汇总数据object—必填汇总数据
6.3.1amount交易金额汇总number35.5必填交易金额汇总
6.3.2chargeSavings收费节省汇总number2必填收费节省汇总
6.3.3commissionSaving佣金节省汇总number1.5必填佣金节省汇总
6.3.4currency货币代码stringUSD必填货币代码
6.3.5currencyIcon货币图标string$必填货币图标
6.3.6originalCharge原始收费汇总number10必填原始收费汇总
6.3.7originalCommission原始佣金汇总number6必填原始佣金汇总
6.3.8shipQty发货数量汇总integer2必填发货数量汇总
6.3.9totalCount总记录数integer1必填总记录数
6.3.10totalPayable应付总额number120.5必填应付总额
6.3.11totalWalmartFundedSavingsProgramWalmart补贴总额number3必填Walmart补贴总额

领星ERP的接口:Walmart - 查询结算账单列表(/basicOpen/multiplatformFinance/walmart/bill/statement/list),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。