Client

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

PDF version
Excel version