Connectivity Manual - Financial entries (Exact Financials C/S format)
Financial entries (Exact Financials C/S format)
A = All journal types
S = Sales
C = Cash
I = Giro
P = Purchase
B = Bank
G = General
File name: fentry.csv
| 1
| line-nr
| INT
| N4
| B
|
| Line number
| Mandatory
| -
| A
|
| 2
| adm-nr
| INT
| N6
| H
| eadmin
| Company number
| -
| *
| A
|
| 3
| fin-yr
| INT
| N4
| H
|
| Financial year
| -
| *
| A
|
| 4
| period
| INT
| N3
| H
|
| Period
| -
| *
| A
|
| 5
| journal-nr
| INT
| N3
| H
| journl
| Journal number
| -
| *
| A
|
| 6
| entry-nr
| INT
| N8
| B
|
| Entry number
| -
| *
| A
|
| 7
| date
| DATE
| DDMMYYYY
| B
|
| Date
| -
| *
| A
|
| 8
| descr
| CHAR
| A25
| B
|
| Description
| -
| -
| A
|
| 9
| acc-nr
| CHAR
| A9
| S
| ledger
| Account
| Mandatory
| -
| A
|
| 10
| debtor
| INT
| N8
| B
| debtor
| Debtor
| -
| -
| SCBIG
|
| 11
| creditor
| INT
| N8
| B
| credit
| Creditor
| -
| -
| PCBIG
|
| 12
| curr-code
| CHAR
| A3
| B
| curren
| Currency
| -
| *
| A
|
| 13
| EXTRA-exch-rate-type
| INT
| N1
| H
|
| Exchange rate type
| 0/1
| *
| A
|
| 14
| exch-rate
| DEC
| N5,6
| B
|
| Exchange rate
| -
| *
| A
|
| 15
| amt-curr
| DEC
| N15,2
| B
|
| Amount in currency
| Mandatory
| -
| A
|
| 16
| vat-code
| CHAR
| A3
| S
| vattrs
| VAT code
| -
| *
| SPCBI
|
| 17
| vat-amt-curr
| DEC
| N15,2
| S
|
| VAT amount in currency
| -
| -
| SPCBI
|
| 18
| rev-entry
| LOG
| Y/N
| B
|
| Reversal entry
| -
| No
| A
|
| 19
| cost-center
| CHAR
| A8
| S
| ccent
| Cost center
| -
| -
| A
|
| 20
| cost-unit
| CHAR
| A8
| S
| cunit
| Cost unit
| -
| -
| A
|
| 21
| qty
| DEC
| N10,2
| S
|
| Quantity
| -
| -
| A
|
| 22
| mcode1
| CHAR
| A8
| S
| mdim1
| Multi dimension 1
| -
| -
| A
|
| 23
| mcode2
| CHAR
| A8
| S
| mdim2
| Multi dimension 2
| -
| -
| A
|
| 24
| mcode3
| CHAR
| A8
| S
| mdim3
| Multi dimension 3
| -
| -
| A
|
| 25
| mcode4
| CHAR
| A8
| S
| mdim4
| Multi dimension 4
| -
| -
| A
|
| 26
| mcode5
| CHAR
| A8
| S
| mdim5
| Multi dimension 5
| -
| -
| A
|
| 27
| nature-movement
| CHAR
| A8
| S
| boenom
| Nature of movement
| -
| -
| B
|
| 28
| PRO-cost-center
| CHAR
| A8
| S
| ccent
| Project cost center
| -
| -
| A
|
| 29
| PRO-cost-cat-code
| CHAR
| A8
| S
| prccat
| Project cost category
| -
| -
| A
|
| 30
| PRO-project-code
| CHAR
| A8
| S
| prmst
| Project code
| -
| -
| A
|
| 31
| PRO-description
| CHAR
| A30
| S
|
| Project description
| -
| -
| A
|
| 32
| PRO-result-type
| INT
| N6
| S
|
| Project result type
| 400501/400502
| *
| A
|
| 33
| pay-ref
| CHAR
| A20
| B
|
| Payment reference
| -
| -
| A
|
| 34
| due-date-invoice
| DATE
| DDMMYYYY
| B
|
| Due date invoice 1
| -
| *
| A
|
| 35
| due-date-surch-1
| DATE
| DDMMYYYY
| B
|
| Due date payment charge/discount 1
| -
| *
| A
|
| 36
| surch-disc
| INT
| N1
| B
|
| Payment charge/discount
| 1/2
| *
| A
|
| 37
| amt-credit-surch-1
| DEC
| N15,2
| B
|
| Amount payment charge/discount 1
| -
| *
| A
|
| 38
| invoice-nr
| INT
| N8
| S
|
| Invoice number
| -
| *
| CBIG
|
| 39
| diff-code
| INT
| N2
| S
|
| Difference code
| 1/2/3/4/5
| *
| CBIG
|
| 40
| pay-method
| INT
| N1
| B
|
| Payment method
| 1/2/3/4/5/6/7/8/9/10/11
| *
| A
|
| 41
| pay-condition
| CHAR
| X(4)
| B
| paycon
| Payment condition
| -
| *
| A
|
| 42
| EXTRA-paycon-calc
| LOG
| Y/N
| H
|
| Calculation payment condition
| 0/1
| *
| SP
|
| 43
| amt-acc-nr-blocked
| DEC
| N15,2
| H
|
| Amount blocked account
| -
| *
| SP
|
| 44
| amt-credit-surch-2
| DEC
| N15,2
| B
|
| Amount payment charge/discount 2
| -
| *
| A
|
| 45
| amt-credit-surch-3
| DEC
| N15,2
| B
|
| Amount payment charge/discount 3
| -
| *
| A
|
| 46
| amt-credit-surch-4
| DEC
| N15,2
| B
|
| Amount payment charge/discount 4
| -
| *
| A
|
| 47
| amt-credit-surch-5
| DEC
| N15,2
| B
|
| Amount payment charge/discount 5
| -
| *
| A
|
| 48
| due-date-surch-2
| DATE
| DDMMYYYY
| B
|
| Due date payment charge/discount 2
| -
| *
| A
|
| 49
| due-date-surch-3
| DATE
| DDMMYYYY
| B
|
| Due date payment charge/discount 3
| -
| *
| A
|
| 50
| due-date-surch-4
| DATE
| DDMMYYYY
| B
|
| Due date payment charge/discount 4
| -
| *
| A
|
| 51
| due-date-surch-5
| DATE
| DDMMYYYY
| B
|
| Due date payment charge/discount 5
| -
| *
| A
|
| 52
| perc-1
| DEC
| N3,2
| H
|
| Percentage 1
| -
| *
| SP
|
| 53
| perc-2
| DEC
| N3,2
| H
|
| Percentage 2
| -
| *
| SP
|
| 54
| perc-3
| DEC
| N3,2
| H
|
| Percentage 3
| -
| *
| SP
|
| 55
| perc-4
| DEC
| N3,2
| H
|
| Percentage 4
| -
| *
| SP
|
| 56
| perc-5
| DEC
| N3,2
| H
|
| Percentage 5
| -
| *
| SP
|
| 57
| empty
| -
| -
| -
| -
| -
| -
| -
| SP
|
| 58
| invoice-nr-type
| INT
| N2
| S
|
| Invoice number type
| 1/3
| *
| CBIG
|
| 59
| curr-code-extra
| CHAR
| A3
| S
| curren
| Currency code outstanding item
| -
| *
| CBIG
|
| 60
| exch-rate-2
| DEC
| N5,6
| S
|
| Exchange rate outstanding item
| -
| *
| CBIG
|
| 61
| amt-curr-extra
| DEC
| N15,2
| S
|
| Amount outstanding item
| -
| *
| CBIG
|
| 62
| EXTRA-journal-type
| INT
| N2
| H
|
| Journal type
| 1/2/3/4/7/8
| *
| A
|
| 63
| open-bal
| DEC
| N15,2
| H
|
| Opening balance
| -
| *
| CBI
|
| 64
| final-bal
| DEC
| N15,2
| H
|
| Closing balance
| -
| *
| CBI |
| 65
| nr_periods_allocation
| INT
| N3
| S
|
| Number of allocation periods
| -
| 0
| A
|
| 66
| start_year_allocation
| INT
| N4
| S
|
| Start year for period allocation
| -
| *
| A
|
| 67 |
start_period_allocation
| INT
| N3
| S
|
| Starting allocation period
| -
| *
| A |
Clarification of the fields
| 1
| 0 for a headline, >0 for sub lines (1 for the first line, 2 for the second line etc.)
|
| 2
| Enter a valid company number, if this field is left empty the current company will be used
|
| 3
| If this field is left empty, the default financial year will used
|
| 4
| If this field is left empty, the default period of the date field (field 6) will be used, according the date/period table is used from the date field
|
| 5
| If this field is left empty, the EXTRA-journal-type (field 62) must be filled In that case the first available journal of the entered journal type will be used.
|
| 6
| If this field is left empty, a new entry number is generated. Only used for Cash journal
|
| 7
| If this field is left empty, the system date will be used. Not applicable in sales and purchase entries.
|
| 10
| Only needed if acc-nr (field 8) is linked to a sales journal (debtor outstanding item), otherwise ignored. Only used in the sales journal
|
| 11
| Only needed if acc-nr (field 8) is linked to a purchase journal (creditor outstanding item), otherwise ignored. Only used in the purchase journal.
|
| 12
| If not given the default currency is used
|
| 13
| If you want to use Anglo-Saxon notation (Euro notation) for exchange rates you should enter 1, if you want to use the 'old' exchange rate enter 0. If this field is left empty, the settings you defined in the financial preferences in [File, Company settings, Financial preferences] on the 'Miscellaneous' tab will be used.
|
| 14
| If this field is left empty, the rate of the day is used (field 7). Type is depending on the EXTRA-exch-rate (field 13) in the header line.
|
| 16
| If this field is left empty, '0' is filled (no vat). The VAT amount (field 17) is inclusive or exclusive the amount (field 15) according the definition in Exact (See: Maintenance VAT codes).
|
| 18
| Default is no
|
| 32
| If this field is left empty, it will automatically be filled according the given amount and journal type (field 5) in the header.
400501 = Expenses
400502 = Revenues
The field value is determined as follows:
If the journal type is purchase or general journal, the default will be expenses. If the journal type is sales, cash or bank, then the default will be revenue. If the journal type is not sales or purchase and the amount is <0 then the type will be reversed (rev to exp, exp to rev). If this field is filled with a type that does not match the default, the project amount will be reversed. (neg. to pos., pos. to neg.).
|
| 34
| If this field is left empty, then a due date is calculated according the date (field 7) and the payment condition (field 41).
|
| 35
| If EXTRA-paycon-calc (field 42) is Y then it will be automatically filled.
|
| 36
| 1 = Surcharge
2 = Discount
If this field is left empty, Surcharge (1) is used and if EXTRA-paycon-calc (field 42) is Y then the default is taken from the payment condition.
|
| 37
| If EXTRA-paycon-calc (field 42) is Y then this field will automatically be filled
|
| 38
| Invoice number of the outstanding item. If invoice-nr-type( field 58) is prepayment(3) and this field is left empty, then the first free number will be used.
|
| 39
| 1 = Do not write off
2 = Discount
3 = Surcharge
4 = Difference in payment
5 = Combination
If this field is left empty, 1 (do not write off) is used.
|
| 40
| If not specified then the payment method linked to the debtor (field 10) or creditor (field 11) is used.
1 = Cash
2 = Bank
3 = Giro
4 = Collection
5 = Acceptgiro
6 = Cheques
7 = BACS
8 = Remittance
9 = Bill of Exchange
10 = Bill of Exchange bank
11 = Periodic Collection
|
| 41
| If this field is left empty, the payment condition linked to the debtor (field 10) or creditor (field 11) will be used, if no payment condition is linked to the debtor or creditor, the payment condition of the financial preferences will be used.
|
| 42
| If set to Y then the payment calculation according to the given payment condition will be used.
|
| 44
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 45
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 46
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 47
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 48
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 49
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 50
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 51
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 52
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 53
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 54
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 55
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 56
| If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
|
| 58
| Type of invoice
1 = Normal
3 = Prepayment
If this field is left empty, 1 (normal) is used.
|
| 59
| The currency code of the outstanding item. If this field is left empty, the currency code is taken from the outstanding item. This field is only used if an existing outstanding item is modified NOT if a new outstanding item is created, then it will be ignored.
|
| 60
| The exchange rate of the outstanding item (type is according the EXTRA-exch-rate-type field 13 of the header). Field curr-code-extra (field 59) must be filled otherwise, this field will be ignored
|
| 61
| The amount in the currency of the outstanding item. Field curr-code-extra (field 59) must be filled, otherwise this field will be ignored.
|
| 62
| If journal (field 5) is not filled then this field will be used to find the journal according the given type (always the lowest journal number).
1 = Cash journal
2 = Bank journal
3 = Giro journal
4 = General journal
7 = Purchase journal
8 = Sales journal
|
| 63
| If this field is left empty, for cash journal 0 is used and for Bank and Giro journal the final-bal from the last financial entry.
|
| 64
| If this field is left empty, the final balance will be calculated. |
Connectivity Manual - Contents > Data import > Finance > Financial entries (Exact Financials C/S format)
| 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.830 |
| Assortment: |
Exact Financials (v3)
|
Date: |
28-09-2007 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|