Rptplanningsplanninglistresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Rptplanningsplanninglistresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
ActivityTypeId |
int32 |
itgen_ibz_activitytypeid |
☐ |
|
ActivityTypeName |
string |
itgen_ibz_activitytypename |
☐ |
|
ApprovalDate |
datetimeoffset |
itgen_ibz_approvaldate |
☐ |
|
ApproverId |
int32 |
itgen_ibz_approverid |
☐ |
|
ApproverName |
string |
itgen_ibz_approvername |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☑ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☑ |
|
CreatorName |
string |
itgen_ibz_creatorname |
☐ |
|
Deadline |
datetimeoffset |
itgen_ibz_deadline |
☐ |
|
Distance |
decimal |
itgen_ibz_distance |
☐ |
|
Duration |
decimal |
itgen_ibz_duration |
☑ |
|
End |
datetimeoffset |
itgen_ibz_end |
☐ |
|
FunctionId |
int32 |
itgen_ibz_functionid |
☐ |
|
FunctionName |
string |
itgen_ibz_functionname |
☐ |
|
HourFrom |
datetimeoffset |
itgen_ibz_hourfrom |
☐ |
|
HourlyRate |
decimal |
itgen_ibz_hourlyrate |
☐ |
|
HourTo |
datetimeoffset |
itgen_ibz_hourto |
☐ |
|
ID |
int32 |
itgen_ibz_id |
☐ |
|
Issue |
string |
itgen_ibz_issue |
☐ |
|
LastModifiedDate |
datetimeoffset |
itgen_ibz_lastmodifieddate |
☐ |
|
LinkedResources |
string |
itgen_ibz_linkedresources |
☐ |
|
LocationId |
int32 |
itgen_ibz_locationid |
☐ |
|
LocationName |
string |
itgen_ibz_locationname |
☐ |
|
MonthPlanningDate |
int32 |
itgen_ibz_monthplanningdate |
☐ |
|
OverlappingResources |
string |
itgen_ibz_overlappingresources |
☐ |
|
Percentage |
decimal |
itgen_ibz_percentage |
☐ |
|
PlanningActivityId |
int32 |
itgen_ibz_planningactivityid |
☐ |
|
PlanningActivityName |
string |
itgen_ibz_planningactivityname |
☐ |
|
PlanningDate |
datetimeoffset |
itgen_ibz_planningdate |
☐ |
|
PlanningStatus |
string |
itgen_ibz_planningstatus |
☐ |
|
PlanningType |
int32 |
itgen_ibz_planningtype |
☑ |
|
ProjectDepartmentId |
int32 |
itgen_ibz_projectdepartmentid |
☐ |
|
ProjectDepartmentName |
string |
itgen_ibz_projectdepartmentname |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectIdText |
string |
itgen_ibz_projectidtext |
☐ |
|
ProjectLocation |
string |
itgen_ibz_projectlocation |
☐ |
|
ProjectManagerName |
string |
itgen_ibz_projectmanagername |
☐ |
|
ProjectName |
string |
itgen_ibz_projectname |
☐ |
|
ProjectSupervisorName |
string |
itgen_ibz_projectsupervisorname |
☐ |
|
ProjectType |
string |
itgen_ibz_projecttype |
☐ |
|
RelationGroup |
string |
itgen_ibz_relationgroup |
☐ |
|
RelationName |
string |
itgen_ibz_relationname |
☐ |
|
ResourceDepartmentId |
int32 |
itgen_ibz_resourcedepartmentid |
☐ |
|
ResourceDepartmentName |
string |
itgen_ibz_resourcedepartmentname |
☐ |
|
ResourceExternalCode |
string |
itgen_ibz_resourceexternalcode |
☐ |
|
ResourceFunctionName |
string |
itgen_ibz_resourcefunctionname |
☐ |
|
ResourceId |
int32 |
itgen_ibz_resourceid |
☑ |
|
ResourceInitials |
string |
itgen_ibz_resourceinitials |
☐ |
|
ResourceName |
string |
itgen_ibz_resourcename |
☐ |
|
ResourceTypeId |
int32 |
itgen_ibz_resourcetypeid |
☐ |
|
ResourceTypeName |
string |
itgen_ibz_resourcetypename |
☐ |
|
Skill |
string |
itgen_ibz_skill |
☐ |
|
Start |
datetimeoffset |
itgen_ibz_start |
☐ |
|
Subject |
string |
itgen_ibz_subject |
☐ |
|
Task |
string |
itgen_ibz_task |
☐ |
|
TaskActivityId |
int32 |
itgen_ibz_taskactivityid |
☐ |
|
TaskActivityName |
string |
itgen_ibz_taskactivityname |
☐ |
|
TaskEndDate |
datetimeoffset |
itgen_ibz_taskenddate |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TaskStartDate |
datetimeoffset |
itgen_ibz_taskstartdate |
☐ |
|
TaskStatus |
string |
itgen_ibz_taskstatus |
☐ |
|
Title |
string |
itgen_ibz_title |
☐ |
|
TotalSales |
decimal |
itgen_ibz_totalsales |
☐ |
|
WorkLocationId |
int32 |
itgen_ibz_worklocationid |
☐ |
|
WorkLocationName |
string |
itgen_ibz_worklocationname |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120