{"id":9346,"date":"2020-07-30T14:33:29","date_gmt":"2020-07-30T13:33:29","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=9346&#038;lang=en"},"modified":"2020-07-30T14:47:19","modified_gmt":"2020-07-30T13:47:19","slug":"artdeppayment","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=9346","title":{"rendered":"ArtDepPayment"},"content":{"rendered":"<h3><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;Ref;Desc;SecurityCode;DepositReference;ArtDepPaymentType;CurrencyRate;<br \/>\nCyAmount;Amount;Description;BankStatmentNumber;BankAccountNumber;SecurityGLAccount<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 20 is for ArtDepPaymeny<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Ref<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Internal reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Desc<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Internal description<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SecurityCode<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Security code<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DepositReference<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Deposit reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ArtDepPaymentType<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Security\/Deposit payment type :<br \/>\n0 = NORMALPAY<br \/>\n1 = EXCHDIFFPAY<br \/>\n2 = DISCOUNTPAY<br \/>\n3 = DISCOUNTPRORATA<br \/>\n4 = FEESPAY<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ForexReference<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Forex reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PayDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Payment date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PCurrency<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Payment currency ISO code<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PCyAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Payment Amount in transaction currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ArtDepPaymentAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Security\/Deposit Payment Amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">13<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CurrencyRate<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Currency rate<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">14<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CyAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Amount in transaction currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">15<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Amount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Amount in capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">16<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Description<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">17<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BankStatmentNumber<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">18<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BankAccountNumber<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Bank Account number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">19<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SecurityGLAccount<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Security GLAccount number (Default, if it is no entered, is the GLAccount on DeMaSy Security screen)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>RecordType;DBId;Ref;Desc;SecurityCode;DepositReference;ArtDepPaymentType;CurrencyRate; CyAmount;Amount;Description;BankStatmentNumber;BankAccountNumber;SecurityGLAccount Nr Name Type Description 1 RecordType Long Type of object to import. 20 is for ArtDepPaymeny 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Ref Char(255) Internal reference 4 Desc Char(255) Internal description 5 SecurityCode Char(50) Security code 6 DepositReference Char(50) Deposit reference 7 ArtDepPaymentType Integer Security\/Deposit payment [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-9346","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/9346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9346"}],"version-history":[{"count":11,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/9346\/revisions"}],"predecessor-version":[{"id":9366,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/9346\/revisions\/9366"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}