1.1       Batch Upload - Client Registration by Clearing Member (CM)

File begin Indicator Record

 

Description

Data Type

Size

End

Status

Remarks

File begin Indicator

Character

2

2

M

It should be '{}' by default

 

Header Record

 

Description

Data Type

Size

End

Status

Remarks

Batch Number

Integer

7

7

M

 

Record Type

Integer

2

9

M

Header Record (11)

CM BP ID

Character

8

17

M

 

Total number of Detail Records

Integer

5

22

M

 

Filler

Character

10

32

O

 Default Spaces

 

Total

32

 

 

 

 

Detail record

 

Description

Data Type

Size

End

Status

Remarks

Batch Number

Integer

7

7

M

 

Record Type

Integer

2

9

M

Header Record (12)

Line Number

Integer

5

14

M

 

DP Id

Character

8

22

M

 

Client ID

Integer

8

30

M

 

POA ID

Integer

8

38

O

 

NOW Flag

Character

1

39

M

 N by Default, mandatory for NOW POA Registration ('Y')

Filler

Character

11

50

O

 Default spaces

 

Total

50

 

 

 

 

File end Indicator Record

 

Description

Data Type

Size

End

Status

Remarks

File end Indicator

Character

2

2

M

It should be '{}' by default

 

 

1.2       Response file for Client Registration

 

Header Record

 

 

Description

Data Type

Size

End

Status

Remarks

Batch Number

Integer

7

7

M

 

Record Type

Integer

2

9

M

Header Record (11)

CM BP ID

Character

8

17

M

 

Total number of Detail Records

Integer

5

22

M

 

Response Creation Date

Date

8

30

M

 

Response Creation Time

Character

4

34

M

 

 

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 Flag

Character

1

15

M

 

Instruction ID

Integer

15

30

M

 

Instruction capture date time

Date time

14

44

M

System date time

Order Status

Character

2

46

 

 

Rejection reason code 1

Integer

5

51

O

Default '00000'

Rejection reason code 2

Integer

5

56

O

Default '00000'

Rejection reason code 3

Integer

5

61

O

Default '00000'

Rejection reason code 4

Integer

5

66

O

Default '00000'

Filler

Character

10

76

O

Default spaces

 

Total

76

 

 

 

 

Trailer Record

 

Description

Data Type

Size

End

Status

Remarks

Batch Number

Integer

7

7

M

 

Record type

Character

2

9

M

Trailer Record (19)

Filler

Character

10

19

O

Default Spaces

 

Total

19

 

 

 

 

 

1.3       Batch Upload by CM for on behalf of Clients

File begin Indicator Record

 

Description

Data Type

Size

End

Status

Remarks

File begin Indicator

Character

2

2

M

It should be '{}' by default

 

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

Can be used for branch code in future.

CM BP ID

Character

8

23

M

 

Total number of Detail Records

Integer

5

28

M

 

Role

Character

2

30

M

 Role is CM

 

Total

30

 

 

 

 

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

Integer

3

17

M

940 for Auto-Payin Instruction

Transaction Flag

Character

1

18

M

It should be A for all orders

Filler

Character

7

25

O

Not in Use

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

 

Source DP Id

Character

8

77

M

 

Source Client Id

Integer

8

85

M

 

Target CM BP Id

Character

8

93

M

 

Filler

Character

1

94

O

Not in Use

Internal Reference Number/Remarks

Character

20

114

M

Internal Reference ID

POA ID

Integer

8

122

O

 

NOW Flag

Character

1

123

M

 N by default (N,Y or ' ')

NOW Reference number

Integer

20

143

M

 Now Reference Number

Filler

Character

1

144

O

Not in Use

 

Total

144

 

 

 

 

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

Filler

Decimal

15

30

O

Default 15 Zero's

Filler

Decimal

15

45

O

Default 15 Zero's

Filler

Decimal

15

60

O

Default 15 Zero's

DFP Instruction Total Qty

Decimal

15

75

O

12+3 without decimal point

Filler

Decimal

15

90

O

Default 15 Zero's

Delivery Out Instruction Total Qty

Decimal

15

105

O

12+3 without decimal point

Inter Settlement Instruction Total Qty

Decimal

15

120

O

12+3 without decimal point

Inter Depository Instruction Total Qty

Decimal

15

135

O

12+3 without decimal point

Auto Payin Instruction Total Qty

Decimal

15

150

O

12+3 without decimal point

Filler

Decimal

15

165

O

Default 15 Zero's

Filler

Decimal

15

180

O

Default 15 Zero's

Irreversible Delivery Out Total Qty

Decimal

15

195

O

12+3 without decimal point

Pool to Pool Instruction Total Qty

Decimal

15

210

O

Default 15 Zero's

Filler

Decimal

15

225

O

Default 15 Zero's

Filler

Decimal

15

240

O

Default 15 Zero's

Filler

Character

7

247

O

Default spaces

Grand Total of Qty

Decimal

15

262

M

12+3 without decimal point

 

Total

262

 

 

 

 

 

CM Batch Response for Batch Uploaded on behalf of Clients

 

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

CM BP ID

Character

8

23

M

 

Total number of Detail Records

Integer

5

28

M

 

Response Creation Date

Date

8

36

M

 

Response Creation Time

Character

4

40

M

 

Filler

Character

2

42

O

Default Spaces

 

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

 

Transaction Flag

Character

1

18

M

 

Internal Reference Number

Character

20

38

M

 

Internet Transaction Id

Integer

15

53

M

 

Internet Instruction ID

Integer

15

68

M

 

Order Status

integer

2

70

M

 

Instruction capture 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

10

114

O

Default spaces

 

Total

114

 

 

 

 

Trailer of Response file for the batch uploaded by CM

 

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

Can be used for branch code in future

Filler

Decimal

30

45

O

Default 15 Zero's

Filler

Decimal

30

75

O

Default 15 Zero's

Filler

Decimal

30

105

O

Default 15 Zero's

DFP Instruction Accepted Qty

Decimal

15

120

O

12+3 without decimal point

DFP Instruction Rejected Qty

Decimal

15

135

O

12+3 without decimal point

Filler

Decimal

30

165

O

Default 15 Zero's

Delivery Out Instruction Accepted Qty

Decimal

15

180

O

12+3 without decimal point

Delivery Out Instruction Rejected Qty

Decimal

15

195

O

12+3 without decimal point

Inter Settlement Instruction Accepted Qty

Decimal

15

210

O

12+3 without decimal point

Inter Settlement Instruction Rejected Qty

Decimal

15

225

O

12+3 without decimal point

Auto-Payin Instruction Accepted Qty

Decimal

15

240

0

12+3 without decimal point

Auto-Payin Instruction Rejected Qty

Decimal

15

255

O

12+3 without decimal point

Filler

Decimal

30

285

O

Default 30 Zero's

Filler

Decimal

30

315

O

Default 30 Zero's

Filler

Decimal

30

345

O

Default 30 Zero's

Irreversible Delivery Out Accepted Qty

Decimal

15

360

O

12+3 without decimal point

Irreversible Delivery Out Rejected Qty

Decimal

15

375

O

12+3 without decimal point

Pool to Pool Accepted Qty

Decimal

15

390

O

12+3 without decimal point

Pool to Pool Rejected Qty

Decimal

15

405

O

12+3 without decimal point

Inter Depository Delivery Instruction Accepted Qty

Decimal

15

420

O

12+3 without decimal point

Inter Depository Delivery Instruction Rejected Qty

Decimal

15

435

O

12+3 without decimal point

Filler

Decimal

30

465

O

Default 30 Zero's

Filler

Character

7

472

O

Default Spaces

Grand Total of Accepted Qty

Decimal

15

487

M

12+3 without decimal point

Grand Total of Rejected Qty

Decimal

15

502

M

12+3 without decimal point

 

Total

502