Skip to content

Instantly share code, notes, and snippets.

@vkostyanetsky

vkostyanetsky/gist:5ec036ee148606aad9caefbc9305bfb0 Secret

Created February 8, 2022 02:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vkostyanetsky/5ec036ee148606aad9caefbc9305bfb0 to your computer and use it in GitHub Desktop.
Save vkostyanetsky/5ec036ee148606aad9caefbc9305bfb0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Function GetZeroRateVATRateList() Export
Query = New Query;
Query.Text =
"SELECT
| VATRates.Ref AS Ref
|FROM
| Catalog.VATRates AS VATRates
|WHERE
| VATRates.Rate = 0";
Table = Query.Execute().Unload();
ZeroVATRateList = New ValueList;
For Each Row In Table Do
ZeroVATRateList.Add(Row.Ref);
EndDo;
Return ZeroVATRateList;
EndFunction
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment