| | |
| | | public class MesRohInData |
| | | { |
| | | /// <summary> |
| | | /// 默认值: (newid()) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] |
| | | public Guid Guid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 采购单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | |
| | | [SugarColumn(ColumnName = "ITEM_ID")] |
| | | public string? ItemId { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 采购单位 |
| | | /// </summary> |
| | |
| | | [SugarColumn(ColumnName = "INVENTORY_UNIT")] |
| | | public string? InventoryUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价单位 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICING_UNIT")] |
| | | public string? PricingUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICING_QTY")] |
| | | public decimal? PricingQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 交货日期 |
| | |
| | | public string? BatchNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 业务关闭 A:正常,B:业务终止 |
| | | /// 业务关闭 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BUSINESS_CLOSE")] |
| | | public string? BusinessClose { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 业务冻结 A:正常,B:业务终止 |
| | | /// 业务冻结 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BUSINESS_FREEZE")] |
| | | public string? BusinessFreeze { get; set; } |
| | |
| | | public decimal? EbelnK3id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// SEQ_BASEINFO_ID |
| | | /// 客户货号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BASEINFO_ID", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
| | | /// 包装单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 主产品 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK3")] |
| | | public string? Remark3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// SMT备注 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK4")] |
| | | public string? Remark4 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public decimal? ErpId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 采购订单行号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "purchase_order_line_number")] |
| | | [SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")] |
| | | public string? PurchaseOrderLineNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 需求组织 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEMAND")] |
| | | public string? Demand { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 收料组织 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVING")] |
| | | public string? Receiving { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 结算组织 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SETTLEMENT")] |
| | | public string? Settlement { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 需求部门 |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CGB014")] |
| | | public decimal? Cgb014 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEMAND_DEPARTMENT")] |
| | | public string? DemandDepartment { get; set; } |
| | |
| | | public string? ReceivingDepartment { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 预计到货时间 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FPREARRIVALDATE")] |
| | | public DateTime? FPREARRIVALDATE { get; set; } |
| | | public DateTime? Fprearrivaldate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户货号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 包装单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 主产品 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK3")] |
| | | public string? Remark3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// SMT备注 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK4")] |
| | | public string? Remark4 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单行号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FDEMANDBILLNO_LINE")] |
| | | public string? FdemandbillnoLine { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 电气成品型号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ELECTRICAL_PRODUCT_MODEL")] |
| | | public string? ElectricalProductModel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 电气成品名称 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ELECTRICAL_PRODUCT_NAME")] |
| | | public string? ElectricalProductName { get; set; } |
| | | } |