wnserver/obj/apps/erp/migrations/0001_initial.py

# 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,
            },
        ),
    ]