Contract provision:
RecordType;DBId;ContractRefSubRef;ContractCompanyName;ContractPersonName;ContractTypeName;ContractClaimDate; ContractClaimNumber;Date;Number;CurrencyName;CyAmount;Amount;DGLAccountNumber;CGLAccountNumber;Description; Grouped |
Nr | Name | Type | Description |
---|---|---|---|
1 | RecordType | Long | Type of object to import. 30 is for contract detail |
2 | DBId | Long | Database Id in DeMaSy. It is displayed in Utilities |
3 | ContractRefSubRef | Char(100) | Contract reference and sub-reference |
4 | ContractCompanyName | Char(75) | Contract company name |
5 | ContractPersonName | Char(75) | Contract person name |
6 | ContractTypeName | Char(50) | Name of contract type |
7 | ContractClaimDate | Date/Time | Contract claim date |
8 | ContractClaimNumber | Char(50) | Contract claim number |
9 | Number | Integer | / |
10 | Date | Date/Time | / |
11 | CurrencyName | Char(10) | Currency name |
12 | CyAmount | Double | Amount in currency |
13 | Amount | Double | Amount |
14 | DGLAccountNumber | Char(50) | GL account number for debit |
15 | CGLAccountNumber | Char(50) | GL account number for credit |
16 | Description | Char(255) | / |
17 | Grouped | Integer | / |