库存业务单据Json
其他入库单查询
ParamKey字段： DlyOtherData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 140 |
| 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": 25,
"vchtype": 140,
"date": "2021-03-01",
"number": "RK-2021-03-01-00001",
"btypeid": "00006",
"busercode": "002",
"bfullname": "2",
"settlebtypeid": "00006",
"settlebusercode": "002",
"settlebfullname": "2",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00004",
"eusercode": "00004",
"efullname": "职员003",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00003",
"dusercode": "003",
"dfullname": "部门003",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 12630,
"billtotal": 12630,
"summary": "入库【存货001】等到【4】:职员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:06:08",
"difatype": 30,
"difatypename": "获赠",
"atypeid": "0000600301",
"mltotal": 0,
"source1": "25",
"source2": "25",
"detail": [
{
"vchcode": 25,
"vchtype": 140,
"dlyorder": 73,
"usedtype": "1",
"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": 1263,
"price": 10,
"total": 12630,
"discount": 1,
"discountprice": 10,
"discounttotal": 12630,
"tax": 0,
"taxprice": 10,
"taxtotal": 0,
"tax_total": 12630,
"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": "25",
"source2": "25_73",
"serialno": []
}
],
"settle": []
}
]
}
其他出库单查询
ParamKey字段： DlyOtherData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 141 |
| 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": 26,
"vchtype": 141,
"date": "2021-03-02",
"number": "CK-2021-03-02-00001",
"btypeid": "00005",
"busercode": "001",
"bfullname": "1",
"settlebtypeid": "00005",
"settlebusercode": "001",
"settlebfullname": "1",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00001",
"eusercode": "00001",
"efullname": "会计主管",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00001",
"dusercode": "001",
"dfullname": "部门001",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 13653,
"billtotal": 13653,
"summary": "从【1】出库【存货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 09:46:33",
"difatype": 31,
"difatypename": "赠送",
"atypeid": "0000700018",
"mltotal": 0,
"source1": "26",
"source2": "26",
"detail": [
{
"vchcode": 26,
"vchtype": 141,
"dlyorder": 74,
"usedtype": "1",
"ptypeid": "00001",
"pusercode": "001",
"pfullname": "存货001",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00003",
"kusercode": "003",
"kfullname": "3",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 123,
"price": 111,
"total": 13653,
"discount": 1,
"discountprice": 111,
"discounttotal": 13653,
"tax": 0,
"taxprice": 111,
"taxtotal": 0,
"tax_total": 13653,
"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": "26",
"source2": "26_74",
"serialno": []
}
],
"settle": []
}
]
}
调拨单查询
ParamKey字段： DlyOtherData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 21 |
| 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": 31,
"vchtype": 21,
"date": "2021-03-02",
"number": "DB-2021-03-02-00001",
"btypeid": "",
"busercode": "",
"bfullname": "",
"settlebtypeid": "",
"settlebusercode": "",
"settlebfullname": "",
"ktypeid": "00003",
"kusercode": "003",
"kfullname": "3",
"ktypeid2": "00001",
"k2usercode": "001",
"k2fullname": "1",
"etypeid": "00002",
"eusercode": "00002",
"efullname": "职员001",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00004",
"dusercode": "004",
"dfullname": "部门004",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 10000,
"billtotal": 10000,
"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 14:20:01",
"difatype": 26,
"difatypename": "异价调拨",
"atypeid": "0000700001",
"mltotal": 0,
"source1": "31",
"source2": "31",
"detail": [
{
"vchcode": 31,
"vchtype": 21,
"dlyorder": 78,
"usedtype": "1",
"ptypeid": "00001",
"pusercode": "001",
"pfullname": "存货001",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00003",
"kusercode": "003",
"kfullname": "3",
"ktypeid2": "00001",
"kusercode2": "001",
"kfullname2": "1",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 100,
"price": 100,
"total": 10000,
"discount": 1,
"discountprice": 100,
"discounttotal": 10000,
"tax": 0,
"taxprice": 100,
"taxtotal": 0,
"tax_total": 10000,
"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": "31",
"source2": "31_78",
"serialno": []
}
],
"settle": []
}
]
}
组装拆分单查询
ParamKey字段： DlyBuildSplitData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 16 |
| 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": 30,
"vchtype": 16,
"date": "2021-03-02",
"number": "CZ-2021-03-02-00001",
"btypeid": "",
"busercode": "",
"bfullname": "",
"settlebtypeid": "",
"settlebusercode": "",
"settlebfullname": "",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"ktypeid2": "00001",
"k2usercode": "001",
"k2fullname": "1",
"etypeid": "00002",
"eusercode": "00002",
"efullname": "职员001",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00004",
"dusercode": "004",
"dfullname": "部门004",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 200,
"billtotal": 200,
"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:51:49",
"difatype": 27,
"difatypename": "组装差额",
"atypeid": "000050000100001",
"mltotal": 0,
"source1": "30",
"source2": "30",
"outdetail": [
{
"vchcode": 30,
"vchtype": 16,
"dlyorder": 75,
"usedtype": "1",
"ptypeid": "00001",
"pusercode": "001",
"pfullname": "存货001",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 2,
"price": 0,
"total": 0,
"discount": 1,
"discountprice": 0,
"discounttotal": 0,
"tax": 0,
"taxprice": 0,
"taxtotal": 0,
"tax_total": 0,
"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": "30",
"source2": "30_75",
"serialno": []
},
{
"vchcode": 30,
"vchtype": 16,
"dlyorder": 76,
"usedtype": "1",
"ptypeid": "00002",
"pusercode": "002",
"pfullname": "存货002",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 5,
"price": 0,
"total": 0,
"discount": 1,
"discountprice": 0,
"discounttotal": 0,
"tax": 0,
"taxprice": 0,
"taxtotal": 0,
"tax_total": 0,
"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": "30",
"source2": "30_76",
"serialno": []
}
],
"indetail": [
{
"vchcode": 30,
"vchtype": 16,
"dlyorder": 77,
"usedtype": "2",
"ptypeid": "00006",
"pusercode": "006",
"pfullname": "存货006",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 20,
"total": 200,
"discount": 1,
"discountprice": 20,
"discounttotal": 200,
"tax": 0,
"taxprice": 20,
"taxtotal": 0,
"tax_total": 200,
"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": "30",
"source2": "30_77"
}
],
"settle": []
}
]
}