prs/prs.desktop/Integrations/V6/Classes/V6Finish.cs

using System;
using System.Collections.Generic;
using InABox.Integration.V6;

namespace PRSDesktop.Integrations.V6;

public class V6Finish : V6Object, IV6Finish
{

    public String Code { get; set; }

    public String Description { get; set; }

    public override  void ValidateQuery(string sql, List<string> errors)
    {
        ValidateField(sql, nameof(Code), errors);
        ValidateField(sql, nameof(Description), errors);
        
    }


    public static String SQL = $@"select distinct 
    fc.FINCOL_CODE as {nameof(Code)}, 
    fc.DESCR as {nameof(Description)} 
from 
    bom_piece bp 
join 
    fincol fc on bp.FINCOL_LIB_ID = fc.FINCOL_LIB_ID and bp.FINCOL_ID = fc.FINCOL_ID 
join 
    quote_item qi on bp.QUOTE_ITEM_ID = qi.QUOTE_ITEM_ID 
where 
    1=1 
and 
    bp.QUOTE_ITEM_ID is not null";

}