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) |