Qeasy Cloud
Get Started

领星ERP 查询结算中心 - 交易明细 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
财务 · POST · 请求参数 12 个(必填 0) · 响应参数 75 个 · 限流令牌桶容量 10
Updated At
2026-11-21

查询结算中心 - 交易明细

POST/bd/sp/api/open/settlement/transaction/detail/list
Factory
{
  "operation": {
    "method": "POST",
    "path": "/bd/sp/api/open/settlement/transaction/detail/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 10,
    "text": ""
  },
  "requestExample": "{\n    \"offset\": 0,\n    \"length\": 20,\n    \"countryCodes\": [\n        1\n    ],\n    \"sids\": [\n        136\n    ],\n    \"startDate\": \"2023-09-24\",\n    \"endDate\": \"2023-09-30\",\n    \"eventType\": \"ShipmentEventList\",\n    \"type\": \"Tax\",\n    \"searchField\": \"id\",\n    \"searchValue\": [\n        \"LWCBG07Y55I3\"\n    ],\n    \"gmtModifiedStart\": \"2022-10-26 15:15:12\",\n    \"gmtModifiedEnd\": \"2022-10-26 16:15:12\"\n}",
  "responseExample": {
    "code": 0,
    "msg": null,
    "data": {
      "records": [
        {
          "uniqueKey": "",
          "amazonOrderId": "202-6458758-1434760",
          "sid": 8,
          "storeName": "JHL-Official-02",
          "countryCode": "UK",
          "accountType": "Standard",
          "fulfillment": "FBA",
          "eventType": "Shipment",
          "sellerId": "xxxxxxxxxxxxxxxx",
          "sellerSku": "1160U1139-A",
          "type": "Commission",
          "postedDateLocale": "2022-09-10T23:55:12+01:00",
          "currencyCode": "GBP",
          "currencyAmount": "-1.93",
          "quantity": 1,
          "processingStatus": "Closed",
          "fundTransferStatus": "Succeeded",
          "fid": "QA0DOY5ODNF8",
          "settlementId": "",
          "localSku": "",
          "localName": "",
          "id": "18327152",
          "gmtModified": "2022-09-11 07:06:37.401",
          "sellerOrderId": "",
          "marketplaceName": "Amazon.com",
          "postedDate": "2024-06-06T08:29:00Z",
          "financialEventGroupId": "2bc77df899a347861b669e3b",
          "fnsku": "X00000STB1",
          "orderItemId": "40667527236852",
          "merchantOrderId": "100119933999",
          "md5": "4fe4d6bb8d6b2b728f97acd9b11de94f",
          "companyId": 1039287,
          "gmtCreate": "",
          "level1": "一级分类",
          "asin": "B00EXAMPLE",
          "level2": "二级分类",
          "promotionId": "PRM202406",
          "dealId": "DEAL12345",
          "feeType": "ShippingFee",
          "dealDescription": "订单退款",
          "invoiceId": "INV202406",
          "transactionType": "Refund",
          "feeDescription": "运费",
          "feeReason": "活动促销",
          "couponId": "QP123456",
          "sellerCouponDescription": "满减优惠券",
          "clipOrRedemptionCount": 2,
          "paymentEventId": "PMT67890",
          "enrollmentId": "ENR202406",
          "parentAsin": "B00PARENT123",
          "debtRecoveryType": "DebtRecoveryTypeA",
          "groupBeginDate": "2024-06-01",
          "groupEndDate": "2024-06-07",
          "orderId": "ORDER202406",
          "removalShipmentItemId": "RS12345",
          "taxCollectionModel": "MarketplaceFacilitator",
          "taxWithholdingPeriodStartDate": "2024-06-01",
          "taxWithholdingPeriodEndDate": "2024-06-05",
          "netCoTransactionId": "NCOTID123",
          "swapReason": "换货",
          "marketplaceId": "A1F83G8C2ARO7P",
          "adjustmentEventId": "ADJ7890",
          "safeTClaimId": "STC202406",
          "reasonCode": "REASON123",
          "productDescription": "产品描述信息",
          "sourceBusinessEventType": "EVENT_TYPE_A",
          "businessObjectType": "Order",
          "amountDescription": "实收金额",
          "level1Index": 1,
          "level2Index": 2
        }
      ],
      "total": 1335
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量integer—Optional分页偏移量
2length分页长度integer—Optional分页长度,上限10000
3countryCodes站点idarray<any>—Optional站点id
4sids店铺idarray<any>—Optional店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
5startDate开始时间【结算时间】string—Optional开始时间【结算时间】,双闭区间,查询时间间隔不得超过7天,格式:Y-m-d 【无搜索值时,结算时间、修改时间二选一必填】
6endDate结束时间【结算时间】string—Optional结束时间【结算时间】,双闭区间,查询时间间隔不得超过7天,格式:Y-m-d 【无搜索值时,结算时间、修改时间二选一必填】
7eventType来源string—Optional来源,多个英文用逗号隔开,枚举见附加说明
8type交易类型string—Optional交易类型
9searchField搜索字段string—Optional搜索字段: id 结算编号 amazon_order_id 订单编号 primary_id 主键编号【对应本接口返回id值】 settlement_id 账单编号【此项下,结算时间或更新时间必填】
10searchValue搜索值array<any>—Optional搜索值
11gmtModifiedStart修改开始时间(北京时间)string—Optional修改开始时间(北京时间),格式:Y-m-d H:i:s 【无搜索值时,结算时间、修改时间二选一必填】
12gmtModifiedEnd修改结束时间(北京时间)string—Optional修改结束时间(北京时间),格式:Y-m-d H:i:s 【无搜索值时,结算时间、修改时间二选一必填】

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2msg返回信息string—Required返回信息
3data响应数据array<object>—Required响应数据
3.1recordsrecordsarray<object>—Required
3.1.1uniqueKey交易明细唯一标识string—Required交易明细唯一标识 备注:eventType=servicefeeeventlist时,uniqueKey会变动
3.1.2amazonOrderId订单号string—Required订单号
3.1.3sid店铺idinteger—Required店铺id
3.1.4storeName店铺名string—Required店铺名
3.1.5sellerId亚马逊店铺idstring—Required亚马逊店铺id
3.1.6countryCode国家string—Required国家
3.1.7accountType报告类型string—Required报告类型
3.1.8fulfillment配送方式string—Required配送方式
3.1.9eventType来源string—Required来源 备注:eventType=servicefeeeventlist时,uniqueKey会变动
3.1.10sellerSkusellerSkustring—RequiredMSKU
3.1.11type交易类型string—Required交易类型
3.1.12postedDateLocale结算时间(站点时间)string—Required结算时间(站点时间)
3.1.13currencyCode币种string—Required币种
3.1.14currencyAmount金额number—Required金额
3.1.15quantity数量integer—Required数量
3.1.16processingStatus结算状态string—Required结算状态: Open 未结算 Closed 已结算 Reconciled 已对账
3.1.17fundTransferStatus转账状态string—Required转账状态: Succeeded 已转账 Processing 转账中 Failed 失败 Unknown 未知
3.1.18fid结算编号string—Required结算编号
3.1.19settlementIdsettlementIdstring—Requiredsettlement_id
3.1.20localSkulocalSkustring—Requiredsku
3.1.21localName品名string—Required品名
3.1.22id主键编号【非唯一键】string—Required主键编号【非唯一键】
3.1.23gmtModified修改时间string—Required修改时间
3.1.24sellerOrderId卖方为订单定义的标识符string—Required卖方为订单定义的标识符
3.1.25marketplaceName市场名称string—Required市场名称
3.1.26postedDate结算日期string2024-06-06T08:29:00ZOptional结算日期 0时区
3.1.27financialEventGroupIdfinancialEventGroupIdstring2bc77df899a347861b669e3bOptionalgroupID
3.1.28fnskufnskustringX00000STB1OptionalFNSKU
3.1.29orderItemId订单项IDstring40667527236852Optional订单项ID
3.1.30merchantOrderId商家订单IDstring100119933999Optional商家订单ID
3.1.31md5md5string4fe4d6bb8d6b2b728f97acd9b11de94fOptionalMD5
3.1.32companyId公司IDinteger1039287Optional公司ID
3.1.33gmtCreate创建时间string2024-06-05 11:22:33Optional创建时间
3.1.34level1层级1string一级分类Optional层级1
3.1.35asinasinstringB00EXAMPLEOptionalASIN
3.1.36level2层级2string二级分类Optional层级2
3.1.37promotionId促销IDstringPRM202406Optional促销ID
3.1.38dealId交易IDstringDEAL12345Optional交易ID
3.1.39feeType费用类型stringShippingFeeOptional费用类型
3.1.40dealDescription交易描述string订单退款Optional交易描述
3.1.41invoiceId发票IDstringINV202406Optional发票ID
3.1.42transactionType交易类型stringRefundOptional交易类型
3.1.43feeDescription费用描述string运费Optional费用描述
3.1.44feeReason费用原因string活动促销Optional费用原因
3.1.45couponId优惠券IDstringQP123456Optional优惠券ID
3.1.46sellerCouponDescription卖家优惠券描述string满减优惠券Optional卖家优惠券描述
3.1.47clipOrRedemptionCount剪辑或兑换计数integer2Optional剪辑或兑换计数
3.1.48paymentEventId支付事件IDstringPMT67890Optional支付事件ID
3.1.49enrollmentId注册IDstringENR202406Optional注册ID
3.1.50parentAsin父ASINstringB00PARENT123Optional父ASIN
3.1.51debtRecoveryType债务恢复类型stringDebtRecoveryTypeAOptional债务恢复类型
3.1.52groupBeginDate组开始日期string2024-06-01Optional组开始日期 已废弃
3.1.53groupEndDate组结束日期string2024-06-07Optional组结束日期 已废弃
3.1.54orderId订单IDstringORDER202406Optional订单ID
3.1.55removalShipmentItemId移除货件项IDstringRS12345Optional移除货件项ID
3.1.56taxCollectionModel税收模型stringMarketplaceFacilitatorOptional税收模型
3.1.57taxWithholdingPeriodStartDate预扣税期间开始日期string2024-06-01Optional预扣税期间开始日期 已废弃
3.1.58taxWithholdingPeriodEndDate预扣税期间结束日期string2024-06-05Optional预扣税期间结束日期 已废弃
3.1.59netCoTransactionId净CO交易IDstringNCOTID123Optional净CO交易ID
3.1.60swapReason交换原因string换货Optional交换原因
3.1.61marketplaceId市场IDstringA1F83G8C2ARO7POptional市场ID
3.1.62adjustmentEventId调整事件IDstringADJ7890Optional调整事件ID
3.1.63safeTClaimIdSafeT索赔IDstringSTC202406OptionalSafeT索赔ID
3.1.64reasonCode原因代码stringREASON123Optional原因代码
3.1.65productDescription产品描述string产品描述信息Optional产品描述
3.1.66sourceBusinessEventType源业务事件类型stringEVENT_TYPE_AOptional源业务事件类型
3.1.67businessObjectType业务对象类型stringOrderOptional业务对象类型
3.1.68amountDescription金额描述string实收金额Optional金额描述
3.1.69level1Index层级1索引integer1Optional层级1索引
3.1.70level2Index层级2索引integer2Optional层级2索引
3.2total总数integer1335Required总数

The 查询结算中心 - 交易明细 API (/bd/sp/api/open/settlement/transaction/detail/list) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.