Třídová akce

Popis:

Načte řádky pro zobrazení v kase (optimalizace pro vyšší rychlost kasy)

Kód:

59

Tělo:

select
  A.id as ID,
  A.PosIndex as PosIndex,
  sc.code as CODE,
  sc.name,
  sc.shortname,
  sc.mainunitcode,
  sc.category as StoreCard_Category,
  a.iscontainer,
  a.quantity,
  a.unitrate,
  a.unitprice,
  a.qunit,
  a.tamountwithoutvat,
  a.tamount,
  a.documentdiscount,
  a.totalprice,
  a.isdiscount,
  a.storecard_id,
  a.store_id,
  a.StoreDocumentRow_ID,
  a.MacroCard_id,
  a.MacroCardBegin,
  st.code as Store_code,
  st.name as Store_Name,
  su.description as description,
  mc.name as MacroCard_Name,
  mc.shortname as MacroCard_ShortName,
  mc.code as MacroCard_code
from
  posdocuments2 A
  join storecards sc on a.storecard_id=sc.id
  left join storeunits su on (su.parent_id=a.storecard_id) and (su.code=a.qunit)
  left join stores st on a.store_id=st.id
  left join storecards mc on a.macrocard_id=mc.id
where
  A.parent_id=:POSDocument_ID
order by
  A.posindex

Generated by ABRA Software a.s. 27.10.2021 16:34:30