# BookingLineEmployeeHoursByProject: Bouw7 Booking Line Employee Hours by Project Returns all available booking items based on its criteria. Returns all available booking items based on its criteria. - Catalog: `Bouw7` - Schema: `Booking` - Label: Booking Line Employee Hours by Project This is a read-only table function. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `BookingLineEmployeeHoursByProject`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `endDate` | `` | ☐ | | End date | | `findForCheckoutDocument` | `` | ☐ | | Whether the booking lines should be retrieved for a checkout document. Available values: 0, 1. | | `project` | `` | ☑ | | Project ID | | `startDate` | `` | ☐ | | Start date | | `type` | `` | ☐ | | Type bit mask | ## Columns of Table Function The columns of the table function `BookingLineEmployeeHoursByProject` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount` | `varchar2` | Amount | ☐ | The unit amount of the Booking object. | | `comment` | `varchar2` | Comment | ☐ | The comments for this invoice booking. | | `costPrice` | `varchar2` | Costprice | ☐ | The cost price. | | `employeeId` | `int64` | Employee ID | ☐ | The ID of the employee. | | `employeeName` | `varchar2` | Employee Name | ☐ | The name of the employee. | | `endTime` | `varchar2` | End Time | ☐ | The end time of the workday. Only available if enabled for your organization. | | `hourTypeName` | `varchar2` | Hour Type Name | ☐ | The hour type name. | | `id` | `int64` | ID | ☐ | The ID of the hour log. | | `invoiceAmount` | `varchar2` | Invoice Amount | ☐ | The amount that will be shown on the invoice. | | `invoiceCostStatusId` | `int64` | Invoice Cost Status ID | ☐ | The invoice cost status id. | | `invoiceDescription` | `varchar2` | Invoice Description | ☐ | The invoice description of the booking item. | | `invoiceLineId` | `int64` | Invoice Line ID | ☐ | The id of the invoice line the booking line is linked to. | | `isMutable` | `char` | | ☐ | Whether the employee hour log booking is mutable. | | `logDate` | `datetime` | Log Date | ☐ | The log date of this booking in ATOM format. | | `sellingPrice` | `varchar2` | Selling Price | ☐ | The selling price. | | `startTime` | `varchar2` | Start Time | ☐ | The start time of the workday. Only available if enabled for your organization. | | `summary_amount` | `varchar2` | Summary Amount | ☐ | Total amount of all items in this category. | | `summary_contactHours_amount` | `varchar2` | Summary Contact Hours Amount | ☐ | Total amount of all items in this category. | | `summary_contactHours_costPrice` | `varchar2` | Summary Contact Hours Cost Price | ☐ | Total cost price of all items in this category. | | `summary_contactHours_invoiceAmount` | `varchar2` | Summary Contact Hours Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_contactHours_itemCount` | `int64` | Summary Contact Hours Item Count | ☐ | Total amount of booking items in this category. | | `summary_contactHours_sellingPrice` | `varchar2` | Summary Contact Hours Selling Price | ☐ | Total selling price of all items in this category. | | `summary_costPrice` | `varchar2` | Summary Cost Price | ☐ | Total cost price of all items in this category. | | `summary_deliveryTickets_amount` | `varchar2` | Summary Delivery Tickets Amount | ☐ | Total amount of all items in this category. | | `summary_deliveryTickets_costPrice` | `varchar2` | Summary Delivery Tickets Cost Price | ☐ | Total cost price of all items in this category. | | `summary_deliveryTickets_invoiceAmount` | `varchar2` | Summary Delivery Tickets Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_deliveryTickets_itemCount` | `int64` | Summary Delivery Tickets Item Count | ☐ | Total amount of booking items in this category. | | `summary_deliveryTickets_sellingPrice` | `varchar2` | Summary Delivery Tickets Selling Price | ☐ | Total selling price of all items in this category. | | `summary_employeeHours_amount` | `varchar2` | Summary Employee Hours Amount | ☐ | Total amount of all items in this category. | | `summary_employeeHours_costPrice` | `varchar2` | Summary Employee Hours Cost Price | ☐ | Total cost price of all items in this category. | | `summary_employeeHours_invoiceAmount` | `varchar2` | Summary Employee Hours Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_employeeHours_itemCount` | `int64` | Summary Employee Hours Item Count | ☐ | Total amount of booking items in this category. | | `summary_employeeHours_sellingPrice` | `varchar2` | Summary Employee Hours Selling Price | ☐ | Total selling price of all items in this category. | | `summary_equipment_amount` | `varchar2` | Summary Equipment Amount | ☐ | Total amount of all items in this category. | | `summary_equipment_costPrice` | `varchar2` | Summary Equipment Cost Price | ☐ | Total cost price of all items in this category. | | `summary_equipment_invoiceAmount` | `varchar2` | Summary Equipment Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_equipment_itemCount` | `int64` | Summary Equipment Item Count | ☐ | Total amount of booking items in this category. | | `summary_equipment_sellingPrice` | `varchar2` | Summary Equipment Selling Price | ☐ | Total selling price of all items in this category. | | `summary_garbage_amount` | `varchar2` | Summary Garbage Amount | ☐ | Total amount of all items in this category. | | `summary_garbage_costPrice` | `varchar2` | Summary Garbage Cost Price | ☐ | Total cost price of all items in this category. | | `summary_garbage_invoiceAmount` | `varchar2` | Summary Garbage Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_garbage_itemCount` | `int64` | Summary Garbage Item Count | ☐ | Total amount of booking items in this category. | | `summary_garbage_sellingPrice` | `varchar2` | Summary Garbage Selling Price | ☐ | Total selling price of all items in this category. | | `summary_invoiceAmount` | `varchar2` | Summary Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_itemCount` | `int64` | Summary Item Count | ☐ | Total amount of booking items in this category. | | `summary_material_amount` | `varchar2` | Summary Material Amount | ☐ | Total amount of all items in this category. | | `summary_material_costPrice` | `varchar2` | Summary Material Cost Price | ☐ | Total cost price of all items in this category. | | `summary_material_invoiceAmount` | `varchar2` | Summary Material Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_material_itemCount` | `int64` | Summary Material Item Count | ☐ | Total amount of booking items in this category. | | `summary_material_sellingPrice` | `varchar2` | Summary Material Selling Price | ☐ | Total selling price of all items in this category. | | `summary_profit` | `varchar2` | Summary Profit | ☐ | The profit. | | `summary_purchaseInvoiceLines_amount` | `varchar2` | Summary Purchase Invoice Lines Amount | ☐ | Total amount of all items in this category. | | `summary_purchaseInvoiceLines_costPrice` | `varchar2` | Summary Purchase Invoice Lines Cost Price | ☐ | Total cost price of all items in this category. | | `summary_purchaseInvoiceLines_invoiceAmount` | `varchar2` | Summary Purchase Invoice Lines Invoice Amount | ☐ | Total invoice amount of all items in this category. | | `summary_purchaseInvoiceLines_itemCount` | `int64` | Summary Purchase Invoice Lines Item Count | ☐ | Total amount of booking items in this category. | | `summary_purchaseInvoiceLines_sellingPrice` | `varchar2` | Summary Purchase Invoice Lines Selling Price | ☐ | Total selling price of all items in this category. | | `summary_sellingPrice` | `varchar2` | Summary Selling Price | ☐ | Total selling price of all items in this category. | | `totalCostPrice` | `varchar2` | Total Cost Price | ☐ | Total cost price. |