# Generated by Django 2.2.7 on 2020-06-16 01:52 from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='View_pcydscjh', fields=[ ('id', models.CharField(max_length=50, primary_key=True, serialize=False, verbose_name='id')), ('cus_snm', models.CharField(max_length=100, verbose_name='客户简称')), ('need_dd', models.CharField(max_length=100, verbose_name='订单交货期')), ('so_no', models.CharField(max_length=100, verbose_name='计划受订')), ('mrp_no', models.CharField(max_length=100, verbose_name='成品编码')), ('mrp_name', models.CharField(max_length=100, verbose_name='成品名称')), ('mo_no', models.CharField(max_length=100, verbose_name='制令单号')), ('pmc_dd', models.CharField(max_length=100, verbose_name='计划排产日期')), ('mo_dep_name', models.CharField(max_length=100, verbose_name='生产部门')), ('zx', models.CharField(max_length=100, verbose_name='IE组线')), ('mo_no_no', models.CharField(max_length=100, verbose_name='制令单代号')), ('mo_no_name', models.CharField(max_length=100, verbose_name='制令单名称')), ('qty', models.CharField(max_length=100, verbose_name='订单数量')), ('qty_fin', models.CharField(max_length=100, verbose_name='已缴库量')), ('w_qty', models.CharField(max_length=100, verbose_name='未完工量')), ('dcl', models.CharField(max_length=100, verbose_name='达成率')), ('jhwcrq', models.CharField(max_length=100, verbose_name='计划完成日期')), ('cn', models.CharField(max_length=100, verbose_name='产能')), ('ddjd', models.CharField(max_length=100, verbose_name='订单完成进度')), ('ymp', models.CharField(max_length=100, verbose_name='研磨品')), ('rq', models.CharField(max_length=100, verbose_name='容器')), ('bq', models.CharField(max_length=100, verbose_name='标签')), ('bc', models.CharField(max_length=100, verbose_name='包材')), ], options={ 'verbose_name': 'PC月度生产计划', 'verbose_name_plural': 'PC月度生产计划', 'db_table': 'view_pcydscjh', 'managed': False, }, ), migrations.CreateModel( name='view_tf_pos', fields=[ ('id', models.CharField(max_length=50, primary_key=True, serialize=False, verbose_name='id')), ('so_no', models.CharField(max_length=100, verbose_name='订单号')), ('pmc_dd', models.CharField(max_length=100, verbose_name='pmc回复交期')), ('bom_no', models.CharField(max_length=100, verbose_name='bom编码')), ('est_itm', models.CharField(max_length=100, verbose_name='项次')), ('mo_dd', models.CharField(max_length=100, verbose_name='制令日期')), ('dl', models.CharField(max_length=100, verbose_name='成品大类')), ('gzwwgs', models.CharField(max_length=100, verbose_name='灌装未完工数量')), ('gzdep', models.CharField(max_length=100, verbose_name='灌装生产线')), ('ggsxrq', models.CharField(max_length=100, verbose_name='灌装上线日')), ('qty', models.CharField(max_length=100, verbose_name='现存量')), ('os_wfl', models.CharField(max_length=100, verbose_name='订单需求量（未领量）')), ('jcq', models.CharField(max_length=100, verbose_name='净需求')), ('jkwshl', models.CharField(max_length=100, verbose_name='缴库未审量')), ('llwsl', models.CharField(max_length=100, verbose_name='领料未审量')), ('mrp_name', models.CharField(max_length=100, verbose_name='研磨品名称')), ('dep', models.CharField(max_length=100, verbose_name='研磨品生产车间')), ('wfl', models.CharField(max_length=100, verbose_name='未发量')), ('zzl', models.CharField(max_length=100, verbose_name='在制量')), ('mrp_no', models.CharField(max_length=100, verbose_name='研磨品代号')), ('mo_no1', models.CharField(max_length=100, verbose_name='单号1')), ('mo_no2', models.CharField(max_length=100, verbose_name='单号2')), ('mo_no3', models.CharField(max_length=100, verbose_name='单号3')), ('mo_no4', models.CharField(max_length=100, verbose_name='单号4')), ('mo_no5', models.CharField(max_length=100, verbose_name='单号5')), ('mo_no6', models.CharField(max_length=100, verbose_name='单号6')), ('mo_no7', models.CharField(max_length=100, verbose_name='单号7')), ('qty1', models.CharField(max_length=100, verbose_name='数量1')), ('qty2', models.CharField(max_length=100, verbose_name='数量2')), ('qty3', models.CharField(max_length=100, verbose_name='数量3')), ('qty4', models.CharField(max_length=100, verbose_name='数量4')), ('qty5', models.CharField(max_length=100, verbose_name='数量5')), ('qty6', models.CharField(max_length=100, verbose_name='数量6')), ('qty7', models.CharField(max_length=100, verbose_name='数量7')), ], options={ 'verbose_name': '研磨品需求计划', 'verbose_name_plural': '研磨品需求计划', 'db_table': 'view_tf_pos', 'managed': False, }, ), migrations.CreateModel( name='View_ydzpcjh', fields=[ ('id', models.CharField(max_length=50, primary_key=True, serialize=False, verbose_name='id')), ('need_dd', models.CharField(max_length=100, verbose_name='订单交货期')), ('cus_no', models.CharField(max_length=50, verbose_name='客户代码')), ('so_no', models.CharField(max_length=50, verbose_name='计划受订')), ('mo_no', models.CharField(max_length=50, verbose_name='制令单号')), ('knd', models.CharField(max_length=50, verbose_name='成品大类')), ('scx', models.CharField(max_length=50, verbose_name='scx')), ('mrp_no', models.CharField(max_length=50, verbose_name='货品代码')), ('name', models.CharField(max_length=50, verbose_name='货品名称')), ('qty', models.FloatField(verbose_name='制令数量')), ('gzwggs', models.FloatField(verbose_name='灌装未完工数量')), ('pmc_dd', models.CharField(max_length=100, verbose_name='计划完成日期')), ('ymppt_dd', models.CharField(max_length=50, verbose_name='研磨品齐套时间')), ('rqdh_dd', models.CharField(max_length=50, verbose_name='容器到货时间')), ('bcdh_dd', models.CharField(max_length=50, verbose_name='包材到货日期')), ('prdt1_qty', models.FloatField(verbose_name='当前库存')), ('iebz', models.FloatField(verbose_name='IE标准')), ('xqry', models.FloatField(verbose_name='需求人员')), ('id_no', models.CharField(max_length=200, verbose_name='BOM代号')), ('jhscrq', models.CharField(max_length=200, verbose_name='计划上线生产日期')), ], options={ 'verbose_name': '月度主排产计划', 'verbose_name_plural': '月度主排产计划', 'db_table': 'view_ydzpcjh', 'managed': False, }, ), ]