采购查询Json
采购订单
ParamKey字段： DlyOrderData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 150 |
| 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": 1,
"vchtype": 150,
"date": "2020-07-07",
"number": "JD-2020-07-07-00001",
"btypeid": "00005",
"busercode": "001",
"bfullname": "1",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"etypeid": "",
"eusercode": "",
"efullname": "",
"dtypeid": "",
"dusercode": "",
"dfullname": "",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 531.1,
"summary": "从【供应商001】订货购进【存货002】等:",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2020-07-07 10:50:43",
"source1": "1",
"source2": "1",
"detail": [
{
"vchcode": 1,
"vchtype": 150,
"dlyorder": 1,
"ptypeid": "00002",
"pusercode": "002",
"pfullname": "存货002",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 20,
"total": 200,
"discount": 1,
"discountprice": 20,
"discounttotal": 200,
"tax": 13,
"taxprice": 22.6,
"taxtotal": 26,
"tax_total": 226,
"qtyother": 0,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"detailsign": 0,
"source1": "1",
"source2": "1_1",
"serialno": []
},
{
"vchcode": 1,
"vchtype": 150,
"dlyorder": 2,
"ptypeid": "00003",
"pusercode": "003",
"pfullname": "存货003",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 12,
"total": 120,
"discount": 1,
"discountprice": 12,
"discounttotal": 120,
"tax": 13,
"taxprice": 13.56,
"taxtotal": 15.6,
"tax_total": 135.6,
"qtyother": 0,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"detailsign": 0,
"source1": "1",
"source2": "1_2",
"serialno": []
},
{
"vchcode": 1,
"vchtype": 150,
"dlyorder": 3,
"ptypeid": "00004",
"pusercode": "004",
"pfullname": "存货004",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "",
"kusercode": "",
"kfullname": "",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 15,
"total": 150,
"discount": 1,
"discountprice": 15,
"discounttotal": 150,
"tax": 13,
"taxprice": 16.95,
"taxtotal": 19.5,
"tax_total": 169.5,
"qtyother": 0,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"detailsign": 0,
"source1": "1",
"source2": "1_3",
"serialno": []
}
]
}
]
}
采购单查询
ParamKey字段： DlyBuyData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 34 |
| 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": 22,
"vchtype": 34,
"date": "2021-03-01",
"number": "JH-2021-03-01-00001",
"btypeid": "00007",
"busercode": "003",
"bfullname": "3",
"settlebtypeid": "00007",
"settlebusercode": "003",
"settlebfullname": "3",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00004",
"eusercode": "00004",
"efullname": "职员003",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00002",
"dusercode": "002",
"dfullname": "部门002",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 1130,
"billtotal": 1130,
"summary": "从【3】购进【存货004】等:职员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-01 16:08:06",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "22",
"source2": "22",
"detail": [
{
"vchcode": 22,
"vchtype": 34,
"dlyorder": 1,
"ptypeid": "00004",
"pusercode": "004",
"pfullname": "存货004",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 100,
"price": 10,
"total": 1000,
"discount": 1,
"discountprice": 10,
"discounttotal": 1000,
"tax": 13,
"taxprice": 11.3,
"taxtotal": 130,
"tax_total": 1130,
"qtyother": 0,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"detailsign": 0,
"source1": "22",
"source2": "22_1",
"serialno": []
}
],
"settle": [
{
"vchcode": 22,
"vchtype": 34,
"dlyorder": 40,
"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": "22",
"source2": ""
}
]
}
]
}
采购退货单查询
ParamKey字段： DlyBuyData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 6 |
| 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": 24,
"vchtype": 6,
"date": "2021-03-01",
"number": "JT-2021-03-01-00001",
"btypeid": "00005",
"busercode": "001",
"bfullname": "1",
"settlebtypeid": "00005",
"settlebusercode": "001",
"settlebfullname": "1",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00004",
"eusercode": "00004",
"efullname": "职员003",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00002",
"dusercode": "002",
"dfullname": "部门002",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 12554.3,
"billtotal": 12554.3,
"summary": "采购退货【存货001】等给【1】:职员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-01 17:04:11",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "24",
"source2": "24",
"detail": [
{
"vchcode": 24,
"vchtype": 6,
"dlyorder": 2,
"ptypeid": "00001",
"pusercode": "001",
"pfullname": "存货001",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 1111,
"total": 11110,
"discount": 1,
"discountprice": 1111,
"discounttotal": 11110,
"tax": 13,
"taxprice": 1255.43,
"taxtotal": 1444.3,
"tax_total": 12554.3,
"qtyother": 0,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"detailsign": 0,
"source1": "24",
"source2": "24_2",
"serialno": []
}
],
"settle": []
}
]
}