class t_product_pic_completion(t_base):
PZRemake = models.CharField(u'拍照类型',
choices=getChoices(ChoicePZRemake),
max_length=2,
null=True)
PZTimeing = models.DateTimeField(u'拍照申请时间', blank=True, null=True)
PZStaffNameing = models.CharField(u'拍照申请人',
max_length=16,
blank=True,
null=True)
SampleState = models.CharField(u'样品状态',
choices=getChoices(ChoiceSampleState),
max_length=16,
blank=True,
null=True)
pid = models.IntegerField(u'业务流水号', null=True, db_index=True)
SalesApplicant = models.CharField(u'销售申请人',
max_length=16,
blank=True,
null=True)
class Meta:
verbose_name = u'图片完成'
verbose_name_plural = verbose_name
db_table = 't_product_pic_completion'
ordering = ['-id']
def __unicode__(self):
return u'id:%s MainSKU:%s' % (self.id, self.MainSKU)
class t_product_art_ing(t_base):
SalesApplicant=models.CharField(u'销售申请人', max_length=16, blank=True, null=True)
Entertime=models.DateTimeField(u'进入本步骤时间',blank=True, null=True)
PZRemake = models.CharField(u'拍照类型', choices=getChoices(ChoicePZRemake), max_length=2, null=True)
PZTimeing = models.DateTimeField(u'拍照申请时间', blank=True, null=True)
PZStaffNameing = models.CharField(u'拍照申请人', max_length=16, blank=True, null=True)
SampleState = models.CharField(u'样品状态', max_length=16, blank=True, null=True)
pid = models.IntegerField(u'业务流水号', null=True, db_index=True)
class Meta:
verbose_name=u'正在美工'
verbose_name_plural=u' 步骤09--正在美工'
db_table = 't_product_art_ing'
ordering = ['CreateTime']
def __unicode__(self):
return u'id:%s MainSKU:%s'%(self.id,self.MainSKU)
class t_product_saler_requirement_photograph(t_base):
PZRemake = models.CharField(u'拍照类型',
choices=getChoices(ChoicePZRemake),
default=1,
max_length=2,
null=True)
PZTimeing = models.DateTimeField(u'拍照申请时间', blank=True, null=True)
PZStaffNameing = models.CharField(u'销售申请人',
max_length=16,
blank=True,
null=True)
SampleState = models.CharField(u'样品状态',
default='未取样',
max_length=16,
blank=True,
null=True)
#SampleState = models.CharField(u'样品状态',choices=getChoices(ChoiceSampleState), max_length=16, blank=True, null=True)
pid = models.IntegerField(u'业务流水号', null=True, db_index=True)
##销售员实拍需求比t_product_photograph新增
LQTimeing = models.DateTimeField(u'领取时间', blank=True, null=True)
LQStaffNameing = models.CharField(u'领取人',
max_length=16,
blank=True,
null=True)
LQState = models.CharField(u'领取状态',
choices=LQStateChoices,
default='n',
max_length=16,
blank=True,
null=True)
SelectWays = models.CharField(u'查询方式',
choices=SelectWaysChoices,
default='y',
max_length=16,
blank=True,
null=True)
class Meta:
verbose_name = u'销售员实拍需求'
verbose_name_plural = verbose_name
db_table = 't_product_saler_requirement_photograph'
ordering = ['-PZTimeing']
def __unicode__(self):
return u'id:%s MainSKU:%s' % (self.id, self.MainSKU)
class t_sku_weight_examine(models.Model):
product_lcate = models.CharField(u'大类名称',
max_length=64,
blank=True,
null=True)
product_scate = models.CharField(u'小类代码',
max_length=32,
blank=True,
null=True)
product_image = models.CharField(u'商品图片',
max_length=255,
blank=True,
null=True)
product_name = models.CharField(u'商品名称',
max_length=255,
blank=True,
null=True)
product_mainsku = models.CharField(u'检索SKU',
max_length=32,
blank=True,
null=True)
product_sku = models.CharField(u'商品SKU',
max_length=32,
blank=True,
null=True)
product_price = models.DecimalField(u'商品价格',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
create_person = models.CharField(u'审核申请人',
max_length=16,
blank=True,
null=True)
create_time = models.DateTimeField(u'审核申请时间', blank=True, null=True)
survey_weight = models.PositiveSmallIntegerField(u'调研克重(g)',
blank=True,
null=True)
packinfo_weight = models.PositiveSmallIntegerField(u'包装克重(g)',
blank=True,
null=True)
examine_weight = models.PositiveSmallIntegerField(u'真实克重(g)',
blank=True,
null=True)
examine_status = models.CharField(
u'审核状态',
choices=getChoices(Choice_examine_status),
max_length=1,
blank=True,
null=True)
auditor = models.CharField(u'审核人', max_length=16, blank=True, null=True)
examine_time = models.DateTimeField(u'审核时间', blank=True, null=True)
supplier_name = models.CharField(u'供应商名称',
max_length=255,
blank=True,
null=True)
canuse_num = models.PositiveSmallIntegerField(u'可用数量',
blank=True,
null=True)
class Meta:
verbose_name = u'精准调研克重审核'
verbose_name_plural = verbose_name
db_table = 't_sku_weight_examine'
def __unicode__(self):
return u'%s' % (self.id)
class t_cloth_factory_dispatch_needpurchase(models.Model):
id = models.AutoField(u'业务流水号', primary_key=True)
SKU = models.CharField(u'商品SKU', max_length=32)
goodsName = models.CharField(u'商品名称', max_length=256, blank=True, null=True)
Supplier = models.CharField(u'供应商', max_length=64, blank=True, null=True)
goodsState = models.CharField(u'商品状态', max_length=32, blank=True, null=True)
goodsCostPrice = models.DecimalField(u'商品成本单价', max_digits=10, decimal_places=2, blank=True, null=True)
oosNum = models.DecimalField(u'缺货及未派单数量', max_digits=8, decimal_places=0, blank=True, null=True)
occupyNum = models.DecimalField(u'占有数量', max_digits=8, decimal_places=0, blank=True, null=True)
stockNum = models.DecimalField(u'库存数量', max_digits=8, decimal_places=0, blank=True, null=True)
ailableNum = models.DecimalField(u'预计可用库存', max_digits=8, decimal_places=0, blank=True, null=True)
sevenSales = models.DecimalField(u'7天销量', max_digits=8, decimal_places=0, blank=True, null=True)
fifteenSales = models.DecimalField(u'15天销量', max_digits=8, decimal_places=0, blank=True, null=True)
thirtySales = models.DecimalField(u'30天销量', max_digits=8, decimal_places=0, blank=True, null=True)
PurchaseNotInNum = models.DecimalField(u'采购未入库', max_digits=8, decimal_places=0, blank=True, null=True)
UseNumber = models.PositiveSmallIntegerField(u'可用数量',max_length=11, blank=True,null=True)
SuggestNum = models.PositiveSmallIntegerField(u'建议采购数量', max_length=11)
SaleDay = models.DecimalField(u'预计可卖天数', max_digits=10, decimal_places=1, blank=True, null=True)
buyer = models.CharField(u'采购员', max_length=128, blank=True, null=True)
girard = models.CharField(u'款号', max_length=32, blank=True, null=True)
colour = models.CharField(u'颜色', max_length=32, blank=True, null=True)
size = models.CharField(u'尺寸', max_length=32, null=True)
productNumbers = models.PositiveSmallIntegerField(u'需采购数量',max_length=8, blank=True,null=True)
loanMoney = models.DecimalField(u'借款金额', max_digits=10, decimal_places=4, blank=True, null=True)
actualMoney = models.DecimalField(u'实际金额', max_digits=10, decimal_places=4, blank=True, null=True)
outFactory = models.CharField(u'派发工厂', choices=getFactory(), max_length=256, blank=True, null=True)
rawNumbers = models.DecimalField(u'原材料数', max_digits=8, decimal_places=2, blank=True, null=True)
unit = models.CharField(u'原材料单位', choices=getChoices(ChoiceRawUnit) ,max_length=8, blank=True, null=True)
remarkApply = models.TextField(u'预采购备注', blank=True, null=True)
genPurchaseMan = models.CharField(u'生成采购员', max_length=32, blank=True, null=True)
genPurchaseDate = models.DateTimeField(u'生成采购时间', blank=True, null=True)
remarkGenPurchase = models.TextField(u'备注', blank=True, null=True)
distributeMan = models.CharField(u'分发人员', max_length=32, blank=True, null=True)
distributeDate = models.DateTimeField(u'分发日期', blank=True, null=True)
applyMan = models.CharField(u'申请人', max_length=32, blank=True, null=True)
applyDate = models.DateTimeField(u'申请时间', blank=True, null=True)
auditMan = models.CharField(u'审核人', max_length=32, blank=True, null=True)
auditNoPass = models.CharField(u'采购审核计划未通过', max_length=32, blank=True, null=True)
auditDate = models.DateTimeField(u'审核时间', blank=True, null=True)
remarkAudit = models.TextField(u'采购计划备注', blank=True, null=True)
speModifyMan = models.CharField(u'修订专员', max_length=32, blank=True, null=True)
speModifyDate = models.DateTimeField(u'专员修订时间', blank=True, null=True)
remarkSpeModify = models.TextField(u'修订备注', blank=True, null=True)
dispatchMan = models.CharField(u'排单人', max_length=32, blank=True, null=True)
disPatchDate = models.DateTimeField(u'排单时间', blank=True, null=True)
remarkDisPatch = models.TextField(u'排单备注', blank=True, null=True)
confirmMan = models.CharField(u'确认完成人', max_length=32, blank=True, null=True)
confirmDate = models.DateTimeField(u'确认完成时间', blank=True, null=True)
remarkConfirm = models.TextField(u'确认交付备注', blank=True, null=True)
closeMan = models.CharField(u'关闭人', max_length=32, blank=True, null=True)
closeDate = models.DateTimeField(u'关闭时间', blank=True, null=True)
remarkClose = models.TextField(u'关闭备注', blank=True, null=True)
createDate = models.DateTimeField(u'创建时间', blank=True, null=True)
currentState = models.PositiveSmallIntegerField(u'当前状态', choices=getChoices(ChoiceClothDispatchState), blank=True,
null=True)
completeNumbers = models.PositiveSmallIntegerField(u'完成件数',max_length=8, blank=True,null=True)
BmpUrl = models.CharField(u'图片网址', max_length=255, blank=True, null=True)
SalerName2 = models.CharField(u'业绩归属人2', max_length=16, blank=True, null=True)
TortInfo = models.CharField(u'侵权站点', max_length=64, blank=True, null=True)
goodsclass = models.CharField(u'商品类别', choices=getChoices(ChoiceSelectCategory), max_length=32, blank=True, null=True)
AverageNumber = models.DecimalField(u'日销量', max_digits=8, decimal_places=2, blank=True, null=True)
flag = models.PositiveSmallIntegerField(u'联动数据标志',max_length=2, blank=True,null=True)
OSCode = models.CharField(u'采购等级码',max_length=8,blank = True,null = True)
Stocking_plan_number = models.CharField(u'采购计划单号', max_length=32, blank=True, null=True)
SpecialPurchaseFlag = models.CharField(u'排单类型',choices=getChoices(ChoicePurchaseType), max_length=16)
OrderNo = models.CharField(u'订单号', max_length=16, blank=True, null=True)
GenRecordMan = models.CharField(u'手动单个和批量导入人', max_length=32, blank=True, null=True)
GenRecordDate = models.DateTimeField(u'手动单个和批量导入时间', blank=True, null=True)
FactoryRemark = models.TextField(u'提交工厂备注', blank=True, null=True)
class Meta:
verbose_name=u'需采购供应链服装列表'
verbose_name_plural=verbose_name
db_table = 't_cloth_factory_dispatch'
ordering = ['-id']
def __unicode__(self):
return u'id:%s sku:%s'%(self.id,self.SKU)
class t_product_build_FBA(models.Model):
id = models.AutoField(u'业务流水号', primary_key=True)
SKU = models.CharField(u'FBA_SKU', max_length=32, blank=False, null=False)
OldSKU = models.CharField(u'SKU', max_length=32, blank=True, null=True)
MainSKU = models.CharField(u'主SKU*', max_length=255, blank=True, null=True)
LargeCategory = models.CharField(u'大类名称',
max_length=32,
blank=True,
null=False)
SmallCategory = models.CharField(u'小类名称',
max_length=32,
blank=True,
null=False)
Name2 = models.CharField(mark_safe(u'商品名称<br>(中文)'),
max_length=128,
blank=True,
null=True)
GoodsStatus = models.CharField(u'商品状态',
max_length=32,
default='正常',
null=True)
Material = models.CharField(u'材质', max_length=32, blank=True, null=True)
Model = models.CharField(u'型号', max_length=32, blank=True, null=True)
Brand = models.CharField(u'品牌', max_length=32, blank=True, null=True)
Unit = models.CharField(u'单位',
choices=getChoices(ChoiceUnit),
default=0,
max_length=32,
blank=True,
null=True)
MinPackNum = models.PositiveSmallIntegerField(mark_safe(u'最小包<br>装数量'),
blank=True,
null=True)
Weight = models.DecimalField(u'重量(g)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
SupplierName = models.CharField(mark_safe(u'供应商名称'),
max_length=32,
blank=True,
null=True)
CostPrice = models.DecimalField(u'成本单价(¥元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
Remark = models.TextField(u'备注', blank=True, null=True)
ReportName2 = models.CharField(u'中文申报名',
max_length=32,
blank=True,
null=True)
ReportName = models.CharField(u'英文申报名',
max_length=32,
blank=True,
null=True)
DeclaredValue = models.DecimalField(u'申报价值(美元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OriginCountryCode = models.CharField(u'原产国代码',
max_length=16,
blank=True,
null=True)
OriginCountry = models.CharField(u'原产国',
max_length=32,
blank=True,
null=True)
MaxNum = models.PositiveSmallIntegerField(u'库存上限', blank=True, null=True)
MinNum = models.PositiveSmallIntegerField(u'库存下限', blank=True, null=True)
SalerName = models.CharField(u'业绩归属人',
max_length=16,
blank=True,
null=True)
SalerName2 = models.CharField(u'业绩归属人2',
max_length=16,
blank=True,
null=True)
PackingID = models.CharField(u'包装规格', max_length=32, blank=True, null=True)
DevDate = models.DateField(u'开发日期', blank=True, null=True)
Purchaser = models.CharField(u'采购员', max_length=16, blank=True, null=True)
Storehouse = models.CharField(u'发货仓库',
max_length=16,
default=u'亚马逊仓库',
blank=True,
null=True)
StockDays = models.PositiveSmallIntegerField(u'采购到货天数',
blank=True,
null=True)
InnerPrice = models.DecimalField(u'内包装成本',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
LinkUrl = models.CharField(u'网页URL', max_length=256, blank=True, null=True)
LinkUrl2 = models.CharField(u'网页URL2',
max_length=256,
blank=True,
null=True)
SellDays = models.PositiveSmallIntegerField(u'库存预警天数',
blank=True,
null=True)
StockMinAmount = models.PositiveSmallIntegerField(u'采购最小订货量',
blank=True,
null=True)
Electrification = models.CharField(u'是否带电',
choices=getChoices(ChoiceIF),
max_length=4,
default=u'否',
blank=True,
null=True)
Powder = models.CharField(u'是否粉末',
choices=getChoices(ChoiceIF),
max_length=4,
default=u'否',
blank=True,
null=True)
Liquid = models.CharField(u'是否液体',
choices=getChoices(ChoiceIF),
max_length=4,
default=u'否',
blank=True,
null=True)
possessMan1 = models.CharField(u'责任归属人1',
max_length=16,
blank=True,
null=True)
possessMan2 = models.CharField(u'责任归属人2',
max_length=16,
blank=True,
null=True)
ContrabandAttribute = models.CharField(u'商品属性',
default=u'普货',
max_length=16,
blank=True,
null=True)
DegreeOfDifficulty = models.CharField(u'包装难度系数',
max_length=16,
blank=True,
null=True)
ShopName = models.CharField(u'店铺名称', max_length=128, blank=True, null=True)
LinkUrl4 = models.CharField(u'网页URL4',
max_length=256,
blank=True,
null=True)
LinkUrl5 = models.CharField(u'网页URL5',
max_length=256,
blank=True,
null=True)
LinkUrl6 = models.CharField(u'网页URL6',
max_length=256,
blank=True,
null=True)
ShopFreight = models.DecimalField(u'店铺运费',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
PackWeight = models.DecimalField(u'包装材料重量',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
ExchangeRate = models.DecimalField(u'汇率',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
LogisticsPrice = models.DecimalField(u'物流公司价格',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
TransactionFee = models.DecimalField(u'交易费',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
ProfitRate = models.DecimalField(u'毛利率',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
SellingPrice = models.DecimalField(u'计算售价',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
LRTime = models.DateTimeField(u'录入时间', blank=True, null=True)
LRStaffName = models.CharField(u'录入员',
max_length=16,
blank=True,
null=True)
isflag = models.PositiveSmallIntegerField(u'FBA流程标志',
blank=True,
null=True,
default=0)
FBAFinshTime = models.DateTimeField(u'FBA录入完成时间', blank=True, null=True)
MultiStyle = models.PositiveSmallIntegerField(u'多款式',
blank=True,
null=True,
default=0)
SampleFlag = models.PositiveSmallIntegerField(u'是否有样品',
blank=True,
null=True,
default=0)
SampleCount = models.PositiveSmallIntegerField(u'样品数量',
blank=True,
null=True,
default=0)
Class = models.CharField(u'规格', max_length=256, blank=True, null=True)
Style = models.CharField(u'款式', max_length=256, blank=True, null=True)
BarCode = models.CharField(u'采购渠道', max_length=128, blank=True, null=True)
BatchPrice = models.DecimalField(u'批发价格(美元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
RetailPrice = models.DecimalField(u'零售价格-美元',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
SalePrice = models.DecimalField(u'最低售价(美元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
MaxSalePrice = models.DecimalField(u'最高售价(美元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
MarketPrice = models.DecimalField(u'市场参考价(美元)',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
Quantity = models.PositiveSmallIntegerField(u'数量',
blank=True,
null=True,
default=0)
SKUStyle1 = models.CharField(u'SKU款式1',
max_length=128,
blank=True,
null=True)
SKUStyle2 = models.CharField(u'SKU款式2',
max_length=128,
blank=True,
null=True)
SKUStyle3 = models.CharField(u'SKU款式3',
max_length=128,
blank=True,
null=True)
SKUDescribe = models.CharField(u'SKU描述',
max_length=256,
blank=True,
null=True)
BmpUrl = models.CharField(u'图片URL', max_length=256, blank=True, null=True)
LinkUrl3 = models.CharField(u'网页URL3',
max_length=256,
blank=True,
null=True)
MinPrice = models.DecimalField(u'最低采购价格',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
HSCODE = models.CharField(u'海关编码', max_length=64, blank=True, null=True)
InLong = models.DecimalField(u'内盒长',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
InWide = models.DecimalField(u'内盒宽',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
InHigh = models.DecimalField(u'内盒高',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
InGrossweight = models.DecimalField(u'内盒毛重',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
InNetweight = models.DecimalField(u'内盒净重',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OutLong = models.DecimalField(u'外箱长',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OutWide = models.DecimalField(u'外箱宽',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OutHigh = models.DecimalField(u'外箱高',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OutGrossweight = models.DecimalField(u'外箱毛重',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
OutNetweight = models.DecimalField(u'外箱净重',
max_digits=6,
decimal_places=2,
blank=True,
null=True)
ItemUrl = models.CharField(u'商品URL', max_length=256, blank=True, null=True)
PackMsg = models.CharField(u'包装事项', max_length=256, blank=True, null=True)
JobPower = models.CharField(u'工号权限', max_length=128, blank=True, null=True)
Season = models.CharField(u'季节', max_length=100, blank=True, null=True)
OpDatetime = models.DateTimeField(u'操作时间', blank=True, null=True)
OpStaffName = models.CharField(u'操作员',
max_length=16,
blank=True,
null=True)
auditnote = models.TextField(u'审核员备注', blank=True, null=True)
class Meta:
verbose_name = u'FBA-建资料'
verbose_name_plural = verbose_name
db_table = "t_product_build_fba"
def __unicode__(self):
return u'id:%s,FBA-sku:%s' % (self.id, self.SKU)