Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field name

Logistic
Classic 

Typetype

Lengthlen

Decdec..

mand-
atory 

Description

Example
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

Contact

contact

C

40

 

Name of the person to contact

"BEBOP LTD"
LanguageCode 

language

C

1

 

 

Language code ("F" will be translated in "fr", "N" in "nl", E,"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 delay (number of days followed by E for End of month or F for Fin de mois : f.i. 30E, 60, …)terms. For example "30 days end of month".

"30E"
PayMode 

paymode

C

10

 

Code for the way of payment

 

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

"CASH"
 

vattype

C

1

 

 

V.A.T. type code (bound, unbound, exempt, …) - not yet implemented

 
 

vatnumber

C

20

 

 

V.A.T. number (without the country code)

 
 

vatcountry

C

2

 

 

V.A.T. country (code ISO2)

 
 

vatid

C

10

 

 

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

 
 

vatpc

N

5

2

 

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

 
 

centaccid

C

10

 

 

General account (400000 f.i.) bounded to the third if the third is not bounded to the default general account for the customers or the suppliers.

 
 

partaccid

C

10

 

 
  • not yet implemented
 
 

agent

C

10

 

 

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

 
 

adrcountry

C

2

 

 

Code ISO2 of the country (BE, FR, DE, …)

 
 

adrzip

C

10

 

 

Zip code

 
 

adrcity

C

40

 

 

City

 
 

adrstreet1

C

40

 

 

Street (Wow will remove comma)

 
 

adrstreet2

C

40

 

 

Street 2 (Wow will remove comma)

 
 

phone1

C

20

 

 

Phone number

 
 

phone2

C

20

 

 

Phone number 2

 
 

fax

C

20

 

 

Fax number

 
 

email

C

40

 

 

E-mail address

 
 

bank1

C

20

 

 

Bank number

 
 

bank2

C

20

 

 

Bank name

 
 

blocked

L

1

 

 

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

 
 creditmaxN132 Max credit allowed for the customer or by the supplier 
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 * C100  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". 
ContactMobilePhoneNumber C1022  Mobile phone number with the country prefix. For example "+32475123456". 
ContactBusinessPhoneNumber C1022  Fix phone number with the country prefix. For example "+3210451244". 
ContactBusinessEmailAddress C1022  Email address. For example "invoicing@mycompany.com". 
ContactSkypeIMAddress C1022  Skype ID. 
        

Example:

Panel
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

...