PR_SalesPromotion_b 数据库表名:促销单据列表DTO
字段名称 |
字段说明 |
字段长度 |
字段类型 |
是否唯一 |
ID |
主键 |
-1 |
ID |
0 |
Code |
编号 |
30 |
String |
0 |
Name |
名称 |
200 |
String |
0 |
CorpBrand |
品牌 |
-1 |
Enum |
0 |
RetailPrice |
零售价 |
-1 |
Decimal |
0 |
MemberPrice |
会员价 |
-1 |
Decimal |
0 |
DiscountRate |
折扣% |
-1 |
Decimal |
0 |
DiscountAmount |
折扣或返现金额 |
-1 |
Decimal |
0 |
DiscountPrice |
折扣价 |
-1 |
Decimal |
0 |
RestrictionQuantity |
每单限售数量 |
-1 |
Int |
0 |
QuantityMeet |
数量满足 |
-1 |
Decimal |
0 |
AmountMeet |
金额满足 |
-1 |
Decimal |
0 |
GiftItem |
赠品项数 |
-1 |
Int |
0 |
PromotionDesc |
促销明细描述 |
1000 |
String |
0 |
Inid |
Inid |
560 |
String |
0 |
CreatedTime |
CreatedTime |
-1 |
DateTime |
0 |
SequenceNumber |
顺序号 |
-1 |
Int |
0 |
Ts |
分布时间戳 |
-1 |
TimeStamp |
0 |
Updated |
更新时间 |
32 |
DateTime |
0 |
UpdatedBy |
更新者 |
32 |
String |
0 |
idsalesPromotionDTO |
idsalesPromotionDTO |
0 |
ID |
0 |
idinventoryClass |
idinventoryClass |
0 |
ID |
0 |
idinventory |
idinventory |
0 |
ID |
0 |
idunit |
idunit |
0 |
ID |
0 |
SalesPromotion |
SalesPromotion |
0 |
DTO |
0 |
InventoryClass |
InventoryClass |
0 |
DTO |
0 |
Inventory |
Inventory |
0 |
DTO |
0 |
Unit |
Unit |
0 |
DTO |
0 |
MultDetails |
MultDetails |
0 |
DTOCollection |
0 |
GrandsonDetails |
孙表明细 |
200 |
String |
0 |