 |
|
Required input : 1.Database name |
| 2. Database name in Sql.ini (in Program folder) |
|
3. Database name in Tnsnames.ora (in
Oracle\Ora81\Network\Admin\Tnsnames.ora) |
|
4. Entry in Registry
(HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE) |
|
Value String: oraoci & Value
Data: oraclient8.dll |
|
Operations |
|
1.
Create/Verify Indexes |
For create & verify the indexes
1. Select the table and check the indexes. 2. If Indexes
shown in Invalid Indexes Box then click on recreate the
verified. |
|
2. Import
Security file |
XXX |
|
3. Create
Security file |
XXX |
|
4. Trial
Balance Difference query |
For view the difference in balance
at a particular date |
|
5. Trim
Database |
It is for trim the
unwanted space in front of any name/code etc.(string
value) or to change "NULL" (number) to "0". for this
user have to select default updation for whole database
or if user want to trim in a particular table then
select customized updation and select the coloumn name
and click on update after selecting Trim string values
or Update Null Values with Zero click on proceed. |
|
6. Add Columns |
Add new columns to connected database tables |
|
7. Extend
Rollback Segment |
It is for extend rollback segments
(user has to check all the boxes and proceed a message
will generated ROLLBACK SEGMENT SUCCESSFULLY ALTERED) |
|
8. Master
Checking |
It is for checking
duplicate entries or blank entries in Master Tables
( Partytrn, Stocktrn, Partytrn/Partymst_fixes) |
|
9. Flagging
Change |
It is for change
Flagging "Y" or "N" in a particular table columns |
|
10. Tune New
Database |
It is for tune a new
database for import the backup (creates a user
SYSADM with passoword SYSADM) |
|
11. Symbol
Change |
It is for change the
symbol in fopro |
|
12. Contact
Notes Nos Deletion |
It is for delete the
contact notes from a particular date |
|
13. Initialize
Maintenance Level |
It is for initialize
maintaince level in Capex & Fopro |
|
14. BSE ISIN
Master Import |
It is for import
ISIN master file (BSE) import. |
|
15. Export for
Internet Trading |
XXX |
| |
|
|
Query Analyzer |
It is to perform the
various queries & get the printout of the result |
| |
|
|
Sebi/Nse/IT
QueryReports |
|
|
1. Sett.
Wise/Client Wise/Scrip Wise Query |
It is for view the
report 1. Select the exchange 2. Give the date from & to
you want to show the report 3. Give the scrip code 4.
Also select the type of client code you are giving
(actual or short). |
|
2. SEBI
Turnover/No of Contracts Report |
This report is for
SEBI inspection 1. Select the market (capital or FO) 2.
Select the exchange 3. Give the date from & to you want
to show the report 4. Give the trading group code and
click on calculate 5. A message will appear "data
successfully calculated" view the report |
|
3. Turnover
Calculation (Turn75) |
This report is for
SEBI inspection 1. Select the exchange 2. Give the
period 3. Give the Trading Group Code 4. Select the
report type (Client Wise or Scrip Wise) 5. If selection
is Scrip wise then also select the print type (Volume
Basis or Value Basis) 6. Click on calculate a message
will appear "data successfully calculated", then view
the report |
|
4. Turnover
Calculation (Turn65) |
Same as above for
maind65 package |
|
5. Transaction
Details for Income Tax |
This report is for
INCOME TAX purpose 1. Select the exchange 2. Give the
period (from & to) you want to show the report 3. Give
the min. transaction value 4. Give the mode of payment
(cash or cheque ) 5. If you want to view report on
unique code basis (actual code or short code) then check
on unique code basis and select client code type 6. If
want to ignore some codes then type in Ignore codes 7.
If want to ignore group code then type the group code 8.
If want to client wise summary then check the box
9. If want to show only those records which have no pan
numbers then check the box. 10. If want to export a file
then give the path & file name and click on make file,
else just click on view /dos print/windows print. |
|
6. Jobbing
Turnover Calculation (as per SEBI) |
This report is for
turnover calculation for SEBI 1. Select the exchange2.
Give the period (from & to) you want to show the report
3. Enter the client codes & click on calculate 4. It
will show the Jobbing purchase, jobbing sale, others
purchase, others sales. |
| |
|
|
Adhoc |
|
|
1. Brokerage
Calculator |
XXX |
|
2. Account
Transfer Entry |
XXX |
|
3. Demat Ledger |
XXX |
|
4. Demat
Balances |
XXX |
|
5. Daily
Valuation Report |
XXX |
| |
|
| |
|
