Rptinvoicinginvoicelinesresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Rptinvoicinginvoicelinesresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
|---|---|---|---|---|
AccountManagerId |
int32 |
itgen_ibz_accountmanagerid |
☐ |
|
AccountManagerName |
string |
itgen_ibz_accountmanagername |
☐ |
|
Activity |
string |
itgen_ibz_activity |
☐ |
|
ActivityType |
string |
itgen_ibz_activitytype |
☐ |
|
Advance |
boolean |
itgen_ibz_advance |
☑ |
|
CompanyAddressCode |
string |
itgen_ibz_companyaddresscode |
☐ |
|
CompanyAddressName |
string |
itgen_ibz_companyaddressname |
☐ |
|
CurrencySymbol |
string |
itgen_ibz_currencysymbol |
☐ |
|
CustomerExternalCode |
string |
itgen_ibz_customerexternalcode |
☐ |
|
CustomerId |
string |
itgen_ibz_customerid |
☐ |
|
CustomerName |
string |
itgen_ibz_customername |
☐ |
|
DepartmentExternalCode |
string |
itgen_ibz_departmentexternalcode |
☐ |
|
DepartmentId |
int32 |
itgen_ibz_departmentid |
☐ |
|
DepartmentName |
string |
itgen_ibz_departmentname |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
Discount |
decimal |
itgen_ibz_discount |
☑ |
|
DiscountType |
string |
itgen_ibz_discounttype |
☐ |
|
DocDate |
datetimeoffset |
itgen_ibz_docdate |
☐ |
|
DocNo |
string |
itgen_ibz_docno |
☐ |
|
DueDate |
datetimeoffset |
itgen_ibz_duedate |
☐ |
|
ExternalNote |
string |
itgen_ibz_externalnote |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InvoiceCurrencyName |
string |
itgen_ibz_invoicecurrencyname |
☐ |
|
InvoiceStatusId |
int32 |
itgen_ibz_invoicestatusid |
☐ |
|
InvoiceStatusName |
string |
itgen_ibz_invoicestatusname |
☐ |
|
InvoiceToCustomerId |
string |
itgen_ibz_invoicetocustomerid |
☐ |
|
InvoiceToCustomerName |
string |
itgen_ibz_invoicetocustomername |
☐ |
|
LastPaymentOn |
datetimeoffset |
itgen_ibz_lastpaymenton |
☐ |
|
LedgerAccountId |
int32 |
itgen_ibz_ledgeraccountid |
☐ |
|
LedgerAccountName |
string |
itgen_ibz_ledgeraccountname |
☐ |
|
LedgerAccountNo |
string |
itgen_ibz_ledgeraccountno |
☐ |
|
LineDate |
datetimeoffset |
itgen_ibz_linedate |
☐ |
|
LineType |
int32 |
itgen_ibz_linetype |
☑ |
|
LocalTotalExclVAT |
decimal |
itgen_ibz_localtotalexclvat |
☑ |
|
LocalTotalInclVAT |
decimal |
itgen_ibz_localtotalinclvat |
☑ |
|
LocalUnitPrice |
decimal |
itgen_ibz_localunitprice |
☑ |
|
Month |
string |
itgen_ibz_month |
☐ |
|
OvertimeDetail |
decimal |
itgen_ibz_overtimedetail |
☐ |
|
PaymentCondition |
string |
itgen_ibz_paymentcondition |
☐ |
|
PercentageBillableDescription |
string |
itgen_ibz_percentagebillabledescription |
☐ |
|
ProjectCurrencyName |
string |
itgen_ibz_projectcurrencyname |
☐ |
|
ProjectGroup |
string |
itgen_ibz_projectgroup |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
ProjectInvoiceGroup |
string |
itgen_ibz_projectinvoicegroup |
☐ |
|
ProjectName |
string |
itgen_ibz_projectname |
☐ |
|
ProjectProjectId |
string |
itgen_ibz_projectprojectid |
☐ |
|
ProjectType |
string |
itgen_ibz_projecttype |
☐ |
|
Quantity |
decimal |
itgen_ibz_quantity |
☑ |
|
RelationGroup |
string |
itgen_ibz_relationgroup |
☐ |
|
RelationGroupId |
int32 |
itgen_ibz_relationgroupid |
☐ |
|
RelationType |
string |
itgen_ibz_relationtype |
☐ |
|
RelationTypeId |
int32 |
itgen_ibz_relationtypeid |
☐ |
|
ResourceName |
string |
itgen_ibz_resourcename |
☐ |
|
RevenueMonths |
int32 |
itgen_ibz_revenuemonths |
☑ |
|
RevenueStart |
int32 |
itgen_ibz_revenuestart |
☑ |
|
StructuredReference |
string |
itgen_ibz_structuredreference |
☐ |
|
TaskDepartment |
string |
itgen_ibz_taskdepartment |
☐ |
|
TaskId |
int32 |
itgen_ibz_taskid |
☐ |
|
TaskName |
string |
itgen_ibz_taskname |
☐ |
|
TotalExclVAT |
decimal |
itgen_ibz_totalexclvat |
☑ |
|
TotalInclVAT |
decimal |
itgen_ibz_totalinclvat |
☑ |
|
UnitPrice |
decimal |
itgen_ibz_unitprice |
☑ |
|
UnitType |
string |
itgen_ibz_unittype |
☐ |
|
Vat |
decimal |
itgen_ibz_vat |
☐ |
|
VatCode |
string |
itgen_ibz_vatcode |
☐ |
|
VatPercentage |
decimal |
itgen_ibz_vatpercentage |
☑ |
|
Year |
int32 |
itgen_ibz_year |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120
ionBIZ API Data Model