view name(vfbopenorderline) class(kfborder_lines) filter(field(productkit) nu('')) viewcolumn name(id) reference(id) key(true) viewcolumn name(orderid) reference(parentid) viewcolumn name(ordernumber) reference(parentid.OrderNumber) viewcolumn name(quantityordered) reference(QuantityOrdered.Value) viewcolumn name(quantitypaid) reference(QuantityPaid.Value) viewcolumn name(product_description) reference(Product.description) viewcolumn name(remark) reference(remark.text) viewcolumn name(kitchendatetime_startdate) reference(KitchenDateTime.startdate) viewcolumn name(waiter_id) reference(waiter.id) viewcolumn name(waiter_description) reference(waiter.description) viewcolumn name(customer) reference(isnull(parentid.CustomerName,parentid.loyaltycustomer.description)) viewcolumn name(table) reference(parentid.table.description) viewcolumn name(line_table) reference(table.description) viewcolumn name(aliasid) reference(parentid.aliasid) viewcolumn name(KitGroup) reference(KitGroup) viewcolumn name(room) reference(parentid.table.room.description) viewcolumn name(is_deleted) reference(case(or(eq(status,4),eq(delivered,1)),1,0)) type(tkYesNo) viewcolumn name(is_moved) reference(case(eq(status,5),1,0)) type(tkYesNo) viewcolumn name(displaystationrouter) reference(displaystationrouter) viewcolumn name(displaystation) reference(displaystationrouter.Stations.id) function(min) viewcolumn name(highlightsonotherpreparations) reference(isnull(Product.HighLightsOnOtherPreparations,1)) viewcolumn name(kitchendatetime_enddate) reference(KitchenDateTime.EndDate)