Ratakan

Informations :

Smartlist Account Maintenance

This Query is used to create Smartlist Account Maintenance :
Name Window GP : Account Maintenance
Location Window on GP : Financial >> Cards >> Financial >> Account



SP View :




create view ABC_Account_Maintenance    

as    

select     

a.ACTNUMST as 'Account Number',    

b.ACTDESCR as 'Account Description',    

b.ACTALIAS as 'Alias',    

c.ACCATNUM as 'Category Number',    

c.ACCATDSC as 'Category Descripton',    

case b.PSTNGTYP     

when 0 then 'Balance Sheet'    

when 1 then 'Profit and Loss'    

else ''    

end 'Posting Type',    

    

case b.TPCLBLNC    

when 0 then 'Debit'    

when 1 then 'Credit'    

else ''    

end 'Typical Balance',    

    

case b.ACCTENTR     

when 1 then 'Allow'    

when 0 then 'Not Allow'    

else ''    

end 'Allow Account Entry',    

    

case b.ACTIVE    

when 1 then 'Active'    

when 0 then 'Inactive'    

else ''    

end 'Inactive',

b.ACTINDX as 'Account Index',    

b.NOTEINDX as 'NOTEINDX',
d.TXTFIELD as 'Note Description'


from GL00105 a    

left join GL00100 b on a.ACTINDX = b.ACTINDX    

left join GL00102 c on b.ACCATNUM = c.ACCATNUM    

left join SY03900 d on b.NOTEINDX = d.NOTEINDX    

go

grant select on ABC_Account_Maintenance to DYNGRP


Hasilnya : 






No comments