|
|
Connectivity Manual - G/L accounts
G/L accounts
Importname: grtbk.csv
| 1
| adm-nr
| INT
| N6
| admdat
| Company
| -
| -
|
| 2
| acc-nr
| CHAR
| A9
| -
| Account
| Mandatory
| *
|
| 3
| descr
| CHAR
| A25
| -
| Description
| -
| -
|
| 4
| search-code
| CHAR
| A9
| -
| Search code
| Mandatory
| -
|
| 5
| bal-sht-pl
| CHAR
| A1
| -
| Balance sheet/P&L
| P/B
| P
|
| 6
| deb-cred
| CHAR
| A1
| -
| Debit/Credit
| D/C
| Credit
|
| 7
| subtotal-acc
| CHAR
| A1
| -
| Subtotal account
| J/N/L
| No
|
| 8
| comp-code
| CHAR
| A3
| comp
| Sub-classification
| -
| -
|
| 9
| vat-code
| CHAR
| A3
| vattrs
| VAT code
| -
| 0
|
| 10
| acc-nr-project
| LOG
| J/N
| -
| Project account
| -
| No
|
| 11
| acc-nr-cost-center
| LOG
| J/N
| -
| Cost center account
| -
| No
|
| 12
| acc-nr-cost-unit
| LOG
| J/N
| -
| Cost unit account
| -
| No
|
| 13
| qtys
| LOG
| J/N
| -
| Quantities
| -
| No
|
| 14
| acc-nr-revenue
| CHAR
| A1
| -
| Type of account
| J/O/N/K
| Neutral
|
| 15
| block
| LOG
| J/N
| -
| Block
| -
| No
|
| 16
| revalue
| LOG
| J/N
| -
| Revalue
| -
| No
|
| 17
| compress
| LOG
| J/N
| -
| Compress
| -
| No
|
| 18
| acc-nr-mdim
| LOG
| J/N
| -
| Multi Dimension Account
| -
| No
|
| 19
| assets-acc
| LOG
| J/N
| -
| Assets account
| -
| No
|
| 20
| acc-nr-cheques-be
| LOG
| J/N
| -
| Cheques/BE account
| -
| No
|
| 21
| descr-ml-1
| CHAR
| A25
| -
| ML description 1
| -
| -
|
| 22
| descr-ml-2
| CHAR
| A25
| -
| ML description 2
| -
| -
|
| 23
| descr-ml-3
| CHAR
| A25
| -
| ML description 3
| -
| -
|
| 24
| descr-ml-4
| CHAR
| A25
| -
| ML description 4
| -
| -
|
| 25
| descr-ml-5
| CHAR
| A25
| -
| ML description 5
| -
| -
|
| 26
| perc-non-deduct-vat
| DEC
| N3,2
| -
| Percentage non-deductible VAT.
| -
| -
|
| 27
| acc-nr-non-deduct-vat
| CHAR
| A9
| ledger
| Non-deductible VAT account.
| -
| -
|
| 28
| acc-nr-type
| INT
| N1
| -
| Type purchase VAT return.
| 1/2/3/4/5
| Goods
|
| 29
| note
| CHAR
| A2000
| -
| Note
| -
| - |
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.
|
| 2
| Although this field is marked as character field it is only possible to enter digits, for example 000010123.
|
| 5
| 'B' for balance sheet account, 'P' for Profit & Loss account.
|
| 6
| 'D' for debit account and 'C' for credit account. This indicates whether a general ledger account is a debit or a credit account.
|
| 7
| 'J' for Yes and 'N' for No, 'L' for empty. A subtotal account is only used for displaying purposes.
|
| 10
| 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account in a link with Exact Project C/S.
|
| 11
| 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account as a cost center account.
|
| 12
| 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account as a cost unit account.
|
| 13
| 'J' for Yes and 'N' for No. If you want to be able to enter quantities on this account, you should enter 'J' here.
|
| 14
| This field can contain the following formats:
J: Yes (imported as turnover account)
O:
Turnover account (imported as turnover account)
N: Neutral
account
K: Cost account
|
| 15
| 'J' for Yes and 'N' for No. This option can be used to prevent an entry being made on a particular account.
|
| 16
| 'J' for Yes and 'N' for No. If you want to use this account for revaluation, you should enter 'J' here.
|
| 17
| 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
|
| 18
| 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
|
| 19
| 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
|
| 20
| 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
|
| 28
| Non-deductible VAT account:
- Goods
- Services
- Investments
- No VAT update
- Always VAT update
|
Connectivity Manual - Contents
> Data import > Finance
> General ledgers
| 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.812 |
| Assortment: |
Exact Financials (v3)
|
Date: |
18-01-2007 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|