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 | OrgArticleCode | Char(50) | Article code if article is linked to an existing article |
| 7 | OrgArticleName | Char(100) | Article name of the linked article |
| 8 | ArticleCategoryName | Char(50) | Name of the category of the article |
| 9 | InvTGLAccountNumber | Char(50) | Account used for this article in client invoices |
| 10 | InvTDC | Char(1) | Indicate if account is used in debit or credit (possible values : D or C) |
| 11 | InvTVATCode | Char(20) | VAT Code used for this article in client invoices |
| 12 | InvTVATRate | Double | VAT rate used for this article in client invoices |
| 13 | InvFGLAccountNumber | Char(50) | Account used for this article in supplier invoices |
| 14 | InvFVATCode | Char(20) | VAT Code used for this article in supplier invoices |
| 15 | InvFVATRate | Double | VAT rate used for this article in supplier invoices |
| 16 | Currency | Char(10) | Currency of the article |
| 17 | IntrastatCode | Char(50) | Intrastat code |
| 18 | IBLCCode | Char(50) | IBLC code |
| 19 | SerialNumber | Char(50) | Serial number of the article |
| 20 | UnitNumber | Double | Number of unit for this article |
| 21 | UnitName | Char(20) | Name of the unit for this article |
| 22 | PackingName | Char(50) | Name of the packing for the article |
| 23 | Min | Integer | Minimum quantity used for the article |
| 24 | Max | Integer | Maximum quantity used for the article |
| 25 | StartDate | Date/Time | First day to use the article |
| 26 | EndDate | Date/Time | Last day to use the article |
| 27 | UsualOrderQuantity | Double | Usual order quantity |
| 28 | ArticleBuy | Boolean | 0 = not salable 1 = salable |
| 29 | ArticleSell | Boolean | 0 = not purchasable 1 = purchasable |