Rptprojectsactualsperresourceresult |
Catalogus: ionBIZ
Ophalen: true
Tabelkolommen
De kolommen van de tabel Rptprojectsactualsperresourceresult worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
ActualHours |
int64 |
itgen_ibz_actualhours |
☐ |
|
BillableHours |
int64 |
itgen_ibz_billablehours |
☐ |
|
CompanyAddress |
string |
itgen_ibz_companyaddress |
☐ |
|
CostsTotal |
decimal |
itgen_ibz_coststotal |
☐ |
|
CostTotalCosts |
decimal |
itgen_ibz_costtotalcosts |
☐ |
|
CostTotalHours |
decimal |
itgen_ibz_costtotalhours |
☐ |
|
CostTotalMileage |
decimal |
itgen_ibz_costtotalmileage |
☐ |
|
CostUnitCostPerDay |
decimal |
itgen_ibz_costunitcostperday |
☐ |
|
CostUnitCostPerHour |
decimal |
itgen_ibz_costunitcostperhour |
☐ |
|
Customer |
string |
itgen_ibz_customer |
☐ |
|
Department |
string |
itgen_ibz_department |
☐ |
|
Difference |
decimal |
itgen_ibz_difference |
☐ |
|
DifferencePct |
int32 |
itgen_ibz_differencepct |
☐ |
|
FunctionName |
string |
itgen_ibz_functionname |
☐ |
|
HoursToBeInvoiced |
int64 |
itgen_ibz_hourstobeinvoiced |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
Intercompany |
boolean |
itgen_ibz_intercompany |
☑ |
|
InvoicedHours |
int64 |
itgen_ibz_invoicedhours |
☐ |
|
Month |
datetimeoffset |
itgen_ibz_month |
☐ |
|
NotBillableHours |
int64 |
itgen_ibz_notbillablehours |
☐ |
|
Profit |
decimal |
itgen_ibz_profit |
☐ |
|
ProfitPct |
int32 |
itgen_ibz_profitpct |
☐ |
|
Project |
string |
itgen_ibz_project |
☐ |
|
ProjectCode |
string |
itgen_ibz_projectcode |
☐ |
|
ProjectGroup |
string |
itgen_ibz_projectgroup |
☐ |
|
ProjectId |
int32 |
itgen_ibz_projectid |
☐ |
|
RelationGroup |
string |
itgen_ibz_relationgroup |
☐ |
|
RequiredSkill |
string |
itgen_ibz_requiredskill |
☐ |
|
Resource |
string |
itgen_ibz_resource |
☐ |
|
ResourceExternalCode |
string |
itgen_ibz_resourceexternalcode |
☐ |
|
ResourceFunction |
string |
itgen_ibz_resourcefunction |
☐ |
|
ResourceIntercompany |
boolean |
itgen_ibz_resourceintercompany |
☑ |
|
ResourceType |
string |
itgen_ibz_resourcetype |
☐ |
|
SalesTotal |
decimal |
itgen_ibz_salestotal |
☐ |
|
SalesTotalCosts |
decimal |
itgen_ibz_salestotalcosts |
☐ |
|
SalesTotalHours |
decimal |
itgen_ibz_salestotalhours |
☐ |
|
SalesTotalMileage |
decimal |
itgen_ibz_salestotalmileage |
☐ |
|
SalesUnitPricePerDay |
decimal |
itgen_ibz_salesunitpriceperday |
☐ |
|
SalesUnitPricePerHour |
decimal |
itgen_ibz_salesunitpriceperhour |
☐ |
|
Task |
string |
itgen_ibz_task |
☐ |
|
TotalInvoicedExclVat |
decimal |
itgen_ibz_totalinvoicedexclvat |
☐ |
|
16-08-2023 19:43 Versie 22.1.262-BETA+4120