ionBIZ API Data Model
Quotes: ionBIZ Offertes |
Catalogus: ionBIZ
Label: Offertes
Ophalen: true
Tabelkolommen
De kolommen van de tabel Quotes worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
AccountManagerId |
int32 |
itgen_ibz_accountmanagerid |
☐ |
|
Color |
string |
itgen_ibz_color |
☐ |
|
CompanyAddressId |
int32 |
itgen_ibz_companyaddressid |
☐ |
|
ContractId |
int32 |
itgen_ibz_contractid |
☐ |
|
ContractTypeId |
int32 |
itgen_ibz_contracttypeid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CurrencyConvertorFactor |
decimal |
itgen_ibz_currencyconvertorfactor |
☐ |
|
CustomerRef |
string |
itgen_ibz_customerref |
☐ |
|
Date |
datetimeoffset |
itgen_ibz_date |
☐ |
|
DateWon |
datetimeoffset |
itgen_ibz_datewon |
☐ |
|
DecisionMakerId |
int32 |
itgen_ibz_decisionmakerid |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DepartmentId |
int32 |
itgen_ibz_departmentid |
☐ |
|
Deposit |
decimal |
itgen_ibz_deposit |
☐ |
|
DepositPayedOn |
datetimeoffset |
itgen_ibz_depositpayedon |
☐ |
|
Discount |
decimal |
itgen_ibz_discount |
☐ |
|
DiscountType |
int32 |
itgen_ibz_discounttype |
☐ |
|
EstimatedStartDate |
datetimeoffset |
itgen_ibz_estimatedstartdate |
☐ |
|
ExpectedEndDate |
datetimeoffset |
itgen_ibz_expectedenddate |
☐ |
|
ExpectedOrderDate |
datetimeoffset |
itgen_ibz_expectedorderdate |
☐ |
|
ExposeToRelationPortal |
boolean |
itgen_ibz_exposetorelationportal |
☐ |
|
FollowUpDate |
datetimeoffset |
itgen_ibz_followupdate |
☐ |
|
GroupId |
int32 |
itgen_ibz_groupid |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InternalMemo |
string |
itgen_ibz_internalmemo |
☐ |
|
InvoiceToCustomerId |
int32 |
itgen_ibz_invoicetocustomerid |
☐ |
|
IsActive |
boolean |
itgen_ibz_isactive |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
LanguageId |
int32 |
itgen_ibz_languageid |
☐ |
|
LastModifiedDate |
datetimeoffset |
itgen_ibz_lastmodifieddate |
☐ |
|
LastStatusUpdate |
datetimeoffset |
itgen_ibz_laststatusupdate |
☐ |
|
LeadId |
int32 |
itgen_ibz_leadid |
☐ |
|
Location |
string |
itgen_ibz_location |
☐ |
|
Locked |
boolean |
itgen_ibz_locked |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
MultiCurrencyId |
int32 |
itgen_ibz_multicurrencyid |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
OwnerId |
int32 |
itgen_ibz_ownerid |
☐ |
|
ProjectAddressId |
int32 |
itgen_ibz_projectaddressid |
☐ |
|
ProjectId |
string |
itgen_ibz_projectid |
☐ |
|
ProjectKey |
int32 |
itgen_ibz_projectkey |
☐ |
|
ProjectTypeId |
int32 |
itgen_ibz_projecttypeid |
☐ |
|
QuoteId |
string |
itgen_ibz_quoteid |
☐ |
|
QuoteTextTypeId |
int32 |
itgen_ibz_quotetexttypeid |
☐ |
|
ReasonLostId |
int32 |
itgen_ibz_reasonlostid |
☐ |
|
RelationAddressId |
int32 |
itgen_ibz_relationaddressid |
☐ |
|
RelationContactId |
int32 |
itgen_ibz_relationcontactid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
ScoringPercentage |
int32 |
itgen_ibz_scoringpercentage |
☐ |
|
SLATemplateId |
int32 |
itgen_ibz_slatemplateid |
☐ |
|
SourceId |
int32 |
itgen_ibz_sourceid |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TemplateId |
int32 |
itgen_ibz_templateid |
☐ |
|
TotalPriceAfterLinesDiscount |
decimal |
itgen_ibz_totalpriceafterlinesdiscount |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
