采购入库单接口

啊鑫

2024-10-23 381ae1e53941691f97ad1484c37a9bf51a85e622

 MES.Service/Modes/MesRohInData.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,384 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     é‡‡è´­è®¢å•æ˜Žç»†è¡¨
/// </summary>
[SugarTable("MES_ROH_IN_DATA")]
public class MesRohInData
{
    /// <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 = "SALES_ORDER_ID")]
    public string? SalesOrderId { get; set; }

    /// <summary>
    ///     é‡‡è´­è®¢å•è¡Œå·
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_LINE_ID")]
    public string? OrderLineId { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public string? ItemId { get; set; }

    /// <summary>
    ///     é‡‡è´­å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_UNIT")]
    public string? PurchaseUnit { get; set; }

    /// <summary>
    ///     é‡‡è´­æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_QTY")]
    public decimal? PurchaseQty { 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>
    ///     äº¤è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public DateTime? DeliveryDate { get; set; }

    /// <summary>
    ///     æœ€æ—©äº¤è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
    public DateTime? EarliestDeliveryDate { get; set; }

    /// <summary>
    ///     æœ€æ™šäº¤è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
    public DateTime? LatestDeliveryDate { get; set; }

    /// <summary>
    ///     éœ€æ±‚组织
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_ORG")]
    public string? DemandOrg { get; set; }

    /// <summary>
    ///     æ”¶æ–™ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_ORG")]
    public string? ReceivingOrg { get; set; }

    /// <summary>
    ///     ç»“算组织
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT_ORG")]
    public string? SettlementOrg { get; set; }

    /// <summary>
    ///     æ˜¯å¦èµ å“
    /// </summary>
    [SugarColumn(ColumnName = "IS_GIFT")]
    public string? IsGift { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string? Remarks { get; set; }

    /// <summary>
    ///     ä¾›åº”商物料编码
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
    public string? SupplierItemCode { get; set; }

    /// <summary>
    ///     ä¾›åº”商物料名称
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
    public string? SupplierItemName { get; set; }

    /// <summary>
    ///     å§”外订单号
    /// </summary>
    [SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
    public string? OutsourcingOrderId { get; set; }

    /// <summary>
    ///     æ‰¹æ¬¡å·
    /// </summary>
    [SugarColumn(ColumnName = "BATCH_NUMBER")]
    public string? BatchNumber { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡å…³é—­æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_CLOSE")]
    public string? BusinessClose { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡å†»ç»“标识
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_FREEZE")]
    public string? BusinessFreeze { get; set; }

    /// <summary>
    ///     å†»ç»“人
    /// </summary>
    [SugarColumn(ColumnName = "FREEZER")]
    public string? Freezer { get; set; }

    /// <summary>
    ///     å†»ç»“时间
    /// </summary>
    [SugarColumn(ColumnName = "FREEZE_TIME")]
    public DateTime? FreezeTime { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡ç»ˆæ­¢æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
    public string? BusinessTerminate { get; set; }

    /// <summary>
    ///     ç»ˆæ­¢äºº
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATOR")]
    public string? Terminator { get; set; }

    /// <summary>
    ///     ç»ˆæ­¢æ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATE_TIME")]
    public DateTime? TerminateTime { get; set; }

    /// <summary>
    ///     æ€»å·²æ”¶æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
    public decimal? TotalReceivedQty { get; set; }

    /// <summary>
    ///     å‰©ä½™æ”¶è´§æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
    public decimal? RemainingReceivedQty { get; set; }

    /// <summary>
    ///     æ€»å·²å…¥åº“数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
    public decimal? TotalStoredQty { get; set; }

    /// <summary>
    ///     å‰©ä½™å…¥åº“数量
    /// </summary>
    [SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
    public decimal? RemainingStoredQty { get; set; }

    /// <summary>
    ///     æ€»é€€è´§æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
    public decimal? TotalReturnedQty { get; set; }

    /// <summary>
    ///     å¯é€€æ”¶è´§æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
    public decimal? ReturnableReceivedQty { get; set; }

    /// <summary>
    ///     å¯é€€å…¥åº“数量
    /// </summary>
    [SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
    public decimal? ReturnableStoredQty { get; set; }

    /// <summary>
    ///     æ¥æºå•æ®ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
    public string? SourceDocumentType { get; set; }

    /// <summary>
    ///     æ¥æºå•æ®å·
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
    public string? SourceDocumentId { get; set; }

    /// <summary>
    ///     éœ€æ±‚跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
    public string? DemandTrackingId { get; set; }

    /// <summary>
    ///     è®¡åˆ’跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
    public string? PlanTrackingId { get; set; }

    /// <summary>
    ///     å˜æ›´æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "CHANGE_FLAG")]
    public string? ChangeFlag { get; set; }

    /// <summary>
    ///     éœ€æ±‚来源
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_SOURCE")]
    public string? DemandSource { get; set; }

    /// <summary>
    ///     éœ€æ±‚单据号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
    public string? DemandDocumentId { get; set; }

    /// <summary>
    ///     éœ€æ±‚单据行号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
    public string? DemandDocumentLineId { get; set; }

    /// <summary>
    ///     é‡‡è´­è®¢å•è¡Œå·ï¼ˆK3系统）
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public decimal? EbelnK3id { 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>
    ///     ä¸»é”®ID
    /// </summary>
    [SugarColumn(ColumnName = "ID")]
    public int Id { get; set; }

    /// <summary>
    ///     ERP系统中的ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public decimal? ErpId { get; set; }

    /// <summary>
    ///     é‡‡è´­è®¢å•è¡Œå·
    /// </summary>
    [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>
    ///     é¢„留字段CGB014
    ///     é»˜è®¤å€¼: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "CGB014")]
    public decimal? Cgb014 { 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 = "DEMAND_DEPARTMENT")]
    public string? DemandDepartment { get; set; }

    /// <summary>
    ///     æ”¶æ–™éƒ¨é—¨
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
    public string? ReceivingDepartment { get; set; }
    
    /// <summary>
    ///     é¢„计到货时间
    /// </summary>
    [SugarColumn(ColumnName = "prearrivaldate")]
    public DateTime? prearrivaldate { get; set; }
}