# BookingLineGarbagesByProject: Bouw7 Booking Line Garbages 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 Garbages 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 `BookingLineGarbagesByProject`. 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 `BookingLineGarbagesByProject` 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. | | `code` | `varchar2` | Code | ☐ | The article number of the resource entity. | | `comment` | `varchar2` | Comment | ☐ | The comments for this invoice booking. | | `costPrice` | `varchar2` | Costprice | ☐ | The cost price. | | `id` | `int64` | ID | ☐ | The ID of the WasteBooking. | | `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 waste booking is mutable. | | `logDate` | `datetime` | Log Date | ☐ | The log date of this booking in ATOM format. | | `name` | `varchar2` | Name | ☐ | The name of the resource. | | `sellingPrice` | `varchar2` | Selling Price | ☐ | The selling price. | | `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. | | `unitName` | `varchar2` | Unit Name | ☐ | The name of the unit. |