零售代金券备份
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| mid (T+13.0) | U会员ID | nvarchar | 200 | True | |
| couponcode (T+13.0) | 代金券编号 | nvarchar | 200 | True | |
| RetailID (T+13.0) | pos端零售单id | bigint | 8 | True | |
| idmember (T+13.0) | 会员id | bigint | 8 | True | |
| id (T+13.0) | id | int | 4 | False | |
| idretailDTO (T+13.0) | 零售单主表id | bigint | 8 | True | |
| reductionamount (T+13.0) | 金额 | decimal | 13 | True | |
| isretreat (T+13.0) | 是否撤销 | int | 4 | True | |
| createdtime (T+13.0) | 创建时间 | datetime | 8 | True | |
| enableamount (T+13.0) | 启动金额 | decimal | 13 | True | |
| code (T+13.0) | 编号 | nvarchar | 30 | True | |
| coupontitle (T+13.0) | 代金券标题 | nvarchar | 200 | True | |
| ts (T+13.0) | ts | timestamp | 8 | False | |
| name (T+13.0) | 名称 | nvarchar | 200 | True |
Copyright 2016 Chanjet Inc.