ionBIZ API Data Model
ProjectInvoices: ionBIZ Projectfacturen |
Catalogus: ionBIZ
Label: Projectfacturen
Ophalen: true
Tabelkolommen
De kolommen van de tabel ProjectInvoices worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
Address_CountryId |
int32 |
itgen_ibz_address_countryid |
☐ |
|
AddressInvoiceName |
string |
itgen_ibz_addressinvoicename |
☐ |
|
Amount |
decimal |
itgen_ibz_amount |
☐ |
|
BookingDate |
datetimeoffset |
itgen_ibz_bookingdate |
☐ |
|
CompanyAddressId |
int32 |
itgen_ibz_companyaddressid |
☐ |
|
ContractId |
int32 |
itgen_ibz_contractid |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CreditNote |
boolean |
itgen_ibz_creditnote |
☐ |
|
CurrencyConvertorFactor |
decimal |
itgen_ibz_currencyconvertorfactor |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
CustomerRef |
string |
itgen_ibz_customerref |
☐ |
|
DefaultLineDiscountPercentage |
decimal |
itgen_ibz_defaultlinediscountpercentage |
☐ |
|
DefaultLineDiscountType |
int32 |
itgen_ibz_defaultlinediscounttype |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
DeliveryDate |
datetimeoffset |
itgen_ibz_deliverydate |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
DetailTemplateId |
int32 |
itgen_ibz_detailtemplateid |
☐ |
|
DiscountPercentage |
decimal |
itgen_ibz_discountpercentage |
☐ |
|
DocDate |
datetimeoffset |
itgen_ibz_docdate |
☐ |
|
DocId |
string |
itgen_ibz_docid |
☐ |
|
DueDate |
datetimeoffset |
itgen_ibz_duedate |
☐ |
|
EqualizedByCreditNoteId |
int32 |
itgen_ibz_equalizedbycreditnoteid |
☐ |
|
EqualizesInvoiceId |
int32 |
itgen_ibz_equalizesinvoiceid |
☐ |
|
ExchangeRateDate |
datetimeoffset |
itgen_ibz_exchangeratedate |
☐ |
|
HoursPerDay |
decimal |
itgen_ibz_hoursperday |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Intercompany |
boolean |
itgen_ibz_intercompany |
☐ |
|
IntercompanyProjectId |
int32 |
itgen_ibz_intercompanyprojectid |
☐ |
|
IntrastatCountryId |
int32 |
itgen_ibz_intrastatcountryid |
☐ |
|
InvoiceInDays |
boolean |
itgen_ibz_invoiceindays |
☐ |
|
InvoiceText |
string |
itgen_ibz_invoicetext |
☐ |
|
InvoiceToAddressId |
int32 |
itgen_ibz_invoicetoaddressid |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
Locked |
boolean |
itgen_ibz_locked |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
Notes |
string |
itgen_ibz_notes |
☐ |
|
NumberRangeId |
int32 |
itgen_ibz_numberrangeid |
☐ |
|
OurRef |
string |
itgen_ibz_ourref |
☐ |
|
PaidOn |
datetimeoffset |
itgen_ibz_paidon |
☐ |
|
PaidOnBankAccountId |
int32 |
itgen_ibz_paidonbankaccountid |
☐ |
|
PaymentComment |
string |
itgen_ibz_paymentcomment |
☐ |
|
PaymentConditionId |
int32 |
itgen_ibz_paymentconditionid |
☐ |
|
ProcessDateTime |
datetimeoffset |
itgen_ibz_processdatetime |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceApprovalPeriodId |
int32 |
itgen_ibz_projectinvoiceapprovalperiodid |
☐ |
|
ProjectInvoiceGroupId |
int32 |
itgen_ibz_projectinvoicegroupid |
☐ |
|
ProjectInvoiceProposalId |
int32 |
itgen_ibz_projectinvoiceproposalid |
☐ |
|
ProjectInvoiceStatusId |
int32 |
itgen_ibz_projectinvoicestatusid |
☐ |
|
QuoteId |
int32 |
itgen_ibz_quoteid |
☐ |
|
RelationContactId |
int32 |
itgen_ibz_relationcontactid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
RelationVat |
string |
itgen_ibz_relationvat |
☐ |
|
RevenueDate |
datetimeoffset |
itgen_ibz_revenuedate |
☐ |
|
SalesManagerId |
int32 |
itgen_ibz_salesmanagerid |
☐ |
|
SendInvoiceByOption |
int32 |
itgen_ibz_sendinvoicebyoption |
☐ |
|
SendToAddress_CountryId |
int32 |
itgen_ibz_sendtoaddress_countryid |
☐ |
|
SendToAddressId |
int32 |
itgen_ibz_sendtoaddressid |
☐ |
|
SendToAddressName |
string |
itgen_ibz_sendtoaddressname |
☐ |
|
StructuredReference |
string |
itgen_ibz_structuredreference |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
TemplateId |
int32 |
itgen_ibz_templateid |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681
