DI_RunShopRecord 数据库表名:跑店记录DTO
| 字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
| id |
主键 |
-1 |
ID |
0 |
| recordDate |
日期 |
-1 |
Date |
0 |
| idPerson |
业务员ID |
-1 |
ID |
0 |
| Person |
Person |
0 |
DTO |
0 |
| signInTime |
签到时间 |
50 |
String |
0 |
| signOutTime |
离店时间 |
50 |
String |
0 |
| lateMinuts |
迟到分钟数 |
-1 |
Int |
0 |
| overTime |
理货超时分钟数 |
-1 |
Int |
0 |
| signInPhoto |
进店拍照图片地址和备注 |
4000 |
String |
0 |
| signOutPhoto |
离店拍照图片地址和备注 |
4000 |
String |
0 |
| promotionPhoto |
促销拍照图片地址和备注 |
4000 |
String |
0 |
| competitionPhoto |
竞品拍照图片地址和备注 |
4000 |
String |
0 |
| idStockSalesReport |
库存销量上报单ID |
-1 |
ID |
0 |
| idSaleOrder |
销售订单ID |
-1 |
ID |
0 |
| idStockRequest |
要货单ID |
-1 |
ID |
0 |
| newsStatus |
跑店状态 |
-1 |
Int |
0 |
| saleQuantitySum |
上报销量合计 |
-1 |
Decimal |
0 |
| stockQuantitySum |
上报库存合计 |
-1 |
Decimal |
0 |
| idRunShopLineDetailDTO |
跑店路线规划明细ID |
-1 |
ID |
0 |
| RunShopLineDetail |
RunShopLineDetail |
-1 |
DTO |
0 |
| orderQuantitySum |
订货合计 |
-1 |
Decimal |
0 |
| createdTime |
createdTime |
-1 |
DateTime |
0 |
| ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
| updatedBy |
更新者 |
32 |
String |
0 |
| updated |
更新时间 |
32 |
DateTime |
0 |
| photoCount |
上传照片数量 |
-1 |
Int |
0 |
| code |
编号(无用处，但是必须有) |
30 |
String |
0 |