Supplier:
RecordType;DBId;CompanyName;PersonName;StartDate;EndDate;FileNumber;DivisionName;RiskValue;DefGLAccountNumber; DefCurrencyName;DefReminderMaturity;DefEndOfMonth;DefVATCode;DefVATRate;SupplierTypeName;CurrentGLAccountNumber |
Nr | Name | Type | Description |
---|---|---|---|
1 | RecordType | Long | Type of object to import. 68 is for supplier |
2 | DBId | Long | Database ID in DeMaSy. |
3 | CompanyName | Char(75) | Company name if client is a company. |
4 | PersonName | Char(75) | Person name if client is a person. |
5 | StartDate | Date/Time | Start date (YYYYMMDD) |
6 | EndDate | Date/Time | End date (YYYYMMDD) |
7 | FileNumber | Long | Supplier unique number |
8 | DivisionName | Char(50) | Division name |
9 | RiskValue | Integer | Supplier risk value |
10 | DefGLAccountNumber | Char(50) | Default Account for postings |
11 | DefCurrencyName | Char(10) | Default Invoices Currency (ISO code) |
12 | DefReminderMaturity | Integer | Payment terms: number of days |
13 | DefEndOfMonth | Boolean | Payment terms: 0 = number of days / 1 = end of month |
14 | DefVATCode | Char(20) | Default VAT code |
15 | DefVATRate | Double | Default VAT rate |
16 | SupplierTypeName | Char(50) | Supplier type |