5. "DAILY COMBINED STATEMENT" ============================= This file will be generated if user has another software ecView (web-statement). File name will be DCyymmdd.TXT. The first line is control record, which contains "Transaction Date". The remaining lines are detail records. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 24 Text File Name: DAILY COMBINED STATEMENT º 34 95 Filler Spaces Record Length = 128 + There will be 6 details record types. 1st Record Type contains Client A/C No & Finance Terms 2nd Record Type contains Client Address 3nd Record Type contains Stock Holding B/F (as at Current Day) 4rd Record Type contains Daily Combined Statement 5th Record Type contains Stock on Hand º 6th Record Type contains Div/Bonus Entitlement (Optional module) First Detail Record Type:- (Client A/C No and Finance Terms) Start Length Content 1 1 Record Type Indicator, set to be 1 2 7 Client A/C No * 9 8 Contract Renewal Date yyyymmdd 17 7 Debit Interest Rate 99.9999 (%) 24 7 Credit Interest Rate 99.9999 (%) 31 7 Penalty Interest Rate 99.9999 (%) 38 1 Interest Basis, Y=Yearly, D=Daily 39 1 Client Type: C=Cash, M=Margin, P=Custodian º 40 89 Filler spaces Record Length = 128 + Note: for Cash/Custodian type client, the following fields are not applicable (no need to be shown on Daily Statement) "Credit Limit" "Contract Renewal Date" "Interest Rates & Basis" * There may be some SB systems where the Length of Client A/C No & Runner Code is more than 7 chars. In such case, the following fields (Client Name to Client Type) will be shifted accordingly. Following is an example of 8 chars Client A/C No:- Start Length Content 1 1 Record Type Indicator, set to be 1 2 8 Client A/C No * 10 8 Contract Renewal Date yyyymmdd 18 7 Debit Interest Rate 99.9999 (%) 25 7 Credit Interest Rate 99.9999 (%) 32 7 Penalty Interest Rate 99.9999 (%) 39 1 Interest Basis, Y=Yearly, D=Daily 40 1 Client Type: C=Cash, M=Margin, P=Custodian º 41 88 Filler spaces Record Length = 128 + Second Detail Record Type:- (Client Address) Start Length Content 1 1 Record Type Indicator, set to be 2 º 2 127 Client Address, Tab Delimited i.e. use TAB (CHR(9)) to delimit each address line Client Address may be upto 4 lines Record Length = 128 + Third Detail Record type:- (Stock Holding B/F as at current day) Start Length Content 1 1 Record Type Indicator, set to be 3 2 5 Stock Holding B/F:- 1st Stock No 7 10 1st Stock Qty B/F, -ve is Oversold 17 5 2nd Stock No 22 10 2nd Stock Qty B/F 32 5 3rd Stock No 37 10 3rd Stock Qty B/F 47 5 4th Stock No 52 10 4th Stock Qty B/F 62 5 5th Stock No 67 10 5th Stock Qty B/F 77 5 6th Stock No 82 10 6th Stock Qty B/F 92 5 7th Stock No 97 10 7th Stock Qty B/F 107 5 8th Stock No 112 10 8th Stock Qty B/F º 122 7 Filler Record Length = 128 + Forth Detail Record Type:- (Daily Combined Statement) Start Length Content 1 1 Record Type Indicator, set to be 4 2 8 Transaction Date, in yyyymmdd format 10 1 Transaction Type 11 8 Transaction Reference No 19 62 Particulars 81 12 Debit Amount 93 12 Credit Amount 105 14 Balance, -ve is credit 119 8 Settlement Date, in yyyymmdd format º 127 1 "Initiated by Intermediary" indicator º 128 1 Filler Record Length = 128 + Fifth Detail Record Type:- (Stock On Hand) Start Length Content 1 1 Record Type Indicator, set to be 5 2 5 Stock No 7 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 17 8 Closing Price 9999.999 25 6 Margin Ratio 99.999 31 1 Y=Trade Suspended 32 1 Y=Bonus Entitlement 33 5 2nd Stock No 38 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 48 8 Closing Price 9999.999 56 6 Margin Ratio 99.999 62 1 Y=Trade Suspended 63 1 Y=Bonus Entitlement 64 5 3rd Stock No 69 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 79 8 Closing Price 9999.999 87 6 Margin Ratio 99.999 93 1 Y=Trade Suspended 94 1 Y=Bonus Entitlement 95 5 4th Stock No 100 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 110 8 Closing Price 9999.999 118 6 Margin Ratio 99.999 124 1 Y=Trade Suspended 125 1 Y=Bonus Entitlement 126 3 Filler (Blank) Record Length = 128 + º Sixth Detail Record Type:- (Dividend/Bonus Entitlement, Optional Item) º Start Length Content º 1 1 Record Type Indicator, set to be E º 2 5 Stock No º 7 15 Stock Code º 22 1 Issue type: D=Div, B=Bonus, W=Warrant, R=Rights, º S=Split, C=Consolidate, X=Expired Warrant º 23 40 Issue Description º 63 8 Ex.Div Date (in yyyymmdd format) º 71 8 Book Closed Date (in yyyymmdd format) º 79 8 Payable Date (in yyyymmdd format) º 87 10 Book Closed Qty º 97 32 Issue Details:- º Type Start Length Content º Div 97 10 Dividend / Share º 107 9 Convert to Bonus Unit Price º Bonus 97 5 Bonus Unit º 102 5 Bonus Base º Warrant 97 5 1st Warrant Unit º 102 5 1st Warrant Base º 107 5 2nd Warrant Unit º 112 5 2nd Warrant Base º Rights 97 5 Rights Unit º 102 5 Rights Base º 107 9 Rights Subscription Price º Split & º Consol 97 5 Old Share Qty º 102 5 New Share Qty º Remaining chars are space filler. º º Record Length = 128 + Finally, an ending record to indicate end of file. Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of First Detail Records 8 6 No. of Second Detail Records 14 6 No. of Third Detail Records 20 6 No. of Forth Detail Records 26 6 No. of Fifth Detail Records 32 6 No. of Sixth Detail Records (Optional) º 38 91 Filler (Blank) Record Length = 128 +