|
|
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 - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | project_code | character | x(12) | Project | | 3 | seqnr_practv | integer | >>>>9 | Activity |
practv2ix| 1 | 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 |
practv3ix| 1 | 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 |
practv4ix| 1 | 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 |
|
|