ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Type 1: 1 text file containing all SB data, being used by Phillip, Hani, º º Tung Tai, Oriental Patron, Celestial, Harmony, Lee On Tat, º º Tarzan, Tat Lee, Prime, Henyep, Yu On, Pacific Challenge, º º Hung Sing, Chief, Christfund, ICBC, Kilmorey, On Wah, º º Wing On Cheong, CSC, CM-CCS, Honfirst º º Web-Statement for: Goldride, KCG º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ Last modified on 15 March 2003. ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Changes Summary:- º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ * To read "SI Transaction" Indicator in Importing Cash P/R Transaction. This field is added to end of line. * Include "T-1 day Cheque Receipt Amount" in 2nd record type in SByymmdd.TXT. * Include Finance Terms in 8th record type in SByymmdd.TXT. * Add additional text file for Stock Dividend/Bonus announcement information. File Name will be SAyymmdd.TXT. * Add "Trade Suspended Indicator" and "Trade Suspended Begin Date" in Stock General Information File (SKyymmdd.Txt) * Add Dividend/Bonus Entitlement in files SByymmdd.TXT with option to suppress it (Optional Item). * Add Cost of Portfolio on Hand (for web-Statement users). * Add additional Text File (CRyymmdd.TXT) to provide commission/rebate rate if user has Multi-Channel module. * Applicable to "Short Sell" module:- Add field to detect a client Sold Trade as "Short Sell". * Export Additional Information in Stock Text File:- CCASS Stock Indicator Require Contract Stamp Stock Closing Price * Add additional Text File (DCyymmdd.TXT) to provided Combined Statement Content, for users of Combined Statement + Web Statement Package. * Change Text File Layout to match with Stock No may be changed from 4 digits to 5 digits when AMS3 is lanuched. * Changes will be highlighted with the symbol º & ³. * To indicate the detail record contains 4 digits or 5 digits stock no, the "RECORD INDICATOR" are changed. Please refer to following table: ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Record ³ Stock no Digits ³ ³ Indicator Content ³ 4 5 ³ ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ ³ Text File SByymmdd.TXT:- ³ ³ ³ 1 Client Balance & Margin Call ³ Y Y ³ ³ 2 Client Name & Runner Name ³ Y Y ³ ³ 3 Client Portfolio ³ Y ³ ³ º A ** Client Portfolio ³ Y ³ ³ 4 Stock Holding B/F ³ Y ³ ³ º B ** Stock Holding B/F ³ Y ³ ³ 5 Statement ³ Y Y ³ ³ º E Dividend/Bonus Entitlement (Optional) Y ³ ³ º F Cost of Portfolio on Hand (Optional)³ Y ³ ³ 8 e-mail address & Finance Terms ³ Y Y ³ ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ ³ Text File SKyymmdd.TXT:- ³ ³ ³ S Stock General Information ³ Y ³ ³ º T ** Stock General Information ³ Y ³ ÃÄÄÄÐÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ ³ Text File UDyymmdd.TXT:- ³ ³ ³ 6 Undue Trades Details ³ Y ³ ³ º D ** Undue Trades Details ³ Y ³ ÃÄÄÄÐÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÅÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ ³ Text File DCyymmdd.TXT:- ³ Y ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÁÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ * Please note that these changes will be implemented in SB Version 6.5. SB Version 6.0 will be stopped when AMS3 is launched. And Version 6.5 allows user to define the Stock No is 4 digits or 5 digits. If the front end trading system is ready to accept text files according to the 5 digits layout in this specification, then user may set the stock no to 5 digits in 6th screen of "(181) System Re-Configuration":- ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ (181) SYSTEM RE-CONFIGURATION (6) ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ No. of digits of Stock No (4,5) : [4] <----- change to 5 ³ ³Margin Client Concentration Discount Factor Effective Date : [12/06/00] (dmy)³ ³ : ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ * The original text file layout will be effective when stock no is 4 digits. * Full list of Stocks in Stock Master will be generated to "Stock General Information" text file. Also, the Stock Margin Ratio is included in this text file. Please refer to "Section 2" for the new text file layout. - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º New Text File Layout, for 5 digits stock no º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ 1. "CLIENT POSITION ENQUIRY" ============================ File name will be SByymmdd.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 23 Text File Name: CLIENT POSITION ENQUIRY 33 80 Company Name 113 16 SB System Serial No 129 9 User Key Record Length = 137 + There will be 6 to 7 details record types. 1st Record Type contains Client Balance & Margin Call, and the 2nd Record Type contains Client Name & Runner Name, 3rd Record Type contains Client Portfolio, 4th Record Type contains Stock Holding B/F (as in Monthly Statement), 5th Record Type contains Statement (as in Monthly Statement). 6th Record Type contains Dividend/Bonus Entitlement of client. (Optional) 7th Record Type contains Cost of Portfolio of Client. (Optional, for web-Stmt) 8th Record Type contains e-mail address & Finance Terms First Detail Record Type:- (Client Balance & Margin Call) Start Length Content 1 1 Record Type Indicator, set to be 1 2 7 Runner (A/E) Code * 9 7 Client A/C No * 16 9 Credit Limit 999999999 25 13 Daily Statement Bal B/F 9999999999.99, -ve is Credit 38 13 Balance C/F (Outstanding) 9999999999.99, -ve is Credit 51 13 Unsettled Balance 9999999999.99, -ve is Credit 64 13 Available Balance 9999999999.99, -ve is Credit 77 11 Month-to-Date Interest 99999999.99, -ve is Credit 88 13 Stock Market Value 9999999999.99, -ve is Oversold 101 13 Stock Margin Value 9999999999.99, -ve is Oversold 114 12 Margin Call (for Deposit) 999999999.99 126 12 Further Purchase Allowed 999999999.99 Record Length = 137 + Note: for Cash type client, the following fields will be zero:- "Month-to-Date Interest" "Stock Margin Value" "Margin Call (for Deposit)" "Further Purchase Allowed" * 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 (Credit Limit to Further Purchase Allowed) 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 Runner (A/E) Code * º 10 8 Client A/C No * º 18 9 Credit Limit 999999999 º 27 13 Daily Statement Bal B/F 9999999999.99, -ve is Credit º 40 13 Balance C/F (Outstanding) 9999999999.99, -ve is Credit º (Including Interest) º 53 13 Unsettled Balance 9999999999.99, -ve is Credit º 66 13 Available Balance 9999999999.99, -ve is Credit º 77 11 Month-to-Date Interest 99999999.99, -ve is Credit º 90 13 Stock Market Value 9999999999.99, -ve is Oversold º 103 13 Stock Margin Value 9999999999.99, -ve is Oversold º 116 12 Margin Call (for Deposit) 999999999.99 º 128 12 Further Purchase Allowed 999999999.99 º ÓÄ Record Length = 139 + Second Detail Record Type:- (Client Name, Runner Name, PIN) Start Length Content 1 1 Record Type Indicator, set to be 2 2 30 1st line of Client Name 32 30 2nd line of Client Name 62 30 Runner Name 92 11 PIN No. ³ 103 8 PIN No Last Effective Date [added on 20 Oct 1999] ³ 111 14 Filler ³ 125 13 T-1 day cheque receipt amount 9999999999.99 -ve is Credit Record Length = 137 + ÖÄSpecial Modification for ICBC:- to include "Internet Trade" indicator º 111 1 Y=Internet Trade º 112 13 Filler ³ 125 13 T-1 day cheque receipt amount 9999999999.99 -ve is Credit ÓÄRecord Length = 137 + ÖÄSpecial Modification for Celestial:- to include "Credit Interest Amount" º 111 11 Month-to-Date Credit Interest 99999999.99, -ve is Credit º 122 3 Filler ³ 125 13 T-1 day cheque receipt amount 9999999999.99 -ve is Credit ÓÄRecord Length = 137 + ÖÄSpecial Modification for some clients:- to include "Hold Fund Amount" º 111 13 Hold Fund Amount 9999999999.99 º 124 1 Filler ³ 125 13 T-1 day cheque receipt amount 9999999999.99 -ve is Credit ÓÄRecord Length = 137 + Third Detail Record Type:- (Stock On Hand) Start Length Content º 1 1 Record Type Indicator, set to be A º 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 5 Another Stock No º 36 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 46 8 Closing Price 9999.999 º 54 6 Margin Ratio 99.999 º 60 5 Another Stock No º 65 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 75 8 Closing Price 9999.999 º 83 6 Margin Ratio 99.999 º 89 5 Another Stock No º 94 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 104 8 Closing Price 9999.999 º 112 6 Margin Ratio 99.999 º 118 20 Filler (Blank) Record Length = 137 + Forth Detail Record type:- (Stock On Hand B/F) Start Length Content º 1 1 Record Type Indicator, set to be B º 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 16 Filler Record Length = 137 + Fifth Detail Record Type:- (Month-to-date Statement) Start Length Content 1 1 Record Type Indicator, set to be 5 2 8 Transaction Date, in yyyymmdd format 10 1 Transaction Type 11 8 Transaction Reference No 19 60 Particulars 79 12 Debit Amount 91 12 Credit Amount 103 14 Balance, -ve is credit 117 8 Settlement Date, in yyyymmdd format º 125 1 "Initiated by intermediary" indicator º 126 12 Filler Record Length = 137 + º Sixth Detail Record Type:- (Dividend/Bonus Entitlement, Optional Item) º (Include if client has option to show Div/Bonus Entitlement on Statement) º 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 41 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 = 137 + Seventh Detail Record Type:- (Cost of Portfolio, for web-Statement) Start Length Content º 1 1 Record Type Indicator, set to be F º 2 5 Stock No º 7 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 17 10 Deposit Qty (cannot determine Purchase Cost) º 27 13 Cost of Stock On Hand 9999999999.99 º 40 5 Another Stock No º 45 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 55 10 Deposit Qty (cannot determine Purchase Cost) º 65 13 Cost of Stock On Hand 9999999999.99 º 88 5 Another Stock No º 93 10 Qty On Hand 9999999999, -ve is Oversold º (undue qty is included) º 103 10 Deposit Qty (cannot determine Purchase Cost) º 113 13 Cost of Stock On Hand 9999999999.99 º 126 12 Filler (Blank) Record Length = 137 + Eighth Detail Record Type:- Start Length Content 1 1 Record Type Indicator, set to be 8 º 2 100 e-mail address º 102 8 Contract Renewal Date yyyymmdd º 110 7 Debit Interest Rate 99.9999 (%) º 117 7 Credit Interest Rate 99.9999 (%) º 124 7 Penalty Interest Rate 99.9999 (%) º 131 1 Interest Basis, Y=Yearly, D=Daily º 132 1 Client Type: C=Cash, M=Margin, P=Custodian º 133 5 Filler (Blank) Record Length = 137 + 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 14 Total Debit Balance 99999999999.99 28 14 Total Credit Balance 99999999999.99 42 14 Total Net Balance 99999999999.99, -ve is Credit 56 12 Total MTD Interest 999999999.99, -ve is Credit 68 14 Total Stock Market Value 99999999999.99 82 14 Total Stock Margin Value 99999999999.99 96 14 Total Margin Call 99999999999.99 110 14 Total Further Purchase Allowed 99999999999.99 124 14 Filler (Blank) Record Length = 137 + ÖÄSpecial Modification for Honfirst:- to include hash total of Stock No º and hash total of Qty on Hand º 124 8 Hash total of Stock No * º 132 16 Hash total of Qty on Hand * ÇÄRecord Length = 147 + º * Overflow digit will be truncated, º e.g. if Hash total of stock no is 123456789, then the leading digit '1' ÓÄÄÄÄÄÄÄÄwill be truncated and hash total will be 23456789. 2. STOCK GENERAL INFORMATION ============================ This file contains the stock no & stock code where may be held by client. File name will be SKyymmdd.TXT. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 10 Text File Name: STOCK CODE º 20 79 Filler Record Length = 98 + Detail Record:- Start Length Content º 1 1 Record Type Indicator, set to be T º 2 5 Stock No º 7 15 Stock Code º 22 45 Stock Full Name º 67 6 Lot Size º 73 6 Margin Ratio ³ 79 1 CCASS Stock Indicator: Y=CCASS Stock, N=No ³ 80 1 Require Contract Stamp: Y=Yes, N=No ³ 81 9 Stock Closing Price 9999.9999 º 90 1 Y=Trade Suspended º 91 8 Trade Suspended Begin Date Record Length = 98 + ÖÄSpecial for Henyep:- Export the following leading fields only º Detail Record:- º Start Length Content º 1 1 Record Type Indicator, set to be T º 2 5 Stock No º 7 15 Stock Code º 22 45 Stock Full Name º 67 6 Lot Size º 73 6 Margin Ratio ÓÄRecord Length = 78 + ÖÄSpecial Modification for ICBC:- to export GB & B5 Chinese Stock Code º 90 20 GB (Simplified) Chinese Stock Code º 110 20 Big 5 (Traditional) Chinese Stock Code º 130 1 Y=Trade Suspended º 131 8 Trade Suspended Begin Date ÓÄRecord Length = 138 + ÖÄSpecial Modification for Chief & Honfirst:- to include "Stock Type" º 90 1 Stock Type º 91 1 Y=Trade Suspended º 92 8 Trade Suspended Begin Date ÓÄRecord Length = 99 + Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records º 8 82 Filler Record Length = 89 + Note: For Henyep, the last 3 fields (CCASS Stock Indicator, Require Contract Stamp & Stock Closing Price) are not included. So the record length becomes 78 chars only. 3. STOCK ANNOUNCEMENT INFORMATION ================================= Additional text file SAyymmdd.TXT provides Dividend/Bonus Announcement Information. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 18 Text File Name: STOCK ANNOUNCEMENT 28 305 Filler Record Length = 332 + Detail Record:- Start Length Content 1 1 Record Type Indicator, set to be T 2 5 Stock No 7 15 Stock Code 22 8 Ex.Dividend Date (yyyymmdd) 30 8 Book Closed Date 38 8 Payable Date 46 8 Warrant Expiry Date 54 10 Dividend / Share 999.999999 64 40 Announcement or Dividend Particulars 104 5 Bonus Issue Base Value 109 4 Bonus Issue Unit Value 113 38 Bonus Issue Particulars 151 5 1st Warrant Issue Base Value 156 4 1st Warrant Issue Unit Value 160 5 2nd Warrant Issue Base Value 165 4 2nd Warrant Issue Unit Value 169 38 Warrant Issue Particulars 207 5 Rights Issue Base Value 212 4 Rights Issue Unit Value 216 38 Rights Issue Particulars 254 10 Rights Subscription Price 99999.9999 264 5 Split Issue Original Share Unit 269 5 Split Issue New Share Unit 274 20 Split Issue Particulars 294 5 Consolidate Issue Original Share Unit 299 5 Consolidate Issue New Share Unit 304 20 Consolidate Issue Particulars 324 9 CCASS Announcement No (in Book-Close Reminder Report) Record Length = 332 + Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records 8 325 Filler Record Length = 332 + 4. UNDUE TRADES =============== This file contains undue trades transactions. File name will be UDyymmdd.TXT. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 11 Text File Name: UNDUE TRADE º 21 60 Filler Record Length = 80 + Detail Record:- Start Length Content º 1 1 Record Type Indicator, set to be D 2 7 Client A/C No * 9 8 Transaction Date, in yyyymmdd format 17 8 Settlement Date, in yyyymmdd format 25 1 Transaction Type: B=Bought, S=Sold 26 8 Document No º 34 5 Stock No º 39 15 Stock Code º 54 9 Trade Qty 999999999 º 63 12 Trade Net Amount 999999999.99 º 75 6 Margin Ratio 99.999 Record Length = 80 + Special Modification for Prime:- to include the Execution Price & Qty in Undue Trade Text File. Record Length is extended to 148. 81 9 1st Trade Qty 999999999 90 8 1st Trade Price 9999.999 98 9 2nd Trade Qty 999999999 107 8 2nd Trade Price 9999.999 115 9 3rd Trade Qty 999999999 124 8 3rd Trade Price 9999.999 132 9 4th Trade Qty 999999999 141 8 4th Trade Price 9999.999 Record Length = 148 + Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records º 8 73 Filler Record Length = 80 + * 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 (Transaction Date to Margin Ratio) 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 6 2 8 Client A/C No 10 8 Transaction Date, in yyyymmdd format 18 8 Settlement Date, in yyyymmdd format 26 1 Transaction Type: B=Bought, S=Sold 27 8 Document No º 35 5 Stock No º 40 15 Stock Code º 55 9 Trade Qty 999999999 º 64 12 Trade Net Amount 999999999.99 º 76 6 Margin Ratio 99.999 Record Length = 81 + 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 + 6. Commission Rate Table ======================== This file will be generated if user has "Multi-Channel" module. File name will be CRyymmdd.TXT. This file may have 2 variations, 1 for Simple Commission Rate, 1 for Multiple Commission Rate. For Simple Commission Rate, the record length is 52. For Multiple Commission Rate, the record length is 115. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 21 Text File Name: COMMISSION RATE TABLE 31 85 Filler --- 115 chars Detail Record:- Start Length Content 1 1 Record Type Indicator, set to be R 2 2 Commission Code ** 4 1 Channel Code 5 6 General Commission Rate 9.9999 (%) 11 6 General Rebate Rate 9.9999 (%) 17 6 General Minimum Comm Amount 999.99 23 6 General Minimum Rebate Amount 999.99 29 6 Bonds Commission Rate 9.9999 (%) 35 6 Bonds Rebate Rate 9.9999 (%) 41 6 Bonds Minimum Comm Amount 999.99 47 6 Bonds Minimum Rebate Amount 999.99 * following fields applicable to Multiple Comm Rate 53 9 1st Privilege Rate applicable to Trade Value >= 999999999 62 6 1st Privilege Comm Rate 9.9999 (%) 68 6 1st Privilege Rebate Rate 9.9999 (%) 74 9 2nd Privilege Rate applicable to Trave Value >= 999999999 83 6 2nd Privilege Comm Rate 9.9999 (%) 89 6 2nd Privilege Rebate Rate 9.9999 (%) 95 9 3rd Privilege Rate applicable to Trave Value >= 999999999 104 6 3rd Privilege Comm Rate 9.9999 (%) 110 6 3rd Privilege Rebate Rate 9.9999 (%) --- 115 chars Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records 8 108 Filler --- 115 chars ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Layout of Daily Transaction Text File from External Trading System º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ Text File Layout for B/S Trade Text File, to be imported into SB system:- - Each line represent 1 B/S Trade, and end with chars. - 1st line will begin with '* 5 DIGITS STOCK NO', this line signal the remaining transaction text lines contain 5 digits stock no. Start Length Description ----- ------ ----------- 1 1 Transaction Type: B=Buy, S=Sell 2 10 Trade Reference, for front-end system reference only 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with trailing spaces) º 25 5 Stock No º 30 8 1st Trade Quantity (99999999) º 38 9 1st Trade Price (9999.9999, including decimal point) º 47 8 2nd Trade Quantity º 55 9 2nd Trade Price º 64 8 3rd Trade Quantity º 72 9 3rd Trade Price º 81 8 4th Trade Quantity º 89 9 4th Trade Price º 98 6 No. of T/D (for Sold Transaction only) º 104 9 Accrued Interest Amount (for Bonds/Loan Stock only) ºº 113 30 User-specific fields, refer to following ºº "Remaining data are user specific" section. ºº 143 1 Initiated by the Intermediate indicator, "!@#%&*" * remaining data are user specific º 113 9 Purchase Charge (999999.99) º (for Honfirst Only, including decimal point) * or specific for another user º 113 1 Channel Code (for ICBC, Henyep, Chief) * or applicable for "Short Sell" module º 113 1 Short Sell Code, "Y"=Short Sell º 114 1 Channel Code if "Short Sell" + "Multi-Channel" module * or specific for Celestial (Proposed) º 113 2 Comm Code, Blank => according to Client Master pre-set º value. "**" => Special Comm Rate º Following will be referred if Comm Code is '**' º 115 6 Special Comm Rate 9.9999 (%) º 121 6 Special Minimum Comm Amount 999.99 º 127 6 Special Rebate Rate 9.9999 (%) º 133 6 Special Minimum Rebate Amount 999.99 In case of following error, transaction will not be generated for a particaluar trade:- 1) Client A/C No does not exist in Client Master 2) Stock No does not exist in Stock Master 3) Transaction Type does not equal to "B" or "S" The "Trade Reference" will be shown on error report so that user is able to trace the error and input the trade manually into SB. Text File Layout for Stock D/W Transaction, to be imported into SB system:- - Each line represent 1 Stock D/W Trans, and end with chars. - 1st line will begin with '* 5 DIGITS STOCK NO', this line signal the remaining transaction text lines contain 5 digits stock no. Start Length Description ----- ------ ----------- 1 1 Transaction Type: D=Deposit, W=Withdrawal 2 10 Trans Reference, for front-end system reference only 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with trailing spaces) º 25 5 Stock No º 30 9 Transaction Quantity (999999999) º 39 1 Stock Allocation Code, may leave it blank, or º 1="Street Name" at Company Safe º 2="Nominee Name" at Company Safe º 3="Street Name" at CCASS º 4="Nominee Name" at CCASS º 5=at Registry º 6=at Bank Custody º 7=at other locations º 40 60 Description, may leave it blank º (Note: some users have 45 chars description, º Please check first) ³ * remaining data are user specific ³ * Celestial:- ³ 101 2 Statement Code ³ 102 1 WD Type (P,S,F) ³ 103 9 WD Handling Fee In case of following error, transaction will not be generated:- 1) Client A/C No does not exist in Client Master 2) Stock No does not exist in Stock Master 3) Transaction Type does not equal to "D" or "W" The "Trans Reference" will be shown on error report so that user is able to trace the error and input the transaction manually into SB. The Cash Payment/Receipt Transaction Text File layout will remain unchanged. ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Each line represent 1 Cash P/R Trans, and end with chars. ³ ³ ³ ³ Start Length Description ³ ³ ----- ------ ----------- ³ ³ 1 1 Transaction Type: P=Payment, R=Receipt ³ ³ 2 10 Trans Reference, for front-end system reference only ³ ³ 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with ³ ³ trailing spaces) ³ ³ 25 12 Transaction Amount (999999999.99) ³ ³ (including decimal point) ³ ³ 37 1 Settle Interest Flag, Y=Settle Interest ³ ³ 38 60 Description ³ ³ (Note: some users have 45 chars description, ³ ³ Please check first) ³ ³ * remaining data are user specific ³ ³ * Celestial:- ³ ³ 98 2 Bank Code ³ ³ 100 2 Statement Code ³ º 102 1 'Y' = SI Trans, (Mark Good Receipt) º º * For Multi-Bank module users:- º º 98 1 Bank Code º º 99 1 'Y' = SI Trans, (Mark Good Receipt) º º * For Other users:- º º 98 1 'Y' = SI Trans, (Mark Good Receipt) º ³ ³ ³ In case of following error, transaction will not be generated:- ³ ³ 1) Client A/C No does not exist in Client Master ³ ³ 2) Transaction Type does not equal to "P" or "R" ³ ³ The "Trans Reference" will be shown on error report so that user is ³ ³ able to trace the error and input the transaction manually into SB. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - Addition on 20 Oct 1999:- After the text file was generated, SB will compress the text file into a file called SBINTNET.ZIP if the batch file SBINTNET.BAT exists. The Zip file SBINTNET.ZIP will be encrypted with the user's Serial No. Here is an sample file of SBINTNET.BAT :- ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Rem Have to Delete any old SBINTNET.ZIP file first ³ ³ DEL SBINTNET.ZIP ³ ³ Rem %1 is the Serial No, %2 is the output text file ³ ³ Rem the output Zip file is SBINTNET.ZIP ³ ³ Rem any files can be compressed together and send to internet ³ ³ Rem ³ ³ Rem another way is to put the list of compressed file into a list, ³ ³ Rem as below ³ ³ Rem PKZIP -= -S%1 SBINTNET @SBINTNET.LST %2 %3 %4 ³ ³ Rem ³ ³ PKZIP -= -S%1 SBINTNET %2 %3 %4 CLMAST.DB? SMMAST.DBF ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Original Text File Layout, for 4 digits stock no º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ 1. "CLIENT POSITION ENQUIRY" ============================ File name will be SByymmdd.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 23 Text File Name: CLIENT POSITION ENQUIRY 33 80 Company Name 113 16 SB System Serial No 129 9 User Key Record Length = 137 + There will be 5 details record types. 1st Record Type contains Client Balance & Margin Call, and the 2nd Record Type contains Client Name & Runner Name, 3rd Record Type contains Client Portfolio, 4th Record Type contains Stock Holding B/F (as in Monthly Statement), 5th Record Type contains Statement (as in Monthly Statement). 8th Record Type contains e-mail address First Detail Record Type:- (Client Balance & Margin Call) Start Length Content 1 1 Record Type Indicator, set to be 1 2 7 Runner (A/E) Code * 9 7 Client A/C No * 16 9 Credit Limit 999999999 25 13 Daily Statement Bal B/F 9999999999.99, -ve is Credit 38 13 Balance C/F (Outstanding) 9999999999.99, -ve is Credit 51 13 Unsettled Balance 9999999999.99, -ve is Credit 64 13 Available Balance 9999999999.99, -ve is Credit 75 11 Month-to-Date Interest 99999999.99, -ve is Credit 88 13 Stock Market Value 9999999999.99, -ve is Oversold 101 13 Stock Margin Value 9999999999.99, -ve is Oversold 114 12 Margin Call (for Deposit) 999999999.99 126 12 Further Purchase Allowed 999999999.99 Record Length = 137 + Note: for Cash type client, the following fields will be zero:- "Month-to-Date Interest" "Stock Margin Value" "Margin Call (for Deposit)" "Further Purchase Allowed" * 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 (Credit Limit to Further Purchase Allowed) 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 Runner (A/E) Code * 10 8 Client A/C No * 18 9 Credit Limit 999999999 27 13 Daily Statement Bal B/F 9999999999.99, -ve is Credit 40 13 Balance C/F (Outstanding) 9999999999.99, -ve is Credit 53 13 Unsettled Balance 9999999999.99, -ve is Credit 66 13 Available Balance 9999999999.99, -ve is Credit 77 11 Month-to-Date Interest 99999999.99, -ve is Credit 90 13 Stock Market Value 9999999999.99, -ve is Oversold 103 13 Stock Margin Value 9999999999.99, -ve is Oversold 116 12 Margin Call (for Deposit) 999999999.99 128 12 Further Purchase Allowed 999999999.99 Record Length = 139 + Second Detail Record Type:- (Client Name, Runner Name, PIN) Start Length Content 1 1 Record Type Indicator, set to be 2 2 30 1st line of Client Name 32 30 2nd line of Client Name 62 30 Runner Name 92 11 PIN No. 103 8 PIN No Last Effective Date [added on 20 Oct 1999] 111 29 Filler Third Detail Record Type:- (Stock On Hand) Start Length Content 1 1 Record Type Indicator, set to be 3, (will be superceded) 2 4 Stock No 6 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 16 8 Closing Price 9999.999 24 6 Margin Ratio 99.999 30 4 Another Stock No 34 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 44 8 Closing Price 9999.999 52 6 Margin Ratio 99.999 58 4 Another Stock No 62 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 72 8 Closing Price 9999.999 80 6 Margin Ratio 99.999 86 4 Another Stock No 90 10 Qty On Hand 9999999999, -ve is Oversold (undue qty is included) 100 8 Closing Price 9999.999 108 6 Margin Ratio 99.999 114 24 Filler (Blank) Record Length = 137 + Forth Detail Record type:- (Stock On Hand B/F) Start Length Content 1 1 Record Type Indicator, set to be 4, (will be superceded) 2 4 Stock Holding B/F:- 1st Stock No 6 10 1st Stock Qty B/F, -ve is Oversold 16 4 2nd Stock No 20 10 2nd Stock Qty B/F 30 4 3rd Stock No 34 10 3rd Stock Qty B/F 44 4 4th Stock No 48 10 4th Stock Qty B/F 58 4 5th Stock No 62 10 5th Stock Qty B/F 72 4 6th Stock No 76 10 6th Stock Qty B/F 86 4 7th Stock No 90 10 7th Stock Qty B/F 100 4 8th Stock No 104 10 8th Stock Qty B/F 114 24 Filler Record Length = 137 + Fifth Detail Record Type:- (Month-to-date Statement) Start Length Content 1 1 Record Type Indicator, set to be 5 2 8 Transaction Date, in yyyymmdd format 10 1 Transaction Type 11 8 Transaction Reference No 19 60 Particulars 79 12 Debit Amount 91 12 Credit Amount 103 14 Balance, -ve is credit 117 8 Settlement Date, in yyyymmdd format 125 13 Filler Record Length = 137 + Eighth Detail Record Type:- Start Length Content 1 1 Record Type Indicator, set to be 8 2 50 e-mail address 52 86 Filler Record Length = 137 + ÖÄSpecial Modification for Phillip:- accept multiple e-mail address º 2 100 e-mail address º 102 36 Filler ÓÄRecord Length = 137 + 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 14 Total Debit Balance 99999999999.99 28 14 Total Credit Balance 99999999999.99 42 14 Total Net Balance 99999999999.99, -ve is Credit 56 12 Total MTD Interest 999999999.99, -ve is Credit 68 14 Total Stock Market Value 99999999999.99 82 14 Total Stock Margin Value 99999999999.99 96 14 Total Margin Call 99999999999.99 110 14 Total Further Purchase Allowed 99999999999.99 124 14 Filler (Blank) Record Length = 137 + 2. STOCK GENERAL INFORMATION ============================ This file contains the stock no & stock code where may be held by client. File name will be SKyymmdd.TXT. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 10 Text File Name: STOCK CODE º 20 78 Filler Record Length = 97 + Detail Record:- Start Length Content 1 1 Record Type Indicator, set to be S, (will be superceded) 2 4 Stock No 6 15 Stock Code 21 45 Stock Full Name 66 6 Lot Size 72 6 Margin Ratio ³ 78 1 CCASS Stock Indicator: Y=CCASS Stock, N=No ³ 79 1 Require Contract Stamp: Y=Yes, N=No ³ 80 9 Stock Closing Price 9999.9999 º 89 1 Y=Trade Suspended º 90 8 Trade Suspended Begin Date Record Length = 97 + Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records º 8 90 Filler Record Length = 97 + Note: For Henyep, the last 3 fields (CCASS Stock Indicator, Require Contract Stamp & Stock Closing Price) are not included. So the record length becomes 77 chars only. 3. UNDUE TRADES =============== This file contains undue trades transactions. File name will be UDyymmdd.TXT. Control Record:- Start Length Content 1 1 Record Type Indicator, set to be 0 2 8 Transaction Date YYYYMMDD 10 11 Text File Name: UNDUE TRADE 21 59 Filler Record Length = 79 + Detail Record:- Start Length Content 1 1 Record Type Indicator, set to be 6 2 7 Client A/C No * 9 8 Transaction Date, in yyyymmdd format 17 8 Settlement Date, in yyyymmdd format 25 1 Transaction Type: B=Bought, S=Sold 26 8 Document No 34 4 Stock No 38 15 Stock Code 53 9 Trade Qty 999999999 62 12 Trade Net Amount 999999999.99 74 6 Margin Ratio 99.999 Record Length = 79 + Ending Record:- Start Length Content 1 1 Record Type Indicator, set to be 9 2 6 No. of Records 8 72 Filler Record Length = 79 + * 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 (Transaction Date to Margin Ratio) 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 6 2 8 Client A/C No 10 8 Transaction Date, in yyyymmdd format 18 8 Settlement Date, in yyyymmdd format 26 1 Transaction Type: B=Bought, S=Sold 27 8 Document No 35 4 Stock No 39 15 Stock Code 54 9 Trade Qty 999999999 63 12 Trade Net Amount 999999999.99 75 6 Margin Ratio 99.999 Record Length = 80 + Import Daily transactions from external system:- Text File Layout for B/S Trade Text File, to be imported into SB system:- ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Each line represent 1 B/S Trade, and end with chars. ³ ³ ³ ³ Start Length Description ³ ³ ----- ------ ----------- ³ ³ 1 1 Transaction Type: B=Buy, S=Sell ³ ³ 2 10 Trade Reference, for front-end system reference only ³ ³ 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with ³ ³ trailing spaces) ³ ³ 25 4 Stock No ³ ³ 29 8 1st Trade Quantity (99999999) ³ ³ 37 9 1st Trade Price (9999.9999, including decimal point) ³ ³ 46 8 2nd Trade Quantity ³ ³ 54 9 2nd Trade Price ³ ³ 63 8 3rd Trade Quantity ³ ³ 71 9 3rd Trade Price ³ ³ 80 8 4th Trade Quantity ³ ³ 88 9 4th Trade Price ³ ³ 97 6 No. of T/D (for Sold Transaction only) ³ ³ 103 9 Accrued Interest Amount (for Bonds/Loan Stock only) ³ ³ * remaining data are user specific ³ ³ 112 9 Purchase Charge (999999.99) ³ ³ (for Honfirst Only, including decimal point) ³ ³ * or applicable for "Short Sell" module ³ ³ 112 1 Short Sell Code, "Y"=Short Sell ³ ³ ³ ³ In case of following error, transaction will not be generated for a ³ ³ particaluar trade:- ³ ³ 1) Client A/C No does not exist in Client Master ³ ³ 2) Stock No does not exist in Stock Master ³ ³ 3) Transaction Type does not equal to "B" or "S" ³ ³ The "Trade Reference" will be shown on error report so that user is ³ ³ able to trace the error and input the trade manually into SB. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ Text File Layout for Stock D/W Transaction, to be imported into SB system:- ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Each line represent 1 Stock D/W Trans, and end with chars. ³ ³ ³ ³ Start Length Description ³ ³ ----- ------ ----------- ³ ³ 1 1 Transaction Type: D=Deposit, W=Withdrawal ³ ³ 2 10 Trans Reference, for front-end system reference only ³ ³ 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with ³ ³ trailing spaces) ³ ³ 25 4 Stock No ³ ³ 29 9 Transaction Quantity (999999999) ³ ³ 38 1 Stock Allocation Code, may leave it blank, or ³ ³ 1="Street Name" at Company Safe ³ ³ 2="Nominee Name" at Company Safe ³ ³ 3="Street Name" at CCASS ³ ³ 4="Nominee Name" at CCASS ³ ³ 5=at Registry ³ ³ 6=at Bank Custody ³ ³ 7=at other locations ³ ³ 39 60 Description, may leave it blank ³ ³ (Note: some users have 45 chars description, ³ ³ Please check first) ³ ³ ³ ³ In case of following error, transaction will not be generated:- ³ ³ 1) Client A/C No does not exist in Client Master ³ ³ 2) Stock No does not exist in Stock Master ³ ³ 3) Transaction Type does not equal to "D" or "W" ³ ³ The "Trans Reference" will be shown on error report so that user is ³ ³ able to trace the error and input the transaction manually into SB. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Each line represent 1 Cash P/R Trans, and end with chars. ³ ³ ³ ³ Start Length Description ³ ³ ----- ------ ----------- ³ ³ 1 1 Transaction Type: P=Payment, R=Receipt ³ ³ 2 10 Trans Reference, for front-end system reference only ³ ³ 12 13 Client A/C No (Most users use 7 bytes A/C No, pad with ³ ³ trailing spaces) ³ ³ 25 12 Transaction Amount (999999999.99) ³ ³ (including decimal point) ³ ³ 37 1 Settle Interest Flag, Y=Settle Interest ³ ³ 38 60 Description ³ ³ (Note: some users have 45 chars description, ³ ³ Please check first) ³ ³ * remaining data are user specific ³ ³ * Celestial:- ³ ³ 98 2 Bank Code ³ ³ 100 2 Statement Code ³ ³ ³ ³ In case of following error, transaction will not be generated:- ³ ³ 1) Client A/C No does not exist in Client Master ³ ³ 2) Transaction Type does not equal to "P" or "R" ³ ³ The "Trans Reference" will be shown on error report so that user is ³ ³ able to trace the error and input the transaction manually into SB. ³ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - On 18 July 2002, draft layout of .DBF files to be generated together with the above text files:- Note: for this option, the exporting .DBF files must to be kept in separate directory other than SB. This separate directory can be defined in '(181) System Re-Config" 4th screen. "Directory of Export Files for Front-End:" If the directory name is blank, SB will change it to '..\WEBIO\'. 1. CLyymmdd.DBF:- Client General Information LACCT C 13 Client A/C No LRNER C 13 Runner Code LLMT N 9,0 Trading/Credit Limit LDBALBF N 13,2 Daily Statement Balance B/F LBALCF N 13,2 Balance C/F (Outstanding) LUNSTL N 13,2 Unsettled Balance LAVBAL N 13,2 Available Balance LMTDINT N 11,2 Month-to-Date Interest LMKTVAL N 13,2 Stock Market Value LMGNVAL N 13,2 Stock Margin Value LMGNCALL N 12,2 Margin Call (for deposit) LFPURALL N 12,2 Further Purchase Allowed LNAME C 30 Client Name (1st line) LNAME2 C 30 Client Name (2nd line) LRNNAME C 30 Runner Name (1st line) LRNNAME2 C 30 Runner Name (2nd line) LPIN C 11 PIN No LPINDATE D 8 PIN No. Last Effective Date LEMAIL C 100 e-mail address LRNEWDATE D 8 Margin Contract Renewal Date LDBRATE N 7,4 Debit Interest Rate % LCRRATE N 7,4 Credit Interest Rate % LPDBRATE N 7,4 Penalty Interest Rate % (applicable for some users only) LINTTYPE C 1 Interest Type: Y=Yearly, D=Daily LTYPE C 1 Client Type: C=Cash, M=Margin, P=Custodian LADDR1 C 40 Client Address 1 LADDR2 C 40 Client Address 2 LADDR3 C 40 Client Address 3 LADDR4 C 40 Client Address 4 2. PFyymmdd.DBF:- Stock On Hand FACCT C 13 Client A/C No FSTKNO C 5 Stock No FQTYOH N 10,0 Qty on Hand (undue qty is included) FMGN N 6,3 Margin Ratio ** Following Fields are Cost of Portfolio, for new web-Statement FDPQTY N 10,0 Deposit Qty (cannot determine Purchase Cost) FCOST N 13,2 Cost of Stock on Hand 3. MByymmdd.DBF:- Stock on B/F for Monthly Statement FACCT C 13 Client A/C No FSTKNO C 5 Stock No FQTYBF N 10,0 Qty B/F for Monthly Statement 4. DByymmdd.DBF:- Stock on B/F for Daily Combined Statement FACCT C 13 Client A/C No FSTKNO C 5 Stock No FQTYBF N 10,0 Qty B/F for Current Date 5. PEyymmdd.DBF:- Dividend/Bonus Entitlement, include if client has option to choose to show Div/Bonus Entitlement on Statement:- FACCT C 13 Client A/C No FSTKNO C 5 Stock No FISSUE C 1 Issue Type: D=Div, B=Bonus, W=Warrant, R=Rights, S=Split, C=Consolidate, X=Expired Warrant FBCQTY N 10,0 Book Closed Qty (Note: Particulars of each Issue Type are stored in SKyymmdd.DBF) 6. SKyymmdd.DBF:- Stock General Information MSTKNO C 5 Stock No MSTK C 15 Stock Code MNAME C 45 Stock Full Name MLOT N 6 Board Lot (Lot Size) MMGN N 6,3 Stock Margin Ratio MCCSTOCK C 1 CCASS Stock Indicator: Y=CCASS Stock, N=No MSTAMP C 1 Require Contract Stamp: Y=Yes, N=No MPRICE N 8,3 Closing Price MSTOP C 1 Y=Trade Suspended MSTPDATE D 8 Trade Suspended Begin Date MTYPE C 1 Stock Type MEXDATE D 8 Ex.Dividend Date MBCDATE D 8 Book Closed Date MPYDATE D 8 Payable Date MXPDATE D 8 Warrant Expiry Date MDPS N 10,6 Dividend / Share MDREMARK C 40 Announcement or Dividend Particulars MDTSPRICE N 10,6 Convert Dividend to Bonus Unit Price MBBASE N 5,0 Bonus Issue Base Value MBUNIT N 5,0 Bonus Issue Unit Value MBREMARK C 38 Bonus Issue Particulars MWUNIT N 5 1st Warrant Issue Unit Value MWBASE N 5 1st Warrant Issue Base Value MWUNIT2 N 5 2nd Warrant Issue Unit Value MWBASE2 N 5 2nd Warrant Issue Base Value MWREMARK C 38 Warrant Issue Particulars MRUNIT N 5 Rights Issue Unit Value MRBASE N 5 Rights Issue Base Value MRREMARK C 38 Rights Issue Particulars MRTSPRICE N 9,4 Rights Subscription Price MSOLD N 5 Split Issue Old Share Qty MSNEW N 5 Split Issue New Share Qty MSREMARK C 20 Split Issue Particulars MCOLD N 5 Consolidate Issue Old Share Qty MCNEW N 5 Consolidate Issue New Share Qty MCREMARK C 20 Consolidate Issue Particulars MANCMREF C 9 CCASS Announcement No (in Book-Close Reminder Report) 7. STyymmdd.DBF:- TACCT C 13 Client A/C No TDATE D 8 Transaction Date TTYPE C 1 Transaction Type TREF C 8 Reference No TDESC C 60 Particulars TDRAMT N 12,2 Debit Amount TCRAMT N 12,2 Credit Amount TBALAMT N 14,2 Balance (-ve is Credit) TSDATE D 8 Settlement Date TDESC2 C 60 2nd line of Particulars (for some users) 8. UDyymmdd.DBF:- Undue Trades Transactions UACCT C 13 Client A/C No UDATE D 8 Transaction Date USDATE D 8 Settlement Date UTYPE C 1 Transaction Type: B=Bought, S=Sold UREF C 8 Document No USTKNO C 5 Stock No UQTY N 9 Trade Qty UAMT N 12,2 Trade Net Amount UMGN N 6,3 Margin Ratio 9. DCyymmdd.TXT:- Daily Combined Statement CACCT C 13 Client A/C No CDATE D 8 Transaction Date CTYPE C 1 Transaction Type CREF C 8 Reference No CDESC C 60 Particulars CDESC2 C 60 2nd line of Statement Description (for some users only) CDRAMT N 12,2 Debit Amount CCRAMT N 12,2 Credit Amount CBALAMT N 14,2 Balance (-ve is Credit) CSDATE D 8 Settlement Date CCCSTOCK C 1 Y=CCASS Stock CDBTYPE C 1 Dividend/Bonus Indicator: D,B,W,R,S CCORTYPE C 1 Y=Correct Trade CCORDATE D 8 Correct Trade - Original Trade Date CSTKNO C 5 Stock No (B/S, D/W, or Div/Bonus Transaction) CSTK C 15 Stock Code CQTY1 N 9,0 D/W Qty, B/S 1st Qty CPRICE1 N 8,3 B/S 1st Price CQTY2 N 9,0 B/S 2nd Qty CPRICE2 N 8,3 B/S 2nd Price CQTY3 N 9,0 B/S 3rd Qty CPRICE3 N 8,3 B/S 3rd Price CQTY4 N 9,0 B/S 4th Qty CPRICE4 N 8,3 B/S 4th Price CCOMM N 10,2 Commission Amount CSTAMP N 10,2 Stamp Amount CLEVY N 10,2 Transaction Levy Amount CSLEVY N 10,2 Trading Fee Amount CCCASS N 10,2 CCASS Fee CINTACR N 10,2 Interest Accrued CTD N 10,2 T/D Fee CCHARGE N 10,2 Other Charges (for some users) ** Following Fields are for Dividend Details:- CBCQTY N 9,0 Book Closed Qty CDPS N 10,6 Dividend / Share CDTS C 1 Y=Convert Dividend to Bonus CDTSQTY N 11,0 Div to Bonus Qty CDIV N 12,2 Dividend Amount CDIVCOL N 10,2 Dividend Collection Fee CDIVTD N 10,2 Dividend Scrip Fee CDIVHDL N 10,2 Dividend Handling Fee CNDIV N 12,2 Net Dividend Amount CDIVBK C 8 Dividend Cheque Bank Code CDIVCHQ C 6 Dividend Cheque No