siv.specification_item_uid
siv.agreement_version
d.contract
d.dt_contract
a.agreement
a.dt_agreement
siv.agreement_version
siv.quantity
siv.price
siv.specification_item_version
specification_item_version siv
left outer join specification_item si on (siv.specification_item_uid=si.specification_item_uid)
left outer join specification s on (si.specification_id=s.specification_id)
left outer join contract d on (s.contract_id=d.contract_id)
left outer join contragent k on (d.contragent_id=k.contragent_id)
left outer join agreement a on (siv.agreement_version=a.agreement_version AND s.contract_id=a.contract_id)
siv.specification_item_uid
siv.agreement_version
select
si.specification_item_uid
,s.specification
,svc.svc
from specification_item si
left outer join specification s on (si.specification_id=s.specification_id)
left outer join svc on (si.svc_id=svc.svc_id)
where si.specification_item_uid=
Удаление строки спецификации
#qDecoration.specification#
#qDecoration.svc#
[#specification_item_uid#]
#markup#