Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
SELECT * FROM `fd_mdr`
Full texts uid bases_id
id базы
updated_at created_at id skf_id
Вид документа
shr_id
Характеристика документа - (as_shr) Константа: …
ddok
Дата документа
ndok
Номер документа
tdok
Время документа
pu
признак оборота. = 1-приход =2-расход
sabor_kid
Клиента - (as_sabor)
sabor_rid
ID Резидента - (as_sabor)
sumv
на сумму
sgo_id
валюта - (as_sgo)
kurs
Курс - (fd_skv)
tn_id
ID накладной
tp_id
ID платежки
s_id
ID связанного документа
dob
Дата обработки
date_plan
Планируемая дата платежа
deb
Дебет по плану счетов -as_sps
kre
Кредит по плану счетов -as_sps
prim
примечание
dtz timz msut_id
Идентификатор транзакции (MS_MSUT:ID)
mz_id
Идентификатор заказа
orders_id
Идентификатор заказа orders id
pay_type
0 - безнал, 1 - наличные, 2 - карточка
stnds
Ставка НДС, для позиции в транзакции
sumnds
Сумма НДС
ext_data
Внешние данные
processing_date
UTC timestamp процесингово центра
device_id
Идентификатор устройства
spz_id
Склад (as_spz)
spd_id
Идентификатор устройства
source_id
Источник операции
payment_status
0 - Ожидает оплаты, 1 - Оплачено, 2 - Не оплачено
fiscal_spd_id
id устройства для фискализации
0x00000000000000000000000000000000 NULL 2025-12-05 11:48:52 2025-12-05 11:48:52 0 0 2 2025-12-05 INVOICE-254-0 11:48:52 1 1 1 1 1 1 0 0 0 NULL NULL NULL NULL NULL 2025-12-05 11:48:52 0 0 0 17 0 0 {"test":true,"original_ndok":"TEST-20251205114852"... NULL NULL NULL NULL 3 0 0
0041CB04-EFC3-72 254 2025-10-02 10:01:34 2025-10-02 10:01:34 2676 0 2 2025-10-02 S59399294 12:01:34 1 16 1 15 166 1 0 0 0 0000-00-00 0000-00-00 2025-10-02 12:01:34 1186 14 0 17 0 0 0 3 1 SHOWCASE 0 0
008E158D-6084-42 212 2025-07-03 09:48:24 2025-07-03 09:48:24 37 0 1 2025-07-03 NEW_PRODUCTS_186 12:48:24 1 4 1 1000 1 1 0 0 38 2025-07-03 0000-00-00 2025-07-03 12:48:24 6 0 0 1 0 0 0 1 0 1 0
00AC1C16-2FD8-1C 178 2025-07-08 13:11:45 2025-07-08 13:11:27 365 0 2 2025-07-08 P51980287 16:11:27 1 18 1 100 1 1 0 0 366 2025-07-08 0000-00-00 2025-07-08 16:11:27 609 120 0 1 0 0 {"is_full_sale":1} 0 4 5 1 0
00CB2E9D-8668-D6 212 2025-07-03 09:22:29 2025-07-03 09:22:29 6 0 2 2025-07-03 NEW_PRODUCTS_184 12:22:29 2 4 1 1000 1 1 0 0 5 2025-07-03 0000-00-00 2025-07-03 12:22:29 4 0 0 1 0 0 0 1 0 1 0
02FB9792-2013-9F 207 2025-07-30 16:29:52 2025-07-30 16:29:52 138 0 1 2025-07-30 S53892992 18:29:52 2 6 1 40 166 1 0 0 137 2025-07-30 0000-00-00 2025-07-30 18:29:52 149 34 0 17 0 0 0 3 1 SHOWCASE 0 0
037E6581-6239-9D 207 2025-08-07 12:59:19 2025-08-07 12:59:19 189 0 2 2025-08-07 14880389046472704 12:59:18 1 6 1 15 166 1 0 0 182 0000-00-00 0000-00-00 0000-00-00 198 0 0 17 0 0 0 1 1 SKLAD 1 0
038BDC69-B3F0-BB 207 2025-08-11 13:23:06 2025-08-11 13:23:06 230 0 1 2025-08-11 NN15 00:00:00 2 3 1 15 166 1 0 0 231 2025-08-11 0000-00-00 2025-08-11 15:23:06 239 0 0 17 0 0 0 1 4 1 0
039AA982-1457-D2 207 2025-08-06 08:36:41 2025-08-06 08:36:41 166 0 1 2025-08-06 S54469401 10:36:41 2 6 1 15 166 1 0 0 165 2025-08-06 0000-00-00 2025-08-06 10:36:41 186 45 0 17 0 0 0 3 1 SHOWCASE 0 0
0408B671-C724-D7 207 2025-08-29 12:08:20 2025-08-29 12:08:20 307 0 1 2025-08-29 TEST_1756469300 15:08:20 2 3 1 100 166 1 0 0 308 2025-08-29 0000-00-00 2025-08-29 14:08:20 291 0 0 1 0 0 0 1 0 1 0
052E7F64-0C73-8A 178 2025-06-27 10:40:03 2025-06-27 10:40:03 324 0 1 2025-06-27 W51020802 00:00:00 1 7 1 212 1 1 0 0 323 2025-06-27 0000-00-00 2025-06-27 13:40:03 538 0 0 5 0 0 {"amount":212,"pay_type":4,"parent_document_number... 0 1 3 SKLAD 1 0
05AE5F65-B674-62 178 2025-07-18 12:11:39 2025-07-18 12:11:39 404 0 1 2025-07-18 D40692517 12:11:34 2 18 1 354 1 1 0 0 361 2025-07-18 0000-00-00 2025-07-18 15:11:39 666 117 0 1 0 0 {"add_detail_name":"","add_detail_value":"","clien... 0 4 10 KASSA 1 0
06276A5B-E72C-26 178 2025-09-02 11:00:57 2025-09-02 11:00:57 484 0 1 2025-09-02 W56810856 00:00:00 1 7 1 331 1 1 0 0 483 2025-09-02 0000-00-00 2025-09-02 14:00:57 765 0 0 5 0 0 {"amount":331,"pay_type":4,"parent_document_number... 0 1 3 SKLAD 1 0
063D76FC-D199-3B 212 2025-07-03 09:48:24 2025-07-03 09:48:24 38 0 2 2025-07-03 NEW_PRODUCTS_186 12:48:24 2 4 1 1000 1 1 0 0 37 2025-07-03 0000-00-00 2025-07-03 12:48:24 6 0 0 1 0 0 0 1 0 1 0
06A5CC12-B1BB-70 178 2025-09-02 11:42:21 2025-09-02 11:42:21 488 0 2 2025-09-02 W56813341 00:00:00 1 7 1 123 1 1 0 0 0 0000-00-00 0000-00-00 2025-09-02 14:42:21 769 160 0 5 0 0 0 1 1 SKLAD 1 0
074B2FE3-1602-27 178 2025-07-10 13:11:43 2025-07-10 13:11:43 378 0 1 2025-07-10 W52153103 00:00:00 2 6 1 11 1 1 0 0 379 2025-07-10 0000-00-00 2025-07-10 16:11:43 633 0 0 5 0 0 0 1 1 SKLAD 1 0
074F4B0F-659B-0A 178 2025-07-18 13:07:14 2025-07-18 13:07:14 411 0 1 2025-07-18 D44031287 13:07:12 2 18 1 354 1 1 0 0 410 2025-07-18 0000-00-00 2025-07-18 16:07:14 675 141 0 1 0 0 {"add_detail_name":"","add_detail_value":"","clien... 0 1 10 KASSA 1 0
07694E78-2101-B9 178 2025-09-01 13:41:39 2025-09-01 13:41:39 479 0 2 2025-09-01 D34089807 13:41:35 1 7 1 236 1 1 0 0 0 0000-00-00 0000-00-00 2025-09-01 16:41:39 760 157 0 1 0 0 {"add_detail_name":"","add_detail_value":"","clien... 0 1 10 KASSA 1 0
0895ADEB-EE9A-27 178 2025-09-11 09:06:02 2025-09-11 09:06:02 517 0 1 2025-09-11 W57581562 00:00:00 1 6 1 642 1 1 0 0 516 2025-09-11 0000-00-00 2025-09-11 12:06:02 825 0 0 5 0 0 {"amount":642,"pay_type":4,"parent_document_number... 0 2 3 SKLAD 1 0
08C20C56-5691-0D 207 2025-07-29 13:53:48 2025-07-29 13:53:48 108 0 1 2025-07-29 S53797228 15:53:48 2 6 1 25 166 1 0 0 107 2025-07-29 0000-00-00 2025-07-29 15:53:48 104 19 0 17 0 0 0 3 1 SHOWCASE 0 0
090FEA80-5466-F8 254 2025-10-19 19:38:27 2025-10-19 19:38:27 2697 0 2 2025-10-19 W60902707 00:00:00 1 16 1 32 166 1 0 0 0 0000-00-00 0000-00-00 2025-10-19 21:38:27 1220 29 0 17 0 0 0 1 1 SKLAD 1 0
0922B248-7CB4-D8 178 2025-06-27 12:41:38 2025-06-27 12:41:38 341 0 1 2025-06-27 P28084419 15:41:25 2 16 1 69.58 1 1 0 0 340 2025-06-27 0000-00-00 2025-06-27 15:41:38 565 106 0 1 0 0 {"add_detail_name":"","add_detail_value":"","clien... 0 1 7 KASSA 1 0
09261120-9DFB-43 212 2025-07-03 09:48:23 2025-07-03 09:48:23 16 0 2 2025-07-03 NEW_PRODUCTS_186 12:48:23 2 4 1 1000 1 1 0 0 15 2025-07-03 0000-00-00 2025-07-03 12:48:23 6 0 0 1 0 0 0 1 0 1 0
09A9CB37-949F-83 254 2025-10-02 07:52:41 2025-10-02 07:52:41 2655 0 2 2025-10-02 1153 00:00:00 1 3 1 80 166 1 0 0 2654 2025-10-02 0000-00-00 2025-10-02 09:52:41 1153 0 0 1 0 0 0 1 0 SKLAD 1 0
09DA5F79-6037-42 254 2025-10-18 13:19:30 2025-10-18 13:19:30 2684 0 1 2025-10-18 W60793570 15:19:30 2 6 1 75 166 1 0 0 0 0000-00-00 0000-00-00 2025-10-18 15:19:30 1198 18 0 17 0 0 0 1 1 SKLAD 0 0