namespace CAPI.Custom.Entities
{
	using System.ComponentModel.DataAnnotations.Schema;

	[Table("publ_SalesItemsFinal")]
	public class SalesItemsFinal : ISurfaceChildEntity, ISurfacePublishedEntity
    {
        protected string _masterPartNumber = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalMasterPartNumber")]
        public string SalesItemsFinalMasterPartNumber
        {
            get { return _masterPartNumber.ToUpperNonEmpty(); }
            set { _masterPartNumber = value.ToUpperNonEmpty(); }
        }

        protected string _partNumber = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalPartNumber")]
        public string SalesItemsFinalPartNumber
        {
            get { return _partNumber.ToUpperNonEmpty(); }
            set { _partNumber = value.ToUpperNonEmpty(); }
        }

        protected string _uniqueNumber = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalUniqueNumber")]
        public string SalesItemsFinalUniqueNumber
        {
            get { return _uniqueNumber.ToUpperNonEmpty(); }
            set { _uniqueNumber = value.ToUpperNonEmpty(); }
        }

        [Column("recId")]
		public int recId { get; set; }

        [Column("SalesItemsFinal_SalesItemsFinal_InvoiceQty")]
        public int? InvoiceQty { get; set; } = 0;

        [Column("isActive")]
        public bool? isActive { get; set; } = true;

		[Column("itemID")]
		public int itemID { get; set; }

		[Column("ParentSurfaceItemId")]
		public int? ParentSurfaceItemId { get; set; }

		[Column("QuoteItemsFinal_SalesItemsFinal_QuoteReference")]
		public string QuoteItemsFinalQuoteReference { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_QuoteReference")]
		public string QuoteReference { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalAdditionalDescription")]
		public string SalesItemsFinalAdditionalDescription { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalBrand")]
		public string SalesItemsFinalBrand { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalCategory")]
		public string SalesItemsFinalCategory { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalCondition")]
		public string SalesItemsFinalCondition { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalDescription")]
		public string SalesItemsFinalDescription { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalDimensionalDescription")]
		public string SalesItemsFinalDimensionalDescription { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalLeadTime")]
		public string SalesItemsFinalLeadTime { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalMinorCode")]
		public string SalesItemsFinalMinorCode { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalQuantityAvailable")]
        public int? SalesItemsFinalQuantityAvailable { get; set; } = 0;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalQuantityRequired")]
        public int? SalesItemsFinalQuantityRequired { get; set; } = 0;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalSequenceNumber")]
        public int? SalesItemsFinalSequenceNumber { get; set; } = 0;

		[Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalSubCategory")]
		public string SalesItemsFinalSubCategory { get; set; } = string.Empty;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalTotalPriceZAR")]
        public decimal? SalesItemsFinalTotalPriceZAR { get; set; } = 0m;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalUnitPriceZAR")]
        public decimal? SalesItemsFinalUnitPriceZAR { get; set; } = 0m;

        [Column("SalesItemsFinal_SalesItemsFinal_SalesItemsFinalWeightKG")]
        public decimal? SalesItemsFinalWeightKG { get; set; } = 0m;

		[Column("surfaceId")]
		public int surfaceId { get; set; }
	}
}