零售支付明细清除备份表
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| steadCashIntegral (T+12.1) | 抵现积分 | decimal | 13 | True | |
| idcurrency (T+12.1) | 币种ID | int | 4 | True | |
| OverchargesAmount (T+12.1) | 溢收金额 | decimal | 13 | True | |
| exchangerate (T+12.1) | 汇率 | decimal | 13 | True | |
| origamount (T+12.1) | 原币金额 | decimal | 13 | True | |
| idRetailDTO (T+12.1) | 零售单表头ID | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| memo (T+12.1) | 备注 | nvarchar | 50 | True | |
| amount (T+12.1) | 金额 | decimal | 13 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| name (T+12.1) | 名称 | nvarchar | 200 | True | |
| idbankaccount (T+12.1) | 账号ID | int | 4 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| givechange (T+12.1) | 找零 | decimal | 13 | True | |
| createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
| RetailID (T+12.1) | 零售单id | bigint | 8 | True | |
| integralforstorage (T+12.1) | 积分转储值 | decimal | 13 | True | |
| idsettlestyle (T+12.1) | 结算方式ID | int | 4 | True | |
| givechangeforstorage (T+12.1) | 找零转储值 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.