What is this for?
--- In Axapta-Knowledge-Village@yahoogroups.com, "p.saravanakumar"
<[EMAIL PROTECTED]> wrote:
>
> Dear Kareem
>
> It is useful for you.
>
>
>
> select DATAAREAID,ASSETGROUP, assetid, NAME, TECHINFO1, TECHINFO2,
> TECHINFO3, sum(assetval) assetval, sum(netbookvalue) netbookvalue
> from
> (
> sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
> E.TECHINFO2, E.TECHINFO3,
> SUM(b.AMOUNTMST) ASSETVAL,
> 0 NetBookValue
> FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B,
> AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D,
> AXATVSTST.ASSETTABLE E
> Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID
> AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE
> AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID
> AND B.TRANSTYPE IN (1,2) AND B.TRANSDATE <
> TO_DATE('01/04/2006','DD/MM/YYYY')
> GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
> E.TECHINFO2, E.TECHINFO3
>
> union
>
> sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
> E.TECHINFO2, E.TECHINFO3,
> SUM(0) ASSETVAL,
> SUM(b.AMOUNTMST) NetBookValue
> FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B,
> AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D,
> AXATVSTST.ASSETTABLE E
> Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID
> AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE
> AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID
> AND B.TRANSDATE < TO_DATE('01/04/2006','DD/MM/YYYY')
> GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
> E.TECHINFO2, E.TECHINFO3
> ) WHERE ASSETGROUP BETWEEN '033' AND '033' group by DATAAREAID,
> ASSETGROUP,assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3
>
>
>
> Regards
>
> P Saravanakumar
> Co-Its
> 09894999281
> -----Original Message-----
> From: Kareem [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 28, 2007 12:07 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] AssetBook and AssetTrans
>
> Hi,
>
> I want to know more about these two tables: AssetBook and
AssetTrans.
>
> I know that AssetTrans contains all the transactions of fix assets,
but
> how is it related to AssetBook? I noted that not all transactions
that
> exist in TransTable are in the assetBook table? so what data
actually
> is stored in the AssetBook?and when this table is updated?
>
> thanks,
>
>
>
> [Non-text portions of this message have been removed]
>