{"id":1457,"date":"2014-05-28T10:20:38","date_gmt":"2014-05-28T09:20:38","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1457&lang=en"},"modified":"2015-12-01T11:46:18","modified_gmt":"2015-12-01T10:46:18","slug":"article","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1457","title":{"rendered":"Article"},"content":{"rendered":"

Article:<\/span><\/b><\/h3>\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\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record<\/span> Type<\/span> =”36<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 36 is for article<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
<Name><\/ Name><\/span><\/td>\nChar(100)<\/td>\nY<\/td>\nName of the article<\/td>\n<\/tr>\n
<Code><\/Code><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nCode of the article<\/td>\n<\/tr>\n
<Description><\/Description><\/span><\/td>\nChar(255)<\/td>\nY<\/td>\nDescription of the article<\/td>\n<\/tr>\n
<OrgArticleCode><\/OrgArticleCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nArticle code if article is linked to an existing article<\/td>\n<\/tr>\n
<OrgArticleName><\/OrgArticleName><\/span><\/td>\nChar(100)<\/td>\nN<\/td>\nArticle name of the linked article<\/td>\n<\/tr>\n
<ArticleCategoryName><\/ArticleCategoryName><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nName of the category of the article<\/td>\n<\/tr>\n
<InvTGLAccountNumber><\/InvTGLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nAccount used for this article in client invoices<\/td>\n<\/tr>\n
<InvTDC><\/InvTDC><\/span><\/td>\nChar(1)<\/td>\nN<\/td>\nIndicate if account is used in debit or credit (possible values : D or C)<\/td>\n<\/tr>\n
<InvTVATCode><\/InvTVATCode><\/span><\/td>\nChar(20)<\/td>\nN<\/td>\nVAT Code used for this article in client invoices<\/td>\n<\/tr>\n
<InvTVATRate><\/InvTVATRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nVAT rate used for this article in client invoices<\/td>\n<\/tr>\n
<InvFGLAccountNumber><\/InvFGLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nAccount used for this article in supplier invoices<\/td>\n<\/tr>\n
<InvFVATCode><\/InvFVATCode><\/span><\/td>\nChar(20)<\/td>\nN<\/td>\nVAT Code used for this article in supplier invoices<\/td>\n<\/tr>\n
<InvFVATRate><\/InvFVATRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nVAT rate used for this article in supplier invoices<\/td>\n<\/tr>\n
<Currency><\/Currency><\/span><\/td>\nChar(10)<\/td>\nY<\/td>\nCurrency of the article<\/td>\n<\/tr>\n
<IntrastatCode><\/IntrastatCode><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nIntrastat code<\/td>\n<\/tr>\n
<IBLCCode><\/IBLCCode><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nIBLC code<\/td>\n<\/tr>\n
<SerialNumber><\/SerialNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nSerial number of the article<\/td>\n<\/tr>\n
<UnitNumber><\/UnitNumber><\/span><\/td>\nDouble<\/td>\nY<\/td>\nNumber of unit for this article<\/td>\n<\/tr>\n
<UnitName><\/UnitName><\/span><\/td>\nChar(20)<\/td>\nY<\/td>\nName of the unit for this article<\/td>\n<\/tr>\n
<PackingName><\/PackingName><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nName of the packing for the article<\/td>\n<\/tr>\n
<Min><\/Min><\/span><\/td>\nInteger<\/td>\nY<\/td>\nMinimum quantity used for the article<\/td>\n<\/tr>\n
<Max><\/Max><\/span><\/td>\nInteger<\/td>\nY<\/td>\nMaximum quantity used for the article<\/td>\n<\/tr>\n
<StartDate><\/StartDate><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nFirst day to use the article<\/td>\n<\/tr>\n
<EndDate><\/EndDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast day to use the article<\/td>\n<\/tr>\n
<UsualOrderQuantity><\/UsualOrderQuantity><\/span><\/td>\nDouble<\/td>\nY<\/td>\nUsual order quantity<\/td>\n<\/tr>\n
<ArticleBuy><\/ArticleBuy><\/span><\/td>\nBoolean<\/td>\nY<\/td>\n0 = not salable
\n1 = salable<\/td>\n<\/tr>\n
<ArticleSell><\/ArticleSell><\/span><\/td>\nBoolean<\/td>\nY<\/td>\n0 = not purchasable
\n1 = purchasable<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nPDF version<\/a>\n","protected":false},"excerpt":{"rendered":"

Article: Name Type Mandatory Description <Record Type =”36“> Long Y Type of object to import. 36 is for article <DBId><\/DBId> Long Y Database Id in DeMaSy. It is displayed in Utilities <Name><\/ Name> Char(100) Y Name of the article <Code><\/Code> Char(50) Y Code of the article <Description><\/Description> Char(255) Y Description of the article <OrgArticleCode><\/OrgArticleCode> Char(50) […]<\/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":[426,15,12],"class_list":["post-1457","post","type-post","status-publish","format-standard","hentry","category-utils","tag-article","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1457","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=1457"}],"version-history":[{"count":16,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions"}],"predecessor-version":[{"id":4718,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions\/4718"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}