销售查询Json
销售订单查询
ParamKey字段： DlyOrderData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 151 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| BeginDate | 是 | string | 查询开始日期 格式：yyyy-MM-dd |
| EndDate | 是 | string | 查询结束日期 格式：yyyy-MM-dd |
接口状态
已完成
接口URL
请求方式
POST
Content-Type
urlencoded
认证方式
noauth
预执行脚本
暂无预执行脚本
后执行脚本
暂无后执行脚本
成功响应示例
{
"code": "0",
"message": "",
"pagecount": 2,
"response": [
{
"rownum": 1,
"vchcode": 2,
"vchtype": 151,
"date": "2020-07-07",
"number": "SD-2020-07-07-00001",
"btypeid": "00001",
"busercode": "001",
"bfullname": "单位001",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"etypeid": "",
"eusercode": "",
"efullname": "",
"dtypeid": "",
"dusercode": "",
"dfullname": "",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 565,
"summary": "销售订货【存货003】等给【单位001】:",
"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:51:10",
"source1": "2",
"source2": "2",
"detail": [
{
"vchcode": 2,
"vchtype": 151,
"dlyorder": 4,
"ptypeid": "00003",
"pusercode": "003",
"pfullname": "存货003",
"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": 50,
"total": 500,
"discount": 1,
"discountprice": 50,
"discounttotal": 500,
"tax": 13,
"taxprice": 56.5,
"taxtotal": 65,
"tax_total": 565,
"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": "2",
"source2": "2_4",
"serialno": []
}
]
},
{
"rownum": 2,
"vchcode": 3,
"vchtype": 151,
"date": "2020-09-01",
"number": "SD-2020-09-01-00002",
"btypeid": "00003",
"busercode": "003",
"bfullname": "单位003",
"ktypeid": "00001",
"kusercode": "001",
"kfullname": "1",
"etypeid": "",
"eusercode": "",
"efullname": "",
"dtypeid": "",
"dusercode": "",
"dfullname": "",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 8908.92,
"summary": "销售订货【存货006】等给【单位003】:",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2020-09-01 10:34:30",
"source1": "3",
"source2": "3",
"detail": [
{
"vchcode": 3,
"vchtype": 151,
"dlyorder": 5,
"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": 233,
"price": 12,
"total": 2796,
"discount": 1,
"discountprice": 12,
"discounttotal": 2796,
"tax": 13,
"taxprice": 13.56,
"taxtotal": 363.48,
"tax_total": 3159.48,
"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": "3",
"source2": "3_5",
"serialno": []
},
{
"vchcode": 3,
"vchtype": 151,
"dlyorder": 6,
"ptypeid": "00005",
"pusercode": "005",
"pfullname": "存货005",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00003",
"kusercode": "003",
"kfullname": "3",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 156,
"price": 23,
"total": 3588,
"discount": 1,
"discountprice": 23,
"discounttotal": 3588,
"tax": 13,
"taxprice": 25.99,
"taxtotal": 466.44,
"tax_total": 4054.44,
"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": "3",
"source2": "3_6",
"serialno": []
},
{
"vchcode": 3,
"vchtype": 151,
"dlyorder": 7,
"ptypeid": "00004",
"pusercode": "004",
"pfullname": "存货004",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00002",
"kusercode": "002",
"kfullname": "2",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 100,
"price": 15,
"total": 1500,
"discount": 1,
"discountprice": 15,
"discounttotal": 1500,
"tax": 13,
"taxprice": 16.95,
"taxtotal": 195,
"tax_total": 1695,
"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": "3",
"source2": "3_7",
"serialno": []
}
]
}
]
}
销售单查询
ParamKey字段： DlySaleData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 11 |
| Vchcode | 否 | int | 单据唯一编码，生单接口成功时返回的Code |
| Number | 否 | string | 单据编号 |
| 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": 21,
"vchtype": 11,
"date": "2020-12-16",
"number": "XS-2020-12-16-00001",
"btypeid": "00002",
"busercode": "002",
"bfullname": "单位002",
"settlebtypeid": "00002",
"settlebusercode": "002",
"settlebfullname": "单位002",
"ktypeid": "00002",
"kusercode": "002",
"kfullname": "2",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "",
"eusercode": "",
"efullname": "",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "",
"dusercode": "",
"dfullname": "",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 11.3,
"billtotal": 11.3,
"summary": "销售【存货002】等给【单位002】:",
"gatheringdate": "",
"userdefined01": "",
"userdefined02": "",
"userdefined03": "",
"userdefined04": "",
"userdefined05": "",
"userdefined06": "",
"userdefined07": "",
"userdefined08": "",
"userdefined09": "",
"userdefined10": "",
"userdefined11": "",
"userdefined12": "",
"userdefined13": "",
"userdefined14": 0,
"userdefined15": 0,
"userdefined16": 0,
"inputno": "会计主管",
"savetime": "2021-01-07 15:30:15",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "21",
"source2": "21",
"detail": [
{
"vchcode": 21,
"vchtype": 11,
"dlyorder": 1,
"ptypeid": "00002",
"pusercode": "002",
"pfullname": "存货002",
"pstandard": "",
"ptype": "",
"unit": 1,
"unitname": "",
"barcode": "",
"ktypeid": "00002",
"kusercode": "002",
"kfullname": "2",
"custom1": "",
"c1usercode": "",
"c1fullname": "",
"custom2": "",
"c2usercode": "",
"c2fullname": "",
"custom3": "",
"custom4": "",
"blockno": "",
"prodate": "",
"comment": "",
"qty": 10,
"price": 1,
"total": 10,
"discount": 1,
"discountprice": 1,
"discounttotal": 10,
"tax": 13,
"taxprice": 1.13,
"taxtotal": 1.3,
"tax_total": 11.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": "21",
"source2": "21_1",
"serialno": []
}
],
"settle": []
}
]
}
销售退货单查询
ParamKey字段： DlySaleData
ParamJson字段：
| 参数名 | 必选 | 类型 | 说明 |
|---|---|---|---|
| PageSize | 是 | int | 每页返回个数 最大200 |
| PageIndex | 是 | int | 页码 |
| VchType | 是 | int | 单据类型 45 |
| 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": 23,
"vchtype": 45,
"date": "2021-03-01",
"number": "XT-2021-03-01-00001",
"btypeid": "00002",
"busercode": "002",
"bfullname": "单位002",
"settlebtypeid": "00002",
"settlebusercode": "002",
"settlebfullname": "单位002",
"ktypeid": "00004",
"kusercode": "004",
"kfullname": "4",
"ktypeid2": "",
"k2usercode": "",
"k2fullname": "",
"etypeid": "00001",
"eusercode": "00001",
"efullname": "会计主管",
"etypeid2": "",
"e2usercode": "",
"e2fullname": "",
"dtypeid": "00001",
"dusercode": "001",
"dfullname": "部门001",
"mtypeid": "",
"musercode": "",
"mfullname": "",
"total": 113,
"billtotal": 113,
"summary": "【单位002】销售退货【存货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-01 16:36:13",
"difatype": 0,
"difatypename": "",
"atypeid": "",
"mltotal": 0,
"source1": "23",
"source2": "23",
"detail": [
{
"vchcode": 23,
"vchtype": 45,
"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": 10,
"total": 100,
"discount": 1,
"discountprice": 10,
"discounttotal": 100,
"tax": 13,
"taxprice": 11.3,
"taxtotal": 13,
"tax_total": 113,
"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": "23",
"source2": "23_2",
"serialno": []
}
],
"settle": [
{
"vchcode": 23,
"vchtype": 45,
"dlyorder": 44,
"atypeid": "0000100002",
"ausercode": "1002",
"afullname": "银行存款",
"total": -10,
"freedom01": "",
"freedom02": "",
"freedom03": "",
"freedom04": "",
"freedom05": "",
"freedom06": "",
"freedom07": "",
"freedom08": "",
"freedom09": "",
"freedom10": "",
"freedom11": "",
"freedom12": "",
"freedom13": "",
"freedom14": 0,
"freedom15": 0,
"freedom16": 0,
"freedomdatedif": 0,
"source1": "23",
"source2": ""
}
]
}
]
}