using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     采购订单表
/// </summary>
[SugarTable("MES_ROH_IN")]
public class MesRohIn
{
    /// <summary>
    ///     SEQ_BASEINFO_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID",
        OracleSequenceName = "SEQ_BASEINFO_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     采购单号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }

    /// <summary>
    ///     单据状态
    /// </summary>
    [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
    public string? DocumentStatus { get; set; }

    /// <summary>
    ///     单据类型
    /// </summary>
    [SugarColumn(ColumnName = "DOCUMENT_TYPE")]
    public string? DocumentType { get; set; }

    /// <summary>
    ///     业务类型
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public string? BusinessType { get; set; }

    /// <summary>
    ///     采购日期
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_DATE")]
    public DateTime? PurchaseDate { get; set; }

    /// <summary>
    ///     供应商
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER")]
    public string? Supplier { get; set; }

    /// <summary>
    ///     取业务关闭字段 0==未关闭 1==业务关闭
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_STATUS")]
    public string? CloseStatus { get; set; }

    /// <summary>
    ///     采购组织
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_ORG")]
    public string? PurchaseOrg { get; set; }

    /// <summary>
    ///     采购部门
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_DEPT")]
    public string? PurchaseDept { get; set; }

    /// <summary>
    ///     采购组
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_GROUP")]
    public string? PurchaseGroup { get; set; }

    /// <summary>
    ///     数量验收
    /// </summary>
    [SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
    public string? QtyAcceptance { get; set; }

    /// <summary>
    ///     采购员
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASER")]
    public string? Purchaser { get; set; }

    /// <summary>
    ///     质量要求
    /// </summary>
    [SugarColumn(ColumnName = "QUALITY_REQ")]
    public string? QualityReq { get; set; }

    /// <summary>
    ///     结算方
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
    public string? SettlementParty { get; set; }

    /// <summary>
    ///     收款方
    /// </summary>
    [SugarColumn(ColumnName = "PAYMENT_PARTY")]
    public string? PaymentParty { get; set; }

    /// <summary>
    ///     邮箱
    /// </summary>
    [SugarColumn(ColumnName = "EMAIL")]
    public string? Email { get; set; }

    /// <summary>
    ///     运输方式
    /// </summary>
    [SugarColumn(ColumnName = "TRANSPORT_METHOD")]
    public string? TransportMethod { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string? Remarks { get; set; }

    /// <summary>
    ///     治具丶模具加工及采购
    /// </summary>
    [SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
    public string? FixtureMoldProcurement { get; set; }

    /// <summary>
    ///     作废状态
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_STATUS")]
    public string? CancellationStatus { get; set; }

    /// <summary>
    ///     作废人
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_PERSON")]
    public string? CancellationPerson { get; set; }

    /// <summary>
    ///     作废日期
    /// </summary>
    [SugarColumn(ColumnName = "CANCELLATION_DATE")]
    public DateTime? CancellationDate { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     创建日期
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     最后修改时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     最后修改人
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "ERP_CHECK_BY")]
    public string? ErpCheckBy { get; set; }

    /// <summary>
    ///     审核时间
    /// </summary>
    [SugarColumn(ColumnName = "ERP_CHECK_DATE")]
    public string? ErpCheckDate { get; set; }

    /// <summary>
    ///     ERP的ID号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public string? EbelnK3id { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_BY")]
    public string? CheckBy { get; set; }

    /// <summary>
    ///     审核标识
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_FALG")]
    public short? CheckFalg { get; set; }

    /// <summary>
    ///     自定义字段1
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }

    /// <summary>
    ///     自定义字段2
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }

    /// <summary>
    ///     自定义字段3
    /// </summary>
    [SugarColumn(ColumnName = "REMARK3")]
    public string? Remark3 { get; set; }

    /// <summary>
    ///     自定义字段4
    /// </summary>
    [SugarColumn(ColumnName = "REMARK4")]
    public string? Remark4 { get; set; }

    /// <summary>
    ///     自定义字段5
    /// </summary>
    [SugarColumn(ColumnName = "REMARK5")]
    public string? Remark5 { get; set; }

    /// <summary>
    ///     变更原因
    /// </summary>
    [SugarColumn(ColumnName = "CHANGEREASON")]
    public string? Changereason { get; set; }

    /// <summary>
    ///     预计到达时间
    /// </summary>
    [SugarColumn(ColumnName = "ARRIVE_DATE")]
    public DateTime? ArriveDate { get; set; }

    /// <summary>
    ///     收料组织
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVE_ORG")]
    public string? ReceiveOrg { get; set; }

    /// <summary>
    ///     审批意见
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_TEXT")]
    public string? FWwcText { get; set; }

    /// <summary>
    ///     来源类别,0=手工 1=请购单 3=需求接口表 4=采购合同 6=采购订单 7=销售订单
    /// </summary>
    [SugarColumn(ColumnName = "SRC_DOC_TYPE")]
    public string? SrcDocType { get; set; }

    /// <summary>
    ///     来源单据
    /// </summary>
    [SugarColumn(ColumnName = "SRC_DOC")]
    public string? SrcDoc { get; set; }

    /// <summary>
    ///     贸易路径
    /// </summary>
    [SugarColumn(ColumnName = "TRADE_PATH_NAME")]
    public string? TradePathName { get; set; }

    /// <summary>
    ///     委外类型字段暂未使用，默认值-1
    /// </summary>
    [SugarColumn(ColumnName = "SUB_TYPE")]
    public string? SubType { get; set; }

    /// <summary>
    ///     返工订单 是否勾选项 0==不勾选 1==勾选，默认不勾选
    /// </summary>
    [SugarColumn(ColumnName = "IS_RE_DO")]
    public short? IsReDo { get; set; }

    /// <summary>
    ///     项目采购负责人
    /// </summary>
    [SugarColumn(ColumnName = "PRIVATE_DESC_SEG1")]
    public string? PrivateDescSeg1 { get; set; }

    /// <summary>
    ///     单据版本
    /// </summary>
    [SugarColumn(ColumnName = "VERSION")]
    public string? Version { get; set; }
}