24. Can SB read CAMS data and how ? 如何將CAMS資料讀入SB
    To make Trading Transaction in "CAMS" to be imported into "SB"

24.1. Add a memory variable CAMS_USER=.T. in SB.MSG
24.2. From CAMS, generate a data file CAMSTRAN.DBF and place it in the
      SB directory. The file layout of CAMSTRAN.DBF is

Field      FieldName     Type          Width      Dec            Remark

  1          CSEQ         Numeric         4                   Sequence No/Ticket No
  2          CTYPE        Character      1                   B=Bought, S=Sold
  3          CACCT        Character      7                   Client A/C No
  4          CSTKNO       Character      4                   Stock No
  5          CSTK         Character     15                   Stock Code
  6          CPRICE       Numeric       10           4        Trade U. Price
  7          CQTY         Numeric         8                   Trade Qty
  8          CTIME        Character      5                   Confirm Time
  9          CTDNO        Numeric        4                   No of T/D(for sold trade)

24.3 On the SB system, "Main Menu"
     ---> 3. Daily Transaction Entry
     3.1 Client Transaction Entry
     3.1.I Imprt Trading Transaction from 'CAMS' System

During importing, error message will be printed out (if any),
therefore, please turn on the printer.

24.4 SB will try to consolidate trades into same "Client Transaction"
     according to:-
     - Same Client
     - Same transaction type
     - Same Stock

But any previously "Matched" transactions will remain unchanged.If trades are consolidated, client transaction record will keep the "sequence no" of the FIRST trade in CAMSTRAN file.

On a record in CAMSTRAN file is prcessed, it will be marked as "DELETED". Any deleted records in CAMSTRAN file will not be imprted again.

WARNING: The SB cannot detected a CAMSTRAN record is imported or not.
         If the user re-send the CAMSTRAN file to SB and perform the
         "IMPORT" option again, then client transactions will be doubled !

24.6 The following data will be extracted from related data files during the import
     procedure:-

CLIENT NAME
RUNNER CODE
COMMISSION RATE
REBATE RATE
MINIMUM COMM AMOUNT
MINIMUM REBATE AMOUNT
NET COMM AMOUNT
STOCK NAME
LOT SIZE(BOARD LT)
REURIE STAMP FLAG
CCASS STOCK FLAG
CLIENT LOCATION CODE (FOR MULTI-BRANCH USERS)
MULTIPLE COMMISSION RATE & REBATE RATE (FOR MULTI-RATE USERS)

All related sur-charges will be calculated at the same time.

24.7 The SB will not perform "ON-LINE" update to the "Client Master" & "Ptfolio
     Master". If user want to obtain a latest client position,he has to perform
     "re-update" procdeure.

24.8 Possible error messages:-
     - ERROR: Stock No not found in "STOCK MASTER" This trade will be ignored!,
              This trade will be ignored (skipped)
              User has to input this trade manually.
     - ERROR: Client A/C No Not found in "Client Master", This trade will be
              ignored ! This trade will be ignored (skipped)
              User has to input his trade manually
     - ERROR: Client Commission Code not found in "Commission Rate Table"
              This trade will be ignored 1
              This indicated that the "Comm Code" of the client record does
              not corresponding to a record in " Comm Rate Table".
              This trade will be ignored (skipped)
              User has to input this trade manually.

24.9 Possible warning message:-
     - WARNING: Stock Code does not match with "Stock Master"!
                It will be changed to XXXXX

                It indicated taht the Stock Code of "CAMS" and that of "sb"
                are not matched. In this case, SB will use the "STOCK CODE"
                of "STOCK MASTER"
                If user finds out that the "STOCK CODE" of "STOCK MASTER"
                is not correct, he has to change it in 'STOCK MASTER ENTRY"

Copyright © 1998, POP ELECTRONIC PRODUCTS LTD. All rights reserved.