Vwprojectinvoicelines |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Vwprojectinvoicelines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
CreditNote |
boolean |
itgen_ibz_creditnote |
☐ |
|
CurrencyId |
int32 |
itgen_ibz_currencyid |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
Discount |
decimal |
itgen_ibz_discount |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Intercompany |
boolean |
itgen_ibz_intercompany |
☐ |
|
InvoiceContractCurrencyId |
int32 |
itgen_ibz_invoicecontractcurrencyid |
☐ |
|
InvoiceContractId |
int32 |
itgen_ibz_invoicecontractid |
☐ |
|
InvoiceCurrencyId |
int32 |
itgen_ibz_invoicecurrencyid |
☐ |
|
InvoiceDocDate |
datetimeoffset |
itgen_ibz_invoicedocdate |
☐ |
|
InvoiceId |
int32 |
itgen_ibz_invoiceid |
☐ |
|
InvoiceQuoteId |
int32 |
itgen_ibz_invoicequoteid |
☐ |
|
InvoiceQuoteMultiCurrencyId |
int32 |
itgen_ibz_invoicequotemulticurrencyid |
☐ |
|
InvoiceRelationDefaultCurrencyId |
int32 |
itgen_ibz_invoicerelationdefaultcurrencyid |
☐ |
|
InvoiceRelationId |
int32 |
itgen_ibz_invoicerelationid |
☐ |
|
IssueId |
int32 |
itgen_ibz_issueid |
☐ |
|
ProjectCostCurrencyId |
int32 |
itgen_ibz_projectcostcurrencyid |
☐ |
|
ProjectCostId |
int32 |
itgen_ibz_projectcostid |
☐ |
|
ProjectCurrencyId |
int32 |
itgen_ibz_projectcurrencyid |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
Sequence |
int32 |
itgen_ibz_sequence |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TotalAfterLineDiscount |
decimal |
itgen_ibz_totalafterlinediscount |
☐ |
|
TotalExclVAT |
decimal |
itgen_ibz_totalexclvat |
☐ |
|
TotalInclVAT |
decimal |
itgen_ibz_totalinclvat |
☐ |
|
TotalLine |
decimal |
itgen_ibz_totalline |
☐ |
|
TotalLineDiscount |
decimal |
itgen_ibz_totallinediscount |
☐ |
|
TotalVAT |
decimal |
itgen_ibz_totalvat |
☐ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☐ |
|
UnitQuantity |
decimal |
itgen_ibz_unitquantity |
☐ |
|
VatCode |
string |
itgen_ibz_vatcode |
☐ |
|
VatPercentage |
decimal |
itgen_ibz_vatpercentage |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120