Download TWS User Manual ( Admin)

3 Appendix A – CTCL Users File Structure
3.1 Header Record
Sr
No
1
2
Field
Data type
Record Type
Date
Char(2)
Date
Mand
atory
Yes
Yes
3
Batch Number
Number(2)
Yes
4
5
Trading Member Code
Number of Records
Number(5)
Number(8)
Yes
Yes
Description
Should be “01”
Current date in format DDMMMYYYY.
E.g. 21Jan2013
Serial number of the file being
uploaded for a given date.
Trading member code
Total number of detail records in the
file
3.2 Detail Record
Sr
No
1
Field
Data type
Record Type
Char(2)
Mand
atory
Yes
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Market Segment
VSAT/ LL ID
Dealer Code
CTCL Address – 1
CTCL Address – 2
CTCL Address – 3
City
Pin Code
State/Union Territory
Telephone No
Fax No
Email
Contact Person Name
Designation
Connectivity mode
Approved Person Name
Father’s name of
Approved Person
Approved Person Date of
birth
Approved Person
Address - 1
Approved Person
Address - 2
Approved Person
Address - 3
Approved Person City
Approved Person State
Approved Person
Permanent Address - 1
Approved Person
Permanent Address - 2
Char (1)
Char (13)
Number(8)
Char (50)
Char (50)
Char (50)
Char (50)
Number(6)
Char (50)
Char (25)
Char (25)
Char (250)
Char (50)
Char (25)
Char (25)
Char (50)
Yes
No
Yes
Yes
No
No
Yes
Yes
Yes
Yes
No
No
Yes
No
Yes
Yes
Char (50)
Yes
Date
Yes
Char (50)
Yes
Char (50)
No
Char (50)
Char (50)
Char (50)
No
Yes
Yes
Char (50)
Yes
Char (50)
No
18
19
20
21
22
23
24
25
26
Description
Should be “20”
S = Spot
F = Future
Dealer code
Format DDMMMYYYY. E.g. 21Jan2013
19