namespace Admin.NET.Plugin.AiDOP.Supply; /// /// 采购订单明细(PurOrdDetail) /// [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; } }