Connectivity Manual - VAT codes
VAT codes
File name: btwtrs.csv
1
| adm-nr
| INT
| N6
| admdat
| Company
| *
| -
|
2
| vat-code
| CHAR
| A3
|
| VAT code
| -
| -
|
3
| descr
| CHAR
| A30
|
| Description
| -
| -
|
4
| code-ps
| INT
| N1
|
| Purchase/Sales
| *
| 3
|
5
| vat-transfer
| LOG
| J/N
|
| VAT charged
| -
| N
|
6
| vat-perc
| DEC
| N3,2
|
| VAT percentage
| -
| 0
|
7
| vat-descr
| CHAR
| A16
|
| Description VAT percentage
| -
| -
|
8
| exclus
| INT
| N2
|
| Including/Excluding
| *
| -
|
9
| country
| CHAR
| A3
| countr
| Country EC sales list
| -
| -
|
10
| vat-listing
| INT
| N2
|
| EC sales list
| *
| -
|
11
| acc-nr
| CHAR
| A9
| ledger
| Account VAT to claim
| *
| -
|
12
| acc-nr-vat-sales
| CHAR
| A9
| ledger
| Account VAT to pay
| *
| -
|
13
| empty
| -
| -
| -
| -
| -
| -
|
14
| credit-note
| LOG
| J/N
|
| Credit note
| *
| -
|
15
| cred-vat-code
| CHAR
| A3
| vattrs
| VAT code credit notes
| -
| -
|
16
| empty
| -
| -
| -
| -
| -
| J
|
17
| descr-ml[1]
| CHAR
| A30
|
| ML description 1
| -
| -
|
18
| Descr-ml[2]
| CHAR
| A30
|
| ML description 2
| -
| -
|
19
| Descr-ml[3]
| CHAR
| A30
|
| ML description 3
| -
| -
|
20
| Descr-ml[4]
| CHAR
| A30
|
| ML description 4
| -
| -
|
21
| Descr-ml[5]
| CHAR
| A30
|
| ML description 5
| -
| - |
Clarification of the fields:
1
| This field is only a part of the import format, when the option 'Company number' is enabled. When this option is not enabled, this field should be skipped.
|
4
| The field should contain one of the following
values:
- Purchase
- Sales
- Both
If this field is left empty, 3 (both) will be used.
This field can not be changed, when updating existing data, but only when creating new VAT codes.
|
8
| This field should contain one of the following
values:
- Exclusive
- Inclusive
- Not needed
If this field is not filled, 3 (not needed) will be used.
|
10
| This field should contain one of the following
values:
- No VAT listing
- Listing
- Listing goods to be processed
- Dispatch process/production work
- Three way transaction
If this field is not filled and the field code-ps is set to both 1 will be entered.
|
11,12
| The accounts entered in these fields may not be empty or journal accounts.
|
11
| This field will always be made empty when 'vat-percentage' is set to 0 or the 'code-ps' is purchase.
|
12
| This field will always be made empty when 'vat-percentage' is set to 0 or the 'code-ps' is sales & vat-transfer=false.
|
14
| This functionality is only used for Belgium. If Belgian functionality is not used, then the value of this field will always be set to 'N'.
|
15
| This functionality is only used for Belgium. This
field can only be filled if the field 'credit-note' is set to
'J'. |
Connectivity Manual - Contents
> Data import > Finance
> VAT codes
Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
01.642.825 |
Assortment: |
Exact Financials (v3)
|
Date: |
18-01-2007 |
Release: |
|
Attachment: |
|
Disclaimer |