Page History
...
The VAT number must be recorded with the proper format of the ISO country code if this country code is an intra community code (ISO country code is recorded in the COUNTRY field). For example a Belgian VAT code must always been recorded with the format 0999.999.999 (with the dots).
If the VAT number is filled in then the VATCAT = '1' (liable).
If the country code is 'BE', then WinBooks will check the validity of the VAT number (check-digit). If an ISO country code is empty, Winbooks will handle it like a 'BE'.
For information, here is the format of the different pictures in WinBooks:
ISO Code | Format |
DE | 999999999 |
AT | U99999999 |
BE | 0999.999.999 |
DK | 99 99 99 99 |
ES | X9999999X |
FI | 99999999 |
FR | XX 999999999 |
EL | 99999999 |
IE | 9S99999L |
IT | 99999999999 |
LU | 99999999 |
NL | 999999999B99 |
PT | 999999999 |
GB | 999 9999 99 999 9999 99 999 |
SE | 999999999901 |
BG | 999999999 9999999999 |
CY | 99999999L |
CZ | 99999999 999999999 9999999999 |
EE | 999999999 |
HU | 99999999 |
LT | 999999999 999999999999 |
LV | 99999999999 |
MT | 99999999 |
RO | 9999999999 |
SK | 9999999999 |
SI | 99999999 |
(9 means a number, L a letter, X a letter or a digit, S a letter; a digit; "+" or "*", the other letters (U,0,1...) must be written as shown)
...
WinBooks checks the validity of each bank account number if the third form has 'BE' in the country code. An empty country code in WinBooks is considered as 'BE'. A Belgian bank account must always have the format 999-9999999-99 (with the '-'). WinBooks doesn't check the bank account number for form where the country code is different from 'BE'.
References of the tables
Fields | Definition | File | |
ZIPCODE | Postal codes | ZIPCODE.DBF | |
CURRENCY | Currencies | CURRENCY.DBF | |
CIVNAME1 et CIVNAME2 | Civil codes | TABLE.DBF | TTYPE=CIVILITY |
PAYCODE | Payment codes | TTYPE=PAYCODE | |
LANG | Languages codes | TTYPE=LANGUAGE | |
CATEGORY | Customers categories | TTYPE=CATCUS | |
Suppliers categories | TTYPE=CATSUP |
CENTRAL
Supplier or customer posting up accounts (customer posting up account = 400... , supplier posting up account = 440...). In the current version of WinBooks the multiple posting up accounts are not managed and in consequence this field can be empty.
...
Summary of the optional/mandatory fields in the ACT
Fields | Mandatory | Comment |
Doctype | X | |
DbkCode | X | |
Dbktype | Filled in by WinBooks using the DbkCode | |
Docnumber | X | |
Docorder | For financial and principal, if empty, filled in with the sequence | |
Opcode | ||
AccountGL | Mandatory if record of Non-VAT type 3 | |
AccountRP | X | If customer or supplier record |
Bookyear | Filled in with the current year | |
Period | If blank, automatically filled in with the default period | |
Date | If blank, filled in with DateDoc | |
DateDoc | X | |
DueDate | If blank, filled in with DateDoc | |
Comment | ||
Commentext | ||
Amount | X | If bookyear in BEF (if bookyear in EURO, then = 0) |
AmountEur | X | If bookyear in EURO (if bookyear in BEF, filled in by WinBooks) |
VatBase | X | If VAT records (non-empty vatcode) |
VatCode | X | Internal VAT code or encoded VAT code (WinBooks will convert) |
Curramount | ||
Currcode | ||
Cureurbase | ||
Vattax | Computed again by WinBooks : tax total for the VAT listing | |
Vatimput | ||
Currate |
D. Cost accounts files (ANF)
...