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>
|
/// 取业务关闭字段 0==未关闭 1==业务关闭
|
/// </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 string? 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 short? CheckFalg { get; set; }
|
|
/// <summary>
|
/// 自定义字段1
|
/// </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 = "ARRIVE_DATE")]
|
public DateTime? ArriveDate { get; set; }
|
|
/// <summary>
|
/// 收料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVE_ORG")]
|
public string? ReceiveOrg { get; set; }
|
|
/// <summary>
|
/// 审批意见
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT")]
|
public string? FWwcText { get; set; }
|
|
/// <summary>
|
/// 来源类别,0=手工 1=请购单 3=需求接口表 4=采购合同 6=采购订单 7=销售订单
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_DOC_TYPE")]
|
public string? SrcDocType { get; set; }
|
|
/// <summary>
|
/// 来源单据
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_DOC")]
|
public string? SrcDoc { get; set; }
|
|
/// <summary>
|
/// 贸易路径
|
/// </summary>
|
[SugarColumn(ColumnName = "TRADE_PATH_NAME")]
|
public string? TradePathName { get; set; }
|
|
/// <summary>
|
/// 委外类型字段暂未使用，默认值-1
|
/// </summary>
|
[SugarColumn(ColumnName = "SUB_TYPE")]
|
public string? SubType { get; set; }
|
|
/// <summary>
|
/// 返工订单 是否勾选项 0==不勾选 1==勾选，默认不勾选
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_RE_DO")]
|
public short? IsReDo { get; set; }
|
|
/// <summary>
|
/// 项目采购负责人
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG1")]
|
public string? PrivateDescSeg1 { get; set; }
|
|
/// <summary>
|
/// 单据版本
|
/// </summary>
|
[SugarColumn(ColumnName = "VERSION")]
|
public string? Version { get; set; }
|
}
|
