123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512 |
- package org.jeecg.modules.fbsMomOrder.entity;
- import java.io.Serializable;
- import java.util.Date;
- import com.baomidou.mybatisplus.annotation.IdType;
- import com.baomidou.mybatisplus.annotation.TableField;
- import com.baomidou.mybatisplus.annotation.TableId;
- import com.baomidou.mybatisplus.annotation.TableName;
- import lombok.Data;
- import com.fasterxml.jackson.annotation.JsonFormat;
- import org.springframework.format.annotation.DateTimeFormat;
- import org.jeecgframework.poi.excel.annotation.Excel;
- /**
- * @Description: 生产订单子表
- * @author: jeecg-boot
- * @date: 2020-10-16
- * @version: V1.0
- */
- @Data
- @TableName("mom_orderdetail")
- public class FbsMomOrderdetail implements Serializable {
- private static final long serialVersionUID = 1L;
- /**id*/
- @Excel(name = "id", width = 15)
- @TableField(exist = false)
- private String id;
- /**modid*/
- @Excel(name = "modid", width = 15)
- private String modid;
- // private Integer modid;SAP-update
- /**moid*/
- @Excel(name = "moid", width = 15)
- private String moid;
- // private Integer moid;SAP-update
- /**sortseq*/
- @Excel(name = "sortseq", width = 15)
- private Integer sortseq;
- /**moclass*/
- @Excel(name = "moclass", width = 15)
- private Integer moclass;
- /**motypeid*/
- @Excel(name = "motypeid", width = 15)
- private Integer motypeid;
- /**qty*/
- @Excel(name = "qty", width = 15)
- private Object qty;
- /**mrpqty*/
- @Excel(name = "mrpqty", width = 15)
- private Object mrpqty;
- /**auxunitcode*/
- @Excel(name = "auxunitcode", width = 15)
- private String auxunitcode;
- /**auxqty*/
- @Excel(name = "auxqty", width = 15)
- private Object auxqty;
- /**changerate*/
- @Excel(name = "changerate", width = 15)
- private Object changerate;
- /**molotcode*/
- @Excel(name = "molotcode", width = 15)
- private String molotcode;
- /**whcode*/
- @Excel(name = "whcode", width = 15)
- private String whcode;
- /**mdeptcode*/
- @Excel(name = "mdeptcode", width = 15)
- private String mdeptcode;
- /**sotype*/
- @Excel(name = "sotype", width = 15)
- private Integer sotype;
- /**sodid*/
- @Excel(name = "sodid", width = 15)
- private String sodid;
- /**socode*/
- @Excel(name = "socode", width = 15)
- private String socode;
- /**soseq*/
- @Excel(name = "soseq", width = 15)
- private Integer soseq;
- /**declaredqty*/
- @Excel(name = "declaredqty", width = 15)
- private Object declaredqty;
- /**qualifiedinqty*/
- @Excel(name = "qualifiedinqty", width = 15)
- private Object qualifiedinqty;
- /**status*/
- @Excel(name = "status", width = 15)
- private Integer status;
- /**orgstatus*/
- @Excel(name = "orgstatus", width = 15)
- private Integer orgstatus;
- /**bomid*/
- @Excel(name = "bomid", width = 15)
- private Integer bomid;
- /**routingid*/
- @Excel(name = "routingid", width = 15)
- private Integer routingid;
- /**custbomid*/
- @Excel(name = "custbomid", width = 15)
- private Integer custbomid;
- /**demandid*/
- @Excel(name = "demandid", width = 15)
- private Integer demandid;
- /**plancode*/
- @Excel(name = "plancode", width = 15)
- private String plancode;
- /**partid*/
- @Excel(name = "partid", width = 15)
- private Integer partid;
- /**invcode*/
- @Excel(name = "invcode", width = 15)
- private String invcode;
- /**free1*/
- @Excel(name = "free1", width = 15)
- private String free1;
- /**free2*/
- @Excel(name = "free2", width = 15)
- private String free2;
- /**free3*/
- @Excel(name = "free3", width = 15)
- private String free3;
- /**free4*/
- @Excel(name = "free4", width = 15)
- private String free4;
- /**free5*/
- @Excel(name = "free5", width = 15)
- private String free5;
- /**free6*/
- @Excel(name = "free6", width = 15)
- private String free6;
- /**free7*/
- @Excel(name = "free7", width = 15)
- private String free7;
- /**free8*/
- @Excel(name = "free8", width = 15)
- private String free8;
- /**free9*/
- @Excel(name = "free9", width = 15)
- private String free9;
- /**free10*/
- @Excel(name = "free10", width = 15)
- private String free10;
- /**sfcflag*/
- @Excel(name = "sfcflag", width = 15)
- private Object sfcflag;
- /**crpflag*/
- @Excel(name = "crpflag", width = 15)
- private Object crpflag;
- /**qcflag*/
- @Excel(name = "qcflag", width = 15)
- private Object qcflag;
- /**relsdate*/
- @Excel(name = "relsdate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date relsdate;
- /**relsuser*/
- @Excel(name = "relsuser", width = 15)
- private String relsuser;
- /**closedate*/
- @Excel(name = "closedate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date closedate;
- /**orgclsdate*/
- @Excel(name = "orgclsdate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date orgclsdate;
- /**ufts*/
- private Date ufts;
- /**define22*/
- @Excel(name = "define22", width = 15)
- private String define22;
- /**define23*/
- @Excel(name = "define23", width = 15)
- private String define23;
- /**define24*/
- @Excel(name = "define24", width = 15)
- private String define24;
- /**define25*/
- @Excel(name = "define25", width = 15)
- private String define25;
- /**define26*/
- @Excel(name = "define26", width = 15)
- private Float define26;
- /**define27*/
- @Excel(name = "define27", width = 15)
- private Float define27;
- /**define28*/
- @Excel(name = "define28", width = 15)
- private String define28;
- /**define29*/
- @Excel(name = "define29", width = 15)
- private String define29;
- /**define30*/
- @Excel(name = "define30", width = 15)
- private String define30;
- /**define31*/
- @Excel(name = "define31", width = 15)
- private String define31;
- /**define32*/
- @Excel(name = "define32", width = 15)
- private String define32;
- /**define33*/
- @Excel(name = "define33", width = 15)
- private String define33;
- /**define34*/
- @Excel(name = "define34", width = 15)
- private Integer define34;
- /**define35*/
- @Excel(name = "define35", width = 15)
- private Integer define35;
- /**define36*/
- @Excel(name = "define36", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date define36;
- /**define37*/
- @Excel(name = "define37", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date define37;
- /**leadtime*/
- @Excel(name = "leadtime", width = 15)
- private Integer leadtime;
- /**opscheduletype*/
- @Excel(name = "opscheduletype", width = 15)
- private Integer opscheduletype;
- /**ordflag*/
- @Excel(name = "ordflag", width = 15)
- private Object ordflag;
- /**wiptype*/
- @Excel(name = "wiptype", width = 15)
- private Integer wiptype;
- /**supplywhcode*/
- @Excel(name = "supplywhcode", width = 15)
- private String supplywhcode;
- /**reasoncode*/
- @Excel(name = "reasoncode", width = 15)
- private String reasoncode;
- /**iswfcontrolled*/
- @Excel(name = "iswfcontrolled", width = 15)
- private Integer iswfcontrolled;
- /**iverifystate*/
- @Excel(name = "iverifystate", width = 15)
- private Integer iverifystate;
- /**ireturncount*/
- @Excel(name = "ireturncount", width = 15)
- private Integer ireturncount;
- /**remark*/
- @Excel(name = "remark", width = 15)
- private String remark;
- /**sourcemocode*/
- @Excel(name = "sourcemocode", width = 15)
- private String sourcemocode;
- /**sourcemoseq*/
- @Excel(name = "sourcemoseq", width = 15)
- private Integer sourcemoseq;
- /**sourcemoid*/
- @Excel(name = "sourcemoid", width = 15)
- private Integer sourcemoid;
- /**sourcemodid*/
- @Excel(name = "sourcemodid", width = 15)
- private Integer sourcemodid;
- /**sourceqccode*/
- @Excel(name = "sourceqccode", width = 15)
- private String sourceqccode;
- /**sourceqcid*/
- @Excel(name = "sourceqcid", width = 15)
- private Integer sourceqcid;
- /**sourceqcdid*/
- @Excel(name = "sourceqcdid", width = 15)
- private Integer sourceqcdid;
- /**costitemcode*/
- @Excel(name = "costitemcode", width = 15)
- private String costitemcode;
- /**costitemname*/
- @Excel(name = "costitemname", width = 15)
- private String costitemname;
- /**relstime*/
- @Excel(name = "relstime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date relstime;
- /**closeuser*/
- @Excel(name = "closeuser", width = 15)
- private String closeuser;
- /**closetime*/
- @Excel(name = "closetime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date closetime;
- /**orgclstime*/
- @Excel(name = "orgclstime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
- @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
- private Date orgclstime;
- /**auditstatus*/
- @Excel(name = "auditstatus", width = 15)
- private Integer auditstatus;
- /**pallocateid*/
- @Excel(name = "pallocateid", width = 15)
- private Integer pallocateid;
- /**demandcode*/
- @Excel(name = "demandcode", width = 15)
- private String demandcode;
- /**collectiveflag*/
- @Excel(name = "collectiveflag", width = 15)
- private Integer collectiveflag;
- /**ordertype*/
- @Excel(name = "ordertype", width = 15)
- private Integer ordertype;
- /**orderdid*/
- @Excel(name = "orderdid", width = 15)
- private Integer orderdid;
- /**ordercode*/
- @Excel(name = "ordercode", width = 15)
- private String ordercode;
- /**orderseq*/
- @Excel(name = "orderseq", width = 15)
- private Integer orderseq;
- /**manualcode*/
- @Excel(name = "manualcode", width = 15)
- private String manualcode;
- /**reformflag*/
- @Excel(name = "reformflag", width = 15)
- private Object reformflag;
- /**sourceqcvouchtype*/
- @Excel(name = "sourceqcvouchtype", width = 15)
- private Integer sourceqcvouchtype;
- /**orgqty*/
- @Excel(name = "orgqty", width = 15)
- private Object orgqty;
- /**fmflag*/
- @Excel(name = "fmflag", width = 15)
- private Object fmflag;
- /**minsn*/
- @Excel(name = "minsn", width = 15)
- private String minsn;
- /**maxsn*/
- @Excel(name = "maxsn", width = 15)
- private String maxsn;
- /**sourcesvccode*/
- @Excel(name = "sourcesvccode", width = 15)
- private String sourcesvccode;
- /**sourcesvcid*/
- @Excel(name = "sourcesvcid", width = 15)
- private String sourcesvcid;
- /**sourcesvcdid*/
- @Excel(name = "sourcesvcdid", width = 15)
- private String sourcesvcdid;
- /**bomtype*/
- @Excel(name = "bomtype", width = 15)
- private Integer bomtype;
- /**routingtype*/
- @Excel(name = "routingtype", width = 15)
- private Integer routingtype;
- /**busflowid*/
- @Excel(name = "busflowid", width = 15)
- private Integer busflowid;
- /**runcardflag*/
- @Excel(name = "runcardflag", width = 15)
- private Object runcardflag;
- /**requisitionflag*/
- @Excel(name = "requisitionflag", width = 15)
- private Object requisitionflag;
- /**allovtid*/
- @Excel(name = "allovtid", width = 15)
- private Integer allovtid;
- /**relsallovtid*/
- @Excel(name = "relsallovtid", width = 15)
- private Integer relsallovtid;
- /**iprintcount*/
- @Excel(name = "iprintcount", width = 15)
- private Integer iprintcount;
- /**cbsysbarcode*/
- @Excel(name = "cbsysbarcode", width = 15)
- private String cbsysbarcode;
- /**ccurrentauditor*/
- @Excel(name = "ccurrentauditor", width = 15)
- private String ccurrentauditor;
- /**custcode*/
- @Excel(name = "custcode", width = 15)
- private String custcode;
- /**lplancode*/
- @Excel(name = "lplancode", width = 15)
- private String lplancode;
- /**sourcesvcvouchtype*/
- @Excel(name = "sourcesvcvouchtype", width = 15)
- private Integer sourcesvcvouchtype;
- /**factorycode*/
- @Excel(name = "factorycode", width = 15)
- private String factorycode;
- //产品名称
- @TableField(exist = false)
- private String cinvname;
- //产品编码
- @TableField(exist = false)
- private String cinvcode;
- //产品规格
- @TableField(exist = false)
- private String cinvstd;
- //生产订单号
- @TableField(exist = false)
- private String mocode;
- //总数量
- @TableField(exist = false)
- private Integer total;
- //总料数
- @TableField(exist = false)
- private Integer materialPreparationTotal;
- //备料数量
- @TableField(exist = false)
- private Integer materialPreparationNumber;
- //未完成数量
- @TableField(exist = false)
- private Integer unfinishedQuantity;
- //应领数量
- @TableField(exist = false)
- private Integer qtys;
- //已领数量
- @TableField(exist = false)
- private Integer issQty;
- //缺料数量
- @TableField(exist = false)
- private Integer shortageQuantity;
- //项目名称
- @TableField(exist = false)
- private String define12;
- //申请人
- @TableField(exist = false)
- private String cmaker;
- //部门名称
- @TableField(exist = false)
- private String cdepName;
- //领料时间
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
- @DateTimeFormat(pattern="yyyy-MM-dd")
- @TableField(exist = false)
- private Date ddate;
- //标准工时
- @TableField(exist = false)
- private String cinvDefine13;
- //已投入工时
- @TableField(exist = false)
- private String manHoursInvested;
- //年月标识 查询当月订单用
- @TableField(exist = false)
- private String yearMonth;
- //产品名称
- @TableField(exist = false)
- private String mocinvname;
- //子子件物料名称
- @TableField(exist = false)
- private String mcinvname;
- //子子件物料编码
- @TableField(exist = false)
- private String mcinvcode;
- //子件物料编码
- @TableField(exist = false)
- private String mInvCode;
- //erp开工时间
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
- @DateTimeFormat(pattern="yyyy-MM-dd")
- @TableField(exist = false)
- private Date startDate;
- //rep完工时间
- @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
- @DateTimeFormat(pattern="yyyy-MM-dd")
- @TableField(exist = false)
- private Date dueDate;
- @TableField(exist = false)
- private Object modQty;
- //项目编码
- @TableField(exist = false)
- private String costItemCode;
- //项目编码
- @TableField(exist = false)
- private String itemCode;
- //工作中心
- @TableField(exist = false)
- private String workCenter;
- //工艺顺序
- @TableField(exist = false)
- private String processSequence;
- //工艺id
- @TableField(exist = false)
- private String fbsTechnologicalProcessId;
- // @TableField(exist = false)
- // private String sortseq;
- @TableField(exist = false)
- private String SAPStatus;
- //工艺名称
- @TableField(exist = false)
- private String fbsTechnologicalProcessName;
- }
|