[ОТВЕТИТЬ]
Опции темы
12.08.2010 11:47  
Назым
Касса №14

Цитата:
1001001 {4F0221BE-5F1B-41EA-879C-DDCCE2B8A1ED} 999 (null) (null) Демо-касса №999 1001 3 0 true 2008-10-31 10:59:39.0 1 false
1001002 {EE4B3438-58C2-483F-A5D6-B98FDA3F3F66} 1 (null) (null) Касса №1 1001 5 0 true 2008-11-27 23:56:09.0 1 false
1001003 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001004 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001005 {ED557C21-3176-477D-81BC-439B9BB3A265} 2 (null) (null) Касса №2 1001 8 0 true 2008-12-12 21:07:00.0 2 false
1001006 {95B02832-28F2-47FA-A8ED-E959928B3CE0} 3 (null) (null) Касса №3 1001 5 0 true 2008-12-18 16:04:27.0 1 false
1001007 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001008 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001009 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001010 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001011 {D8FD4774-96F3-41D6-9412-C4E8EE33E9E9} 5 (null) (null) Касса №5 1001 5 0 true 2008-12-19 09:44:13.0 1 false
1001012 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001013 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001014 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001015 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001016 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001017 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001018 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001019 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001020 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001021 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001022 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001023 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001024 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001025 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001026 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001027 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001028 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001029 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001030 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001031 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001032 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001033 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001034 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001035 {F3D74185-46E2-4ACD-BC0D-DCD91936AF15} 666 (null) (null) Касса №666 1001 10 0 true 2009-11-10 12:34:23.0 1 false
1001036 {2EEC103E-4631-4480-B12C-3F189D5BE5D3} 1 (null) (null) Касса №1 1001 5 0 true 2010-02-04 17:11:44.0 1 false
1001037 {C6F21A30-57F8-4C94-8C51-E7329B9292AB} 7 (null) (null) Касса №7 1001 5 0 true 2010-03-04 13:36:50.0 1 false
1001038 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001039 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001040 0 (null) (null) 1001 (null) 0 false (null) 1 false
1001041 {F20A0DA0-271C-472F-A88C-62DD9DAFE2EB} 8 (null) (null) Касса №8 1001 5 0 true 2010-04-23 11:53:26.0 1 false
1002001 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002002 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002003 {050574AE-7403-4337-A9F3-C300BC76A0E1} 1 (null) (null) Касса ГС№1 1002 5 0 true 2008-12-16 00:13:26.0 8 false
1002004 {A474F96E-4140-4CF4-9DE1-1631A074A5B7} 0 (null) (null) Касса №0 1002 5 0 false 2008-12-17 21:31:16.0 2 false
1002005 {7F83AF4D-931F-469A-9B46-E678C406A44C} 2 (null) (null) Касса ГС№2 1002 5 0 true 2008-12-17 21:42:08.0 4 false
1002006 {B627AEE0-9B02-4122-B5D7-EF3233ED24F3} 3 (null) (null) Касса ГС№3 1002 5 0 true 2008-12-17 22:04:58.0 3 false
1002007 {29E134D1-FED2-4E84-8932-311C053EDEC8} 4 (null) (null) Касса ГС№4 1002 5 0 true 2008-12-18 13:42:40.0 3 false
1002008 {275CBD4B-8CEC-4BCD-A59C-AC3DCBB7BBFE} 5 (null) (null) Касса №5 1002 5 0 true 2008-12-18 13:56:01.0 2 false
1002009 {5E1E3A4E-0F2D-4A69-991D-379136266405} 9 (null) (null) Касса №9 1002 5 0 true 2009-08-02 10:06:14.0 1 false
1002010 {DC1D87E9-DBE7-4D43-8BD9-FE2C78E9C580} 10 (null) (null) Касса №10 1002 5 0 true 2009-08-02 12:15:43.0 1 false
1002011 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002012 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002013 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002014 {3679305D-28FF-46E3-9AE5-FE27D9513990} 11 (null) (null) Касса №11 1002 5 0 true 2009-10-01 16:14:25.0 1 false
1002015 {4AEF7513-2703-4807-A938-AC337BA6CEB5} 12 (null) (null) Касса №12 1002 5 0 true 2009-11-10 13:31:12.0 1 false
1002016 {9EA4A380-D3DB-49E8-9F76-F8112EF74F51} 13 (null) (null) Касса №13 1002 5 0 true 2010-01-04 13:40:16.0 1 false
1002017 {EA86E4C4-4EF6-4287-B249-E9CD369909A8} 14 (null) (null) Касса №14 1002 5 0 true 2010-03-02 17:41:15.0 1 false
1002018 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002019 0 (null) (null) 1002 (null) 0 false (null) 1 false
1002020 {61832B99-75CE-41EF-862D-88603C1A9730} 15 (null) (null) Касса №15 1002 5 0 true 2010-04-05 20:06:43.0 1 false
1002021 {C9EE010A-6E37-46D8-9579-FE96A6D84E09} 16 (null) (null) Касса №16 1002 5 0 true 2010-08-05 10:09:59.0 1 false
1003001 {79DA239E-858D-44AA-8867-C4E30801B18B} 1 (null) (null) Касса ЧС№1 1003 5 0 true 2008-12-18 10:23:23.0 2 false
1004001 {F641C682-13ED-4C32-AE95-A61062F68C4C} 1 (null) (null) Касса №1 1004 5 0 false 2008-12-17 16:52:01.0 3 false
1004002 {6B214022-43A6-4A54-92BF-64EF286EDBBB} 1 (null) (null) Касса КС№1 1004 5 0 true 2008-12-18 09:46:02.0 3 false
1004003 {0272A5B9-499E-470A-AAFA-1DBE12F9AA7B} 2 (null) (null) Касса КС№2 1004 5 0 true 2008-12-18 10:00:32.0 2 false
1004004 {611935A3-E44A-4137-8095-F82AD12C448B} 3 (null) (null) Касса №3 1004 5 0 true 2009-12-11 15:25:14.0 1 false
1004005 {DAB12525-F096-487C-838C-44E0E41EA029} 4 (null) (null) Касса №4 1004 5 0 true 2009-12-11 17:04:54.0 1 false
1004006 {F056F0E9-AF85-4CA5-8D12-3646A6FE3E09} 13 (null) (null) Касса №13 1004 5 0 true 2009-12-21 19:02:00.0 1 false
1004007 0 (null) (null) 1004 (null) 0 false (null) 1 false
1004008 {69E5BE5C-A30F-457D-A9F3-C95551DE0E92} 5 (null) (null) Касса №5 1004 5 0 true 2010-03-24 09:49:26.0 1 false
1005001 {07CF0EF5-B4B3-4A6A-BB38-2664E564D89C} 1 (null) (null) Касса Г№1 1005 5 0 true 2008-11-28 20:24:54.0 5 false
1005002 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005003 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005004 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005005 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005006 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005007 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005008 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005009 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005010 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005011 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005012 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005013 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005014 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005015 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005016 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005017 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005018 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005019 0 (null) (null) 1005 (null) 0 false (null) 1 false
1005020 {97080BA3-B6B8-4F9D-A4E8-72F74532E2EB} 2 (null) (null) Касса Г№2 1005 8 0 true 2008-12-16 21:14:28.0 4 false
1007001 {095180DE-BBA9-4256-8F48-07A28AB3BE04} 1 (null) (null) Касса Ч№1 1007 5 0 true 2008-12-07 20:01:20.0 3 false
1007002 0 (null) (null) 1007 (null) 0 false (null) 1 false
1007003 0 (null) (null) 1007 (null) 0 false (null) 1 false
1007004 0 (null) (null) 1007 (null) 0 false (null) 1 false
1007005 0 (null) (null) 1007 (null) 0 false (null) 1 false
1007006 {51F03045-A670-42DB-887F-B56DD28A7081} 2 (null) (null) Касса Ч№2 1007 8 0 true 2008-12-10 01:01:52.0 3 false
1007007 {B39AFB54-D80E-4FD6-A315-28EEAEDB209C} 3 (null) (null) Касса №3 1007 5 0 true 2009-11-01 11:34:03.0 1 false
1007008 {09A0D979-3A22-4454-9739-21A54D0DBD7E} 4 (null) (null) Касса №4 1007 8 0 true 2009-11-01 12:00:09.0 1 false
1008001 {52851A78-AE7C-4911-A1A5-3AA29783D690} 1 (null) (null) Касса К№1 1008 5 0 true 2008-12-09 18:27:50.0 2 false
1008002 {79A91DB6-06C9-4D82-AA23-D37FAED53BC1} 2 (null) (null) Касса К№2 1008 5 0 true 2008-12-09 22:57:05.0 2 false
1008003 {A4A8FA1E-18CF-44AF-BCDA-DA3A793FBDF7} 3 (null) (null) Касса К№3 1008 8 0 true 2008-12-15 18:43:46.0 2 false
 
12.08.2010 11:50  
Mtirt
Код:
SELECT * FROM trm_out_receipt_header t where cash_id=1002017	and global_number=70842;
 
12.08.2010 11:51  
Назым
1002017 69603 70842 456 1 0 (null) (null) 549 156 2010-08-04 21:35:45.0 14 (null)
 
12.08.2010 11:54  
Mtirt
Код:
SELECT * FROM trm_out_receipt_footer t where cash_id=1002017	and id=69603;
 
12.08.2010 12:16  
Назым
1002017 69603 0 2010-08-04 21:35:50.0
 
12.08.2010 12:34  
Mtirt
Код:
SELECT * FROM trm_out_receipt_payment t where cash_id=1002017	and receipt_header=69603;
 
12.08.2010 12:37  
Назым
Цитата:
Сообщение от Mtirt
Код:
SELECT * FROM trm_out_receipt_payment t where cash_id=1002017	and receipt_header=69603;
1002017 114695 69603 0 0 Наличные 43.0000 43.0000 (null) (null) (null) (null) true
 
12.08.2010 12:56  
Mtirt
Код:
 SELECT * FROM trm_out_receipt_discounts t where cash_id=1002017	and receipt_header=69603;
 
12.08.2010 12:57  
Назым
Цитата:
Сообщение от Mtirt
Код:
 SELECT * FROM trm_out_receipt_discounts t where cash_id=1002017	and receipt_header=69603;
1002017 95160 69603 Белая карта 0 8 {CF5F0B7F-114B-4eec-9A85-9CF520963263} 33 (null) (null) (null) 11 12 1 Скидки ТД Руслан 1 Скидки ТД Руслан
1002017 95161 69603 Оптовики 0 16 {598BCEED-DA47-476c-990D-85F15BF34225} 47 (null) (null) (null) 11 14 1 Скидки ТД Руслан 1 Скидки ТД Руслан
1002017 95162 69603 Скидканаупаковку 0 4 {CF5F0B7F-114B-4eec-9A85-9CF520963263} 49 (null) (null) (null) 11 15 1 Скидки ТД Руслан 1 Скидки ТД Руслан
1002017 95163 69603 Снова в школу 01-05 0 19 {CF5F0B7F-114B-4eec-9A85-9CF520963263} 51 (null) (null) (null) 11 16 1 Скидки ТД Руслан 1 Скидки ТД Руслан
 
12.08.2010 13:00  
Mtirt
Бэкап есть?
Предлагаю удалить запись
Код:
 delete FROM trm_out_receipt_discounts t where cash_id=1002017	and id=95161;
И посмотреть, откроется ли на сервере чек.
 
 


Опции темы



Часовой пояс GMT +3, время: 04:56.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.