{"id":1494,"date":"2014-06-12T08:12:47","date_gmt":"2014-06-12T07:12:47","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1494&#038;lang=en"},"modified":"2019-11-27T15:22:53","modified_gmt":"2019-11-27T14:22:53","slug":"bankaccount","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1494","title":{"rendered":"BankAccount"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">Bank Account:<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"15\">Mandatory<\/th>\n<th width=\"250\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">&lt;<span style=\"color: #993300;\">Record<\/span> <span style=\"color: #0000ff;\">Type<\/span> =&#8221;<span style=\"color: #ff0000;\">40<\/span>&#8220;&gt;<\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 40 is for BankAccount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Number&gt;&lt;\/ Number&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Number of the bank account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;IbanNumber&gt;&lt;\/IbanNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(40)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">IBAN Number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CompanyName&gt;&lt;\/CompanyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the company linked to this account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;PersonName&gt;&lt;\/PersonName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the person linked to this account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BankName&gt;&lt;\/BankName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the bank<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BankAccountCurrency&gt;&lt;\/BankAccountCurrency&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Currency for the bank account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;GLAccountNumber&gt;&lt;\/GLAccountNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">General ledger account linked to the bank account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BankAccountTypeName&gt;&lt;\/BankAccountTypeName&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;FeeType&gt;&lt;\/FeeType&gt;<\/span><\/td>\n<td valign=\"top\">Short<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of fee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Name&gt;&lt;\/Name&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the bank account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;OpenDate&gt;&lt;\/OpenDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Open date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CloseDate&gt;&lt;\/CloseDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Close date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Description&gt;&lt;\/Description&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Description of the bank account<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;AccountManager&gt;&lt;\/AccountManager&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Account manager<\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td valign=\"top\"><\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td>End of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"https:\/\/sdna.lu\/?media_dl=7343\">PDF version<\/a><br \/>\n<a href=\"https:\/\/sdna.lu\/?media_dl=7347\">Excel version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bank Account: Name Type Mandatory Description &lt;Record Type =&#8221;40&#8220;&gt; Long Y Type of object to import. 40 is for BankAccount &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;Number&gt;&lt;\/ Number&gt; Char(50) Y Number of the bank account &lt;IbanNumber&gt;&lt;\/IbanNumber&gt; Char(40) Y IBAN Number &lt;CompanyName&gt;&lt;\/CompanyName&gt; Char(75) Y Name of the company linked to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[57,15,12],"class_list":["post-1494","post","type-post","status-publish","format-standard","hentry","category-utils","tag-bank-account","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1494","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1494"}],"version-history":[{"count":19,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1494\/revisions"}],"predecessor-version":[{"id":7348,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1494\/revisions\/7348"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}