One moment please...
 
 
Exact Financials   
 

Connectivity Manual - IFALL - Project budgets

Project budgets

As of version 3.21 it is possible to import project budgets via EDIS. We have added 8 tables to the script for application 'EXACT'. In the tables below you see the fields that have been added to application 'EXACT' including their data types and field lengths. The new EDIS script is automatically imported when upgrading to version 3.21.

Budgets per cost category (PRRCCA)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 COST_CAT_CODE Character 8 prccat Cost category -
5 COST_CENTER Character 8 ccent Cost center -
6 CHANGE_TYPE Integer 6 2 Original/current -
7 BUDGET_QUANTITY Decimal 15 - Budget quantity -
8 BUDGET_AMOUNT Decimal 15 - Budget amount -
9 DATE_CHANGE Date 8 - Date of change -
10 REASON_CHANGE Character 30 - Reason of change -

Budgets per cost category / period (PRRCYP)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 YEAR Integer 4 - Year -
5 PERIOD Integer 3 - Period -
6 COST_CAT_CODE Character 8 prccat Cost category -
7 COST_CENTER Character 8 ccent Cost center -
8 CHANGE_TYPE Integer 6 2 Original/current -
9 BUDGET_QUANTITY Decimal 15 - Budget quantity -
10 BUDGET_AMOUNT Decimal 15 - Budget amount -
11 DATE_CHANGE Date 8 - Date of change -
12 REASON_CHANGE Character 30 - Reason of change -

Budgets per employee (PRRHCA)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 EMPLOYEE_CODE Character 8 premp Employee -
5 HOUR_CAT_CODE Character 8 prhcat Hour category -
6 COST_CAT_CODE Character 8 prccat Cost category -
7 COST_CENTER Character 8 ccent Cost center -
8 CHANGE_TYPE Integer 6 2 Original/current -
9 BUDGET_QUANTITY Decimal 15 - Budget quantity -
10 BUDGET_AMOUNT Decimal 15 - Budget amount -
11 DATE_CHANGE Date 8 - Date of change -
12 REASON_CHANGE Character 30 - Reason of change -

Budgets per employee / period (PRRHYP)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 YEAR Integer 4 - Year -
5 PERIOD Integer 3 - Period -
6 EMPLOYEE_CODE Character 8 premp Employee -
7 HOUR_CAT_CODE Character 8 prhcat Hour category -
8 COST_CAT_CODE Character 8 prccat Cost category -
9 COST_CENTER Character 8 ccent Cost center -
10 CHANGE_TYPE Integer 6 2 Original/current -
11 BUDGET_QUANTITY Decimal 15 - Budget quantity -
12 BUDGET_AMOUNT Decimal 15 - Budget amount -
13 DATE_CHANGE Date 8 - Date of change -
14 REASON_CHANGE Character 30 - Reason of change -

Budgets per item (PRRITM)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 ITEM_CODE Character 20 llitem Item -
5 COST_CAT_CODE Character 8 prccat Cost category -
6 COST_CENTER Character 8 ccent Cost center -
7 CHANGE_TYPE Integer 6 2 Original/current -
8 BUDGET_QUANTITY Decimal 15 - Budget quantity -
9 BUDGET_AMOUNT Decimal 15 - Budget amount -
10 DATE_CHANGE Date 8 - Date of change -
11 REASON_CHANGE Character 30 - Reason of change -

Budgets per item / period (PRRIYP)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 YEAR Integer 4 - Year -
5 PERIOD Integer 3 - Period -
6 ITEM_CODE Character 20 llitem Item -
7 COST_CAT_CODE Character 8 prccat Cost category -
8 COST_CENTER Character 8 ccent Cost center -
9 CHANGE_TYPE Integer 6 2 Original/current -
10 BUDGET_QUANTITY Decimal 15 - Budget quantity -
11 BUDGET_AMOUNT Decimal 15 - Budget amount -
12 DATE_CHANGE Date 8 - Date of change -
13 REASON_CHANGE Character 30 - Reason of change -

Budget per machinery (PRRMCH)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 MACHINERY_CODE Character 8 prmach Machinery -
5 UNIT_CODE Character 8 prunit Unit -
6 COST_CAT_CODE Character 8 prccat Cost category -
7 COST_CENTER Character 8 ccent Cost center -
8 CHANGE_TYPE Integer 6 2 Original/current -
9 BUDGET_QUANTITY Decimal 15 - Budget quantity -
10 BUDGET_AMOUNT Decimal 15 - Budget amount -
11 DATE_CHANGE Date 8 - Date of change -
12 REASON_CHANGE Character 30 - Reason of change -

Budget per machinery / period (PRRMYP)

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company -
2 PROJECT_CODE Character 10 prmst Project -
3 RESULT_TYPE Integer 6 1 Result type -
4 YEAR Integer 4 - Year -
5 PERIOD Integer 3 - Period -
6 MACHINERY_CODE Character 8 prmach Employee -
7 UNIT_CODE Character 8 prunit Machinery -
8 COST_CAT_CODE Character 8 prccat Unit -
9 COST_CENTER Character 8 ccent Cost center -
10 CHANGE_TYPE Integer 6 2 Original/current -
11 BUDGET_QUANTITY Decimal 15 - Budget quantity -
12 BUDGET_AMOUNT Decimal 15 - Budget amount -
13 DATE_CHANGE Date 8 - Date of change -
14 REASON_CHANGE Character 30 - Reason of change -
  1. 400501: expenses
    400502: revenues
  2. 403001: original
    403002: current
Connectivity Manual > Contents > IFALL > Project > Project budgets

     
 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.330.345
 Assortment: Exact Financials  Date: 03-12-2008
 Release:  Attachment:
 Disclaimer