Spgettasksextensionfieldsresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Spgettasksextensionfieldsresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
ActualCost |
decimal |
itgen_ibz_actualcost |
☑ |
|
ActualCostCosts |
decimal |
itgen_ibz_actualcostcosts |
☑ |
|
ActualCostsTime |
decimal |
itgen_ibz_actualcoststime |
☑ |
|
Actuals |
int64 |
itgen_ibz_actuals |
☑ |
|
ActualSales |
decimal |
itgen_ibz_actualsales |
☑ |
|
ActualSalesCosts |
decimal |
itgen_ibz_actualsalescosts |
☑ |
|
ActualSalesInclTaskDiscount |
decimal |
itgen_ibz_actualsalesincltaskdiscount |
☑ |
|
ActualSalesTime |
decimal |
itgen_ibz_actualsalestime |
☑ |
|
ActualSalesTimeProfit |
decimal |
itgen_ibz_actualsalestimeprofit |
☑ |
|
AllCostsCosts |
decimal |
itgen_ibz_allcostscosts |
☑ |
|
AllSalesCosts |
decimal |
itgen_ibz_allsalescosts |
☑ |
|
AssignedCosts |
decimal |
itgen_ibz_assignedcosts |
☑ |
|
AssignedSales |
decimal |
itgen_ibz_assignedsales |
☑ |
|
AssignedTime |
int64 |
itgen_ibz_assignedtime |
☐ |
|
AverageCostPricePerHour |
decimal |
itgen_ibz_averagecostpriceperhour |
☑ |
|
AverageSalesPricePerHour |
decimal |
itgen_ibz_averagesalespriceperhour |
☑ |
|
Baseline |
int64 |
itgen_ibz_baseline |
☑ |
|
BaselineCostsCosts |
decimal |
itgen_ibz_baselinecostscosts |
☑ |
|
BaselineCostsTime |
decimal |
itgen_ibz_baselinecoststime |
☑ |
|
BaselineSalesCosts |
decimal |
itgen_ibz_baselinesalescosts |
☑ |
|
BaselineSalesTime |
decimal |
itgen_ibz_baselinesalestime |
☑ |
|
BillableHours |
int64 |
itgen_ibz_billablehours |
☑ |
|
CompletedPercent |
int32 |
itgen_ibz_completedpercent |
☑ |
|
ConfirmedActuals |
decimal |
itgen_ibz_confirmedactuals |
☑ |
|
ConfirmedCostsActuals |
decimal |
itgen_ibz_confirmedcostsactuals |
☑ |
|
ConfirmedSalesActuals |
decimal |
itgen_ibz_confirmedsalesactuals |
☑ |
|
ConversionFactor |
decimal |
itgen_ibz_conversionfactor |
☑ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☑ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☑ |
|
CurrencySymbol |
string |
itgen_ibz_currencysymbol |
☐ |
|
CurrentCosts |
decimal |
itgen_ibz_currentcosts |
☑ |
|
CurrentCostsCosts |
decimal |
itgen_ibz_currentcostscosts |
☑ |
|
CurrentCostsTime |
decimal |
itgen_ibz_currentcoststime |
☑ |
|
CurrentSales |
decimal |
itgen_ibz_currentsales |
☑ |
|
CurrentSalesCosts |
decimal |
itgen_ibz_currentsalescosts |
☑ |
|
CurrentSalesTime |
decimal |
itgen_ibz_currentsalestime |
☑ |
|
EndDate |
datetimeoffset |
itgen_ibz_enddate |
☐ |
|
FuturePlanned |
int64 |
itgen_ibz_futureplanned |
☑ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Initials |
string |
itgen_ibz_initials |
☐ |
|
Invoiced |
decimal |
itgen_ibz_invoiced |
☑ |
|
IsBillable |
boolean |
itgen_ibz_isbillable |
☐ |
|
IsLeaf |
boolean |
itgen_ibz_isleaf |
☑ |
|
Milestone |
boolean |
itgen_ibz_milestone |
☑ |
|
MinimumMargin |
int32 |
itgen_ibz_minimummargin |
☑ |
|
MinimumMarkup |
int32 |
itgen_ibz_minimummarkup |
☑ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
NotBillableHours |
int64 |
itgen_ibz_notbillablehours |
☑ |
|
ParentId |
int32 |
itgen_ibz_parentid |
☑ |
|
PastActuals |
int64 |
itgen_ibz_pastactuals |
☑ |
|
Planned |
int64 |
itgen_ibz_planned |
☑ |
|
PlannedCost |
decimal |
itgen_ibz_plannedcost |
☑ |
|
PlannedSales |
decimal |
itgen_ibz_plannedsales |
☑ |
|
ProjectBudgetAllocation |
int32 |
itgen_ibz_projectbudgetallocation |
☑ |
|
ProjectDepartmentId |
int32 |
itgen_ibz_projectdepartmentid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectOverheadFactorCosts |
decimal |
itgen_ibz_projectoverheadfactorcosts |
☐ |
|
ProjectOverheadFactorTime |
decimal |
itgen_ibz_projectoverheadfactortime |
☐ |
|
ProjectWorkHoursPerDay |
decimal |
itgen_ibz_projectworkhoursperday |
☐ |
|
RegisteredCostsTime |
decimal |
itgen_ibz_registeredcoststime |
☑ |
|
RegisteredSalesTime |
decimal |
itgen_ibz_registeredsalestime |
☑ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☑ |
|
StartDate |
datetimeoffset |
itgen_ibz_startdate |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☑ |
|
SubsequentPlanning |
decimal |
itgen_ibz_subsequentplanning |
☑ |
|
SubsequentPlanningCosts |
decimal |
itgen_ibz_subsequentplanningcosts |
☑ |
|
SubsequentPlanningSales |
decimal |
itgen_ibz_subsequentplanningsales |
☑ |
|
TaskBudgetAllocation |
int32 |
itgen_ibz_taskbudgetallocation |
☑ |
|
TaskBudgetType |
int32 |
itgen_ibz_taskbudgettype |
☑ |
|
TaskDiscountPercentage |
decimal |
itgen_ibz_taskdiscountpercentage |
☐ |
|
TaskParentId |
int32 |
itgen_ibz_taskparentid |
☐ |
|
TimeToCompletion |
int64 |
itgen_ibz_timetocompletion |
☑ |
|
ToCompletionCosts |
decimal |
itgen_ibz_tocompletioncosts |
☑ |
|
ToCompletionSales |
decimal |
itgen_ibz_tocompletionsales |
☑ |
|
TotalRegisteredCosts |
decimal |
itgen_ibz_totalregisteredcosts |
☑ |
|
TotalRegisteredSales |
decimal |
itgen_ibz_totalregisteredsales |
☑ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120