Use this field to link this SQL query to a column identified as a 'Free column' in the report structure for the selected financial view. That is, where the field Column content (field CODDES) in the Financial overview structure (PJMBUDTRS) function is set to 'Free column 1-10'. This field is mandatory.
This field links this SQL query to the data structure (one of the 'free columns' (Free columns 1-10) in the financial overview database tables); the field Structure link (field PJMPBTCOD) links this query to the report structure for the selected financial view.
If this SQL query retrieves expense values you can assign it to Free columns 1-5 as these columns are predefined specifically for managing costs (expenses) – committed, pre-committed, actual and posted amounts. By default, one expense column tracks 'commitments' and one expense column tracks 'actuals'.
If this SQL query retrieves revenue linked to a project, such as orders or invoices you can assign it to Free columns 6-10.
