Connectivity Manual - Commitments
Commitments
File name: commitm.csv
| 1
| line-nr-lis
| INT
| N4
| B
|
| Line no
| Mandatory
| -
|
| 2
| commitment_nr
| INT
| N8
| B
|
| Commitment number
| Mandatory
| -
|
| 3
| creditor
| INT
| N8
| S
| credit
| Creditor
| Mandatory
| -
|
| 4
| fin-yr
| INT
| N4
| S
|
| Financial year
| Mandatory
| -
|
| 5
| acc-nr
| CHAR
| A9
| S
| ledger
| Account
| Mandatory
| -
|
| 6
| amt_cur
| DEC
| N15,2
| S
|
| Amount FC
| Mandatory
| -
|
| 7
| descr
| CHAR
| A30
| B
|
| Description
| -
| -
|
| 8
| search_code
| CHAR
| A9
| H
|
| Search code
| -
| -
|
| 9
| class
| CHAR
| X2
| H
| comcls
| Classification
| -
| -
|
| 10
| block
| LOG
| J/N
| B
|
| Block
| -
| No
|
| 11
| cost-center
| CHAR
| A8
| S
| ccent
| Cost center
| -
| -
|
| 12
| cost-unit
| CHAR
| A8
| S
| cunit
| Cost unit
| -
| -
|
| 13
| qty
| DEC
| N10,2
| S
|
| Quantity
| -
| -
|
| 14
| mcode1
| CHAR
| A8
| S
| mdim1
| Multi dimension 1
| -
| -
|
| 15
| mcode2
| CHAR
| A8
| S
| mdim2
| Multi dimension 2
| -
| -
|
| 16
| mcode3
| CHAR
| A8
| S
| mdim3
| Multi dimension 3
| -
| -
|
| 17
| mcode4
| CHAR
| A8
| S
| mdim4
| Multi dimension 4
| -
| -
|
| 18
| mcode5
| CHAR
| A8
| S
| mdim5
| Multi dimension 5
| -
| -
|
| 19
| PRO-project_code
| CHAR
| A10
| S
| prmst
| Project code
| -
| -
|
| 20
| PRO_cost_cat
| CHAR
| A8
| S
| prcat
| Project cost category
| -
| -
|
| 21
| PRO_cost_center
| CHAR
| A8
| S
| ccent
| Project cost center
| -
| -
|
| 22
| PRO_qty
| DEC
| N10,2
| S
|
| Project quantity
| -
| -
|
| 23
| cntr_nr
| CHAR
| A8
| S
| comctr
| Contract number
| -
| -
|
| 24
| request_date
| DATE
| DDMMYYYY
| S
|
| Entry date
| -
| -
|
| 25
| start_date
| DATE
| DDMMYYYY
| S
|
| Start date
| -
| -
|
| 26
| end_date
| DATE
| DDMMYYYY
| S
|
| End date
| -
| -
|
| 27
| curr-code
| CHAR
| A3
| S
| curren
| Currency
| -
| -
|
| 28
| exch_rate
| DEC
| N5,6
| S
|
| Exchange rate
| -
| -
|
| 29
| EXTRA-exch-rate-type
| INT
| N1
| H
|
| Rate format
| 0/1
| * |
Clarification of the fields
| 1
| 0 for headers, >0 for sublines (1 for the first line, 2 for the second line etc.)
|
| 19-22
| These fields will only need to be filled if you defined in [File, Company settings, Financial preferences] that a project link is optional or mandatory and the enty concerns a project account. In case you have set this option to 'Optional' it is possible to import project data. In case you have set this option to 'Mandatory' the entry will be rejected if you do not enter project data or the project data is not appropriately filled.
|
| 29
| 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.
NOTE: as of version 3.50 this fields is no longer supported. |
Connectivity Manual C/S - Contents > Data import > Exact Finance C/S > Formats > Commitments
| 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.828 |
| Assortment: |
Exact Financials (v3)
|
Date: |
14-09-2007 |
| Release: |
|
Attachment: |
|
| Disclaimer |