Issues: ionBIZ Issues |
Catalogus: ionBIZ
Label: Issues
Ophalen: true
Tabelkolommen
De kolommen van de tabel Issues worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
ActionDate |
datetimeoffset |
itgen_ibz_actiondate |
☐ |
|
ActionRequiredById |
int32 |
itgen_ibz_actionrequiredbyid |
☐ |
|
AddToPlanning |
boolean |
itgen_ibz_addtoplanning |
☐ |
|
AreaId |
int32 |
itgen_ibz_areaid |
☐ |
|
AssignedByUserId |
int32 |
itgen_ibz_assignedbyuserid |
☐ |
|
AssignedOn |
datetimeoffset |
itgen_ibz_assignedon |
☐ |
|
AssignedUserId |
int32 |
itgen_ibz_assigneduserid |
☐ |
|
Billable |
boolean |
itgen_ibz_billable |
☐ |
|
BudgetType |
int32 |
itgen_ibz_budgettype |
☐ |
|
CategoryId |
int32 |
itgen_ibz_categoryid |
☐ |
|
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 |
☐ |
|
ContactId |
int32 |
itgen_ibz_contactid |
☐ |
|
ContractId |
int32 |
itgen_ibz_contractid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorContactId |
int32 |
itgen_ibz_creatorcontactid |
☐ |
|
CreatorUserId |
int32 |
itgen_ibz_creatoruserid |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
DeletedByContactId |
int32 |
itgen_ibz_deletedbycontactid |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DepartmentId |
int32 |
itgen_ibz_departmentid |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
DueDate |
datetimeoffset |
itgen_ibz_duedate |
☐ |
|
EstimatedHours |
decimal |
itgen_ibz_estimatedhours |
☐ |
|
ExpectedDeliveryDate |
datetimeoffset |
itgen_ibz_expecteddeliverydate |
☐ |
|
ExposeToRelationPortal |
boolean |
itgen_ibz_exposetorelationportal |
☐ |
|
ExternalID |
string |
itgen_ibz_externalid |
☐ |
|
FirstRespondedByUserId |
int32 |
itgen_ibz_firstrespondedbyuserid |
☐ |
|
FirstRespondedOn |
datetimeoffset |
itgen_ibz_firstrespondedon |
☐ |
|
GroupId |
int32 |
itgen_ibz_groupid |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InvoiceMode |
int32 |
itgen_ibz_invoicemode |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
IssueArea_Id |
int32 |
itgen_ibz_issuearea_id |
☐ |
|
IssueId |
string |
itgen_ibz_issueid |
☐ |
|
IterationId |
int32 |
itgen_ibz_iterationid |
☐ |
|
ModifiedByContactId |
int32 |
itgen_ibz_modifiedbycontactid |
☐ |
|
ModifiedByUserId |
int32 |
itgen_ibz_modifiedbyuserid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
OwnerId |
int32 |
itgen_ibz_ownerid |
☐ |
|
Points |
int32 |
itgen_ibz_points |
☐ |
|
PriorityId |
int32 |
itgen_ibz_priorityid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceId |
int32 |
itgen_ibz_projectinvoiceid |
☐ |
|
ProjectInvoiceLineId |
int32 |
itgen_ibz_projectinvoicelineid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
RelationLeadId |
int32 |
itgen_ibz_relationleadid |
☐ |
|
Resolution |
string |
itgen_ibz_resolution |
☐ |
|
ReviewedHours |
decimal |
itgen_ibz_reviewedhours |
☐ |
|
RMAAssignedToId |
int32 |
itgen_ibz_rmaassignedtoid |
☐ |
|
RMAComment |
string |
itgen_ibz_rmacomment |
☐ |
|
RMACustomerEstimateApprovedById |
int32 |
itgen_ibz_rmacustomerestimateapprovedbyid |
☐ |
|
RMACustomerEstimateDecisionDate |
datetimeoffset |
itgen_ibz_rmacustomerestimatedecisiondate |
☐ |
|
RMACustomerEstimatePrice |
decimal |
itgen_ibz_rmacustomerestimateprice |
☐ |
|
RMACustomerEstimateReference |
string |
itgen_ibz_rmacustomerestimatereference |
☐ |
|
RMADeliveryDate |
datetimeoffset |
itgen_ibz_rmadeliverydate |
☐ |
|
RMADeliveryToId |
int32 |
itgen_ibz_rmadeliverytoid |
☐ |
|
RMAItemId |
int32 |
itgen_ibz_rmaitemid |
☐ |
|
RMAOrderInfo |
string |
itgen_ibz_rmaorderinfo |
☐ |
|
RMAPredecessorId |
int32 |
itgen_ibz_rmapredecessorid |
☐ |
|
RMAReceivingDate |
datetimeoffset |
itgen_ibz_rmareceivingdate |
☐ |
|
RMAReplacementItemId |
int32 |
itgen_ibz_rmareplacementitemid |
☐ |
|
RMAReplacementReturnDate |
datetimeoffset |
itgen_ibz_rmareplacementreturndate |
☐ |
|
RMAReplacementSerialNumber |
string |
itgen_ibz_rmareplacementserialnumber |
☐ |
|
RMAReplacementShipmentDate |
datetimeoffset |
itgen_ibz_rmareplacementshipmentdate |
☐ |
|
RMAReplacementStatus |
string |
itgen_ibz_rmareplacementstatus |
☐ |
|
RMARespectiveUnitCost |
decimal |
itgen_ibz_rmarespectiveunitcost |
☐ |
|
RMASendToId |
int32 |
itgen_ibz_rmasendtoid |
☐ |
|
RMASerialNumber |
string |
itgen_ibz_rmaserialnumber |
☐ |
|
RMASupplierContactId |
int32 |
itgen_ibz_rmasuppliercontactid |
☐ |
|
RMASupplierEstimateApprovedById |
int32 |
itgen_ibz_rmasupplierestimateapprovedbyid |
☐ |
|
RMASupplierEstimateDecisionDate |
datetimeoffset |
itgen_ibz_rmasupplierestimatedecisiondate |
☐ |
|
RMASupplierEstimatePrice |
decimal |
itgen_ibz_rmasupplierestimateprice |
☐ |
|
RMASupplierEstimateReference |
string |
itgen_ibz_rmasupplierestimatereference |
☐ |
|
RMASupplierGuarantee |
boolean |
itgen_ibz_rmasupplierguarantee |
☐ |
|
RMASupplierId |
int32 |
itgen_ibz_rmasupplierid |
☐ |
|
RMASupplierRef |
string |
itgen_ibz_rmasupplierref |
☐ |
|
RMASupplierReturnDate |
datetimeoffset |
itgen_ibz_rmasupplierreturndate |
☐ |
|
RMASupplierShipmentDate |
datetimeoffset |
itgen_ibz_rmasuppliershipmentdate |
☐ |
|
RMASupplierShipmentInfo |
string |
itgen_ibz_rmasuppliershipmentinfo |
☐ |
|
SalesPrice |
decimal |
itgen_ibz_salesprice |
☐ |
|
SeverityId |
int32 |
itgen_ibz_severityid |
☐ |
|
SoftwareId |
int32 |
itgen_ibz_softwareid |
☐ |
|
Solution |
string |
itgen_ibz_solution |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TestResult |
string |
itgen_ibz_testresult |
☐ |
|
TestStatusId |
int32 |
itgen_ibz_teststatusid |
☐ |
|
TestUserId |
int32 |
itgen_ibz_testuserid |
☐ |
|
TransferToProjectId |
int32 |
itgen_ibz_transfertoprojectid |
☐ |
|
TypeId |
int32 |
itgen_ibz_typeid |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model