I think you have the right idea. Using the structure you outlined for
all levels would allow you to add a sixth withoutchanging anything
except the reports and forms.
Albert
On 09/05/2013 5:04 PM, Bruce A. Chitiea wrote:
Chart of Accounts: Table Structure
All:
I need to construct a five-level GL code structure, and wondering how
best to design schema to contain it.
Can someone point to an apt example in the SATs?
Is this theright idea?
GLCODE
------------------
P GLCODEID(serial number)
..GLCODE (gl code)
..GLCPARENT (gl code parent)
..GLCDESCRIPTION(gl code description)
Thanks again,
Bruce Chitiea
SafeSectors, Inc.
eCondoMetrics
909.238.9012 cell
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.3336 / Virus Database: 3162/6310 - Release Date: 05/09/13
