One moment please...
 

Account import IDF (Debtor and Creditor)

 

Accounts;Startline
Accounts;Delimiter
Accounts;Textqualifier
Accounts;Sheetname
Accounts;Division
Accounts;Adm
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;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;BankCurrency;
Accounts;BankAccounttype;
Accounts;BankName;
Accounts;Bankcode;
Accounts;Iban;
Accounts;SwiftCode;
Accounts;Bic;
Accounts;Bankcountry;
Accounts;MandateReference;
Accounts;MandateSignatureDate;
Accounts;MandateSignatureDateFormat;
Accounts;MandateType;
--(B2B Core COR1)
Accounts;MandateSort;
--(FRST FNAL OOFF RCUR)
Accounts;MandateStatus;
--(A Active, B Blocked, D Draft, E Expired)
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;VATNumber
Accounts;VATCode
Accounts;VATCheckDate;
Accounts;VATCheckDateFormat;
Accounts;VATFixedYN;
Accounts;VATLiability;
Accounts;VATExemptNumber;
Accounts;VATServicesCode;
Accounts;VATServicesFixedYN;
Accounts;ShowAttention
Accounts;Paymentmethod
Accounts;Paymentcondition
Accounts;Deliverymethod
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;LOOKUPCOMPANYSIZE
Accounts;CompanyOrigin
Accounts;LOOKUPCOMPANYORIGIN
Accounts;CompanyRating
Accounts;Sector
Accounts;LOOKUPCOMPANYSECTOR
Accounts;SubSector
Accounts;LOOKUPCOMPANYSUBSECTOR
Accounts;DefaultYN
--Accounts;DefaultYN="1" or "0"
Accounts;JobTitle
Accounts;MobileShortcut
Accounts;WebAccess
Accounts;PersonLastname
Accounts;PersonFirstname
Accounts;PersonMiddlename
Accounts;PersonInitials
Accounts;PersonTitelcode
Accounts;PersonGender
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;PersonAccountmanager
Accounts;PersonLanguage
Accounts;PersonJobdescription
Accounts;PersonPhone
Accounts;PersonFax
Accounts;PersonMobile
Accounts;PersonEmail
Accounts;PERSONSTATUS;
--A=Active, E=Exit
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.004.764