Page History
...
Field name | Logistic | type | len | dec.. | mand- atory | Description | Example | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LocalizedCodeLanguage | C | 2 | 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 | ||||||||||||
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 | C | 10 | 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 |
|
| ||||||||||||||
AgentCode | agent | C | 10 |
| Code of the agent (account manager) in charge with the third | InvoicingAddressName * | ||||||||||||
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 * | C | 256 | Street | |||||||||||||||
InvoicingAddressAddress2 * | C | 256 | Street 2 | |||||||||||||||
InvoicingAddressNumber * | C | 50 | Number in the street | |||||||||||||||
InvoicingAddressBox | C | 50 | box number if any | |||||||||||||||
InvoicingAddressCountryCode * | C | 3 | ISO 2 country code ("BE", "FR", "UK", ...) | |||||||||||||||
InvoicingAddressZip * | C | 50 | Zip code | |||||||||||||||
InvoicingAddressTown * | C | 256 | Name of the Town/City | |||||||||||||||
InvoicingAddressPhoneNo | C | 50 | Phone number | |||||||||||||||
InvoicingAddressFaxNo | C | 50 | Fax number | |||||||||||||||
IBAN number. If it's an IBAN or BEBAN, save the corresponding IBAN to BankIBAN and compute if possible the BankCodeBic. | ||||||||||||||||||
BankNumber | bank1 | C | phone2 | C | 20 | Phone number 2 | 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 | |||||||||||||
creditmax | N | 13 | 2 | Max credit allowed for the customer or by the supplier | ||||||||||||||
AddressName * | C | 256 | 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 * | adrstreet1 | C | 256 | Street | ||||||||||||||
AddressAddress2 * | adrstreet2 | C | 256 | Street 2 | ||||||||||||||
AddressNumber * | C | 50 | Number in the street | |||||||||||||||
AddressBox | C | 50 | box number if any | |||||||||||||||
AddressCountryCode * | adrcountry | C | 3 | ISO 2 country code ("BE", "FR", "UK", ...) | ||||||||||||||
AddressZip * | adrzip | C | 50 | Zip code | ||||||||||||||
AddressTown * | adrcity | C | 256 | Name of the Town/City | ||||||||||||||
AddressPhoneNo | phone1 | C | 50 | Phone number | ||||||||||||||
AddressFaxNo | fax | C | 50 | Fax number | ||||||||||||||
ContactTitle * | C | 50 | Contact for the document (if the option is activated). | |||||||||||||||
ContactFirstName * | C | 100 | First name of the contact | |||||||||||||||
ContactMiddleName * | C | 100 | Middle name | |||||||||||||||
ContactLastName * | contact | C | 100 | Last name | ||||||||||||||
ContactSalutation * | C | 100 | Salutation is how we address the person when starting an email. For exampe "Dear John". | |||||||||||||||
ContactLanguageCode | C | 2 | Language code. For example "en" or "fr" or "nl". | |||||||||||||||
ContactMobilePhoneNumber | phone2 | C | 1022 | Mobile phone number with the country prefix. For example "+32475123456". | ||||||||||||||
ContactBusinessPhoneNumber | C | 1022 | Fix phone number with the country prefix. For example "+3210451244". | |||||||||||||||
ContactBusinessEmailAddress | C | 1022 | Email address. For example "invoicing@mycompany.com". | |||||||||||||||
ContactSkypeIMAddress | C | 1022 | Skype ID. | |||||||||||||||
...