The field names in red can also be used for compatibility reason with Logistics Classic (Windows version).

Field name

Logistic
Classic 

type

len

dec..

mand-
atory 

Description

Example
LocalizedCodeLanguage C2  Language used in this file for the localized codes like Vat Code."fr"
Type

type

C

1

 

yes

C for customer, S for supplier

"C"
Code

id

C

10

 

yes

Code of the third (account number)

"BEBOP"
Name

name

C

40

 

yes

Name of the company

"BEBOP LTD"
LanguageCode

language

C

1

 

 

Language code ("F" will be translated in "fr", "N" in "nl", "E" in "en")

"en"
CurrencyCode

currid

C

3

 

 

Currency code mostly used by the third (if empty, it's the folder currency, usually EUR)

 
CategoryCode

category

C

10

 

 

Category of the third (free use)

 
PayCode

paydelay

C

10

 

 

Payment terms. For example "30 days end of month".

"30E"
PayMode

paymode

C

10

 

 

Mode of payment like Cash, Bank transfer, ...

"CASH"
VatApplicable

vattype

N

1

 

 

V.A.T. applicable:
1 - Subject to
2 - Exempt from
3 - Not subject 

1
VatNumber

vatnumber

C

20

 

 

V.A.T. number (no format, without the country code)

"0000000097"
VatCountryCode

vatcountry

C

2

 

 

V.A.T. country (code ISO2)

"BE"
VatCode

vatid

C

10

 

 

V.A.T. code by default (internal code of WinBooks and WinBooks on Web:
f.i. "National sales at 21%" = "211400" or User code in the language)

"21"
 

vatpc

N

5

2

 

V.A.T. % corresponding or bounded to the V.A.T. code

 
GLAccountCode C10  Default general account for sales (or purchase for supplier)"700000"
GLAccount2Code

centaccid

C

10

 

 

General centralising account bounded to the third if the third is not bounded to the default general account
for the customers or the suppliers.

"400000"
 

partaccid

C

10

 

 
  • not yet implemented
 
AgentCode

agent

C

10

 

 

Code of the agent (account manager) in charge with the third

"JACK"
BankIBAN *

bank1

C

20

 

 

IBAN number.
If it's an IBAN or BEBAN, save the corresponding IBAN to BankIBAN and compute if possible the BankCodeBic.
If specified, corresponding IBAN is the key to update the existing Bank account * 

"BE12 1234 5678 9012"
BankNumber **bank1C20  Bank number if not IBAN or BEBAN.
If specified, it's the key with the BankCodeBic to update the existing Bank account **
 
BankName

bank2

C

20

 

 

Bank name

 
BankCodeBic ** C20  Code BIC/SWIFT of the bank.
If specified and BankNumber is specified, it's the key to update existing Bank account **
 
IsLocked

blocked

L

1

 

 

True (T) if the customer / supplier is blocked, else False (F). By default F.

F
 creditmaxN132 Max credit allowed for the customer or by the supplier 
AddressName * C256  Name of the company at this address
The fields marked with a * in the name are key fields to identify an existing address.
If none is found for the third party, a new address is created. 
Other fields are updated. 
 
AddressAddress1 *adrstreet1C256  Street 
AddressAddress2 *adrstreet2C256  Street 2 
AddressNumber * C50  Number in the street 
AddressBox C50  box number if any 
AddressCountryCode *adrcountryC3  ISO 2 country code ("BE", "FR", "UK", ...) 
AddressZip *adrzipC50  Zip code 
AddressTown *adrcityC256  Name of the Town/City 
AddressPhoneNophone1C50  Phone number 
AddressFaxNofaxC50  Fax number 
ContactTitle * C50  

Contact for the document (if the option is activated).
The fields marked with a * in the name are key fields to identify an existing contact.
If none is found for the third party, a new contact is created. 
Other fields are updated.
If the contact is not specified, Wow will take the default contact for the type of document. 

 
ContactFirstName * C100  First name of the contact 
ContactMiddleName * C100  Middle name 
ContactLastName *contactC100  Last name 
ContactSalutation * C100  Salutation is how we address the person when starting an email. For exampe "Dear John". 
ContactLanguageCode C2  Language code. For example "en" or "fr" or "nl". 
ContactMobilePhoneNumberphone2C1022  Mobile phone number with the country prefix. For example "+32475123456". 
ContactBusinessPhoneNumber C1022  Fix phone number with the country prefix. For example "+3210451244". 
ContactBusinessEmailAddressemailC1022  Email address. For example "invoicing@mycompany.com". 
ContactSkypeIMAddress C1022  Skype ID. 
        

Example:

type,id,name,contact,language,currid,category,paydelay,paymode,vattype,vatnumber,vatcountry,vatid,vatpc,centaccid,partaccid,agent,adrcountry,adrzip,adrcity,adrstreet1,adrstreet2,phone1,phone2,fax,email,bank1,bank2,blocked,creditmax
"C","ALPHA","ALPHA SPRL","Monsieur J. FRISSON","F","","CL","",""," ","..","BE","",0.00,"","","","BE","1000","BRUXELLES 1","Rue de la Halle, 59","","0032473190551","","","info@alpha.te","000-0013595-15","",F,0.00
"C","ARTHUR","ARTHUR","","F","","RV","",""," ","0403.374.894","BE","21",0.00,"","","","BE","7000","MONS","Rue des Epingliers, 124","","065/24.06.38","","","js@winbooks.be","889-3546597-38","",F,0.00
"C","AUBEPINES","MAISON DE REPOS - LES AUBEPINES","","F","","CL","",""," ","0454.863.583","BE","21",0.00,"","","","BE","6000","CHARLEROI","Rue de la Paix, 25","","071/33.00.01","","071/33.00.02","","230-0993355-95","",F,0.00
"C","AUBIGZABAR","AU BIG ZABAR","Madame HENDRIX","F","","CL","",""," ","0430.190.248","BE","21",0.00,"","","","BE","1070","ANDERLECHT","Interleuvenlaan, 32","","02/158.69.24","","","info@bigbazar.te","694-7887330-42","",F,0.00
"C","AUDACE","AUDACE","","F","","CL","",""," ","0256.398.516","BE","21",0.00,"","","","BE","1000","BRUXELLES 1","Rue de la Coupole, 69","","02/851.36.36","","","","256-3985214-25","",F,0.00
"C","BEBOP","BE BOP sprl","Monsieur VAN DER HAEGEN","F","","CL","",""," ","0455.895.743","BE","21",0.00,"","","","BE","4650","HERVE","Rue de Welkenraedt, 54","","087/35.30.67","","087/35.41.20","info@bebop.te","455-8957434-17","",F,0.00