Interface Generic Mapping Excel

In this section, you will find all the files necessary to use the Generic Interface Excel. All downloaded zip files contain an Excel file and an XML file used as parameters in the interface. Client invoice Company Contract Contract claim Contract detail Contract...

Supplier invoice XML

SUPPLIER INVOICE (header) Name Type Mandatory Description <Record Type =”24″> Long Y Type of object to import. 24 is for supplier invoice <DBId></DBId> Long Y Database ID in DeMaSy <Number></Number> Char(50) Y Number of the...

Currency rate

Currency rate: RecordType;DBId;StartDate;EndDate;OrgCurrency;DestCurrency;Value;BuyValue;SellValue;InputValue;Invert;RoundPos Nr Name Type Description 1 RecordType Long Type of object to import. 51 is for currency rates 2 DBId Long Database Id in DeMaSy. It is...

Client Invoice

If an article code is specified, an article price and an article number must be specified.The Amount must be equal to the ArticleNumber * ArticlePriceThe CyAmount must be equal to the ArticleNumber * CyArticlePriceThe VATValue must be equal to the Amount * VATCodeRate...

ArtDepPayment

RecordType;DBId;Ref;Desc;SecurityCode;DepositReference;ArtDepPaymentType;CurrencyRate; CyAmount;Amount;Description;BankStatmentNumber;BankAccountNumber;SecurityGLAccount Nr Name Type Description 1 RecordType Long Type of object to import. 20 is for ArtDepPaymeny 2...