using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 采购订单表
|
/// </summary>
|
[SugarTable("MES_ROH_IN")]
|
public class MesRohIn
|
{
|
/// <summary>
|
/// 主键
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 采购单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
|
public string DocumentStatus { get; set; }
|
|
/// <summary>
|
/// 单据类型
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_TYPE")]
|
public string DocumentType { get; set; }
|
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_TYPE")]
|
public string BusinessType { get; set; }
|
|
/// <summary>
|
/// 采购日期
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_DATE")]
|
public DateTime? PurchaseDate { get; set; }
|
|
/// <summary>
|
/// 供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIER")]
|
public string Supplier { get; set; }
|
|
/// <summary>
|
/// 关闭状态
|
/// </summary>
|
[SugarColumn(ColumnName = "CLOSE_STATUS")]
|
public string CloseStatus { get; set; }
|
|
/// <summary>
|
/// 采购组织
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_ORG")]
|
public string PurchaseOrg { get; set; }
|
|
/// <summary>
|
/// 采购部门
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_DEPT")]
|
public string PurchaseDept { get; set; }
|
|
/// <summary>
|
/// 采购组
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_GROUP")]
|
public string PurchaseGroup { get; set; }
|
|
/// <summary>
|
/// 数量验收
|
/// </summary>
|
[SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
|
public string QtyAcceptance { get; set; }
|
|
/// <summary>
|
/// 采购员
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASER")]
|
public string Purchaser { get; set; }
|
|
/// <summary>
|
/// 质量要求
|
/// </summary>
|
[SugarColumn(ColumnName = "QUALITY_REQ")]
|
public string QualityReq { get; set; }
|
|
/// <summary>
|
/// 结算方
|
/// </summary>
|
[SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
|
public string SettlementParty { get; set; }
|
|
/// <summary>
|
/// 收款方
|
/// </summary>
|
[SugarColumn(ColumnName = "PAYMENT_PARTY")]
|
public string PaymentParty { get; set; }
|
|
/// <summary>
|
/// 邮箱
|
/// </summary>
|
[SugarColumn(ColumnName = "EMAIL")]
|
public string Email { get; set; }
|
|
/// <summary>
|
/// 运输方式
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSPORT_METHOD")]
|
public string TransportMethod { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARKS")]
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// 治具丶模具加工及采购
|
/// </summary>
|
[SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
|
public string FixtureMoldProcurement { get; set; }
|
|
/// <summary>
|
/// 作废状态
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCELLATION_STATUS")]
|
public string CancellationStatus { get; set; }
|
|
/// <summary>
|
/// 作废人
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCELLATION_PERSON")]
|
public string CancellationPerson { get; set; }
|
|
/// <summary>
|
/// 作废日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCELLATION_DATE")]
|
public DateTime? CancellationDate { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 最后修改时间
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 最后修改人
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
|
public string LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_CHECK_BY")]
|
public string ErpCheckBy { get; set; }
|
|
/// <summary>
|
/// 审核时间
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_CHECK_DATE")]
|
public string ErpCheckDate { get; set; }
|
|
/// <summary>
|
/// ERP的ID号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public long? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_BY")]
|
public string CheckBy { get; set; }
|
|
/// <summary>
|
/// 审核标识
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_FALG")]
|
public int? CheckFalg { get; set; }
|
|
/// <summary>
|
/// 打印次数
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK1")]
|
public string Remark1 { get; set; }
|
|
/// <summary>
|
/// 自定义字段2
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK2")]
|
public string Remark2 { get; set; }
|
|
/// <summary>
|
/// 自定义字段3
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK3")]
|
public string Remark3 { get; set; }
|
|
/// <summary>
|
/// 自定义字段4
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK4")]
|
public string Remark4 { get; set; }
|
|
/// <summary>
|
/// 自定义字段5
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK5")]
|
public string Remark5 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "CHANGEREASON")]
|
public string Changereason { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "Prearrivaldate")]
|
public DateTime? Prearrivaldate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ReceiveOrgId")]
|
public string ReceiveOrgId { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "Provider_Id")]
|
public string ProviderId { get; set; }
|
|
/// <summary>
|
/// 联系人
|
/// </summary>
|
[SugarColumn(ColumnName = "anred")]
|
public string Anred { get; set; }
|
|
/// <summary>
|
/// 电话
|
/// </summary>
|
[SugarColumn(ColumnName = "telf1")]
|
public string Telf1 { get; set; }
|
|
/// <summary>
|
/// 固定电话
|
/// </summary>
|
[SugarColumn(ColumnName = "Fixed_Telephone")]
|
public string FixedTelephone { get; set; }
|
|
/// <summary>
|
/// 通讯地址
|
/// </summary>
|
[SugarColumn(ColumnName = "Address")]
|
public string Address { get; set; }
|
|
/// <summary>
|
/// 验收方式
|
/// </summary>
|
[SugarColumn(ColumnName = "Acctype")]
|
public string Acctype { get; set; }
|
}
|