Contract claim:
| RecordType;DBId;ContractRefSubRef;ContractTypeName;ContractCompanyName;ContractPersonName;ClaimNumber;ClaimDate; PaymentDate;CurrencyName;CyAmount;Amount;CancelDate;Description;InvoiceType;ExpertCompanyName;ExpertPersonName; InspectorCompanyName;InspectorPersonName;Location;ContractCauseName;ContractCauseCode |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 29 is for contract claim |
| 2 | DBId | Long | Database Id in DeMaSy. It is displayed in Utilities |
| 3 | ContractRefSubRef | Char(100) | Contract reference and sub-reference |
| 4 | ContractTypeName | Char(50) | Contract type name |
| 5 | ContractCompanyName | Char(75) | Contract company name |
| 6 | ContractPersonName | Char(75) | Contract person name |
| 7 | ClaimNumber | Char(50) | Claim number |
| 8 | ClaimDate | Date/Time | Claim date |
| 9 | PaymentDate | Date/Time | Payment date |
| 10 | CurrencyName | Char(10) | Currency name |
| 11 | CyAmount | Double | Amount in currency |
| 12 | Amount | Double | Amount |
| 13 | CancelDate | Date/Time | Not used |
| 14 | Description | Char(255) | Not used |
| 15 | InvoiceType | Integer | Invoice type |
| 16 | ExpertCompanyName | Char(75) | Expert company name |
| 17 | ExpertPersonName | Char(75) | Not used |
| 18 | InspectorCompanyName | Char(75) | Inspector company name |
| 19 | InspectorPersonName | Char(75) | Not used |
| 20 | Location | Char(75) | Location |
| 21 | ContractCauseName | Char(75) | Contract cause name |
| 22 | ContractCauseCode | Char(12) | Contract cause code |