One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Hour entries

File name: prhentry.csv

No Field name Type Format H/S/B Ref Description Remarks Default
1 adm_nr INT N6 B admdat Company number Mandatory -
2 line_nr INT N4 B - Line number 0 for header -
3 entry_nr INT N8 H - Entry number - ?= first available
4 employee_code CHAR A8 H premp Employee Mandatory -
5 check_total DEC N9,2 H - Check total - -
6 result_type INT N6 H - Result type 400501/400502 400501
7 input_type INT N6 H - Input type Mandatory

400401/400402

 -
8 description CHAR A30 B - Description - -
9 date DATE DD/MM/YYYY S - Date - ?=system date
10 project_code CHAR A10 S prmst Project code Mandatory -
11 qty DEC N9,2 S - Quantity - -
12 hour_cat_code CHAR A8 S prhcat Hour category - -
13 seqnr_practv INT N5 S practv Activity - -
14 cost_center CHAR A8 S ccent Cost center Mandatory *
15 cost_unit CHAR A8 S cunit Cost unit - *

Clarification of the fields:

Field Clarification
5 The use of this field depends on the project settings. In the settings you can define whether you want to be able to check the total. When you set this option to mandatory, this field has to be filled. You can also enter a '?' to use the default value.
6 For costs enter 400501, for revenues enter 400502. If this field is left empty, costs (400501) will be used as default.
7 You should enter 400401 for standard entries and 400402 for schedule entries.
9 When entering a '?', the current date will be used.
12 Only used when an entry is made for Employee schedule expenses. In that case this field replaces the field 'Hour category'.
14 If in your settings you have defined in you settings that you want to be able to change the cost center when making an entry, then every cost center can be entered here. If you stated that changing the cost center is not allowed, you will have to use the cost center you defined on the project master card. A '?' can be used to use the default value of the project master card.
15 The cost unit of the project master card should be entered here. If you enter a '?', Exact Financials will retrieve this cost unit automatically.

Connectivity > Data import > Available import formats > Project > Hour entries

     
 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: 18.325.037
 Assortment: Exact Financials  Date: 03-10-2015
 Release:  Attachment:
 Disclaimer