------------------------------------------------------------------------------------------------------------------------------- Sanad
update Sanad set NoeSanad = 158 where NoeSanad = 0 -- افتتاحیه
update Sanad set NoeSanad = 159 where NoeSanad = 1 -- طی دوره
update Sanad set NoeSanad = 160 where NoeSanad = 2 -- اختتامیه
--************
update Sanad set Vaziat = 162 where Vaziat = 0 -- ثبت اولیه
update Sanad set Vaziat = 163 where Vaziat = 1 -- قطعی
--************
update Sanad set CodeMarja = 127 where CodeMarja = 0 -- حسابداری عمومی
update Sanad set CodeMarja = 128 where CodeMarja = 1 -- خرید
update Sanad set CodeMarja = 129 where CodeMarja = 2 -- فروش
update Sanad set CodeMarja = 130 where CodeMarja = 3 -- خزانه داری
update Sanad set CodeMarja = 131 where CodeMarja = 4 -- برگشت از خرید
update Sanad set CodeMarja = 132 where CodeMarja = 5 -- برگشت از فروش
update Sanad set CodeMarja = 133 where CodeMarja = 6 -- تولید کالا
update Sanad set CodeMarja = 134 where CodeMarja = 7 -- تبدیل کالا
update Sanad set CodeMarja = 135 where CodeMarja = 8 -- حقوق دستمزد
update Sanad set CodeMarja = 136 where CodeMarja = 9 -- استهلاک اموال
update Sanad set CodeMarja = 137 where CodeMarja = 10 -- تولید/مصرف کالای پروژه
------------------------------------------------------------------------------------------------------------------------------- SanadDetail
update SanadDetail set NoeMarja = 139 where NoeMarja = 0 -- هیچکدام
update SanadDetail set NoeMarja = 140 where NoeMarja = 1 -- فاکتور فروش
update SanadDetail set NoeMarja = 141 where NoeMarja = 2 -- فاکتور خرید
update SanadDetail set NoeMarja = 142 where NoeMarja = 3 -- فاکتور برگشت از فروش
update SanadDetail set NoeMarja = 143 where NoeMarja = 4 -- فاکتور برگشت ازخرید
update SanadDetail set NoeMarja = 144 where NoeMarja = 5 -- وجه دریافتی
update SanadDetail set NoeMarja = 145 where NoeMarja = 6 -- چک دریافتی
update SanadDetail set NoeMarja = 146 where NoeMarja = 7 -- فیش دریافتی
update SanadDetail set NoeMarja = 147 where NoeMarja = 8 -- وجه پرداختی
update SanadDetail set NoeMarja = 148 where NoeMarja = 9 -- چک پرداختی
update SanadDetail set NoeMarja = 149 where NoeMarja = 10 -- فیش پرداختی
update SanadDetail set NoeMarja = 150 where NoeMarja = 11 -- هزینه
update SanadDetail set NoeMarja = 151 where NoeMarja = 12 -- حواله حسابداری
update SanadDetail set NoeMarja = 152 where NoeMarja = 13 -- تولید
update SanadDetail set NoeMarja = 153 where NoeMarja = 14 -- تبدیل
update SanadDetail set NoeMarja = 154 where NoeMarja = 15 -- انبارگردانی
update SanadDetail set NoeMarja = 155 where NoeMarja = 16 -- مصرف کالای پروژه
update SanadDetail set NoeMarja = 156 where NoeMarja = 17 -- استهلاک اموال
------------------------------------------------------------------------------------------------------------------------------- EtelaateTakmili
update EtelaateTakmili set SatheEtelaat = 25 where SatheEtelaat = 0
update EtelaateTakmili set SatheEtelaat = 21 where SatheEtelaat = 1
------------------------------------------------------------------------------------------------------------------------------- GrooheHesab
update GrooheHesab set NoeGrooh = 57 where NoeGrooh = 0 -- سود زیانی
update GrooheHesab set NoeGrooh = 58 where NoeGrooh = 1 -- ترازنامه ای
update GrooheHesab set NoeGrooh = 59 where NoeGrooh = 2 -- کنترلی
------------------------------------------------------------------------------------------------------------------------------- Kol
update Kol set NoeMande = 61 where NoeMande = 0 -- بدهکار مطلق
update Kol set NoeMande = 62 where NoeMande = 1 -- بدهکار
update Kol set NoeMande = 63 where NoeMande = 2 -- بستانکار مطلق
update Kol set NoeMande = 64 where NoeMande = 3 -- بستانکار
update Kol set NoeMande = 65 where NoeMande = 4 -- بدون کنترل
--************
update Kol set MahiatHesab = 67 where MahiatHesab = 0
update Kol set MahiatHesab = 68 where MahiatHesab = 1
update Kol set MahiatHesab = 69 where MahiatHesab = 2
update Kol set MahiatHesab = 70 where MahiatHesab = 3
update Kol set MahiatHesab = 71 where MahiatHesab = 4
update Kol set MahiatHesab = 72 where MahiatHesab = 5
update Kol set MahiatHesab = 73 where MahiatHesab = 6
update Kol set MahiatHesab = 438 where MahiatHesab = 7
------------------------------------------------------------------------------------------------------------------------------- Farayand
update Farayand set NoeFarayand = 75 where NoeFarayand = 0
update Farayand set NoeFarayand = 76 where NoeFarayand = 1
update Farayand set NoeFarayand = 77 where NoeFarayand = 2
--************
update Farayand set Mahiat = 79 where Mahiat = 0
update Farayand set Mahiat = 80 where Mahiat = 1
update Farayand set Mahiat = 81 where Mahiat = 2
update Farayand set Mahiat = 82 where Mahiat = 3
update Farayand set Mahiat = 83 where Mahiat = 4
------------------------------------------------------------------------------------------------------------------------------- YadAvari
update YadAvari set Vaziat = 232 where Vaziat = 0
update YadAvari set Vaziat = 233 where Vaziat = 1
--************
update YadAvari set Noe = 235 where Noe = 0
update YadAvari set Noe = 236 where Noe = 1
update YadAvari set Noe = 237 where Noe = 2
update YadAvari set Noe = 238 where Noe = 3
update YadAvari set Noe = 239 where Noe = 4
update YadAvari set Noe = 240 where Noe = 5
update YadAvari set Noe = 241 where Noe = 6
update YadAvari set Noe = 242 where Noe = 7
update YadAvari set Noe = 243 where Noe = 8
update YadAvari set Noe = 244 where Noe = 9
update YadAvari set Noe = 245 where Noe = 10
update YadAvari set Noe = 246 where Noe = 11
update YadAvari set Noe = 247 where Noe = 12
update YadAvari set Noe = 248 where Noe = 30
update YadAvari set Noe = 249 where Noe = 31
update YadAvari set Noe = 250 where Noe = 32
update YadAvari set Noe = 251 where Noe = 33
------------------------------------------------------------------------------------------------------------------------------- Formul
update Formul set Noe = 256 where Noe = 0 -- تولید
update Formul set Noe = 257 where Noe = 1 -- تبدیل
------------------------------------------------------------------------------------------------------------------------------- Bargeh
update Bargeh set Noe = 28 where Noe = 0 -- فاکتور فروش
update Bargeh set Noe = 29 where Noe = 1 -- برگشت از فروش
update Bargeh set Noe = 30 where Noe = 2 --پیش فاکتور فروش
update Bargeh set Noe = 31 where Noe = 3 -- فاکتور خرید
update Bargeh set Noe = 32 where Noe = 4 -- برگشت از خرید
update Bargeh set Noe = 33 where Noe = 5 -- پیش فاکتور خرید
update Bargeh set Noe = 34 where Noe = 6 -- حواله انبار
update Bargeh set Noe = 35 where Noe = 7 -- رسید انبار
update Bargeh set Noe = 36 where Noe = 8 -- انتقال بین انبار
--************
update Bargeh set Vaziat = 100  where Vaziat = 0 -- نرمال
update Bargeh set Vaziat = 101  where Vaziat = 1-- حذف شده
update Bargeh set Vaziat = 102  where Vaziat = 2-- قطعي
update Bargeh set Vaziat = 103  where Vaziat = 3 -- سند خورده
update Bargeh set Vaziat = 104  where Vaziat = 4 -- فقط خواندني
--select * from Domain where ID = 99 or Dom_ID = 99
------------------------------------------------------------------------------------------------------------------------------- DaryaftPardakht
update DaryaftPardakht set NoeMaster = 38 where NoeMaster = 0 -- دریافت
update DaryaftPardakht set NoeMaster = 39 where NoeMaster = 1 --  پرداخت
update DaryaftPardakht set NoeMaster = 40 where NoeMaster = 2 -- هزینه
update DaryaftPardakht set NoeMaster = 41 where NoeMaster = 3 -- حواله حسابداری
update DaryaftPardakht set NoeMaster = 42 where NoeMaster = 4 -- درآمد
--************
update DaryaftPardakht set Vaziat = 100  where Vaziat = 0 -- نرمال
update DaryaftPardakht set Vaziat = 101  where Vaziat = 1-- حذف شده
update DaryaftPardakht set Vaziat = 102  where Vaziat = 2-- قطعي
update DaryaftPardakht set Vaziat = 103  where Vaziat = 3 -- سند خورده
update DaryaftPardakht set Vaziat = 104  where Vaziat = 4 -- فقط خواندني
--************
update DaryaftPardakht set NoeDetail = 44 where NoeDetail = 0 -- چک
update DaryaftPardakht set NoeDetail = 45 where NoeDetail = 1 -- حواله
update DaryaftPardakht set NoeDetail = 46 where NoeDetail = 2 -- وجه
--************ وضعیت چک
update DaryaftPardakht set VaziateChek  = 106 where VaziateChek  = 0 -- در جریان وصول
update DaryaftPardakht set VaziateChek  = 107 where VaziateChek  = 1 -- برگشت
update DaryaftPardakht set VaziateChek  = 108 where VaziateChek  = 2 -- حذف شده
update DaryaftPardakht set VaziateChek  = 109 where VaziateChek  = 3 --  خرج شده
update DaryaftPardakht set VaziateChek  = 110 where VaziateChek  = 4 -- موجود
update DaryaftPardakht set VaziateChek  = 111 where VaziateChek  = 5 -- برگشت به مشتری
update DaryaftPardakht set VaziateChek  = 112 where VaziateChek  = 6 -- پاس شده
update DaryaftPardakht set VaziateChek  = 113 where VaziateChek  = 7 -- برگشت از مشتری
update DaryaftPardakht set VaziateChek  = 114 where VaziateChek  = 8 -- دریافت نقد از مشتری
update DaryaftPardakht set VaziateChek  = 115 where VaziateChek  = 9 -- پس دادن چک برگشتی
update DaryaftPardakht set VaziateChek  = 116 where VaziateChek  = 10 -- نقد شدن چک برگشتی
update DaryaftPardakht set VaziateChek  = 117 where VaziateChek  = 11 -- نقد شدن چک
update DaryaftPardakht set VaziateChek  = 118 where VaziateChek  = 12 -- موجود شدن چک خرج شده

------------------------------------------------------------------------------------------------------------------------------- GardesheChek
update GardesheChek set Vaziat  = 106 where Vaziat  = 0 -- در جریان وصول
update GardesheChek set Vaziat  = 107 where Vaziat  = 1 -- برگشت
update GardesheChek set Vaziat  = 108 where Vaziat  = 2 -- حذف شده
update GardesheChek set Vaziat  = 109 where Vaziat  = 3 --  خرج شده
update GardesheChek set Vaziat  = 110 where Vaziat  = 4 -- موجود
update GardesheChek set Vaziat  = 111 where Vaziat  = 5 -- برگشت به مشتری
update GardesheChek set Vaziat  = 112 where Vaziat  = 6 -- پاس شده
update GardesheChek set Vaziat  = 113 where Vaziat  = 7 -- برگشت از مشتری
update GardesheChek set Vaziat  = 114 where Vaziat  = 8 -- دریافت نقد از مشتری
update GardesheChek set Vaziat  = 115 where Vaziat  = 9 -- پس دادن چک برگشتی
update GardesheChek set Vaziat  = 116 where Vaziat  = 10 -- نقد شدن چک برگشتی
update GardesheChek set Vaziat  = 117 where Vaziat  = 11 -- نقد شدن چک
update GardesheChek set Vaziat  = 118 where Vaziat  = 12 -- موجود شدن چک خرج شده
------------------------------------------------------------------------------------------------------------------------------- Tafsili
update Tafsili set Noe = 48 where Noe = 0 -- هرینه
update Tafsili set Noe = 49 where Noe = 1 -- بانک
update Tafsili set Noe = 50 where Noe = 2 -- شخص
update Tafsili set Noe = 51 where Noe = 3 -- صندوق
update Tafsili set Noe = 52 where Noe = 4 -- خدمات
update Tafsili set Noe = 53 where Noe = 5 -- پروژه
update Tafsili set Noe = 54 where Noe = 6 -- اموال
------------------------------------------------------------------------------------------------------------------------------- Aghsat
update Aghsat set Noe = 292 where Noe = 0 -- دریافتی
update Aghsat set Noe = 293 where Noe = 1 -- پرداختی
--************
update Aghsat set Vaziat = 295 where Vaziat = 0 -- پرداخت نشده
update Aghsat set Vaziat = 296 where Vaziat = 1 -- پرداخت شده
update Aghsat set Vaziat = 297 where Vaziat = 2 -- تبدیل به برگه دریافت/پرداخت
------------------------------------------------------------------------------------------------------------------------------- PhoneNumber
update PhoneNumber set Noe = 338 where Noe = 0 -- منزل
update PhoneNumber set Noe = 339 where Noe = 1 -- محل کار
update PhoneNumber set Noe = 340 where Noe = 2 -- فکس
update PhoneNumber set Noe = 341 where Noe = 3 -- موبایل
update PhoneNumber set Noe = 342 where Noe = 4 -- سایر

--select * from DaryaftPardakht