Rptprojectsopentasksresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Rptprojectsopentasksresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AccountManager |
string |
itgen_ibz_accountmanager |
☐ |
|
Activity |
string |
itgen_ibz_activity |
☐ |
|
ActivityType |
string |
itgen_ibz_activitytype |
☐ |
|
Actuals |
int64 |
itgen_ibz_actuals |
☑ |
|
Baseline |
int64 |
itgen_ibz_baseline |
☑ |
|
EndDate |
datetimeoffset |
itgen_ibz_enddate |
☐ |
|
FeeCustomer |
decimal |
itgen_ibz_feecustomer |
☑ |
|
FeeMargin |
decimal |
itgen_ibz_feemargin |
☑ |
|
FeeResource |
decimal |
itgen_ibz_feeresource |
☑ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
LastActualDate |
datetimeoffset |
itgen_ibz_lastactualdate |
☐ |
|
OpenWeeks |
int32 |
itgen_ibz_openweeks |
☑ |
|
ProjectCode |
string |
itgen_ibz_projectcode |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☑ |
|
ProjectManager |
string |
itgen_ibz_projectmanager |
☐ |
|
ProjectName |
string |
itgen_ibz_projectname |
☐ |
|
ResourceDepartment |
string |
itgen_ibz_resourcedepartment |
☐ |
|
ResourceId |
int32 |
itgen_ibz_resourceid |
☑ |
|
ResourceName |
string |
itgen_ibz_resourcename |
☐ |
|
StartDate |
datetimeoffset |
itgen_ibz_startdate |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☑ |
|
TaskLevel |
string |
itgen_ibz_tasklevel |
☐ |
|
TaskName |
string |
itgen_ibz_taskname |
☐ |
|
TaskStatus |
string |
itgen_ibz_taskstatus |
☐ |
|
TimeStatus |
string |
itgen_ibz_timestatus |
☐ |
|
TimeToCompletion |
int64 |
itgen_ibz_timetocompletion |
☑ |
|
TimeToCompletionDays |
decimal |
itgen_ibz_timetocompletiondays |
☑ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120