CLIENT:
| RecordType;DBId;CompanyName;PersonName;Prospect;StartDate;EndDate;FileNumber;DivisionName;RiskValue;DefGLAccountNumber; DefCurrencyName;DefReminderMaturity;DefEndOfMonth;DefVATCode;DefVATRate;Status;ClientTypeName;InvoiceType; ReceivedCommissionType;GivenCommissionType |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 44 is for client |
| 2 | DBId | Long | Database ID in DeMaSy. |
| 3 | CompanyName | Char(75) | Company Name is client is a company. |
| 4 | PersonName | Char(75) | Person Name is client is a person. |
| 5 | Prospect | Boolean | 0 = client / -1 = prospect |
| 6 | StartDate | Date/Time | Start date (YYYYMMDD) |
| 7 | EndDate | Date/Time | End date (YYYYMMDD) |
| 8 | FileNumber | Long | Unique Client number |
| 9 | DivisionName | Char(50) | Division name |
| 10 | RiskValue | Integer | Client risk value |
| 11 | DefGLAccountNumber | Char(50) | Default General Ledger Account number for postings |
| 12 | DefCurrencyName | Char(10) | Default invoices currency (ISO code) |
| 13 | DefReminderMaturity | Integer | Payment terms (number of days) |
| 14 | DefEndOfMonth | Boolean | Payment terms: 0 = number of days / -1 = end of month |
| 15 | DefVATCode | Char(20) | Default VAT Code |
| 16 | DefVATRate | Double | Default VAT Rate |
| 17 | Status | Char(255) | Client status |
| 18 | ClientTypeName | Char(50) | Client type |
| 19 | InvoiceType | Integer | N/A (for reinsurance) |
| 20 | ReceivedCommissionType | Integer | N/A (for reinsurance) |
| 21 | GivenCommissionType | Integer | N/A (for reinsurance) |