查询VC结算发票列表
POST
/basicOpen/finance/vc/invoice/page支持查询结算发票列表中的VC采购发票和合作费用发票,包含分页信息及付款明细。
接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/basicOpen/finance/vc/invoice/page | HTTPS | POST | 1 |
请求参数
pageNumintegerpageSizeintegercountryListarray<any>sidListarray<any>invoiceTypeListarray<any>fundingTypeListarray<any>invoiceStatusListarray<any>startDatestring必填endDatestring必填payeeCodeListarray<any>dateTypestringsearchFieldstringsearchValuestringsearchValueListarray<any>请求cURL示例
curl --location 'https://openapi.lingxing.com/basicOpen/finance/vc/invoice/page?access_token=value×tamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
"pageNum": 1,
"pageSize": 20,
"countryList": [],
"sidList": [],
"invoiceTypeList": [],
"paymentStatus": "",
"fundingTypeList": [],
"invoiceStatusList": [],
"startDate": "2025-08-01",
"endDate": "2026-08-01",
"payeeCodeList": [],
"dateType": "invoice",
"searchField": "invoiceNumber",
"searchValue": "",
"searchValueList": []
}'
返回结果
Json Object
codeinteger必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填dataobject必填隐藏子属性
totalinteger必填sizeinteger必填pageCountinteger必填currentinteger必填currentSizeinteger必填recordsarray<object>必填隐藏子属性
sidinteger必填storeNamestring必填countrystring必填invoiceNumberstring必填invoiceTypestring必填invoiceDateStrstring必填isPaidboolean必填paymentResponseListarray<object>必填隐藏子属性
sidinteger必填invoiceNumberstring必填invoiceNumberExtractstring必填currencyCodestring必填amountPaidnumber必填remainingAmountnumber必填invoiceAmountnumber必填withholdingAmountnumber必填termsDiscountTakennumber必填invoiceCurrencystring必填descriptionstring必填paymentNumberstring必填paymentDateStrstring必填currencyCodestring必填paymentDueDateStrstring必填payeeCodestring必填purchaseOrderNumberstring必填invoiceStatusstring必填invoiceCurrencySymbolstring必填invoiceAmountnumber必填actualPaidAmountnumber必填inProgressAmountnumber必填totalMatchedToDateAmountnumber必填queuedForPaymentAmountnumber必填quantityVarianceAmountnumber必填priceVarianceAmountnumber必填quickPayDiscountnumber必填agreementIdinteger必填agreementTitlestring必填fundingTypestring必填originalBalancenumber必填originalBalanceCurrencystring必填hasNextPageboolean必填hasPreviousPageboolean必填totalinteger必填返回成功示例
{
"code": 0,
"message": "success",
"error_details": [],
"request_id": "a0d54debf93140f3b58d1ed81e8e3583",
"response_time": "2026-10-12 12:00:00",
"data": {
"total": 2,
"size": 20,
"pageCount": 1,
"current": 1,
"currentSize": 2,
"records": [
{
"sid": 134225003201380860,
"storeName": "VC美国店铺",
"country": "US",
"invoiceNumber": "INV-250806-01",
"invoiceType": "invoice",
"invoiceDateStr": "2025-08-06",
"isPaid": true,
"paymentResponseList": [
{
"sid": 134225003201380860,
"invoiceNumber": "INV-250806-01PC",
"invoiceNumberExtract": "INV-250806-01",
"currencyCode": "USD",
"amountPaid": -78.01,
"remainingAmount": 0,
"invoiceAmount": 78.8,
"withholdingAmount": 0,
"termsDiscountTaken": 0.79,
"invoiceCurrency": "$",
"description": "1RX2O6YR/RDU4/",
"paymentNumber": "366666688",
"paymentDateStr": "2025-08-07"
}
],
"currencyCode": "USD",
"paymentDueDateStr": "2025-09-17",
"payeeCode": "B0806",
"purchaseOrderNumber": "PO25080601",
"invoiceStatus": "UNPAID",
"invoiceCurrencySymbol": "$",
"invoiceAmount": 370,
"actualPaidAmount": 0,
"inProgressAmount": 370,
"totalMatchedToDateAmount": 370,
"queuedForPaymentAmount": 370,
"quantityVarianceAmount": 0,
"priceVarianceAmount": 0,
"quickPayDiscount": 0,
"agreementId": null,
"agreementTitle": null,
"fundingType": null,
"originalBalance": null,
"originalBalanceCurrency": null
},
{
"sid": 134225003201380860,
"storeName": "VC美国店铺",
"country": "US",
"invoiceNumber": "2050-1414856005",
"invoiceType": "coop",
"invoiceDateStr": "2026-05-14",
"isPaid": false,
"paymentResponseList": [],
"currencyCode": "USD",
"paymentDueDateStr": null,
"payeeCode": null,
"purchaseOrderNumber": null,
"invoiceStatus": null,
"invoiceCurrencySymbol": null,
"invoiceAmount": null,
"actualPaidAmount": null,
"inProgressAmount": null,
"totalMatchedToDateAmount": null,
"queuedForPaymentAmount": null,
"quantityVarianceAmount": null,
"priceVarianceAmount": null,
"quickPayDiscount": null,
"agreementId": 107450800,
"agreementTitle": "合作费用协议示例",
"fundingType": "Vendor Funded Sales Discount",
"originalBalance": 90.09,
"originalBalanceCurrency": "$"
}
],
"hasNextPage": false,
"hasPreviousPage": false
},
"total": 2
}
附加说明
- 固定筛选枚举来自HAR中实际请求值;店铺ID、国家ID和供应商编码均由客户直接传入。
- 前端状态选项
PROCESSING,PENDING_AMAZON_ACTION是一个含逗号的字符串。请求示例:{"invoiceStatusList":["PROCESSING,PENDING_AMAZON_ACTION"]},不要拆成两个数组元素。 - 普通查询示例使用空数组和空字符串。筛选示例:
{"invoiceTypeList":["invoice"],"fundingTypeList":["Accrual"],"invoiceStatusList":["UNPAID"],"payeeCodeList":["B0806"]};需与必填日期一起传入。 - 批量搜索示例:
{"searchField":"purchaseOrderNumber","searchValue":"","searchValueList":["PO25080601","PO25080502"]};需与必填日期一起传入。单值与批量搜索的优先级由上游决定,建议只选一种。 invoice与coop返回相同明细结构,但适用字段不同:样本中的采购发票没有合作协议及原始余额信息,合作费用发票的采购订单及部分付款金额字段为空。isPaid、invoiceStatus、actualPaidAmount及付款明细均保留上游结果,不相互推导;测试样本存在isPaid=true、invoiceStatus=UNPAID的记录。- 金额使用十进制数值返回;上游金额字符串会转换为数值,空值不转换成0。付款明细
amountPaid可能为负数。 sid、agreementId是长整型;使用JavaScript时避免浮点转换丢失精度。提交sidList时也可使用数字字符串,例如["134225003201380864"]。countryList接收国家ID,响应records[].country为国家代码,不能直接互换。