P
PeteCresswell
Muni bonds.
Accounts within accounts.... sort of.
Somebody buys 150 mil of XYZ into account A
Trade ticket for 150 mil goes to fund accounting and we need to know
that's where the money is.
BUT: at the time of the trade, the trader allocates 50 mil of 150 to
account D as XYZ, 75 mil to account F as XYZ, and 25 mil to account M
- also as XYZ.
Now XYZ's 150 mil is in the DB twice: a lump in account A and three
pieces in accounts D, F, and M.
But we need to report on accounts A, D, F, and M the same way. i.e.
they are co-equals for reporting purposes.
Doesn't seem like a parent-child relationship.
But what is it?
Some sort of recursive relationship?
I've *really* got to get this one right.
Anybody been here?
Accounts within accounts.... sort of.
Somebody buys 150 mil of XYZ into account A
Trade ticket for 150 mil goes to fund accounting and we need to know
that's where the money is.
BUT: at the time of the trade, the trader allocates 50 mil of 150 to
account D as XYZ, 75 mil to account F as XYZ, and 25 mil to account M
- also as XYZ.
Now XYZ's 150 mil is in the DB twice: a lump in account A and three
pieces in accounts D, F, and M.
But we need to report on accounts A, D, F, and M the same way. i.e.
they are co-equals for reporting purposes.
Doesn't seem like a parent-child relationship.
But what is it?
Some sort of recursive relationship?
I've *really* got to get this one right.
Anybody been here?