Where is codesetup table. Cant setup broker code, account holder, etc.
Codesetup table is in the portfolio.mdb file, which is the database of the application. At the moment, due to limited time, I have not release a UI for managing this table, but you could simply open the table by opening the Access database file and editing the contents of the Codesetup table. Please see the example below that explains how to use and setup values in this table.
The Codes defined for each CodeSet are the values you will see in the Upload Data Tab on the application. To explain this theory, here's an example.
Lets say you would like to manage Portfolios of
1. Mr. Sam Petro
2. Mrs. Sumi Perto
3. Mr. Charles Drum
4. Mrs. Lynn Drum
These 4 individuals deal with the following brokers:
1. Sharekhan
2. ICICIDirect
3. 5Paisa
4. Motilal
5. Reliance
6. Raligare
It is possible that Mr. Sam only deals with Sharekhan whereas Mrs. Sumi deals with all 6 of them, while Mrs. Lynn only works with Reliance and Raligare.
In any case, you should configure all the 4 AccountOwners and the 6 brokers that they are dealing with in the Codesetup as follows :
CodeSet Code Description Sort Order
AccountOwner SAMPETRO Mr. Sam Petro 1
AccountOwner SUMIPETRO Mrs. Sumi Perto 2
AccountOwner Charles Drum Mr. Charles Drum 3
AccountOwner Lynn Drum Mrs. Lynn Drum 4
Similarly, configure the Brokers in the following manner:
CodeSet Code Description Sort Order
BrokerCode Sharekhan Sharekhan 1
BrokerCode ICICDIRECT ICICDIRECT 2
BrokerCode 5Paisa 5Paisa 3
BrokerCode Motilal Motilal 4
BrokerCode Reliance Reliance 5
BrokerCode Raligare Raligare 6
Once you have setup these values in the CodeSetup table you will see them in the Upload Data page.
Hope this helps. I will be releasing the UI for managing this table, but at the moment I am working on higher priority items.
Regards
Rusk