/basicOpen/multiplatformFinance/mercado/bill/list{
"operation": {
"method": "POST",
"path": "/basicOpen/multiplatformFinance/mercado/bill/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/multiplatformFinance/mercado/bill/list?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"sids\": [\"123456789012345678\"],\n \"storeTypes\": [1],\n \"sites\": [\"MX\"],\n \"currencyCode\": \"USD\",\n \"descriptionTypes\": [\"Payment\"],\n \"startDate\": \"2026-01-01 00:00:00\",\n \"endDate\": \"2026-01-31 23:59:59\",\n \"searchField1\": \"msku\",\n \"productSearchValue\": \"MSKU001\",\n \"productSearchArr\": [\"MSKU001\"],\n \"searchField2\": \"platformOrderNo\",\n \"orderSearchValue\": \"ORDER001\",\n \"orderSearchArr\": [\"ORDER001\"],\n \"orderIdFilterTypes\": [1],\n \"offset\": 0,\n \"length\": 20,\n \"sortField\": \"releaseDate\",\n \"sortType\": \"DESC\",\n \"includedInSettlement\": true\n}'",
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "a0d54debf93140f3b58d1ed81e8e3583",
"response_time": "2026-08-05 12:00:00",
"data": {
"totalCount": 1,
"list": [
{
"reportId": 1,
"companyId": 1,
"releaseDate": "2026-01-01",
"sourceId": "SOURCE001",
"recordType": "Payment",
"description": "Payment",
"netCreditAmount": 100,
"netDebitAmount": 0,
"grossAmount": 100,
"currency": "USD",
"orderId": "ORDER001",
"productSku": "MSKU001",
"includedInSettlement": true
}
],
"totalSum": {
"netCreditAmount": 100,
"netDebitAmount": 0,
"grossAmount": 100,
"currency": "USD",
"totalCount": 1
}
},
"total": 1
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sids | 店铺ID列表 | array<any> | — | Optional | 店铺ID列表,元素为字符串 |
| 2 | storeTypes | 店铺类型 | array<any> | — | Optional | 店铺类型:0-本土店 1-跨境店 |
| 3 | sites | 站点 | array<any> | — | Optional | 站点:MX-墨西哥 MX-full-墨西哥-Full AR-阿根廷 BO-玻利维亚 BR-巴西 CL-智利 CL-full-智利-Full CO-哥伦比亚 COCR-哥斯达黎加 DO-多米尼加 EC-厄瓜多尔 GT-危地马拉 HN-洪都拉斯 NI-尼加拉瓜 PA-巴拿马 PY-巴拉圭 PE-秘鲁 SV-萨尔瓦多 UY-乌拉圭 VE-委内瑞拉 |
| 4 | currencyCode | 币种 | string | — | Required | 币种 |
| 5 | descriptionTypes | 描述类型 | array<any> | — | Optional | 描述类型:0-空 1-payment 2-refund 3-mediation 4-mediation_cancel 5-shipping 6-shipping fee 7-shipping_cancel 8-shipping_return 9-restriction 10-dispute 11-tax_payment_ibex 12-tax_payment_iibb_cre_ 13-tax_iibb_ 14-tax_iva 15-tax_iva_cre 16-tax_withholding 17-tax_withholding_cancel 18-tax_withholding_payer 19-tax_withholding_collector 20-tax_withholding_payout 21-tax_withholding_shipping 22-fee_release_in_advance 23-digitalchange_transaction 24-asset_management_gain 25-asset_management_loss 26-chargeback 27-credit_payment 28-cash withdrawal 29-withdrawal 30-payout 31-reserve_for_payment 32-reserve for payout 33-reserve for refund 34-reserve_for_dispute 35-reserve_for_embargo_invested 36-reserve_for_bpp_shipping_return 37-reserve_for_debt_payment 38-reserve_for_cbk_cross_recovery 39-其他描述 |
| 6 | startDate | 开始时间 | string | — | Required | 开始时间,格式 yyyy-MM-dd HH:mm:ss |
| 7 | endDate | 结束时间 | string | — | Required | 结束时间,格式 yyyy-MM-dd HH:mm:ss |
| 8 | searchField1 | 商品搜索字段 | string | — | Optional | 商品搜索字段,可选值:msku、mskuId、itemId |
| 9 | productSearchValue | 商品搜索内容 | string | — | Optional | 商品搜索内容 |
| 10 | productSearchArr | 商品精确搜索内容 | array<any> | — | Optional | 商品精确搜索内容 |
| 11 | searchField2 | 订单搜索字段 | string | — | Optional | 订单搜索字段:orderId-ORDER ID platformOrderNo-平台单号 platformOrderItemNo-平台子单号 packId-包裹单号 externalReference-参考号 sourceId-来源 ID shippingId-运单号 |
| 12 | orderSearchValue | 订单搜索内容 | string | — | Optional | 订单搜索内容 |
| 13 | orderSearchArr | 订单精确搜索内容 | array<any> | — | Optional | 订单精确搜索内容 |
| 14 | orderIdFilterTypes | ORDER ID 筛选类型 | array<any> | — | Optional | ORDER ID 筛选类型:0-ORDER ID 为空 1-ORDER ID 首位为 2 2-ORDER ID 首位为 4 3-其他首位 |
| 15 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,从0开始,默认0 |
| 16 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,最大200 |
| 17 | sortField | 排序字段 | string | — | Optional | 排序字段,可选值:releaseDate、netCreditAmount、netDebitAmount、grossAmount、sellerAmount、mpFeeAmount、financingFeeAmount、shippingFeeAmount、taxesAmount、couponAmount、saleQuantity、refundQuantity |
| 18 | sortType | 排序类型 | string | — | Optional | 排序类型,可选值:DESC、ASC |
| 19 | includedInSettlement | 是否包含在结算中 | boolean | — | Optional | 是否包含在结算中 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | — | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | a0d54debf93140f3b58d1ed81e8e3583 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2026-08-05 12:00:00 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | totalCount | 数据总数 | integer | 1 | Required | 数据总数 |
| 6.2 | list | 明细数据 | array<object> | — | Required | 明细数据 |
| 6.2.1 | reportId | 关联系统报告编号 | integer | 1 | Required | 关联系统报告编号 |
| 6.2.2 | companyId | 公司ID | integer | 1 | Required | 公司ID |
| 6.2.3 | releaseDate | 放款日期 | string | 2026-01-01 | Required | 放款日期 |
| 6.2.4 | sourceId | 来源ID | string | SOURCE001 | Required | 来源ID |
| 6.2.5 | externalReference | 参考号 | string | REF001 | Required | 参考号 |
| 6.2.6 | recordType | 交易类型 | string | Payment | Required | 交易类型 |
| 6.2.7 | description | 描述 | string | Payment | Required | 描述 |
| 6.2.8 | netCreditAmount | 净入账金额 | number | 100 | Required | 净入账金额 |
| 6.2.9 | netDebitAmount | 净出账金额 | number | 0 | Required | 净出账金额 |
| 6.2.10 | grossAmount | 总金额 | number | 100 | Required | 总金额 |
| 6.2.11 | sellerAmount | 分期购买付款金额 | number | 100 | Required | 分期购买付款金额 |
| 6.2.12 | mpFeeAmount | 平台佣金 | number | 10 | Required | 平台佣金 |
| 6.2.13 | financingFeeAmount | 分期手续费 | number | 1 | Required | 分期手续费 |
| 6.2.14 | shippingFeeAmount | 平台物流费 | number | 5 | Required | 平台物流费 |
| 6.2.15 | taxesAmount | 税费 | number | 3 | Required | 税费 |
| 6.2.16 | couponAmount | 优惠金额 | number | 2 | Required | 优惠金额 |
| 6.2.17 | currency | 币种 | string | USD | Required | 币种 |
| 6.2.18 | installments | 分期期数 | string | 1 | Required | 分期期数 |
| 6.2.19 | paymentMethod | 支付方式 | string | credit_card | Required | 支付方式 |
| 6.2.20 | taxDetail | 税费明细 | string | — | Required | 税费明细 |
| 6.2.21 | taxAmountTelco | 电信服务税 | number | 0 | Required | 电信服务税 |
| 6.2.22 | approvalDate | 支付批准日期 | string | 2026-01-01 | Required | 支付批准日期 |
| 6.2.23 | posId | 收银机ID | string | POS001 | Required | 收银机ID |
| 6.2.24 | posName | 收银机名称 | string | POS | Required | 收银机名称 |
| 6.2.25 | externalPosId | 自定义收银机ID | string | POS001 | Required | 自定义收银机ID |
| 6.2.26 | storeId1 | 分支机构ID | string | STORE001 | Required | 分支机构ID |
| 6.2.27 | externalStoreId | 自定义分支机构ID | string | STORE001 | Required | 自定义分支机构ID |
| 6.2.28 | taxesDisaggregated | 税费分项明细 | string | — | Required | 税费分项明细 |
| 6.2.29 | shippingId | 运单号 | string | SHIP001 | Required | 运单号 |
| 6.2.30 | shipmentMode | 物流方式 | string | shipping | Required | 物流方式 |
| 6.2.31 | orderId | 平台单号 | string | ORDER001 | Required | 平台单号 |
| 6.2.32 | packId | 包裹单号 | string | PACK001 | Required | 包裹单号 |
| 6.2.33 | metadata | 元数据 | string | — | Required | 元数据 |
| 6.2.34 | effectiveCouponAmount | 实际优惠金额 | number | 2 | Required | 实际优惠金额 |
| 6.2.35 | poiId | 受理点ID | string | POI001 | Required | 受理点ID |
| 6.2.36 | cardInitialNumber | 卡号前几位 | string | 123456 | Required | 卡号前几位 |
| 6.2.37 | operationTags | 物流类型标签 | string | — | Required | 物流类型标签 |
| 6.2.38 | itemId | MSKU ID | string | ITEM001 | Required | MSKU ID |
| 6.2.39 | bankOfOrigin | 发卡行 | string | bank | Required | 发卡行 |
| 6.2.40 | digitalWallet | 电子钱包 | string | wallet | Required | 电子钱包 |
| 6.2.41 | businessUnit | 核算主体 | string | unit | Required | 核算主体 |
| 6.2.42 | subUnit | 核算细分单元 | string | sub-unit | Required | 核算细分单元 |
| 6.2.43 | balance | 账户余额 | string | 0.00 | Required | 账户余额 |
| 6.2.44 | payoutBankAccountNumber | 提款银行账号 | string | 123456 | Required | 提款银行账号 |
| 6.2.45 | productSku | productSku | string | MSKU001 | Required | MSKU |
| 6.2.46 | saleDetail | 销售详情 | string | — | Required | 销售详情 |
| 6.2.47 | paymentMethodType | 支付方式类型 | string | credit_card | Required | 支付方式类型 |
| 6.2.48 | transactionIntentId | 交易意图ID | string | TX001 | Required | 交易意图ID |
| 6.2.49 | franchise | 银行卡品牌 | string | VISA | Required | 银行卡品牌 |
| 6.2.50 | issuerName | 发卡机构名称 | string | issuer | Required | 发卡机构名称 |
| 6.2.51 | lastFourDigits | 银行卡后四位 | string | 1234 | Required | 银行卡后四位 |
| 6.2.52 | orderMp | 美客多订单ID | string | MLB001 | Required | 美客多订单ID |
| 6.2.53 | avkId | 跨行清算标识 | string | AVK001 | Required | 跨行清算标识 |
| 6.2.54 | purchaseId | 购买ID | string | PURCHASE001 | Required | 购买ID |
| 6.2.55 | shippingOrderId | 配送关联ID | string | DELIVERY001 | Required | 配送关联ID |
| 6.2.56 | gmtCreate | 创建日期 | string | 2026-01-01 00:00:00 | Required | 创建日期 |
| 6.2.57 | gmtModified | 更新日期 | string | 2026-01-01 00:00:00 | Required | 更新日期 |
| 6.2.58 | storeName | 店铺名称 | string | Mercado Store | Required | 店铺名称 |
| 6.2.59 | others | 其他 | object | — | Required | 其他 |
| 6.2.60 | includedInSettlement | 计入结算 | boolean | true | Required | 计入结算 |
| 6.2.61 | saleQuantity | 销售数量 | string | 1 | Required | 销售数量 |
| 6.2.62 | refundQuantity | 退款数量 | string | 0 | Required | 退款数量 |
| 6.3 | totalSum | 汇总数据 | object | — | Required | 汇总数据 |
| 6.3.1 | netCreditAmount | 净入账金额 | number | 100 | Required | 净入账金额 |
| 6.3.2 | netDebitAmount | 净出账金额 | number | 0 | Required | 净出账金额 |
| 6.3.3 | grossAmount | 总金额 | number | 100 | Required | 总金额 |
| 6.3.4 | sellerAmount | 分期购买付款金额 | number | 100 | Required | 分期购买付款金额 |
| 6.3.5 | mpFeeAmount | 平台佣金 | number | 10 | Required | 平台佣金 |
| 6.3.6 | financingFeeAmount | 分期手续费 | number | 1 | Required | 分期手续费 |
| 6.3.7 | shippingFeeAmount | 平台物流费 | number | 5 | Required | 平台物流费 |
| 6.3.8 | taxesAmount | 税费 | number | 3 | Required | 税费 |
| 6.3.9 | couponAmount | 优惠金额 | number | 2 | Required | 优惠金额 |
| 6.3.10 | currency | 币种 | string | USD | Required | 币种 |
| 6.3.11 | taxAmountTelco | 电信服务税 | number | 0 | Required | 电信服务税 |
| 6.3.12 | effectiveCouponAmount | 实际优惠金额 | number | 2 | Required | 实际优惠金额 |
| 6.3.13 | currencyIcon | 币种图片 | string | $ | Required | 币种图片 |
| 6.3.14 | totalCount | 总数 | integer | 1 | Required | 总数 |
| 6.3.15 | saleQuantity | 销售数量 | string | 1 | Required | 销售数量 |
| 6.3.16 | refundQuantity | 退款数量 | string | 0 | Required | 退款数量 |
| 6.3.17 | others | 其他 | string | — | Required | 其他 |
| 7 | total | 总数 | integer | 1 | Required | 总数 |
The 美客多账单明细 API (/basicOpen/multiplatformFinance/mercado/bill/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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.