Menu Close

GL Tables

These are what I have found to be the most commonly used tables in GL. 

GL00100 – Account Master
GL00102 – Account Category Master
GL00105 – Account Index Master
GL10000 – Unposted Transactions (header)
GL10001 – Unposted Transactions (line)
GL10110 – Summary Master YTD
GL10111 – Summary Master Historical Years
GL20000 – Posted Transactions YTD
GL30000 – Posted Transactions Historical Years

All check boxes in GP: unchecked is a 0 (zero) in the DB and checked is a 1.

All drop down menus on windows, just count down the selection in the drop down: the first item listed is a 1 in the DB, second a 2, etc.

Leave a Reply

Your email address will not be published. Required fields are marked *