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>
    ///     关闭状态
    /// </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(IsIgnore = true)]
    public string? SupplierContact { get; set; }

    /// <summary>
    ///     联系人电话
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string? ContactPhone { get; set; }

    /// <summary>
    ///     职务
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string? Position { get; set; }

    /// <summary>
    ///     联系电话
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string? OfficePhone { get; set; }

    /// <summary>
    ///     供货方地址
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string? SupplierAddress { 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>
    ///     ERP审核人
    /// </summary>
    [SugarColumn(ColumnName = "ERP_CHECK_BY")]
    public string? ErpCheckBy { get; set; }

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

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

    /// <summary>
    ///     审核日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public string? 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 = "changereason")]
    public string? Changereason { get; set; }

    /// <summary>
    ///     自定义字段1
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public decimal? 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; }

    
}