已付款明细导入

开发中

POST

http://127.0.0.1:8758/snc-settle/paymtPayDetail/importExcel

请求参数

Header 参数

Ssotoken

string

可选

默认值:

x-timestamp

string

可选

默认值:

1713748800833

x-signature

string

可选

默认值:

KUXSucUrpWVx4Cjfq8XNig7l3yKhqLycqDMoJhHJpPU=

x-app-id

string

可选

默认值:

sncsit

Body 参数multipart/form-data

columns

string

可选

示例值:

sheetid,companyCode,jvCode,supplierid,type,month,currencyCode,payamt,payflag,appdate,paydate,remark,refSheetId

begin

string

可选

示例值:

end

string

可选

示例值:

99999

file

可选

示例值:

file://C:\Users\luosiwei\Desktop\已付款明细导入模板.xlsx

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://127.0.0.1:8758/snc-settle/paymtPayDetail/importExcel' \
--header 'Ssotoken: {{accessToken}}' \
--header 'x-timestamp: 1713748800833' \
--header 'x-signature: KUXSucUrpWVx4Cjfq8XNig7l3yKhqLycqDMoJhHJpPU=' \
--header 'x-app-id: sncsit'

返回响应

🟢200成功

application/json

Body

returncode

string

必需

data

object

必需

ignoreCount

integer

必需

verifyMessage

array[string]

必需

successCount

integer

必需

remark

string

必需

rows

array [object {16}]

必需

totalCount

integer

必需

errorCount

integer

必需

message

string

必需

traceId

string

必需

now

string

必需

示例

{"returncode":"0","data":{"ignoreCount":0,"verifyMessage":[],"successCount":1,"remark":"","rows":[{"companyCode":"WGZ","supplierid":"1067634101","remark":"测试导入数据","type":"进货","message":"结算单不存在","payflag":"1","payamt":"180.15","paydate":"2023/12/14","refSheetId":"WGZ1000","__rownum":2,"result":"异常","month":"202307","sheetid":"PNWGZ2309016","jvCode":"998","appdate":"2023/10/10","currencyCode":"RMB"}],"totalCount":1,"errorCount":0},"message":"","traceId":"","now":"2023-12-14 15:57:20"}

修改于 2023-12-14 07:56:04

已付款明细批量删除

已付款明细查询