PurOrdMaster.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356
  1. namespace Admin.NET.Plugin.AiDOP.Supply;
  2. /// <summary>
  3. /// 采购订单主表(PurOrdMaster)
  4. /// </summary>
  5. [SugarTable("PurOrdMaster", "采购订单主表")]
  6. public class PurOrdMaster
  7. {
  8. [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
  9. public int RecID { get; set; }
  10. [SugarColumn(ColumnName = "OwnerApplication", Length = 12, IsNullable = true)]
  11. public string? OwnerApplication { get; set; }
  12. [SugarColumn(ColumnName = "APAcct", Length = 16, IsNullable = true)]
  13. public string? APAcct { get; set; }
  14. [SugarColumn(ColumnName = "CostCtr", Length = 4, IsNullable = true)]
  15. public string? CostCtr { get; set; }
  16. [SugarColumn(ColumnName = "APSubAcct", Length = 8, IsNullable = true)]
  17. public string? APSubAcct { get; set; }
  18. [SugarColumn(ColumnName = "Bank", Length = 2, IsNullable = true)]
  19. public string? Bank { get; set; }
  20. [SugarColumn(ColumnName = "BillTo", Length = 10, IsNullable = true)]
  21. public string? BillTo { get; set; }
  22. [SugarColumn(ColumnName = "BlanketOrd", Length = 24, IsNullable = true)]
  23. public string? BlanketOrd { get; set; }
  24. [SugarColumn(ColumnName = "Buyer", Length = 30, IsNullable = true)]
  25. public string? Buyer { get; set; }
  26. [SugarColumn(ColumnName = "CloseDate", IsNullable = true)]
  27. public DateTime? CloseDate { get; set; }
  28. [SugarColumn(ColumnName = "CommentIndex")]
  29. public int CommentIndex { get; set; }
  30. [SugarColumn(ColumnName = "Confirming", ColumnDataType = "bit(1)")]
  31. public bool Confirming { get; set; }
  32. [SugarColumn(ColumnName = "Consignment")]
  33. public short Consignment { get; set; }
  34. [SugarColumn(ColumnName = "Contact", Length = 24, IsNullable = true)]
  35. public string? Contact { get; set; }
  36. [SugarColumn(ColumnName = "Contract", Length = 24, IsNullable = true)]
  37. public string? Contract { get; set; }
  38. [SugarColumn(ColumnName = "CreditTermsInt", ColumnDataType = "decimal(9,5)")]
  39. public decimal CreditTermsInt { get; set; }
  40. [SugarColumn(ColumnName = "CreditTerms", Length = 8, IsNullable = true)]
  41. public string? CreditTerms { get; set; }
  42. [SugarColumn(ColumnName = "Curr", Length = 3, IsNullable = true)]
  43. public string? Curr { get; set; }
  44. [SugarColumn(ColumnName = "CycleCode", Length = 2, IsNullable = true)]
  45. public string? CycleCode { get; set; }
  46. [SugarColumn(ColumnName = "DeliverTo", Length = 4, IsNullable = true)]
  47. public string? DeliverTo { get; set; }
  48. [SugarColumn(ColumnName = "Disc", ColumnDataType = "decimal(7,5)")]
  49. public decimal Disc { get; set; }
  50. [SugarColumn(ColumnName = "Domain", Length = 24, IsNullable = true)]
  51. public string? Domain { get; set; }
  52. [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
  53. public DateTime? DueDate { get; set; }
  54. [SugarColumn(ColumnName = "DutyType", Length = 1, IsNullable = true)]
  55. public string? DutyType { get; set; }
  56. [SugarColumn(ColumnName = "BlanketStart", IsNullable = true)]
  57. public DateTime? BlanketStart { get; set; }
  58. [SugarColumn(ColumnName = "BlanketEnd", IsNullable = true)]
  59. public DateTime? BlanketEnd { get; set; }
  60. [SugarColumn(ColumnName = "ExchRate", ColumnDataType = "decimal(10,5)")]
  61. public decimal ExchRate { get; set; }
  62. [SugarColumn(ColumnName = "ERSOption", Length = 2, IsNullable = true)]
  63. public string? ERSOption { get; set; }
  64. [SugarColumn(ColumnName = "EstVal", ColumnDataType = "decimal(13,5)")]
  65. public decimal EstVal { get; set; }
  66. [SugarColumn(ColumnName = "Sequence")]
  67. public int Sequence { get; set; }
  68. [SugarColumn(ColumnName = "ExchRate1", ColumnDataType = "decimal(15,5)")]
  69. public decimal ExchRate1 { get; set; }
  70. [SugarColumn(ColumnName = "ExchRate2", ColumnDataType = "decimal(15,5)")]
  71. public decimal ExchRate2 { get; set; }
  72. [SugarColumn(ColumnName = "RateType", Length = 8, IsNullable = true)]
  73. public string? RateType { get; set; }
  74. [SugarColumn(ColumnName = "FixedPrice", ColumnDataType = "bit(1)")]
  75. public bool FixedPrice { get; set; }
  76. [SugarColumn(ColumnName = "FixedRate", ColumnDataType = "bit(1)")]
  77. public bool FixedRate { get; set; }
  78. [SugarColumn(ColumnName = "FOB", Length = 20, IsNullable = true)]
  79. public string? FOB { get; set; }
  80. [SugarColumn(ColumnName = "Frt", ColumnDataType = "decimal(6,5)")]
  81. public decimal Frt { get; set; }
  82. [SugarColumn(ColumnName = "FSMType", Length = 8, IsNullable = true)]
  83. public string? FSMType { get; set; }
  84. [SugarColumn(ColumnName = "FSTID", Length = 24, IsNullable = true)]
  85. public string? FSTID { get; set; }
  86. [SugarColumn(ColumnName = "InvoicesVia", Length = 8, IsNullable = true)]
  87. public string? InvoicesVia { get; set; }
  88. [SugarColumn(ColumnName = "EMTPO")]
  89. public short EMTPO { get; set; }
  90. [SugarColumn(ColumnName = "Language", Length = 2, IsNullable = true)]
  91. public string? Language { get; set; }
  92. [SugarColumn(ColumnName = "MaxAgingDays")]
  93. public int MaxAgingDays { get; set; }
  94. [SugarColumn(ColumnName = "PurOrd", Length = 48, IsNullable = true)]
  95. public string? PurOrd { get; set; }
  96. [SugarColumn(ColumnName = "OrdDate", IsNullable = true)]
  97. public DateTime? OrdDate { get; set; }
  98. [SugarColumn(ColumnName = "PartialOK", ColumnDataType = "bit(1)")]
  99. public bool PartialOK { get; set; }
  100. [SugarColumn(ColumnName = "AmtPrepaid", ColumnDataType = "decimal(15,5)")]
  101. public decimal AmtPrepaid { get; set; }
  102. [SugarColumn(ColumnName = "LastPriceDt", IsNullable = true)]
  103. public DateTime? LastPriceDt { get; set; }
  104. [SugarColumn(ColumnName = "PricingDate", IsNullable = true)]
  105. public DateTime? PricingDate { get; set; }
  106. [SugarColumn(ColumnName = "PrintPO", ColumnDataType = "bit(1)")]
  107. public bool PrintPO { get; set; }
  108. [SugarColumn(ColumnName = "Project", Length = 24, IsNullable = true)]
  109. public string? Project { get; set; }
  110. [SugarColumn(ColumnName = "DiscTbl", Length = 8, IsNullable = true)]
  111. public string? DiscTbl { get; set; }
  112. [SugarColumn(ColumnName = "PriceTbl", Length = 20, IsNullable = true)]
  113. public string? PriceTbl { get; set; }
  114. [SugarColumn(ColumnName = "ERSPriceListOption")]
  115. public int ERSPriceListOption { get; set; }
  116. [SugarColumn(ColumnName = "PST", ColumnDataType = "bit(1)")]
  117. public bool PST { get; set; }
  118. [SugarColumn(ColumnName = "PSTID", Length = 24, IsNullable = true)]
  119. public string? PSTID { get; set; }
  120. [SugarColumn(ColumnName = "Recurr", ColumnDataType = "bit(1)")]
  121. public bool Recurr { get; set; }
  122. [SugarColumn(ColumnName = "Release", ColumnDataType = "bit(1)")]
  123. public bool ReleaseFlag { get; set; }
  124. [SugarColumn(ColumnName = "Rel")]
  125. public int Rel { get; set; }
  126. [SugarColumn(ColumnName = "ReqBy", Length = 8, IsNullable = true)]
  127. public string? ReqBy { get; set; }
  128. [SugarColumn(ColumnName = "Revision", ColumnDataType = "decimal(8,5)")]
  129. public decimal Revision { get; set; }
  130. [SugarColumn(ColumnName = "Remark", Length = 200, IsNullable = true)]
  131. public string? Remark { get; set; }
  132. [SugarColumn(ColumnName = "Scheduled", ColumnDataType = "bit(1)")]
  133. public bool Scheduled { get; set; }
  134. [SugarColumn(ColumnName = "SchedulesVia", Length = 1, IsNullable = true)]
  135. public string? SchedulesVia { get; set; }
  136. [SugarColumn(ColumnName = "ServiceCharge", ColumnDataType = "decimal(6,5)")]
  137. public decimal ServiceCharge { get; set; }
  138. [SugarColumn(ColumnName = "ShipTo", Length = 20, IsNullable = true)]
  139. public string? ShipTo { get; set; }
  140. [SugarColumn(ColumnName = "ShipVia", Length = 20, IsNullable = true)]
  141. public string? ShipVia { get; set; }
  142. [SugarColumn(ColumnName = "Site", Length = 24, IsNullable = true)]
  143. public string? Site { get; set; }
  144. [SugarColumn(ColumnName = "SecondarySOCrHold")]
  145. public short SecondarySOCrHold { get; set; }
  146. [SugarColumn(ColumnName = "PrimarySO", Length = 8, IsNullable = true)]
  147. public string? PrimarySO { get; set; }
  148. [SugarColumn(ColumnName = "SpecialCharge", ColumnDataType = "decimal(6,5)")]
  149. public decimal SpecialCharge { get; set; }
  150. [SugarColumn(ColumnName = "Status", Length = 2, IsNullable = true)]
  151. public string? Status { get; set; }
  152. [SugarColumn(ColumnName = "Taxable", ColumnDataType = "bit(1)")]
  153. public bool Taxable { get; set; }
  154. [SugarColumn(ColumnName = "TaxClass", Length = 20, IsNullable = true)]
  155. public string? TaxClass { get; set; }
  156. [SugarColumn(ColumnName = "TaxDate", IsNullable = true)]
  157. public DateTime? TaxDate { get; set; }
  158. [SugarColumn(ColumnName = "TaxEnvironment", Length = 16, IsNullable = true)]
  159. public string? TaxEnvironment { get; set; }
  160. [SugarColumn(ColumnName = "Tax1", ColumnDataType = "decimal(7,5)")]
  161. public decimal Tax1 { get; set; }
  162. [SugarColumn(ColumnName = "Tax2", ColumnDataType = "decimal(7,5)")]
  163. public decimal Tax2 { get; set; }
  164. [SugarColumn(ColumnName = "Tax3", ColumnDataType = "decimal(7,5)")]
  165. public decimal Tax3 { get; set; }
  166. [SugarColumn(ColumnName = "TaxUsage", Length = 8, IsNullable = true)]
  167. public string? TaxUsage { get; set; }
  168. [SugarColumn(ColumnName = "TermsofTrade", Length = 20, IsNullable = true)]
  169. public string? TermsofTrade { get; set; }
  170. [SugarColumn(ColumnName = "TransportDays", ColumnDataType = "decimal(8,5)")]
  171. public decimal TransportDays { get; set; }
  172. [SugarColumn(ColumnName = "Typed", Length = 18, IsNullable = true)]
  173. public string? Typed { get; set; }
  174. [SugarColumn(ColumnName = "Ufld1", Length = 24, IsNullable = true)]
  175. public string? Ufld1 { get; set; }
  176. [SugarColumn(ColumnName = "Ufld2", Length = 60, IsNullable = true)]
  177. public string? Ufld2 { get; set; }
  178. [SugarColumn(ColumnName = "EnteredBy", Length = 8, IsNullable = true)]
  179. public string? EnteredBy { get; set; }
  180. [SugarColumn(ColumnName = "Supp", Length = 20, IsNullable = true)]
  181. public string? Supp { get; set; }
  182. [SugarColumn(ColumnName = "Transm", Length = 1, IsNullable = true)]
  183. public string? Transm { get; set; }
  184. [SugarColumn(ColumnName = "BusinessID")]
  185. public long BusinessID { get; set; }
  186. [SugarColumn(ColumnName = "CreateUser", Length = 24, IsNullable = true)]
  187. public string? CreateUser { get; set; }
  188. [SugarColumn(ColumnName = "UpdateUser", Length = 24, IsNullable = true)]
  189. public string? UpdateUser { get; set; }
  190. [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
  191. public DateTime? CreateTime { get; set; }
  192. [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
  193. public DateTime? UpdateTime { get; set; }
  194. [SugarColumn(ColumnName = "EffTime", IsNullable = true)]
  195. public DateTime? EffTime { get; set; }
  196. [SugarColumn(ColumnName = "IsActive", ColumnDataType = "bit(1)")]
  197. public bool IsActive { get; set; }
  198. [SugarColumn(ColumnName = "IsConfirm", ColumnDataType = "bit(1)")]
  199. public bool IsConfirm { get; set; }
  200. [SugarColumn(ColumnName = "Potype", Length = 8)]
  201. public string Potype { get; set; } = string.Empty;
  202. [SugarColumn(ColumnName = "Department", Length = 8, IsNullable = true)]
  203. public string? Department { get; set; }
  204. [SugarColumn(ColumnName = "IsChanged", ColumnDataType = "bit(1)")]
  205. public bool IsChanged { get; set; }
  206. [SugarColumn(ColumnName = "TaxIn", ColumnDataType = "bit(1)")]
  207. public bool TaxIn { get; set; }
  208. [SugarColumn(ColumnName = "Amt", ColumnDataType = "decimal(15,5)")]
  209. public decimal Amt { get; set; }
  210. [SugarColumn(ColumnName = "Usage", Length = 30, IsNullable = true)]
  211. public string? Usage { get; set; }
  212. [SugarColumn(ColumnName = "CustAddress", Length = 200, IsNullable = true)]
  213. public string? CustAddress { get; set; }
  214. [SugarColumn(ColumnName = "CustContact", Length = 50, IsNullable = true)]
  215. public string? CustContact { get; set; }
  216. [SugarColumn(ColumnName = "CustPhone", Length = 30, IsNullable = true)]
  217. public string? CustPhone { get; set; }
  218. [SugarColumn(ColumnName = "SalesOrd", Length = 30, IsNullable = true)]
  219. public string? SalesOrd { get; set; }
  220. [SugarColumn(ColumnName = "CustPO", Length = 24, IsNullable = true)]
  221. public string? CustPO { get; set; }
  222. [SugarColumn(ColumnName = "IsPriceChanged", ColumnDataType = "bit(1)")]
  223. public bool IsPriceChanged { get; set; }
  224. [SugarColumn(ColumnName = "CustName", Length = 120, IsNullable = true)]
  225. public string? CustName { get; set; }
  226. [SugarColumn(ColumnName = "Rev")]
  227. public int Rev { get; set; }
  228. [SugarColumn(ColumnName = "RoleNo", Length = 20, IsNullable = true)]
  229. public string? RoleNo { get; set; }
  230. [SugarColumn(ColumnName = "InvoiceType", Length = 20, IsNullable = true)]
  231. public string? InvoiceType { get; set; }
  232. [SugarColumn(ColumnName = "PricingMethod", Length = 20, IsNullable = true)]
  233. public string? PricingMethod { get; set; }
  234. [SugarColumn(ColumnName = "ERPfld1", Length = 200, IsNullable = true)]
  235. public string? ERPfld1 { get; set; }
  236. [SugarColumn(ColumnName = "ERPWorkOrd", Length = 255, IsNullable = true)]
  237. public string? ERPWorkOrd { get; set; }
  238. [SugarColumn(ColumnName = "WorkOrd", Length = 255, IsNullable = true)]
  239. public string? WorkOrd { get; set; }
  240. }