对账单sheet说明
账单模板
对账单sheet
| sheet | 说明 |
|---|---|
| Settlement Report | 结算报告，总览当前账期数据 |
| Purchase | 已交易结算流水数据和交易费用数据 |
| Refund | 退款和退款费用流水数据 |
| Chargeback | 拒付费用数据 |
| Reserve | 循环保证金 |
| Deposit | 固定保证金 |
| Withdrawal | 提现明细 |
| Other Fee | 其他费用 |
| Adjustment | 调账明细 |
对账单字段明细
Purchase
Refund
Refund TimeString(32)必填退款时间Acc IDString(32)必填店铺号URLString(128)必填网站地址Refund Transaction IDString(64)必填退款流水号Merchant Refund Transaction IDString(32)必填网站退款订单号Refund CurrencyString(3)必填退款币种Refund AmountNumber必填退款金额Settlement TimeString(32)必填结算时间Settlement CurrencyString(3)必填结算币种Settlement AmountNumber必填结算金额Refund FeeNumber可选退款手续费Rolling Reserve ReleaseNumber可选循环保证金退回Net Settlement AmountNumber必填结算净额Purchase Transaction IDString(64)必填交易流水号Merchant Transaction IDString(32)必填网站订单号Acquirer Reference NumberString(32)必填收单行流水号Partner FeeNumber可选分账金额