AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Supply/Entity/PurOrdDetail.cs

namespace Admin.NET.Plugin.AiDOP.Supply;

/// <summary>
/// 采购订单明细（PurOrdDetail）
/// </summary>
[SugarTable("PurOrdDetail", "采购订单明细")]
public class PurOrdDetail
{
    [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
    public int RecID { get; set; }

    [SugarColumn(ColumnName = "PurAcct", Length = 8, IsNullable = true)]
    public string? PurAcct { get; set; }

    [SugarColumn(ColumnName = "ApprovedBy", Length = 8, IsNullable = true)]
    public string? ApprovedBy { get; set; }

    [SugarColumn(ColumnName = "ApprovalCode", Length = 8, IsNullable = true)]
    public string? ApprovalCode { get; set; }

    [SugarColumn(ColumnName = "Assay", ColumnDataType = "decimal(18,5)", IsNullable = true)]
    public decimal? Assay { get; set; }

    [SugarColumn(ColumnName = "Blanket", Length = 8, IsNullable = true)]
    public string? Blanket { get; set; }

    [SugarColumn(ColumnName = "BlanketLine")]
    public int BlanketLine { get; set; }

    [SugarColumn(ColumnName = "QtyBO", ColumnDataType = "decimal(12,5)")]
    public decimal QtyBO { get; set; }

    [SugarColumn(ColumnName = "CostCtr", Length = 4, IsNullable = true)]
    public string? CostCtr { get; set; }

    [SugarColumn(ColumnName = "CommentIndex")]
    public int CommentIndex { get; set; }

    [SugarColumn(ColumnName = "Consignment")]
    public short Consignment { get; set; }

    [SugarColumn(ColumnName = "Contract", Length = 24, IsNullable = true)]
    public string? Contract { get; set; }

    [SugarColumn(ColumnName = "ContractID", Length = 8, IsNullable = true)]
    public string? ContractID { get; set; }

    [SugarColumn(ColumnName = "RctCost", ColumnDataType = "decimal(14,5)")]
    public decimal RctCost { get; set; }

    [SugarColumn(ColumnName = "CreditTermsInt", ColumnDataType = "decimal(9,5)")]
    public decimal CreditTermsInt { get; set; }

    [SugarColumn(ColumnName = "UpdateCurrentCost", ColumnDataType = "bit(1)")]
    public bool UpdateCurrentCost { get; set; }

    [SugarColumn(ColumnName = "CumStart1", IsNullable = true)]
    public DateTime? CumStart1 { get; set; }

    [SugarColumn(ColumnName = "CumStart2", IsNullable = true)]
    public DateTime? CumStart2 { get; set; }

    [SugarColumn(ColumnName = "CumStart3", IsNullable = true)]
    public DateTime? CumStart3 { get; set; }

    [SugarColumn(ColumnName = "CumStart4", IsNullable = true)]
    public DateTime? CumStart4 { get; set; }

    [SugarColumn(ColumnName = "CumReceived1", ColumnDataType = "decimal(15,5)")]
    public decimal CumReceived1 { get; set; }

    [SugarColumn(ColumnName = "CumReceived2", ColumnDataType = "decimal(15,5)")]
    public decimal CumReceived2 { get; set; }

    [SugarColumn(ColumnName = "CumReceived3", ColumnDataType = "decimal(15,5)")]
    public decimal CumReceived3 { get; set; }

    [SugarColumn(ColumnName = "CumReceived4", ColumnDataType = "decimal(15,5)")]
    public decimal CumReceived4 { get; set; }

    [SugarColumn(ColumnName = "ActiveRlseID1", Length = 100, IsNullable = true)]
    public string? ActiveRlseID1 { get; set; }

    [SugarColumn(ColumnName = "ActiveRlseID2", Length = 100, IsNullable = true)]
    public string? ActiveRlseID2 { get; set; }

    [SugarColumn(ColumnName = "ActiveRlseID3", Length = 100, IsNullable = true)]
    public string? ActiveRlseID3 { get; set; }

    [SugarColumn(ColumnName = "Disc", ColumnDataType = "decimal(7,5)")]
    public decimal Disc { get; set; }

    [SugarColumn(ColumnName = "Dock", Length = 8, IsNullable = true)]
    public string? Dock { get; set; }

    [SugarColumn(ColumnName = "Domain", Length = 24, IsNullable = true)]
    public string? Domain { get; set; }

    [SugarColumn(ColumnName = "DRPRef", Length = 8, IsNullable = true)]
    public string? DRPRef { get; set; }

    [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
    public DateTime? DueDate { get; set; }

    [SugarColumn(ColumnName = "EndEff1", IsNullable = true)]
    public DateTime? EndEff1 { get; set; }

    [SugarColumn(ColumnName = "EndEff2", IsNullable = true)]
    public DateTime? EndEff2 { get; set; }

    [SugarColumn(ColumnName = "EndEff3", IsNullable = true)]
    public DateTime? EndEff3 { get; set; }

    [SugarColumn(ColumnName = "EndEff4", IsNullable = true)]
    public DateTime? EndEff4 { get; set; }

    [SugarColumn(ColumnName = "ERSOption")]
    public int ERSOption { get; set; }

    [SugarColumn(ColumnName = "ExpireDate", IsNullable = true)]
    public DateTime? ExpireDate { get; set; }

    [SugarColumn(ColumnName = "FabAuthDays")]
    public int FabAuthDays { get; set; }

    [SugarColumn(ColumnName = "FabAuthWeeks")]
    public int FabAuthWeeks { get; set; }

    [SugarColumn(ColumnName = "FirmDays")]
    public int FirmDays { get; set; }

    [SugarColumn(ColumnName = "FirmWeeks")]
    public int FirmWeeks { get; set; }

    [SugarColumn(ColumnName = "FixedPrice", ColumnDataType = "bit(1)")]
    public bool FixedPrice { get; set; }

    [SugarColumn(ColumnName = "FrtList", Length = 8, IsNullable = true)]
    public string? FrtList { get; set; }

    [SugarColumn(ColumnName = "FSMType", Length = 8, IsNullable = true)]
    public string? FSMType { get; set; }

    [SugarColumn(ColumnName = "Grade", Length = 2, IsNullable = true)]
    public string? Grade { get; set; }

    [SugarColumn(ColumnName = "InspectReq", ColumnDataType = "bit(1)")]
    public bool InspectReq { get; set; }

    [SugarColumn(ColumnName = "Line")]
    public short Line { get; set; }

    [SugarColumn(ColumnName = "Location", Length = 8, IsNullable = true)]
    public string? Location { get; set; }

    [SugarColumn(ColumnName = "NextLotSerial", Length = 24, IsNullable = true)]
    public string? NextLotSerial { get; set; }

    [SugarColumn(ColumnName = "SingleLot", ColumnDataType = "bit(1)")]
    public bool SingleLot { get; set; }

    [SugarColumn(ColumnName = "MaxAgingDays")]
    public int MaxAgingDays { get; set; }

    [SugarColumn(ColumnName = "SupplyPer", ColumnDataType = "decimal(8,5)")]
    public decimal SupplyPer { get; set; }

    [SugarColumn(ColumnName = "MultiDueDates")]
    public short MultiDueDates { get; set; }

    [SugarColumn(ColumnName = "PurOrd", Length = 24)]
    public string PurOrd { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "NeedDate", IsNullable = true)]
    public DateTime? NeedDate { get; set; }

    [SugarColumn(ColumnName = "Op")]
    public int Op { get; set; }

    [SugarColumn(ColumnName = "StdPackQty", ColumnDataType = "decimal(10,0)", IsNullable = true)]
    public decimal? StdPackQty { get; set; }

    [SugarColumn(ColumnName = "ItemNum", Length = 60, IsNullable = true)]
    public string? ItemNum { get; set; }

    [SugarColumn(ColumnName = "Dimension1", Length = 8)]
    public string Dimension1 { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "Dimension2", Length = 8)]
    public string Dimension2 { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "PastDueLogic", Length = 1, IsNullable = true)]
    public string? PastDueLogic { get; set; }

    [SugarColumn(ColumnName = "PayUM", Length = 2, IsNullable = true)]
    public string? PayUM { get; set; }

    [SugarColumn(ColumnName = "PerformDate", IsNullable = true)]
    public DateTime? PerformDate { get; set; }

    [SugarColumn(ColumnName = "ProjectLine")]
    public int ProjectLine { get; set; }

    [SugarColumn(ColumnName = "PkgCode", Length = 60, IsNullable = true)]
    public string? PkgCode { get; set; }

    [SugarColumn(ColumnName = "PlanSchedDays")]
    public int PlanSchedDays { get; set; }

    [SugarColumn(ColumnName = "PlanSchedMonths")]
    public int PlanSchedMonths { get; set; }

    [SugarColumn(ColumnName = "PlanSchedWeeks")]
    public int PlanSchedWeeks { get; set; }

    [SugarColumn(ColumnName = "PODatabase", Length = 8, IsNullable = true)]
    public string? PODatabase { get; set; }

    [SugarColumn(ColumnName = "POSite", Length = 8, IsNullable = true)]
    public string? POSite { get; set; }

    [SugarColumn(ColumnName = "PricingDate", IsNullable = true)]
    public DateTime? PricingDate { get; set; }

    [SugarColumn(ColumnName = "Project", Length = 24, IsNullable = true)]
    public string? Project { get; set; }

    [SugarColumn(ColumnName = "PriceList", Length = 20, IsNullable = true)]
    public string? PriceList { get; set; }

    [SugarColumn(ColumnName = "ERSPriceListOption")]
    public int ERSPriceListOption { get; set; }

    [SugarColumn(ColumnName = "PST", ColumnDataType = "bit(1)")]
    public bool PST { get; set; }

    [SugarColumn(ColumnName = "PackingSlipQty", ColumnDataType = "decimal(12,5)")]
    public decimal PackingSlipQty { get; set; }

    [SugarColumn(ColumnName = "PayUMConv", ColumnDataType = "decimal(10,5)")]
    public decimal PayUMConv { get; set; }

    [SugarColumn(ColumnName = "PurCost", ColumnDataType = "decimal(15,6)")]
    public decimal PurCost { get; set; }

    [SugarColumn(ColumnName = "RctQty", ColumnDataType = "decimal(15,5)")]
    public decimal RctQty { get; set; }

    [SugarColumn(ColumnName = "QtyOrded", ColumnDataType = "decimal(15,5)")]
    public decimal QtyOrded { get; set; }

    [SugarColumn(ColumnName = "QtyReceived", ColumnDataType = "decimal(15,5)")]
    public decimal QtyReceived { get; set; }

    [SugarColumn(ColumnName = "QtyReturned", ColumnDataType = "decimal(15,5)")]
    public decimal QtyReturned { get; set; }

    [SugarColumn(ColumnName = "RawAuthDays")]
    public int RawAuthDays { get; set; }

    [SugarColumn(ColumnName = "RawAuthWeeks")]
    public int RawAuthWeeks { get; set; }

    [SugarColumn(ColumnName = "RctStatus", Length = 60, IsNullable = true)]
    public string? RctStatus { get; set; }

    [SugarColumn(ColumnName = "Active", ColumnDataType = "bit(1)")]
    public bool Active { get; set; }

    [SugarColumn(ColumnName = "Reason", Length = 8, IsNullable = true)]
    public string? Reason { get; set; }

    [SugarColumn(ColumnName = "Rel")]
    public int Rel { get; set; }

    [SugarColumn(ColumnName = "QtyReleased", ColumnDataType = "decimal(12,5)")]
    public decimal QtyReleased { get; set; }

    [SugarColumn(ColumnName = "RequestedBy", Length = 8, IsNullable = true)]
    public string? RequestedBy { get; set; }

    [SugarColumn(ColumnName = "ReqLine")]
    public int ReqLine { get; set; }

    [SugarColumn(ColumnName = "Req", Length = 20, IsNullable = true)]
    public string? Req { get; set; }

    [SugarColumn(ColumnName = "Revision", Length = 4, IsNullable = true)]
    public string? Revision { get; set; }

    [SugarColumn(ColumnName = "NextReleaseID")]
    public int NextReleaseID { get; set; }

    [SugarColumn(ColumnName = "RMAType", Length = 1, IsNullable = true)]
    public string? RMAType { get; set; }

    [SugarColumn(ColumnName = "RMAUM", Length = 2, IsNullable = true)]
    public string? RMAUM { get; set; }

    [SugarColumn(ColumnName = "RctUMConversion", ColumnDataType = "decimal(10,5)")]
    public decimal RctUMConversion { get; set; }

    [SugarColumn(ColumnName = "Scheduled", ColumnDataType = "bit(1)")]
    public bool Scheduled { get; set; }

    [SugarColumn(ColumnName = "ScheduledChanged", ColumnDataType = "bit(1)")]
    public bool ScheduledChanged { get; set; }

    [SugarColumn(ColumnName = "ScheduleData", Length = 8, IsNullable = true)]
    public string? ScheduleData { get; set; }

    [SugarColumn(ColumnName = "SchedMRPReq", ColumnDataType = "bit(1)")]
    public bool SchedMRPReq { get; set; }

    [SugarColumn(ColumnName = "ShipDlvyPattern", Length = 2, IsNullable = true)]
    public string? ShipDlvyPattern { get; set; }

    [SugarColumn(ColumnName = "ShipDlvyTime", Length = 2, IsNullable = true)]
    public string? ShipDlvyTime { get; set; }

    [SugarColumn(ColumnName = "WIPLotSerial", Length = 24, IsNullable = true)]
    public string? WIPLotSerial { get; set; }

    [SugarColumn(ColumnName = "SafetyDays", ColumnDataType = "decimal(8,5)")]
    public decimal SafetyDays { get; set; }

    [SugarColumn(ColumnName = "SafetyHours", ColumnDataType = "decimal(8,5)")]
    public decimal SafetyHours { get; set; }

    [SugarColumn(ColumnName = "ShipSchedWeeks")]
    public int ShipSchedWeeks { get; set; }

    [SugarColumn(ColumnName = "Site", Length = 24, IsNullable = true)]
    public string? Site { get; set; }

    [SugarColumn(ColumnName = "PrimarySOLine")]
    public int PrimarySOLine { get; set; }

    [SugarColumn(ColumnName = "SalesJob", Length = 200, IsNullable = true)]
    public string? SalesJob { get; set; }

    [SugarColumn(ColumnName = "SecondarySOStatus", Length = 1, IsNullable = true)]
    public string? SecondarySOStatus { get; set; }

    [SugarColumn(ColumnName = "StartEff1", IsNullable = true)]
    public DateTime? StartEff1 { get; set; }

    [SugarColumn(ColumnName = "StartEff2", IsNullable = true)]
    public DateTime? StartEff2 { get; set; }

    [SugarColumn(ColumnName = "StartEff3", IsNullable = true)]
    public DateTime? StartEff3 { get; set; }

    [SugarColumn(ColumnName = "StartEff4", IsNullable = true)]
    public DateTime? StartEff4 { get; set; }

    [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "StdCost", ColumnDataType = "decimal(14,5)")]
    public decimal StdCost { get; set; }

    [SugarColumn(ColumnName = "PurSubAcct", Length = 8, IsNullable = true)]
    public string? PurSubAcct { get; set; }

    [SugarColumn(ColumnName = "SubcontractShip", IsNullable = true)]
    public DateTime? SubcontractShip { get; set; }

    [SugarColumn(ColumnName = "SubcontractType", Length = 8, IsNullable = true)]
    public string? SubcontractType { get; set; }

    [SugarColumn(ColumnName = "Taxable", ColumnDataType = "bit(1)")]
    public bool Taxable { get; set; }

    [SugarColumn(ColumnName = "TaxClass", Length = 20, IsNullable = true)]
    public string? TaxClass { get; set; }

    [SugarColumn(ColumnName = "TaxEnvironment", Length = 16, IsNullable = true)]
    public string? TaxEnvironment { get; set; }

    [SugarColumn(ColumnName = "TaxIn", ColumnDataType = "bit(1)")]
    public bool TaxIn { get; set; }

    [SugarColumn(ColumnName = "MaxTaxableAmt", ColumnDataType = "decimal(14,5)")]
    public decimal MaxTaxableAmt { get; set; }

    [SugarColumn(ColumnName = "TaxUsage", Length = 8, IsNullable = true)]
    public string? TaxUsage { get; set; }

    [SugarColumn(ColumnName = "TransportDays", ColumnDataType = "decimal(18,5)", IsNullable = true)]
    public decimal? TransportDays { get; set; }

    [SugarColumn(ColumnName = "TransportHours", ColumnDataType = "decimal(8,5)")]
    public decimal TransportHours { get; set; }

    [SugarColumn(ColumnName = "Typed", Length = 1, IsNullable = true)]
    public string? Typed { get; set; }

    [SugarColumn(ColumnName = "UM", Length = 8, IsNullable = true)]
    public string? UM { get; set; }

    [SugarColumn(ColumnName = "UMConversion", ColumnDataType = "decimal(12,7)")]
    public decimal UMConversion { get; set; }

    [SugarColumn(ColumnName = "Ufld1", Length = 24, IsNullable = true)]
    public string? Ufld1 { get; set; }

    [SugarColumn(ColumnName = "Ufld2", Length = 24, IsNullable = true)]
    public string? Ufld2 { get; set; }

    [SugarColumn(ColumnName = "VAT", ColumnDataType = "bit(1)")]
    public bool VAT { get; set; }

    [SugarColumn(ColumnName = "SuppItem", Length = 24, IsNullable = true)]
    public string? SuppItem { get; set; }

    [SugarColumn(ColumnName = "LotSerial", Length = 120, IsNullable = true)]
    public string? LotSerial { get; set; }

    [SugarColumn(ColumnName = "WorkOrdID", Length = 30, IsNullable = true)]
    public string? WorkOrdID { get; set; }

    [SugarColumn(ColumnName = "BusinessID")]
    public long BusinessID { get; set; }

    [SugarColumn(ColumnName = "CreateUser", Length = 24, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "UpdateUser", Length = 24, IsNullable = true)]
    public string? UpdateUser { get; set; }

    [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
    public DateTime? UpdateTime { get; set; }

    [SugarColumn(ColumnName = "EffTime", IsNullable = true)]
    public DateTime? EffTime { get; set; }

    [SugarColumn(ColumnName = "IsActive", ColumnDataType = "bit(1)")]
    public bool IsActive { get; set; }

    [SugarColumn(ColumnName = "IsConfirm", ColumnDataType = "bit(1)")]
    public bool IsConfirm { get; set; }

    [SugarColumn(ColumnName = "Potype", Length = 8)]
    public string Potype { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "IsChanged", ColumnDataType = "bit(1)")]
    public bool IsChanged { get; set; }

    [SugarColumn(ColumnName = "Remark", ColumnDataType = "text", IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnName = "Usage", Length = 30, IsNullable = true)]
    public string? Usage { get; set; }

    [SugarColumn(ColumnName = "TaxRate", ColumnDataType = "decimal(8,5)")]
    public decimal TaxRate { get; set; }

    [SugarColumn(ColumnName = "Comments1", Length = 50, IsNullable = true)]
    public string? Comments1 { get; set; }

    [SugarColumn(ColumnName = "ListPurCost", ColumnDataType = "decimal(18,5)", IsNullable = true)]
    public decimal? ListPurCost { get; set; }

    [SugarColumn(ColumnName = "IsRounding", ColumnDataType = "bit(1)")]
    public bool IsRounding { get; set; }

    [SugarColumn(ColumnName = "ReceiptQty", ColumnDataType = "decimal(15,5)")]
    public decimal ReceiptQty { get; set; }

    [SugarColumn(ColumnName = "BarCodeQty", ColumnDataType = "decimal(18,5)")]
    public decimal BarCodeQty { get; set; }

    [SugarColumn(ColumnName = "IsClosed", ColumnDataType = "bit(1)")]
    public bool IsClosed { get; set; }

    [SugarColumn(ColumnName = "Rev", Length = 8, IsNullable = true)]
    public string? Rev { get; set; }

    [SugarColumn(ColumnName = "Remarks", Length = 100, IsNullable = true)]
    public string? Remarks { get; set; }

    [SugarColumn(ColumnName = "Department", Length = 8, IsNullable = true)]
    public string? Department { get; set; }

    [SugarColumn(ColumnName = "WorkOrd", Length = 30, IsNullable = true)]
    public string? WorkOrd { get; set; }

    [SugarColumn(ColumnName = "QtyReturnedRefund", ColumnDataType = "decimal(15,5)")]
    public decimal QtyReturnedRefund { get; set; }

    [SugarColumn(ColumnName = "CumQtyBO", ColumnDataType = "decimal(18,5)")]
    public decimal CumQtyBO { get; set; }

    [SugarColumn(ColumnName = "PurOrdRecID")]
    public int PurOrdRecID { get; set; }

    [SugarColumn(ColumnName = "Drawing", Length = 24, IsNullable = true)]
    public string? Drawing { get; set; }

    [SugarColumn(ColumnName = "ERPfld1", Length = 200, IsNullable = true)]
    public string? ERPfld1 { get; set; }

    [SugarColumn(ColumnName = "ERPfld2", Length = 200, IsNullable = true)]
    public string? ERPfld2 { get; set; }

    [SugarColumn(ColumnName = "IsPush", ColumnDataType = "bit(1)", IsNullable = true)]
    public bool? IsPush { get; set; }

    [SugarColumn(ColumnName = "Descr", ColumnDataType = "text", IsNullable = true)]
    public string? Descr { get; set; }
}