using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     来源出货计划的标准出货明细表
/// </summary>
[SugarTable("SHIPMENT_PLAN_DELIVERY_DETAIL")]
public class ShipmentPlanDeliveryDetail
{
    /// <summary>
    ///     主键ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_SHIPMENT_PLAN_DELIVERY_D", IsPrimaryKey = true)]
    public decimal? Id { get; set; }

    /// <summary>
    ///     主表ID
    /// </summary>
    [SugarColumn(ColumnName = "HEAD_ID")]
    public decimal? HeadId { get; set; }

    /// <summary>
    ///     行号
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string? LineNo { get; set; }

    /// <summary>
    ///     小步项目
    /// </summary>
    [SugarColumn(ColumnName = "PROJECT")]
    public string? Project { get; set; }

    /// <summary>
    ///     客户料号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NO")]
    public string? CustomerItemNo { get; set; }

    /// <summary>
    ///     客户品名
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NAME")]
    public string? CustomerItemName { get; set; }

    /// <summary>
    ///     料号
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_ID")]
    public string? MaterialId { get; set; }

    /// <summary>
    ///     品名
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_NAME")]
    public string? MaterialName { get; set; }

    /// <summary>
    ///     规格
    /// </summary>
    [SugarColumn(ColumnName = "SPECIFICATION")]
    public string? Specification { get; set; }

    /// <summary>
    ///     存储地点
    /// </summary>
    [SugarColumn(ColumnName = "STORAGE_LOCATION")]
    public string? StorageLocation { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }

    /// <summary>
    ///     数量
    /// </summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

    /// <summary>
    ///     免费品类型
    /// </summary>
    [SugarColumn(ColumnName = "FREE_ITEM_TYPE")]
    public string? FreeItemType { get; set; }

    /// <summary>
    ///     交期
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public string? DeliveryDate { get; set; }

    /// <summary>
    ///     表体备注
    /// </summary>
    [SugarColumn(ColumnName = "BODY_NOTE")]
    public string? BodyNote { get; set; }

    /// <summary>
    ///     ASN行号
    /// </summary>
    [SugarColumn(ColumnName = "ASN_LINE_NO")]
    public string? AsnLineNo { get; set; }

    /// <summary>
    ///     库存可用量
    /// </summary>
    [SugarColumn(ColumnName = "AVAILABLE_STOCK")]
    public decimal? AvailableStock { get; set; }

    /// <summary>
    ///     查询库存时间
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_QUERY_TIME")]
    public string? InventoryQueryTime { get; set; }

    /// <summary>
    ///     行状态
    /// </summary>
    [SugarColumn(ColumnName = "LINE_STATUS")]
    public string? LineStatus { get; set; }

    /// <summary>
    ///     收货位置
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_LOCATION")]
    public string? ReceiverLocation { get; set; }

    /// <summary>
    ///     收货地址
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_ADDRESS")]
    public string? ReceiverAddress { get; set; }

    /// <summary>
    ///     收货地址全称
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_ADDRESS_FULL")]
    public string? ReceiverAddressFull { get; set; }

    /// <summary>
    ///     收货联系人
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER_CONTACT")]
    public string? ReceiverContact { get; set; }

    /// <summary>
    ///     可退换
    /// </summary>
    [SugarColumn(ColumnName = "RETURNABLE")]
    public string? Returnable { get; set; }

    /// <summary>
    ///     可用日期
    /// </summary>
    [SugarColumn(ColumnName = "AVAILABLE_DATE")]
    public string? AvailableDate { get; set; }

    /// <summary>
    ///     承诺日期
    /// </summary>
    [SugarColumn(ColumnName = "COMMITMENT_DATE")]
    public string? CommitmentDate { get; set; }

    /// <summary>
    ///     计划出货日
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_SHIP_DATE")]
    public string? PlanShipDate { get; set; }

    /// <summary>
    ///     客户确认出货日
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_CONFIRM_DATE")]
    public string? CustomerConfirmDate { get; set; }

    /// <summary>
    ///     计划组织
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_ORG")]
    public string? PlanOrg { get; set; }

    /// <summary>
    ///     供应商直运
    /// </summary>
    [SugarColumn(ColumnName = "VENDOR_DIRECT_SHIP")]
    public string? VendorDirectShip { get; set; }

    /// <summary>
    ///     供应来源
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_SOURCE")]
    public string? SupplySource { get; set; }

    /// <summary>
    ///     供应类型
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_TYPE")]
    public string? SupplyType { get; set; }

    /// <summary>
    ///     供应组织
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_ORG")]
    public string? SupplyOrg { get; set; }

    /// <summary>
    ///     供应商
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER")]
    public string? Supplier { get; set; }

    /// <summary>
    ///     出货方式
    /// </summary>
    [SugarColumn(ColumnName = "DETAIL_SHIPPING_METHOD")]
    public string? DetailShippingMethod { get; set; }

    /// <summary>
    ///     货主组织
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_ORG")]
    public string? OwnerOrg { get; set; }

    /// <summary>
    ///     需求分类
    /// </summary>
    [SugarColumn(ColumnName = "DETAIL_DEMAND_CATEGORY")]
    public string? DetailDemandCategory { get; set; }

    /// <summary>
    ///     库存规划
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_PLANNING")]
    public string? InventoryPlanning { get; set; }

    /// <summary>
    ///     行备注
    /// </summary>
    [SugarColumn(ColumnName = "LINE_REMARK")]
    public string? LineRemark { get; set; }

    /// <summary>
    ///     来源单据类别
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOC_CATEGORY")]
    public string? SourceDocCategory { get; set; }

    /// <summary>
    ///     来源单号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOC_NO")]
    public string? SourceDocNo { get; set; }

    /// <summary>
    ///     来源单行号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_LINE_NO")]
    public string? SourceLineNo { get; set; }

    /// <summary>
    ///     ERP行ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_LINE_ID")]
    public string? ErpLineId { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_HEAD_ID")]
    public string? ErpHeadId { get; set; }
}