Article

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) N Article code if article is linked to an existing article
<OrgArticleName></OrgArticleName> Char(100) N Article name of the linked article
<ArticleCategoryName></ArticleCategoryName> Char(50) Y Name of the category of the article
<InvTGLAccountNumber></InvTGLAccountNumber> Char(50) N Account used for this article in client invoices
<InvTDC></InvTDC> Char(1) N Indicate if account is used in debit or credit (possible values : D or C)
<InvTVATCode></InvTVATCode> Char(20) N VAT Code used for this article in client invoices
<InvTVATRate></InvTVATRate> Double N VAT rate used for this article in client invoices
<InvFGLAccountNumber></InvFGLAccountNumber> Char(50) N Account used for this article in supplier invoices
<InvFVATCode></InvFVATCode> Char(20) N VAT Code used for this article in supplier invoices
<InvFVATRate></InvFVATRate> Double N VAT rate used for this article in supplier invoices
<Currency></Currency> Char(10) Y Currency of the article
<IntrastatCode></IntrastatCode> Char(50) Y Intrastat code
<IBLCCode></IBLCCode> Char(50) Y IBLC code
<SerialNumber></SerialNumber> Char(50) N Serial number of the article
<UnitNumber></UnitNumber> Double Y Number of unit for this article
<UnitName></UnitName> Char(20) Y Name of the unit for this article
<PackingName></PackingName> Char(50) Y Name of the packing for the article
<Min></Min> Integer Y Minimum quantity used for the article
<Max></Max> Integer Y Maximum quantity used for the article
<StartDate></StartDate> Date/Time Y First day to use the article
<EndDate></EndDate> Date/Time N Last day to use the article
<UsualOrderQuantity></UsualOrderQuantity> Double Y Usual order quantity
<ArticleBuy></ArticleBuy> Boolean Y 0 = not salable
1 = salable
<ArticleSell></ArticleSell> Boolean Y 0 = not purchasable
1 = purchasable
</Record> Y End of block
PDF version