财务管理
账单获取
获取账单信息。
生产环境
https://ssl.glitzcloud.com/agent/v1/api/invoice/query测试环境
http://gztest.glitzcloud.com/agent/v1/api/invoice/query说明
1、功能名称：账单获取
2、功能描述：账单获取
请参阅鉴权签名说明。
请求参数
| 名称 | 类型 | 必填 | 示例值 | 描述 |
|---|---|---|---|---|
| store_name | String | 是 | The Warehouse USA | 仓库名称 |
| time_from | Integer | 是 | 1487606400 | 开始时间时间戳 |
| time_to | Integer | 是 | 1487606400 | 结束时间时间戳 |
返回字段
| 参数 | 类型 | 示例值 | 描述 |
|---|---|---|---|
| billing_sn | String | GCB17022100001 | 账单编号 |
| pay_status | Integer | 30 | 支付状态 10:未支付;20:用户确认;30:支付完成 |
| due_time | String | 2017-03-08 | 账单到期日 |
| confirm_time | String | 2017-02-21 | 账单确认时间 |
| pay_time | String | 2017-07-16 | 支付时间 |
| start_time | String | 2017-07-10 | 账单开始时间 |
| end_time | String | 2017-07-16 | 账单结束时间 |
| create_time | String | 2017-02-20 | 账单创建时间 |
| total_amount_all | Float | 111.41 | 账单总金额 |
| charge_name | String | 费用名称 | 费用名称 Inbound:入库;Outbound:出库;Return:退换货;Storage:仓储费;Relabeling:换标; |
| total_amount | Float | 分类费用总金额 | 77.71 |
| order_sn | String | 20170703001 | 入库单号,或者出库平台订单号或者退换货单号 |
| order_type | String | 1 | 订单类型1：入库单；2：出库单; 3:退货单 |
| charge_price | Float | 10.00 | 费用单价 |
| charge_amount | Float | 1 | 数量 |
| charge_discount | Float | 0.95 | 折扣 |
| charge_total | Float | 9.50 | 总费用 |
| charge_currency | String | usd | 币种 usd:美元;rmb:人民币 |
| pay_status | Integer | 0 | 支付状态 0:未支付 ;1:已支付 |
| create_time | String | 2017-05-23 14:50:11 | 费用生成时间 |
示例
请求示例
{
"format": "json",
"apikey": "85082f5f62a811e684f500163e06045f",
"randoms": 1234,
"sign": "656d6fbe6b7dec6c2e77ffe27f04bd6d",
"store_name": "The Warehouse USA",
"time_from": "1487606400",
"time_to": "1487606400"
}返回示例
{
"status": 200,
"reqMsg": "ok",
"result": [
{
"billing_sn": "GCB17071300001",
"pay_status": "10",
"due_time": "2017-07-28",
"confirm_time": "",
"pay_time": "",
"start_time": "2017-07-10",
"end_time": "2017-07-16",
"create_time": "2017-07-13 16:59:18",
"total_amount_all": 5.95,
"details": [
{
"charge_name": "Shipping",
"total_amount": 77.71,
"details": [
{
"order_sn": "Amy Yao-523452345fefed1",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": null,
"charge_amount": "1",
"charge_discount": "1.00",
"charge_total": "1.00",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-05-23 14:12:40"
},
{
"order_sn": "Amy Yao-20170510002",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": null,
"charge_amount": "1",
"charge_discount": "1.00",
"charge_total": "1.00",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-05-23 14:13:01"
},
{
"order_sn": "Amy Yao-20170510002",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "18.62",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "21.79",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-05-27 11:08:36"
},
{
"order_sn": "Amy Yao-Ronnie777",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "9.08",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "10.62",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-06-09 13:56:52"
},
{
"order_sn": "GCO16092600006-01",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "10.49",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "12.27",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-06-09 14:20:22"
},
{
"order_sn": "GCO16092600006-02",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "10.49",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "12.27",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-06-09 14:27:45"
},
{
"order_sn": "Amy Yao-312312312",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "6.71",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "9.38",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-03 13:14:28"
},
{
"order_sn": "Amy Yao-20170510001",
"order_type": "1",
"charge_name": "Shipping",
"charge_price": "6.71",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "9.38",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-03 13:22:00"
}
]
},
{
"charge_name": "FBA return receiving 1",
"total_amount": 1,
"details": [
{
"order_sn": "GCI17052300002",
"order_type": "1",
"charge_name": "FBA return receiving 1",
"charge_price": "1.00",
"charge_amount": "1",
"charge_discount": "1.00",
"charge_total": "1.00",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-05-23 14:50:11"
}
]
},
{
"charge_name": "FBA return receiving 2",
"total_amount": 8,
"details": [
{
"order_sn": "GCI17052300002",
"order_type": "1",
"charge_name": "FBA return receiving 2",
"charge_price": "2.00",
"charge_amount": "2",
"charge_discount": "2.00",
"charge_total": "8.00",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-05-23 14:50:11"
}
]
},
{
"charge_name": "Material",
"total_amount": 1.3,
"details": [
{
"order_sn": "Amy Yao-Ronnie777",
"order_type": "1",
"charge_name": "Material",
"charge_price": "1.00",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "1.30",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-06-09 13:56:52"
}
]
},
{
"charge_name": "Relabel",
"total_amount": 23.4,
"details": [
{
"order_sn": "REL17031300003",
"order_type": "1",
"charge_name": "Relabel",
"charge_price": "0.40",
"charge_amount": "1",
"charge_discount": "1.30",
"charge_total": "0.52",
"charge_currency": "USD",
"pay_status": "0",
"create_time": "2017-06-19 14:35:47"
},
{
"order_sn": "REL17061900001",
"order_type": "1",
"charge_name": "Relabel",
"charge_price": "0.40",
"charge_amount": "19",
"charge_discount": "1.30",
"charge_total": "9.88",
"charge_currency": "USD",
"pay_status": "0",
"create_time": "2017-06-19 14:52:04"
},
{
"order_sn": "REL17031300001",
"order_type": "1",
"charge_name": "Relabel",
"charge_price": "0.40",
"charge_amount": "8",
"charge_discount": "1.30",
"charge_total": "4.16",
"charge_currency": "USD",
"pay_status": "0",
"create_time": "2017-07-06 14:47:00"
},
{
"order_sn": "REL17031300002",
"order_type": "1",
"charge_name": "Relabel",
"charge_price": "0.40",
"charge_amount": "2",
"charge_discount": "1.30",
"charge_total": "1.04",
"charge_currency": "USD",
"pay_status": "0",
"create_time": "2017-07-06 14:48:11"
},
{
"order_sn": "REL17070500001",
"order_type": "1",
"charge_name": "Relabel",
"charge_price": "0.40",
"charge_amount": "15",
"charge_discount": "1.30",
"charge_total": "7.80",
"charge_currency": "USD",
"pay_status": "0",
"create_time": "2017-07-06 16:48:27"
}
]
},
{
"charge_name": "Discount",
"total_amount": -105.46,
"details": [
{
"order_sn": "",
"order_type": "1",
"charge_name": "Discount",
"charge_price": "-8.91",
"charge_amount": "1",
"charge_discount": null,
"charge_total": "-8.91",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-14 17:12:09"
},
{
"order_sn": "",
"charge_name": "Discount",
"order_type": "1",
"charge_price": "-1.27",
"charge_amount": "1",
"charge_discount": null,
"charge_total": "-1.27",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-14 17:12:10"
},
{
"order_sn": "",
"order_type": "1",
"charge_name": "Discount",
"charge_price": "-22.23",
"charge_amount": "1",
"charge_discount": null,
"charge_total": "-22.23",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-14 17:12:10"
},
{
"order_sn": "",
"order_type": "1",
"charge_name": "Discount",
"charge_price": "-73.05",
"charge_amount": "1",
"charge_discount": null,
"charge_total": "-73.05",
"charge_currency": "usd",
"pay_status": "0",
"create_time": "2017-07-14 17:12:10"
}
]
}
]
}
]
}示例 3
{
"status": "2590",
"reqMsg": "Time field.",
"result": []
}