Unos OS u registra

Unos iu tmp tabele OS u registar

--delete tHE_FA
--delete tHE_SetFADeprecGroup
--delete tHE_SetFADeprecGroupDet

select * from tHE_SetFAClassif
select * from tHE_SetFADeprecGroup
select * from tHE_SetFADeprecGroupDet

create table os
(acInventNum char (16),
acName char (80),
anQty int,
anRevAcqVal decimal (18,2),
anRevWrtOffVal decimal (18,2),
acDeprecGrp char (20),
acAcct char (13),
acAcctDeprCR char (13),
acAcctDeprDB char (13),
acLocID varchar (100),
acResponsible char (100),
adDateOfActivat datetime,
adDateOdAcq datetime,
acStstus char (10))

select * from os

insert into tHE_SetFADeprecGroupDet (acDeprecGrp, acName, anMinRate)
select acDeprecGrp, 'Grupa: ' + rtrim(acDeprecGrp) + ' %', cast(replace(acDeprecGrp, ',', '.') as decimal (18,2))
from os
group by acDeprecGrp, 'Grupa: ' + rtrim(acDeprecGrp) + ' %', cast(replace(acDeprecGrp, ',', '.') as decimal (18,2))

select g.acAcct
from os g
left join tDE_SetAccountCode t on g.acAcct = t.acAcct
where t.acAcct is null

select g.acAcct
from os g
left join tDE_SetAccount t on g.acAcct = t.acAcct
where t.acAcct is null
---
insert into tDE_SetAccountCode (acAcct)
select g.acAcctDeprCR
from os g
left join tDE_SetAccountCode t on g.acAcctDeprCR = t.acAcct
where t.acAcct is null

insert into tDE_SetAccount (acAcct)
select g.acAcctDeprCR
from os g
left join tDE_SetAccount t on g.acAcctDeprCR = t.acAcct
where t.acAcct is null
---
insert into tDE_SetAccountCode (acAcct)
select g.acAcctDeprDB
from os g
left join tDE_SetAccountCode t on g.acAcctDeprDB = t.acAcct
where t.acAcct is null

insert into tDE_SetAccount (acAcct)
select g.acAcctDeprDB
from os g
left join tDE_SetAccount t on g.acAcctDeprDB = t.acAcct
where t.acAcct is null

-------------------

select acStstus from os group by acStstus

select * from os where acStstus = '0'

select acInventNum, count(*)
from os
group by acInventNum
having count(*) > 1

insert into tHE_FA (acInventNum, acName, acFieldSC, anQty, anAmountAcq, anRemVal, acDeprecGrp, acAcct, acAcctDeprCR, acAcctDeprDB, adDateActivation, adDateOfAcq, acFieldSA,acFieldSB, acSetOf)
select acInventNum, left(acName,50), acName, anQty, anRevAcqVal, anRevAcqVal-anRevAcqVal, rtrim(acDeprecGrp), acAcct, acAcctDeprCR, acAcctDeprDB,
adDateOfActivat, adDateOdAcq, acLocID, acResponsible, acStstus
from os

insert into tHE_FAItem (acInventNum, anNo, adDate, anRevAcqVal, anRevWrtOffVal, acStatus, acTypOfEntry, acAcct, acCurrency, anQty)
select acinventNum, 1, '2016-12-31', anRevAcqVal, anRevWrtOffVal, 'AK', '1', acAcct, 'KM', anQty
from os