{"id":1970,"date":"2014-07-11T11:10:33","date_gmt":"2014-07-11T10:10:33","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1970&lang=en"},"modified":"2021-01-04T15:51:54","modified_gmt":"2021-01-04T14:51:54","slug":"client-invoice-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1970","title":{"rendered":"Client Invoice (TXT)"},"content":{"rendered":"

CLIENT INVOICE (header):<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;Number;ClientName;InvoiceDate;InvoiceTCurrency;CurrencyRate;Description;Type;ClientNumber;ReminderDate<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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. Type 22 is for invoice headers<\/td>\n<\/tr>\n
1<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy<\/td>\n<\/tr>\n
2<\/td>\nRef<\/span><\/td>\nChar(255)<\/td>\nInternal reference<\/td>\n<\/tr>\n
3<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nInternal description<\/td>\n<\/tr>\n
4<\/td>\nNumber<\/span><\/td>\nChar(50)<\/td>\nInvoice Number<\/td>\n<\/tr>\n
5<\/td>\nClientName<\/span><\/td>\nChar(75)<\/td>\nClient Name (has to match existing client name)
\nNB: If the unique client file number is provided the name can be omitted<\/td>\n<\/tr>\n
6<\/td>\nDate<\/span><\/td>\nDate\/Time<\/td>\nInvoice date (YYYYMMDD)<\/td>\n<\/tr>\n
7<\/td>\nCurrency<\/span><\/td>\nChar(10)<\/td>\nCurrency (ISO code)<\/td>\n<\/tr>\n
8<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate<\/td>\n<\/tr>\n
9<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription<\/td>\n<\/tr>\n
10<\/td>\nType<\/span><\/td>\nInteger<\/td>\nType transaction:
\n1 = Invoice \/ 8 = Credit note
\n3 = Permanent Order \/ 6 = Initial
\n7 = Advance payment
\n9 = Write Off<\/td>\n<\/tr>\n
11<\/td>\nClientFileNumber<\/span><\/td>\nDouble<\/span><\/td>\nClient number
\n(mandatory if no name specified)<\/td>\n<\/tr>\n
12<\/td>\nReminderDate<\/span><\/td>\nDate\/Time<\/td>\nReminder date (YYYYMMDD)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

CLIENT INVOICE (details):<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;InvoiceNumber;ArticleCode;CyArticlePrice;ArticlePrice;ArticleNumber;
\nCyAmount;Amount;VATCode;VATRate;CyVATValue;VATValue;Description;DGLAccount;CGLAccount;PLCenterCode#<\/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\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. 23 = Client invoice detail<\/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>\nInternal reference<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nInternal description<\/td>\n<\/tr>\n
5<\/td>\nInvoiceNumber<\/span><\/td>\nChar(50)<\/td>\nInvoice number<\/td>\n<\/tr>\n
6<\/td>\nArticleCode<\/span><\/td>\nChar(50)<\/td>\nArticle code<\/td>\n<\/tr>\n
7<\/td>\nCyArticlePrice<\/span><\/td>\nDouble<\/td>\nUnit price (transaction currency)<\/td>\n<\/tr>\n
8<\/td>\nArticlePrice<\/span><\/td>\nDouble<\/td>\nUnit price (capital currency)<\/td>\n<\/tr>\n
9<\/td>\nArticleNumber<\/span><\/td>\nDouble<\/td>\nQuantity of article<\/td>\n<\/tr>\n
10<\/td>\nCyAmount<\/span><\/td>\nDouble<\/td>\nAmount without VAT (transaction currency)<\/td>\n<\/tr>\n
11<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount without VAT (capital currency) – optional<\/td>\n<\/tr>\n
12<\/td>\nVATCode<\/span><\/td>\nChar 20<\/td>\nVAT Code<\/td>\n<\/tr>\n
13<\/td>\nVATRate<\/span><\/td>\nDouble<\/td>\nVAT Rate<\/td>\n<\/tr>\n
14<\/td>\nCyVATValue<\/span><\/td>\nDouble<\/td>\nVAT value (transaction currency)<\/td>\n<\/tr>\n
15<\/td>\nVATValue<\/span><\/td>\nDouble<\/td>\nVAT value (capital currency) – optional<\/td>\n<\/tr>\n
16<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription<\/td>\n<\/tr>\n
17<\/td>\nDGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nDebit account number (empty = client default)<\/td>\n<\/tr>\n
18<\/td>\nCGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nCredit account number (empty = client default)<\/td>\n<\/tr>\n
19<\/td>\nPLCenterCode<\/span><\/td>\nChar(50)<\/td>\nProfit and loss center code<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

If an article code is specified, an article price and an article number must be specified.
\nThe Amount must be equal to the ArticleNumber * ArticlePrice
\nThe CyAmount must be equal to the ArticleNumber * CyArticlePrice
\nThe VATValue must be equal to the Amount * VATCodeRate \/ 100.
\nThe CyVATValue must be equal to the CyAmount * VATCodeRate \/ 100.
\nIf the DGLAccountNumber is specified and not the CGLAccountNumber the CGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
\nIf the CGLAccountNumber is specified and not the DGLAccountNumber the DGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
\nIf the 2 Accounts are specified, one of the two accounts must be the Client General Ledger account.
\nIn the following block, a detail will be generated for the invoice number 00001 with only an amount and a VAT.<\/p>\n","protected":false},"excerpt":{"rendered":"

CLIENT INVOICE (header): RecordType;DBId;Ref;Desc;Number;ClientName;InvoiceDate;InvoiceTCurrency;CurrencyRate;Description;Type;ClientNumber;ReminderDate Nr Name Type Description 1 RecordType Long Type of object to import. Type 22 is for invoice headers 1 DBId Long Database ID in DeMaSy 2 Ref Char(255) Internal reference 3 Desc Char(255) Internal description 4 Number Char(50) Invoice Number 5 ClientName Char(75) Client Name (has to match existing client name) […]<\/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":[428,15,21,481],"class_list":["post-1970","post","type-post","status-publish","format-standard","hentry","category-interface-utils","tag-client","tag-interface","tag-invoice","tag-txt"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1970","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=1970"}],"version-history":[{"count":21,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1970\/revisions"}],"predecessor-version":[{"id":11148,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1970\/revisions\/11148"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}