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 |