{"id":1859,"date":"2014-07-11T10:15:05","date_gmt":"2014-07-11T09:15:05","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1859&lang=en"},"modified":"2020-07-30T13:46:23","modified_gmt":"2020-07-30T12:46:23","slug":"article-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1859","title":{"rendered":"Article"},"content":{"rendered":"

Article:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Name;Code;Description;CompanyName;OrgArticleCode;OrgArticleName;ArticleCategoryName;ArticleTypeName;
\nInvTGLAccountNumber;InvTDC;InvTVATCode;InvTVATRate;InvFGLAccountNumber;InvFDC;InvFVATCode;InvFVATRate;
\nDefaultSupplierName;Currency;IntrastatCode;IBLCCode;SerialNumber;UnitNumber;UnitName;PackingName;Min;Max;StartDate;
\nEndDate;UsualOrderQuantity;ArticleBuy;ArticleSell;Memo<\/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\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. 36 is for article<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nName
\n<\/span><\/td>\n		Char(100)<\/td>\nName of the article<\/td>\n<\/tr>\n
4<\/td>\nCode<\/span><\/td>\nChar(50)<\/td>\nCode of the article<\/td>\n<\/tr>\n
5<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription of the article<\/td>\n<\/tr>\n
6<\/td>\nOrgArticleCode<\/span><\/td>\nChar(50)<\/td>\nArticle code if article is linked to an existing article<\/td>\n<\/tr>\n
7<\/td>\nOrgArticleName<\/span><\/td>\nChar(100)<\/td>\nArticle name of the linked article<\/td>\n<\/tr>\n
8<\/td>\nArticleCategoryName<\/span><\/td>\nChar(50)<\/td>\nName of the category of the article<\/td>\n<\/tr>\n
9<\/td>\nInvTGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nAccount used for this article in client invoices<\/td>\n<\/tr>\n
10<\/td>\nInvTDC<\/span><\/td>\nChar(1)<\/td>\nIndicate if account is used in debit or credit (possible values : D or C)<\/td>\n<\/tr>\n
11<\/td>\nInvTVATCode<\/span><\/td>\nChar(20)<\/td>\nVAT Code used for this article in client invoices<\/td>\n<\/tr>\n
12<\/td>\nInvTVATRate<\/span><\/td>\nDouble<\/td>\nVAT rate used for this article in client invoices<\/td>\n<\/tr>\n
13<\/td>\nInvFGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nAccount used for this article in supplier invoices<\/td>\n<\/tr>\n
14<\/td>\nInvFVATCode<\/span><\/td>\nChar(20)<\/td>\nVAT Code used for this article in supplier invoices<\/td>\n<\/tr>\n
15<\/td>\nInvFVATRate<\/span><\/td>\nDouble<\/td>\nVAT rate used for this article in supplier invoices<\/td>\n<\/tr>\n
16<\/td>\nCurrency<\/span><\/td>\nChar(10)<\/td>\nCurrency of the article<\/td>\n<\/tr>\n
17<\/td>\nIntrastatCode<\/span><\/td>\nChar(50)<\/td>\nIntrastat code<\/td>\n<\/tr>\n
18<\/td>\nIBLCCode<\/span><\/td>\nChar(50)<\/td>\nIBLC code<\/td>\n<\/tr>\n
19<\/td>\nSerialNumber<\/span><\/td>\nChar(50)<\/td>\nSerial number of the article<\/td>\n<\/tr>\n
20<\/td>\nUnitNumber<\/span><\/td>\nDouble<\/td>\nNumber of unit for this article<\/td>\n<\/tr>\n
21<\/td>\nUnitName<\/span><\/td>\nChar(20)<\/td>\nName of the unit for this article<\/td>\n<\/tr>\n
22<\/td>\nPackingName<\/span><\/td>\nChar(50)<\/td>\nName of the packing for the article<\/td>\n<\/tr>\n
23<\/td>\nMin<\/span><\/td>\nInteger<\/td>\nMinimum quantity used for the article<\/td>\n<\/tr>\n
24<\/td>\nMax<\/span><\/td>\nInteger<\/td>\nMaximum quantity used for the article<\/td>\n<\/tr>\n
25<\/td>\nStartDate<\/span><\/td>\nDate\/Time<\/td>\nFirst day to use the article<\/td>\n<\/tr>\n
26<\/td>\nEndDate<\/span><\/td>\nDate\/Time<\/td>\nLast day to use the article<\/td>\n<\/tr>\n
27<\/td>\nUsualOrderQuantity<\/span><\/td>\nDouble<\/td>\nUsual order quantity<\/td>\n<\/tr>\n
28<\/td>\nArticleBuy<\/span><\/td>\nBoolean<\/td>\n0 = not salable
\n1 = salable<\/td>\n<\/tr>\n
29<\/td>\nArticleSell<\/span><\/td>\nBoolean<\/td>\n0 = not purchasable
\n1 = purchasable<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Article: RecordType;DBId;Name;Code;Description;CompanyName;OrgArticleCode;OrgArticleName;ArticleCategoryName;ArticleTypeName; InvTGLAccountNumber;InvTDC;InvTVATCode;InvTVATRate;InvFGLAccountNumber;InvFDC;InvFVATCode;InvFVATRate; DefaultSupplierName;Currency;IntrastatCode;IBLCCode;SerialNumber;UnitNumber;UnitName;PackingName;Min;Max;StartDate; EndDate;UsualOrderQuantity;ArticleBuy;ArticleSell;Memo Nr Name Type Description 1 RecordType Long Type of object to import. 36 is for article 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Name Char(100) Name of the article 4 Code Char(50) Code of the article 5 Description Char(255) Description of the article 6 […]<\/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-1859","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1859","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=1859"}],"version-history":[{"count":8,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1859\/revisions"}],"predecessor-version":[{"id":9297,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1859\/revisions\/9297"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}