ionBIZ API Data Model
PurchaseQuoteLines: ionBIZ Aankoop Offerte Lijnen |
Catalogus: ionBIZ
Label: Aankoop Offerte Lijnen
Ophalen: true
Tabelkolommen
De kolommen van de tabel PurchaseQuoteLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Billable |
boolean |
itgen_ibz_billable |
☐ |
|
CostTypeId |
int32 |
itgen_ibz_costtypeid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
DateRequired |
datetimeoffset |
itgen_ibz_daterequired |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DeliveredNo |
decimal |
itgen_ibz_deliveredno |
☐ |
|
DeliveryDate |
datetimeoffset |
itgen_ibz_deliverydate |
☐ |
|
DeliveryStatusId |
int32 |
itgen_ibz_deliverystatusid |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
ExpectedDeliveryDate |
datetimeoffset |
itgen_ibz_expecteddeliverydate |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InvoicingStatusId |
int32 |
itgen_ibz_invoicingstatusid |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
ItemId |
int32 |
itgen_ibz_itemid |
☐ |
|
ItemSupplierVolumeCostMemo |
string |
itgen_ibz_itemsuppliervolumecostmemo |
☐ |
|
LastUnitCostUpdate |
datetimeoffset |
itgen_ibz_lastunitcostupdate |
☐ |
|
Memo |
string |
itgen_ibz_memo |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
ParentId |
int32 |
itgen_ibz_parentid |
☐ |
|
ProjectCostId |
int32 |
itgen_ibz_projectcostid |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
ResourceId |
int32 |
itgen_ibz_resourceid |
☐ |
|
SalesQuoteLine_Id |
int32 |
itgen_ibz_salesquoteline_id |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
StatusId |
int32 |
itgen_ibz_statusid |
☐ |
|
StockId |
int32 |
itgen_ibz_stockid |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
UnitAmount |
decimal |
itgen_ibz_unitamount |
☐ |
|
UnitCost |
decimal |
itgen_ibz_unitcost |
☐ |
|
UnitTypeId |
int32 |
itgen_ibz_unittypeid |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
