using Core.Mes.Client.Comm.Attribute;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
namespace Core.StlMes.Client.YdmBcPipeManage.Entity
{
///
/// 数据库表CRM_SLM_ORDER所对应的实体类(生成工具:代码生成工具3.0)
/// 作者:LAPTOP-I2IGVKJC 时间:2021-06-04
///
public class CrmSlmOrderEntity
{
///
/// ORD_PK
///
private string ordPk = "";
///
/// ORD_LN_PK(ORD_PK+三位流失号)
///
private string ordLnPk = "";
///
/// ORD_LN_DLY_PK(ORD_LN_PK+三位流水号)
///
private string ordLnDlyPk = "";
///
/// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号
///
private string orderNo = "";
///
/// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性)
///
private string orderSeq = "";
///
/// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性)
///
private string deliveryNo = "";
///
/// 客户合同号
///
private string custmOrderNo = "";
///
/// 合同类型
///
private string orderTyp = "";
///
/// 合同类型描述
///
private string orderTypDesc = "";
///
/// 省市/区域代码
///
private string regionNo = "";
///
/// 省市/区域
///
private string regionName = "";
///
/// 销售组织(国内贸易部/国际贸易部)
///
private string saleOrg = "";
///
/// 销售组织描述
///
private string saleOrgDesc = "";
///
/// 销售区域编码
///
private string saleAreaNo = "";
///
/// 销售区域描述
///
private string saleAreaDesc = "";
///
/// 订货单位代码
///
private string customerNo = "";
///
/// 订货单位名称
///
private string customerNm = "";
///
/// 收货单位编码
///
private string receivNo = "";
///
/// 收货单位名称
///
private string receivNm = "";
///
/// 计价方式(1203)
///
private string priceFl = "";
///
/// 订货量
///
private decimal? orderQty = null;
///
/// 订货价(结算价)
///
private decimal? balncePrice = null;
///
/// 币种
///
private string currency = "";
///
/// 付款方式
///
private string mnyAskTyp = "";
///
/// 是否含税 0 否 1 是
///
private string containTax = "";
///
/// 订货计量单位(支、米、吨)
///
private string orderUnit = "";
///
/// 品名代码
///
private string produccode = "";
///
/// 品名描述
///
private string producname = "";
///
/// 标准代码
///
private string stdCode = "";
///
/// 标准名称
///
private string stdName = "";
///
/// 钢级(牌号)代码
///
private string steelcode = "";
///
/// 钢级(牌号)名称
///
private string steelname = "";
///
/// 标准类别代码
///
private string stdStyle = "";
///
/// 标准类别描述
///
private string stdStyleDesc = "";
///
/// 扣型代码
///
private string modelCode = "";
///
/// 扣型描述
///
private string modelDesc = "";
///
/// 订货规格代码(用于合同、质保书、标牌、标识)
///
private string orderSpecCode = "";
///
/// 订货规格描述(用于合同、质保书、标牌、标识)
///
private string orderSpecDesc = "";
///
/// 产品规格代码
///
private string specCode = "";
///
/// 产品规格描述
///
private string specName = "";
///
/// 外径(mm)
///
private decimal? dimater = null;
///
/// 壁厚(mm)
///
private decimal? height = null;
///
/// 长度编码
///
private string lenNo = "";
///
/// 长度描述
///
private string lenDesc = "";
///
/// 长度单位
///
private string lenUnit = "";
///
/// 外购坯(COM_BASE_INFO:1218)
///
private string outsBilletFl = "";
///
/// 外购管(COM_BASE_INFO:1219)
///
private string outsStlPipeFl = "";
///
/// 付款要求描述
///
private string mnyAskDesc = "";
///
/// 合同头锁定状态
///
private string islock = "";
///
/// 监制说明
///
private string prdcrDesc = "";
///
/// MPS说明
///
private string mpsDesc = "";
///
/// 结算单位编码
///
private string stlmtUnitNo = "";
///
/// 结算单位名称
///
private string stlmtUnitNm = "";
///
/// 交货量差方式(绝对值;百分比)
///
private string delvryRangeTpe = "";
///
/// 交货量差下限
///
private decimal? delvryRangeMin = null;
///
/// 交货量差上限
///
private decimal? delvryRangeMax = null;
///
/// 附加要求编码
///
private string addAskNo = "";
///
/// 订货附加要求描述
///
private string orderAddDesc = "";
///
/// 产品特殊要求描述
///
private string orderSpecialDesc = "";
///
/// 交货行状态
///
private string orderSts = "";
///
/// 交货行状态描述
///
private string orderStsDesc = "";
///
/// 制造商代码
///
private string supplyUnitCode = "";
///
/// 制造商
///
private string supplyUnit = "";
///
/// 重量估算
///
private decimal? wgtEstmt = null;
///
/// 交货结束日期
///
private string delvryEdate = "";
///
/// 生效时间
///
private string effectTime = "";
///
/// 提报时间
///
private string tibaoTime = "";
///
/// CRM是否同步(0 未同步 1已同步)
///
private string isFlag = "";
///
/// 数据类型(0 新增 1修改 2删除)
///
private string dataStatus = "";
///
/// CRM用于修改的字段
///
private string crmFlag = "";
///
/// CRM同步时间
///
private string synchroTime = "";
///
/// 主键
///
private string id = "";
///
/// 创建时间
///
private string createTime = "";
///
/// 合同行状态
///
private string orderLnSts = "";
///
/// 合同行状态描述
///
private string orderLnStsDesc = "";
///
/// 合同创建人
///
private string createName = "";
private string fstDraweeUnit = "";
private string keepType;
private string createTimestamp = "";
///
/// 合同头状态
///
private string orderHeadSts = "";
///
/// 合同头状态描述
///
private string orderHeadStsDesc = "";
private string materialNo;
private string materialDesc;
[Description("物料编码")]
public string MaterialNo
{
get { return materialNo; }
set { materialNo = value; }
}
[Description("物料名称")]
public string MaterialDesc
{
get { return materialDesc; }
set { materialDesc = value; }
}
[Description("合同头状态")]
public string OrderHeadSts
{
get { return orderHeadSts; }
set { orderHeadSts = value; }
}
[Description("合同头状态描述")]
public string OrderHeadStsDesc
{
get { return orderHeadStsDesc; }
set { orderHeadStsDesc = value; }
}
///
/// 创建时间戳
///
[Description("创建时间戳")]
public string CreateTimestamp
{
get { return createTimestamp; }
set { createTimestamp = value; }
}
///
/// 保价类型
///
[Description("保价类型")]
public string KeepType
{
get { return keepType; }
set { keepType = value; }
}
private string problemMsg;
///
/// 问题反馈
///
[Description("问题反馈")]
public string ProblemMsg
{
get { return problemMsg; }
set { problemMsg = value; }
}
///
/// 数据状态(0 合同头 1合同行 2交货行)
///
private string dataFlag = "";
[Description("操作数据类型")]
[Nullable(true)]
public string DataFlag
{
get { return dataFlag; }
set { dataFlag = value; }
}
///
/// 首次受票人(国贸/钢贸/集团/客户) 卖出单位
///
[Description("首次受票人")]
[Nullable(true)]
[DataLength(30)]
public string FstDraweeUnit
{
get { return fstDraweeUnit; }
set { fstDraweeUnit = value; }
}
///
/// ORD_PK
///
[Description("ORD_PK")]
[Nullable(false)]
[DataLength(40)]
public string OrdPk
{
get { return ordPk; }
set { ordPk = value; }
}
///
/// ORD_LN_PK(ORD_PK+三位流失号)
///
[Description("ORD_LN_PK")]
[Nullable(false)]
[DataLength(40)]
public string OrdLnPk
{
get { return ordLnPk; }
set { ordLnPk = value; }
}
///
/// ORD_LN_DLY_PK(ORD_LN_PK+三位流水号)
///
[Description("ORD_LN_DLY_PK")]
[Nullable(false)]
[DataLength(40)]
public string OrdLnDlyPk
{
get { return ordLnDlyPk; }
set { ordLnDlyPk = value; }
}
///
/// 合同号(记录创建时如无合同号,形成LS+YYMMDD+三位流水号的临时合同号
///
[Description("合同号")]
[Nullable(true)]
[DataLength(20)]
public string OrderNo
{
get { return orderNo; }
set { orderNo = value; }
}
///
/// 合同行号(ORD_PK向下三位流水号,确保流水号的连续性)
///
[Description("合同行号")]
[Nullable(true)]
[DataLength(3)]
public string OrderSeq
{
get { return orderSeq; }
set { orderSeq = value; }
}
///
/// 交货编码(ORD_PK向下三位流水号,确保流水号唯一性、连续性)
///
[Description("交货编码")]
[Nullable(true)]
[DataLength(3)]
public string DeliveryNo
{
get { return deliveryNo; }
set { deliveryNo = value; }
}
///
/// 客户合同号
///
[Description("客户合同号")]
[Nullable(true)]
[DataLength(100)]
public string CustmOrderNo
{
get { return custmOrderNo; }
set { custmOrderNo = value; }
}
///
/// 合同类型
///
[Description("合同类型")]
[Nullable(true)]
[DataLength(20)]
public string OrderTyp
{
get { return orderTyp; }
set { orderTyp = value; }
}
///
/// 合同类型描述
///
[Description("合同类型描述")]
[Nullable(true)]
[DataLength(20)]
public string OrderTypDesc
{
get { return orderTypDesc; }
set { orderTypDesc = value; }
}
///
/// 省市/区域代码
///
[Description("省市/区域代码")]
[Nullable(true)]
[DataLength(40)]
public string RegionNo
{
get { return regionNo; }
set { regionNo = value; }
}
///
/// 省市/区域
///
[Description("省市/区域")]
[Nullable(true)]
[DataLength(100)]
public string RegionName
{
get { return regionName; }
set { regionName = value; }
}
///
/// 销售组织(国内贸易部/国际贸易部)
///
[Description("销售组织")]
[Nullable(true)]
[DataLength(20)]
public string SaleOrg
{
get { return saleOrg; }
set { saleOrg = value; }
}
///
/// 销售组织描述
///
[Description("销售组织描述")]
[Nullable(true)]
[DataLength(20)]
public string SaleOrgDesc
{
get { return saleOrgDesc; }
set { saleOrgDesc = value; }
}
///
/// 销售区域编码
///
[Description("销售区域编码")]
[Nullable(true)]
[DataLength(20)]
public string SaleAreaNo
{
get { return saleAreaNo; }
set { saleAreaNo = value; }
}
///
/// 销售区域描述
///
[Description("销售区域描述")]
[Nullable(true)]
[DataLength(50)]
public string SaleAreaDesc
{
get { return saleAreaDesc; }
set { saleAreaDesc = value; }
}
///
/// 订货单位代码
///
[Description("订货单位代码")]
[Nullable(true)]
[DataLength(10)]
public string CustomerNo
{
get { return customerNo; }
set { customerNo = value; }
}
///
/// 订货单位名称
///
[Description("订货单位名称")]
[Nullable(true)]
[DataLength(128)]
public string CustomerNm
{
get { return customerNm; }
set { customerNm = value; }
}
///
/// 收货单位编码
///
[Description("收货单位编码")]
[Nullable(true)]
[DataLength(100)]
public string ReceivNo
{
get { return receivNo; }
set { receivNo = value; }
}
///
/// 收货单位名称
///
[Description("收货单位名称")]
[Nullable(true)]
[DataLength(100)]
public string ReceivNm
{
get { return receivNm; }
set { receivNm = value; }
}
///
/// 计价方式(1203)
///
[Description("计价方式")]
[Nullable(true)]
[DataLength(20)]
public string PriceFl
{
get { return priceFl; }
set { priceFl = value; }
}
///
/// 订货量
///
[Description("订货量")]
[Nullable(true)]
[DataLength(22)]
public decimal? OrderQty
{
get { return orderQty; }
set { orderQty = value; }
}
///
/// 订货价(结算价)
///
[Description("订货价")]
[Nullable(true)]
[DataLength(22)]
public decimal? BalncePrice
{
get { return balncePrice; }
set { balncePrice = value; }
}
///
/// 币种
///
[Description("币种")]
[Nullable(true)]
[DataLength(20)]
public string Currency
{
get { return currency; }
set { currency = value; }
}
///
/// 付款方式
///
[Description("付款方式")]
[Nullable(true)]
[DataLength(20)]
public string MnyAskTyp
{
get { return mnyAskTyp; }
set { mnyAskTyp = value; }
}
///
/// 是否含税 0 否 1 是
///
[Description("是否含税")]
[Nullable(true)]
[DataLength(1)]
public string ContainTax
{
get { return containTax; }
set { containTax = value; }
}
///
/// 订货计量单位(支、米、吨)
///
[Description("订货计量单位")]
[Nullable(true)]
[DataLength(20)]
public string OrderUnit
{
get { return orderUnit; }
set { orderUnit = value; }
}
///
/// 品名代码
///
[Description("品名代码")]
[Nullable(true)]
[DataLength(20)]
public string Produccode
{
get { return produccode; }
set { produccode = value; }
}
///
/// 品名描述
///
[Description("品名描述")]
[Nullable(true)]
[DataLength(100)]
public string Producname
{
get { return producname; }
set { producname = value; }
}
///
/// 标准代码
///
[Description("标准代码")]
[Nullable(true)]
[DataLength(20)]
public string StdCode
{
get { return stdCode; }
set { stdCode = value; }
}
///
/// 标准名称
///
[Description("标准名称")]
[Nullable(true)]
[DataLength(200)]
public string StdName
{
get { return stdName; }
set { stdName = value; }
}
///
/// 钢级(牌号)代码
///
[Description("钢级(牌号)代码")]
[Nullable(true)]
[DataLength(10)]
public string Steelcode
{
get { return steelcode; }
set { steelcode = value; }
}
///
/// 钢级(牌号)名称
///
[Description("钢级(牌号)名称")]
[Nullable(true)]
[DataLength(100)]
public string Steelname
{
get { return steelname; }
set { steelname = value; }
}
///
/// 标准类别代码
///
[Description("标准类别代码")]
[Nullable(true)]
[DataLength(20)]
public string StdStyle
{
get { return stdStyle; }
set { stdStyle = value; }
}
///
/// 标准类别描述
///
[Description("标准类别描述")]
[Nullable(true)]
[DataLength(50)]
public string StdStyleDesc
{
get { return stdStyleDesc; }
set { stdStyleDesc = value; }
}
///
/// 扣型代码
///
[Description("扣型代码")]
[Nullable(true)]
[DataLength(20)]
public string ModelCode
{
get { return modelCode; }
set { modelCode = value; }
}
///
/// 扣型描述
///
[Description("扣型描述")]
[Nullable(true)]
[DataLength(100)]
public string ModelDesc
{
get { return modelDesc; }
set { modelDesc = value; }
}
///
/// 订货规格代码(用于合同、质保书、标牌、标识)
///
[Description("订货规格代码")]
[Nullable(true)]
[DataLength(20)]
public string OrderSpecCode
{
get { return orderSpecCode; }
set { orderSpecCode = value; }
}
///
/// 订货规格描述(用于合同、质保书、标牌、标识)
///
[Description("订货规格描述")]
[Nullable(true)]
[DataLength(200)]
public string OrderSpecDesc
{
get { return orderSpecDesc; }
set { orderSpecDesc = value; }
}
///
/// 产品规格代码
///
[Description("产品规格代码")]
[Nullable(true)]
[DataLength(20)]
public string SpecCode
{
get { return specCode; }
set { specCode = value; }
}
///
/// 产品规格描述
///
[Description("产品规格描述")]
[Nullable(true)]
[DataLength(100)]
public string SpecName
{
get { return specName; }
set { specName = value; }
}
///
/// 外径(mm)
///
[Description("外径(mm)")]
[Nullable(true)]
[DataLength(6)]
public decimal? Dimater
{
get { return dimater; }
set { dimater = value; }
}
///
/// 壁厚(mm)
///
[Description("壁厚(mm)")]
[Nullable(true)]
[DataLength(6)]
public decimal? Height
{
get { return height; }
set { height = value; }
}
///
/// 长度编码
///
[Description("长度编码")]
[Nullable(true)]
[DataLength(20)]
public string LenNo
{
get { return lenNo; }
set { lenNo = value; }
}
///
/// 长度描述
///
[Description("长度描述")]
[Nullable(true)]
[DataLength(200)]
public string LenDesc
{
get { return lenDesc; }
set { lenDesc = value; }
}
///
/// 长度单位
///
[Description("长度单位")]
[Nullable(true)]
[DataLength(20)]
public string LenUnit
{
get { return lenUnit; }
set { lenUnit = value; }
}
///
/// 外购坯(COM_BASE_INFO:1218)
///
[Description("外购坯")]
[Nullable(true)]
[DataLength(20)]
public string OutsBilletFl
{
get { return outsBilletFl; }
set { outsBilletFl = value; }
}
///
/// 外购管(COM_BASE_INFO:1219)
///
[Description("外购管")]
[Nullable(true)]
[DataLength(20)]
public string OutsStlPipeFl
{
get { return outsStlPipeFl; }
set { outsStlPipeFl = value; }
}
///
/// 付款要求描述
///
[Description("付款要求描述")]
[Nullable(true)]
[DataLength(200)]
public string MnyAskDesc
{
get { return mnyAskDesc; }
set { mnyAskDesc = value; }
}
///
/// 合同头锁定状态
///
[Description("合同头锁定状态")]
[Nullable(true)]
[DataLength(1)]
public string Islock
{
get { return islock; }
set { islock = value; }
}
///
/// 监制说明
///
[Description("监制说明")]
[Nullable(true)]
[DataLength(500)]
public string PrdcrDesc
{
get { return prdcrDesc; }
set { prdcrDesc = value; }
}
///
/// MPS说明
///
[Description("MPS说明")]
[Nullable(true)]
[DataLength(100)]
public string MpsDesc
{
get { return mpsDesc; }
set { mpsDesc = value; }
}
///
/// 结算单位编码
///
[Description("结算单位编码")]
[Nullable(true)]
[DataLength(10)]
public string StlmtUnitNo
{
get { return stlmtUnitNo; }
set { stlmtUnitNo = value; }
}
///
/// 结算单位名称
///
[Description("结算单位名称")]
[Nullable(true)]
[DataLength(128)]
public string StlmtUnitNm
{
get { return stlmtUnitNm; }
set { stlmtUnitNm = value; }
}
///
/// 交货量差方式(绝对值;百分比)
///
[Description("交货量差方式")]
[Nullable(true)]
[DataLength(20)]
public string DelvryRangeTpe
{
get { return delvryRangeTpe; }
set { delvryRangeTpe = value; }
}
///
/// 交货量差下限
///
[Description("交货量差下限")]
[Nullable(true)]
[DataLength(5)]
public decimal? DelvryRangeMin
{
get { return delvryRangeMin; }
set { delvryRangeMin = value; }
}
///
/// 交货量差上限
///
[Description("交货量差上限")]
[Nullable(true)]
[DataLength(5)]
public decimal? DelvryRangeMax
{
get { return delvryRangeMax; }
set { delvryRangeMax = value; }
}
///
/// 附加要求编码
///
[Description("附加要求编码")]
[Nullable(true)]
[DataLength(16)]
public string AddAskNo
{
get { return addAskNo; }
set { addAskNo = value; }
}
///
/// 订货附加要求描述
///
[Description("订货附加要求描述")]
[Nullable(true)]
[DataLength(4000)]
public string OrderAddDesc
{
get { return orderAddDesc; }
set { orderAddDesc = value; }
}
///
/// 产品特殊要求描述
///
[Description("产品特殊要求描述")]
[Nullable(true)]
[DataLength(4000)]
public string OrderSpecialDesc
{
get { return orderSpecialDesc; }
set { orderSpecialDesc = value; }
}
///
/// 交货行状态
///
[Description("交货行状态")]
[Nullable(true)]
[DataLength(20)]
public string OrderSts
{
get { return orderSts; }
set { orderSts = value; }
}
///
/// 交货行状态描述
///
[Description("交货行状态描述")]
[Nullable(true)]
[DataLength(20)]
public string OrderStsDesc
{
get { return orderStsDesc; }
set { orderStsDesc = value; }
}
///
/// 制造商代码
///
[Description("制造商代码")]
[Nullable(true)]
[DataLength(20)]
public string SupplyUnitCode
{
get { return supplyUnitCode; }
set { supplyUnitCode = value; }
}
///
/// 制造商
///
[Description("制造商")]
[Nullable(true)]
[DataLength(20)]
public string SupplyUnit
{
get { return supplyUnit; }
set { supplyUnit = value; }
}
///
/// 重量估算
///
[Description("重量估算")]
[Nullable(true)]
[DataLength(10)]
public decimal? WgtEstmt
{
get { return wgtEstmt; }
set { wgtEstmt = value; }
}
///
/// 交货结束日期
///
[Description("交货结束日期")]
[Nullable(true)]
public string DelvryEdate
{
get { return delvryEdate; }
set { delvryEdate = value; }
}
///
/// 生效时间
///
[Description("生效时间")]
[Nullable(true)]
public string EffectTime
{
get { return effectTime; }
set { effectTime = value; }
}
///
/// 提报时间
///
[Description("提报时间")]
[Nullable(true)]
public string TibaoTime
{
get { return tibaoTime; }
set { tibaoTime = value; }
}
///
/// CRM是否同步(0 未同步 1已同步)
///
[Description("CRM是否同步")]
[Nullable(true)]
[DataLength(1)]
public string IsFlag
{
get { return isFlag; }
set { isFlag = value; }
}
///
/// 数据类型(0 新增 1修改 2删除)
///
[Description("数据类型")]
[Nullable(true)]
[DataLength(1)]
public string DataStatus
{
get { return dataStatus; }
set { dataStatus = value; }
}
///
/// CRM用于修改的字段
///
[Description("CRM用于修改的字段")]
[Nullable(true)]
[DataLength(10)]
public string CrmFlag
{
get { return crmFlag; }
set { crmFlag = value; }
}
///
/// CRM同步时间
///
[Description("CRM同步时间")]
[Nullable(true)]
public string SynchroTime
{
get { return synchroTime; }
set { synchroTime = value; }
}
///
/// 主键
///
[Description("主键")]
[Nullable(false)]
[DataLength(40)]
public string Id
{
get { return id; }
set { id = value; }
}
///
/// 创建时间
///
[Description("创建时间")]
[Nullable(true)]
public string CreateTime
{
get { return createTime; }
set { createTime = value; }
}
///
/// 合同行状态
///
[Description("合同行状态")]
[Nullable(true)]
[DataLength(20)]
public string OrderLnSts
{
get { return orderLnSts; }
set { orderLnSts = value; }
}
///
/// 合同行状态描述
///
[Description("合同行状态描述")]
[Nullable(true)]
[DataLength(20)]
public string OrderLnStsDesc
{
get { return orderLnStsDesc; }
set { orderLnStsDesc = value; }
}
///
/// 合同创建人
///
[Description("合同创建人")]
[Nullable(true)]
[DataLength(40)]
public string CreateName
{
get { return createName; }
set { createName = value; }
}
private string balncePriceSts;
[Description("结算价状态")]
public string BalncePriceSts
{
get { return balncePriceSts; }
set { balncePriceSts = value; }
}
}
}