--select * from Hd_WageRecipt
--delete from HD_RevenueTypes
INSERT INTO HD_RevenueTypes (
    Code, Name, LatinName, CodeMoain, State, Priority, 
    HasExtWork, HasInsur, HasTax, HasMonthRate, Description,
    HasImpactOfDays, IsBasePercentage, HasNewYearReward, IsInReciptPrint,
    IsAmount, IsDec, IsActive, IsMinute, IsHour, IsDay,
    HasYears, IsContinuous, IsWelfare)
	values
(1,N'تعداد ساعات غیبت و کسر کار','AbsenceDays',NULL,2,2,0,0,0,0,NULL,0,0,0,1,0,NULL,1,1,1,1,NULL,NULL,NULL	),
(	2,N'حق ماموریت','MissionAmount',NULL,2,99,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	3,N'جریمه غیبت','AbsencePenaltyAmount',NULL,3,31,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,NULL,NULL	),
(	4,N'قسط وام','LoanInstallment',NULL,2,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,0,NULL	),
(	5,N'پاداش','RewardAmount',NULL,2,22,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	6,N'سایر کسورات','DeductionsAmount',NULL,2,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,0,NULL	),
(	7,N'سایر مزایا','EtcAdvantages',NULL,2,29,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	8,N'موقت حکمی 1','EtcExtAmount1',NULL,1,98,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,0,0,NULL	),
(	9,N'موقت حکمی 2','EtcExtAmount2',NULL,1,14,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	10,N'موقت حکمی 3','EtcExtAmount3',NULL,1,15,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	11,N'موقت حکمی 4','EtcExtAmount4',NULL,1,16,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	12,N'موقت حکمی 5','EtcExtAmount5',NULL,1,17,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	13,N'موقت حکمی 6','EtcExtAmount6',NULL,1,18,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	14,N'موقت حکمی 7','EtcExtAmount7',NULL,1,19,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,NULL,NULL,NULL	),
(	15,N'موقت حکمی 8','EtcExtAmount8',NULL,1,20,0,0,0,0,NULL,0,0,0,0,1,0,1,0,0,0,0,0,NULL	),
(	16,N'اضافه کاری','ExtWorkAmount',NULL,3,99,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	17,N'حقوق پایه','BaseAmount',NULL,1,1,1,1,1,0,NULL,1,0,1,1,1,0,1,0,0,0,1,1,NULL	),
(	18,N'مسکن و خواروبار','HousingAmount',NULL,1,5,0,1,0,0,NULL,0,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	19,N'حق جذب','AbsorbAmount',NULL,1,12,1,0,1,1,NULL,1,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	20,N'شب کاری','ShiftWorkAmount',NULL,3,21,0,1,1,0,NULL,1,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	21,N'هزینه سفر','TripAmount',NULL,2,99,0,0,0,1,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	22,N'فوق العاده محل خدمت','WorkPlaceExtAmount',NULL,1,11,1,0,1,1,NULL,1,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	23,N'سختی کار','BadWorkConditionAmount',NULL,1,7,1,0,0,1,NULL,1,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	24,N'ایاب ذهاب','TransferAmount',NULL,1,6,1,0,0,1,NULL,1,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	25,N'بیمه بیکاری','UnemploymentInsureAmount',NULL,4,99,0,0,0,0,NULL,0,0,0,1,1,NULL,1,0,0,0,NULL,NULL,NULL	),
(	26,N'پایه سنوات','BaseYearsAmount',NULL,1,2,0,0,1,1,NULL,0,0,1,1,1,0,1,0,0,0,0,0,NULL	),
(	27,N'عیدی','NewYearRewardAmount',NULL,2,21,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	28,N'بستانکاری','CreditorAmount',NULL,2,30,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	29,N'بن','CouponAmount',NULL,1,4,0,1,0,0,NULL,0,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	30,N'حق اولاد','ChildrensAmount',NULL,1,3,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	31,N'گرد شده ماه قبل','LastMonthRoundAmount',NULL,3,99,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	32,N'گرد شده ','RoundAmount',NULL,3,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,NULL,NULL	),
(	33,N'غیبت','Ghaybat',NULL,3,99,0,0,0,0,NULL,0,0,0,1,0,1,1,0,0,0,NULL,0,NULL	),
(	34,N'مالیات','TaxAmount',NULL,3,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,0,NULL	),
(	35,N'بیمه کارمند 7%','InsureAmountPer',NULL,3,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,0,NULL	),
(	36,N'تعداد روزهای کارکرد','QtyDayWork',NULL,2,1,0,1,1,0,NULL,0,0,0,1,0,NULL,1,0,0,1,NULL,NULL,NULL	),
(	37,N'مرخصی استعلاجی-روز','QtySickLeave',NULL,2,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,1,NULL,NULL,NULL	),
(	38,N'قسط مسکن','HousingPayment',NULL,2,99,0,0,1,0,NULL,0,0,0,1,0,1,1,0,0,0,NULL,NULL,NULL	),
(	39,N'مشمول بیمه','InsurAssignedAmount',NULL,4,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	40,N'بیمه سهم کارفرما','InsureAmountWork',NULL,4,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	41,N'مشمول اضافه کار','ExtWorkAssignedAmount',NULL,4,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	42,N'مشمول مالیات','TaxAssignedAmount',NULL,4,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	43,N'مساعده','AssistAmount',NULL,2,99,0,0,0,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,NULL,NULL	),
(	45,N'موقت کارکردی1','EtcExtAmount11',NULL,2,21,0,0,1,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,1,NULL	),
(	46,N'موقت کارکردی2','EtcExtAmount12',NULL,2,22,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	47,N'موقت کارکردی8','EtcExtAmount18',NULL,2,28,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	48,N'خالص پرداخت','TotalAmount',NULL,2,1,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	49,N'تعداد ساعات اضافه کاری','ExtWorkCount',NULL,2,3,0,1,1,0,NULL,0,0,0,1,0,NULL,1,1,1,1,NULL,NULL,NULL	),
(	50,N'تعداد ساعات شب کاری','ShiftWorkCount',NULL,2,4,0,1,1,0,NULL,0,0,0,1,0,NULL,1,1,1,1,NULL,NULL,NULL	),
(	51,N'تعداد ساعات تعطیل کاری','HolidayWorkCount',NULL,2,5,0,1,1,0,NULL,0,0,0,1,0,NULL,1,1,1,1,NULL,NULL,NULL	),
(	52,N'تعطیل کاری','HolidayWorkAmount',NULL,3,99,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,1,NULL	),
(	53,N'موقت کارکردی3','EtcExtAmount13',NULL,2,22,0,0,1,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,0,NULL	),
(	54,N'موقت کارکردی4','EtcExtAmount14',NULL,2,22,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	55,N'موقت کارکردی5','EtcExtAmount15',NULL,2,22,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	56,N'موقت کارکردی6','EtcExtAmount16',NULL,2,22,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	57,N'موقت کارکردی7','EtcExtAmount17',NULL,2,22,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	58,N'تعداد ساعات کارکرد','QtyHourWork',NULL,2,2,0,0,1,0,NULL,0,0,0,1,0,NULL,1,1,1,0,NULL,NULL,NULL	),
(	59,N'حقوق ساعتی','AmountHour',NULL,1,2,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	60,N'تعداد ساعات جمعه کاری','FridayWorkCount',NULL,2,5,0,1,1,0,NULL,0,0,0,1,0,NULL,1,1,1,1,NULL,NULL,NULL	),
(	61,N'جمعه کاری','FridayWorkAmount',NULL,3,99,0,1,1,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,0,NULL	),
(	62,N'بیمه تکمیلی','SupplementaryInsurance',NULL,2,99,0,0,1,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,1,NULL	),
(	63,N'سنوات','YearsAmount',NULL,2,99,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,NULL,NULL,NULL	),
(	64,N'مشمول مالیات عیدی','TaxAssignedNewYearRewardAmount',NULL,4,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	65,N'حق تاهل','MarriageAmount',NULL,1,99,0,0,0,0,NULL,0,0,0,1,1,0,1,0,0,0,0,0,NULL	),
(	66,N'بیمه عمر','LifeInsurance',NULL,2,99,0,0,1,0,NULL,0,0,0,1,1,1,1,0,0,0,NULL,1,NULL	),
(	67,N'مالیات سامانه','CalculatedTaxAmount',NULL,2,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	68,N'حق التدریس/حق التحقیق/ حق پژوهش','TuitionAmount',NULL,1,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	69,N'حق کشیک','StandByAmount',NULL,1,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	),
(	71,N'حق السعی  به استثنای مزد، حقوق، پاداش ','EffortAmount',NULL,1,99,0,0,0,0,NULL,0,0,0,1,0,NULL,1,0,0,0,NULL,NULL,NULL	)