Счетфактура
SELECT [LG_001_ITEMS].[CODE] AS [STCODE],
[LG_001_ITEMS].[KASTORAMANAME] AS [STNAME],
[LG_001_UNITSETL].[CODE] AS [UNITCODE],
[LG_001_ITMUNITA].[CONVFACT2] AS [PAS],
[LG_001_01_STLINE].[AMOUNT] /[LG_001_ITMUNITA].[CONVFACT2] AS [MICBPAS],
(([LG_001_01_STLINE].[AMOUNT])/[LG_001_ITEMS].[KASTORAMADET])AS AMOUNT,
([LG_001_01_STLINE].[PRICE]*[LG_001_ITEMS].[KASTORAMADET]) AS [PRICE],
(([LG_001_01_STLINE].[TOTAL]/118)* 100)AS [BRTTOT],
([LG_001_01_STLINE].[TOTAL] - (([LG_001_01_STLINE].[TOTAL]/118)* 100))AS [KDV],
[LG_001_01_STLINE].[TOTAL] AS [NETTOT],
[LG_001_ITEMS].[PRODCOUNTRY],
(SELECT [SLNOP].[NAME] FROM [LG_001_01_SLTRANS] [SLTR] INNER JOIN [LG_001_01_SERILOTN] [SLNOP] ON [SLNOP].[LOGICALREF] = [SLTR].[SLREF]  WHERE [SLTR].[STTRANSREF] = [LG_001_01_STLINE].[LOGICALREF] AND [SLTR].[LINENR] = 1  )AS [CODE1] ,
(SELECT [SLNOP].[NAME] FROM [LG_001_01_SLTRANS] [SLTR] INNER JOIN [LG_001_01_SERILOTN] [SLNOP] ON [SLNOP].[LOGICALREF] = [SLTR].[SLREF]  WHERE [SLTR].[STTRANSREF] = [LG_001_01_STLINE].[LOGICALREF] AND [SLTR].[LINENR] = 2  )AS [CODE2] ,
[LG_001_ITEMS].[GumDecCode],
[LG_001_ITEMS].[KASTORAMACODE] AS [FIRMCODE]
FROM [LG_001_01_INVOICE]
 INNER JOIN [LG_001_01_STLINE] ON [LG_001_01_INVOICE].[LOGICALREF] = [LG_001_01_STLINE].[INVOICEREF]
INNER JOIN [LG_001_ITEMS] ON  [LG_001_01_STLINE].[STOCKREF] =  [LG_001_ITEMS].[LOGICALREF]
INNER JOIN [LG_001_UNITSETL] ON [LG_001_UNITSETL].[LOGICALREF] = [LG_001_01_STLINE].[UOMREF]
INNER JOIN [LG_001_ITMUNITA] ON [LG_001_ITEMS].[LOGICALREF] = [LG_001_ITMUNITA].[ITEMREF]
 WHERE [LG_001_01_INVOICE].[TRCODE] =8 AND [LG_001_ITMUNITA].[LINENR] = 2 AND [LG_001_01_INVOICE].[FICHENO] ='E00001396'
order by [FIRMCODE]

Торг-12
SELECT [LG_001_ITEMS].[CODE] AS [STCODE],
[LG_001_ITEMS].[KASTORAMANAME] AS [STNAME],
[LG_001_UNITSETL].[CODE] AS [UNITCODE],
([LG_001_ITMUNITA].[CONVFACT2]/[LG_001_ITEMS].[KASTORAMADET]) AS [PAS],
[LG_001_01_STLINE].[AMOUNT] /[LG_001_ITMUNITA].[CONVFACT2] AS [MICBPAS],
(([LG_001_01_STLINE].[AMOUNT])/[LG_001_ITEMS].[KASTORAMADET])AS AMOUNT,
([LG_001_01_STLINE].[PRICE]*[LG_001_ITEMS].[KASTORAMADET]) AS [PRICE],
(([LG_001_01_STLINE].[TOTAL]/118)* 100)AS [BRTTOT],
([LG_001_01_STLINE].[TOTAL] - (([LG_001_01_STLINE].[TOTAL]/118)* 100))AS [KDV],
[LG_001_01_STLINE].[TOTAL] AS [NETTOT],
[LG_001_ITEMS].[PRODCOUNTRY],
[LG_001_ITEMS].[GumDecCode] ,
[LG_001_ITEMS].[KASTORAMACODE] AS [FIRMCODE],
( SELECT [LG_001_01_ORFICHE].[CliSipNo] FROM  [LG_001_01_ORFICHE]  WHERE [LG_001_01_ORFICHE].[LOGICALREF] = [LG_001_01_STLINE].[ORDFICHEREF]  ) AS CLISIPNO,
[LG_001_ITEMS].[BARCODE],
( SELECT [LG_001_01_ORFICHE].[PALET] FROM  [LG_001_01_ORFICHE]  WHERE [LG_001_01_ORFICHE].[LOGICALREF] = [LG_001_01_STLINE].[ORDFICHEREF]  ) AS PALET
FROM [LG_001_01_INVOICE]
INNER JOIN [LG_001_01_STLINE] ON [LG_001_01_INVOICE].[LOGICALREF] = [LG_001_01_STLINE].[INVOICEREF]
INNER JOIN [LG_001_ITEMS] ON  [LG_001_01_STLINE].[STOCKREF] =  [LG_001_ITEMS].[LOGICALREF]
INNER JOIN [LG_001_UNITSETL] ON [LG_001_UNITSETL].[LOGICALREF] = [LG_001_01_STLINE].[UOMREF]
INNER JOIN [LG_001_ITMUNITA] ON [LG_001_ITEMS].[LOGICALREF] = [LG_001_ITMUNITA].[ITEMREF]
WHERE [LG_001_01_INVOICE].[TRCODE] =8 AND [LG_001_ITMUNITA].[LINENR] = 2 AND [LG_001_01_INVOICE].[FICHENO] ='E00001396'
order by [FIRMCODE]