{"id":1963,"date":"2014-07-11T10:51:56","date_gmt":"2014-07-11T09:51:56","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1963&lang=en"},"modified":"2020-07-30T13:56:50","modified_gmt":"2020-07-30T12:56:50","slug":"invoice-payment-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1963","title":{"rendered":"Invoice payment"},"content":{"rendered":"

CLIENT\/SUPPLIER INVOICE PAYMENTS:<\/span>
\n<\/span><\/b><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;Type;InvoiceFNumber;InvoiceTNumber;Date;PCurrency;PCyAmount;Currency;CurrencyRate;
\nCyAmount;Amount;Description; BankStatmentNumber;BankAccountNumber<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 26 is for payment<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy.<\/td>\n<\/tr>\n
3<\/td>\nRef<\/span><\/td>\nChar(255)<\/td>\nOptional reference (for transaction interface)<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nOptional description (for transaction interface)<\/td>\n<\/tr>\n
5<\/td>\nType<\/span><\/td>\nLong<\/td>\nType:
\n0 = Normal invoice payment
\n4 = Fees without VAT \/ 5 = Fees with VAT<\/td>\n<\/tr>\n
6<\/td>\nInvoiceFNumber<\/span><\/td>\nChar(50)<\/td>\nInvoice number if supplier invoice<\/td>\n<\/tr>\n
7<\/td>\nInvoiceTNumber<\/span><\/td>\nChar(50)<\/td>\nInvoice number if client invoice<\/td>\n<\/tr>\n
8<\/td>\nDate<\/span><\/td>\nDate\/Time<\/td>\nPayment Date (YYYYMMDD)<\/td>\n<\/tr>\n
9<\/td>\nPCurrency<\/span><\/td>\nChar(10)<\/td>\nPayment Currency (ISO code)<\/td>\n<\/tr>\n
10<\/td>\nPCyAmount<\/span><\/td>\nDouble<\/td>\nAmount (payment currency)<\/td>\n<\/tr>\n
11<\/td>\nCurrency<\/span><\/td>\nChar(10)<\/td>\nBank Currency (ISO code)<\/td>\n<\/tr>\n
12<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate between bank currency and capital currency<\/td>\n<\/tr>\n
13<\/td>\nCyAmount<\/span><\/td>\nDouble<\/td>\nAmount (bank currency)<\/td>\n<\/tr>\n
14<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount (capital currency)<\/td>\n<\/tr>\n
15<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription<\/td>\n<\/tr>\n
16<\/td>\nBankStatmentNumber<\/span><\/td>\nLong<\/td>\nBank Statement number<\/td>\n<\/tr>\n
17<\/td>\nBankAccountNumber<\/span><\/td>\nChar(50)<\/td>\nBank account number (IBAN)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To be noted that a payment with type 0 and bank statement number = 0 is considered as a wire transfer order.
\nSwift files sent to (wire transfer orders) or received (bank statements) from the bank (multiline) is dealt with the multiline wire transfer module.<\/p>\n","protected":false},"excerpt":{"rendered":"

CLIENT\/SUPPLIER INVOICE PAYMENTS: RecordType;DBId;Ref;Desc;Type;InvoiceFNumber;InvoiceTNumber;Date;PCurrency;PCyAmount;Currency;CurrencyRate; CyAmount;Amount;Description; BankStatmentNumber;BankAccountNumber Nr Name Type Description 1 RecordType Long Type of object to import. 26 is for payment 2 DBId Long Database ID in DeMaSy. 3 Ref Char(255) Optional reference (for transaction interface) 4 Desc Char(255) Optional description (for transaction interface) 5 Type Long Type: 0 = Normal invoice payment 4 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1963","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1963","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=1963"}],"version-history":[{"count":11,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1963\/revisions"}],"predecessor-version":[{"id":6874,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1963\/revisions\/6874"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}