Accounts;SOURCETYPE Accounts;DELIMITER Accounts;TEXTQUALIFIER Accounts;SHEETNAME Accounts;OPTIONS Accounts;STARTLINE Accounts;DIVISION Accounts;Accountcode --cicmpy.cmpcode Accounts;DebtorCode --cicmpy.debcode Accounts;CreditorCode --cicmpy.crdcode Accounts;AccountNumber --cicmpy.debnr or crdnr Accounts;ACCOUNTTYPE --A=Associate, B=Bank, C=Customer, D=Division, E=Employee, L=Lead, N=Not validated, P=Prospect, R=Reseller, S=Supplier, T=Suspect Accounts;STATUS --A=Active, B=Blocked, E=Inactive, N=Not validated, P=Pilot, R=Reference, S=Passive Accounts;DECIMALSEPARATOR Accounts;NAME Accounts;PHONE Accounts;PHONEEXT Accounts;FAX Accounts;EMAIL Accounts;HOMEPAGE Accounts;MANAGER Accounts;CURRENCY Accounts;GLOFFSET Accounts;GLCENTRAL Accounts;DEBTORINVOICECODE Accounts;DEBTORINVOICENUMBER Accounts;CUSTOMERCODE Accounts;BANKACCOUNT Accounts;BANKACCOUNTTYPE Accounts;BANKCURRENCY Accounts;BankName Accounts;Bankcode Accounts;Iban Accounts;SwiftCode Accounts;Bic Accounts;BANKCOUNTRY Accounts;MandateReference Accounts;MandateSignatureDate Accounts;MandateSignatureDateFormat Accounts;MandateType Accounts;MandateSort Accounts;MandateStatus Accounts;MandateLastDate Accounts;MandateLastDateFormat Accounts;MandatePaymentcondition Accounts;MandateNotes Accounts;MandateDescription Accounts;MandateOldReference Accounts;MandateOldSignatureDate Accounts;MandateOldSignatureDateFormat Accounts;MandateOldCancellationDate Accounts;MandateOldCancellationDateFormat Accounts;MandateOldBankAccount Accounts;CREDITLINE Accounts;DISCOUNTPERCENTAGE Accounts;SENDREMINDER Accounts;PRINTSTATEMENT Accounts;DATELASTREMINDER Accounts;DATELASTREMINDERDATEFORMAT Accounts;ORDERCONFIRMATION Accounts;VATCode Accounts;VATNumber Accounts;VATLIABLE Accounts;VATCheckDate Accounts;VATCheckDateFormat Accounts;VATFixedYN Accounts;VATLiability Accounts;VATExemptNumber Accounts;VATServicesCode Accounts;VATServicesFixedYN Accounts;SHOWATTENTION Accounts;DELIVERYMETHOD Accounts;PAYMENTMETHOD Accounts;PAYMENTCONDITION Accounts;Invoicemethod Accounts;Mailbox Accounts;PRICELIST Accounts;EXTRATEXT Accounts;EXEMPTNUMBER Accounts;PAYEENAME Accounts;DUNSNUMBER Accounts;CATEGORY Accounts;CATEGORY1 Accounts;CATEGORY2 Accounts;CATEGORY3 Accounts;CATEGORY4 Accounts;CATEGORY5 Accounts;CATEGORY6 Accounts;CATEGORY7 Accounts;CATEGORY8 Accounts;CATEGORY9 Accounts;CATEGORY10 Accounts;NOTE Accounts;RESELLER Accounts;PARENT Accounts;CHAMBEROFCOMMERCE Accounts;SELECTION Accounts;COMPANYSIZE Accounts;COMPANYORIGIN Accounts;COMPANYRATING Accounts;SECTOR Accounts;SUBSECTOR Accounts;ADDRESSTYPE Accounts;ADDRESSTYPEDESC Accounts;ADDRESSLINE1 Accounts;ADDRESSLINE2 Accounts;ADDRESSLINE3 Accounts;POSTALCODE Accounts;CITY Accounts;County Accounts;State Accounts;COUNTRYCODE Accounts;ADDRESSPHONE Accounts;ADDRESSFAX Accounts;ADDRESSTYPE2 Accounts;ADDRESSTYPEDESC2 Accounts;ADDRESSLINE21 Accounts;ADDRESSLINE22 Accounts;ADDRESSLINE23 Accounts;POSTALCODE2 Accounts;CITY2 Accounts;County2 Accounts;State2 Accounts;COUNTRYCODE2 Accounts;ADDRESSPHONE2 Accounts;ADDRESSFAX2 Accounts;ADDRESSTYPE3 Accounts;ADDRESSTYPEDESC3 Accounts;ADDRESSLINE31 Accounts;ADDRESSLINE32 Accounts;ADDRESSLINE33 Accounts;POSTALCODE3 Accounts;CITY3 Accounts;County3 Accounts;State3 Accounts;COUNTRYCODE3 Accounts;ADDRESSPHONE3 Accounts;ADDRESSFAX3 Accounts;ADDRESSTYPE4 Accounts;ADDRESSTYPEDESC4 Accounts;ADDRESSLINE41 Accounts;ADDRESSLINE42 Accounts;ADDRESSLINE43 Accounts;POSTALCODE4 Accounts;CITY4 Accounts;County4 Accounts;State4 Accounts;COUNTRYCODE4 Accounts;ADDRESSPHONE4 Accounts;ADDRESSFAX4 Accounts;ADDRESSTYPE5 Accounts;ADDRESSTYPEDESC5 Accounts;ADDRESSLINE51 Accounts;ADDRESSLINE52 Accounts;ADDRESSLINE53 Accounts;POSTALCODE5 Accounts;CITY5 Accounts;COUNTRYCODE5 Accounts;ADDRESSPHONE5 Accounts;ADDRESSFAX5 Accounts;ADDRESSTYPE6 Accounts;ADDRESSTYPEDESC6 Accounts;ADDRESSLINE61 Accounts;ADDRESSLINE62 Accounts;ADDRESSLINE63 Accounts;POSTALCODE6 Accounts;CITY6 Accounts;COUNTRYCODE6 Accounts;ADDRESSPHONE6 Accounts;ADDRESSFAX6 Accounts;ADDRESSTYPE7 Accounts;ADDRESSTYPEDESC7 Accounts;ADDRESSLINE71 Accounts;ADDRESSLINE72 Accounts;ADDRESSLINE73 Accounts;POSTALCODE7 Accounts;CITY7 Accounts;COUNTRYCODE7 Accounts;ADDRESSPHONE7 Accounts;ADDRESSFAX7 Accounts;ADDRESSTYPE8 Accounts;ADDRESSTYPEDESC8 Accounts;ADDRESSLINE81 Accounts;ADDRESSLINE82 Accounts;ADDRESSLINE83 Accounts;POSTALCODE8 Accounts;CITY8 Accounts;COUNTRYCODE8 Accounts;ADDRESSPHONE8 Accounts;ADDRESSFAX8 Accounts;FREETEXT1 Accounts;FREETEXT2 Accounts;FREETEXT3 Accounts;FREETEXT4 Accounts;FREETEXT5 Accounts;FREETEXT6 Accounts;FREETEXT7 Accounts;FREETEXT8; Accounts;FREETEXT9; Accounts;FREETEXT10; Accounts;FREENUMBER1 Accounts;FREENUMBER2 Accounts;FREENUMBER3 Accounts;FREENUMBER4 Accounts;FREENUMBER5 Accounts;FREEYESNO1 Accounts;FREEYESNO2 Accounts;FREEYESNO3 Accounts;FREEYESNO4 Accounts;FREEYESNO5 Accounts;PERSONLASTNAME; Accounts;PERSONFIRSTNAME Accounts;PERSONMIDDLENAME; Accounts;PERSONINITIALS Accounts;PERSONTITELCODE Accounts;PERSONGENDER Accounts;DEFAULTYN --- Accounts;DEFAULTYN; 1 OR 0 (1 = DEFAULT YES) Accounts;PERSONSTATUS; --- A=Active, E=Exit --IMPORTANT: --In Exact each account requires minimum one active main contact person. If no contact person is available the PERSONLASTNAME can be set to "--". --Also the DEFAULTYN should be set to "1" to indicate that this is the main contact person of the account. --The person should be set to status Active by PERSONSTATUS="A" --The main contact person should have all four address types: INV, VIS, POS and DEL. (invoice, visit, postal, delivery) --For non main contact persons the POS address is mandatory and DEL is optional. INV and VIS are not posible here. Accounts;JOBTITLE; Accounts;MOBILESHORTCUT Accounts;WEBACCESS Accounts;PERSONACCOUNTMANAGER Accounts;PERSONLANGUAGE Accounts;PERSONJOBDESCRIPTION; Accounts;PERSONPHONE Accounts;PERSONFAX Accounts;PERSONMOBILE Accounts;PERSONEMAIL --- WHEN LEFT EMPTY ACCOUNT ADDRESS DATA WILL BE COPIED INTO CONTACT ADDRESSES Accounts;ADDRESSTYPECP; Accounts;ADDRESSTYPEDESCCP Accounts;ADDRESSLINE1CP; Accounts;ADDRESSLINE2CP Accounts;ADDRESSLINE3CP Accounts;POSTALCODECP; Accounts;CITYCP; Accounts;COUNTRYCODECP Accounts;ADDRESSPHONECP Accounts;ADDRESSFAXCP Accounts;ADDRESSTYPECP2; Accounts;ADDRESSTYPEDESCCP2 Accounts;ADDRESSLINE1CP2; Accounts;ADDRESSLINE2CP2 Accounts;ADDRESSLINE3CP2 Accounts;POSTALCODECP2; Accounts;CITYCP2; Accounts;COUNTRYCODECP2; Accounts;ADDRESSPHONECP2 Accounts;ADDRESSFAXCP2 Accounts;ADDRESSTYPECP3 Accounts;ADDRESSTYPEDESCCP3 Accounts;ADDRESSLINE1CP3 Accounts;ADDRESSLINE2CP3 Accounts;ADDRESSLINE3CP3 Accounts;POSTALCODECP3 Accounts;CITYCP3 Accounts;COUNTRYCODECP3 Accounts;ADDRESSPHONECP3 Accounts;ADDRESSFAXCP3 Accounts;ADDRESSTYPECP4 Accounts;ADDRESSTYPEDESCCP4 Accounts;ADDRESSLINE1CP4 Accounts;ADDRESSLINE2CP4 Accounts;ADDRESSLINE3CP4 Accounts;POSTALCODECP4 Accounts;CITYCP4 Accounts;COUNTRYCODECP4 Accounts;ADDRESSPHONECP4 Accounts;ADDRESSFAXCP4 Accounts;ADDRESSTYPECP5 Accounts;ADDRESSTYPEDESCCP5 Accounts;ADDRESSLINE1CP5 Accounts;ADDRESSLINE2CP5 Accounts;ADDRESSLINE3CP5 Accounts;POSTALCODECP5 Accounts;CITYCP5 Accounts;COUNTRYCODECP5 Accounts;ADDRESSPHONECP5 Accounts;ADDRESSFAXCP5 Accounts;ADDRESSTYPECP6 Accounts;ADDRESSTYPEDESCCP6 Accounts;ADDRESSLINE1CP6 Accounts;ADDRESSLINE2CP6 Accounts;ADDRESSLINE3CP6 Accounts;POSTALCODECP6 Accounts;CITYCP6 Accounts;COUNTRYCODECP6 Accounts;ADDRESSPHONECP6 Accounts;ADDRESSFAXCP6 Accounts;ADDRESSTYPECP7 Accounts;ADDRESSTYPEDESCCP7 Accounts;ADDRESSLINE1CP7 Accounts;ADDRESSLINE2CP7 Accounts;ADDRESSLINE3CP7 Accounts;POSTALCODECP7 Accounts;CITYCP7 Accounts;COUNTRYCODECP7 Accounts;ADDRESSPHONECP7 Accounts;ADDRESSFAXCP7 Accounts;ADDRESSTYPECP8 Accounts;ADDRESSTYPEDESCCP8 Accounts;ADDRESSLINE1CP8 Accounts;ADDRESSLINE2CP8 Accounts;ADDRESSLINE3CP8 Accounts;POSTALCODECP8 Accounts;CITYCP8 Accounts;COUNTRYCODECP8 Accounts;ADDRESSPHONECP8 Accounts;ADDRESSFAXCP8 --contact persron freefields Accounts;FREETEXT1CP Accounts;FREETEXT2CP Accounts;FREETEXT3CP Accounts;FREETEXT4CP Accounts;FREETEXT5CP Accounts;FREETEXT6CP Accounts;FREETEXT7CP Accounts;FREETEXT8CP Accounts;FREETEXT9CP Accounts;FREETEXT10CP Accounts;FREENUMBER1CP Accounts;FREENUMBER2CP Accounts;FREENUMBER3CP Accounts;FREENUMBER4CP Accounts;FREENUMBER5CP Accounts;FREEYESNO1CP Accounts;FREEYESNO2CP Accounts;FREEYESNO3CP Accounts;FREEYESNO4CP Accounts;FREEYESNO5CP Accounts;FREEDATE1CP Accounts;FREEDATE1CPFORMAT Accounts;FREEDATE2CP Accounts;FREEDATE2CPFORMAT Accounts;FREEDATE3CP Accounts;FREEDATE3CPFORMAT Accounts;FREEDATE4CP Accounts;FREEDATE4CPFORMAT Accounts;FREEDATE5CP Accounts;FREEDATE5CPFORMAT Accounts;Freetext1 Accounts;Freetext2 Accounts;Freetext3 Accounts;Freetext4 Accounts;Freetext5 Accounts;Freetext6 Accounts;Freetext7 Accounts;Freetext8 Accounts;Freetext9 Accounts;Freetext10 Accounts;Freetext11 Accounts;Freetext12 Accounts;Freetext13 Accounts;Freetext14 Accounts;Freetext15 Accounts;Freetext16 Accounts;Freetext17 Accounts;Freetext18 Accounts;Freetext19 Accounts;Freetext20 Accounts;Freetext21 Accounts;Freetext22 Accounts;Freetext23 Accounts;Freetext24 Accounts;Freetext25 Accounts;Freetext26 Accounts;Freetext27 Accounts;Freetext28 Accounts;Freetext29 Accounts;Freetext30 Accounts;Freenumber1 Accounts;Freenumber2 Accounts;Freenumber3 Accounts;Freenumber4 Accounts;Freenumber5 Accounts;Freenumber6 Accounts;Freenumber7 Accounts;Freenumber8 Accounts;Freenumber9 Accounts;Freenumber10 Accounts;Freenumber11 Accounts;Freenumber12 Accounts;Freenumber13 Accounts;Freenumber14 Accounts;Freenumber15 Accounts;Freenumber16 Accounts;Freenumber17 Accounts;Freenumber18 Accounts;Freenumber19 Accounts;Freenumber20 Accounts;FreeYesNo1 Accounts;FreeYesNo2 Accounts;FreeYesNo3 Accounts;FreeYesNo4 Accounts;FreeYesNo5 Accounts;FREEDATE1 Accounts;FREEDATE1FORMAT Accounts;FREEDATE2 Accounts;FREEDATE2FORMAT Accounts;FREEDATE3 Accounts;FREEDATE3FORMAT Accounts;FREEDATE4 Accounts;FREEDATE4FORMAT Accounts;FREEDATE5 Accounts;FREEDATE5FORMAT
Doc id: 00.001.060