One moment please...
 
 
Exact Financials   
 

Data dictionary prrhyp - Result hcat per period - 7.20

#Field nameData typeFormatDecExtentDefaultLabel
1adm_nrinteger>>>>>9 ?Company
2project_codecharacterx(12) ?Project
3cost_cat_codecharacterx(12) ?Cost category
4cost_centercharacterx(12) ?Cost center
5employee_codecharacterX(12) ?Employee
6hour_cat_codecharacterx(12) ?Hour category
7result_typeinteger>>>>>9 ?Result type
8yearinteger9999 ?Year
9periodinteger>>9 ?Period
10bud_qtydecimal->>>,>>>,>>9.992 0Budget quantity
11bud_amtdecimal->>>,>>>,>>9.992 0Budget amount
12real_qtydecimal->>>,>>>,>>9.992 0Actual quantity
13real_amt_intdecimal->>>,>>>,>>9.992 0Actual internal amount
14real_amt_extdecimal->>>,>>>,>>9.992 0Actual external amount
15real_amt_int_defdecimal->>>,>>>,>>9.992 0Actual internal amount DC
16real_amt_ext_defdecimal->>>,>>>,>>9.992 0Actual external amount DC
17euserid_crcharacterX(12) User creation
18date_crdate99/99/9999 Date creation
19time_crinteger>>>>>9 ?Time creation
20source_crcharacterX(40) Source creation
21euserid_lccharacterX(12) User last changed
22date_lcdate99/99/9999 Date last changed
23time_lcinteger>>>>>9 ?Time last changed
24source_lccharacterX(40) Source last changed
25fore_qtydecimal->>>,>>>,>>9.992 0Forecast quantity
26fore_amtdecimal->>>,>>>,>>9.992 0Forecast amount
27fore_amt_defdecimal->>>,>>>,>>9.992 0Forecast amount DC
28bud_amt_defdecimal->>>,>>>,>>9.992 0Budget amount DC
29wip_amount_fcdecimal->>>,>>>,>>>,>>>,>>9.992 0Amount
30wip_amount_dcdecimal->>>,>>>,>>>,>>>,>>9.992 0Amount

Indexes

prrhypix - primary - unique

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2project_codecharacterx(12)Project
3result_typeinteger>>>>>9Result type
4yearinteger9999Year
5periodinteger>>9Period
6employee_codecharacterX(12)Employee
7hour_cat_codecharacterx(12)Hour category
8cost_cat_codecharacterx(12)Cost category
9cost_centercharacterx(12)Cost center

prrhyp2ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2cost_centercharacterx(12)Cost center
3employee_codecharacterX(12)Employee
4yearinteger9999Year
5periodinteger>>9Period
6cost_cat_codecharacterx(12)Cost category
7project_codecharacterx(12)Project
8hour_cat_codecharacterx(12)Hour category
9result_typeinteger>>>>>9Result type

prrhyp3ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2cost_cat_codecharacterx(12)Cost category
3project_codecharacterx(12)Project
4result_typeinteger>>>>>9Result type
5cost_centercharacterx(12)Cost center
6yearinteger9999Year
7periodinteger>>9Period
8employee_codecharacterX(12)Employee
9hour_cat_codecharacterx(12)Hour category

prrhyp4ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2cost_centercharacterx(12)Cost center
3employee_codecharacterX(12)Employee
4cost_cat_codecharacterx(12)Cost category
5project_codecharacterx(12)Project
6result_typeinteger>>>>>9Result type
7hour_cat_codecharacterx(12)Hour category
8yearinteger9999Year
9periodinteger>>9Period

prrhyp8ix

#Field nameData typeFormatDescription
1adm_nrinteger>>>>>9Company
2project_codecharacterx(12)Project
3cost_centercharacterx(12)Cost center
4employee_codecharacterX(12)Employee
5hour_cat_codecharacterx(12)Hour category
6cost_cat_codecharacterx(12)Cost category
7yearinteger9999Year
8periodinteger>>9Period
9result_typeinteger>>>>>9Result type

Contents > prrhyp

     
 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: 26.936.586
 Assortment:  Date: 27-01-2016
 Release:  Attachment:
 Disclaimer