Spgettaskslist_Result |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Spgettaskslist_Result worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Activity |
string |
itgen_ibz_activity |
☐ |
|
ActivityType |
string |
itgen_ibz_activitytype |
☐ |
|
ActualCostInclOH |
decimal |
itgen_ibz_actualcostincloh |
☐ |
|
ActualCostsCosts |
decimal |
itgen_ibz_actualcostscosts |
☐ |
|
ActualCostsOfCostsInclOH |
decimal |
itgen_ibz_actualcostsofcostsincloh |
☐ |
|
ActualCostsOfTimeInclOH |
decimal |
itgen_ibz_actualcostsoftimeincloh |
☐ |
|
ActualCostsTime |
decimal |
itgen_ibz_actualcoststime |
☐ |
|
ActualSalesCosts |
decimal |
itgen_ibz_actualsalescosts |
☐ |
|
ActualSalesTime |
decimal |
itgen_ibz_actualsalestime |
☐ |
|
ClosedTickets |
string |
itgen_ibz_closedtickets |
☐ |
|
Contact |
string |
itgen_ibz_contact |
☐ |
|
CurrencySymbol |
string |
itgen_ibz_currencysymbol |
☐ |
|
CurrentCostsCostsInclOH |
decimal |
itgen_ibz_currentcostscostsincloh |
☐ |
|
CurrentCostsInclOH |
decimal |
itgen_ibz_currentcostsincloh |
☐ |
|
CurrentCostsTimeInclOH |
decimal |
itgen_ibz_currentcoststimeincloh |
☐ |
|
Customer |
string |
itgen_ibz_customer |
☐ |
|
CustomerDocumentStatus |
int32 |
itgen_ibz_customerdocumentstatus |
☐ |
|
CustomFields |
string |
itgen_ibz_customfields |
☐ |
|
Invoiced |
decimal |
itgen_ibz_invoiced |
☐ |
|
OverheadFactorCosts |
decimal |
itgen_ibz_overheadfactorcosts |
☐ |
|
OverheadFactorTime |
decimal |
itgen_ibz_overheadfactortime |
☐ |
|
ProjectAccountManager |
string |
itgen_ibz_projectaccountmanager |
☐ |
|
ProjectBaselineHours |
int64 |
itgen_ibz_projectbaselinehours |
☑ |
|
ProjectBillable |
boolean |
itgen_ibz_projectbillable |
☐ |
|
ProjectBudgetAllocation |
int32 |
itgen_ibz_projectbudgetallocation |
☐ |
|
ProjectBudgetType |
int32 |
itgen_ibz_projectbudgettype |
☐ |
|
ProjectCurrency |
string |
itgen_ibz_projectcurrency |
☐ |
|
ProjectCustomerRef |
string |
itgen_ibz_projectcustomerref |
☐ |
|
ProjectDepartment |
string |
itgen_ibz_projectdepartment |
☐ |
|
ProjectDepartmentId |
int32 |
itgen_ibz_projectdepartmentid |
☐ |
|
ProjectEndDate |
datetimeoffset |
itgen_ibz_projectenddate |
☐ |
|
ProjectGroup |
string |
itgen_ibz_projectgroup |
☐ |
|
ProjectManager |
string |
itgen_ibz_projectmanager |
☐ |
|
ProjectName |
string |
itgen_ibz_projectname |
☐ |
|
ProjectProjectId |
string |
itgen_ibz_projectprojectid |
☑ |
|
ProjectStartDate |
datetimeoffset |
itgen_ibz_projectstartdate |
☐ |
|
ProjectStatus |
string |
itgen_ibz_projectstatus |
☐ |
|
ProjectSupervisor |
string |
itgen_ibz_projectsupervisor |
☐ |
|
ProjectType |
string |
itgen_ibz_projecttype |
☐ |
|
ProjectWorkHoursPerDay |
decimal |
itgen_ibz_projectworkhoursperday |
☐ |
|
RegisteredCostsTime |
decimal |
itgen_ibz_registeredcoststime |
☐ |
|
RegisteredSalesTime |
decimal |
itgen_ibz_registeredsalestime |
☐ |
|
ResourceDocumentStatus |
int32 |
itgen_ibz_resourcedocumentstatus |
☐ |
|
TaskActualHours |
int64 |
itgen_ibz_taskactualhours |
☐ |
|
TaskBaselineHours |
int64 |
itgen_ibz_taskbaselinehours |
☑ |
|
TaskBillable |
boolean |
itgen_ibz_taskbillable |
☐ |
|
TaskCompletedPct |
int32 |
itgen_ibz_taskcompletedpct |
☐ |
|
TaskCurrentCostCosts |
decimal |
itgen_ibz_taskcurrentcostcosts |
☐ |
|
TaskCurrentCostTime |
decimal |
itgen_ibz_taskcurrentcosttime |
☐ |
|
TaskCurrentCostTotal |
decimal |
itgen_ibz_taskcurrentcosttotal |
☐ |
|
TaskCurrentSalesCosts |
decimal |
itgen_ibz_taskcurrentsalescosts |
☐ |
|
TaskCurrentSalesTime |
decimal |
itgen_ibz_taskcurrentsalestime |
☐ |
|
TaskCurrentSalesTotal |
decimal |
itgen_ibz_taskcurrentsalestotal |
☐ |
|
TaskCustomerRef |
string |
itgen_ibz_taskcustomerref |
☐ |
|
TaskDescription |
string |
itgen_ibz_taskdescription |
☐ |
|
TaskEndDate |
datetimeoffset |
itgen_ibz_taskenddate |
☐ |
|
TaskFunction |
string |
itgen_ibz_taskfunction |
☐ |
|
TaskHourlyCost |
decimal |
itgen_ibz_taskhourlycost |
☐ |
|
TaskHourlyRate |
decimal |
itgen_ibz_taskhourlyrate |
☐ |
|
TaskInternalRef |
string |
itgen_ibz_taskinternalref |
☐ |
|
TaskName |
string |
itgen_ibz_taskname |
☐ |
|
TaskPlannedHours |
int64 |
itgen_ibz_taskplannedhours |
☐ |
|
TaskStartDate |
datetimeoffset |
itgen_ibz_taskstartdate |
☐ |
|
TaskStatus |
string |
itgen_ibz_taskstatus |
☐ |
|
TaskTimeToCompletion |
int64 |
itgen_ibz_tasktimetocompletion |
☑ |
|
TimesheetDocumentStatus |
int32 |
itgen_ibz_timesheetdocumentstatus |
☐ |
|
TotalActualCosts |
decimal |
itgen_ibz_totalactualcosts |
☐ |
|
TotalActualSales |
decimal |
itgen_ibz_totalactualsales |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120