Evolution 200 Data Tables

SOLVED

Hi There 

Is there a list / data table dictionary available for Sage EVO200 ? 

I want to write my sql queries but need to map an idea if the table structure - other than your usual suspects such as : 

SELECT * FROM _bvGLTransactionsFull = PostGL

select * from _bvSTTransactionsFull = PostST

select * from _bvARTransactionsFull = PostAR

select * from _bvAPTransactionsFull = PostAP

 

select * from _bvARAccountsFull = Client

select * from _bvAPAccountsFull = Vendor

select * from _bvStockFull = StkItem

select * from _evGLAccountsFull = Accounts

Any one that can point me in the right direction ?

Regards,

Parents Reply Children