Все названия полей взяты из описания.
- Код: Выделить всё
SELECT
transaction.n_transaction AS "НомерТранзакции",
transaction.tr_type AS "ТипТранзакции",
transaction.tr_date_time AS "ДатаТранзакции",
transaction.n_kkm AS "КодККМ",
transaction.n_pc AS "НомерРМК",
transaction.seller AS "КодКассира",
transaction.n_session AS "НомерСмены",
transaction.n_check AS "НомерЧека",
transaction.n_doc AS "НомерДокумента",
transaction.check_type AS "ТипЧека",
CASE WHEN tr_type >= 11 and tr_type <= 14 THEN code END AS "КодТовара",
CASE WHEN tr_type >= 15 and tr_type <= 38 THEN code END AS "ТипСкидки",
CASE WHEN tr_type >= 40 and tr_type <= 41 THEN code END AS "КодВидаОплаты",
CASE WHEN tr_type = 55 THEN code END AS "НомерЧекаВозврата",
CASE WHEN tr_type = 14 THEN code_tax_group END AS "КодНалоговойГруппы",
CASE WHEN tr_type = 14 THEN code_tax_rate END AS "КодНалоговойСтавки",
CASE WHEN tr_type >= 15 and tr_type <= 38 THEN card_code END AS "ИнформацияПоСкидке",
CASE WHEN tr_type >= 11 and tr_type <= 12 THEN value_1 END AS "ЦенаТовара",
--CASE WHEN tr_type >= 15 and tr_type <= 38 THEN ? END AS "Ставка",
--CASE WHEN tr_type >= 40 and tr_type <= 41 THEN ? END AS "СуммаОплаты",
--CASE WHEN tr_type = 55 THEN ? END AS "ИтоговаяСуммаКлиента",
--CASE WHEN tr_type = 50 THEN ? END AS "СуммаВнесения",
--CASE WHEN tr_type = 51 THEN ? END AS "СуммаВыплаты",
--CASE WHEN tr_type >= 60 and tr_type <= 63 THEN ? END AS "НаличностьВКассе",
CASE WHEN tr_type >= 11 and tr_type <= 12 THEN value_2 END AS "КоличествоТовара",
--CASE WHEN tr_type = 14 THEN ? END AS "СуммаНалога",
--CASE WHEN tr_type >= 15 and tr_type <= 38 THEN ? END AS "СуммаСкидки",
--CASE WHEN tr_type = 40 THEN ? END AS "СуммаСдачи",
CASE WHEN tr_type >= 55 and tr_type <= 58 THEN value_2 END AS "ИтоговаяСуммаЧека",
--CASE WHEN tr_type >= 60 and tr_type <= 63 THEN ? END AS "СменныйИтог",
--CASE WHEN tr_type >= 11 and tr_type <= 12 THEN ? END AS "СуммаПозиции",
--CASE WHEN tr_type >= 55 and tr_type <= 58 THEN ? END AS "СуммаЧекаБезОкругления",
--CASE WHEN tr_type >= 60 and tr_type <= 63 THEN ? END AS "Выручка",
CASE WHEN tr_type >= 11 and tr_type <= 12 THEN barcode END AS "ШтрихКод",
CASE WHEN tr_type >= 40 and tr_type <= 41 THEN payment_type END AS "КодДополнительногоВидаОплаты",
--CASE WHEN tr_type >= 11 and tr_type <= 12 THEN ? END AS "КодДополненияТовара",
--CASE WHEN tr_type >= 15 and tr_type <= 38 THEN ? END AS "ВнутреннийКодСкидки",
--CASE WHEN tr_type >= 11 and tr_type <= 12 THEN ? END AS "НомерСекции",
--CASE WHEN tr_type >= 11 and tr_type <= 12 THEN ? END AS "КодМенеджера",
--CASE WHEN tr_type >= 11 and tr_type <= 12 THEN ? END AS "Комментрарий",
CASE WHEN tr_type = 55 THEN manager END AS "КодМенеджера",
CASE WHEN tr_type = 55 or tr_type = 56 or tr_type = 11 or tr_type = 12 THEN comment END AS "Комментарий",
transaction.value_1,
transaction.value_2,
transaction.reduction_type,
transaction.reduction_info,
transaction.auto_scheme_id,
transaction.gain,
transaction.round_sum,
transaction.protokol_type,
transaction.shortcut
FROM
public.transaction;
Спасибо за помощь!
