Versions Compared

Key

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

...

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

 
BankIBAN 

bank1

C

256

20

 

 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  Phone number 
InvoicingAddressFaxNo C50  Fax number 

IBAN number. If it's an IBAN or BEBAN, save the corresponding IBAN to BankIBAN and compute if possible the BankCodeBic.

 
BankNumberbank1C 

phone2

C

20  

Phone number 2

  

email

C

40

 

 

E-mail address

 
 

bank1

C

20

 

 

Bank number

 
BankName 

bank2

C

20

 

 

Bank name

  
IsLocked

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 * 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". 
ContactMobilePhoneNumber phone2C1022  Mobile phone number with the country prefix. For example "+32475123456". 
ContactBusinessPhoneNumber C1022  Fix phone number with the country prefix. For example "+3210451244". 
ContactBusinessEmailAddress emailC1022  Email address. For example "invoicing@mycompany.com". 
ContactSkypeIMAddress C1022  Skype ID. 
        

...