ProjectInvoiceProposals: ionBIZ Projectfactuur voorstellen |
Catalogus: ionBIZ
Label: Projectfactuur voorstellen
Ophalen: true
Tabelkolommen
De kolommen van de tabel ProjectInvoiceProposals 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 |
☐ |
|
AddToProjectInvoiceId |
int32 |
itgen_ibz_addtoprojectinvoiceid |
☐ |
|
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 |
☐ |
|
GroupByLocked |
boolean |
itgen_ibz_groupbylocked |
☐ |
|
GroupInvoiceLinesById |
int32 |
itgen_ibz_groupinvoicelinesbyid |
☐ |
|
HoursPerDay |
decimal |
itgen_ibz_hoursperday |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Intercompany |
boolean |
itgen_ibz_intercompany |
☐ |
|
IntercompanyProjectId |
int32 |
itgen_ibz_intercompanyprojectid |
☐ |
|
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 |
☐ |
|
Manual |
boolean |
itgen_ibz_manual |
☐ |
|
ModifiedById |
int32 |
itgen_ibz_modifiedbyid |
☐ |
|
Notes |
string |
itgen_ibz_notes |
☐ |
|
OnlyLevelApprovalProcessId |
int32 |
itgen_ibz_onlylevelapprovalprocessid |
☐ |
|
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 |
☐ |
|
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 |
☐ |
|
ShowPeriodGroupedInvoiceLines |
boolean |
itgen_ibz_showperiodgroupedinvoicelines |
☐ |
|
State |
int32 |
itgen_ibz_state |
☐ |
|
TemplateId |
int32 |
itgen_ibz_templateid |
☐ |
|
Transferred |
boolean |
itgen_ibz_transferred |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model