Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

Tasks: ionBIZ Taken

Catalogus: ionBIZ

Label: Taken

Ophalen: true

Tabelkolommen

De kolommen van de tabel Tasks worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.

Naam

Datatype

Label

Verplicht

Documentatie

Active

boolean

itgen_ibz_active

 

AllowActualSalesTimeGreaterThenCurrentSalesBudgetTime

boolean

itgen_ibz_allowactualsalestimegreaterthencurrentsalesbudgettime

 

AllowActualsGreaterThenBaseline

boolean

itgen_ibz_allowactualsgreaterthenbaseline

 

AllowAutomaticUpdateOfAssignedResourceHourlyRates

boolean

itgen_ibz_allowautomaticupdateofassignedresourcehourlyrates

 

AllowMoreActualsThanAssigned

boolean

itgen_ibz_allowmoreactualsthanassigned

 

AllowMoreAssignedSalesBudgetThanCurrentSalesBudget

boolean

itgen_ibz_allowmoreassignedsalesbudgetthancurrentsalesbudget

 

AllowMoreTotalAssignedThanBaseline

boolean

itgen_ibz_allowmoretotalassignedthanbaseline

 

AssignedRateBasedOn

int32

itgen_ibz_assignedratebasedon

 

BadgeOrderID

string

itgen_ibz_badgeorderid

 

Baseline

int64

itgen_ibz_baseline

 

BaselineCostsCosts

decimal

itgen_ibz_baselinecostscosts

 

BaselineCostsTime

decimal

itgen_ibz_baselinecoststime

 

BaselineSalesCost

decimal

itgen_ibz_baselinesalescost

 

BaselineSalesTime

decimal

itgen_ibz_baselinesalestime

 

Billable

boolean

itgen_ibz_billable

 

BudgetAllocation

int32

itgen_ibz_budgetallocation

 

BudgetType

int32

itgen_ibz_budgettype

 

ClosingDate

datetimeoffset

itgen_ibz_closingdate

 

Color

string

itgen_ibz_color

 

Comment

string

itgen_ibz_comment

 

CompletedById

int32

itgen_ibz_completedbyid

 

CompletedPercent

int32

itgen_ibz_completedpercent

 

CompletionDate

datetimeoffset

itgen_ibz_completiondate

 

CreationDate

datetimeoffset

itgen_ibz_creationdate

 

CreatorId

int32

itgen_ibz_creatorid

 

CurrentCostsCosts

decimal

itgen_ibz_currentcostscosts

 

CurrentCostsTime

decimal

itgen_ibz_currentcoststime

 

CurrentSalesCost

decimal

itgen_ibz_currentsalescost

 

CurrentSalesTime

decimal

itgen_ibz_currentsalestime

 

CustomerRef

string

itgen_ibz_customerref

 

DailyRate

decimal

itgen_ibz_dailyrate

 

Declarable

boolean

itgen_ibz_declarable

 

DefaultReportingDuration

int64

itgen_ibz_defaultreportingduration

 

DefaultTravelDuration

int64

itgen_ibz_defaulttravelduration

 

DeletedById

int32

itgen_ibz_deletedbyid

 

DeletionDate

datetimeoffset

itgen_ibz_deletiondate

 

DeliveryDate

datetimeoffset

itgen_ibz_deliverydate

 

DepartmentId

int32

itgen_ibz_departmentid

 

Description

string

itgen_ibz_description

 

DiscountPercentage

decimal

itgen_ibz_discountpercentage

 

Duration

decimal

itgen_ibz_duration

 

DurationType

int32

itgen_ibz_durationtype

 

EndDate

datetimeoffset

itgen_ibz_enddate

 

ExcludeFromFlexCalculation

boolean

itgen_ibz_excludefromflexcalculation

 

ExposeToRelationPortal

boolean

itgen_ibz_exposetorelationportal

 

ExternalNoteOnTimesheetIsRequired

boolean

itgen_ibz_externalnoteontimesheetisrequired

 

FunctionId

int32

itgen_ibz_functionid

 

HourlyCost

decimal

itgen_ibz_hourlycost

 

HourlyRate

decimal

itgen_ibz_hourlyrate

 

Id

int32

itgen_ibz_id

 

IntercompanyCostPrice

decimal

itgen_ibz_intercompanycostprice

 

InternalNoteOnTimesheetIsRequired

boolean

itgen_ibz_internalnoteontimesheetisrequired

 

InternalRef

string

itgen_ibz_internalref

 

IsDeleted

boolean

itgen_ibz_isdeleted

 

IsLeaf

boolean

itgen_ibz_isleaf

 

LedgerAccountId

int32

itgen_ibz_ledgeraccountid

 

Location

string

itgen_ibz_location

 

Mileage

decimal

itgen_ibz_mileage

 

MileageFromHours

decimal

itgen_ibz_mileagefromhours

 

MileageType

int32

itgen_ibz_mileagetype

 

MileageUnitCost

decimal

itgen_ibz_mileageunitcost

 

MileageUnitPrice

decimal

itgen_ibz_mileageunitprice

 

Milestone

boolean

itgen_ibz_milestone

 

MinimalPercentageOfUnusedBaselineVsTime

int32

itgen_ibz_minimalpercentageofunusedbaselinevstime

 

MinimalPercentageOfUsedActualsVsBaseline

int32

itgen_ibz_minimalpercentageofusedactualsvsbaseline

 

MinStatusId

int32

itgen_ibz_minstatusid

 

ModifiedById

int32

itgen_ibz_modifiedbyid

 

ModifiedDate

datetimeoffset

itgen_ibz_modifieddate

 

Name

string

itgen_ibz_name

 

NextInvoiceDate

datetimeoffset

itgen_ibz_nextinvoicedate

 

ParentId

int32

itgen_ibz_parentid

 

Priority

int32

itgen_ibz_priority

 

ProjectActivityId

int32

itgen_ibz_projectactivityid

 

ProjectActivityTypeId

int32

itgen_ibz_projectactivitytypeid

 

ProjectId

int32

itgen_ibz_projectid

 

ProjectInvoiceId

int32

itgen_ibz_projectinvoiceid

 

ProjectInvoiceLineId

int32

itgen_ibz_projectinvoicelineid

 

ProjectInvoiceProposalLineId

int32

itgen_ibz_projectinvoiceproposallineid

 

RateType

int32

itgen_ibz_ratetype

 

Reporting

boolean

itgen_ibz_reporting

 

RequiredResourcesPerDay

int32

itgen_ibz_requiredresourcesperday

 

SendTMTimesheetsInvoiceProposalsTaskStatusClosed

boolean

itgen_ibz_sendtmtimesheetsinvoiceproposalstaskstatusclosed

 

Sequence

int32

itgen_ibz_sequence

 

SequenceId

string

itgen_ibz_sequenceid

 

SequenceIdOrder

string

itgen_ibz_sequenceidorder

 

ShortName

string

itgen_ibz_shortname

 

StartDate

datetimeoffset

itgen_ibz_startdate

 

StatusId

int32

itgen_ibz_statusid

 

SysEndTime

datetimeoffset

itgen_ibz_sysendtime

 

SysStartTime

datetimeoffset

itgen_ibz_sysstarttime

 

TicketIsRequiredOnTimesheets

boolean

itgen_ibz_ticketisrequiredontimesheets

 

TimesheetLinked

boolean

itgen_ibz_timesheetlinked

 

TimesheetRuleInvoicingId

int32

itgen_ibz_timesheetruleinvoicingid

 

TimesheetTimesRequired

boolean

itgen_ibz_timesheettimesrequired

 

TransferToProjectId

int32

itgen_ibz_transfertoprojectid

 

Travel

boolean

itgen_ibz_travel

 

 

22-12-2022 20:59 Versie 22.1.101-BETA+3681