CLIENT
Name | Type | Mandatory | Description |
---|---|---|---|
<Record Type =”44“> | Long | Y | Type of object to import. 44 is for client |
<DBId></DBId> | Long | Y | Database ID in DeMaSy. |
<CompanyName></ CompanyName> | Char(75) | Y | Company Name if client is a company. |
<PersonName></PersonName> | Char(75) | Y | Person Name if client is a person. (Concatenation of LastName and FirstName) |
<Prospect></Prospect> | Boolean | N | 0 = client / -1 = prospect |
<StartDate></StartDate> | Date/Time | N | Start date (YYYYMMDD) |
<EndDate></EndDate> | Date/Time | N | End date (YYYYMMDD) |
<FileNumber></FileNumber> | Long | N | Unique Client number |
<DivisionName></DivisionName> | Char(50) | N | Division name |
<RiskValue></ RiskValue> | Integer | N | Client risk value |
<DefGLAccountNumber></DefGLAccountNumber> | Char(50) | Y | Default General Ledger Account number for postings |
<DefCurrencyName></DefCurrencyName> | Char(10) | Y | Default invoices currency (ISO code) |
<DefReminderMaturity></DefReminderMaturity> | Integer | Y | Payment terms (number of days) |
<DefEndOfMonth></DefEndOfMonth> | Boolean | Y | Payment terms: 0 = number of days / -1 = end of month |
<DefVATCode></DefVATCode> | Char(20) | Y | Default VAT Code |
<DefVATRate></DefVATRate> | Double | Y | Default VAT Rate |
<Status></ Status> | Char(255) | N | Client status |
<ClientTypeName></ClientTypeName> | Char(50) | N | Client type |
<InvoiceType></InvoiceType> | Integer | N | N/A (for reinsurance) |
<ReceivedCommissionType></ReceivedCommissionType> | Integer | N | N/A (for reinsurance) |
<GivenCommissionType></GivenCommissionType> | Integer | N | N/A (for reinsurance) |
</Record> | Y | End of block |