subaccounts

  • Thread starter Thread starter G
  • Start date Start date
G

G

I am working on a asset database and was wondering the best way to create
Main - sub - sub accounts for the types of assets?
 
Thanks, G.

Steve said:
TblAssetAccount
AssetAccountID
AssetAccount

TblAssetSubAccount
AssetSubAccountID
AssetAccountID
AssetSubAccount

TblAssetSubSubAccount
AssetSubSubAccountID
AssetSubAccountID
AssetSubSubAccount


Steve
Click to expand...
 
G said:
I am working on a asset database and was wondering the best way to create
Main - sub - sub accounts for the types of assets?
Click to expand...


What do you really need? Is it a unique account number for an asset that has
several layers? A main account number containing a sub account number that
could contain further divisions. In that case, the asset needs a unique key
and should have secondary keys for the account, sub account and sub-sub
account.

John... Visio MVP
 
Hi G

I think Steve's suggestion is rather inflexible. What if you need more than
three levels? What if you want to reclassify an account as being somewhere
else in the hierarchy?

I would favour a structure something like this:

AccID (primary key)
AccName
AccParent (null for top-level accounts, otherwise the ID of the parent)
AccOrder (the numeric order that the account should be listed among its
siblings)
AccPostable (boolean - whether or not transactions may be posted to this
account [false for an account that is only a header])
 
Go with Graham's method. It is much better.
As Graham said, the other suggestion, although workable, is inflexible.
 
Back
Top