BookingHeChuan/Myshipping.Application/Entity/BookingSlotChange/BookingSlotChangeRecord.cs

using System;
using System.Collections.Generic;
using SqlSugar;
using Myshipping.Core.Entity;
using System.ComponentModel;

namespace Myshipping.Application
{
    /// <summary>
    /// 舱位差异记录表
    /// </summary>
    [SugarTable("booking_slot_change_record", TableDescription = "舱位差异记录表")]
    public class BookingSlotChangeRecord : DBEntityTenant
    {
        /// <summary>
        /// 舱位主键
        /// </summary>
        [SugarColumn(ColumnName = "SLOT_ID")]
        [Description("舱位主键")]
        public Nullable<long> SLOT_ID { get; set; }

        /// <summary>
        /// 订单主键
        /// </summary>
        [SugarColumn(ColumnName = "BOOKING_ID")]
        [Description("订单主键")]
        public Nullable<long> BOOKING_ID { get; set; }

        /// <summary>
        /// 变更类型标记 BEFORE-变更前，CURRENT-变更后
        /// </summary>
        [SugarColumn(ColumnName = "CHANGE_FLAG")]
        [Description("变更类型标记")]
        public string CHANGE_FLAG { get; set; }

        /// <summary>
        /// 变更范围类型 SINGLE-单票变更,ALLSHIP-整船变更（例如截止时间变更）
        /// </summary>
        [SugarColumn(ColumnName = "CHANGE_RANGE")]
        [Description("变更类型标记")]
        public string CHANGE_RANGE { get; set; }

        /// <summary>
        /// 主提单号
        /// </summary>
        [SugarColumn(ColumnName = "MBL_NO")]
        [Description("主提单号")]
        public string MBL_NO { get; set; }

        /// <summary>
        /// 真提单号
        /// </summary>
        [SugarColumn(ColumnName = "REAL_MBL_NO")]
        [Description("真提单号")]
        public string REAL_MBL_NO { get; set; }

        /// <summary>
        /// 合约号
        /// </summary>
        [SugarColumn(ColumnName = "CONTRACT_NO")]
        [Description("合约号")]
        public string CONTRACT_NO { get; set; }

        /// <summary>
        /// 订舱抬头
        /// </summary>
        [SugarColumn(ColumnName = "BOOKING_PARTY")]
        [Description("订舱抬头")]
        public string BOOKING_PARTY { get; set; }

        /// <summary>
        /// 船名
        /// </summary>
        [SugarColumn(ColumnName = "VESSEL")]
        [Description("船名")]
        public string VESSEL { get; set; }

        /// <summary>
        /// 航次号
        /// </summary>
        [SugarColumn(ColumnName = "VOYNO")]
        [Description("航次号")]
        public string VOYNO { get; set; }

        /// <summary>
        /// 预计开船日期
        /// </summary>
        [SugarColumn(ColumnName = "ETD")]
        [Description("预计开船日期")]
        public Nullable<DateTime> ETD { get; set; }

        /// <summary>
        /// 预计到港日期
        /// </summary>
        [SugarColumn(ColumnName = "ETA")]
        [Description("预计到港日期")]
        public Nullable<DateTime> ETA { get; set; }

        /// <summary>
        /// 收货地代码
        /// </summary>
        [SugarColumn(ColumnName = "PLACERECEIPTID")]
        [Description("收货地代码")]
        public string PLACERECEIPTID { get; set; }

        /// <summary>
        /// 收货地
        /// </summary>
        [SugarColumn(ColumnName = "PLACERECEIPT")]
        [Description("收货地")]
        public string PLACERECEIPT { get; set; }

        /// <summary>
        /// 交货地代码
        /// </summary>
        [SugarColumn(ColumnName = "PLACEDELIVERYID")]
        [Description("收货地代码")]
        public string PLACEDELIVERYID { get; set; }

        /// <summary>
        /// 交货地
        /// </summary>
        [SugarColumn(ColumnName = "PLACEDELIVERY")]
        [Description("交货地")]
        public string PLACEDELIVERY { get; set; }

        /// <summary>
        /// 装货港代码
        /// </summary>
        [SugarColumn(ColumnName = "PORTLOADID")]
        [Description("装货港代码")]
        public string PORTLOADID { get; set; }

        /// <summary>
        /// 装货港
        /// </summary>
        [SugarColumn(ColumnName = "PORTLOAD")]
        [Description("装货港")]
        public string PORTLOAD { get; set; }

        /// <summary>
        /// 卸货港代码
        /// </summary>
        [SugarColumn(ColumnName = "PORTDISCHARGEID")]
        [Description("卸货港代码")]
        public string PORTDISCHARGEID { get; set; }

        /// <summary>
        /// 卸货港
        /// </summary>
        [SugarColumn(ColumnName = "PORTDISCHARGE")]
        [Description("卸货港")]
        public string PORTDISCHARGE { get; set; }

        /// <summary>
        /// 船公司代号
        /// </summary>
        [SugarColumn(ColumnName = "CARRIERID")]
        [Description("船公司代号")]
        public string CARRIERID { get; set; }

        /// <summary>
        /// 船公司
        /// </summary>
        [SugarColumn(ColumnName = "CARRIER")]
        [Description("船公司")]
        public string CARRIER { get; set; }

        /// <summary>
        /// 承运方式 DIRECT_SHIP-直达；TRANSFER_SHIP-中转
        /// </summary>
        [SugarColumn(ColumnName = "CARRIAGE_TYPE")]
        [Description("承运方式")]
        public string CARRIAGE_TYPE { get; set; }

        /// <summary>
        /// 承运方式名称 DIRECT_SHIP-直达；TRANSFER_SHIP-中转
        /// </summary>
        [SugarColumn(ColumnName = "CARRIAGE_TYPE_NAME")]
        [Description("承运方式名称")]
        public string CARRIAGE_TYPE_NAME { get; set; }

        /// <summary>
        /// 订舱方式 CONTRACT_ORDER-合约订舱；SPOT_ORDER-SPOT订舱
        /// </summary>
        [SugarColumn(ColumnName = "BOOKING_SLOT_TYPE")]
        [Description("订舱方式")]
        public string BOOKING_SLOT_TYPE { get; set; }

        /// <summary>
        /// 订舱方式名称 CONTRACT_ORDER-合约订舱；SPOT_ORDER-SPOT订舱
        /// </summary>
        [SugarColumn(ColumnName = "BOOKING_SLOT_TYPE_NAME")]
        [Description("订舱方式名称")]
        public string BOOKING_SLOT_TYPE_NAME { get; set; }

        /// <summary>
        /// 箱型箱量
        /// </summary>
        [SugarColumn(ColumnName = "CTN_STAT")]
        [Description("箱型箱量")]
        public string CTN_STAT { get; set; }

        /// <summary>
        /// 所在周数
        /// </summary>
        [SugarColumn(ColumnName = "WEEK_AT")]
        [Description("所在周数")]
        public string WEEK_AT { get; set; }

        /// <summary>
        /// 箱使天数
        /// </summary>
        [SugarColumn(ColumnName = "DETENSION_FREE_DAYS")]
        [Description("箱使天数")]
        public Nullable<int> DETENSION_FREE_DAYS { get; set; }

        /// <summary>
        /// 样单截止日期
        /// </summary>
        [SugarColumn(ColumnName = "SI_CUT_DATE")]
        [Description("样单截止日期")]
        public Nullable<DateTime> SI_CUT_DATE { get; set; }

        /// <summary>
        /// 客户样单截止日期,经过日期提前后的日期
        /// </summary>
        [SugarColumn(ColumnName = "CUSTOM_SI_CUT_DATE")]
        [Description("客户样单截止日期")]
        public Nullable<DateTime> CUSTOM_SI_CUT_DATE { get; set; }

        /// <summary>
        /// 截港时间
        /// </summary>
        [SugarColumn(ColumnName = "CY_CUT_DATE")]
        [Description("截港时间")]
        public Nullable<DateTime> CY_CUT_DATE { get; set; }

        /// <summary>
        /// VGM截止日期
        /// </summary>
        [SugarColumn(ColumnName = "VGM_SUBMISSION_CUT_DATE")]
        [Description("VGM截止日期")]
        public Nullable<DateTime> VGM_SUBMISSION_CUT_DATE { get; set; }

        /// <summary>
        /// 是否已发送钉钉 1-已发，0-未发
        /// </summary>
        [SugarColumn(ColumnName = "IS_SEND_DINGDING")]
        [Description("是否已发送钉钉 1-已发，0-未发")]
        public bool IS_SEND_DINGDING { get; set; }

        /// <summary>
        /// 发送钉钉结果
        /// </summary>
        [SugarColumn(ColumnName = "SEND_DINGDING_RLT")]
        [Description("发送钉钉结果")]
        public string SEND_DINGDING_RLT { get; set; }

        /// <summary>
        /// 是否已发送邮件 1-已发送，0-未发送
        /// </summary>
        [SugarColumn(ColumnName = "IS_SEND_EMAIL")]
        [Description("是否已发送邮件 1-已发送，0-未发送")]
        public bool IS_SEND_EMAIL { get; set; }

        /// <summary>
        /// 发送邮件结果
        /// </summary>
        [SugarColumn(ColumnName = "SEND_EMAIL_RLT")]
        [Description("发送邮件结果")]
        public string SEND_EMAIL_RLT { get; set; }

        /// <summary>
        /// 发送批次
        /// </summary>
        [SugarColumn(ColumnName = "SEND_BATCH_NO")]
        [Description("发送批次")]
        public string SEND_BATCH_NO { get; set; }

        /// <summary>
        /// 任务主键
        /// </summary>
        [SugarColumn(ColumnName = "TASK_ID")]
        [Description("任务主键")]
        public string TASK_ID { get; set; }

        /// <summary>
        /// 发送时间
        /// </summary>
        [SugarColumn(ColumnName = "SEND_TIME")]
        [Description("发送时间")]
        public Nullable<DateTime> SEND_TIME { get; set; }
    }
}