UFTData

PR_SalesPromotion_Subs Table  (PR 促销管理)  [T+12.1]

Summary

促销单据附属列表DTO

Columns

 Column NameDescriptionDatatypeLengthAllow Nulls
  DueDate (T+13.0) 失效日期 datetimeTrue 
  discountamount (T+12.1) 返现金额 decimal13 True 
  idinventory (T+12.1) 关联存货ID intTrue 
  name (T+12.1) 名称 nvarchar200 True 
  PieceMeet (T+12.1) 第X件 decimal13 True 
  idSalesPromotionDTO (T+12.1) 关联促销单据表头ID intTrue 
  ID (T+12.1) 主键 intFalse 
  retailprice (T+12.1) 零售价 decimal13 True 
  ts (T+12.1) 分布时间戳 timestampFalse 
  createdtime (T+12.1) 创建时间 datetimeTrue 
  amountmeet (T+12.1) 金额满足 decimal13 True 
  LimitedGiftQuantity (T+12.1) 每店限赠数量 decimal13 True 
  sequencenumber (T+12.1) 顺序号 intTrue 
  DueDaysRate (T+13.0) 到期天数低于 decimal13 True 
  DayLimitedGiftQuantity (T+12.1) 每店每天限赠数量 decimal13 True 
  InventoryBarCode (T+12.1) 条形码 nvarchar200 True 
  promotiondesc (T+12.1) 促销明细描述 nvarchar1000 True 
  quantitymeet (T+12.1) 数量满足 decimal13 True 
  code (T+12.1) 编号 nvarchar30 True 
  Batch (T+13.0) 批号 nvarchar200 True 
  DueDays (T+13.0) 到期天数 intTrue 
  discountrate (T+12.1) 整单折扣率 decimal13 True 
  idunit (T+12.1) 关联计量单位ID intTrue 
  additionalprice (T+12.1) 加价 decimal13 True 

Send feedback

Copyright 2016 Chanjet Inc.