跑店记录DTO
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| createdTime (T+12.1) | 创建时间 | datetime | 8 | True | |
| newsStatus (T+12.1) | 跑店状态 | int | 4 | True | |
| signOutPhoto (T+12.1) | 离店拍照图片地址和备注 | nvarchar | 2000 | True | |
| idPerson (T+12.1) | 关联业务员ID | int | 4 | True | |
| photoCount (T+12.1) | 上传照片数量 | int | 4 | True | |
| overTime (T+12.1) | 理货超时分钟数 | int | 4 | True | |
| idStockRequest (T+12.1) | 关联要货单ID | nvarchar | 2000 | True | |
| idSaleOrder (T+12.1) | 关联销售订单ID | nvarchar | 2000 | True | |
| lateMinuts (T+12.1) | 迟到分钟数 | int | 4 | True | |
| signOutDate (T+12.1) | 离店日期 | datetime | 8 | True | |
| recordDate (T+12.1) | 跑店记录日期 | datetime | 8 | True | |
| competitionPhoto (T+12.1) | 竞品拍照图片地址和备注 | nvarchar | 2000 | True | |
| idStockSalesReport (T+12.1) | 库存销量上报单ID | nvarchar | 2000 | True | |
| promotionPhoto (T+12.1) | 促销拍照图片地址和备注 | nvarchar | 2000 | True | |
| updated (T+12.1) | 更新时间 | datetime | 8 | True | |
| signInPhoto (T+12.1) | 进店拍照图片地址和备注 | nvarchar | 2000 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| TaskDescription (T+12.1) | 工作描述 | nvarchar | 1000 | True | |
| signInAddress (T+12.1) | 签到地址 | nvarchar | 50 | True | |
| signInTime (T+12.1) | 进店时间 | nvarchar | 8 | True | |
| signOutTime (T+12.1) | 离店时间 | nvarchar | 8 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| idRunShopLineDetailDTO (T+12.1) | 跑店路线规划明细ID | int | 4 | True |
Copyright 2019 Chanjet Inc.