Page History
Field name | Type | Length | Dec. | Description | Example | ||
---|---|---|---|---|---|---|---|
typeTYPE | C | 1 |
| C for customer, S for supplier | "C" | ||
IDid | C | 10 |
| Code of the third (account number) | "WINBOOKS" | ||
nameNAME | C | 40 |
| Name of the company | "WinBooks SA/NV" | ||
contactCONTACT | C | 40 |
| Name of the person to contact | "Mr J-F Cuylits" | ||
languageLANGUAGE | C | 1 |
| Language code (F, N, E, | "F" | ||
curridCURRID | C | 3 |
| Currency code mostly used by the third (if empty, it's the folder currency, usually EUR) | "" | ||
categoryCATEGORY | C | 10 |
| Category of the third (free use) | "CAT1" | ||
PAYDELAYpaydelay | C | 10 |
| Payment delay (number of days followed by E for End of month or F for Fin de mois : f.i. 30E, 60, …) | "30E" | ||
PAYMODEpaymode | C | 10 |
| Code for the way of payment | "BANKTRF" | ||
VATTYPEvattype | C | 1 |
| V.A.T. type code (bound, unbound, exempt, …) - not yet implemented | "" | ||
vatnumberVATNUMBER | C | 20 |
| V.A.T. number (without the country code) | "0000.000.097" | ||
vatcountryVATCOUNTRY | C | 2 |
| V.A.T. country (code ISO2) | "BE" | ||
VATIDvatid | C | 10 |
| V.A.T. code by default (21, 6, 0, IEXP, ECEE, …)internal code of WinBooks and WinBooks on Web: f.i. "National sales at 21%" = "211400") | "211400" | ||
vatpcVATPC | N | 5 | 2 | V.A.T. % corresponding or bounded to the V.A.T. code | 21.00 | ||
centaccidCENTACCID | 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. | "" | ||
partaccidPARTACCID | C | 10 |
|
|
| "" | |
agentAGENT | C | 10 |
| Code of the agent (account manager) in charge with the third | "PETER" | ||
adrcountryADRCOUNTRY | C | 2 |
| Code ISO2 of the country (BE, FR, DE, …) | "BE" | ||
ADRZIPadrzip | C | 10 |
| Zip code | "1348" | ||
ADRCITYadrcity | C | 40 |
| City | "Louvain-La-Neuve" | ||
adrstreet1ADRSTREET1 | C | 40 |
| Street (Wow will remove comma) | "Fond Jean Pâques 6 C" | ||
adrstreet2ADRSTREET2 | C | 40 |
| Street 2 (Wow will remove comma) | "" | ||
phone1PHONE1 | C | 20 |
| Phone number | "010.45.12.44" | ||
phone2PHONE2 | C | 20 |
| Phone number 2 | "" | ||
faxFAX | C | 20 |
| Fax number | "" | ||
EMAILemail | C | 40 |
| E-mail address | "info@winbooks.be" | ||
bank1BANK1 | C | 20 |
| Bank number | "000-0000000-97" | ||
bank2BANK2 | C | 20 |
| Bank name | "Fictive Bank" | ||
MEMOblocked | ML | 41 | Comment | True (T) if the customer / supplier is blocked, False (F) else | F | ||
creditmax | N | 13 | 2 | Max credit allowed for the customer or by the supplier | 10000.00 |
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 |
...