ionBIZ API Data Model
QuoteLines: ionBIZ Citaat lijnen |
Catalogus: ionBIZ
Label: Citaat lijnen
Ophalen: true
Tabelkolommen
De kolommen van de tabel QuoteLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Baseline |
int64 |
itgen_ibz_baseline |
☐ |
|
Billable |
boolean |
itgen_ibz_billable |
☐ |
|
BudgetAllocation |
int32 |
itgen_ibz_budgetallocation |
☐ |
|
BudgetType |
int32 |
itgen_ibz_budgettype |
☐ |
|
Color |
string |
itgen_ibz_color |
☐ |
|
CostTypeId |
int32 |
itgen_ibz_costtypeid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
Discount |
decimal |
itgen_ibz_discount |
☐ |
|
DiscountType |
int32 |
itgen_ibz_discounttype |
☐ |
|
DurationType |
int32 |
itgen_ibz_durationtype |
☐ |
|
EndDate |
datetimeoffset |
itgen_ibz_enddate |
☐ |
|
FunctionId |
int32 |
itgen_ibz_functionid |
☐ |
|
Group |
int32 |
itgen_ibz_group |
☐ |
|
HourlyCost |
decimal |
itgen_ibz_hourlycost |
☐ |
|
HourlyRate |
decimal |
itgen_ibz_hourlyrate |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
ItemId |
int32 |
itgen_ibz_itemid |
☐ |
|
LineType |
int32 |
itgen_ibz_linetype |
☐ |
|
MarginType |
int32 |
itgen_ibz_margintype |
☐ |
|
Memo |
string |
itgen_ibz_memo |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
Optional |
boolean |
itgen_ibz_optional |
☐ |
|
ParentId |
int32 |
itgen_ibz_parentid |
☐ |
|
ParentQuantity |
int32 |
itgen_ibz_parentquantity |
☐ |
|
int32 |
itgen_ibz_print |
☐ |
|
|
PrintCode |
string |
itgen_ibz_printcode |
☐ |
|
ProjectActivityId |
int32 |
itgen_ibz_projectactivityid |
☐ |
|
ProjectActivityTypeId |
int32 |
itgen_ibz_projectactivitytypeid |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
StartDate |
datetimeoffset |
itgen_ibz_startdate |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
UnitAmount |
decimal |
itgen_ibz_unitamount |
☐ |
|
UnitCost |
decimal |
itgen_ibz_unitcost |
☐ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☐ |
|
UnitTypeId |
int32 |
itgen_ibz_unittypeid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
