| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 |
- create class if not exists /mingdao1/project (
- attr0 varchar "项目ID",
- attr1 varchar "合同编号",
- attr10 varchar "产品信息（合同）",
- attr100 double "实施人员成本",
- attr101 double "开发人员工时",
- attr102 double "开发人员成本",
- attr103 double "项目经理工时",
- attr104 double "项目经理成本",
- attr105 double "设计人员工时",
- attr106 double "设计人员成本",
- attr107 double "模型人员工时",
- attr108 double "模型人员成本",
- attr109 double "实习人员工时",
- attr11 varchar "采纳的技术平台",
- attr110 double "实习人员成本",
- attr111 double "其他人员工时（需修改）",
- attr112 double "其他人员成本（需修改）",
- attr113 double "总部定制开发总工时",
- attr114 double "总部定制开发总工时成本",
- attr115 double "总部建模工时",
- attr116 double "总部建模成本",
- attr117 double "总部开发-北京工时",
- attr118 double "总部开发-北京成本",
- attr119 double "总部开发-南京武汉工时",
- attr120 double "总部开发-南京武汉成本",
- attr121 double "总部开发-EA工时",
- attr122 double "总部开发-EA成本",
- attr123 double "总部开发-设计工时",
- attr124 double "总部开发-设计成本",
- attr125 double "总部开发-森学院工时",
- attr126 double "总部开发-森学院成本",
- attr127 double "总部开发-U产品研发部开发工时",
- attr128 double "总部开发-U产品研发部开发工时成本",
- attr129 double "总部开发-实习人员工时",
- attr13 date "授权到期日期-1",
- attr130 double "总部开发-实习人员成本",
- attr131 varchar "格式调整-2",
- attr132 double "差旅成本-手工记录(元)",
- attr133 double "提货成本",
- attr134 double "外包成本（不含税）",
- attr135 double "项目总工时",
- attr136 double "项目总工时成本",
- attr137 double "其中：项目售后工时",
- attr138 double "售后工时占比",
- attr139 double "项目总成本（包含：总工时成本+差旅成本+提货成本）",
- attr140 double "项目实际公司毛利率",
- attr141 double "预审事业部毛利率",
- attr142 double "预审公司毛利率",
- attr143 double "实际工时VS.预审工时",
- attr144 double "超额工时占比",
- attr145 double "实际毛利率VS.预审毛利率",
- attr146 double "实际毛利率VS.预审毛利率【数值】(%)",
- attr147 varchar "毛利率说明",
- attr148 date "毛利差首次低于0%",
- attr149 varchar "记录rowId",
- attr150 varchar "里程碑",
- attr151 timestamp "创建时间",
- attr152 timestamp "最近修改时间",
- attr19 varchar "项目机会名称",
- attr2 varchar "签约客户名称",
- attr20 varchar "阶段名称",
- attr22 varchar "责任销售（售前）",
- attr23 varchar "部门（售前）",
- attr24 varchar "事业部（售前）",
- attr25 varchar "项目经理（售前）",
- attr28 varchar "售前项目是否可在今年验收",
- attr29 varchar "售前项目可在今年验收状态",
- attr3 varchar "项目名称",
- attr30 varchar "项目经理*",
- attr31 varchar "非我司交付类型",
- attr32 varchar "支持售前",
- attr33 varchar "所属事业部",
- attr34 varchar "所属部门（销售）",
- attr35 varchar "销售所在部门",
- attr36 varchar "TAPD链接（应用交付项目敏捷研发协作地址）",
- attr37 varchar "是否为大项目",
- attr38 date "周报更新日期",
- attr39 varchar "项目活跃度",
- attr40 varchar "项目状态",
- attr41 date "项目启动时间",
- attr42 date "项目承诺完成时间",
- attr43 int "项目完成百分比(%)",
- attr44 date "项目计划完成时间",
- attr45 date "项目实际完成时间",
- attr46 date "进场时间（入场通知书）",
- attr47 int "延期天数(天)",
- attr48 varchar "是否延期",
- attr49 int "checklist提交情况",
- attr5 varchar "行业",
- attr50 varchar "计划延期情况说明",
- attr51 int "提前启动至今天数(天)",
- attr52 int "提前启动至签约天数(天)",
- attr53 varchar "验收报告提醒",
- attr54 date "【PM】预计验收报告签回时间",
- attr55 varchar "（PM）收入承诺状态",
- attr56 date "【销售】预计签回验收报告日期",
- attr57 varchar "（销售）收入承诺状态",
- attr58 date "项目验收报告时间",
- attr59 varchar "是否跨期调整",
- attr6 varchar "合同归档状态",
- attr60 date "项目完工报告时间",
- attr61 date "发送预计完成时间",
- attr62 date "内部启动评审时间",
- attr63 date "内部结项评审时间",
- attr64 date "取消/终止时间",
- attr65 varchar "合同终止/取消原因",
- attr66 double "合同总金额",
- attr67 double "不含税总金额",
- attr68 double "外包实际金额",
- attr69 double "净合同额",
- attr7 varchar "原售前项目编号",
- attr70 double "回款金额",
- attr71 double "回款比例",
- attr72 int "剩余未回款金额（元）",
- attr73 varchar "收入认列依据",
- attr74 date "收入确认年月",
- attr75 varchar "已完成里程碑",
- attr76 varchar "财务回款目标",
- attr77 varchar "已完成财务目标",
- attr78 double "预估工时汇总",
- attr79 double "预估人天汇总",
- attr8 varchar "项目密级",
- attr80 double "预估成本汇总",
- attr81 double "PM-预计工时",
- attr82 double "实施-预计工时",
- attr83 double "区域开发-预计工时",
- attr84 double "设计-预计工时",
- attr85 double "其他-预计工时",
- attr86 double "模型-预计工时",
- attr87 double "总部开发-预计工时",
- attr88 double "实习-预计工时",
- attr89 int "PM-预计人天",
- attr9 varchar "省份",
- attr90 int "实施-预计人天",
- attr91 int "区域开发-预计人天",
- attr92 int "设计-预计人天",
- attr93 int "其他-预计人天",
- attr94 int "模型-预计人天",
- attr95 int "总部开发-预计人天",
- attr96 int "实习-预计人天",
- attr97 double "BU交付总工时",
- attr98 double "BU交付总工时成本",
- attr99 double "实施人员工时",
- attr12 varchar "产品版本",
- attr14 date "授权到期日期-2",
- attr15 date "授权到期日期-3",
- attr16 date "授权到期日期-4",
- attr17 varchar "项目整体需求概况",
- attr18 varchar "干系人管理",
- attr21 double "机会总额",
- attr26 date "申请提前入场时间",
- attr27 date "预计签约时间",
- attr4 date "签约日期"
- )with autosearch=true , version=false , key=manu, alias='项目信息' , nickname='mingdao1_project'
- /**
- fork(a)
- **/;
|
