|
SQL ilişkisi şu şekilde: Siparişi, TBLSIPAMAS, TBLSIPATRA, TBLFATUEK. TBLFATUNO tablolarına İrsaliyeyi TBLFATUIRS, TBLSTHAR,TBLFATUEK, TBLFATUNO tablolarına kaydedeceksiniz
siparişte SOK_KODU, FISNO (sipariş no), STHAR_ACIKLAMA (cari kodu) SIRA,STHAR_GCMIK (sip miktarı)
irsaliyeye STOK_KODU,STHAR_SIPNUM,STHAR_ACIKLAMA (cari KODU), STRA_SIPKONT,STHAR_GCMIK (Sevk iktarı) olarak kaydedilir. sevk Miktarı TBLSIPATRA da FIRMA_DOVTUT alanında tutulur Bekleyen miktar TBLSIPATRA.STHAR_GCMIK - TBLSIPATRA.FIRMA_DOVTUT olarak hesaplanır
| < id="SL_locer" ="" title="Lock-in "> | < id="SL_lng_from" ="SL_lngs">< value="auto">Detect language< value="af">Afrikaans< value="sq">Albanian< value="am">Amharic< value="ar">Arabic< value="hy">Armenian< value="az">Azerbaijani< value="eu">Basque< value="be">Belarusian< value="bn">Bengali< value="bs">Bosnian< value="bg">Bulgarian< value="ca">Catalan< value="ceb">Cebuano< value="ny">Chichewa< value="zh-CN">Chinese (Simplified)< value="zh-TW">Chinese (Traditional)< value="co">Corsican< value="hr">Croatian< value="cs">Czech< value="da">Danish< value="nl">Dutch< value="en">English< value="eo">Esperanto< value="et">Estonian< value="tl">Filipino< value="fi">Finnish< value="fr">French< value="fy">Frisian< value="gl">Galician< value="ka">Georgian< value="de">German< value="el">Greek< value="gu">Gujarati< value="ht">Haitian Creole< value="ha">Hausa< value="haw">Hawaiian< value="iw">Hebrew< value="hi">Hindi< value="hmn">Hmong< value="hu">Hungarian< value="is">Icelandic< value="ig">Igbo< value="id">Indonesian< value="ga">Irish< value="it">Italian< value="ja">Japanese< value="jw">Javanese< value="kn">Kannada< value="kk">Kazakh< value="km">Khmer< value="ko">Korean< value="ku">Kurdish< value="ky">Kyrgyz< value="lo">Lao< value="la">Latin< value="lv">Latvian< value="lt">Lithuanian< value="lb">Luxembourgish< value="mk">Macedonian< value="mg">Malagasy< value="ms">Malay< value="ml">Malayalam< value="mt">Maltese< value="mi">Maori< value="mr">Marathi< value="mn">Mongolian< value="my">Myanmar (Burmese)< value="ne">Nepali< value="no">Norwegian< value="ps">Pashto< value="fa">Persian< value="pl">Polish< value="pt">Portuguese< value="pa">Punjabi< value="ro">Romanian< value="ru">Russian< value="sm">Samoan< value="gd">Scots Gaelic< value="sr">Serbian< value="st">Sesotho< value="sn">Shona< value="sd">Sindhi< value="si">Sinhala< value="sk">Slovak< value="sl">Slovenian< value="so">Somali< value="es">Spanish< value="su">Sundanese< value="sw">Swahili< value="sv">Swedish< value="tg">Tajik< value="ta">Tamil< value="te">Telugu< value="th">Thai< value="tr">Turkish< value="uk">Ukrainian< value="ur">Urdu< value="uz">Uzbek< value="vi">Vietnamese< value="cy">Welsh< value="xh">Xhosa< value="yi">Yiddish< value="yo">Yoruba< value="zu">Zulu | | < id="SL_lng_to" ="SL_lngs">< value="af">Afrikaans< value="sq">Albanian< value="am">Amharic< value="ar">Arabic< value="hy">Armenian< value="az">Azerbaijani< value="eu">Basque< value="be">Belarusian< value="bn">Bengali< value="bs">Bosnian< value="bg">Bulgarian< value="ca">Catalan< value="ceb">Cebuano< value="ny">Chichewa< value="zh-CN">Chinese (Simplified)< value="zh-TW">Chinese (Traditional)< value="co">Corsican< value="hr">Croatian< value="cs">Czech< value="da">Danish< value="nl">Dutch< value="en">English< value="eo">Esperanto< value="et">Estonian< value="tl">Filipino< value="fi">Finnish< value="fr">French< value="fy">Frisian< value="gl">Galician< value="ka">Georgian< value="de">German< value="el">Greek< value="gu">Gujarati< value="ht">Haitian Creole< value="ha">Hausa< value="haw">Hawaiian< value="iw">Hebrew< value="hi">Hindi< value="hmn">Hmong< value="hu">Hungarian< value="is">Icelandic< value="ig">Igbo< value="id">Indonesian< value="ga">Irish< value="it">Italian< value="ja">Japanese< value="jw">Javanese< value="kn">Kannada< value="kk">Kazakh< value="km">Khmer< value="ko">Korean< value="ku">Kurdish< value="ky">Kyrgyz< value="lo">Lao< value="la">Latin< value="lv">Latvian< value="lt">Lithuanian< value="lb">Luxembourgish< value="mk">Macedonian< value="mg">Malagasy< value="ms">Malay< value="ml">Malayalam< value="mt">Maltese< value="mi">Maori< value="mr">Marathi< value="mn">Mongolian< value="my">Myanmar (Burmese)< value="ne">Nepali< value="no">Norwegian< value="ps">Pashto< value="fa">Persian< value="pl">Polish< value="pt">Portuguese< value="pa">Punjabi< value="ro">Romanian< value="ru">Russian< value="sm">Samoan< value="gd">Scots Gaelic< value="sr">Serbian< value="st">Sesotho< value="sn">Shona< value="sd">Sindhi< value="si">Sinhala< value="sk">Slovak< value="sl">Slovenian< value="so">Somali< value="es">Spanish< value="su">Sundanese< value="sw">Swahili< value="sv">Swedish< value="tg">Tajik< value="ta">Tamil< value="te">Telugu< value="th">Thai< ed="ed" value="tr">Turkish< value="uk">Ukrainian< value="ur">Urdu< value="uz">Uzbek< value="vi">Vietnamese< value="cy">Welsh< value="xh">Xhosa< value="yi">Yiddish< value="yo">Yoruba< value="zu">Zulu | | | | | | |
Text-to-speech function is limited to 200 characters | < id="SL_BBL_locer" ="" ="1" title="Show Translator's 3 seconds"> | | chrome-extension://noaijdpnepcgjemiklgfkcfbkokogabh/content/html/options/options.html?bbl" rel="nofollow - Options : chrome-extension://noaijdpnepcgjemiklgfkcfbkokogabh/content/html/options/options.html?hist" rel="nofollow - History : chrome-extension://noaijdpnepcgjemiklgfkcfbkokogabh/content/html/options/options.html?feed" rel="nofollow - Feedback : https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=GD9D8CPW8HFA2" rel="nofollow - Donate | Close |
-------------
Mehmet Baykan
|