Smart
Card Investor Instruction - Batch Upload File Format
|
File
begin Indicator Record |
Description
|
Data Type
|
Size
|
End
|
Status
|
Remarks
|
File Begin Indicator
|
Character
|
2
|
2
|
M
|
{} by default
|
|
|
Header
Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
11 (Header Record)
|
Filler
|
Character
|
6
|
15
|
O
|
Default Spaces
|
DP Id
|
Character
|
8
|
23
|
M
|
|
Client ID
|
Integer
|
8
|
31
|
M
|
|
Total No. Of
Detail Records
|
Integer
|
5
|
36
|
M
|
|
File Creation
Date
|
Date
|
8
|
44
|
M
|
|
File Creation
Time
|
Time
|
4
|
48
|
M
|
|
Filler
|
Character
|
2
|
50
|
O
|
Default Spaces
|
|
|
Total
|
50
|
|
|
|
|
|
Delivery
to Pool |
Description
|
Data Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
12 (Detail Record)
|
Line Number
|
Integer
|
5
|
14
|
M
|
|
Transaction
Type
|
Integer
|
3
|
17
|
M
|
904 - Delivery
to Pool 904 - Delivery to Client
|
Transaction
Flag
|
Character
|
1
|
18
|
M
|
Default 'A'
|
Filler
|
Character
|
7
|
25
|
O
|
Default Spaces
|
ISIN
|
Character
|
12
|
37
|
M
|
|
Quantity
|
Decimal
|
15
|
52
|
M
|
12+3 without
decimal point
|
Market Type
|
Integer
|
2
|
54
|
M
|
|
Settlement Number
|
Character
|
7
|
61
|
M
|
|
Execution Date
|
Date
|
8
|
69
|
M
|
|
Filler
|
Character
|
16
|
85
|
O
|
Default Spaces
|
CM BP Id
|
Character
|
8
|
93
|
M
|
|
Internal Reference
Number/Remarks
|
Character
|
20
|
113
|
O
|
|
Filler
|
Character
|
25
|
138
|
O
|
Default Spaces
|
|
|
Total
|
138
|
|
|
|
|
|
Delivery
to Client |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
12 (Detail Record)
|
Line Number
|
Integer
|
5
|
14
|
M
|
|
Transaction
Type
|
Integer
|
3
|
17
|
M
|
904 - Delivery
to Pool 904 - Delivery to Client
|
Transaction
Flag
|
Character
|
1
|
18
|
M
|
Default 'A'
|
Filler
|
Character
|
7
|
25
|
O
|
Default Spaces
|
ISIN
|
Character
|
12
|
37
|
M
|
|
Quantity
|
Decimal
|
15
|
52
|
M
|
12+3 without
decimal point
|
Filler
|
Character
|
9
|
61
|
O
|
Default Spaces
|
Execution Date
|
Date
|
8
|
69
|
M
|
|
DP Id
|
Character
|
8
|
77
|
M
|
|
Client Id
|
Integer
|
8
|
85
|
M
|
|
Filler
|
Character
|
8
|
93
|
O
|
Default Spaces
|
Internal Reference
Number/Remarks
|
Character
|
20
|
113
|
O
|
Default
Spaces
|
Consideration
|
Integer
|
15
|
128
|
M
|
The trailing extra characters, if any, to be filled with spaces
No decimal Values should be allowed.
Mandatory in case of reason code as 01. For remaining reason codes it will be fillers
|
Reason Code
|
Character
|
2
|
130
|
M
|
Allowed values are 01,02,03,04,05,06,07,08,99
|
Filler
|
Character
|
1
|
131
|
M
|
Space should be provided
|
Purpose
|
Character
|
22
|
153
|
M
|
The trailing extra characters, if any, to be filled with spaces
Mandatory for Reason code '99' and for remaining it will be spaces.
|
Market Type
|
Integer
|
2
|
155
|
O
|
Mandatory only for target is RGESS Clients
|
Settlement Number
|
Character
|
7
|
162
|
O
|
Mandatory only for target is RGESS Clients
|
CC Id
|
Character
|
8
|
170
|
O
|
Mandatory only for target is RGESS Clients
|
Filler
|
Character
|
3
|
173
|
O
|
Default Spaces
|
|
|
Total
|
173
|
|
|
|
|
|
Inter Depository Delivery Instruction |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
12 (Detail Record)
|
Line Number
|
Integer
|
5
|
14
|
M
|
|
Transaction
Type
|
Integer
|
3
|
17
|
M
|
925- Inter Depository Delivery
|
Transaction
Flag
|
Character
|
1
|
18
|
M
|
Default 'A'
|
Filler
|
Character
|
7
|
25
|
O
|
Default Spaces
|
ISIN
|
Character
|
12
|
37
|
M
|
|
Quantity
|
Decimal
|
15
|
52
|
M
|
12+3 without
decimal point
|
Filler
|
Character
|
9
|
61
|
O
|
Default Spaces
|
Execution Date
|
Date
|
8
|
69
|
M
|
|
Client Code
|
Character
|
16
|
85
|
M
|
This would be the target Client code
|
Other Depository Id
|
Character
|
8
|
93
|
M
|
This would be the target Depository Id (IN000026)
|
Internal Reference
Number/Remarks
|
Character
|
20
|
113
|
O
|
Default
Spaces
|
Consideration
|
Integer
|
15
|
128
|
M
|
The trailing extra characters, if any, to be filled with spaces
No decimal values should be allowed.
Mandatory in case of reason code as 01. For remaining reason codes it will be fillers
|
Reason Code
|
Character
|
2
|
130
|
M
|
Allowed values are 01,02,03,04,05,06,07,08,99,09,10,11
|
Filler
|
Character
|
1
|
131
|
M
|
Space should be provided
|
Purpose
|
Character
|
22
|
153
|
M
|
The trailing extra characters, if any, to be filled with spaces
Mandatory for Reason code '99' and for remaining it will be spaces.
|
Settlement Details
|
Integer
|
13
|
166
|
O
|
If settlement detail is provided then it must be of 13 digits
End position will be moved to 166.
|
Filler
|
Character
|
7
|
173
|
O
|
Default Spaces
|
|
|
Total
|
173
|
|
|
|
|
|
|
Trailer
Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
19 (Trailer
Record)
|
Filler
|
Character
|
6
|
15
|
O
|
Default Spaces
|
Delivery to
Pool Instructions Total Quantity
|
Decimal
|
15
|
30
|
O
|
12+3 without
decimal point
|
Delivery to
Client Instructions Total Quantity
|
Decimal
|
15
|
45
|
O
|
12+3 without
decimal point
|
Inter Depository Delivery Instructions(IDD) Total Quantity
|
Decimal
|
15
|
60
|
O
|
12+3 without decimal point
|
Filler
|
Decimal
|
15
|
75
|
O
|
Default "000000000000000"
|
Filler
|
Decimal
|
15
|
90
|
O
|
Default "000000000000000"
|
Filler
|
Decimal
|
15
|
105
|
O
|
Default "000000000000000"
|
Filler
|
Decimal
|
15
|
120
|
O
|
Default "000000000000000"
|
Filler
|
Decimal
|
15
|
135
|
O
|
Default "000000000000000"
|
Grand Total
Of Quantity
|
Decimal
|
15
|
150
|
O
|
12+3 without
decimal point
|
|
|
Total
|
150
|
|
|
|
|
|
File
end Indicator Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
File End Indicator
|
Character
|
2
|
2
|
M
|
{} by default
|
|
|
|
Smart
Card Investor Instruction - Batch Upload - Response File Format
|
Header
Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
Header Record
(11)
|
Filler
|
Character
|
6
|
15
|
O
|
Default Spaces
|
DP Id
|
Character
|
8
|
23
|
M
|
|
Client ID
|
Integer
|
8
|
31
|
M
|
|
Total Number
Of Detail Records
|
Integer
|
5
|
36
|
M
|
|
Response Creation
Date
|
Date
|
8
|
44
|
M
|
|
Response Creation
Time
|
Character
|
4
|
48
|
M
|
|
Filler
|
Character
|
2
|
50
|
O
|
Default Spaces
|
|
|
Total
|
50
|
|
|
|
|
|
Detail
Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
Detail Record
(12)
|
Line Number
|
Integer
|
5
|
14
|
M
|
|
Transaction
Type
|
Character
|
3
|
17
|
M
|
904 - Delivery
to Pool
904 -
Delivery to Client
925 - InterDepository Delivery Instruction
|
Transaction
Flag
|
Character
|
1
|
18
|
M
|
A - Accepted
R - Rejected
|
Internal Reference
Number
|
Character
|
20
|
38
|
O
|
|
Internal Transaction
Id
|
Integer
|
15
|
53
|
M
|
|
Internal Instruction
ID
|
Integer
|
15
|
68
|
M
|
|
Status
|
Integer
|
2
|
70
|
M
|
10 - Accepted
; 99 - rejected
|
Instruction
Acceptance/ Rejection Date Time
|
Date Time
|
14
|
84
|
M
|
System Date
Time
|
Rejection Reason
Code 1
|
Integer
|
5
|
89
|
O
|
Default '00000'
|
Rejection Reason
Code 2
|
Integer
|
5
|
94
|
O
|
Default '00000'
|
Rejection Reason
Code 3
|
Integer
|
5
|
99
|
O
|
Default '00000'
|
Rejection Reason
Code 4
|
Integer
|
5
|
104
|
O
|
Default '00000'
|
Filler
|
Character
|
2
|
106
|
O
|
Default Spaces
|
|
|
Total
|
106
|
|
|
|
|
|
Trailer
Record |
Description
|
Data
Type
|
Size
|
End
|
Status
|
Remarks
|
Batch Number
|
Integer
|
7
|
7
|
M
|
|
Record Type
|
Integer
|
2
|
9
|
M
|
Trailer Record
(19)
|
Filler
|
Character
|
6
|
15
|
O
|
Default Spaces
|
Delivery to
Pool Instruction Accepted Qty
|
Decimal
|
15
|
30
|
O
|
12+3 without
decimal point
|
Delivery to
Pool Instruction Rejected Qty
|
Decimal
|
15
|
45
|
O
|
12+3 without
decimal point
|
Delivery to
Client Instruction Accepted Qty
|
Decimal
|
15
|
60
|
O
|
12+3 without
decimal point
|
Delivery to
Client Instruction Rejected Qty
|
Decimal
|
15
|
75
|
O
|
12+3 without
decimal point
|
Inter Depository Delivery Instruction Accepted Qty
|
Decimal
|
15
|
90
|
O
|
12+3 without decimal point
|
Inter Depository Delivery Instruction Rejected Qty
|
Decimal
|
15
|
105
|
O
|
12+3 without decimal point
|
Filler
|
Decimal
|
15
|
120
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
135
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
150
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
165
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
180
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
195
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
210
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
225
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
240
|
O
|
Default 000000000000000
|
Filler
|
Decimal
|
15
|
255
|
O
|
Default 000000000000000
|
Grand Total
of Accepted Qty
|
Decimal
|
15
|
270
|
M
|
12+3 without
decimal point
|
Grand Total
of Rejected Qty
|
Decimal
|
15
|
285
|
M
|
12+3 without
decimal point
|
|
|
Total
|
285
|
|
|
|
|
|