ionBIZ API Data Model
Projects: ionBIZ Projecten |
Catalogus: ionBIZ
Label: Projecten
Ophalen: true
Tabelkolommen
De kolommen van de tabel Projects worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
AddressId |
int32 |
itgen_ibz_addressid |
☐ |
|
Baseline |
int64 |
itgen_ibz_baseline |
☐ |
|
BaselineCostsCosts |
decimal |
itgen_ibz_baselinecostscosts |
☐ |
|
BaselineCostsTime |
decimal |
itgen_ibz_baselinecoststime |
☐ |
|
BaselineLocked |
boolean |
itgen_ibz_baselinelocked |
☐ |
|
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 |
☐ |
|
CompanyAddressId |
int32 |
itgen_ibz_companyaddressid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
CurrentCostsCosts |
decimal |
itgen_ibz_currentcostscosts |
☐ |
|
CurrentCostsTime |
decimal |
itgen_ibz_currentcoststime |
☐ |
|
CurrentLocked |
boolean |
itgen_ibz_currentlocked |
☐ |
|
CurrentSalesCost |
decimal |
itgen_ibz_currentsalescost |
☐ |
|
CurrentSalesTime |
decimal |
itgen_ibz_currentsalestime |
☐ |
|
CustomerRef |
string |
itgen_ibz_customerref |
☐ |
|
Declarable |
boolean |
itgen_ibz_declarable |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DepartmentId |
int32 |
itgen_ibz_departmentid |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
EndDate |
datetimeoffset |
itgen_ibz_enddate |
☐ |
|
EngagementClause |
boolean |
itgen_ibz_engagementclause |
☐ |
|
ExcludeFromFlexCalculation |
boolean |
itgen_ibz_excludefromflexcalculation |
☐ |
|
ExposeToRelationPortal |
boolean |
itgen_ibz_exposetorelationportal |
☐ |
|
ExternalNoteOnTimesheetIsRequired |
boolean |
itgen_ibz_externalnoteontimesheetisrequired |
☐ |
|
GroupId |
int32 |
itgen_ibz_groupid |
☐ |
|
HonoraryFeeFormulaId |
int32 |
itgen_ibz_honoraryfeeformulaid |
☐ |
|
HonoraryFeePercentage |
decimal |
itgen_ibz_honoraryfeepercentage |
☐ |
|
Hyperlink |
string |
itgen_ibz_hyperlink |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InternalNoteOnTimesheetIsRequired |
boolean |
itgen_ibz_internalnoteontimesheetisrequired |
☐ |
|
InvoiceDetailTemplateId |
int32 |
itgen_ibz_invoicedetailtemplateid |
☐ |
|
InvoiceItemsUponDelivery |
boolean |
itgen_ibz_invoiceitemsupondelivery |
☐ |
|
InvoiceTemplateId |
int32 |
itgen_ibz_invoicetemplateid |
☐ |
|
InvoiceText |
string |
itgen_ibz_invoicetext |
☐ |
|
InvoiceToAddressId |
int32 |
itgen_ibz_invoicetoaddressid |
☐ |
|
InvoiceToCustomerId |
int32 |
itgen_ibz_invoicetocustomerid |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
LastStatusUpdate |
datetimeoffset |
itgen_ibz_laststatusupdate |
☐ |
|
LinkTimesheetsWithLeads |
boolean |
itgen_ibz_linktimesheetswithleads |
☐ |
|
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 |
☐ |
|
MinStatusId |
int32 |
itgen_ibz_minstatusid |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
MSPFee |
decimal |
itgen_ibz_mspfee |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
OverheadFactorCosts |
decimal |
itgen_ibz_overheadfactorcosts |
☐ |
|
OverheadFactorTime |
decimal |
itgen_ibz_overheadfactortime |
☐ |
|
ProjComment |
string |
itgen_ibz_projcomment |
☐ |
|
ProjectId |
string |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceGroupId |
int32 |
itgen_ibz_projectinvoicegroupid |
☐ |
|
ProjectInvoiceLineId |
int32 |
itgen_ibz_projectinvoicelineid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
ProjectManagerId |
int32 |
itgen_ibz_projectmanagerid |
☐ |
|
ProjectManagerReminder |
boolean |
itgen_ibz_projectmanagerreminder |
☐ |
|
ProjectSupervisorId |
int32 |
itgen_ibz_projectsupervisorid |
☐ |
|
ProjectSupervisorReminder |
boolean |
itgen_ibz_projectsupervisorreminder |
☐ |
|
ProjectTypeId |
int32 |
itgen_ibz_projecttypeid |
☐ |
|
RegimePct |
decimal |
itgen_ibz_regimepct |
☐ |
|
RelationContactId |
int32 |
itgen_ibz_relationcontactid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
SalesManagerId |
int32 |
itgen_ibz_salesmanagerid |
☐ |
|
SalesManagerReminder |
boolean |
itgen_ibz_salesmanagerreminder |
☐ |
|
SendToAddressId |
int32 |
itgen_ibz_sendtoaddressid |
☐ |
|
SLATemplateId |
int32 |
itgen_ibz_slatemplateid |
☐ |
|
StartDate |
datetimeoffset |
itgen_ibz_startdate |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TemplateId |
int32 |
itgen_ibz_templateid |
☐ |
|
TimesheetRuleInvoicingId |
int32 |
itgen_ibz_timesheetruleinvoicingid |
☐ |
|
TransferToProjectId |
int32 |
itgen_ibz_transfertoprojectid |
☐ |
|
WorkHoursPerDay |
decimal |
itgen_ibz_workhoursperday |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
