收付款查询Json
收款单查询
ParamKey字段： DlyGatheringData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 4 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| BeginDate | 是 | string | 查询开始日期 格式：yyyy-MM-dd |
| EndDate | 是 | string | 查询结束日期 格式：yyyy-MM-dd |
接口状态
已完成
接口URL
请求方式
POST
Content-Type
urlencoded
认证方式
noauth
预执行脚本
暂无预执行脚本
后执行脚本
暂无后执行脚本
成功响应示例
{
"code": "0",
"message": "",
"pagecount": 1,
"response": [
{
"rownum": 1,
"vchcode": 27,
"vchtype": 4,
"date": "2021-03-02",
"number": "SK-2021-03-02-00001",
"btypeid": "00002",
"busercode": "002",
"bfullname": "单位002",
"settlebtypeid": "00002",
"settlebusercode": "002",
"settlebfullname": "单位002",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00001",
"eusercode": "00001",
"efullname": "会计主管",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00001",
"dusercode": "001",
"dfullname": "部门001",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 100,
"billtotal": 100,
"summary": "【库存现金】等:100元【单位002】:会计主管",
"gatheringdate": "",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2021-03-02 10:03:34",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "27",
"source2": "27",
"detail": [
{
"vchcode": 27,
"vchtype": 4,
"dlyorder": 61,
"usedtype": "1",
"atypeid": "0000100001",
"ausercode": "1001",
"afullname": "库存现金",
"total": 100,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "27",
"source2": ""
}
],
"gatherdetail": [
{
"vchcode": 27,
"vchtype": 4,
"dlyorder": 62,
"atypeid": "0000100122",
"ausercode": "1122",
"afullname": "应收账款",
"total": 140,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "27",
"source2": ""
}
],
"orderdetail": [
{
"sourcevchcode": 21,
"sourcevchtype": 11,
"sourcedlyorder": 0,
"sourcetimestamp": 272705,
"number": "XS-2020-12-16-00001",
"date": "2020-12-16",
"summary": "销售【存货002】等给【单位002】:",
"pusercode": "",
"pfullname": "",
"receivebusercode": "002",
"receivebfullname": "单位002",
"billtotal": 11.3,
"billbalanceedtotal": 0,
"billbalancetotal": 11.3,
"total": 10,
"billcurbalancetotal": 1.3,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"ftypeid": "",
"ct1fullname": "",
"stypeid": "",
"ct2fullname": "",
"c3typeid": "",
"c4typeid": "",
"blockno": "",
"prodate": "",
"source1": "27",
"source2": ""
},
{
"sourcevchcode": 23,
"sourcevchtype": 45,
"sourcedlyorder": 0,
"sourcetimestamp": 280710,
"number": "XT-2021-03-01-00001",
"date": "2021-03-01",
"summary": "【单位002】销售退货【存货001】等:会计主管",
"pusercode": "",
"pfullname": "",
"receivebusercode": "002",
"receivebfullname": "单位002",
"billtotal": -113,
"billbalanceedtotal": -10,
"billbalancetotal": -103,
"total": -50,
"billcurbalancetotal": -53,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"ftypeid": "",
"ct1fullname": "",
"stypeid": "",
"ct2fullname": "",
"c3typeid": "",
"c4typeid": "",
"blockno": "",
"prodate": "",
"source1": "27",
"source2": ""
}
]
}
]
}
付款单查询
ParamKey字段： DlyPaymentData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 66 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| BeginDate | 是 | string | 查询开始日期 格式：yyyy-MM-dd |
| EndDate | 是 | string | 查询结束日期 格式：yyyy-MM-dd |
接口状态
已完成
接口URL
请求方式
POST
Content-Type
urlencoded
认证方式
noauth
预执行脚本
暂无预执行脚本
后执行脚本
暂无后执行脚本
成功响应示例
{
"code": "0",
"message": "",
"pagecount": 1,
"response": [
{
"rownum": 1,
"vchcode": 28,
"vchtype": 66,
"date": "2021-03-02",
"number": "FK-2021-03-02-00001",
"btypeid": "00007",
"busercode": "003",
"bfullname": "3",
"settlebtypeid": "00007",
"settlebusercode": "003",
"settlebfullname": "3",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00002",
"eusercode": "00002",
"efullname": "职员001",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00004",
"dusercode": "004",
"dfullname": "部门004",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 1000,
"billtotal": 1000,
"summary": "【银行存款】等:1000元【3】:职员001",
"gatheringdate": "",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2021-03-02 10:10:23",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "28",
"source2": "28",
"detail": [
{
"vchcode": 28,
"vchtype": 66,
"dlyorder": 64,
"usedtype": "1",
"atypeid": "0000100002",
"ausercode": "1002",
"afullname": "银行存款",
"total": 1000,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "28",
"source2": ""
}
],
"paydetail": [
{
"vchcode": 28,
"vchtype": 66,
"dlyorder": 65,
"atypeid": "000020020200001",
"ausercode": "220201",
"afullname": "应付货款",
"total": 900,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "28",
"source2": ""
}
],
"orderdetail": [
{
"sourcevchcode": 22,
"sourcevchtype": 34,
"sourcedlyorder": 0,
"sourcetimestamp": 280705,
"number": "JH-2021-03-01-00001",
"date": "2021-03-01",
"summary": "从【3】购进【存货004】等:职员003",
"pusercode": "",
"pfullname": "",
"sendbusercode": "003",
"sendbfullname": "3",
"billtotal": 1130,
"billbalanceedtotal": 1000,
"billbalancetotal": 130,
"total": 100,
"billcurbalancetotal": 30,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"ftypeid": "",
"ct1fullname": "",
"stypeid": "",
"ct2fullname": "",
"c3typeid": "",
"c4typeid": "",
"blockno": "",
"prodate": "",
"source1": "28",
"source2": ""
}
]
}
]
}
其他收款业务查询
ParamKey字段： DlyOtherSettleData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 93 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| BeginDate | 是 | string | 查询开始日期 格式：yyyy-MM-dd |
| EndDate | 是 | string | 查询结束日期 格式：yyyy-MM-dd |
接口状态
已完成
接口URL
请求方式
POST
Content-Type
urlencoded
认证方式
noauth
预执行脚本
暂无预执行脚本
后执行脚本
暂无后执行脚本
成功响应示例
{
"code": "0",
"message": "",
"pagecount": 1,
"response": [
{
"rownum": 1,
"vchcode": 29,
"vchtype": 93,
"date": "2021-03-02",
"number": "QTS-2021-03-02-00001",
"btypeid": "00005",
"busercode": "001",
"bfullname": "1",
"settlebtypeid": "00005",
"settlebusercode": "001",
"settlebfullname": "1",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00002",
"eusercode": "00002",
"efullname": "职员001",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00004",
"dusercode": "004",
"dfullname": "部门004",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 100,
"billtotal": 100,
"summary": "现金销售产品",
"gatheringdate": "",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2021-03-02 10:17:38",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "29",
"source2": "29",
"detail": [
{
"vchcode": 29,
"vchtype": 93,
"dlyorder": 67,
"atypeid": "0000100002",
"ausercode": "1002",
"afullname": "银行存款",
"total": 100,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "29",
"source2": ""
}
],
"settledetail": [
{
"vchcode": 29,
"vchtype": 93,
"dlyorder": 68,
"atypeid": "0000100001",
"ausercode": "1001",
"afullname": "库存现金",
"total": 100,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "29",
"source2": ""
}
]
}
]
}
其他付款业务查询
ParamKey字段： DlyOtherSettleData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 36 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| BeginDate | 是 | string | 查询开始日期 格式：yyyy-MM-dd |
| EndDate | 是 | string | 查询结束日期 格式：yyyy-MM-dd |
接口状态
已完成
接口URL
请求方式
POST
Content-Type
urlencoded
认证方式
noauth
预执行脚本
暂无预执行脚本
后执行脚本
暂无后执行脚本
成功响应示例
{
"code": "0",
"message": "",
"pagecount": 1,
"response": [
{
"rownum": 1,
"vchcode": 35,
"vchtype": 36,
"date": "2021-03-04",
"number": "QTF-2021-03-04-00001",
"btypeid": "00007",
"busercode": "003",
"bfullname": "3",
"settlebtypeid": "00007",
"settlebusercode": "003",
"settlebfullname": "3",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00004",
"eusercode": "00004",
"efullname": "职员003",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00004",
"dusercode": "004",
"dfullname": "部门004",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 200,
"billtotal": 200,
"summary": "【库存现金】等其它付款共200元:职员003",
"gatheringdate": "",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2021-03-04 09:39:37",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "35",
"source2": "35",
"detail": [
{
"vchcode": 35,
"vchtype": 36,
"dlyorder": 72,
"atypeid": "0000100001",
"ausercode": "1001",
"afullname": "库存现金",
"total": 100,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "35",
"source2": ""
},
{
"vchcode": 35,
"vchtype": 36,
"dlyorder": 73,
"atypeid": "0000100003",
"ausercode": "1003",
"afullname": "存放中央银行款项",
"total": 100,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "35",
"source2": ""
}
],
"settledetail": [
{
"vchcode": 35,
"vchtype": 36,
"dlyorder": 74,
"atypeid": "0000100021",
"ausercode": "1021",
"afullname": "结算备付金",
"total": 200,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "35",
"source2": ""
}
]
}
]
}