|
|
Data dictionary stusrol - Roles per user - 7.20
| 1 | user_id | character | X(12) | | | ? | User ID | | 2 | type_role | integer | >>>>>9 | | | ? | Role type | | 3 | adm_nr | integer | >>>>>9 | | | ? | Company | | 4 | curr_code | character | X(3) | | | | Currency | | 5 | rate_internal | decimal | ->>,>>>,>>9.99 | 2 | | | Internal rate | | 6 | rate_external | decimal | ->>,>>>,>>9.99 | 2 | | | External rate | | 7 | cost_center | character | x(12) | | | | Cost center | | 8 | department_code | character | x(12) | | | | Department | | 9 | position_code | character | x(12) | | | | Position | | 10 | capacity | decimal | >>>9.99 | 2 | | 0 | Capacity | | 11 | unit_code | character | x(12) | | | | Unit | | 12 | amount_dc_minimum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Minimum approval amount | | 13 | amount_dc_maximum | decimal | ->>>,>>>,>>>,>>>,>>9.99 | 4 | | 0 | Maximum approval amount | | 14 | entity_state | integer | >>>>>9 | | | 0 | State |
Indexesstusrol01ix - primary - unique| 1 | user_id | character | X(12) | User ID | | 2 | type_role | integer | >>>>>9 | Role type | | 3 | adm_nr | integer | >>>>>9 | Company |
stusrol02ix| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | user_id | character | X(12) | User ID | | 3 | type_role | integer | >>>>>9 | Role type |
Contents > stusrol
| 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.671 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|