ionBIZ API Data Model
ProjectInvoiceScheduleLines: ionBIZ Projectfactuur Schema Regels |
Catalogus: ionBIZ
Label: Projectfactuur Schema Regels
Ophalen: true
Tabelkolommen
De kolommen van de tabel ProjectInvoiceScheduleLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Advance |
boolean |
itgen_ibz_advance |
☐ |
|
Amount |
decimal |
itgen_ibz_amount |
☐ |
|
ApprovalProcessId |
int32 |
itgen_ibz_approvalprocessid |
☐ |
|
ApproveOnlyThisLevel |
boolean |
itgen_ibz_approveonlythislevel |
☐ |
|
CalculateAmountOnInvoicing |
boolean |
itgen_ibz_calculateamountoninvoicing |
☐ |
|
ContractId |
int32 |
itgen_ibz_contractid |
☐ |
|
ContractLineId |
int32 |
itgen_ibz_contractlineid |
☐ |
|
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 |
☐ |
|
EndDate |
datetimeoffset |
itgen_ibz_enddate |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Invoiced |
boolean |
itgen_ibz_invoiced |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
LastExportDateTime |
datetimeoffset |
itgen_ibz_lastexportdatetime |
☐ |
|
LastInvoiceDate |
datetimeoffset |
itgen_ibz_lastinvoicedate |
☐ |
|
LastRecurrenceDate |
datetimeoffset |
itgen_ibz_lastrecurrencedate |
☐ |
|
LedgerAccountId |
int32 |
itgen_ibz_ledgeraccountid |
☐ |
|
LineType |
int32 |
itgen_ibz_linetype |
☐ |
|
NextInvoiceDate |
datetimeoffset |
itgen_ibz_nextinvoicedate |
☐ |
|
Percentage |
decimal |
itgen_ibz_percentage |
☐ |
|
ProjectBudget |
decimal |
itgen_ibz_projectbudget |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceLineId |
int32 |
itgen_ibz_projectinvoicelineid |
☐ |
|
ProjectInvoiceProposalLineId |
int32 |
itgen_ibz_projectinvoiceproposallineid |
☐ |
|
ProjectInvoiceScheduleId |
int32 |
itgen_ibz_projectinvoicescheduleid |
☐ |
|
Quantity |
decimal |
itgen_ibz_quantity |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
Recurrence |
int32 |
itgen_ibz_recurrence |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
SeparateProposal |
boolean |
itgen_ibz_separateproposal |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TransferToProjectId |
int32 |
itgen_ibz_transfertoprojectid |
☐ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☐ |
|
UseRemainingPercentage |
boolean |
itgen_ibz_useremainingpercentage |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
