CustMaster.cs 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. namespace Admin.NET.Plugin.AiDOP.Universal;
  2. /// <summary>
  3. /// 客户主数据(CustMaster 表,外部 ERP 表,只读映射)
  4. /// </summary>
  5. [IgnoreTable]
  6. [SugarTable("CustMaster", "客户主数据")]
  7. public class CustMaster
  8. {
  9. /// <summary>自增列</summary>
  10. [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
  11. public int RecID { get; set; }
  12. /// <summary>客户编号</summary>
  13. [SugarColumn(ColumnName = "Cust", Length = 8, IsNullable = true)]
  14. public string? Cust { get; set; }
  15. /// <summary>简称</summary>
  16. [SugarColumn(ColumnName = "SortName", Length = 30, IsNullable = true)]
  17. public string? SortName { get; set; }
  18. /// <summary>域名</summary>
  19. [SugarColumn(ColumnName = "Domain", Length = 8, IsNullable = true)]
  20. public string? Domain { get; set; }
  21. /// <summary>地点</summary>
  22. [SugarColumn(ColumnName = "Site", Length = 8, IsNullable = true)]
  23. public string? Site { get; set; }
  24. /// <summary>等级</summary>
  25. [SugarColumn(ColumnName = "Class", Length = 2, IsNullable = true)]
  26. public string? Class { get; set; }
  27. /// <summary>货币</summary>
  28. [SugarColumn(ColumnName = "Curr", Length = 4, IsNullable = true)]
  29. public string? Curr { get; set; }
  30. /// <summary>类别</summary>
  31. [SugarColumn(ColumnName = "Terms", Length = 8, IsNullable = true)]
  32. public string? Terms { get; set; }
  33. /// <summary>信用限额</summary>
  34. [SugarColumn(ColumnName = "CreditLimit", IsNullable = true)]
  35. public decimal? CreditLimit { get; set; }
  36. /// <summary>信用冻结</summary>
  37. [SugarColumn(ColumnName = "CreditHold", IsNullable = true)]
  38. public int? CreditHold { get; set; }
  39. /// <summary>区域</summary>
  40. [SugarColumn(ColumnName = "Region", Length = 8, IsNullable = true)]
  41. public string? Region { get; set; }
  42. /// <summary>发至</summary>
  43. [SugarColumn(ColumnName = "ShipTo", Length = 8, IsNullable = true)]
  44. public string? ShipTo { get; set; }
  45. /// <summary>运输方式</summary>
  46. [SugarColumn(ColumnName = "ShipVia", Length = 6, IsNullable = true)]
  47. public string? ShipVia { get; set; }
  48. /// <summary>语言</summary>
  49. [SugarColumn(ColumnName = "Language", Length = 4, IsNullable = true)]
  50. public string? Language { get; set; }
  51. /// <summary>销售员1</summary>
  52. [SugarColumn(ColumnName = "Salesperson1", Length = 8, IsNullable = true)]
  53. public string? Salesperson1 { get; set; }
  54. /// <summary>应交税</summary>
  55. [SugarColumn(ColumnName = "Taxable", IsNullable = true)]
  56. public int? Taxable { get; set; }
  57. /// <summary>税类型</summary>
  58. [SugarColumn(ColumnName = "TaxClass", Length = 8, IsNullable = true)]
  59. public string? TaxClass { get; set; }
  60. /// <summary>变更日期</summary>
  61. [SugarColumn(ColumnName = "ModDate", IsNullable = true)]
  62. public DateTime? ModDate { get; set; }
  63. /// <summary>创建时间</summary>
  64. [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
  65. public DateTime? CreateTime { get; set; }
  66. /// <summary>更新时间</summary>
  67. [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
  68. public DateTime? UpdateTime { get; set; }
  69. /// <summary>有效</summary>
  70. [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
  71. public int? IsActive { get; set; }
  72. /// <summary>备注</summary>
  73. [SugarColumn(ColumnName = "Remark", Length = 255, IsNullable = true)]
  74. public string? Remark { get; set; }
  75. /// <summary>税ID</summary>
  76. [SugarColumn(ColumnName = "TaxID", Length = 30, IsNullable = true)]
  77. public string? TaxID { get; set; }
  78. /// <summary>银行帐户</summary>
  79. [SugarColumn(ColumnName = "BankAcct", Length = 30, IsNullable = true)]
  80. public string? BankAcct { get; set; }
  81. }