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 |