Contract:
RecordType;DBId;CompanyGroupName;CurrencyName;ContractDate;Period;NoticeTime;Immatriculation;Description; InvoiceFrequency;ContractTypeName;ContractRiskName;ContractCompanyName;ContractPersonName;AgentCompanyName; AgentPersonName;ClientCompanyName;ClientPersonName;InsuredCompanyName;InsuredPersonName;MaturityDate;StartDate; EndDate;ExternalReference;RiskCountryName;RiskParticipation;CyInsuredValue;MaxClaimAmount;MaxClaimYearlyAmount; ExcessAmount;ExcessYearlyAmount |
Nr | Name | Type | Description |
---|---|---|---|
1 | RecordType | Long | Type of object to import. 27 is for contract |
2 | DBId | Long | Database Id in DeMaSy. It is displayed in Utilities |
3 | CompanyGroupName | Char(50) | Code of the company group/branch |
4 | CurrencyName | Char(10) | Name of the currency |
5 | ContractDate | Date/Time | Contract date |
6 | Period | Integer | Frequency/duration: 0 = No frequency 13 = Weekly 1 = Monthly 3 = Quaterly 6 = Half-yearly 12 = Yearly |
7 | Immatriculation | Char(50) | Not used |
8 | Description | Memo | Not used |
9 | InvoiceFrequency | Integer | Invoice frequency: 0 = No frequency 13 = Weekly 1 = Monthly 3 = Quaterly 6 = Half-yearly 12 = Yearly |
10 | ContractTypeName | Char(50) | Name of the Contract type |
11 | ContractRiskName | Char(50) | Name of the Contract risk |
12 | ContractCompanyName | Char(75) | Name of the Contract company |
13 | ContractPersonName | Char(75) | Name of the Contract person |
14 | AgentCompanyName | Char(75) | Name of the agent for the Company |
15 | AgentPersonName | Char(75) | Name of the agent person |
16 | ClientCompanyName | Char(75) | Name of the client company |
17 | ClientPersonName | Char(75) | Name of the client person |
18 | InsuredCompanyName | Char(75) | Name of the insured company |
19 | InsuredPersonName | Char(75) | Name of the insured person |
20 | MaturityDate | Date/Time | Maturity date |
21 | StartDate | Date/Time | Start date |
22 | EndDate | Date/Time | Start date |
23 | ExternalReference | Char(50) | External reference |
24 | RiskCountryName | Char(50) | Name of risk country |
25 | RiskParticipation | Double | / |
26 | CyInsuredValue | Double | Insured value in currency |
27 | MaxClaimAmount | Double | Maximum claim amount |
28 | MaxClaimYearlyAmount | Double | Maximum yearly claim amount |
29 | ExcessAmount | Double | Excess amount |
30 | ExcessYearlyAmount | Double | Yearly excess amount |