Versions Compared

Key

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

...

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

CN

1

 

 

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

 

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 (400000 f.i.) 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

 
InvoicingAddressName * adrcountryC2256  

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)

 
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. 
 
InvoicingAddressAddress1 * C256  Street 
InvoicingAddressAddress2 * C256  Street 2 
InvoicingAddressNumber * C50  Number in the street 
InvoicingAddressBox C50  box number if any 
InvoicingAddressCountryCode * C3  ISO 2 country code ("BE", "FR", "UK", ...) 
InvoicingAddressZip * C50  Zip code 
InvoicingAddressTown * C256  Name of the Town/City 
InvoicingAddressPhoneNo C50 

phone1

C

20  Phone number 
InvoicingAddressFaxNo 

phone2

C2050  Phone Fax number 2 
 

faxphone2

C

20

 

 

Fax Phone number 2

 
 

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 
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 * 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. 
        

...