The field names in red can also be used for compatibility reason with Logistics Classic (Windows version).
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: | "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 | "400000" | |
partaccid | C | 10 |
|
| |||
AgentCode | agent | C | 10 |
| Code of the agent (account manager) in charge with the third | "JACK" | |
BankIBAN * | bank1 | C | 20 |
| IBAN number. | "BE12 1234 5678 9012" | |
BankNumber ** | bank1 | C | 20 | 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 ** | C | 20 | 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 | |
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. | ||||
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 |