using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 采购订单表
|
/// </summary>
|
[SugarTable("MES_ROH_IN")]
|
public class MesRohIn
|
{
|
/// <summary>
|
/// SEQ_BASEINFO_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BASEINFO_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { 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(IsIgnore = true)]
|
public string? SupplierContact { get; set; }
|
|
/// <summary>
|
/// 联系人电话
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? ContactPhone { get; set; }
|
|
/// <summary>
|
/// 职务
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? Position { get; set; }
|
|
/// <summary>
|
/// 联系电话
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? OfficePhone { get; set; }
|
|
/// <summary>
|
/// 供货方地址
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? SupplierAddress { 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>
|
/// ERP审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_CHECK_BY")]
|
public string? ErpCheckBy { get; set; }
|
|
/// <summary>
|
/// ERP审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_CHECK_DATE")]
|
public string? ErpCheckDate { get; set; }
|
|
/// <summary>
|
/// ERP的ID号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public decimal? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public string? CheckDate { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_BY")]
|
public string? CheckBy { get; set; }
|
|
/// <summary>
|
/// 审核标识
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_FALG")]
|
public short? CheckFalg { get; set; }
|
|
/// <summary>
|
/// 自定义字段1
|
/// </summary>
|
[SugarColumn(ColumnName = "changereason")]
|
public string? Changereason { get; set; }
|
|
/// <summary>
|
/// 自定义字段1
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK1")]
|
public decimal? 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; }
|
|
|
}
|
