|
Data dictionary practv - Activities - 7.20
1 | adm_nr | integer | >>>>>9 | | | ? | Company | 2 | project_code | character | x(12) | | | ? | Project | 3 | seqnr_practv | integer | >>>>9 | | | ? | Activity | 4 | search_code | character | x(12) | | | | Activity code | 5 | description | character | X(60) | | | | Description | 6 | startdate | date | 99/99/9999 | | | | Startdate | 7 | starttime | integer | >>>>>9 | | | 0 | Starttime | 8 | enddate | date | 99/99/9999 | | | | Enddate | 9 | endtime | integer | >>>>>9 | | | 0 | Endtime | 10 | first_date_real | date | 99/99/9999 | | | | First actual date | 11 | last_date_real | date | 99/99/9999 | | | | Last actual date | 12 | bud_qty | decimal | ->>>,>>>,>>9.99 | 2 | | 0 | Budget quantity | 13 | generated_qty | decimal | ->>>,>>>,>>9.99 | 2 | | 0 | Generated budget quantity | 14 | real_qty | decimal | ->>>,>>>,>>9.99 | 2 | | 0 | Actual quantity | 15 | resource_type | integer | >>>>>9 | | | 0 | Resource type | 16 | resource_code | character | X(12) | | | | Resource | 17 | hour_cat_code | character | x(12) | | | | Hour category | 18 | unit_code | character | x(12) | | | | Unit | 19 | location_code | character | x(12) | | | | Location | 20 | date_ready | date | 99/99/9999 | | | | Date ready | 21 | blocked | logical | TRUE/FALSE | | | FALSE | Block | 22 | critical | logical | TRUE/FALSE | | | FALSE | Critical | 23 | priority | integer | >9 | | | 0 | Priority | 24 | seqnr_prphlp | integer | >>>>9 | | | 0 | Sequence number | 25 | parent_seqnr_practv | integer | >>>>9 | | | 0 | Parent activity | 26 | euserid_cr | character | X(12) | | | | User creation | 27 | euserid_lc | character | X(12) | | | | User last changed | 28 | source_cr | character | X(40) | | | | Source creation | 29 | source_lc | character | X(40) | | | | Source last changed | 30 | date_cr | date | 99/99/9999 | | | | Date creation | 31 | date_lc | date | 99/99/9999 | | | | Date last changed | 32 | time_cr | integer | >>>>>9 | | | ? | Time creation | 33 | time_lc | integer | >>>>>9 | | | ? | Time last changed |
Indexespractvix - primary - unique1 | adm_nr | integer | >>>>>9 | Company | 2 | project_code | character | x(12) | Project | 3 | seqnr_practv | integer | >>>>9 | Activity |
practv2ix1 | adm_nr | integer | >>>>>9 | Company | 2 | project_code | character | x(12) | Project | 3 | seqnr_prphlp | integer | >>>>9 | Sequence number | 4 | parent_seqnr_practv | integer | >>>>9 | Parent activity | 5 | seqnr_practv | integer | >>>>9 | Activity |
practv3ix1 | adm_nr | integer | >>>>>9 | Company | 2 | project_code | character | x(12) | Project | 3 | parent_seqnr_practv | integer | >>>>9 | Parent activity | 4 | seqnr_practv | integer | >>>>9 | Activity |
practv4ix1 | adm_nr | integer | >>>>>9 | Company | 2 | project_code | character | x(12) | Project | 3 | resource_type | integer | >>>>>9 | Resource type | 4 | resource_code | character | X(12) | Resource | 5 | seqnr_practv | integer | >>>>9 | Activity |
Contents > practv
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.499 |
Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
Release: |
|
Attachment: |
|
Disclaimer |
|
|