| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356 |
- namespace Admin.NET.Plugin.AiDOP.Supply;
- /// <summary>
- /// 采购订单主表(PurOrdMaster)
- /// </summary>
- [SugarTable("PurOrdMaster", "采购订单主表")]
- public class PurOrdMaster
- {
- [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
- public int RecID { get; set; }
- [SugarColumn(ColumnName = "OwnerApplication", Length = 12, IsNullable = true)]
- public string? OwnerApplication { get; set; }
- [SugarColumn(ColumnName = "APAcct", Length = 16, IsNullable = true)]
- public string? APAcct { get; set; }
- [SugarColumn(ColumnName = "CostCtr", Length = 4, IsNullable = true)]
- public string? CostCtr { get; set; }
- [SugarColumn(ColumnName = "APSubAcct", Length = 8, IsNullable = true)]
- public string? APSubAcct { get; set; }
- [SugarColumn(ColumnName = "Bank", Length = 2, IsNullable = true)]
- public string? Bank { get; set; }
- [SugarColumn(ColumnName = "BillTo", Length = 10, IsNullable = true)]
- public string? BillTo { get; set; }
- [SugarColumn(ColumnName = "BlanketOrd", Length = 24, IsNullable = true)]
- public string? BlanketOrd { get; set; }
- [SugarColumn(ColumnName = "Buyer", Length = 30, IsNullable = true)]
- public string? Buyer { get; set; }
- [SugarColumn(ColumnName = "CloseDate", IsNullable = true)]
- public DateTime? CloseDate { get; set; }
- [SugarColumn(ColumnName = "CommentIndex")]
- public int CommentIndex { get; set; }
- [SugarColumn(ColumnName = "Confirming", ColumnDataType = "bit(1)")]
- public bool Confirming { get; set; }
- [SugarColumn(ColumnName = "Consignment")]
- public short Consignment { get; set; }
- [SugarColumn(ColumnName = "Contact", Length = 24, IsNullable = true)]
- public string? Contact { get; set; }
- [SugarColumn(ColumnName = "Contract", Length = 24, IsNullable = true)]
- public string? Contract { get; set; }
- [SugarColumn(ColumnName = "CreditTermsInt", ColumnDataType = "decimal(9,5)")]
- public decimal CreditTermsInt { get; set; }
- [SugarColumn(ColumnName = "CreditTerms", Length = 8, IsNullable = true)]
- public string? CreditTerms { get; set; }
- [SugarColumn(ColumnName = "Curr", Length = 3, IsNullable = true)]
- public string? Curr { get; set; }
- [SugarColumn(ColumnName = "CycleCode", Length = 2, IsNullable = true)]
- public string? CycleCode { get; set; }
- [SugarColumn(ColumnName = "DeliverTo", Length = 4, IsNullable = true)]
- public string? DeliverTo { get; set; }
- [SugarColumn(ColumnName = "Disc", ColumnDataType = "decimal(7,5)")]
- public decimal Disc { get; set; }
- [SugarColumn(ColumnName = "Domain", Length = 24, IsNullable = true)]
- public string? Domain { get; set; }
- [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
- public DateTime? DueDate { get; set; }
- [SugarColumn(ColumnName = "DutyType", Length = 1, IsNullable = true)]
- public string? DutyType { get; set; }
- [SugarColumn(ColumnName = "BlanketStart", IsNullable = true)]
- public DateTime? BlanketStart { get; set; }
- [SugarColumn(ColumnName = "BlanketEnd", IsNullable = true)]
- public DateTime? BlanketEnd { get; set; }
- [SugarColumn(ColumnName = "ExchRate", ColumnDataType = "decimal(10,5)")]
- public decimal ExchRate { get; set; }
- [SugarColumn(ColumnName = "ERSOption", Length = 2, IsNullable = true)]
- public string? ERSOption { get; set; }
- [SugarColumn(ColumnName = "EstVal", ColumnDataType = "decimal(13,5)")]
- public decimal EstVal { get; set; }
- [SugarColumn(ColumnName = "Sequence")]
- public int Sequence { get; set; }
- [SugarColumn(ColumnName = "ExchRate1", ColumnDataType = "decimal(15,5)")]
- public decimal ExchRate1 { get; set; }
- [SugarColumn(ColumnName = "ExchRate2", ColumnDataType = "decimal(15,5)")]
- public decimal ExchRate2 { get; set; }
- [SugarColumn(ColumnName = "RateType", Length = 8, IsNullable = true)]
- public string? RateType { get; set; }
- [SugarColumn(ColumnName = "FixedPrice", ColumnDataType = "bit(1)")]
- public bool FixedPrice { get; set; }
- [SugarColumn(ColumnName = "FixedRate", ColumnDataType = "bit(1)")]
- public bool FixedRate { get; set; }
- [SugarColumn(ColumnName = "FOB", Length = 20, IsNullable = true)]
- public string? FOB { get; set; }
- [SugarColumn(ColumnName = "Frt", ColumnDataType = "decimal(6,5)")]
- public decimal Frt { get; set; }
- [SugarColumn(ColumnName = "FSMType", Length = 8, IsNullable = true)]
- public string? FSMType { get; set; }
- [SugarColumn(ColumnName = "FSTID", Length = 24, IsNullable = true)]
- public string? FSTID { get; set; }
- [SugarColumn(ColumnName = "InvoicesVia", Length = 8, IsNullable = true)]
- public string? InvoicesVia { get; set; }
- [SugarColumn(ColumnName = "EMTPO")]
- public short EMTPO { get; set; }
- [SugarColumn(ColumnName = "Language", Length = 2, IsNullable = true)]
- public string? Language { get; set; }
- [SugarColumn(ColumnName = "MaxAgingDays")]
- public int MaxAgingDays { get; set; }
- [SugarColumn(ColumnName = "PurOrd", Length = 48, IsNullable = true)]
- public string? PurOrd { get; set; }
- [SugarColumn(ColumnName = "OrdDate", IsNullable = true)]
- public DateTime? OrdDate { get; set; }
- [SugarColumn(ColumnName = "PartialOK", ColumnDataType = "bit(1)")]
- public bool PartialOK { get; set; }
- [SugarColumn(ColumnName = "AmtPrepaid", ColumnDataType = "decimal(15,5)")]
- public decimal AmtPrepaid { get; set; }
- [SugarColumn(ColumnName = "LastPriceDt", IsNullable = true)]
- public DateTime? LastPriceDt { get; set; }
- [SugarColumn(ColumnName = "PricingDate", IsNullable = true)]
- public DateTime? PricingDate { get; set; }
- [SugarColumn(ColumnName = "PrintPO", ColumnDataType = "bit(1)")]
- public bool PrintPO { get; set; }
- [SugarColumn(ColumnName = "Project", Length = 24, IsNullable = true)]
- public string? Project { get; set; }
- [SugarColumn(ColumnName = "DiscTbl", Length = 8, IsNullable = true)]
- public string? DiscTbl { get; set; }
- [SugarColumn(ColumnName = "PriceTbl", Length = 20, IsNullable = true)]
- public string? PriceTbl { get; set; }
- [SugarColumn(ColumnName = "ERSPriceListOption")]
- public int ERSPriceListOption { get; set; }
- [SugarColumn(ColumnName = "PST", ColumnDataType = "bit(1)")]
- public bool PST { get; set; }
- [SugarColumn(ColumnName = "PSTID", Length = 24, IsNullable = true)]
- public string? PSTID { get; set; }
- [SugarColumn(ColumnName = "Recurr", ColumnDataType = "bit(1)")]
- public bool Recurr { get; set; }
- [SugarColumn(ColumnName = "Release", ColumnDataType = "bit(1)")]
- public bool ReleaseFlag { get; set; }
- [SugarColumn(ColumnName = "Rel")]
- public int Rel { get; set; }
- [SugarColumn(ColumnName = "ReqBy", Length = 8, IsNullable = true)]
- public string? ReqBy { get; set; }
- [SugarColumn(ColumnName = "Revision", ColumnDataType = "decimal(8,5)")]
- public decimal Revision { get; set; }
- [SugarColumn(ColumnName = "Remark", Length = 200, IsNullable = true)]
- public string? Remark { get; set; }
- [SugarColumn(ColumnName = "Scheduled", ColumnDataType = "bit(1)")]
- public bool Scheduled { get; set; }
- [SugarColumn(ColumnName = "SchedulesVia", Length = 1, IsNullable = true)]
- public string? SchedulesVia { get; set; }
- [SugarColumn(ColumnName = "ServiceCharge", ColumnDataType = "decimal(6,5)")]
- public decimal ServiceCharge { get; set; }
- [SugarColumn(ColumnName = "ShipTo", Length = 20, IsNullable = true)]
- public string? ShipTo { get; set; }
- [SugarColumn(ColumnName = "ShipVia", Length = 20, IsNullable = true)]
- public string? ShipVia { get; set; }
- [SugarColumn(ColumnName = "Site", Length = 24, IsNullable = true)]
- public string? Site { get; set; }
- [SugarColumn(ColumnName = "SecondarySOCrHold")]
- public short SecondarySOCrHold { get; set; }
- [SugarColumn(ColumnName = "PrimarySO", Length = 8, IsNullable = true)]
- public string? PrimarySO { get; set; }
- [SugarColumn(ColumnName = "SpecialCharge", ColumnDataType = "decimal(6,5)")]
- public decimal SpecialCharge { get; set; }
- [SugarColumn(ColumnName = "Status", Length = 2, IsNullable = true)]
- public string? Status { 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 = "TaxDate", IsNullable = true)]
- public DateTime? TaxDate { get; set; }
- [SugarColumn(ColumnName = "TaxEnvironment", Length = 16, IsNullable = true)]
- public string? TaxEnvironment { get; set; }
- [SugarColumn(ColumnName = "Tax1", ColumnDataType = "decimal(7,5)")]
- public decimal Tax1 { get; set; }
- [SugarColumn(ColumnName = "Tax2", ColumnDataType = "decimal(7,5)")]
- public decimal Tax2 { get; set; }
- [SugarColumn(ColumnName = "Tax3", ColumnDataType = "decimal(7,5)")]
- public decimal Tax3 { get; set; }
- [SugarColumn(ColumnName = "TaxUsage", Length = 8, IsNullable = true)]
- public string? TaxUsage { get; set; }
- [SugarColumn(ColumnName = "TermsofTrade", Length = 20, IsNullable = true)]
- public string? TermsofTrade { get; set; }
- [SugarColumn(ColumnName = "TransportDays", ColumnDataType = "decimal(8,5)")]
- public decimal TransportDays { get; set; }
- [SugarColumn(ColumnName = "Typed", Length = 18, IsNullable = true)]
- public string? Typed { get; set; }
- [SugarColumn(ColumnName = "Ufld1", Length = 24, IsNullable = true)]
- public string? Ufld1 { get; set; }
- [SugarColumn(ColumnName = "Ufld2", Length = 60, IsNullable = true)]
- public string? Ufld2 { get; set; }
- [SugarColumn(ColumnName = "EnteredBy", Length = 8, IsNullable = true)]
- public string? EnteredBy { get; set; }
- [SugarColumn(ColumnName = "Supp", Length = 20, IsNullable = true)]
- public string? Supp { get; set; }
- [SugarColumn(ColumnName = "Transm", Length = 1, IsNullable = true)]
- public string? Transm { 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 = "Department", Length = 8, IsNullable = true)]
- public string? Department { get; set; }
- [SugarColumn(ColumnName = "IsChanged", ColumnDataType = "bit(1)")]
- public bool IsChanged { get; set; }
- [SugarColumn(ColumnName = "TaxIn", ColumnDataType = "bit(1)")]
- public bool TaxIn { get; set; }
- [SugarColumn(ColumnName = "Amt", ColumnDataType = "decimal(15,5)")]
- public decimal Amt { get; set; }
- [SugarColumn(ColumnName = "Usage", Length = 30, IsNullable = true)]
- public string? Usage { get; set; }
- [SugarColumn(ColumnName = "CustAddress", Length = 200, IsNullable = true)]
- public string? CustAddress { get; set; }
- [SugarColumn(ColumnName = "CustContact", Length = 50, IsNullable = true)]
- public string? CustContact { get; set; }
- [SugarColumn(ColumnName = "CustPhone", Length = 30, IsNullable = true)]
- public string? CustPhone { get; set; }
- [SugarColumn(ColumnName = "SalesOrd", Length = 30, IsNullable = true)]
- public string? SalesOrd { get; set; }
- [SugarColumn(ColumnName = "CustPO", Length = 24, IsNullable = true)]
- public string? CustPO { get; set; }
- [SugarColumn(ColumnName = "IsPriceChanged", ColumnDataType = "bit(1)")]
- public bool IsPriceChanged { get; set; }
- [SugarColumn(ColumnName = "CustName", Length = 120, IsNullable = true)]
- public string? CustName { get; set; }
- [SugarColumn(ColumnName = "Rev")]
- public int Rev { get; set; }
- [SugarColumn(ColumnName = "RoleNo", Length = 20, IsNullable = true)]
- public string? RoleNo { get; set; }
- [SugarColumn(ColumnName = "InvoiceType", Length = 20, IsNullable = true)]
- public string? InvoiceType { get; set; }
- [SugarColumn(ColumnName = "PricingMethod", Length = 20, IsNullable = true)]
- public string? PricingMethod { get; set; }
- [SugarColumn(ColumnName = "ERPfld1", Length = 200, IsNullable = true)]
- public string? ERPfld1 { get; set; }
- [SugarColumn(ColumnName = "ERPWorkOrd", Length = 255, IsNullable = true)]
- public string? ERPWorkOrd { get; set; }
- [SugarColumn(ColumnName = "WorkOrd", Length = 255, IsNullable = true)]
- public string? WorkOrd { get; set; }
- }
|