На экране нет:
А в табличках есть:
Код:
SQL> select * from supermag.smdocuments
2 where
3 id='30ПН017594';
DOCTYPE ID BORNIN CREATEDAT DOCSTATE ISCLOSED OPCODE USEROP CLIENTINDEX LOCATIONFROM LOCATIONTO LOCATION CURRENCYTYPE CURRENCYRATE CURRENCYMULTORDER TOTALSUM TOTALSUMCUR PRICEROUNDMODE ISROUBLES COMMENTARY
------- -------------------------------------------------- -------------------------------- ----------- -------- -------- ------ ------ ----------- ------------ ----------- ----------- ------------ ------------ ----------------- --------------------- --------------------- -------------- --------- --------------------------------------------------------------------------------
WI 30ПН017594 2EF38299B6D74DA7A321B61D779F5B5A 16.11.2011 2 0 0 198 71574 30 1 1,0000 0 876,1900 876,1900 3 1
SQL> select * from supermag.smspec
2 where docid='30ПН017594';
DOCTYPE DOCID SPECITEM DISPLAYITEM ARTICLE QUANTITY EXPQUANTITY ITEMPRICE TOTALPRICE ITEMPRICENOTAX TOTALPRICENOTAX ITEMPRICECUR TOTALPRICECUR CAUSETYPE CAUSEID CAUSESPECITEM
------- -------------------------------------------------- ----------- ----------- -------------------------------------------------- ---------------- ---------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------------------- --------- -------------------------------------------------- -------------
WI 30ПН017594 1 1 003253 20,000 0,000 17,1400 342,8000 15,5820 311,6400 17,1400 342,8000
WI 30ПН017594 2 2 007936 10,000 0,000 17,1400 171,4000 15,5820 155,8200 17,1400 171,4000
WI 30ПН017594 3 3 003248 10,000 0,000 17,1400 171,4000 15,5820 155,8200 17,1400 171,4000
WI 30ПН017594 4 4 013584 5,000 0,000 38,1180 190,5900 34,6520 173,2600 38,1180 190,5900
Как такое может быть?