This checkbox indicates that the column is part of the primary business key when set. Multiple columns can form the primary business key. This indicator is set and cleared by QAD Data Warehouse Designer during the Data Store Object update procedure generation process. This check box should not normally be altered.

Each Data Store Object column can have a transformation associated with it. The transformation will be included in the generated procedure and will be executed as part of the procedure update. The transformation must therefore be a valid SQL construct that can be included in a 'Select' statement. For example we could have a transformation of 'load_order_line.qty * 0.125' to calculate a tax column of 12.5%. Click the 'Transformation' tab to enter a transformation.