促销单据附属列表DTO
Column Name | Description | Datatype | Length | Allow Nulls | |
---|---|---|---|---|---|
DueDate (T+13.0) | 失效日期 | datetime | 8 | True | |
discountamount (T+12.1) | 返现金额 | decimal | 13 | True | |
idinventory (T+12.1) | 关联存货ID | int | 4 | True | |
name (T+12.1) | 名称 | nvarchar | 200 | True | |
PieceMeet (T+12.1) | 第X件 | decimal | 13 | True | |
idSalesPromotionDTO (T+12.1) | 关联促销单据表头ID | int | 4 | True | |
ID (T+12.1) | 主键 | int | 4 | False | |
retailprice (T+12.1) | 零售价 | decimal | 13 | True | |
ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
createdtime (T+12.1) | 创建时间 | datetime | 8 | True | |
amountmeet (T+12.1) | 金额满足 | decimal | 13 | True | |
LimitedGiftQuantity (T+12.1) | 每店限赠数量 | decimal | 13 | True | |
sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
DueDaysRate (T+13.0) | 到期天数低于 | decimal | 13 | True | |
DayLimitedGiftQuantity (T+12.1) | 每店每天限赠数量 | decimal | 13 | True | |
InventoryBarCode (T+12.1) | 条形码 | nvarchar | 200 | True | |
promotiondesc (T+12.1) | 促销明细描述 | nvarchar | 1000 | True | |
quantitymeet (T+12.1) | 数量满足 | decimal | 13 | True | |
code (T+12.1) | 编号 | nvarchar | 30 | True | |
Batch (T+13.0) | 批号 | nvarchar | 200 | True | |
DueDays (T+13.0) | 到期天数 | int | 4 | True | |
discountrate (T+12.1) | 整单折扣率 | decimal | 13 | True | |
idunit (T+12.1) | 关联计量单位ID | int | 4 | True | |
additionalprice (T+12.1) | 加价 | decimal | 13 | True |
Copyright 2019 Chanjet Inc.