ProjectInvoiceLines: ionBIZ Projectfactuurregels |
Catalogus: ionBIZ
Label: Projectfactuurregels
Ophalen: true
Tabelkolommen
De kolommen van de tabel ProjectInvoiceLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Advance |
boolean |
itgen_ibz_advance |
☐ |
|
AdvanceClosed |
boolean |
itgen_ibz_advanceclosed |
☐ |
|
DateFrom |
datetimeoffset |
itgen_ibz_datefrom |
☐ |
|
DateTo |
datetimeoffset |
itgen_ibz_dateto |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
DiscountPercentage |
decimal |
itgen_ibz_discountpercentage |
☐ |
|
DiscountType |
int32 |
itgen_ibz_discounttype |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
IssueId |
int32 |
itgen_ibz_issueid |
☐ |
|
LedgerAccountId |
int32 |
itgen_ibz_ledgeraccountid |
☐ |
|
LineType |
int32 |
itgen_ibz_linetype |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
OvertimeDetail |
decimal |
itgen_ibz_overtimedetail |
☐ |
|
PercentageBillableDescription |
string |
itgen_ibz_percentagebillabledescription |
☐ |
|
ProjectActivityTypeId |
int32 |
itgen_ibz_projectactivitytypeid |
☐ |
|
ProjectCostId |
int32 |
itgen_ibz_projectcostid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceFeeId |
int32 |
itgen_ibz_projectinvoicefeeid |
☐ |
|
ProjectInvoiceId |
int32 |
itgen_ibz_projectinvoiceid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
RevenueMonths |
int32 |
itgen_ibz_revenuemonths |
☐ |
|
RevenueStart |
int32 |
itgen_ibz_revenuestart |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TransferFromProjectId |
int32 |
itgen_ibz_transferfromprojectid |
☐ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☐ |
|
UnitQuantity |
decimal |
itgen_ibz_unitquantity |
☐ |
|
UnitTypeId |
int32 |
itgen_ibz_unittypeid |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model