PurchaseInvoiceLines: ionBIZ Inkoop Factuurregels |
Catalogus: ionBIZ
Label: Inkoop Factuurregels
Ophalen: true
Tabelkolommen
De kolommen van de tabel PurchaseInvoiceLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Billable |
boolean |
itgen_ibz_billable |
☐ |
|
CostPrice |
decimal |
itgen_ibz_costprice |
☐ |
|
CostTypeId |
int32 |
itgen_ibz_costtypeid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
Date |
datetimeoffset |
itgen_ibz_date |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
LedgerAccountId |
int32 |
itgen_ibz_ledgeraccountid |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
ModifiedDate |
datetimeoffset |
itgen_ibz_modifieddate |
☐ |
|
ProjectCostId |
int32 |
itgen_ibz_projectcostid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
PurchaseInvoiceId |
int32 |
itgen_ibz_purchaseinvoiceid |
☐ |
|
PurchaseQuoteLineId |
int32 |
itgen_ibz_purchasequotelineid |
☐ |
|
Quantity |
decimal |
itgen_ibz_quantity |
☐ |
|
SalesPrice |
decimal |
itgen_ibz_salesprice |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
UnitTypeId |
int32 |
itgen_ibz_unittypeid |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681