Contract detail:
| RecordType;DBId;ContractRefSubRef;ContractTypeName;StartDate;EndDate;ContractCompanyName;ContractPersonName; CyNetPrime;NetPrime;CyFees;Fees;CyTax;Tax;CyTotalPrime;TotalPrime;CyReceivedCommission;ReceivedCommission; CyGivenCommission;GivenCommission;GivenCommissionType;CurrencyName;InvoiceType;AcctgDate;ReceiptNumber;Type; GivenCommissionPercentage;ReceivedCommissionPercentage;ReceivedCommissionType;TaxCompanyName;TaxPersonName; BeneficiaryPercentage;BeneficiaryCyAmount;BeneficiaryAmount |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 28 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 | ContractTypeName | Char(50) | Contract type name |
| 5 | StartDate | Date/Time | Contract start date |
| 6 | EndDate | Date/Time | Contract end date |
| 7 | ContractCompanyName | Char(75) | Contract company name |
| 8 | CyNetPrime | Double | Net prime in currency |
| 9 | NetPrime | Double | Net prime |
| 10 | CyFees | Double | Amount of fees in currency |
| 11 | Fees | Double | Amount of fees |
| 12 | CyTax | Double | Amount of taxes in currency |
| 13 | Tax | Double | Amount of taxes |
| 14 | CyTotalPrime | Double | Total prime (net+fees+taxes) in currency |
| 15 | TotalPrime | Double | Total prime (net+fees+taxes) |
| 16 | CyReceivedCommission | Double | Received commission in currency |
| 17 | ReceivedCommission | Double | Received commission |
| 18 | CyGivenCommission | Double | Given commission in currency |
| 19 | GivenCommission | Double | Given commission |
| 20 | GivenCommissionType | Integer | Type of given commission: 1 = deducted on invoice 2 = received after prime payment |
| 21 | CurrencyName | Char(10) | Currency name |
| 22 | InvoiceType | Integer | Type of invoice: 0 = no invoicing 1 = client invoicing 2 = agent invoicing |
| 23 | AcctgDate | Date/Time | / |
| 24 | ReceiptNumber | Char(25) | Receipt number |
| 25 | Type | Integer | / |
| 26 | GivenCommissionPercentage | Double | Given commission percentage |
| 27 | ReceivedCommissionPercentage | Double | Received commission percentage |
| 28 | ReceivedCommissionType | Integer | Type of received commission: 1 = deducted on invoice 2 = received after prime payment |
| 29 | TaxCompanyName | Char(75) | Tax company name |
| 30 | TaxPersonName | Char(75) | Tax person name |
| 31 | BeneficiaryPercentage | Double | Beneficiary percentage |
| 32 | BeneficiaryCyAmount | Double | Beneficiary amount in currency |
| 33 | BeneficiaryAmount | Double | Beneficiary amount |