ilgili sql sorgular\u0131 ve tablo d\u00f6k\u00fcman\u0131<\/p>\n
<\/p>\n
UPDATE LG_412_01_CLRNUMS SET CEKRISKFACTOR=1<\/p>\n
UPDATE LG_412_01_CLRNUMS SET SENETRISKFACTOR=1<\/p>\n
UPDATE LG_412_01_CLRNUMS SET CSTCEKRISKFACTOR=1<\/p>\n
UPDATE LG_412_01_CLRNUMS SET CSTSENETRISKFACTOR=1<\/p>\n
UPDATE LG_412_01_CLRNUMS SET CSTCIROCEKRISKFAC=1<\/p>\n
UPDATE LG_412_01_CLRNUMS SET CSTCIROSENETRISKFAC=1<\/p>\n
<\/p>\n
CAR\u0130 HESAP KARI \u0130\u00c7ER\u0130S\u0130NDEK\u0130 R\u0130SK TUTARLARI<\/strong><\/p>\n SELECT ACCRISKLIMIT,MYCSRISKLIMIT,CSTCSRISKLIMIT,DESPRISKLIMIT,ORDRISKLIMIT,ORDRISKLIMITSUGG FROM LG_021_01_CLRNUMS WHERE CLCARDREF=9<\/p>\n CLCARDREF= CAR\u0130 HESAP KATI REFERANSI<\/p>\n ACCRISKLIMIT= A\u00c7IK HESAP<\/p>\n MYCSRISKLIMIT=KEMD\u0130 \u00c7EK<\/p>\n CSTCSRISKLIMIT= M\u00dc\u015eTER\u0130 \u00c7EK<\/p>\n DESPRISKLIMIT=\u0130RSAL\u0130YE<\/p>\n ORDRISKLIMIT=S\u0130PAR\u0130\u015e<\/p>\n ORDRISKLIMITSUGG=S\u0130PAR\u0130\u015e \u00d6NER\u0130<\/p>\n ——-CAR\u0130 HESAP KARI \u0130\u00c7ER\u0130S\u0130NDEK\u0130 \u00c7EK\/SENET R\u0130SK \u00c7ARPANLARI<\/strong><\/p>\n SELECT CEKRISKFACTOR, SENETRISKFACTOR, CSTCEKRISKFACTOR,CSTSENETRISKFACTOR FROM LG_003_01_CLRNUMS WHERE CLCARDREF=9<\/p>\n CLCARDREF= CAR\u0130 HESAP KATI REFERANSI<\/p>\n CEKRISKFACTOR = KEND\u0130 \u00c7EK\u0130M\u0130Z<\/p>\n SENETRISKFACTOR = KEND\u0130 SENED\u0130M\u0130Z<\/p>\n CSTCEKRISKFACTOR = M\u00dc\u015eTER\u0130 \u00c7EK\u0130<\/p>\n CSTSENETRISKFACTOR =\u00a0M\u00dc\u015eTER\u0130 SENED\u0130<\/p>\n NOT= Risk bilgileri tab’\u0131nda bulunan \u00e7ek risk \u00e7arpan\u0131 ve senet risk \u00e7arpan\u0131 alanlar\u0131 0 (s\u0131f\u0131r) de\u011feri verilirse \u00e7ek\/senet tutar\u0131 tahsil edilinceye kadar riskten d\u00fc\u015fmeyecektir. Bu de\u011ferin 1 (bir) olmas\u0131 halinde \u00e7ek\/senet al\u0131nd\u0131\u011f\u0131 anda cari hesab\u0131n risk limitinden d\u00fc\u015fer.<\/p>\n ————————————————————————————–<\/strong><\/p>\n CAR\u0130 HESAP KARI \u0130\u00c7ER\u0130S\u0130NDEK\u0130 R\u0130SK\u0130 ETK\u0130LEYECEK ALANLARI<\/strong><\/p>\n SELECT RISKTYPES1, RISKTYPES2,RISKTYPES3,RISKTYPES4,RISKTYPES5, RISKTYPES6 FROM LG_003_01_CLRNUMS WHERE CLCARDREF=9<\/p>\n CLCARDREF= CAR\u0130 HESAP KATI REFERANSI<\/p>\n RISKTYPES1 = A\u00c7IK HESAP<\/p>\n RISKTYPES2 = KEND\u0130 \u00c7EK\/SENED\u0130M\u0130Z<\/p>\n RISKTYPES3 = M\u00dc\u015eTER\u0130 \u00c7EK\/SENED\u0130M\u0130Z<\/p>\n RISKTYPES4 = \u0130RSAL\u0130YE<\/p>\n RISKTYPES5 = S\u0130PAR\u0130\u015e (SEVKED\u0130LEB\u0130L\u0130R)<\/p>\n RISKTYPES6 = S\u0130PAR\u0130\u015e (\u00d6NER\u0130)<\/p>\n NOT=\u00a00 (s\u0131f\u0131r) olmas\u0131 halinde risk takibi yap\u0131l\u0131r, 1 (bir) olmas\u0131 halinde risk takibi yap\u0131lmaz.<\/p>\n ————————————————————————————–<\/strong><\/p>\n HAREKETLERDE R\u0130SK\u0130 ETK\u0130LEYECEK ALANLARI<\/strong><\/p>\n AFFECTRISK alan\u0131 ile takip edilir. de\u011fer 0\u00a0(s\u0131f\u0131r)\u00a0ise etkileyecek demek, de\u011fer 1 (bir) ise riski etkilemeyecek demektir.<\/p>\n AFFECTRISK alan\u0131 a\u015fa\u011f\u0131daki tablolarda bulunur;<\/p>\n LG_030_01_BNFLINE = BANKA HAREKETLER\u0130<\/p>\n LG_030_01_CLFICHE = CAR\u0130 HESAP HAREKETLER\u0130<\/p>\n LG_030_01_CSCARD = DEV\u0130R \u00c7EKLER\u0130<\/p>\n LG_030_01_CSROLL =\u00a0\u00c7EK\/SENET\u00a0BORDOSU<\/p>\n LG_030_01_CSTRANS = \u00c7EK HAREKETLER\u0130<\/p>\n LG_030_01_DISTORD = DA\u011eITIM EM\u0130RLER\u0130<\/p>\n LG_030_01_DISTORDLINE = DA\u011eITIM EM\u0130RLER\u0130 SATIRLARI<\/p>\n LG_030_01_INVOICE = FATURA<\/p>\n LG_030_01_KSLINES = KASA SATIRLARI<\/p>\n LG_030_01_ORFICHE = S\u0130PAR\u0130\u015e F\u0130\u015e\u0130<\/p>\n LG_030_01_ORFLINE = S\u0130PAR\u0130\u015e F\u0130\u015e SATIRLARI<\/p>\n LG_030_01_STFICHE = \u0130RSAL\u0130YE<\/p>\n LG_030_01_STLINE = \u0130RSAL\u0130YE SATIRLARI<\/p>\n LG_030_PURCHOFFER =\u00a0S\u00d6ZLE\u015eME<\/p>\n LG_030_PURCHOFFERLN\u00a0= S\u00d6ZLE\u015eME SATIRLARI<\/p>\n","protected":false},"excerpt":{"rendered":" ilgili sql sorgular\u0131 ve tablo d\u00f6k\u00fcman\u0131<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-284","post","type-post","status-publish","format-standard","hentry","category-logo-genel-destek"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=284"}],"version-history":[{"count":4,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/284\/revisions"}],"predecessor-version":[{"id":395,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/284\/revisions\/395"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}