Frmissueplain |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Frmissueplain worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Action |
boolean |
itgen_ibz_action |
☐ |
|
ActionDate |
datetimeoffset |
itgen_ibz_actiondate |
☐ |
|
ActionRequiredById |
int32 |
itgen_ibz_actionrequiredbyid |
☐ |
|
ActualHours |
int64 |
itgen_ibz_actualhours |
☐ |
|
Area |
string |
itgen_ibz_area |
☐ |
|
AreaId |
int32 |
itgen_ibz_areaid |
☐ |
|
AssignedOn |
datetimeoffset |
itgen_ibz_assignedon |
☐ |
|
AssignedOverdueAlarmIn |
int64 |
itgen_ibz_assignedoverduealarmin |
☐ |
|
AssignedTo |
string |
itgen_ibz_assignedto |
☐ |
|
AssignedToUser |
string |
itgen_ibz_assignedtouser |
☐ |
|
AssignedUserId |
int32 |
itgen_ibz_assigneduserid |
☐ |
|
AssignIn |
int64 |
itgen_ibz_assignin |
☐ |
|
AssignInColor |
string |
itgen_ibz_assignincolor |
☐ |
|
AssignInIconColor |
string |
itgen_ibz_assigniniconcolor |
☐ |
|
Billable |
boolean |
itgen_ibz_billable |
☑ |
|
BudgetType |
int32 |
itgen_ibz_budgettype |
☑ |
|
CanAddTimesheet |
boolean |
itgen_ibz_canaddtimesheet |
☑ |
|
Category |
string |
itgen_ibz_category |
☐ |
|
CategoryId |
int32 |
itgen_ibz_categoryid |
☐ |
|
CategorySequence |
int32 |
itgen_ibz_categorysequence |
☐ |
|
Color |
string |
itgen_ibz_color |
☐ |
|
CompletedByContactId |
int32 |
itgen_ibz_completedbycontactid |
☐ |
|
CompletedByUserId |
int32 |
itgen_ibz_completedbyuserid |
☐ |
|
CompletedPercent |
int32 |
itgen_ibz_completedpercent |
☐ |
|
CompletionDate |
datetimeoffset |
itgen_ibz_completiondate |
☐ |
|
ContactFirstName |
string |
itgen_ibz_contactfirstname |
☐ |
|
ContactId |
int32 |
itgen_ibz_contactid |
☐ |
|
ContactLastName |
string |
itgen_ibz_contactlastname |
☐ |
|
ContactName |
string |
itgen_ibz_contactname |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☑ |
|
Creator |
string |
itgen_ibz_creator |
☐ |
|
CreatorContactId |
int32 |
itgen_ibz_creatorcontactid |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
DepartmentId |
int32 |
itgen_ibz_departmentid |
☐ |
|
DepartmentName |
string |
itgen_ibz_departmentname |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
DueDate |
datetimeoffset |
itgen_ibz_duedate |
☐ |
|
DueDateColor |
string |
itgen_ibz_duedatecolor |
☐ |
|
EscalatedToYou |
boolean |
itgen_ibz_escalatedtoyou |
☐ |
|
EstimatedHours |
decimal |
itgen_ibz_estimatedhours |
☐ |
|
ExpectedDeliveryDate |
datetimeoffset |
itgen_ibz_expecteddeliverydate |
☐ |
|
ExposeToRelationPortal |
boolean |
itgen_ibz_exposetorelationportal |
☑ |
|
ExternalID |
string |
itgen_ibz_externalid |
☐ |
|
FirstRespondedOn |
datetimeoffset |
itgen_ibz_firstrespondedon |
☐ |
|
FirstResponseIn |
int64 |
itgen_ibz_firstresponsein |
☐ |
|
FirstResponseInColor |
string |
itgen_ibz_firstresponseincolor |
☐ |
|
FirstResponseInIconColor |
string |
itgen_ibz_firstresponseiniconcolor |
☐ |
|
FirstResponseOverdueAlarmIn |
int64 |
itgen_ibz_firstresponseoverduealarmin |
☐ |
|
GroupId |
int32 |
itgen_ibz_groupid |
☐ |
|
GroupName |
string |
itgen_ibz_groupname |
☐ |
|
GroupSequence |
int32 |
itgen_ibz_groupsequence |
☐ |
|
HasReminders |
boolean |
itgen_ibz_hasreminders |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Invoiced |
decimal |
itgen_ibz_invoiced |
☐ |
|
IsCompleted |
boolean |
itgen_ibz_iscompleted |
☐ |
|
IssueId |
string |
itgen_ibz_issueid |
☐ |
|
IssueStatusActionRequired |
boolean |
itgen_ibz_issuestatusactionrequired |
☐ |
|
IssueStatusUseEscalationRule |
boolean |
itgen_ibz_issuestatususeescalationrule |
☐ |
|
IterationId |
int32 |
itgen_ibz_iterationid |
☐ |
|
IterationName |
string |
itgen_ibz_iterationname |
☐ |
|
IterationOwnerId |
int32 |
itgen_ibz_iterationownerid |
☐ |
|
IterationSequence |
int32 |
itgen_ibz_iterationsequence |
☐ |
|
Location |
string |
itgen_ibz_location |
☐ |
|
ModifiedByContactId |
int32 |
itgen_ibz_modifiedbycontactid |
☐ |
|
ModifiedByUserId |
int32 |
itgen_ibz_modifiedbyuserid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
ModifierName |
string |
itgen_ibz_modifiername |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
Owner |
string |
itgen_ibz_owner |
☐ |
|
OwnerId |
int32 |
itgen_ibz_ownerid |
☐ |
|
PermissionsDeleteWithNoLinks |
boolean |
itgen_ibz_permissionsdeletewithnolinks |
☑ |
|
Planned |
int64 |
itgen_ibz_planned |
☐ |
|
Points |
int32 |
itgen_ibz_points |
☐ |
|
Priority |
string |
itgen_ibz_priority |
☐ |
|
PriorityColor |
string |
itgen_ibz_prioritycolor |
☐ |
|
PriorityId |
int32 |
itgen_ibz_priorityid |
☐ |
|
PrioritySequence |
int32 |
itgen_ibz_prioritysequence |
☐ |
|
Project |
string |
itgen_ibz_project |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectIdString |
string |
itgen_ibz_projectidstring |
☐ |
|
ProjectManagerId |
int32 |
itgen_ibz_projectmanagerid |
☐ |
|
ProjectSupervisorId |
int32 |
itgen_ibz_projectsupervisorid |
☐ |
|
Quote |
string |
itgen_ibz_quote |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
RelationName |
string |
itgen_ibz_relationname |
☐ |
|
ReleaseNotesCount |
int32 |
itgen_ibz_releasenotescount |
☐ |
|
ResolutionIn |
int64 |
itgen_ibz_resolutionin |
☐ |
|
ResolutionInColor |
string |
itgen_ibz_resolutionincolor |
☐ |
|
ResolutionInIconColor |
string |
itgen_ibz_resolutioniniconcolor |
☐ |
|
ResolutionOverdueAlarmIn |
int64 |
itgen_ibz_resolutionoverduealarmin |
☐ |
|
ResolutionTimersCount |
int32 |
itgen_ibz_resolutiontimerscount |
☐ |
|
RowNumber |
int32 |
itgen_ibz_rownumber |
☑ |
|
SalesPrice |
decimal |
itgen_ibz_salesprice |
☐ |
|
Severity |
string |
itgen_ibz_severity |
☐ |
|
SeverityColor |
string |
itgen_ibz_severitycolor |
☐ |
|
SeverityId |
int32 |
itgen_ibz_severityid |
☐ |
|
SeveritySequence |
int32 |
itgen_ibz_severitysequence |
☐ |
|
ShowOnHome |
boolean |
itgen_ibz_showonhome |
☐ |
|
ShowPauseTimer |
boolean |
itgen_ibz_showpausetimer |
☐ |
|
ShowRestartTimer |
boolean |
itgen_ibz_showrestarttimer |
☐ |
|
ShowSla |
boolean |
itgen_ibz_showsla |
☐ |
|
ShowStopTimer |
boolean |
itgen_ibz_showstoptimer |
☐ |
|
SkillName |
string |
itgen_ibz_skillname |
☐ |
|
SLATemplateId |
int32 |
itgen_ibz_slatemplateid |
☐ |
|
SoftwareId |
int32 |
itgen_ibz_softwareid |
☐ |
|
SoftwareName |
string |
itgen_ibz_softwarename |
☐ |
|
SoftwareSequence |
int32 |
itgen_ibz_softwaresequence |
☐ |
|
Status |
string |
itgen_ibz_status |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☐ |
|
StatusSequence |
int32 |
itgen_ibz_statussequence |
☐ |
|
TaskColor |
string |
itgen_ibz_taskcolor |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TaskName |
string |
itgen_ibz_taskname |
☐ |
|
Tester |
string |
itgen_ibz_tester |
☐ |
|
TestStatus |
string |
itgen_ibz_teststatus |
☐ |
|
TestStatusId |
int32 |
itgen_ibz_teststatusid |
☐ |
|
TestUserId |
int32 |
itgen_ibz_testuserid |
☐ |
|
Type |
string |
itgen_ibz_type |
☐ |
|
TypeId |
int32 |
itgen_ibz_typeid |
☐ |
|
TypeSequence |
int32 |
itgen_ibz_typesequence |
☐ |
|
UnreadEmails |
int32 |
itgen_ibz_unreademails |
☑ |
|
UnreadNotes |
int32 |
itgen_ibz_unreadnotes |
☑ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model