using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;

namespace MES.Service.Modes
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("DELIVERY_DETAIL")]
    public class DeliveryDetail
    {
        /// <summary>
        /// SEQ_DELIVERY_DETAIL 
        ///</summary>
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
        public decimal Id { get; set; }

        /// <summary>
        /// DELIVERY_MAIN的id 
        ///</summary>
        [SugarColumn(ColumnName = "PID")]
        public decimal? Pid { get; set; }

        /// <summary>
        /// 送货单号（主业务标识） 
        ///</summary>
        [SugarColumn(ColumnName = "ZZASN")]
        public string? Zzasn { get; set; }

        /// <summary>
        /// 送货单行号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZITEM_ID")]
        public string? ZzitemId { get; set; }

        /// <summary>
        /// 采购凭证号（PO单号） 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPO_NO")]
        public string? ZzpoNo { get; set; }

        /// <summary>
        /// 采购订单行项目 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPO_ITEM_ID")]
        public string? ZzpoItemId { get; set; }

        /// <summary>
        /// 小米退换货单号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZREQNR")]
        public string? Zzreqnr { get; set; }

        /// <summary>
        /// 退换货申请单行号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZREQLN")]
        public string? Zzreqln { get; set; }

        /// <summary>
        /// 小米内部物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPRODUCT_ID")]
        public string? ZzproductId { get; set; }

        /// <summary>
        /// 工厂实际使用料号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZVPRODUCT_ID")]
        public string? ZzvproductId { get; set; }

        /// <summary>
        /// 库存单位编码 
        ///</summary>
        [SugarColumn(ColumnName = "ZZSKU")]
        public string? Zzsku { get; set; }

        /// <summary>
        /// 物料描述（如：手机屏幕组件） 
        ///</summary>
        [SugarColumn(ColumnName = "MAKTX")]
        public string? Maktx { get; set; }

        /// <summary>
        /// 产品型号（示例：Xiaomi 14 Ultra） 
        ///</summary>
        [SugarColumn(ColumnName = "MODELNUMBER")]
        public string? Modelnumber { get; set; }

        /// <summary>
        /// 订单需求数量 
        ///</summary>
        [SugarColumn(ColumnName = "ZZQUANTITY")]
        public string? Zzquantity { get; set; }

        /// <summary>
        /// 计量单位（如：个/箱） 
        ///</summary>
        [SugarColumn(ColumnName = "ZZUNIT")]
        public string? Zzunit { get; set; }

        /// <summary>
        /// 未完成数量（待补货量） 
        ///</summary>
        [SugarColumn(ColumnName = "ZZOPEN_QTY")]
        public string? ZzopenQty { get; set; }

        /// <summary>
        /// 实际收货数量 
        ///</summary>
        [SugarColumn(ColumnName = "ACT_GR_QTY")]
        public string? ActGrQty { get; set; }

        /// <summary>
        /// Shipment批次数量 
        ///</summary>
        [SugarColumn(ColumnName = "SHIPMENTID_NUM")]
        public string? ShipmentidNum { get; set; }

        /// <summary>
        /// 品牌名称（如：Xiaomi） 
        ///</summary>
        [SugarColumn(ColumnName = "BRAND")]
        public string? Brand { get; set; }

        /// <summary>
        /// 生产地（示例：中国深圳） 
        ///</summary>
        [SugarColumn(ColumnName = "PLACE")]
        public string? Place { get; set; }

        /// <summary>
        /// 品牌类型（自有/ODM/OEM） 
        ///</summary>
        [SugarColumn(ColumnName = "BRAND_TYPE")]
        public string? BrandType { get; set; }

        /// <summary>
        /// 物流批次唯一标识 
        ///</summary>
        [SugarColumn(ColumnName = "ZSHIPMENT_ID")]
        public string? ZshipmentId { get; set; }

        /// <summary>
        /// 详细配送地址（省市区街道门牌号） 
        ///</summary>
        [SugarColumn(ColumnName = "ADDRESS_DETAIL")]
        public string? AddressDetail { get; set; }

        /// <summary>
        /// 调出项目号（调拨来源标识） 
        ///</summary>
        [SugarColumn(ColumnName = "BEDNR")]
        public string? Bednr { get; set; }

        /// <summary>
        /// 调出仓类型（成品仓/原料仓） 
        ///</summary>
        [SugarColumn(ColumnName = "WARE_TYPE_FROM")]
        public string? WareTypeFrom { get; set; }

        /// <summary>
        /// 调入仓类型 
        ///</summary>
        [SugarColumn(ColumnName = "WARE_TYPE_TO")]
        public string? WareTypeTo { get; set; }

        /// <summary>
        /// 物控调拨单号 
        ///</summary>
        [SugarColumn(ColumnName = "XMSTO_NO")]
        public string? XmstoNo { get; set; }

        /// <summary>
        /// 调拨单行项 
        ///</summary>
        [SugarColumn(ColumnName = "XMSTO_ITEM_NO")]
        public string? XmstoItemNo { get; set; }

        /// <summary>
        /// 最后修改时间（格式：yyyyMMddHHmmss） 
        ///</summary>
        [SugarColumn(ColumnName = "CHANGED_AT")]
        public string? ChangedAt { get; set; }

        /// <summary>
        /// 数据创建时间（格式：yyyyMMddHHmmss） 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_AT")]
        public string? CreatedAt { get; set; }

        /// <summary>
        /// 关联项目机型（多值逗号分隔） 
        ///</summary>
        [SugarColumn(ColumnName = "APP_MODELS")]
        public string? AppModels { get; set; }

        /// <summary>
        /// 外部系统凭证号（如ERP单号） 
        ///</summary>
        [SugarColumn(ColumnName = "EXT_DOC_NO")]
        public string? ExtDocNo { get; set; }

        /// <summary>
        /// 外部凭证行项目 
        ///</summary>
        [SugarColumn(ColumnName = "EXT_DOC_ITEM")]
        public string? ExtDocItem { get; set; }

        /// <summary>
        /// 海关HS编码（进出口报关用） 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_ID")]
        public string? BatchId { get; set; }

        /// <summary>
        /// 优先采购标识（紧急备料标记） 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_ROW")]
        public string? BatchRow { get; set; }

        /// <summary>
        /// 串号管理标识（Y/N，控制序列号采集） 
        ///</summary>
        [SugarColumn(ColumnName = "IS_IDENTIFICATION")]
        public string? IsIdentification { get; set; }
    }
}