ionBIZ API Data Model
Timesheets: ionBIZ Urenregistratie |
Catalogus: ionBIZ
Label: Urenregistratie
Ophalen: true
Tabelkolommen
De kolommen van de tabel Timesheets worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
AbroadAllowance |
boolean |
itgen_ibz_abroadallowance |
☐ |
|
AllowancePerHour |
decimal |
itgen_ibz_allowanceperhour |
☐ |
|
ApproverId |
int32 |
itgen_ibz_approverid |
☐ |
|
Billable |
int64 |
itgen_ibz_billable |
☐ |
|
CostPrice |
decimal |
itgen_ibz_costprice |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
DailyRate |
decimal |
itgen_ibz_dailyrate |
☐ |
|
Date |
datetimeoffset |
itgen_ibz_date |
☐ |
|
Declarable |
int64 |
itgen_ibz_declarable |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DigitalSigningLineId |
int32 |
itgen_ibz_digitalsigninglineid |
☐ |
|
DisapprovalReasonMotivation |
string |
itgen_ibz_disapprovalreasonmotivation |
☐ |
|
DisapprovalTimestamp |
datetimeoffset |
itgen_ibz_disapprovaltimestamp |
☐ |
|
DisapproverResourceId |
int32 |
itgen_ibz_disapproverresourceid |
☐ |
|
ExternalNotes |
string |
itgen_ibz_externalnotes |
☐ |
|
Flex |
boolean |
itgen_ibz_flex |
☐ |
|
HotelAllowance |
boolean |
itgen_ibz_hotelallowance |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
IncludeBreaks |
boolean |
itgen_ibz_includebreaks |
☐ |
|
Intercompany |
boolean |
itgen_ibz_intercompany |
☐ |
|
IntercompanyCostPrice |
decimal |
itgen_ibz_intercompanycostprice |
☐ |
|
IntercompanyNextInvoiceDate |
datetimeoffset |
itgen_ibz_intercompanynextinvoicedate |
☐ |
|
IntercompanyProjectInvoiceId |
int32 |
itgen_ibz_intercompanyprojectinvoiceid |
☐ |
|
IntercompanyProjectInvoiceLineId |
int32 |
itgen_ibz_intercompanyprojectinvoicelineid |
☐ |
|
IntercompanyProjectInvoiceProposalLineId |
int32 |
itgen_ibz_intercompanyprojectinvoiceproposallineid |
☐ |
|
IntercompanyStatus |
int32 |
itgen_ibz_intercompanystatus |
☐ |
|
InternalNotes |
string |
itgen_ibz_internalnotes |
☐ |
|
InterruptedShift |
boolean |
itgen_ibz_interruptedshift |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
IssueId |
int32 |
itgen_ibz_issueid |
☐ |
|
LastExportDateTime |
datetimeoffset |
itgen_ibz_lastexportdatetime |
☐ |
|
LastExportDateTimeIC |
datetimeoffset |
itgen_ibz_lastexportdatetimeic |
☐ |
|
LastModified |
datetimeoffset |
itgen_ibz_lastmodified |
☐ |
|
LeadId |
int32 |
itgen_ibz_leadid |
☐ |
|
LeadRelationId |
int32 |
itgen_ibz_leadrelationid |
☐ |
|
Location |
string |
itgen_ibz_location |
☐ |
|
MatchingCostId |
int32 |
itgen_ibz_matchingcostid |
☐ |
|
Mileage |
decimal |
itgen_ibz_mileage |
☐ |
|
MileageCostPrice |
decimal |
itgen_ibz_mileagecostprice |
☐ |
|
MileageInvoiced |
boolean |
itgen_ibz_mileageinvoiced |
☐ |
|
MileageNextInvoiceDate |
datetimeoffset |
itgen_ibz_mileagenextinvoicedate |
☐ |
|
MileageProjectInvoiceId |
int32 |
itgen_ibz_mileageprojectinvoiceid |
☐ |
|
MileageProjectInvoiceLineId |
int32 |
itgen_ibz_mileageprojectinvoicelineid |
☐ |
|
MileageProjectInvoiceProposalLineId |
int32 |
itgen_ibz_mileageprojectinvoiceproposallineid |
☐ |
|
MileageTransferToProjectId |
int32 |
itgen_ibz_mileagetransfertoprojectid |
☐ |
|
MileageUnitPrice |
decimal |
itgen_ibz_mileageunitprice |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
NightShift |
boolean |
itgen_ibz_nightshift |
☐ |
|
Nightshift2 |
boolean |
itgen_ibz_nightshift2 |
☐ |
|
NotBillable |
int64 |
itgen_ibz_notbillable |
☐ |
|
NotDeclarable |
int64 |
itgen_ibz_notdeclarable |
☐ |
|
Overtime |
boolean |
itgen_ibz_overtime |
☐ |
|
OvertimeDetail |
decimal |
itgen_ibz_overtimedetail |
☐ |
|
PayOut |
boolean |
itgen_ibz_payout |
☐ |
|
PlanningId |
int32 |
itgen_ibz_planningid |
☐ |
|
PredefinedExternalNoteId |
int32 |
itgen_ibz_predefinedexternalnoteid |
☐ |
|
PredefinedInternalNoteId |
int32 |
itgen_ibz_predefinedinternalnoteid |
☐ |
|
ProjectActivityId |
int32 |
itgen_ibz_projectactivityid |
☐ |
|
ProjectActivityTypeId |
int32 |
itgen_ibz_projectactivitytypeid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceApprovalHeaderId |
int32 |
itgen_ibz_projectinvoiceapprovalheaderid |
☐ |
|
ProjectInvoiceId |
int32 |
itgen_ibz_projectinvoiceid |
☐ |
|
ProjectInvoiceLineId |
int32 |
itgen_ibz_projectinvoicelineid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
ResourceId |
int32 |
itgen_ibz_resourceid |
☐ |
|
RuleOvertimeId |
int32 |
itgen_ibz_ruleovertimeid |
☐ |
|
RuleShiftId |
int32 |
itgen_ibz_ruleshiftid |
☐ |
|
SalesPrice |
decimal |
itgen_ibz_salesprice |
☐ |
|
SalesQuoteId |
int32 |
itgen_ibz_salesquoteid |
☐ |
|
StartHour |
datetimeoffset |
itgen_ibz_starthour |
☐ |
|
Status |
int32 |
itgen_ibz_status |
☐ |
|
StopHour |
datetimeoffset |
itgen_ibz_stophour |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TimesheetTimerId |
int32 |
itgen_ibz_timesheettimerid |
☐ |
|
TransferToProjectId |
int32 |
itgen_ibz_transfertoprojectid |
☐ |
|
WorkLocationId |
int32 |
itgen_ibz_worklocationid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
