Home

STARCOIN C&A System User Manual Volume - II of II

1. KM_GEN_PCT DOWF KM_PCTICC KM_PCTTK S KM_PERS_HASH KM_PERS_MAC KM_PERS_ENC FINAL CONFIDENTIAL KM_TRANS_SV ra KD_SETT_HASH KM_SC_UPDATE KM_BANK_HASH KM_BANK_RESMAC KM_BANK_DATA KD_SETT_DATA o key_der TREE_SYS flo KM_TRANS_ICC KM_TRANS_TK SOWF DOWF KD_PCTICC_ENC KD_PCTICC_HASH KD_SC_UPDATE KD_PCTTK_ENC KD TRANS SCPER KD TRANS SETT KD PCTTK HASH KD TRANS ICC KD TRANS BKPER KD TRANS BKUPD KD BANK HASH KD BANK DATA KD SC AUTH TERM KD SC AUTH BANK ee Figure 6 2 Key relations for KGG SYSTEM Page 100 of 109 KD TRANS TK TDESENC KS TRANS SCPER KS TRANS SETT KS TRANS BKPER KS TRANS BKUPD KS TRANS TK STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 6 4 2 KGG CARDS KGG CARDS DOWF Y Y KM GEN PINRST KG IEPL ON KG IEPL OFF KM GEN ATM ON KM GEN P
2. The report can sent to personal mail account e Close Closes the previewer screen e New Creates another copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 41 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 8 Out Of Order Terminals Access Path Queries Reports Out of order terminals Information about out of order terminals for merchants banks or all 4 8 1 Retrieve information On selection of the option in the main menu the Query form List of Out Of Order Terminals appears on the screen with cursor on the Bank Terminal of the Option radio button Select Bank Terminal or Merchant Terminal or from the Option Press Execute button for a particular Option chosen to get Terminal Information records for the selected Terminal Type Total No of Bank Terminals and Total No of Merchant Terminals are shown as Summary Information Note A message is shown in status bar if no data is fetched for any of the Option chosen Terminal Category is PURCHASE or BANK terminal 4 8 2 Terminal information part Operator Id Unique identifier for a merchant Terminal Id Terminal serial number for that merchant Cluster Id Group identifier for the specific terminal Location Place of terminal installation Model Type Identifier for the type of terminal Service
3. Do you want to save the changes Not Applicable you have made All Information will be lost Not Applicable Continue This process will archive Do you Not Applicable want to continue This process will purge Do you Not Applicable want to continue Card s will be automatically Not Applicable Do you want to abandon the Not Applicable session Do you really want to replace the Not Applicable card Full path name not given Will you Not Applicable use current directory Do you really want to purge records Not Applicable Not Applicable Not Applicable WRN 90055 Do you really want to purge records Not Applicable without archiving STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 339 WRN90055 Do you really want to delete user Not Applicable WRN90101 Do you really want to replace the Not Applicable card 341 WRN90102 Accounting will get effected Do Not Applicable you want to continue Table 6 48 List of Error Information Warning messages STARCOIN C amp A System User Manual 25 05 99 Vol Page 99 of 109 Version 2 0 1 Revision 15 04 99 6 4 6 4 1 6 Appendices KM GEN SETTSEC Appendix H Key relations KGG SYSTEM KGG SYSTEM DOWF KM GEN PERSEC KM SETT HASH KM SETT DATA Sf KM_GEN_BKUPD
4. Export Settlement Advice AII settlement advice which have been not been exported to a flat file can be exported Hence only those merchants who have transactions for which settlement advice has been raised but not yet exported will be shown 5 3 1 Retrieve Existing Merchant record e Select either the Single Merchant or All Merchants option For All Merchants e No merchant data is shown For Single Merchant e Either Enter valid Merchant Id and Transfer Date Press e Or Press the Search button Searchable fields are in Yellow legend Wildcarding may be used in the field List of Merchants for whom Settlement Advice has been raised but not yet exported will be displayed Press Ok in the List of Values for selecting a particular Merchant e Following Merchant Information will be displayed on the screen Merchant Id Transfer Date Merchant Name e The Search button is disabled The Export button is enabled e At this point pressing Clear button will clear the form without exporting the data to a flat file At this point pressing Close button will close the form without exporting the data to a flat file STARCOIN C amp A System User Manual 25 05 99 Vol Page 47 of 109 Version 2 0 1 Revision 15 04 99 5 Utilities FINAL CONFIDENTIAL 5 32 Export Settlement Advice e Press Export button The settlement advice raised is exported to
5. Table Name SYSADM USERS Description This table keeps all the users information Primary Key USER ID Foreign Key USER ROLEID SYSADM ROLES ROLE ID Name ees SER_NAME Name of the User SER_ROLEID Role assigned to the user Table 6 35 Structure of table SYSADM_ROLES cia SYSCARDPAR Description This table is used to keep information on system parameters set up during installation time Primary Key N A Foreign Key SYSCARDPAR AUTHLIMIT NOT NULL NUMBER 10 On line Off line authorisation limit above this limit an on line load authorisation of the issuing bank is required Must be check at any load request SYSCARDPAR BALMAXECH NOT NULL NUMBER 10 Maximum holding amount for the ECH SYSCARDPAR_BALMAXIEP NOT NULL NUMBER 10 Maximum holding amount for the IEP SYSCARDPAR_CARDNRSTART NOT NULL NUMBER 13 System provider defined part of the Start value for the unique Number identifying for each Customer Card Resulting start value for system counter CustCard_CardNr is then 0000 amp PID 3 amp N 13 PID comes through G amp D init table SYSCARDPAR_CURRIEP NUMBER 4 Currency used in the STARCOIN system 1 nibble minor unit 2 4 nibble Currency code Base currency of the STARCOIN system nat curr SYSCARDPAR_DEXPIEP SYSCARDPAR ISOS305INIT DATE Date on which the IEP or ECH expires Unload and purchase denied NUMBER 2 The flag determining whethe
6. corti tui 40 4 7 SAEP Pool Lr nsaction parts CRI Nd A 40 4 44 ECH Transaction part d a ade eoa ede Be id bg he Pie e diese p REB 40 4 75 Navigatiori ui e tee ge Saee eda dt et de ede des 41 4 8 DUT OF ORDER TERMINWAES C V deanna RU TU PLE EROR TREE DEDERE 42 ASA R etrieve danformatiori osi e t E Ded ae ete et dept p e dette epe S 42 2 6 2 Terminal information part e n sa i e re e E HERE I ERE DRY Heer aab cube ee ru levees eve eoe b aue b ee eet 42 4 6 3 Summary information seh Ie ertet rien Ere SURE HEN EE Ree Pee Te Oe 42 4 SA Navigation rr OPER DUREE Er DE ees 43 4 0 EOCATIONWISE LIST OB TERMINALS 2 mire Shiga see re e iex ER 44 4 0 T Retrievethe Y cOrd i sa reo de neat 44 4 9 2 Terminal informati n part ede eR EE 44 4 9 3 Summary information Dart dt ert i eee ter ote e E RR P RIEF RUE 45 2 9 4 Navigation ined tte te RI endet eene te enm eniti 45 S UTILITIES T 46 5x1 INTRODUCTION oe epe E ED PEREAT RUE D RE ER EP ERI 46 SU PLOT QUIS ULES a sss e WERT Gee tee WAR UR D USE REIR Me ees 46 5 2 GENERATE EXPORT FILE OF DEBIT ADVICE
7. csscssssscosscessoverssessssvonsseenssvensesensevensesnssevonsessusesnsessssesonoesssseesssessnssoonsersssconeesss 46 5 21 Retrieve Existing Customer record 2 eue deer edet ded dise ee ERE e Eee de dee 46 3 2 2 Export Debit Advice ie ber ro ERO RP OSAKO P UP ERE FERRO 47 5 3 GENERATE EXPORT FILE OF SETTLEMENT ADVICE nennen ees eiiie iinei 47 5 34 Retrieve Existing Merchant record corrr eet e ea eet e n uota PU Eee eS Eo eines 47 5 3 2 Export Settlement Advice uses ete pte aee beue esie tog e pte e Eee EYE 48 6 APPENDICES rr 49 6 1 APPENDIX A ENTITY RELATIONSHIP DIAGRAM 20001 010 enne entente intense 49 6 2 APPENDIX B TABLE STRUCTURE OF C amp A SYSTEM 4420 0 00 netten en 51 6 3 APPENDIX LIST OF ERROR MESSAGES ssssssescosrsesvcseersssnocseensssvecconsesssssoonseesssconsnsesnscsesseusnsevonsessaseonsesusssosnssensevenseseasens 83 6 4 APPENDIX H KEY ee ER rete Ee sesh E cbe v ee REIR ERE euo RUM SERERE SERE sven 100 6 4 1 KGG SYSTEM 4 iiec HIE S USER ee WERE A e rs HY eo Pee Reve E de ee d 100 6 4 2 K GG CARDS ro eder d tore bitu b it
8. ECHSTL_DATETIME NOT NULL NUMBER 13 UL OT OT OT OT OT OT ECHSTL_ECHACCNO NUMBER 20 ECHSTL_ECHSRCBIN NUMBER 15 ECHSTL_EXPFLAG NUMBER 1 ECHSTL_MRCACCNO NUMBER 20 ECHSTL_MRCBIN MBER 15 L L L L L L NULL NULL NULL NULL NULL NULL N N N N N N N U U U U U U ECHSTL_MRCID UMBER 20 ECHSTL_MRCNAME VARCHAR2 30 ECHSTL_NC NULL UMBER 5 I U 19 U U U U U ECHSTL NO NOT NULL MBER ECHSTL PURTRANSNO NOT NULL MBER ECHSTL SVCACCNO NULL NUMBER 20 ECHSTL SVCBIN NULL NUMBER 15 ECHSTL_SVCCHARGE NULL NUMBER 10 N ECHSTL_TERMID NOT NULL MBER 5 ECHSTL TERMOPID NOT NULL NUMBER 10 Table 6 14 Structure of table ECH_STLADVICE N N N ECHSTL NULL NUMBER 5 N N STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 FINAL CONFIDENTIAL ECHSTL PURTRANSNO PUR TRANSACTION PURTRANS NO Purchase amount that has been transacted with the Merchant for this advice ECH settlement archived confirmation Default N after archivation changed to Y Bank specific customer Id if not available source acc no must be set Settlement advice generation Date and Time Source account from where the money is to be Debited Bank ECH Account number of the customer Bank if not available BankCustId must be set BIN of the card holders bank Flag to Indicate whether this advice has been exported or not Default 0 Account numb
9. STRUCTURE OF TABLE KEY VERSION STRUCTURE OF TABLE MERCHANT STRUCTURE OF TABLE MRC ACCBAL STRUCTURE OF TABLE MRC POOL STRUCTURE OF TABLE PENDING NC STRUCTURE OF TABLE TRANSACTION STRUCTURE OF TABLE REDLIST CARDS STRUCTURE OF TABLE SYSADM CODES STRUCTURE OF TABLE SYSADM ERRORS STRUCTURE OF TABLE SYSADM ITEMS STRUCTURE OF TABLE SYSADM ROLES STRUCTURE OF TABLE SYSADM ROLE ITEMS STRUCTURE OF TABLE SYSADM ROLES STRUCTURE OF TABLE SYSCARDPAR STRUCTURE OF TABLE SYSISOPARATM STRUCTURE OF TABLE SYSISOPARPOS STRUCTURE OF TABLE SYSPAR STRUCTURE OF TABLE SYSREDLIST STRUCTURE OF TABLE SYSSVC STRUCTURE OF TABLE SYSTKPAR STRUCTURE OF TABLE SYSTKUPD STRUCTURE OF TABLE TERMINAL STRUCTURE OF TABLE TERM MANF STRUCTURE OF TABLE TRANSFER FILES STRUCTURE OF TABLE TERM CARD LIST OF ERROR INFORMATION WARNING MESSAGES Page 104 of 109 FINAL CONFIDENTIAL STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices TABLE 6 49 LIST OF ABBREVIATIONS 6 7 Appendix J List of Figures FIGURE 1 1 STATE TRANSITION FOR TERMINAL CARD STATUS FIGURE 3 1 SETTLEMENT PROCESS FIGURE 6 1 ENTITY RELATIONSHIP DIAGRAM FIGURE 6 2 KEY RELATIONS FOR SYSTEM FIGURE 6 3 KEY RELATIONS FOR CARDS FIGURE 6 4 KEY RELATIONS FOR KGG EXPIRY STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 FINAL CONFIDENTIAL 103 15 22 50 100 101 102 Vol Page 105 of 109
10. TRMCARD KEYVERSION TRMCARD LISTSTATUS TRMCARD NEWPSAM TRMCARD NTTK TRMCARD PPPSAM TRMCARD PSAM TRMCARD RSAANFPROB TRMCARD SERVICE TRMCARD SHOWBALANCE TRMCARD SIGNCHECKTK TRMCARD SINGLETXLIMIT TRMCARD SINGLETXPROB TRMCARD STATUS TRMCARD STATUSDATE TRMCARD STATUSREASON TRMCARD TERMID TRMCARD TERMOPID TRMCARD_UPDATETKNO TRMCARD_UPDTKCONFDATE TRMCARD_UPDTKNCCONF Page 82 of 109 2 E 2 pA NOT NULL NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL NULL NOT NULL NOT NULL NULL NULL OT NU OT NUL NOT NU NOT NU Z NOT NU NULL NOT NU E NOT NU E NOT NU E E NULL NULL NOT NULL NOT NULL NULL NULL NULL Type NUMBER 5 VARCHAR2 255 VARCHAR2 255 VARCHAR2 255 VARCHAR2 255 VARCHAR2 8 VARCHAR2 8 DATE DATE NUMBER 1 DATE MBER 10 MBER 10 MBER 10 MBER 10 VARCHAR2 8 MBER 4 2 NU Z 2 eue oj z Sia 4 MBER 3 MBER 1 MBER 10 MBER 10 MBER 6 MBER 10 MBER 3 MBER 5 z 2 C 2 c MBER 3 MBER 3 MBER 10 Z 2 MBER 3 NUMBER 2 DATE VARCHAR2 20 NUMBER S 2 10 2 5 Z 4 t 2 c MBER 5 FINAL CONFIDENTIAL Bitmap indicating necessary checks of bank authorisation card PIN bank TK only RFU RFU RFU R
11. Table structure of C amp A System Identifier indicating group sharing for the Bank in 59PAN file several values RFU RFU RFU RFU FU RI Authorisation limit for ATM transactions Authorisation limit for POS transactions Maximum waiting time for on line authorisation of the purchase transactions National Identifier for the Bank Bank Cash Account No which is to be used for settlement Total Load from cash amount Total Unload to cash amount City part of Address of the Bank Contact Person for the Bank Country where bank is located Bank deleted date Default 0 Flag indicating whether the Bank has been deleted Fax number of the bank C amp A system specific Unique Number identifying for each Bank ICC currency component and code as used in POS transactions Off line ATM floor limit of ICC Off line POS floor limit of ICC Maximum number of off line ATM authorisations Maximum number of off line POS authorisations Maximum days off line Maximum days off line Maximum total off line ATM tx amount Maximum total off line POS tx amount Revolving credit cycle limit for ATM Tx Revolving credit cycle limit for POS Tx Revolving credit cycle length for ATM tx Daily Weekly Revolving credit cycle length for POS tx Daily Weekly Name of the Bank Flag to indicate whether this bank pays service charge s for transactions done at other bank Bank Pool to which the bank belongs Total Load from cash amoun
12. Terminal Id Terminal serial number for that bank merchant defined by the C amp A system Terminal Manufacturer No Identifier for the terminal manufacturer defined by the C amp A system Enter valid data or press Search button and select a valid data from list of values Terminal Category The terminal is MERCHANT terminal Terminal Service Status Terminals can be ACTIVE Terminal is in operational mode UNDER REPAIR Terminal currently out of service SHUTDOWN Terminal not used anymore The Terminal Service Status can be set via Terminal Update Terminals Merchant Bank Id Identifier of the bank the merchant has the account for this terminal Enter valid data or press Search button and select a valid data from list of values Merchant Bank A c No Account number where the transactions for this terminal are settled Please note that the accounts are terminal related thus one merchant may have different accounts for different groups of terminals at one bank Enter valid data or press Search button and select a valid data from list of values Loaded Terminal SW Version Giving the software version which is actually loaded into that terminal Number Maximum length 4 Not mandatory STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL Last Fault Type Last fault which occurred on that termi
13. archivation changed to Y Unique identifier for the bank terminal executing the transaction BT Id First entered Customer card number for this particular transaction Required for POS loading where the cash is being transferred from Bank Clerk card to Customer card This card number is used always as the source account card number for raising debit advice but only in case of LOADING Next entered Customer card number for this particular transaction Required for POS loading where the cash is being transferred from Bank Clerk card to Customer card Last completion code of the cardholder card Last completion code of the Terminal Card Debit Advice Number to indicate whether debit advice has been raised or not Transaction number for the customer card POS funds raising transaction Transaction number for the customer card Load transaction Transaction number of Terminal card Transaction Confirmation 0 Confirmation arrived 1 Confirmation not arrived 2 Lost Data confirmation will not arrive on line May require manual clearance Variable containing important parameter Pool Id for the customer pool where the amount will be updated for ECH standard pool EC 00 Purse Provider for the IEP Together PPIEP IEP make a unique identifier for an IEP ECH in a transaction Reason for which this transaction has happened For LOAD 01 or UNLOAD 02 Transaction technical error code stored for l
14. 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL CL esse ELE E 221 INF20003 A Terminal can have maximum Not Applicable cards each of different service 222 INF20004 Card already issued cannot modify Not Applicable service 223 INF20017 There is no Terminal for this Not Applicable which has card s to be 224 INF30001 No Record s Retrieved Not Applicable 225 INF30002 You cannot delete this Not Applicable manufacturer as detail records exist 226 INF30003 There are no customers having an Not Applicable Account in this Bank 227 INF30004 From Date Should Be Less Than or Not Applicable Equal to Date 228 INF30005 From To Date Can Not Be A Not Applicable Future Date 229 INF40001 Customer exists for bank Cannot Not Applicable delete 230 INF40002 CA provider exists for bank Not Applicable Cannot delete 231 INF40003 Do You Want To Continue Not Applicable Personalisation OF The Terminal Card 232 INF40003 There is no Card in the system Not Applicable which can be 233 INF40003 There is no Card for the Customer Not Applicable which can be 234 INF40004 Please Insert Terminal Card for Not Applicable Service BSTIEP and Press OK 235 INF40005 Please Insert Terminal Card for Not Applicable Service BSTPOS and Press OK 236 INF40006 Please Insert Terminal Card For Not Applicable Service PSAMIEP and Press OK 237 INF40007 Please Insert Ter
15. Advice Please note Before the settlement advice can be generated the transfer data must have been read to the database This happens daily at the time defined in System gt Set up gt System Init gt Settlement Bank Settlement Time The correctness of the transfer data can be checked in the log file directory in file Of lt date gt dat while date is the actual system date 3 3 1 1 Retrieve Existing Purchase Transaction Records e Select either the Single Merchant or All Merchants option e For All Merchants Page 26 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL Either Enter valid Transfer Date Or Press the Search button Searchable fields are in Yellow legend Wildcarding may be used in the field Press Ok in the List of Values after choosing any particular transfer date Merchants who have uploaded purchase transactions for which Settlement Advice has not been raised is shown with the following information Merchant Id Merchant Name Transfer Date Settlement Amount For each Merchant Information retrieved Merchant A c Transactions Details shown on the screen showing the following fields Merchant Bank Id Account No Amount Service Charge For each Merchant A c Transactions Details retrieved Terminal Transactions Details are shown on the screen displaying the followi
16. Customer ID should be unique created 55 ERR40033 Bank Specific Clerk Id for the Bank When a duplicate Bank clerk id is created should be unique 56 ERR40034 Terminal Terminal Card Or Service Card services not present in the table Data Not Found Cannot Continue GDSERV 57 ERR40035 Please Insert Card With Proper Service type of entered card is invalid in Service this context 58 ERR40036 The Card Setup In The System The card service does not support Debit Does Not Require Debit POS POS functionality i e the card type is lower Functionality than Ver2 2 59 ERR40037 Replaced card has not been Attempt has been made to execute any exported Export it first functionality before exporting the replaced cards ERR40038 From Date To Date Fields Are Not Format of entered Date value is not proper Properly Entered Format in this context dd mm yyyy 61 ERR40039 Invalid From Date To Date Entered From date and To Date are invalid in this context 62 ERR40040 From Date Should Not Be Greater From date is greater than the System Date Than System Date Or To Date 63 ERR40041 Year Should Be Greater Than Zero Zero is entered in the place of year in a date field 64 ERR40042 Customer Bank A c No should not Length of entered bank A c no is greater exceed length 12 than 12 65 ERR40043 No bank can have more than 999 For a specific bank if an attempt is made to cards in the same customer account issue 1000th card
17. Key Name 59PANID BANK BANK ATTRIBUTE2 BANK ATTRIBUTE3 BANK ATTRIBUTEA BANK AUTHLIMITATM BANK AUTHLIMITPOS BANK AUTHTIMEOUT gt NK BIN NK CASHACCNO ANK_CASHLOADAMT NK_CASHUNLOADAMT BANK CITY BANK CONTACTPERSON BANK COUNTRY BANK DELDATE BANK DELFLAG BANK FAX BANK ID BANK 150317 316 BANK 1580401 ICCATM BANK 150401 ICCPOS BANK 150402 BANK 150402 POS BANK 150404 BANK 150404 POS BANK 150406 BANK 1850406 POS BANK 150408 BANK 150408 POS BANK 150409 BANK 150409 POS BANK NAME BANK OTHTXNSVCFLG gt gt BANK POOLID BANK PURGEDCASHLOADAMT BANK PURGEDCASHUNLOADAMT BANK PURGEDSVCAMT BANK SECTORID BANK STREET BANK SVCACCNO BANK SVCAMT STARCOIN C amp A System User Manual 25 05 Version 2 0 1 Revision 15 04 99 This table is used to keep Bank Master information Bank_Poolld BANK_POOL BANKPOOL_POOLID Null NOT NULL NUMBER S U U U U U NULL NULL NULL NULL NOT NULL NOT NULL NOT NULL NOT NULL VARCHAR2 30 VARCHAR2 30 U U U U U rye LL LL LL c i LL LL NOTNULL VARCHAR2 30 NULL NUMBER 1 NU NU NU LL LL LL NU NU NU MBER 5 MBER 10 MBER 10 NU NUMBER 10 NUMBER 2 VARCHAR2 30 MBER 20 MBER 10 99 FINAL CONFIDENTIAL Appendix B
18. MBER 1 MBER 2 Z VARCHAR2 20 VARCHAR2 30 NUMBER S DATE DATE MBER 4 MBER 10 MBER 10 MBER 3 MBER 3 MBER 5 MBER 5 MBER 10 MBER 10 MBER 10 MBER 10 MBER 3 NUMBER 3 VARCHAR2 12 DATE MBER 1 Z Z Z Z Z 71 Gl c oc 2 2 c MBER 3 2 20 5 Jj z Sia 4 MBER 10 MBER 5 2 MBER 2 DATE Identifier for card functionality depending on type of card RFU Unique Number identifying for each Customer Card 0000 amp PID 3 amp N 13 coded Unique Identifier for the card s corresponding customer C amp A system specific Customer Card deleted date Default 0 Flag to indicate deleted Customer Card Number of duplicate issued if any for this card 1 at Renewal or Replacement Number of the Current Cardholder Id 0 amp 67 amp CustCard_CardNr amp LUN Bank BIN for the Customer s bank Cardholder id sequence number for the current file RFU not displayed Date on which the Customer card is effective Personalisation date ICC currency component and code as used in POS transactions Maximum number of off line POS authorisations Revolving credit cycle length for ATM tx Daily Weekly Revolving credit cycle length for POS tx Daily Weekly Card acceptor name and location Customer Card Issue Date date of card set up in database Status
19. NULL NULL NULL NULL NULL NOT NULL NOT NULL NULL NOT NULL NOT NULL NOT NULL 2 2 C NOT NULL Z 2 2 c E B Z Imi NOT NULL NU NO LL T NULL LL LL LL LL LL NOT NULL Table 6 44 Structure of table TERMINAL Page 80 of 109 This table is used to keep terminal information TERM MANENR TERM MANF MANF Type VARCHAR2 255 VARCHAR2 255 VARCHAR2 255 VARCHAR2 255 MBER 6 MBER 2 MBER 4 2 NU NU 2 MBER 1 gt gt 4 t NUMBER 1 NUMBER 5 VARCHAR2 12 MBER 2 MBER 5 MBER 4 MBER 10 RCHAR2 30 MBER 3 MBER 20 MBER 4 MBER 10 cic gt 2 NUMBER 10 DATE NUMBER 8 MBER 5 MBER 2 MBER 4 MBER 4 VARCHAR2 30 NUMBER 3 FINAL CONFIDENTIAL C amp A system specific number of a bank terminal Category of the Terminal whether PURCHASE 01 or BANK 00 Cluster Id part of the terminal Id Service provider specific number e g according to 1508583 For bank terminal set to 6010 for BST and 6011 for SST Flag indicating whether the confirmation from this Bank terminal has arrived for the last session Terminal deleted date Default 0 Flag indicating deleted Terminal Unique Number identifying each Terminal related to Term Opld The complete terminal id is build of Term OpId amp Term ClustlId amp Term Id Short identifier of card
20. Page 69 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name MERCHANT Description This table keeps Merchant information Primary Key MRC ID Foreign Key N A VARCHAR2 255 VARCHAR2 255 TrmCard Opld therefore max value defined Table 6 24 Structure of table MERCHANT Table Name MRC_ACCBAL Description This table keeps Merchant Bank and Account No wise cumulated ECH Pool and POS Transaction amount Primary Key MRCACCBAL_MRCID MRCACCBAL_ACCNO MRCACCBAL_MRCBANKID MRCACCBAL_PURGEDECHAMT NUMBER 10 Total purged ECH amount MRCACCBAL_PURGEDPOOLAMT NUMBER 10 Total purged IEP amount MRCACCBAL_PURGEDSVCAMT NUMBER 10 Total purged Service charge amount MRCACCBAL_PURPOOLAMT NUMBER 10 Total IEP amount for that account MRCACCBAL_SVCAMT NUMBER 10 Total Service charge paid from that account Foreign Key Dena REN NUMBER 10 Total DBPOS transaction amount NUMBER 10 Total ECH amount of that account Se EMROACGBAETUROHDECHAMT 1 MRCSCORARCPURCEDROQESMES 1 __ Table 6 25 Structure of table MRC_ACCBAL Page 70 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name MRC POOL Description This table keeps terminal cardwise cumulated pool
21. Total No of Terminals Total No of Active Terminals Total No of Under Repair Terminals Total No of Shutdown Terminals are shown as Summary Information Terminal information part Operator Id Unique identifier for a merchant Terminal Id Terminal serial number for that merchant e Cluster Id Group identifier for the specific terminal e Category Bank Service or Merchant Terminal Bank Merchant Name Operator of the terminal e Status Active Under Repair or Shutdown STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 9 3 Summary information part e Total number of Terminals Total number of terminals in that terminal location e Total number of Active Terminals Total number of active terminals in that terminal location Total number of under repair Terminals Total number of under repair terminals in that terminal location e Total number of Shutdown Terminals Total number of shutdown terminals in that terminal location 4 9 4 Navigation e Atany point of time pressing Clear button clears the screen so that new query can be fired depending on option chosen e Atany point of time pressing Close button closes the form e To get report of the data retrieved for Single Location or Locations press Print button after query has been executed e A report previewer appears
22. Unique Number identifying for each terminal card CARDPOOL_TM NULL NUMBER 15 Total transaction amount for the pool in this terminal card This will occur 14 20 times for each PSAM TransferDate CARDPOOL_TRANSFERDATE NOT NULL DATE Transfer date and time stamp for the PSAM transfer session or system clearing date time if DE 0 0 in reconc data Table 6 3 Structure of table CARD POOL STARCOIN C amp A System User Manual 25 05 99 Vol Page 53 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name CA PROGRAM Description This table is used to keep module information for maintaining System Log Primary Key N A Foreign Key N A CPG_MODULEDESC NOT NULL VARCHAR2 60 Module description Name CPG_MODULENAME NOT NULL VARCHAR2 10 Module Name Table 6 4 Structure of table CA PROGRAM Table Name CA PROVIDER Description This table is used to keep System Provider information Primary Key N A Foreign Key N A Name Null CAP ATTRIBUTEI CAP ATTRIBUTE2 CAP ATTRIBUTE3 CAP ATTRIBUTEA CAP CITY CONTACTPERSON CAP COUNTRY CAP DELDATE CAP DELFLAG L L L L L li GG L L G L L City part of the Address of the CA Provider Contact Person for the CA Provider Country of System provider CA Provider Deleted Date Default 0 Flag to indicate deleted CA Provider L L L L L
23. Version 2 0 1 Revision 15 04 99 6 Appendices TRMCARD UPDTKSENDDATE TRMCARD VKATMOFF TRMCARD VKATMON TRMCARD VKIEPLOFF TRMCARD VKIEPLON TRMCARD VKIEPPOFF TRMCARD VKIEPPON TRMCARD VKPINRESET TRMCARD VKPOSOFF TRMCARD VKPOSON TRMCARD VKRSAMOD TRMCARD VKRSAPUBLIC TRMCARD VKRSASECRET TRMCARD VKUPDENC TRMCARD VKUPDMAC TRMCARD VKUPDSIG 2 2 c 2 2 c 2 LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL LL DATE NUMBER 3 NUMBER 3 U U FINAL C ONFIDENTIAL Date when last update command has been sent Contains value of SysTkpar_Keyversion TK update Contains value of SysTkpar_Keyversion TK update Contains value of SysTkpar_Keyversion TK update Contains value of SysTkpar_Keyversion TK Contains TK Contains TK Contains TK Contains TK Contains Contains TK Contains TK Contains TK Contains TK Contains TK e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e value of SysTkpar_Keyversion e Contains value of SysTkpar_Keyve
24. acceptor Defined by merchant ASCII RFU Type of fault last encountered for this terminal Redlist Number finally sent to the Terminal Last received transaction Id Date received as YDDD and kept as N 4 for this terminal of type Bank only Last received transaction Id sequence number for this terminal of type Bank only Location of the Terminal Identifier indicating this Terminal s Manufacturer Merchant Bank Account No for settlement for this terminal Merchant C amp A system specific Bank Id for ECH IEP settlement Transaction counter of terminal increased 1 at every reconciliation single rec tx at every reconciliation itself and parameter update of terminal Unique Terminal Operator Id which is equal to related Merchant identifier Mrc Id or Bank identifier 100000 amp Bank Id Date of the redlist last received by terminal Maximum Length of the redlist for this terminal Number of the redlist last received by terminal Status of the Terminal with regard to its operability e g UNDER REPAIR ACTIVE SHUTDOWN etc Version number for the software loaded in the terminal Terminal Topical Software Version compare Term SW Version Type of Terminal Model Type Type of data transfer for this terminal only one bit can be set refer to DD STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name TERM Description
25. and Clear or Close button is pressed the system will raise an alert for confirmation and will act accordingly Otherwise pressing of Clear or Close button without any change made will clear or close the screen respectively 1 3 Update Delete Merchants Access path Terminal Update Merchants 1 3 1 Update Merchant Information Retrieve Existing Merchant Record e Either Enter a valid Merchant Id and press Tab to fetch the record on the screen e OR e Put the cursor on Merchant Id or Merchant Name At this stage Search button is on e Press the Search button A List of Values containing the list of Merchants will be displayed Wildcarding is possible e Select a Merchant record and press button in the List of values e The desired record is fetched onto the screen 1 3 2 Update Merchant Record e The following fields can be modified e Street Characters with maximum length 30 Not mandatory e City Characters with maximum length 30 Not mandatory e ZIP Code Characters with maximum length 30 Not mandatory e Country Characters with maximum length 30 Not mandatory e Telephone Characters with maximum length 30 Not mandatory Fax Characters with maximum length 30 Not mandatory e Contact Person Characters with maximum length 30 Not mandatory e Press Save button to save the changes e Press Close button to com
26. as the PCT file version of the actual PCT file A PCT file Personalisation Control Table defines the personalisation structure for a card Please assure always to use the right version If the PCT file is updated a new version will be provided by G amp D Please make sure to delete the old version to avoid misuse or accidental usage PCT Log Directory Name e The PCT File Name will appear automatically To work with an encrypted PCT file click on the Use Encrypted File check box e Press Personalise button to personalise and issue terminal cards The data is stored in the card inserted A Personalisation log file is generated in the PCT directory of the client named lt PSAM No in Hex gt 1 2 2 5 View or modify Merchant Terminal Terminal Card Data In the details screens you can modify the following fields prior to issue of Terminal Card After personalisation only the merchant information fields can be changed For Merchant Information Press Details in the merchant bank section For Terminal and Terminal Card Press Details in the terminal section 1 2 2 6 Issue Transfer cards Transfer cards must be personalised to receive the correct authentication key for the related terminal and banks e Please note A transfer card can be used at any bank but only at the terminals of one specific merchant same Operator Id e Select the terminal and the terminal card a Transfer Card shall be is
27. buttons on top e Prey Takes to previous page e Next Takes to next page STARCOIN C amp A System User Manual 25 05 99 Vol Page 31 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL e First Takes to the first page e Last Takes to the last page e Page Takes to page no entered in the box next to the button e Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report sent to personal mail account e Close Closes previewer screen e New Creates another copy of previewer screen 4 4 Transactions e Access Path Queries Reports Transaction Overview to all transactions within a certain period for one or all customers participating in the system 4 4 1 Retrieve the records e Select Option for Single Customer or Customer e Enter From Date and To Date in DD MM YYYY format e For Single Customer e Press Tab to place the cursor on C amp A Customer Id field At this stage Search button is enabled e Either Enter valid data in C amp A Customer Id or enter valid data in Customer Name and Bank Customer Id and C amp A Customer Id Searchable fields are in Yellow legend W
28. found Incorrect Manufacturer Id is entered ERR20023 Bank Id not found Incorrect Bank Id is entered ERR20024 Merchant Id not found Incorrect Merchant Id is entered 2 ERR30001 From Date Should Be Less Than or From Date is greater than To Date Equal to to Date 22 ERR30002 From To Date Can Not Be A From To date is greater than current date Future Date 29 ERR40004 Bank Bin has already been assigned An attempt is made to assign BIN toa to a Bank bank which is already assigned to another bank ERR40005 Enter valid Date Of Birth Invalid Date of Birth Entry ERR40006 Enter valid Card Effective Date Invalid Card effective date Page 84 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL ERR40007 Enter valid CA Provider ID Entered CA provider Id is not valid in this context FERRAQOT3 Cands notyetperonaised 37 ERR40014 Card Effective Date should be Entered Card effective date is greater than before or equal to Expiry Date or equal to Expiry date 38 ERR40015 IEPECH Expiry Date should be Invalid IEP ECH Expiry date entered before or equal to Card Expiry Date 39 ERR40016 Expiry Date should be IEP ECH expiry date is less than or equal to equal to or after Card Effective Card Effective date Date ERR40017 IEPECH Activation Date should be Entered IEP ECH Activation date Greater before or equal to IEPECH Expiry than IEP ECH Expiry d
29. of debit advice for on line customer transactions such as Load customer card from cash account and e Unload customer to cash account e Generation of settlement advice for IEP ECH POS off line purchase transactions e Generation of settlement advice for POS on line purchase transactions e Export of settlement data to be sent to settlement bank which may be hashed and encrypted Settlement can be generated manually using the screen menu Settlement Debit Advice Settlement Advice or automatically through the off line process CBSERVER t and the setting for automated mode in System Setup System Init Settlement Bank Figure below depicts the Manual and automatic process of settlement Automatic Settlement CBSERVER t Debit Advice Information Manual settlement Settlement Settlement Advice 3 recorded as single transactions Figure 3 1 Settlement Process Page 22 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL The settlement process generates settlement advice for both the transaction amount and the service charge amount The table below depicts the source and destination of the settlement advice for different transactions e TEP Load from account Credit Bank Pool Account Customer Bank Account C amp A System provider Service account Customer Bank Service Charge account EP Load from Cash
30. on the screen with following buttons on top e Prey Takes to previous page e Next Takes to next page e First Takes to the first page e Last Takes to the last page e Page Takes to page no entered in the box next to the button Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report can sent to personal mail account e Close Closes previewer screen e New Creates another copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 45 of 109 Version 2 0 1 Revision 15 04 99 5 Utilities 5 1 5 1 1 5 2 5 2 1 Page 46 of 109 FINAL CONFIDENTIAL Utilities Introduction Prerequisites For Export Processing records should exist in Debit Advice IEP Settlement Advice amp ECH Settlement Advice which has not yet been exported Generate export file of Debit Advice e Access Path Utilities Export Debit Advice All debit advice which have been not been exported to a flat file can be exported Hence only those customers who have transactions for which debit advice has been raised but not exported will be shown Retrieve Existing Customer record Select either the Single Customer or Customers option e For All Customers
31. status ACTIVE UNDER REPAIR SHUTDOWN Last fault type Last error which occurred on that terminal 4 8 3 Summary information part Page 42 of 109 Total number of bank terminals Number of all ACTIVE bank service terminals Total number of merchant terminals Number of all ACTIVE merchant terminals STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 8 4 Navigation e Atany point of time pressing Clear button clears the screen so that new query can be fired depending on option chosen e Atany point of time pressing Close button closes the form To get report of the data retrieved for Bank Terminal or Merchant Terminal or All press Print button after query has been executed report previewer appears on the screen with following buttons on top e Prey Takes to previous page e Takes to next page e First X Takes to the first page e Last Takes to the last page Page Takes to page no entered in the box next to the button e Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report can sent to personal mail account e Close Closes previewer screen e New Creates an
32. the flat files ISLDDMMY dat IEP purchase settlement data ESLDDMMY dat ECH purchase settlement data and POSDDMMY dat POS purchase settlement data in the Export Directory of the STARCOIN Server The entire data from the settlement advice table is dumped in the file Page 48 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 6 Appendices 6 1 Appendix A Entity Relationship Diagram ENTITY RELATIONSHIP DIAGRAM FOR STARCOIN C amp A APPLICATION SYSTEM Depending on different BANK amp ACC for different TERMINAL Depending on the no of Pools in BANK POOL 1 TERM MANF BANK POOL MRC POOL MRC ACCBAL MERCHANT BANK cm CUSTOMER ay associate either to a erchant or td a Bank CUST CARD TERMINAL For a particular service may have 1 or None TRM CARD DB ADVICE IEPECH IEP ECH Load amp Unload CUST TRANSACTION PUR TRANSACTION DBPOS TRANSACTION Purchase Upload CARD POOL ECH STLADVICE IEP STLADVICE DBPOS ADVICE L kecumulated for a Merchant amp a pool STARCOIN C amp A System User Manual
33. this pool Default 0 U U BANKPOOL_UNLOADNR NOT NULL NUMBER 10 Number of unloading transactions on this pool Default 0 BANKPOOL_UNLOADTM NOT NULL NUMBER 15 Cumulated unload amounts of this pool Default 0 Table 6 2 Structure of table BANK_POOL Page 52 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name CARD POOL Description This table is used to keep pool wise purchase transaction details Primary Key CARDPOOL NO Foreign Key CARDPOOL PSAM TRM CARD TRMCARD PSAM CARDPOOL ARCHFLAG NOT NULL CHAR 1 CardPool archived confirmation Default N after archivation changed to Y CARDPOOL CRITICAL NOT NULL NUMBER 1 0 Indicates valid transaction 1 Erroneous Transaction CARDPOOL_CUMLTM NULL NUMBER 15 Cumulated transaction amount for the pool in this terminal card as received from the Transfer File U U CARDPOOL_NC NOT NULL NUMBER 5 Reconciliation or the transfer number for this PSAM CARDPOOL NI NULL NUMBER 5 Total number of individual transactions for this PSAM transfer CARDPOOL NO NOT NULL NUMBER Unique Pool Transaction Number NU U U CARDPOOL POOLID NOT NULL MBER 5 Pool Identifier for the PSAM This will occur 14 20 times for each PSAM TransferDate CARDPOOL_POOLSTLNO NULL NUMBER Settlement advice number indicating whether the advice for this pool has been generated CARDPOOL_PSAM NOT NULL NUMBER 10
34. which shows whether the customer card is under red List 1 Black List 2 or neither 0 Indicates whether the card limit is weekly or daily Default value 80 weekly limit Indicates the card number which replaces the existing one Transaction Number for this card Date to indicate whether the customer Card personalisation data have been generated and exported LKZ related Limit for the Customer Card Bank auth cards have a higher limit Indication whether card is for POS IEP ECH Bank refer to GMW08_xx doc Current Status for the card could be NEW 01 ACTIVE 02 Extra list box for reason fake lost stolen Date when topical status was set or state reason occured e g loss theft STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL CUSTCARD STATUSREASON NULL VARCHAR2 20 Indicates the reason why a card has been set to a certain state ref CustCard_STATUS Table 6 9 Structure of table CUST_CARD STARCOIN C amp A System User Manual 25 05 99 Vol Page 57 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name Description CUST TRANSACTION CUSTTRANS NO CUSTTRANS IEPECH IEPECH IEPECH IEPECH CUSTTRANS PSAM TRM CARD TRMCARD PSAM CUSTTRANS AC pc NUMBER 3 CUSTTRANS_ AI NULL NUMBER 2 CUSTTRANS_ARCHFLAG OT NULL CHAR 1 NU NU N CUSTTRANS ATTRIBUTEI NU VARCHAR2 255 NU NU NU Primary Key Forei
35. 0093 Invalid archive directory Given directory path file non existent Page 92 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 200 ERR90094 Archiving and Purging Stopped Archiving Purging stopped due to some abnormally Please check your error Possible error invalid directory for entries purging 201 ERR90095 Resource used by another user Data displayed in the form may have changed by another user 202 ERR90100 System Parameters are not correct Incorrect System Parameters are entered contact System Administrator 203 ERR90102 Can not replace Contact System Attempted to replace when some system Administrator error has occurred ERR90103 Field must be in the Range 0 to Field is entered outside the range ERR90104 Field must be entered completely Field is not entered completely 206 ERR90105 Resource is busy Please try again The particular table is already being used by another user when it is attempted to access 207 ERR90106 Unable to Generate Merchant Id Max limit of Merchant Id has exceeded and Max Limit 2147483647 new merchant is tried to insert 208 ERR90107 Unable to Generate Terminal Id Max limit of Terminal Id has exceeded and Max Limit 65535 new Terminal is tried to insert 209 ERR90108 Unable to Generate Terminal Card Max limit of Terminal Card Number has Number Max Limit 4294967295 exceeded and new Terminal Card is
36. 2 S T INTRODUCTION PO ERR HEU ERE ERI RETI I RE ERE RETE DEUDA T ETERNA 22 Sb E Prerequisitesc asa E RUN GR Re ERE RN UE SR RI MN ER NER NUR MEUS 24 3 2 GENERATE DEBIT ADVICE FOR LOAD UNLOAD 2 2 202 60000000000000000000000005000 1 25 9 3 SETTLEMENT ADVICE o pn EO wide ipe eos 26 4 QUERTES AND 300 0 53 ARRA 29 AT INTRODUCTION oue RE URA NU RROUINNO A E E IGNI IIIA eee 29 4 sl Prerequisitis a a v tex er ERE ERRARE NOR EEG RES tiga ERRRRENUBE UE DAR HE EMT EMQUE NARI 29 DAGLI 29 4 2 l Retrievethe records saa see a er d Ue iro dete teta teen Rer d Hx Nee Ra ee RENE 29 4 2 2 Ndvig tioni e eto ete meer te eei s b tete sete de de lits 29 4 23 Custome A OE 30 4 3 CUSTOMER CARD BALANGE fs t ten e n anae tier tees 30 4 35 R trievethe recordg i SL n RR ROG HESSEN NAR 30 4 3 2 Load Unload Transaction part issiria pios ensaia enne tne tenete 31 4 3 3 Payment Transaction ius e eO EGRE 31 2 3 4 NaVvigatioTis esse eco EG IRE edP EO 31 4A TRANSACTIONS ER et ER ER ON RE eee e e eei D re te regie 32 44 I Retrieve the records sedie Re teres eadeni Eo ER eee e ERR Led de RED EY Eod Eder IRR 32 4 4 2 Load Unload transaction ert Fh EO S e Uer RUE RENE HU RERO 33 24 3 Pu
37. 25 05 99 Vol Page 49 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices DM PROCE FINAL CONFIDENTIAL G amp D Initialisation GDAID GDATR SYSADM ld DM ROLE GDCARDPAR GDSYSPAR EY VERSION GpsERV K Ps DM RoLE LTE 5 System Initialisation SYSISOPARPOS SYSREDLIST SYSISOPARATM SYSPAR SYSAl SYSADM ERRORS PROVIDER SYSCARDPAR CA_SE SYSLOG C amp A Interf GDCA_PARAMS TRANSFER_F PENDING_NC NOTATIONS Figure 6 1 Entity relationship diagram Page 50 of 109 DESCRIPTION One A must have one or many B while B must belong to A One A may have one or many B while B must belong to A while B must belong to A B while B must belong to A while C must belong to A X OR Relationship SYTKUPD One A may have one and only one B Either one A may have one or more OR one A may have one or more C STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices 6 2 Table Name BANK Description Primary Key Bank Id Foreign
38. 37 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 6 4 Page 38 of 109 Bank Id Corresponding identifier for the Bank Balance Balance corresponding to this Account within the given range of From Date and Date Service Charge Total service charge paid from for this account within the given range of From Date and To Date Total Account Balance of the merchant Total balance for the merchant within the given range of From Date and Date Total service charge paid by the merchant Total service charge paid by the merchant within the given range of From Date and Date Navigation At any point of time pressing Clear button clears the screen so that new query can be fired depending on option chosen At any point of time pressing Close button closes the form At any point of time pressing of Labels in block Payment Transactions will sort the fetched records depending on which label is pressed To get report of the data retrieved press Print button after query has been executed A report previewer appears on the screen with following buttons on top e Prey Takes to previous page e Next Takes to next page e First Takes to the first page e Last Takes to the last page Page Takes to page no entered in the box next to the button e Print Prints the report s
39. 4 99 4 Queries and Reports FINAL CONFIDENTIAL 4 3 2 Load Unload Transaction part Transaction Date amp Time Date when the transaction was executed IEP ECH No Unique number of the IEP or ECH payment application on the customer card Type Type of payment application IEP or ECH Reason Type of transaction Load or Unload Context Context of the transaction Account Cash or ATM RFU Amount Loaded Unloaded amount Service Charge Service Charge Paid Bank Id Related Bank Id for the Customer Card 4 3 3 Payment Transaction part Transaction Date amp Time Date when the transaction was executed Type Type of payment application IEP or ECH or POS Amount Transaction amount Terminal OpId Unique identifier for the merchant Terminal Id Terminal serial number for that merchant IEP ECH No Unique number of the ECH payment application on the customer card 4 3 4 Navigation At any point of time pressing Clear button clears the screen so that a new query can be fired depending on option chosen At any point of time pressing Close button closes the form At any point of time pressing of Labels in block Load Unload Transactions or in Payment Transactions will sort the fetched records depending on which label is pressed To get report of the data retrieved press Print button after query has been executed A report previewer appears on the screen with following
40. 53 Expiry date of IEP ECH must be A date less than the current date is entered greater than the current date for Expiry date of IEP ECH 165 ERR90054 Minimum Limit must be less than The entered value of minimum limit is or equal to the Maximum Limit greater than maximum limit ERR90055 No Service is available A service is entered where none is available 167 ERR90056 Customer Card Expiry date must be A date less than the current date is entered greater than the current date for Customer Card Expiry date 168 ERR90057 Expiry Date of Terminal Card A date less than the current date is entered Generation must be greater than the for Expiry date of Terminal Card current date Generation ERR90058 Proper value must be entered in all Records have been tried to save when all fields fields in all the screens have not been entered 9 Currency Code should contain Characters have been entered for Currency digits lying between 0 and 9 only Code and attempted to save 5 Currency Code must be greater than The entered value for Currency Code is 0 0 172 ERR90061 Settlement Time must be entered Settlement Time is not entered for for Automatic mode of Settlement Automatic mode of Settlement ERR90062 Enter valid Settlement Time Invalid Settlement Time is entered apo Enter valid Menu Item Invalid Menu Item is entered 175 ERR90064 Duplicate A c No Uniqueness of a c no is violated ERR90065 Cannot modify this service code Service code is atte
41. 534 When total no of cards for a Batch export Cards process exceeds 65534 111 ERR80058 Invalid Command Line Relation Generated Command for export is wrong Page 88 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Cannot Export es 112 ERR90001 Invalid Error Code Encountered Error Code s in Error master Contact DBA SYSADM ERRORS are either modified or deleted ERR90002 Duplicate Key Exists For Duplicate key entry 114 ERR90003 The system is unable to generate Unable to generate serial no for nn Serial Number for ERR90004 Enter valid User ID Invalid User Id entry ERR90005 Enter valid Password Invalid password entry 117 ERR90006 Unable To Log In To System after Log in failed for three successive times 3 Attempts Exiting quits ERR90007 Enter valid Role ID Invalid Role Id Invalid Role Id entry ERR90008 Unable To Open File Unable To Open File 120 ERR90009 Version Specific Keys not Loaded During Key management operation if the prc of proper version is not loaded ERR90010 Do you want to update the data Confirmation message on Confirmation message on update 122 ERR90011 User Deleted Contact System An attempt is made to retrieve one deleted Administrator User 123 ERR90012 Role ID is deleted Contact System An attempt is made to retrieve one deleted Administrator Role 124 ERR90013 No Cha
42. 9 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name IEPECH Description This table is used to keep the purse information of a Customer Card Primary Key IEPECH IEPECH Foreign Key IEPECH_CARDNR CUST CARD CUSTCARD CARDNR IEPECH BALMAXIEPECH NOT NULL NUMBER 10 Maximum holding amount for the IEP ECH depending on type of purse IEPECH CARDNR NOT NULL NUMBER 20 Unique Number identifying for the corresponding Customer Card IEPECH CURRIEP NOT NULL NUMBER 4 Currency for the IEP ECH IEPECH DACTIEP NULL DATE Date on which the IEP is Activated Defined Date of ICC personalisation IEPECH DDEAIEP NULL DATE Date on which the IEP is deactivated No more tx allowed DEXP SysCardPar DdeaOff In case of loss defect theft and fake of the card this date is preset in the database IEPECH DELFLAG Default 0 Flag to indicate deleted IEPECH DEXPIEP Date on which the IEP expires No more Load allowed ULL 0 U IEPECH_ECHACCNO 20 Account number for the in this Card y IEPECH_IEPECH NOT NULL NUMBER 14 Unique Number identifying for each Electronic purse Start value is N PID Hex amp 00 00 00 01 N N L U L U U TEPECH_PIEP Phase Number for this Purse Default 01 IEPECH POOLID Pool Identifier associated with this Purse ECH derived from IEPECH CustCard Cust Bank Pool U U U U A N IEPECH PURAMT NULL NU
43. AL 2 2 1 2 2 Personalisation Process Introduction This section deals with the followings 1 Batch Export of Customer Card Data Once the customer cards are set up via Customer Card Handling Process they need to be personalised before being ACTIVE As a first step to that the card data to be exported in a specified file format from which they will be actually personalised in a subsequent stage 2 Import Customer Card Data After the customer card s have successfully been personalised a confirmation record is generated by the Personalisation program which must be returned to the C amp A System and read by the STARCOIN application to change the card status from NEW to ACTIVE From this very moment the card can be used Export Customer Card data e Access path Export Export Personalisation Data 2 2 1 Prerequisites e For exporting Card Data record s should present in the following tables 1 All the System and G amp D Initialisation tables 2 Bank Customer Customer IEPECH tables 2 2 2 Export of personalisation data e Choose the option from Issuing Bank block Valid values are Single and All e For Single Bank option get bank information either by providing valid Bank Id or via list of values through Search button e For All bank option all the bank information for which card s are yet to be exported will be fetched on the screen User c
44. Button of the first block of the initial screen after setting the option for Merchant Terminal e It will take you to the Merchant Entry screen where you have to enter the following fields Merchant Name Characters with maximum length 30 Mandatory Street where merchant is located Characters with maximum length 30 Not mandatory City where merchant is located Characters with maximum length 30 Not mandatory ZIP Code of city where merchant is located Characters with maximum length 30 Not mandatory Country where merchant is located Characters with maximum length 30 Not mandatory STARCOIN C amp A System User Manual 25 05 99 Vol Page 3 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL e Telephone Characters with maximum length 30 Not mandatory e Fax Characters with maximum length 30 Not mandatory e Contact Person Characters with maximum length 30 Not mandatory If OK button is pressed the Merchant record is saved and the control returns back to original calling screen along with Merchant Id Merchant name Merchant Id is system generated If at any point of time after making some changes if Clear or Close button is pressed system will ask for a confirmation and will act accordingly 1 2 1 2 Allocating New Terminal Follow the above mentioned Issue New Terminal Terminal Card proc
45. Cannot Delete Bank INF60007 Has No Bank s Attached To It Not Applicable 257 INF60008 This Bank is attached to a Pool Not Applicable Cannot delete Bank INF60009 Cannot delete a ECH Pool record Not Applicable 259 INF60010 Bank Name not to be entered Not Applicable without Bank Id INF60012 Select Bank 14 from the List Not Applicable INF60013 exists Pool not to be deleted Not Applicable 262 INF60014 Bank is attached to this Pool Not Applicable Cannot delete Pool record INF60015 No record retrieved Reenter Not Applicable 264 INF60016 All the participating Banks are Not Applicable already attached Cannot attach INF60017 is successfully attached to this Not Applicable Pool INF60018 is detached from this Pool Not Applicable 267 INF60019 Total No Of Pool has equal the Not Applicable Max Pool Parameter Cannot Create New Pool STARCOIN C amp A System User Manual 25 05 99 Vol Page 95 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 268 INF60020 There Is No Bank In The System Not Applicable Which Can Be Made The Pool Bank 269 INF60505 Enter valid Bank Id Not Applicable 270 INF70001 This facility is not allowed for Not Applicable 271 INF70002 No Deactivated Version Of This Not Applicable Key Is Available For Deletion 272 INF70003 No Deactivated Expiry Date Not Applicable Instance For This Key Is Available For Deletion 273 INF70004 T
46. Credit Bank Pool Account BAC Card Account C amp A System provider Service account BAC Bank service Charge account e Unload to account Credit Customer Bank Account Bank Pool Account C amp A System provider Service account Customer Bank service Charge account e TEP Unload to Cash Credit BST Bank cash Account Bank Pool Account C amp A System provider Service account BST Bank service Charge account ECH Load from account Credit ECH Account Customer Bank Account C amp A System provider Service account Customer Bank Service Charge Account e Load from Cash ECH Account BAC Bank Cash Account C amp A System provider Service account BAC Bank Service Charge Account STARCOIN C amp A System User Manual 25 05 99 Vol Page 23 of 109 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL e ECH Unload to account Credit Customer Bank Account ECH Account C amp A System provider Service account Customer Bank Service Charge Account e ECH Unload to Cash Credit BST Bank cash Account ECH Account C amp A System provider Service account BST Bank Service Charge Account EP Purchase Credit Merchant Bank Account IEP Pool Account C amp A System provider Service account Merchant Bank Service Charge Account ECH Purchase Merchant Bank Account ECH Account C amp A System provider Service account Merchant Bank Service Charge Account Table 3 1 Source and Destination for Settlement Note T
47. D PIN PRES CUSTOMERS CARDS oy genTREE EXP flo TERMINAL CARDS Figure 6 4 Key relations for KGG_EXPIRY STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 Page 102 of 109 6 Appendices FINAL CONFIDENTIAL 6 5 Appendix H Abbreviations Under respective LMK encrypiedkey Under respective LMK encrypted key security ere PCS inegratedcieuitcard U i Inersector electronic puse Master key derived rom top level key or KM_GEN KM Master key derived from top level key or KM_GEN KD Derived key derived from or KM KGG Top level key Generation key of generation keys Session key derived from KD LMK PCSM IRSA Rivest Shamir Adleman cryptographie algoritm SAM Security application module TK TemmicwiGAM 0 7 6000 Transaction XOR Exclusive OR Table 6 49 List of Abbreviations mac MSB Most significan PCSM PC Secur I I L L R T t HSM CC EP KM_G KM KD KGG KS MK SB MAC MSB OWF SA SAM K X XOR STARCOIN C amp A System User Manual 25 05 99 Vol Page 103 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices 6 6 Appendix I List of Tables TABLE 1 1 TERMINAL CARD REPLACEMENT CRITERIA TABLE 1 2 RESTRICTIONS ON TERMINAL CARD STATUS NEW TABLE 1 3 RESTRICTIONS ON TERMINAL CARD STATUS ACTIVE TABLE 1 4 RESTRICTIONS ON TERMINAL CARD STAT
48. FU Identifier indicating group sharing for the Bank in 59PAN file several values RFU Bitmap indicating necessary checks of bank authorisation card bank TK only Activation Date for the Terminal Card Defined Date of TK personalisation Terminal ISO506 Header required in Personalisation Terminal Card issue date date of card setup in database Showing the topical version of the terminal card version dependent keys Indicating the topical terminal card list status Default 0 0 Neither or red listed 01 Last received transaction number for this Terminal Card Requested or Supported service depending on type of card refer to GMW08_xx doc Show Balance Indicator Signature check by Terminal Card Individual Transaction Recording Limit for IEP purchase transactions Individual Transaction Recording Ratio for IEP purchase transactions Status of the Card 01 NEW 02 ACTIVE 15 RESTRICTED USE 90 DEACTIVATED Date when topical status was set or state reason occurred e g loss theft Reason for TK status Ref your document lifecyc1 doc Unique Identifier for the purchase terminal corresponding to the terminal card Unique Terminal Operator Id which is equal to related Mrc_Id or 100000 amp Bank_Id Number of TK update Date when last update confirmation has been received TransFile_NC at the moment the update confirmation has arrived STARCOIN C amp A System User Manual 25 05 99
49. ID NULL NUMBER 10 Operator Id identifying a merchant who s terminal cards shall be updated NULL N N SYSTKUPD_TERMID MBER 3 Terminal Id for a specific terminal of one merchant then Op_Id must be defined of which the terminal card shall be updated SYSTKUPD_UCTVER NOT NULL MBER 3 Version of the UCT file which is used to generate the update command SYSTKUPD_UPDDATE NOT NULL Date when this update has been started SYSTKUPD_UPDNO NOT NULL NUMBER S Number of that update start value 50 Incremented by 1 with every new setup update Table 6 43 Structure of table SYSTKUPD NU SYSTKUPD_DELFLAG Delete flag indicating that the TK Update record has been deleted logically U U U STARCOIN C amp A System User Manual 25 05 99 Vol Page 79 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name TERMINAL Description Primary Key TERM ID TERM OPID Foreign Key Name TERM ATTRIBUTEI TERM ATTRIBUTE2 TERM ATTRIBUTE3 TERM ATTRIBUTEA TERM BTID TERM CATEGORY TERM CLUSTID TERM CONFFLAG TERM DELDATE TERM DELFLAG TERM ID TERM 180506 TERM LASTFAULTTYPE TERM LASTSENTREDNUMBER TERM LASTTXDATE TERM LASTTXSEQ TERM LOCATION TERM TERM MRCBANKACCNO TERM MRCBANKID TERM NTCOLL TERM OPID TERM REDDATE TERM REDLENGTH TERM REDNUMBER TERM SERVICESTATUS TERM SWVERSION TERM TOPSWVESRION TERM TYPB TERM TYPEDATATRANSFER Null
50. L L L L L CAP FAX CAP NAME CAP STREET CAP SVCACCNO CAP SVCBANKID CAP TELEFON CAP ZIP Z L NOT NULL LL NOT NULL NOT NULL NULL NULL Fax number of System provider The name of the CA Provider Street part of the Address of the CA Provider Z Bank Account No of the CA Provider for service charges Service providers Bank for service charges The Telephone number of the CA Provider ZIP Code part of the Address of the CA Provider NIE 0 Table 6 5 Structure of table CA PROVIDER Table Name CA SESSION Description This table is used to keep the information about the database session for a particular STARCOIN instance Primary Key N A Foreign Key N A CAS_CAUSERID NOT NULL VARCHAR2 0 Cause of data manipulation viz Insert Update Delete CAS MODULENAME NOT NULL VARCHAR2 10 Name of the module Name CAS_OPERATIONDESC NULL VARCHAR2 100 Description of the data manipulation CAS_SESSIONID NOT NULL VARCHAR2 100 Session Id for a particular STARCOIN instance Table 6 6 Structure of table CA SESSION STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 Page 54 of 109 6 Appendices Table Name CA SYSLOG Description Primary Key N A Foreign Key N A FINAL CONFIDENTIAL This table is used to keep the log of possible insertion updating deletion in the database CSL CAUSERID NOT NULL VARCHAR2 20 Cause of data manipulation viz Insert Upd
51. L NULL NULL NULL NULL NULL NO NULL NULL NULL NO NULL NULL Table Name SYSREDLIST Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key Table 6 40 Structure of table SYSREDLIST STARCOIN C amp A System User Manual 25 05 99 Vol Page 77 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name SYSSVC Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key SYSSVC MAXCHRG NOT NULL NUMBER 10 Maximum service charge fixed N SYSSVC_MAXLIM NOT NULL MBER 10 Transaction amount from which maximum service charge fixed is taken U U SYSSVC MINCHRG NOT NULL NUMBER 10 Minimum service charge fixed NU U SYSSVC_MINLIM NOT NULL MBER 10 Transaction amount up to which minimum service charge fixed is taken SYSSVC RATE NOT NULL NUMBER S5 2 If the transaction amount is above SysSvc_MinLim and below SysSve the service charge is calculated upon this rate SYSSVC_TYPE NOT NULL NUMBER 2 Type of transaction the service charged is raised for load unload acc cash IEP ECH purchase Table 6 41 Structure of table SYSSVC Table Name SYSTKPAR Description This table is used to keep information on system parameters set up during installation time Primary Key N A For
52. L VARCHAR2 80 Error Warning Informative Message Table 6 31 Structure of table SYSADM_ERRORS STARCOIN C amp A System User Manual 25 05 99 Vol Page 73 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name SYSADM ITEMS Description This table is used to keep all the menu items of the application Primary Key ITEM ID Foreign Key N A Name ITEM_PROG_ID VARCHAR2 60 Customer Program IdMenu Path ITEM_TYPE NOT NULL CHAR 1 Menu Item Type Table 6 32 Structure of table SYSADM_ITEMS Table Name SYSADM_ROLES Description This table keeps role information for different users Primary Key ROLE ID Foreign Key N A Default 0 Flag to indicate whether the Role has been deleted Table 6 33 Structure of table SYSADM_ROLES Table Name SYSADM_ROLE_ITEMS Description This table keeps rolewise item information Primary Key RLITM_ITEMID RLITM_ROLEID Foreign Key RLITM_ITEMID SYSADM ITEMS ITEM ID RLITM_ROLEID SYSADM ROLES ROLE ID RLITM CREATED BY NOT NULL VARCHAR2 6 Role Item creation date RLITM CREATED DATE NOT NULL DATE User Id of the Role Item Creator RLITM ITEMID NOT NULL VARCHAR2 8 Unique Identifier for each Menu Item Id RLITM_ROLEID NOT NULL VARCHAR2 10 Unique Identifier for each Role Id Table 6 34 Structure of table SYSADM_ROLE_ITEMS Page 74 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL
53. LOADING else the Customer account No or Bank Cash Account No in case of LOADING DBADV_SVCACCNO NULL NUMBER 20 Service Charge Account No from which the amount is to be debited If bank is paying the charges this will be the bank service charge account no else this will be the customer Account number or the bank cash acc no DBADV_SVCCHARGE NULL NUMBER 10 Amount that has been calculated as the service charge If any for this customer card and for this advice DBADV_TERMID NOT NULL NUMBER S Unique identifier for the terminal executing the load unload transaction DBADV_TERMOPID NOT NULL NUMBER 10 Unique Terminal Operator Id which is equal to related Merchant identifier Mrc_Id or Bank identifier 100000 amp Bank_Id DBADV_TYPE NOT NULL NUMBER 2 Type to indicate whether it is fora LOADING 01 transaction or UNLOADING 02 transaction Table 6 13 Structure of table ADVICE Page 62 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name Description STLADVICE This table is used to keep ECH transaction records Primary Key ECHSTL NO Foreign Key ECHSTL AMT NOT NULL NUMBER 10 ECHSTL ARCHFLAG NOT NULL CHAR 1 ECHSTL_ATTRIBUTE1 NULL VARCHAR2 255 ECHSTL ATTRIBUTE2 VARCHAR2 255 ECHSTL ATTRIBUTE3 VARCHAR2 255 ECHSTL_ATTRIBUTE4 NULL VARCHAR2 255 ECHSTL_BANKCUSTID VARCHAR2 20 NUL NUL NUL NUL NUL
54. MBER 10 Total Purse Purchase amount IEPECH PURGEDLOADAMT NULL NUMBER 10 Total purged purse load amount N IEPECH PURGEDUNLOADAMT NULL NUMBER 10 Total Purged purse unload amount IEPECH TYPE NOT NULL VARCHAR2 3 Type indicating whether it is an IEP or ECH IEPECH UNLOADAMT NULL NUMBER 10 Total purse unload amount Table 6 21 Structure of table IEPECH PURGEDPURAMT NULL MBER 10 Total Purged Purchase amount of that purse STARCOIN C amp A System User Manual 25 05 99 Vol Page 67 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name IEP STLADVICE Description This table is used to keep summarised information on IEP Transactions Primary Key IEPSTL Foreign Key N A IEPSTL AMT NOT NULL NUMBER 10 Amount that has been transacted with the Merchant for this advice IEPSTL ARCHFLAG NOT NULL CHAR 1 IEP settlement archived confirmation Default N after archivation changed to Y IEPSTL MRCACCNO NOT NU MBER 20 Destination account where the money is to be credited Bank Account number of the Merchant IEPSTL MRCBIN NOT NU NUMBER 15 Merchant Bank Id for IEP settlement IEPSTL MRCID NOT NU NUMBER 20 Merchant identification number for this credit settlement Advice IEPSTL MRCNAME NOT NU VARCHAR2 30 Merchant Id for the Merchant whose credit settlement advice is being generated U U U U U A IEPSTL NC NULL UMBER 5 Terminal Card reconciliation count
55. NCT GDCARDPAR_PIEP GDCARDPAR_PPOS GDCARDPAR_PVERS GDCARDPAR_SECTORID GDCARDPAR_UAIEP Null NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL NOT NU NOT NU NOT NU NOT NU LL LL LL LL NOT NULL NOT NU NULL L LL NULL NULL NOT NU NOT NU OT NU OT NU OT NU OT NU OT NU NOT NU NOT NU iii oe LL Table 6 17 Structure of table GDCARDPAR VARCHAR2 4 FID of ICC file EF CARDCERT VARCHAR2 4 FID of ICC file EF STARCOIN VARCHAR2 2 Indicates for which transaction the Merchant Id card must be inserted VARCHAR2 2 Parameter indicates locking of the card NUMBER 5 Cardholder id sequence number for the current file NUMBER 3 Number of performed off line transactions Personalised with 00 MBER 10 Cumulated total off line amount personalised with 00 00 00 00 U U NU i sonali U i i NUMBER 2 Sector Identifier for the Bank not used in STARCOIN VARCHAR2 2 Activation status of an IEP Table Name GDCA_PARAMS Description This table is used to keep information on system parameters set up during installation time Primary Key N A Foreign Key N A GDPARAM ICCPERS NULL CHAR 1 Internally used to control Customer Card information Export GDPARAM PARAMI NOT NULL VARCHAR2 255 Important Parameter for System Operation Date when last purge database process has run GDPARAM PURGEDDATE NULL DATE STARCOIN C amp A S
56. No customer data is shown e For Single Customers e Either Enter valid Bank Id and Bank Customer Id fields or enter valid Bank Id and Bank A c No Press Tab Or Press the Search button Searchable fields are in Yellow legend Wildcarding may be used in the field List of Customers for whom Debit Advice has been raised but not yet exported will be displayed Press Ok in the List of Values for selecting a particular customer e Following Customer Information will be displayed on the screen Bank Id Bank Customer Id Bank A c No Customer Name Bank Name Bank BIN STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 5 Utilities FINAL CONFIDENTIAL e The Search button is disabled The Export button is enabled At this point pressing Clear button will clear the form without exporting the data to a flat file At this point pressing Close button will close the form without exporting the data to a flat file 5 2 2 Export Debit Advice e Press Export button The debit advice raised is exported to a flat file DAVDDMMY dat IEP ECH load unload settlement data in the Export Directory of the STARCOIN Server for a Single Customers or for All Customers as per option chosen The entire data from the debit advice table is dumped in the file 5 3 Generate export file of Settlement Advice e Access Path Utilities
57. OS ON Y v v 59PAN ld powr POOL ld power Y v v KM UPDATETK ENC KM PINRST KM ATM OFF KM POS OFF MM EA KM IEPP ON Y KM POS ON 5 KM IEPP OFF KM IEPL ON Y Y KM UPDATETK MAC KM IEPL OFF KM UPDATETK SIG ERR Y v Y Y Y Y Y SOWF DOWF SOWF Y KD PINRST KD ATM OFF KD UPDATETK MAC KD IEPL ON KM POS OFF KD UPDATETK SIG KD ATM ON KD IEPP ON KD UPDATETK ENC KD IEPL OFF POS ON KD IEPP OFF o key_der TREE_CRD flo STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 Figure 6 3 Key relations for KGG_CARDS Vol Page 101 of 109 FINAL CONFIDENTIAL 6 Appendices 6 4 3 KGG EXPIRY om KGG_EXPIRY DOWF v v KM GEN REHAB ICC KM GEN SRW v v 59PAN Id DOWF v v v v INVAL ICC KM REHAB ICC SRW KM INVAL KM SM MAC KM REHAB TK KM SM ENC KM S5 KM REGISTER KM S6 KM CREATE KM SWUPD MAC KM WRCREATEKEY KM RED MAC KM CE CCS KM TND ENC KM CE ENC KM TND MAC KM EXECUTE KM PIN PRES v v SOWF v v v KD INVAL ICC KD REHAB SRW KD INVAL TK KD SM MAC KD REHAB TK KD SM ENC KD S5 KD REGISTER KD S6 KD CREATE KD SWUPD MAC KD WRCREATEKEY KD RED MAC KD CE CCS KD TND ENC KD CE ENC KD TND MAC KD EXECUTE K
58. Payment is still allowed because especially due to the off line purchase terminals and irregular reconciliation purchase transactions may arrive for a certain amount of time after the expiry of the terminal card On the date of expiry of the terminal card of the purchase terminals further purchase transactions are automatically blocked by the terminal However transfer of data for purchases done before the expiry of the card can still be done These transferred data are accepted by the C amp A system During settlement only the files received until the deactivation offset days from expiry are settled Other transactions are recorded as critical and are not settled In the current implementation settlement of critical transactions are not possible Please note There is no automatic process generating a new generation of terminal cards after its expiry initiated by this state itself The process of generating a new cards is triggered from another screen table and may use the card status field to decide about replacing this card by a new one DEACTIVATED e Set Automatically after the deactivation offset days from expiry e Set Automatically if reason Alert is selected The card had been in state Restricted use with reason as Replaced until deactivation offset days from expiry No transactions are expected to arrive for clearing anymore Restrictions Transaction Allowed Table 1 5 Restrictions on Terminal Card Status DEAC
59. STARCOIN C amp A System User Manual Volume II of II Edition 25 05 1999 Author G amp D Status FINAL CONFIDENTIAL Version 2 0 I Revision 15 04 99 Giesecke amp Devrient GmbH Prinzregentenstr 159 Postfach 80 07 29 81607 M nchen Copyright 1999 rights reserved Giesecke amp Devrient GmbH Prinzregentenstr 159 Postfach 80 07 29 81607 M nchen Germany The information or material contained in this document is property of G amp D GAO and any recipient of this document shall not disclose or divulge directly or indirectly this document or the information or material contained herein without the prior written consent of G amp D GAO copyrights trademarks patents and other rights in connection herewith are expressly reserved to the Giesecke amp Devrient group of companies and no license is created hereby brand or product names mentioned are trademarks or registered trademarks of their respective holders Content Table of content 1 BANK MERCHANT TERMINAL amp TERMINAL CARD HANDLING PROCESS eere 2 IE INTRODUCTION cere Rene Nene d DNI 2 TAA Purpose orea EI 2 T2 Prerequisite s seen a RES NER ei e E dq eias E A 3 12 ISSUE TERMINAL CARDS REPRE UNTERE KE Rei ee eA e NSE EE RENE 3 1 21 Set Up A NeW 5 tee dt ee ee LE ge 3 1 2 2 Issue a Terminal Terminal Card to existi
60. TIVATED No transaction requests can be accepted anymore The service provider must have informed the merchants about the time after card RESTRICTED USE REPLACEMENT until it becomes useless STARCOIN C amp A System User Manual 25 05 99 Vol Page 13 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL If any tx arrive it may be important to receive the place of load unload payment as soon as possible to get hold of the fraud Please note There is no automatic deletion of DEACTIV ATED cards This command must be executed manually or by SQL statements SUMMARY Card state overview Reason NULL C amp A Re Lost Defect Re Alert Status superv turned Stolen placed NEW dq rd 7 active _ memucrp x s peactivaren x sd xm Table 1 6 Card status Overview Please note As to be seen in the table above card state is set by a certain process data entry NEW Personalisation ACTIVE or manually by an authorised user The respective list states is set accordingly by the C amp A system or can be set manually Coding of list status Red listed at the discretion of the system provider manually R Red listed automatically Status reason summary e Alert Terminal card is suspected known to be faked or able to corrupt the system in any way e C amp A superv
61. This table is used to keep terminal manufacturer s information Primary Key MANF_MANFNR Foreign Key N A Table 6 45 Structure of table TERM_MANF Table Name TRANSFER_FILES Description This table is used to keep Transfer File information Primary Key N A Foreign Key N A Transfer File archived confirmation Default N after archivation changed to Y TRANSFILE PSAM NOT NULL NUMBER 10 Terminal Card No as received in transfer file T NSFILE_STATUS NOT NULL NUMBER 1 File Processed status 0 Processing successful 1 Processing pending 2 Processing Error TRANSFILE_TERMINALID NOT NULL NUMBER 20 Terminal Id received as eight bytes in the transfer file header Table 6 46 Structure of table TRANSFER_FILES STARCOIN C amp A System User Manual 25 05 99 Vol Page 81 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name Description TRM CARD Primary Key Foreign Key This table is used to keep terminal card information TRMCARD PSAM TRMCARD TERMID TERMINAL TERM ID TRMCARD TERMOPID TERMINAL TERM OPID Name TRMCARD 59PANID TRMCARD ATTRIBUTEI TRMCARD ATTRIBUTE2 TRMCARD ATTRIBUTE3 TRMCARD ATTRIBUTEA TRMCARD CHECKBAK TRMCARD CHECKPIN TRMCARD DACTTK TRMCARD DELDATE TRMCARD DELFLAG TRMCARD DEXPTK TRMCARD IEPPOSSWITCH TRMCARD 180401 TRMCARD_ISO401_TKATM TRMCARD ISO401 TKPOS TRMCARD ISOSO6HDR TRMCARD 150512 TRMCARD ISSDATE
62. Transaction ECH 4 4 2 Load Unload transaction part Tx Date Date when the transaction was executed BT Id Identifier of the bank service terminal executing the load unload transaction Card No Unique customer card number No Unique number of the IEP or ECH payment application on the customer card Amount Loaded Unloaded amount Type Type of payment application IEP or ECH Reason Additional status information Context Type of transaction Load or Unload NTICC Customers card transaction counter Currency Currency code of transaction amount Advised Indicator if the transaction has already been settled 4 4 3 Purchase transaction ECH part Tx Date Date when the transaction was executed Terminal time Operator Id Unique identifier for the merchant Terminal Id Terminal serial number for that merchant Card No Unique customer card number ECH No Unique number of the ECH payment application on the customer card IEP purchases are cleared in pool so individual recorded transaction data are not displayed here NTICC Customers card transaction counter STARCOIN C amp A System User Manual 25 05 99 Vol Page 33 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports 4 4 4 Page 34 of 109 FINAL CONFIDENTIAL Settled Indicator if the transaction has already been settled Navigation At any point of time pressing Clear button clears the screen so that a
63. US RESTRICTED USE TABLE 1 5 RESTRICTIONS ON TERMINAL CARD STATUS DEACTIVATED TABLE 1 6 CARD STATUS OVERVIEW TABLE 3 1 SOURCE AND DESTINATION FOR SETTLEMENT TABLE 6 1 TABLE 6 2 TABLE 6 3 TABLE 6 4 TABLE 6 5 TABLE 6 6 TABLE 6 7 TABLE 6 8 TABLE 6 9 TABLE 6 10 TABLE 6 11 TABLE 6 12 TABLE 6 13 TABLE 6 14 TABLE 6 15 TABLE 6 16 TABLE 6 17 TABLE 6 18 TABLE 6 19 TABLE 6 20 TABLE 6 21 TABLE 6 22 TABLE 6 23 TABLE 6 24 TABLE 6 25 TABLE 6 26 TABLE 6 27 TABLE 6 28 TABLE 6 29 TABLE 6 30 TABLE 6 31 TABLE 6 32 TABLE 6 33 TABLE 6 34 TABLE 6 35 TABLE 6 36 TABLE 6 37 TABLE 6 38 TABLE 6 39 TABLE 6 40 TABLE 6 41 TABLE 6 42 TABLE 6 43 TABLE 6 44 TABLE 6 45 TABLE 6 46 TABLE 6 47 TABLE 6 48 STRUCTURE OF TABLE BANK STRUCTURE OF TABLE BANK POOL STRUCTURE OF TABLE CARD POOL STRUCTURE OF TABLE CA PROGRAM STRUCTURE OF TABLE CA PROVIDER STRUCTURE OF TABLE CA SESSION STRUCTURE OF TABLE SYSLOG STRUCTURE OF TABLE CUSTOMER STRUCTURE OF TABLE CUST CARD STRUCTURE OF TABLE CUST TRANSACTION STRUCTURE OF TABLE DBPOS ADVICE STRUCTURE OF TABLE DBPOS TRANSACTION STRUCTURE OF TABLE DB ADVICE STRUCTURE OF TABLE STLADVICE STRUCTURE OF TABLE GDAID STRUCTURE OF TABLE GDATR STRUCTURE OF TABLE GDCARDPAR STRUCTURE OF TABLE GDCA_PARAMS STRUCTURE OF TABLE GDSERV STRUCTURE OF TABLE GDSYSPAR STRUCTURE OF TABLE IEPECH STRUCTURE OF TABLE IEP STLADVICE
64. action Amount Total Purchase Transactions ECH and Total Purchase Amount ECH on a popup screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 39 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 7 2 4 7 3 4 7 4 Page 40 of 109 Note A message is shown in status bar if no data is fetched for IEP Pool Transaction and or ECH Transaction Terminal Card Information Part PSAM No Unique terminal card number Service PSAMIEP or BSTSAM NTTK Terminal card transaction counter Status Terminal card status ACTIVE List Status Terminal card list status IEP Pool Transaction part Transfer Date Date the transaction has been transferred to the C amp A System Pool Id Unique identifier of the pool Amount Transferred differential actual pool amount pool amount of last transfer pool amount of that transfer Settled Yes No An IEP Pool Transaction may not be settled because the settlement may not have run for that day or some of the transactions are critical because signature or other validations have failed Status Status indicates why the transactions have failed If settled 15 No and status is OK then these transactions will be settled later ECH Transaction part Transfer date Date the transaction has been transferred to the C amp A System Card No Unique customer card number ECH No Unique number of ECH payment applica
65. alid data in Merchant Id or enter valid data in Merchant Name and Merchant Id Searchable fields are in Yellow legend Wildcarding may be used in both of the fields e OR Press Search button for Merchant Id or Merchant Name A List of Values appears with list of Merchants After selecting the desired Merchant press OK button in the List of Values form to get a valid Merchant Information e Enter From Date and Date in DD MM YYYY format e Press Execute to fetch information on Payment Transaction for the selected merchant within the given range of From Date and To Date Merchant A c wise balance and service charge information are shown as Summary Information e Total Account Balance of the merchant and Total service charge paid by the merchant are shown as Summary Information 4 6 2 Payment Transactions part e Transaction Date amp Time Date when the transaction was executed e Terminal Id Unique identifier for the merchant Account No Merchant Bank s A c No e Type Type of payment application IEP or ECH or POS Purchase Amount Transaction amount e Merchant Spec TermlId Merchant Specific Terminal Id IEP ECH No Unique number of the ECH payment application on the customer card 4 6 3 Summary information part Merchant A c No Merchant s different bank A c No STARCOIN C amp A System User Manual 25 05 99 Vol Page
66. an scroll through Previous and Next buttons e Choose Card type Valid values are IEPPOS ECHPOS 5 and Depending on the card type selected Card details will be populated Also the PCT files required for personalisation will appear depending on the card type selected The version for the PCT file s is updateable Default value is 001 or the last here entered value This field must contain the version number of the current PCT file in use A PCT file Personalisation Control Table defines the personalisation structure for a card Please assure always to use the right version If the PCT file is updated a new version will be provided by G amp D Please make sure to delete the old version to avoid misuse or accidental usage STARCOIN C amp A System User Manual 25 05 99 Vol Page 19 of 109 Version 2 0 1 Revision 15 04 99 2 Personalisation Process FINAL CONFIDENTIAL 2 3 e Incase PCT files are encrypted the Encrypted field can be set e If Export button is pressed a confirmation message will appear stating that the card data are going to be exported On positive response to the confirmation a popup window will appear with the following fields 1 Card Number Currently in Progress Shows the Card Number which currently is being processed 2 Processing Logfile Name Shows the file name along with path where all the operation history are kept 3 Process In
67. ane mite ues 101 643 KGG EXPIRY ie Re E RS AERE OBERE ERI EN tr ENE RE HT ERU 102 6 3 APPENDIX H ABBREVIATIONS ee A x EE PR EE RETE see isos 103 6 6 APPENDIX I LIST OF TABLES eere E Ea ie ger edel bp ee Renee unt epe tenere Ee penser eese Pe per 104 APPENDIX J LIST OF FIGURES HERE eT RA DR seeds EIE ELE RENE ER ER ETE ERE Ue ER PER oan bese das 105 Page 4 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 Bank Merchant Terminal amp Terminal Card Handling Process 1 1 Introduction This section deals with the actual working methodology while dealing with Bank Merchant Terminal amp Terminal Card Handling Process e Maintenance of Merchant Information e Allocation of Terminals to Banks Merchants amp Issue Replacement of Terminal Cards to the allocated Terminals e Updating of Card Status of Issued Replaced Terminal Cards e Updating of Terminal Service Status amp Type of Fault 1 1 1 Purpose Issue Cards Replace Cards Update Card Status Update Terminal Update Merchant Page 2 of 109 This task serves any of following purposes Issue new Terminal Terminal Cards to an existing Bank Add a new Merchant allocate Terminal and Issue Terminal Cards Allocate new Terminal amp Issue Terminal Cards to an existing Merchant This task Replace
68. ard issued for the Not Applicable customer 316 WRN50001 The advice raised has not been Not Applicable exported Do you want to the STARCOIN C amp A System User Manual 25 05 99 Vol II Page 97 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL a RN WRNS50002 All the advices will be exported Not Applicable Do you want to continue WRN50003 All the advices for will be Not Applicable exported Do you want to continue WRN60001 Do you want to abandon this Not Applicable session WRN60002 Do you want to Clear the Form Not Applicable 321 WRN60003 Do you want to remove this Bank Not Applicable 317 318 319 320 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 WRN70001 WRN80052 WRN90001 WRN90002 WRN90003 WRN90004 WRN90005 WRN90009 WRN90015 WRN90016 WRN90017 WRN90020 WRN90050 WRN90051 WRN90052 WRN90055 Page 98 of 109 This Process Will Delete All Key Data and Install New LMK and Keys Do you really want to Export the Not Applicable file Do you want to clear the screen Not Applicable Do you want to abandon the Not Applicable change Do you really want to delete the Not Applicable Do you really want to reset the Not Applicable group information to the original values Do You Want To Delete Update TK Information For UCT Version
69. ard s status information is modified and the pop up window disappears In the initial screen cursor is set to the selected Card showing the modified status information If Cancel button is pressed pop up window disappears without any modification done Note If Clear button is pressed whenever possible all the information appeared will be lost and the screen will be initialised 1 2 5 Update Terminals e Access path Terminal Update Terminals 1 2 5 1 Retrieve the existing Terminal record On selection of this option from the menu item the corresponding form appears on the screen with the cursor positioned on Operator Id field and Bank terminal radio button on Select either Bank Terminal or Merchant Terminal e Either Enter a valid Operator id and press Tab to fetch the record on the screen e OR e Put the cursor on Operator Id at this stage Search button is on e Press the Search button a list of terminals will be displayed e Select a terminal and press button desired record is fetched onto the screen Page 16 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 2 5 2 Update Terminal record e Update the open fields as required e Press Save button to save the changes in the database Note If after data retrieval some change is made
70. ate Date ERR40018 IEPECH Activation Date should be IEPECH Activation Date 15 less than the equal to or after Card Effective Card effective date Date ERR40019 Activation Date should be If IEP ECH deactivation date is there an given whenever there is attempt is made to leave the IEP ECH Deactivation Date activation date ERR40020 IEPECH Deactivation Date should IEPECH Deactivation date is greater than be equal to or after Activation Date or equal to Activation date ERR40021 Deactivation Date should be Deactivation Date is greater than or before or equal IEPECH Expiry equal to IEP ECH Expiry Date Date and Clear button has been pressed 50 ERR40028 You cannot save a new Bank record An attempt is made to insert a new Bank to with corresponding BankPool a deleted Bank Pool deleted 5 ERR40029 Card Present For This Customer An attempt is made to delete a customer Cannot Delete Customer when the card is present Information 52 ERR40030 Card POS Limit must be more than Card POS Limit is entered less than 0 for 0 for Bank Pos Card Bank Pos Card STARCOIN C amp A System User Manual 25 05 99 Vol Page 85 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 53 ERR40031 IEPECH Card should have at least An IEPECH Card do not have an IEP and an IEP and an ECH purse an ECH purse 54 ERR40032 Bank Customer Id for the Bank When a duplicate Bank
71. ate Delete CSL_DATETIME NOT NULL NUMBER 14 Date and time of data manipulation CSL_MODULENAME NULL VARCHAR2 10 Name of the module CSL_NEWVALUE NULL VARCHAR2 600 New value of the affected record CSL_OLDVALUE NULL VARCHAR2 600 Old value of the affected record CSL_REMARK NULL VARCHAR2 100 Remark if any CSL_OPERATIONDESC NULL VARCHAR2 100 Description of the data manipulation CSL_REPORTFLAG NOT NULL NUMBER 1 Flag to indicate whether report has been generated for this entry CSL_SESSIONID NOT NULL VARCHAR2 100 Session Id for a particular STARCOIN instance CSL_TABLENAME NOT NULL VARCHAR2 30 Table on which data manipulation is done Table 6 7 Structure of table CA SYSLOG Table Name Description CUSTOMER Primary Key CUST_CUSTNR This table is used to keep Customer information Foreign Key CUST BANKID BANK BANK ID UST UST UST U CUST BANKCUSTID CUST BANKID CUST CITY CUST COUNTRY CUST DBPOSAMT C CUST DELFLAG CUST CUSTNR UST U U U U U U U U U U U CUST ZIP CUST PURGEDDBPOSAMT c Null T T T NOT NULL NOT NULL L L L L z z z LL Bank Account No of the Customer LL VARCHAR2 20 NOT NULL Issuing bank specific Customer Id Indispensable if no acc number name delivered by the bank NUMBER 4 Unique identifier for the customers corresponding bank NUMBER 20 U
72. can be replaced Red Listed RESTRICTED USE 5 Lost Stolen Neither If a Lost Stolen card 15 not red listed it can be replaced Red Listed RESTRICTED USE Returned Neither RESTRICTED A card is returned to the C amp A USE system only when the customer decides not to use the card anymore Hence it cannot be replaced Red Listed amp Neither RESTRICTED The C amp A system may set the Supervisor USE card to restricted use to restrict further load unload with the card Red Listed RESTRICTED Page 10 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL E GE This status cannot be updated USE manually These values are automatically set on the Expiry date of the card This card can be replaced DEACTIVATED Y On the deactivation date expiry date offset the card is automatically deactivated This card can be replaced Expired cards cannot be redlisted Table 1 1 Terminal card Replacement criteria e Select a Terminal Card record If the Card Status is RESTRICTED USE or DEACTIVATED the Card s Status Reason is not ALERT and List Status is not Red Listed Replace button is enabled i e the card is replaceable e Press Replace button A warning message pops up asking for user s confirmation for replacement f Yes button is chosen the existin
73. case of successful operation the field shows the corresponding information Otherwise the error will appear in this field 4 A progress bar giving pictorial representation of the progress of export process 5 If Start button is pressed the actual export process will start Once the process is complete the user can view print the process history via View Log button e Once the export process is complete the popup window disappears and the modified card information after export process will be fetched e If Clear button is pressed a confirmation message will appear in case any change is made to the screen e g any record is fetched otherwise the screen will be cleared without any message On positive response the screen will be cleared e If Close button is pressed a confirmation message will appear in case any change is made to the screen e g any record is fetched otherwise the screen will be closed without any message On positive response the screen will be closed Import Customer Card Personalisation confirmation file e Access path Import Personalisation Confirmation 2 3 1 Prerequisites The confirmation file must exist in the correct directory as defined in STARCOIN ini DATA_FILE_DIR lt path gt 2 3 2 Import confirmation file e Enter Confirmation date Either Press Import button to import Personalisation data for customer card data e Or Press Close button to return to ma
74. chant Information block A List of Values appears with list of Merchants After selecting the desired Merchant press button in the List of Values form to get a valid Merchant Information e Press Execute to fetch Terminal Card records in the Terminal Card Information block e Total No of New Cards Total No of Active Cards Total No of Restricted Use Cards and Total No of Deactivated Cards are shown as Summary Information 4 5 2 Terminal card information part Operator Id Unique identifier for the merchant e Cluster Id Group identifier for the specific terminal Terminal Id Terminal serial number for that merchant e Terminal Card No Unique number of the terminal card PSAM e Activation date Date of terminal card Personalisation e Expiry date Terminal card expiration date e NTTK Terminal card transaction counter e Service Whether the terminal card is of service PSAMIEP or BSTSAM e Status NEW ACTIVE etc e List Status Terminal card list status STARCOIN C amp A System User Manual 25 05 99 Vol Page 35 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 5 3 4 5 4 Page 36 of 109 Summary information part Total number of new cards Terminal cards of that specific merchant in state NEW started but not yet personalised Total number of active cards Terminal cards of that specific merchant in state ACTIVE To
75. d Now obsolete Bank BIN must be of six digit number Required only for Avers account checking scheme Range check of Bank account number required only for Avers account checking scheme 187 ERR90076 Bank A c Should be at least 6 Digit and Maximum 14 Digits 188 ERR90077 The Personalisation Export Process is being used by another user Try Later 189 ERR90078 Terminal Id cannot Exist Without During terminal information entry if an Operator Id attempt is made to leave operator id 190 ERR90079 Terminal Card Update Information For a particular terminal card update Already Exists For Version version the UCT text file already exists Concurrent users are trying to do the same operation ERR90080 No Customer Card Found For An attempt is made to update the Customer Updating card status for which updating is not required ERR90081 Invalid File Path Name Given File Path name does not exist ERR90082 Invalid File Format Invalid file format entered in the screen Check file format in the hint text ERR90083 File and Path Name Required File name not given but check box for archiving is checked ERR90084 Path name without file name given ERR90090 This is not a valid update depth Given Update Depth is not number ERR90091 Update depth not be below Given update depth is below default update depth in table sysredlist ERR90092 Update Depth required Update Depth field is null while executing query ERR9
76. e flag Default N Not archived T u u u pa 3 2 3 N N d d p T NULL N N d 3 3 2 E 2 ppp E ta Table 6 11 Structure of table DBPOS_ADVICE Page 60 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name Description DBPOS TRANSACTION This table is used to keep individual rec DBPOSTRAN NO Foreign Key DBPOSTRAN AC NULL NO E E E E NO DBPOSTRAN_ISO506 NOT NU DBPOSTRAN 150510 NOT NU DBPOSTRAN_ISOS11 NOT NULL DBPOSTRAN 150512 NOT NULL DBPOSTRAN NO NOT NULL DBPOSTRAN VKOFF NOT NULL DBPOSTRAN VKON NOT NULL L T NULL LL LL LL LL T NULL ii E LL LL LL LL LL LL LL LL Table 6 12 Structure of table DBPOS TRANSACTION STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 FINAL CONFIDENTIAL ords of Debit POS Transactions NUMBER 3 Action code of authorisation request from C amp A to Bank stored for logging NUMBER 2 Action Indicator of authorisation request of Terminal U Short identifier for card acceptor New definition PSAM 4 amp 8 Currency exponent and code as used in POS transaction NU U U U U U Default N Y transaction archived and can be purged Outstanding flag 0 Not out
77. e out from that screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 17 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL Note If after data retrieval some change is made and Clear or Close button is pressed the system will raise an alert for confirmation and will act accordingly Otherwise pressing of Clear or Close button without any change made will clear or close the screen respectively without asking for any confirmation 1 3 3 Delete Merchant 1 3 3 1 Retrieve the Existing Merchant Record e Either Enter a valid Merchant Id and press Tab to fetch the record on the screen e OR e Put the cursor on Merchant Id or Merchant Name At this stage Search button is on Press the Search button a List of Values containing the list of Merchants will be displayed Wildcarding is possible Select a Merchant record and press OK button e The desired record is fetched onto the screen 1 3 3 2 Delete Merchant Record Check the Deleted check box to delete a particular Merchant e Press Save button Note If at any point of time after making some changes Clear or Close button is pressed system will ask for a confirmation and will act accordingly Page 18 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 2 Personalisation Process FINAL CONFIDENTI
78. e terminal e g ICT 800 Characters with maximum length 30 Not mandatory Type of Data Transfer Enter 01 for via Transfer Card Transfer Laptop and 05 for on line transfer Mandatory Topical SW Version Identifier of the actual software version may be different to Loaded Terminal SW version Number Maximum length 4 Not mandatory STARCOIN C amp A System User Manual 25 05 99 Vol Page 5 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL Page 6 of 109 Bank Specific Terminal Id This value is personalised on the terminal card and can be used by the bank to identify the terminal because it also appears in the settlement data Characters with maximum length 8 Mandatory Red List Length Defining the maximum redlist length for a terminal Defined value for the ICT 800 is currently 4090 do not change Number Maximum length 8 Mandatory For Merchant Terminal Operator Id System specific identifier for the terminal operator here merchant Cluster Id The Cluster Id can be defined by the C amp A system provider to assign a terminal to a certain group For merchant terminals this field allows to define groups of merchants terminals e g according to ISO 8583 Annex A 2 where numbers for various businesses are defined Please note that 6010 is reserved for BST and 6011 for SST Number Maximum length 4 Mandatory field
79. ebit advice has not against transactions made by and all been raised advices have already been raised against those transactions 77 50009 settlement advice for for this An attempt is made to raise Settlement transfer date have already been Advice against transactions of xx since raised all advices have already been raised 78 ERR50010 There are no advices to be No advice for tt is available to export exported 79 ERR50011 There are no advices to be exported No advice for tt is available to export for ERR50012 advice sequence no exceeded When sequence no for advice of type tt Contact system administrator exceeds maximum limit 81 ERR50013 This a c no does not belong to this Incorrect a c no entered for a particular bank customer id bank customer id 82 ERR50014 settlement advice have been An attempt has been made to raise a raised settlement advice when all settlement advice has been raised 83 ERR50015 settlement advice for have An attempt has been made to raise a already been raised settlement advice when all settlement advice has been raised 84 ERR50016 There are no transactions made An attempt has been made to retrieve this transfer date transaction where none exist 85 ERR50017 There are no transactions on this An attempt has been made to retrieve transfer date transaction where none exist ERR50018 Export file for this date is already At
80. edure Note Before Inserting new Terminal Terminal Card for a Merchant user can update Merchant Details by pressing Details button on first block if Merchant Terminal is selected 1 2 2 Issue a Terminal Terminal Card to existing Merchant Bank 1 2 2 1 Retrieve the existing Merchant Bank record Page 4 of 109 Terminal Setup Merchant Terminal Cards Select either Bank for bank service terminals or Merchant for merchant terminals Enter either Merchant Bank Id or Merchant Bank Name fields searchable fields are in Yellow legend Wildcarding may be used in both of the fields to fetch the record Press Search button in the first block A list of values will appear from which a Merchant Bank name can be selected After selecting a record press Ok button of the list of values If you use wildcard or just initials in Merchant Bank Id or Merchant Bank Name fields and press the Search button the list of values appears from which a Merchant Bank Name can be selected Terminal amp Terminal Card details for the Merchant Bank will be displayed on the screen STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 2 2 2 Issue New Terminal Terminal Card Allows to enter all relevant data to set up a terminal as well as the related terminal card e Press New button on t
81. een between 139 ERR90028 Password Expired Password Expires 140 ERR90029 Enter valid old password Invalid old password entry 141 ERR90030 User Id must contain at least one An attempt is made to leave the user is as character null 142 ERR90031 Enter Valid Terminal Information Entered terminal information is invalid in this context 143 ERR90032 Enter valid new password Invalid new password entry 144 ERR90033 There is at least one User assigned Attempt is made to delete a role while a to this Role So Cannot delete Role user still holds that 145 ERR90034 You cannot add Menu Items to a Attempt is made to add menu items to a deleted Role deleted role 146 ERR90035 There is no Role associated with Attempt is made to insert a new role the item s Cannot Save without any item attached 147 ERR90036 You cannot update any attributes of Attempt is made to update contents of a a deleted Role deleted role 148 ERR90037 Password not confirmed Cannot Attempt is made to save without password save confirmation 149 ERR90038 Password expiry date should be Password Expiry date is less than lt date gt more than 150 ERR90039 This Error ID is already existing Attempt is made to enter new error with Re enter new Error Id existing error id 151 ERR90040 This Role is already existing Attempt is made to enter new Role with Please enter new Role Id existing Role Id 152 ERR90041 Enter valid value Invalid
82. eign Key N A NOT NUL Bitmap indicating necessary checks of bank authorisation card L SYSTKPAR_CHECKPIN NOT NULL VARCHAR2 8 Bitmap indicating necessary checks of bank authorisation card PIN L SYSTKPAR_DEXPTK NOT NUL DATE Date on which current generation of terminal cards expires SYSTKPAR IEPRECORDING NOT NULL NUMBER 1 Flag indicating IEP Recording N SYSTKPAR_KEY VERSION NOT NULL MBER 3 Showing the topical version of the terminal cards version dependent keys SYSTKPAR_SHOWBALANCE NOT NULL NUMBER 3 Show Balance Indicator SYSTKPAR_SIGNCHECKTK NOT NULL NUMBER 3 Signature check by Terminal Card SYSTKPAR_SINGLETXLIMIT NOT NULL NUMBER 10 Individual Transaction Recording Limit for IEP purchase transactions SYSTKPAR_SINGLETXPROB NOT NULL NUMBER 3 Individual Transaction Recording Ratio for IEP purchase transactions 255 100 Table 6 42 Structure of table SYSTKPAR U U U U U Page 78 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name SYSTKUPD Description This table is used to keep Terminal Card Update Information Primary Key SYSTKUPD_UPDNO SYSTKUPD UCTVER Foreign Key Name SYSTKUPD CLUSTID MBER 4 Cluster Id identifying a group of terminals of which the terminal cards shall be updated A TE SYSTKUPD DESC VARCHAR2 255 Short description of what is updated with this command N NULL SYSTKUPD_OP
83. er NI U U U U U U 2 2 Clerc rye N IE NUMBERS IEPSTL_NO NOT NULL NUMBER Unique Number identifying for each Credit settlement Advice IEPSTL SRCPOOLACCNO NOT NULL NUMBER 20 Source account from where the money is to be Debited Bank Pool Account number of the customer Bank IEPSTL SRCPOOLBIN NOT NULL NUMBER 15 Bank Id number from where the money is to be Debited BIN of Bank Pool of the customer bank IEPSTL SVCACCNO NULL NUMBER 20 Number of the account which is debited with the service charge IEPSTL SVCBIN NULL NUMBER 15 Identification number of the bank which service account is debited IEPSTL SVCCHARGE NULL NUMBER 10 Amount that has been calculated as the service charge for this Merchant and for this advice Page 68 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table 6 22 Structure of table IEP STLADVICE Table Name KEY VERSION Description This table keeps information on Keys Primary Key Foreign Key N A u p Z 2 T Cic c T i c L LL LL LL LL L i 2 2 2 L T u L L GG c Li Li KEY PURPOSE VARCHAR2 8 Purpose of the Key KEY_TYPE L VARCHAR2 2 Indicates the type of key KEY_VERSION NULL NUMBER 3 Version of the key Table 6 23 Structure of table KEY_VERSION i E STARCOIN C amp A System User Manual 25 05 99 Vol II
84. er of the Merchant Unique Number identifying for each Credit Settlement Advice The corresponding Purchase transaction for which the Advice is being raised Number of the account which is debited with the service account Identification number of the bank which is debited with the service account Amount that has been calculated as the service charge for this advice Unique identifier for a terminal Unique Terminal Operator Id which is equal to related Merchant identifier Id or Bank identifier 100000 amp Bank Id Vol Page 63 of 109 6 Appendices FINAL CONFIDENTIAL Table Name GDAID Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key GDAID AIDTKATM GDAID AIDTKIEPL GDAID AIDICCRFU NOTNULL VARCHAR2 16 RFU Application identifier for ICC NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL OT NULL GDAID_ATTRIBUTE3 NULL VARCHAR2 255 GDAID_ATTRIBUTE4 NULL VARCHAR2 255 Table 6 15 Structure of table GDAID Table Name GDATR Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key N A Fame GDATR_ATRICCBANK NOT NULL VARCHAR2 30 Data returned in the cards answer to reset Bank authorisation card GDATR NOT NULL VARCHAR2 30 Data returned in the cards answer to rese
85. erchant Bank Id or Merchant Bank Name fields and press the Search button the List of values appears from which a Merchant Bank Name can be selected e Terminal amp Terminal Card details for the Merchant Bank will be displayed on the screen 1 2 4 2 Update Card Status A terminal card may go through different states during its life cycle Each state leads to the change of card status Figure below shows the state transitions during the life cycle of a terminal card On Personalisation Response DEACTIVATED Figure 1 1 State transition for Terminal Card Status STARCOIN C amp A System User Manual 25 05 99 Vol Page 15 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL e Select a Terminal Card If the Card s Status is Update button is enabled On pressing of update button a pop up window appears containing card s e Status Card status will be displayed e g RESTRICTED USE DEACTIVATED etc e Status Reason List Box showing the possible status reasons e g Defect Alert Bank Request etc e ist Status List Box having two possible options i e Neither and Red Listed e Status Date When was the terminal card set to this status Once the Status Reason List Status is selected card s status is automatically set Status Date is set to current date e On pressing of OK button in that pop up window the selected C
86. g card will be replaced by a new one having the card s status as New Replace button is however disabled as the newly replaced card is selected and the Issue button is enabled A message will pop up stating the completion of replacement e If button is opted for the selected card s status remains unchanged and the replacement process is abandoned e To issue the replaced card press Issue button to invoke a new screen containing e Merchant Bank Name e Operator Id e Term Id e Cluster Id e PSAM Card Type e Enter values for e Version The version number 001 or the last here entered value appears on the screen This version number should be same as the PCT version The File Name will appear automatically To use an encrypted PCT file click on the Use Encrypted File check box Either Press Personalise button to personalise and issue cards The data is stored in the card inserted A Personalisation log file is generated in the PCT directory of the client named PSAM No in Hex gt Press Cancel button to return to the previous screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 11 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 2 4 Update a Terminal Card Status e Access path Terminal Update Card Status The Terminal card through its life cycle can go through 5 different states from the time i
87. gn Key CUSTTRANS_ATTRIBUTE2 VARCHAR2 255 CUSTTRANS_ATTRIBUTE3 VARCHAR2 255 CUSTTRANS_ATTRIBUTE4 VARCHAR2 255 CUSTTRANS_BTID NOT NULL NUMBER 6 CU STTRANS CARDNRI NOT NULL NUMBER 20 NOT NULL NUMBER 20 CUSTTRANS_CCICC NULL VARCHAR2 4 CUSTTRANS_CCTK NULL VARCHAR2 4 CUSTTRANS_DBADVNO NULL NUMBER CUSTTRANS_NO U U 19 CUSTTRANS NTICCI NUMBER 5 NU U U U L L L L L L STTRANS_CARDNR2 CUSTTRANS NTICC2 NOTNULL MBER 5 CUSTTRANS NTTK NUMBER 10 CU N STTRANS OUTSTFLAG NULL MBER 1 CUSTTRANS PARAMI NULL VARCHAR2 255 CUSTTRANS_POOLID NOT NULL NUMBER S CUSTTRANS_PPIEP NOT NULL NUMBER 6 CUSTTRANS_PSAM NOT NULL NUMBER 10 CUSTTRANS REASON NOT NULL NUMBER 2 U U U CUSTTRANS_SVCCHARGE NULL NUMBER 10 U U U L L L L L L NULL NULL NULL NULL NULL NULL T NULL NULL NULL NULL NOT NOT NOT NOT NOT NOT NO NOT NOT NOT CUSTTRANS_TE NULL NUMBER 2 CUSTTRANS_TRANSCONTEXT NOT NULL NUMBER 2 CUSTTRANS_TXSTATUSCODE NULL NUMBER 3 CUSTTRANS_TYPE NOT NULL NUMBER 2 Page 58 of 109 FINAL CONFIDENTIAL This table is used to keep summarised information on Customer Transaction records Action code of authorisation request from C amp A to Bank stored for logging Action Indicator of authorisation request of Terminal Customer transaction archived confirmation Default N after
88. he Key s are Successfully Not Applicable Deleted 274 INF80001 Record s successfully imported Not Applicable 275 INF80002 Enter Proper Bank Information Not Applicable 276 INF80053 No Card Information to be Not Applicable Exported 279 INF90003 Archiving of Transactions is Not Applicable partially successful 280 INF90003 All non issued card s issued Not Applicable 281 INF90003 Card Issued Not Applicable 282 INF90004 Archiving of Transactions is Not Applicable successful 283 INF90005 Purging of Archived Transactions Not Applicable partially successful 284 INF90006 Purging of Archived Transactions Not Applicable Successful 285 INF90007 No Transactions available for Not Applicable Purging 286 INF90008 No Transactions available for Not Applicable Archiving 287 INF90009 No Transactions exist for the Not Applicable entered period 289 INF90011 Purging of System Log records Not Applicable successful 290 INF90012 No System Log records available Not Applicable for purging 291 INF90013 New Redlist generated successfully Not Applicable 292 INF90014 Terminal Card Update Information Not Applicable Already Deleted Cannot Update Page 96 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 293 INF90014 Archiving and Purging Redlist Not Applicable Data 294 INF90014 Purging Redlist Data without No
89. he Terminal Block of the screen e You get a new screen for entering Terminal as well as Terminal Card details Terminal section For Bank Terminal Operator Id System specific identifier for the terminal operator here bank Cluster Id For Bank service terminals only the id for BST or SST can be selected Terminal Id Terminal serial number for that bank merchant defined by the C amp A system Terminal Manufacturer No Identifier for the terminal manufacturer defined by the C amp A system Enter a valid data or press Search button and select a valid data from list of values Terminal Category The terminal is either a terminal Terminal Service Status Terminals can be ACTIVE Terminal is in operational mode UNDER REPAIR Terminal currently out of service SHUTDOWN Terminal not used anymore The Terminal Service Status can be set via Terminal Update Terminals Bank Terminal Id Specific identifier of a bank terminal defined by the C amp A system Loaded Terminal SW Version Giving the software version which is actually loaded into that terminal Number Maximum length 4 Not mandatory Last Fault Type Last fault which occurred on that terminal Number Maximum length 2 Not mandatory Terminal Location C amp A specific identifier of terminal location Characters with maximum length 30 Not mandatory Terminal Model Type Identifier for the hardware type of th
90. here is an additional settlement feature for Debit POS transactions As far as the settlement of such transactions are concerned it is exactly similar to that of a ECH Purchase transaction 3 1 1 Prerequisites e For Debit Advice Load unload transaction must have been executed For Settlement Advice IEP ECH purchases must have been transferred to the C amp A System e Please note Before the settlement advice can be generated the transfer data must have been read to the database This happens daily at the time defined in System gt Set up gt System Init gt Settlement Bank Settlement Time The correctness of the transfer data can be checked in the log file directory in file Of lt date gt dat while date is the actual system date Page 24 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL 3 2 Generate Debit Advice for Load Unload Tx e Access Path Settlement Debit Advice 3 2 1 1 Retrieve Existing Customer Transaction Records e Select either the Single Customer or All Customer option e For All Customer e Customers who have confirmed transactions for which debit advice has not been raised is shown with the following information Bank Id Bank Customer Id Bank A c No Customer Name Bank Name Bank BIN Total Load Amount Total Unload Amount e For each Customer Information retrieved Customer T
91. hown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report can sent to personal mail account e Close Closes the previewer screen e New Creates another copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 7 Terminal Transaction e Access Path Queries Reports Terminal transaction List of transferred transactions within a certain period for one or all terminals 4 7 1 Retrieve the records e Select Option for Single Terminal or All Terminals e Enter From Date and To Date in DD MM YYYY format e For Single Terminal Press Tab to place the cursor on Operator Id field At this stage Search button is enabled Either Enter valid data in Operator Id Cluster Id and Terminal Id Searchable fields are in Yellow legend Wildcarding may be used in both of the fields OR Press Search button in Terminal Information block A List of Values appears with list of Terminal Information After selecting the desired Information press OK button in the List of Values form to get a valid Terminal Information Press Execute to fetch all Terminal Card records on the scree
92. ildcarding may be used in both of the fields e OR Press Search button in Customer Bank Information block A List of Values appears with list of Customer Information After selecting the desired Information press OK button in the List of Values form to get a valid Customer Bank Information e Press Execute to fetch Load Unload Purchase Transactions on the main screen within the given range of From Date and To Date e For All Customer e Press Execute to fetch all existing records on the main screen within the given range of From Date and To Date e You can navigate from one record to another of Customer Bank Information by pressing the Prev and Next button The corresponding data for Load Unload Transaction if any and Purchase Transaction ECH if any is fetched in the corresponding blocks Page 32 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL If any data is fetched for Load Unload Transaction or Purchase Transaction ECH or both press Summary button to get Total Loading Unloading Transactions Total Loading Unloading Amount Total Purchase Transactions ECH and Total Purchase Amount ECH on a popup screen Note A message is shown in status bar if no data is fetched for Load Unload Transaction and or Purchase
93. in menu Note At any point of time you can press the Clear button to clear the screen On successful import a screen shows the number of imported and rejected confirmations Number of successful Confirmations These cards have been successfully personalised and set to state ACTIVE Page 20 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 2 Personalisation Process FINAL CONFIDENTIAL Number of erroneous Confirmations The card could not be personalised for technical reasons In this case the Personalisation machine rejects the card and tries to personalise the data on the next card in the stack This number gives an information how many cards have been rejected but the Personalisation nevertheless was executed on another card Number of redundant Confirmations rejected For these cards a Personalisation confirmation was already successfully done and the cards have been personalised a second time Check the personalised cards on double issued ones and delete one of them e If double cards are existing in one payment system the consistency of the database and especially the payment data is destroyed This is always an indicator for the existence of counterfeit cards STARCOIN C amp A System User Manual 25 05 99 Vol Page 21 of 109 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL 3 Settlement Process 3 1 Introduction Settlement process involves e Generation
94. information Primary Key MRCPOOL MRCID MRCPOOL PSAM MRCPOOL POOLID Foreign Key MRCPOOL MRCID MERCHANT MRC ID MRCPOOL PSAM TRM CARD TRMCARD PSAM MRCPOOL POOLID BANK POOL BANKPOOL POOLID anc MRCPOOL LASTSTLAMT NULL MBER 10 Total amount in the pool that was last used for settlement advices N MRCPOOL MRCID NOT NULL NUMBER 20 Unique Identifier for the Merchant associated with the pool number N U U MRCPOOL POOLID NOT NULL UMBER 5 Unique identifier for each Merchant pool U MRCPOOL_PSAM NOT NULL NUMBER 10 Terminal card number of merchant terminal on which these pool amounts are settled MRCPOOL_TM NULL NUMBER 15 Current Cumulative amount for the Merchant in that pool Table 6 26 Structure of table MRC_POOL Table Name PENDING_NC Description This table is used to keep information on pending transaction records Primary Key N A Foreign Key N A Name PENDNC_NC NOT NULL NUMBER S NC of the transfer file which is pending and for which resend request has been sent PENDNC_PSAM NOT NULL NUMBER 10 Transfer File PSAM for which NCs are pending and resend request has been sent PENDNC_TERMINALID NOT NULL NUMBER 20 Transfer File Terminal Id for which NCs are pending and resend request has been sent Table 6 27 Structure of table PENDING_NC STARCOIN C amp A System User Manual 25 05 99 Vol Page 71 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name Descri
95. ingle tx record for this IEP transaction If this parameter is not equal 0 and Single Tx Prob is below the accounting for IEP transactions is deactivated and can not be enabled again Press button to come back to the original calling screen after inserting a new Terminal and Terminal Card fatany point of time after making some changes if Clear or Close button is pressed system will ask for a confirmation and will act accordingly 1 2 2 3 Enter some more Terminal Terminal Card e Press New button in the Terminal block which will take you to the same screen where you can enter one new Terminal Terminal Card details 1 2 2 4 Issue the existing new Terminal Card Press the button right in the Terminal section of the terminal card you want to personalise and the Issue button is activated The status of the terminal card to be personalised must always be NEW otherwise the card has already been personalised e Press Issue button to invoke a new screen displaying Merchant Bank Name Operator Id Term Id Cluster Id PSAM Card Type Pilot Id e Enter values for Page 8 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL e Version The version number 001 or the last here entered value appears on the screen This version number must be same
96. ision 15 04 99 6 Appendices FINAL CONFIDENTIAL EJ 22 than or equal to date less than a specific date ERR20012 Activation Date should be less An attempt is made to enter the activation than or equal to date greater than a specific date 10 ERR20013 Terminal Service Status cannot An attempt is made to keep terminal service NULL status as null 11 ERR20014 Enter Valid Merchant Bank Id Given Merchant Bank Id is not valid in this context 12 ERR20015 Cluster Id For Merchant Terminal Cluster Id for Merchant Terminal has been cannot be 6010 or 6011 entered as 6010 or 6011 13 ERR20016 Terminal cannot have more than An attempt has been made to enter more ONE card each of same service than one card for a terminal having same service 14 ERR20017 Valid values are 01 and 02 Value entered for Type of Data Transfer is not O1 or 02 15 ERR20018 Active Trm Trm Cards Present An attempt is made to delete merchant For This Merchant Cannot Delete information having some terminal issued to Merchant Info that merchant and terminal terminal card status is active 16 ERR20020 Terminal Card is not Deactivated Terminal is attempted to shut down when Terminal cannot be made corresponding Terminal Card is not Shutdown deactivated 17 ERR20021 Terminal Card Status is not present Terminal is attempted to shut down when Terminal cannot be made corresponding Terminal Card Status is not Shutdown entered ERR20022 Manufacturer Id not
97. isor The C amp A supervisor may set a card to certain state if it seems necessary from security or system point of view e g card suspected to be faked e Defect The merchant reports a defect of his card to the service provider who informs the C amp A system and sends the card there for testing e Lost Stolen The merchant reports a loss or theft of his card to the service provider who must inform the C amp A system at once If available the date time of loss theft need to be reported too Replacement The terminal card has expired and is replaced in the normal card live cycle The process of generating a new set of cards is initiated from an extra screen Returned The merchant returns his card to the service provider for any reason and the bank must inform the C amp A system phone fax letter Page 14 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 2 4 1 Retrieve the Existing Terminal Record e Enter either Merchant Bank Id or Merchant Bank Name fields Searchable fields are in Yellow legend Wildcarding may be used in both of the fields to fetch the record e Press Search button in the first block A List of Values will appear from which a Merchant Bank Name can be selected After selecting a record press Ok button of the List of Values If you use wildcard or just initials in M
98. minal Card of Not Applicable Version 2 2 Or Higher and Press OK 238 INF40008 Personalisation Of Terminal Card Not Applicable Successfully Completed 239 INF40010 Personalisation of Cards has been Not Applicable successful 240 INF40030 Card is replaced Not Applicable 241 INF40035 No Bank information exists Not Applicable INF40036 No Cards to Export Not Applicable Page 94 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 243 INF40037 Please Remove Card And Insert Not Applicable Terminal Card of Version V2 2 or Later 244 INF50001 Debit Advice raised Not Applicable 245 INF50002 File successfully exported Not Applicable E ae Debit Advice table Not Ir T 247 INFSO004 Settlement Advice raised Advice raised Not Not Applicable si INF50005 ECH Settlement Advice table Not Applicable updated 249 INF50006 IEP Settlement Advice table Not Applicable updated 250 INF60001 Has Cannot Detach Bank From Not Applicable The Pool 251 INF60002 Pool Id Is Not Null Cannot Not Applicable Generate New Pool 252 INF60003 Customer Is Attached To This Not Applicable Bank Cannot Delete Bank 253 INF60004 Merchant Is Attached To This Not Applicable Bank Cannot Delete Bank 254 INF60005 Bank Terminal Is Present Cannot Not Applicable Delete Bank 255 INF60006 This Bank Is The Pool Holding Not Applicable Bank
99. mpted to modify when card with this service code exists card exists for that service code 177 ERR90066 This application can not run in Attempt is made to run a form from stand alone mode Designer mode and not from menu 178 ERR90067 No of Service Types for should No of Service Types entered is not multiple be multiples of three of three ERR90068 Invalid Service Type entered Invalid Service Type entered 180 ERR90069 Enter unique value for Service Duplicate value for service type is entered Type corresponding to each for different service category Service Category ERR90070 Enter valid Confirm Password Invalid Confirm Password entry STARCOIN C amp A System User Manual 25 05 99 Vol Page 91 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 182 ERR90071 Please enter correct password for Incorrect password for confirmation is confirmation entered 183 ERR90072 IEP ECH Expiry Date must be same as Customer Card Expiry Date ERR90073 Minimum Limit Minimum Charge and Maximum Limit Not Allowed for IEP Purchase ERR90074 Settlement of Transactions Pending Cannot Change Service Charge ERR90075 Bank BIN Must Be of 6 Digit Number Entered IEP ECH Expiry Date is not same as Customer Card Expiry Date Entry of Minimum Limit Minimum Charge and Maximum limit Maximum charge not allowed for IEP transactions Service charge schemes cannot be changed if there are transactions pending to be cleare
100. n within the given range of From Date and To Date For each Terminal Card Information data one or more IEP Pool Transaction and or ECH Transaction records are fetched on the screen Navigate to the Terminal Card Information block Press Up Arrow and L Down Arrow to navigate between different records in the block The corresponding IEP Pool Transaction and or ECH Transaction records are shown e For All Terminals Press Execute to fetch all Terminal Information Terminal Card Information records related to the Terminal amp Pool Transaction and or Transaction records related to the Terminal Card on the screen within the given range of From Date and To Date You can navigate from one record to another of Terminal Information by pressing the Prev and Next button The corresponding data for Terminal Card Information is fetched in the corresponding block For each Terminal Card Information data you get several Pool Transaction and or ECH Transaction data Navigate to the Terminal Card Information block Press T Up Arrow and Down Arrow to navigate between different records in the block The corresponding Pool Transaction and ECH Transaction data are shown e Press Summary button to get Total Pool Transactions Total Pool Trans
101. nal Number Maximum length 2 Not mandatory Terminal Location C amp A specific identifier of terminal location Characters with maximum length 30 Not mandatory Terminal Model Type Identifier for the hardware type of the terminal e g ICT 800 Characters with maximum length 30 Not mandatory Type of Data Transfer Enter 01 for via Transfer Card Transfer Laptop and 05 for on line transfer Mandatory Topical SW Version Identifier of the actual software version may be different to Loaded Terminal SW version Number Maximum length 4 Not mandatory Merchant Specific Terminal Id This value is personalised on the terminal card and can be used by the merchant to identify the terminal because it also appears in the settlement data Characters with maximum length 8 Mandatory Red List Length Defining the maximum redlist length for a terminal Defined value for the ICT 800 is currently 4090 do not change Number Maximum length 8 Mandatory e Terminal Card section Service Identifier which payment functionality is supported by the terminal card PSAM_V2 IEP ECH POS purchases BSTSAM V2 IEP ECH POS bank terminal functions PSAMIEP IEP ECH purchases BSTIEP IEP ECH bank terminal functions BSTPOS POS bank terminal functions Terminal Card Number Serial number of the terminal card PSAM defined by the C amp A system Expiry Date Terminal card PSAM date of expiry as defined in the system ini
102. new query can be fired depending on option chosen At any point of time pressing Close button closes the form To get report of the data retrieved for Single Customer or All Customer press Print button after query has been executed A report previewer appears on the screen with following buttons on top Takes to previous page Next Takes to next page First Takes to the first page Last Takes to the last page Page Takes to page no entered in the box next to the button Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations The report can sent to personal mail account Close Closes the previewer screen New Creates another copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 5 Terminal Card e Access Path Queries Reports Terminal card Displays the vital terminal data of all terminals of one merchant 4 5 1 Retrieve the records e Either Enter valid data in Merchant Id or enter valid data in Merchant Name and Merchant Id Searchable fields are in Yellow legend Wildcarding may be used in both of the fields e OR Press Search button in Mer
103. ng Merchant 4 1 2 3 Replace Terminal Gard nsn re lon eumd eb tute ee e 10 1 24 Update a Terminal e Ye HE REO EP ERI IE ERR 12 1 2 5 Update Terminals Lease pee ape eo FO cR eMe eg Ote ene eh oa Ete ye ee Ee 16 1 3 UPDATE DEEETE MERCHANTS or ED P ER v AERE Errem 17 434 Update Merchant Informationen s s hae aee e e et ERU Rede 17 1 3 2 Update Merchant Record 3 edic e b ve e ode tue Hle b Ru eae ie Pra ue pe ppt 17 1 3 3 Delete Merchant i e ie ete Eee dee 18 2 5 19 2 p bent ERR RO ERREUR GRE GREEN RR 19 2 2 EXPORT CUSTOMER CARD DATA e e REC tin Mere e torte Pre store en 19 2 24 Prerequisites s e a ege meae EN deeeicipesdatadatencet pagent e 19 2 2 2 Export of personalisation data 3 ig ie dte ad esie ui tereti ei bude wads Re ver tee eret e Ree 19 2 3 IMPORT CUSTOMER CARD PERSONALISATION CONFIRMATION 20 2 93 41 PrerequisiteS oie t E RR i N E a EEEE e ro Er ere tte D e d ere e ee ed 20 2 9 2 Import confirmation tree este reete tte We dee 20 5 ette 2
104. ng fields Terminal Id Cluster Id Card Acceptor Id Amount For each Terminal Transactions Details retrieved Terminal Card Transaction Details are shown on the screen displaying the following fields Terminal Card No Amount For each Terminal Card Transactions Details retrieved Pool Transaction Details are shown on the screen displaying the following fields Pool Id Amount Click ECH Tx to view ECH Transaction Details For each Terminal Card Transactions Details retrieved ECH Transaction Details are shown on the screen displaying the following fields Tx No Amount Click POS Tx to view Debit POS Transaction Details For each Terminal Card Transactions Details retrieved Debit POS Transaction Details are shown on the screen displaying the following fields Tx No Amount Click Pool Tx to view Pool Transaction Details STARCOIN C amp A System User Manual 25 05 99 Vol Page 27 of 109 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL e The Search and Export buttons are disabled The Details Next disabled when at last record Prev disabled when at first record and Advice buttons are enabled e At this point of time you can see the details of a particular merchant by pressing the Details button e You can navigate between various records of merchant and their corresponding transaction details by pressing
105. nges to Save An attempt is made to save changes when no change is made 125 ERR90014 Datafile Directory not specified in Datafile Directory not specified in Parameter Parameter 126 ERR90015 Expiry Date Specific Keys not During Key management operation if the Loaded keys of proper expiry date is not loaded 127 ERR90016 Cannot Open UCT Text File If the file corresponding to this operation does not exists 128 ERR90017 All mandatory fields not entered Attempt is made to save without entering Cannot save some or all of the fields ERR90018 Unable to Write in File Unable to create the flat file to create the flat file ERR90020 Enter User Id without spaces in User Id entered with space s in between between ERR90021 Password does not match Re enter Invalid Password entry ERR90022 Duplicate User Id Duplicate User Id entry 134 ERR90023 Enter password without spaces in Password entered with spaces in between between 135 ERR90024 Password not entered Cannot save Attempt is made to save keeping password form blank ERR90025 There should be at least one item Attempt is made to either delete all items STARCOIN C amp A System User Manual 25 05 99 Vol Page 89 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Jace to he Roe ERR90026 Password Expired Cannot Login Password expires Login denied 138 ERR90027 Enter Role Id without spaces in Role Id entered with spaces in betw
106. nique identifier for each Customer C amp A system specific LL VARCHAR2 30 The City part of Address of the customer LL VARCHAR2 30 Country where customer is living LL DATE Customer Deleted Date L First name of the customer L Last Date of Updating of Customer s Authorised Load Amount LL NUMBER 10 Total DBPOS transaction amount Table 6 8 Structure of table CUSTOMER STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 L GG GG GG GG UL z z z LL Total service charge paid z z L VARCHAR2 30 The ZIP Code part of Address of the customer Vol Page 55 of 109 6 Appendices Table Name CUST CARD Description This table is used to keep Customer s Card information Primary Key CUSTCARD CARDNR Foreign Key CUSTCARD CUSTNR CUSTOMER CUST CUSTNR FINAL CONFIDENTIAL CUSTCARD ATTRIBUTEA NULL CUSTCARD AWS NOT NULL CUSTCARD CARDNR NOT NULL CUSTCARD CUSTNR NOT NULL CUSTCARD DELDATE NULL CUSTCARD DELFLAG NOT NU CUSTCARD DUPLNUM NOT NU CUSTCARD ISO305 NOT NU CUSTCARD_ISO306 NULL CUSTCARD_ISO307 NOT NU CUSTCARD_ISO309 NULL CUSTCARD_LISTSTATUS NOT NULL CUSTCARD_LKZ NOT NULL CUSTCARD_NEWCARDNR NULL CUSTCARD_NTICC NULL Page 56 of 109 i 2 pa pa p E E E E VARCHAR2 255 NUMBER 2 NUMBER 20 2 20 2 S gt 4
107. nt to personal mail account e Close Closes the previewer screen e New Creates another copy of previewer screen Customer summary Valid cards Number of cards in status ACTIVE Red listed cards Number of cards of that bank which are redlisted Customer Card Balance Access Path Queries Reports Customer This screen gives an overview to all Load Unload and Payment transactions within a certain period for a specific card of a particular customer Retrieve the records Either Enter valid data in C amp A Customer Id or enter valid data in Customer Name and Bank Customer Id and C amp A Customer Id Searchable fields are in Yellow legend Wildcarding may be used in both of the fields OR Press Search button in Customer Card Information block A List of Values appears with list of Customer Information After selecting the desired Information press OK button in the List of Values form to get a valid Customer Information Enter a valid Card No or retrieve the same by pressing Search button Enter From Date and To Date in DD MM YYYY format Press Execute to fetch Load Unload Payment Transactions on the main screen within the given range of From Date and To Date The purse balance and the service charge paid by the customer is shown STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 0
108. ogging purpose Context of transaction to indicate whether the LOAD UNLOAD was with CASH or was it to customer account Transaction status code stored for logging purpose Type to indicate whether it is an IEP 01 ECH 02 or POS 03 transaction STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL CUSTTRANS VKOFF NULL VARCHAR2 4 Off line tx key version CUSTTRANS_VKON NULL VARCHAR2 4 On line tx key version Table 6 10 Structure of table CUST_TRANSACTION STARCOIN C amp A System User Manual 25 05 99 Vol Page 59 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name Description ADVICE Primary Key DBPADV NO Foreign Key Name DBPADV AMT DBPADV ARCHFLAG DBPADV ATTRIBUTE DBPADV ATTRIBUTE2 DBPADV ATTRIBUTE3 DBPADV ATTRIBUTEA DBPADV BANKCUSTID DBPADV CARDNR DBPADV DATETIME DBPADV EXPFLAG DBPADV MRCACCNO DBPADV MRCBIN DBPADV MRCID DBPADV MRCNAME DBPADV NO DBPADV SRCACCNO DBPADV SRCBIN DBPADV SVCACCNO DBPADV SVCBIN DBPADV SVCCHARGE DBPADV TERMID DBPADV TERMOPID DBPADV TRANNO FINAL CONFIDENTIAL This table is used to keep summarised information on Debit POS Transactions DBPADV TRANNO DBPOS TRANSACTION DBPOSTRAN NO Null NOT NULL NOT NULL NULL NULL NULL NULL NOT NU NOT NU NOT NU NOT NU NOT NU OT NU OT NU OT NU OT NU OT NU OT NU OT NU NOT NU NOT NU NOT NU NOT NU NOT NU Archiv
109. ormation on system parameters for POS transactions set up during installation time Unique serial number of POS authorisation sequence Threshold value of proposed service IEP ECH or POS If IEP or ECH balances are sufficient STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name SYSPAR Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key N A Sena wur VARCHAR RAC SYSPARATIRIBUTE a VARCHAR RAT SYSPARATIRIBOTES wur VARCHAR SYSPARATIRIBOTES a SYSPARAUTOSTEIOBNO wur ROBERT RA SYSPARLSTEBANKACE NULL NUMBEROD Bark SYSPARLSTEBANKGIY VARCHNUGD Ciy par ot Asse Seteme a SYSPAR_STEBANKCONTACTPERSON NUL VARCHAIGD Conic Peron representing Sortem ak SYSPARLSTEBANKCOUNTRY VARCHARIG0 owy viere SYSPARLSTIOBANKEAR NULL VARCHNUGD For mambe oie Seenen SYSPARLSTEBANKPHONE NULL VARCHAIGD Veneris Semen Bak Prone SYSPARLSTEBANKSTREET NULL VARCHARIGD___ Sece par oF Address oF he wu T SSPNCSIPROCHSHAG NULL NUMBERS SYSPARSTETIME NUL swewwenw Table 6 39 Structure of table SYSPAR NULL NULL NULL NULL NULL NUL
110. other copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Vol Page 43 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 9 4 9 1 4 9 2 Page 44 of 109 Location Wise List Of Terminals e Access Path Queries Reports Terminal List List of terminals sorted per location Retrieve the record e Select Option for Single Location All Locations e For Single Location e Place the cursor on Terminal Location field At this stage Search button is enabled e Either Enter valid data in Terminal Location Searchable fields are in Yellow legend Wildcarding may be used in both of the fields e OR Press Search button in Terminal Location block A List of Values appears with list of Terminal Location Information After selecting the desired Information press OK button in the List of Values form to get a valid Terminal Location Information e Press Execute to fetch Terminal Information records for the selected Terminal Location e For All Locations Press Execute to fetch all Terminal Locations amp corresponding Terminal Information records on the screen e You can navigate from one record to another of Terminal Location by pressing the Prev and Next button The corresponding data for Terminal Information is fetched in the corresponding blocks e
111. particular transaction settlement per transfer date Key identifier and Version Number for Off line transaction Key identifier and Version Number for On line transaction Table Name REDLIST CARDS Description This table is used to keep information of Redlisted Cards Primary Key REDLIST NR Foreign Key N A Description RFU RFU RFU RFU Card number redlisted or resetted from Redlist REDLIST_CARDNR NOT NULL NUMBER O REDLIST DATE NOT NULL DATE REDLIST_NR NOT NULL NUMBER S REDLIST_REDRESETFLAG NOT NULL NUMBER 1 Date of Redlist generation Unique redlist generation number Reset flag 0 Redlisted card 1 Resetted from redlist Table 6 29 Structure of table REDLIST CARDS Page 72 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name SYSADM CODES Description This table is used for internal processing Primary Key Foreign Key N A COD CODEDESC NOT NULL VARCHAR2 20 Code type COD CODEVALUE NOT NULL NUMBER 5 Code description Table 6 30 Structure of table SYSADM CODES Table Name SYSADM ERRORS Description This table is used to keep all the application level errors Primary Key ERROR ID Foreign Key N A Nam ERROR_CAUSE NULL VARCHAR2 160 Cause for Error Warning ERROR ID NOT NULL VARCHAR2 80 Unique Identifier for each Error Warnings Informations ERROR_TXT NOT NUL
112. ption PUR TRANSACTION This table keeps summarised information on purchase transactions PURTRANS NO PURTRANS IEPECH IEPECH IEPECH IEPECH PURTRANS PSAM CARD TRMCARD PSAM PURTRANS ARCHFLAG NOT NULL CHAR 1 Purchase transaction archived confirmation Default N after i archivation changed to Y VARCHARIOSS o Primary Key Foreign Key NULL NULL NULL NULL NULL NULL NOT NULL U U U PURTRANS CRITICAL NUMBER 1 Tx could not be settled due to ts signature other errors 0 Not U U U critical 1 Critical Error in transaction RTRANS_DEXPIEP Date on which the IEP or ECH Expires D NUMBER ECH settlement advice no indicating whether this transaction has been adviced or not RTRANS_ECHSTLNO P NOT NULL Customer card IEP ECH number for this particular transaction RTRANS IEPECH PURTRANS MRCPOOLID PURTRANS MTOTPSAM PURTRANS NC NS NS Pool Identifier corresponding to this transaction NOT NULL NULL NULL NOT NULL NOT NUL U U U U ina NU Transfer date of transactions for which this settlement is done one NU NU E U PU PU U U RTRANS PSAM NOT NU RTRANS TRANSFERDATE NOT NU PURTRANS TYPE NOT NU PURTRANS VKOFF NOT NU PURTRANS VKON NOT NU Table 6 28 Structure of table PUR TRANSACTION Purchase Terminal card number where this transaction happened E Purse Provider for the for this
113. r the Cardholders ID 305 contains issuer id or not If the value is 1 then the ISSUERID field has to be not null SYSCARDPAR_ISO310 N DATE Date on which the Customer card POS functionality expires load process denied SYSCARDPAR_ISSUERID NULL NUMBER 2 Issuer Id for 150305 SYSCARDPAR_MINLOADAMT NUMBER 10 Minimum Load Amount allowed for Customer Card SYSCARDPAR PINCHANGE NOT NULL NUMBER 1 PIN change allowed indicator 00 no 017 yes Button C amp A system Table 6 36 Structure of table SYSCARDPAR SYSCARDPAR DDEAOFF NUMBER 3 ICC and terminal card deactivation date offset in days to DEXP_IEP TK indicating the time transactions are still cleared NOT NULL NOT NULL NOT NULL NOT NULL OT NULL STARCOIN C amp A System User Manual 25 05 99 Vol Page 75 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices Table Name SYSISOPARATM Description Primary Key Foreign Key Table 6 37 Structure of table SYSISOPARATM Table Name SYSISOPARPOS Description Primary Key N A Foreign Key N A SYSISOPOS_IEPPOSSWITCH NOT NU Table 6 38 Structure of table SYSISOPARPOS Page 76 of 109 MBER 10 NU NU U FINAL CONFIDENTIAL This table is used to keep information on system parameters for ATM transactions set up during installation time Unique serial number of ATM authorisation sequence This table is used to keep inf
114. ransactions Details made by that customer are shown on the screen showing the following fields Date No Type Reason Context Card No No Amount e The Search and Export buttons are disabled The Details Next disabled when at last record Prev disabled when at first record and Advice buttons are enabled e At this point of time you can see the details of a particular customer by pressing the Details button e You can navigate between various records of customer and their corresponding transactions by pressing the Prev and Next buttons e For Single Customer e Either Enter valid Bank Id and Bank Customer Id fields or enter valid Bank Id and Bank A c No Press Tab Data is retrieved for that particular Customer Or e Press the Search button Searchable fields are in Yellow legend Wildcarding may be used in the field Press Ok in the List of Values after choosing any particular customer Data is retrieved for that particular Customer Customer STARCOIN C amp A System User Manual 25 05 99 Vol Page 25 of 109 Version 2 0 1 Revision 15 04 99 3 Settlement Process FINAL CONFIDENTIAL Name Bank Name Bank BIN Total Load Amount Total Unload Amount are display only fields e The Search and Export buttons are disabled The Details and Advice buttons are enabled e At this point of
115. rchase transaction Dart uite dee eet te p nette eee steer Ure 33 4 44 Inupmin mm 34 4 5 TERMINAT CARD tenia qiie eele tei e ee EN Gr I es 35 Z5 TL Retrieve the Yecords ir RE ERE EE IR EU ane Pra RETURN ee EMEN ROME oca UAE 35 43 2 Teminalcard inform tlOWDpkt edi e Ra UN etes da een dpa 35 4 5 3 Summary information part e ad pe eee qm o ua eed eye eese edi i re egy ee fete ga eA bee 36 ADA Navig tion i eU e ET e tee 36 4 0 MERCHANT B ADANCE 1025 i735 ette te prr HERE ORO ESSERE TRE ERN RO D RERO TRUE IE ORE TREE Re IHRER 37 A Os Retrieve the records aute eA st teri ede tte ia erit ette 37 40 2 PAYMENE Transactions Dart co es IR C AR 37 STARCOIN C amp A System User Manual 25 05 99 Page 3 of 109 Version 2 0 1 Revision 15 04 99 Content 2 6 3 Summary information part e deett erue oet e E REC 37 2 6 4 NOVIgtiOri eet e Rn e ied ient dne tee nne entem 38 A TATERMINAT TRANSACTION ettet ree Et eR bite NER e EE RC EU eee Nen Verr et reU 39 4 7 1 Retrieve the records ias da Pet dock reo 39 4 7 2 Terminal Card Information Part a nr tei RR e Pe REO
116. rs with list of Banks After selecting the desired Bank press OK button in the List of Values form to get a valid Bank Information e Press Execute to fetch an existing record in the Customer Information block e Total No of Customers is shown as summary information for Customer Information block and total number of Valid Cards and Redlisted Cards are shown as Customer Summary information Navigation e At any point of time pressing Clear button clears the screen so that new query can be made e At any point of time pressing Close button closes the form e To get report of the query press Print button after query has been executed STARCOIN C amp A System User Manual 25 05 99 Vol Page 29 of 109 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 2 3 4 3 4 3 1 Page 30 of 109 A report previewer appears on the screen with following buttons on top e Prev Takes to previous page e Next Takes to next page e First X Takes to the first page e Last Takes to the last page Page Takes to page no entered in the box next to the button e Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report can se
117. rsion TK update Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Required for controlling of Table 6 47 Structure of table TERM CARD e 9 Appendix List of Error Messages 22 Error Id Error Description ERR20001 Given Terminal Manufacturer Id is not valid in this context Enter Valid Terminal Manufacturer No ERR20002 Enter valid Merchant Id Given Merchant Id is not valid in this context ERR20003 Given Terminal No is not valid in this context Enter valid Key ID Given Key Id is not valid in this context Deactivation Date Should be An attempt is made to enter Greater Than or Equal To Enter valid Terminal Number EN ERR20004 ERR20005 3 A Terminal must have a terminal card Enter valid Merchant ID An attempt is made to cancel the Terminal Card for a Terminal ERR20006 Entered Merchant id is not valid in this 7 ERR20010 context 8 20011 Activation Date should be greater An attempt is made to enter the activation Vol Page 83 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Rev
118. s a pool bank ERR60010 The Member Bank Of The Pool An attempt is made to attach a bank for Must Have A Cash Account which Cash a c no is null in a pool Number 97 ERR70001 Key Already Installed go through Attempted to install an already installed key reinstallation option fos ERR7O002 fos ERR70003 Expiry dateshoutdbe Incomestexpiny date Attempt to work with a key which have not been installed 102 ERR70006 Key Not Found in Database Record for a specific key is not present in Cannot update Records database but an attempt is made to Update Topical Version etc 103 ERR70007 Key Not Found in Database Record for a specific key is not present in Cannot Add New Instance database but an attempt is made to Add New Key Instance etc ERR80051 File not found File is not found 105 ERR80052 must contain digits lying between Characters are entered in a field which must 0 and 9 only contain digits 106 ERR80053 Please Provide File Name with File Name has not been entered properly full Path 107 ERR80054 File already used valid transactions Attempt to access a file which has been are already posted already used 108 ERR80055 Please Enter Proper values for all Incorrect values entered the fields 109 ERR80056 All Customer Cards Under This Export of all sorts of customer cards has Bank Are Personalised And success fully done Exported 110 ERR80057 Cannot Export More Than 65
119. s an existing Terminal Card This task Updates the status of an existing Terminal Card Updates existing Terminal Service Status Information amp fault Type Updates existing Merchant Information STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 1 2 Prerequisites e For allocation of Terminal amp issue of Terminal Card For allocation of new Terminal amp issuing Terminal Cards to an existing Bank records should exist for GD Init System Init Bank and Terminal Manufacturer For new Merchant as well as Terminal Terminal Card entry records should exist for GD Init System Init and Terminal Manufacturer For allocation of new Terminal amp issuing Terminal Cards to an existing Merchant records should exist for GD Init System Init Bank Bank Pool Merchant and Terminal Manufacturer e For Replacement of Terminal Cards records of Terminal Terminal Card should exist for Bank Merchant e For Updating of Cards Status records of Terminal Terminal Card should exist for Bank Merchant e For Updating of Terminal information records should exist for Terminal e For Updating of Merchant information records should exist for Merchant 1 2 Issue Terminal Cards e Access path Terminal Setup Merchant Terminal Cards 1 2 1 Set up a new Merchant 1 2 1 1 Creating New Merchant Record e Press New
120. standing 1 Outstanding Transaction status code stored for logging purpose Vol Page 61 of 109 6 Appendices FINAL CONFIDENTIAL Table Name DB ADVICE Description This table is used to keep summarised information on Load Unload Transactions Primary Key DBADV_NO Foreign Key CUSTTRANSNO CUST TRANSACTION CUSTTRANS DBADV AMT NOT NULL NUMBER 10 Amount that has been transacted with the customer card for this advice DBADV_ARCHFLAG NOT NULL CHAR 1 Debit advice archived confirmation Default N after archivation changed to Y Name of the customer whose Debit advice is being generated Customer related Transaction No C amp A system specific N DBADV_DESTACCNO NULL MBER 20 The Account where money is to be credited The Customer Account No in case of UNLOADING else the Bank Pool Account No or cust ECH acc number in case of LOADING DBADV_EXPFLAG NOT NULL NUMBER 1 Flag to indicate whether this debit advice has been exported or not Default 02 Not Exported 1 Exported U U U x U DBADV IEPECH NOT NULL NUMBER 14 Customer Card IEPECH No z NU U U DBADV_IEPTYPE NOT NULL 2 Type indicating whether the Debit Advice is for IEP 01 or ECH 02 DBADV NO NOT NULL NUMBER Unique Number identifying for each Debit Advice DBADV SOURCEACCNO NULL NUMBER 20 The Account from which money is to be debited The Bank pool Account No or ECH Account Number in case of UN
121. sued for e Press Issue Transfer Card to personalise and issue transfer card to Merchants STARCOIN C amp A System User Manual 25 05 99 Vol Page 9 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL 1 2 3 Replace Terminal Card e Access path Terminal Replace Cards 1 2 3 1 Retrieve Existing Terminal Record e Enter either Merchant Bank Id or Merchant Bank Name fields Searchable fields are in Yellow legend Wildcarding may be used in both of the fields to fetch the record e Press Search button in the first block A List of Values will appear from which a Merchant Bank Name can be selected After selecting a record press Ok button of the List of Values If you use wildcard or just initials in Merchant Bank Id or Merchant Bank Name fields and press the Search button the List of values appears from which a Merchant Bank Name can be selected e Terminal amp Terminal Card details for the Merchant Bank will be displayed on the screen 1 2 3 2 Replace Terminal Card The table below shows the combination of conditions for which the terminal card can be replaced Sl Status List Card Status Rep Remarks Reason Status lace Alert Red Listed DEACTIVATED If Status Reason is Alert this is the only possible combination Defect Neither RESTRICTED If a defective card is not Red USE Listed then it
122. t is set up in the C amp A database till it expires These states are maintained as Card Status Depending on the Card Status certain functionalities of the card are either allowed or disallowed NEW e Set Automatically when the terminal card data have been entered and set up by the system ready for Personalisation Restrictions Transaction Allowed Table 1 2 Restrictions on Terminal Card Status NEW It should not be possible that any transaction arrive If yes the C amp A supervisor need to be informed because it may be a faked terminal card or transaction ACTIVE e Set Automatically when the Personalisation instance has returned a correct response The terminal card can operate now in the STARCOIN payment system able to execute load unload payment and service PIN counter reset transactions Restrictions Transaction Allowed mme x _ Table 1 3 Restrictions on Terminal card Status ACTIVE Page 12 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL RESTRICTED USE e Set Automatically when authorised user on request of the service technician merchant bank phone call fax selects one of the below mentioned reasons e Set Automatically by the C amp A system when terminal card expires Restrictions Table 1 4 Restrictions on Terminal Card Status RESTRICTED USE
123. t Applicable Archiving 295 INF90014 Redlist and Reset data archived Not Applicable and purged 296 INF90014 Redlist and Reset data purged Not Applicable without archiving INF90014 Invalid archive directory Not Applicable 298 INF90014 Archiving and Purging Stopped Not Applicable abnormally Please check your entries INF90014 Update depth can not be below Not Applicable INF90014 Enter valid Update Depth Not Applicable INF90014 Update Depth required Not Applicable 302 INF90014 Full path not given Do you want to Not Applicable use current directory INF90015 Press Query button for new query Not Applicable 306 INF90032 MaxPool parameter in Parameter Not Applicable table exceeded can t create INF90033 Record s modified Save Form Not Applicable 308 INF90034 No Change From Previous Redlist Not Applicable Info Redlist File not Generated 309 INF90035 File Name Not Entered Output Not Applicable File Name Is Default txt 310 WRN00050 TK Update Information Is Deleted Not Applicable For Update No And UCT Version 311 WRN20007 No Terminal is allocated All Not Applicable Information of the Merchant will be lost 312 WRN20008 Replacement Card Issued Not Applicable Cannot delete existing Card 313 WRN20009 No Renew Card Issued Cannot Not Applicable delete existing Card WRNA0001 Do You Want To Clear The Form Not Applicable 315 WRN40012 There is no C
124. t ECH only customers card GDATR_ATRICCIEP NOT NULL VARCHAR2 30 Data returned in the cards answer to reset IEP only customers card GDATR_ATRICCPOS NOT NULL VARCHAR2 30 Data returned in the cards answer to reset IEP ECH POS customers card GDATR_ATRPSAM NOT NULL VARCHAR2 30 Data returned in the cards answer to reset Merchant IEP ECH POS TK GDATR ATRPSAMICC NOT NULL VARCHAR2 30 Data returned in the cards answer to reset Merchant IEP ECH TK GDATR_ATRPSAMPOS NOT NULL VARCHAR2 30 Data returned in the cards answer to reset Merchant POS TK GDATR_ATRTKBANK NOT NULL VARCHAR2 30 Data returned in the cards answer to reset Bank IEP ECH POS TK GDATR ATTRIBUTE3 NULL VARCHAR2 255 GDATR_ATTRIBUTE4 NULL VARCHAR2 255 Table 6 16 Structure of table GDATR Page 64 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL Table Name GDCARDPAR Description This table is used to keep information on system parameters set up during installation time Primary Key N A Foreign Key N A Name GDCARDPAR_59PANID GDCARDPAR_ALGIEPPSAM GDCARDPAR_AMIEPPSAM GDCARDPAR ATTRIBUTEI GDCARDPAR ATTRIBUTE2 GDCARDPAR ATTRIBUTE3 GDCARDPAR ATTRIBUTEA GDCARDPAR_AWS10 GDCARDPAR_FIDEFCERT GDCARDPAR_FIDEFSCN GDCARDPAR_IDCHECKTK GDCARDPAR_IEPPARAM GDCARDPAR_ISO307 GDCARDPAR_ISO403 GDCARDPAR_ISO407 GDCARDPAR_ISO410 GDCARDPAR_ISO411 GDCARDPAR_MAXPIN GDCARDPAR_PATM GDCARDPAR_PFU
125. t for which transactions are purged out Total Unload from cash amount for which transactions are purged out Vol Page 51 of 109 6 Appendices FINAL CONFIDENTIAL BANK SVCFLAG NULL NUMBER 1 Flag to Indicate whether the Bank pays service charges for all its customers and or merchants OR the Customers and or merchants of this bank have to pay their own service charges BANK_TELEFON NULL VARCHAR2 30 Telephone Number for the Bank BANK_ZIP NULL VARCHAR2 30 ZIP Code part of Address of the Bank Table 6 1 Structure of table BANK Table Name BANK_POOL Description This table is used to keep Pool master information Primary Key BANKPOOL_POOLID Foreign Key None BANKPOOL_BANKID NULL MBER 4 Unique Identifier for the pool s corresponding Bank where the pool account is located BANKPOOL_CURRIEP NOT NULL NUMBER 4 Actual Currency for the Pool BANKPOOL DELDATE NULL DATE Bank Pool Deleted Date BANKPOOL DELFLAG NOT NULL MBER 1 Default 0 Flag to indicate deleted Bank Pools NU U NU BANKPOOL LOADNR NOT NULL NUMBER 10 Number of loading transactions on this pool Default 0 NU U U U BANKPOOL_LOADTM NOT NULL MBER 15 Cumulated load amounts of this pool Default 0 BANKPOOL PAYMENTNR NOT NU NUMBER 10 Number of payment transactions on this pool Default 0 N BANKPOOL_PAYMENTTM NOT NULL MBER 15 Cumulated payment amounts of this pool s m 2 the C amp A system according to GDInit MaxPool NOT NULL Current Balance for
126. tal number of restricted use cards RFU Total number of deactivated cards Already deactivated terminal cards of that specific merchant Navigation At any point of time pressing Clear button clears the screen so that new query can be fired At any point of time pressing Close button closes the form To get report of the query press Print button after query has been executed A report previewer appears on the screen with following buttons on top e Prey Takes to previous page Takes to next page e First Takes to the first page e Last Takes to the last page Page Takes to page no entered in the box next to the button e Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e The report can sent to personal mail account e Close Closes the previewer screen e New Creates another copy of previewer screen STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 6 Merchant Balance e Access Path Queries Reports Merchant balance This screen gives an overview of all the transactions for a Merchant It also provides Merchant A c wise summary information 4 6 1 Retrieve the records e Either Enter v
127. tempt has been made to Advice Export present Cannot Advice Export when export file already exist for this date again 87 ERR60001 does not exist or Invalid Invalid entry Character Set Enter valid 88 ERR60002 has no Cash A c Number A bank having no Cash A c Number is Cannot attach bank attempted to attach to a pool ERR60003 Pool A c No cannot exist without Pool A c No is given and attempted to save Cannot Save when Bank Id does not exist ERR60004 Service A c No is mandatory for Service Code is given and attempted to save this Service Code when Service A c No does not exist STARCOIN C amp A System User Manual 25 05 99 Vol Page 87 of 109 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 9 ERR60005 Total No of Pools has exceeded the A new pool is attempted to create when Max Pool No Cannot Total No of Pools has exceeded the Max create generate new Pool Pool No 92 ERR60006 Bank Id cannot exist without Pool Bank Id is given and attempted to save A c No Cannot Save when Pool A c No does not exist 93 ERR60007 PoolBank already exists for another Attempted to save record for pool when Pool Cannot Save pool bank already exist 94 ERR60008 An ECH Pool cannot Have an An attempt is made to attach a Bank with Participating Bank Attached To It ECH Pool 32769 95 ERR60009 Pool Bank Must Have A Cash An attempt is made to define a bank Account Number without Cash A c no a
128. the Prev and Next buttons e For Single Merchant e Either Enter valid Merchant Id and Transfer Date Press Tab Data is retrieved for that particular Merchant Or Press the Search button Searchable fields are in Yellow legend Wildcarding may be used in the field Press Ok in the List of Values after choosing the particular merchant and transfer date Data is retrieved for the particular Merchant Merchant Name Settlement Amount are display only fields e The Search and Export buttons are disabled The Details and Advice buttons are enabled e At this point of time you can see the details of the particular merchant by pressing the Details button e Clear will clear the form without raising Settlement advice e Close will close the form without raising Settlement advice 3 3 1 2 Raise Settlement Advice e Press Advice button For Single Merchant Settlement Advice is raised and the merchant transaction is updated by the Settlement Advice No for that particular merchant For All Merchants Settlement Advice is raised and the merchant transactions are updated by the Settlement Advice No for all merchants e The Details and Advice buttons are disabled and Export button is enabled e At this point pressing Clear button will clear the form without exporting the data to a flat file e At this point pressing Close bu
129. tialisation System Setup System Init gt TK Param Single Tx Prob Terminal parameter defining the probability of single transaction recording of IEP purchase transactions hex coded 00 0 FF 100 It is recommended to use the default value FF If this parameter is not equal FF and Single Tx Limit is above 0 the accounting for IEP transactions is deactivated and can not be enabled again Status Operational state of the terminal card For a detailed description of the terminal card states please refer to a later chapter of this manual STARCOIN C amp A System User Manual 25 05 99 Vol Page 7 of 109 Version 2 0 1 Revision 15 04 99 1 Bank Merchant Terminal amp Terminal Card Handling Process FINAL CONFIDENTIAL Threshold value If the purchase amount on a terminal is above this value the terminal will promote Debit POS as preferred payment method but still allows to change for an IEP or ECH payment Defined in the system initialisation System Setup System Init TK Param Currency code Currency code of the payment system Floor Limit of TK Maximum limit of the terminal card ISO401 for Debit POS payments Number Maximum value 4294967295 Mandatory Balance indicator Defines when the balance of the IEP and or ECH is displayed Defined in System Setup System Init Single Tx Limit If the IEP purchase amount on a terminal is above this value the terminal will store a s
130. time you can see the details of the particular customer by pressing the Details button e At this point pressing Clear button will clear the form without raising Debit advice e At this point pressing Close button will close the form without raising Debit advice 3 2 1 2 Raise Debit Advice e Press Advice button For Single Customer Debit advice is raised and the customer transaction is updated by the Debit Advice No for that particular customer For All Customers Debit advice is raised and the customer transactions are updated by the Debit Advice No for all customers e The Details and Advice buttons are disabled and Export button is enabled e At this point pressing Clear button will clear the form without exporting the data to a flat file At this point pressing Close button will close the form without exporting the data to a flat file Note It will not be possible to export the data from this screen for the particular record because data for this customer will not be retrieved in this form again 3 2 1 3 Export Debit Advice e Press Export button The debit advice raised is exported to a flat file DAVDDMMY dat in the export directory of the STARCOIN Server as defined in STARCOIN ini SETTLEMENT_EXPORT_DIR lt path gt The entire data from the debit advice table is dumped in the file 3 3 Settlement Advice e Access Path Settlement Settlement
131. tion on that card NTICC Customers card transaction counter Amount Purchase transaction amount Settled Yes No An ECH Transaction may not be settled because the settlement may not have STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL run for that day or some of the transactions are critical because signature or other validations have failed e Status Status indicates why the transactions have failed If settled is No and status is OK then these transactions will be settled later 4 7 5 Navigation e Atany point of time pressing Clear button clears the screen so that new query can be fired depending on option chosen e Atany point of time pressing Close button closes the form e To get report of the data retrieved for Single Terminal or All Terminals press Print button after query has been executed report previewer appears on the screen with following buttons on top e Prey Takes to previous page e Takes to next page e First Takes to the first page e Last Takes to the last page Page Takes to page no entered in the box next to the button e Print Prints the report shown on the screen in the local printer The printer has to be a postscript printer i e Laserjet or Deskjet printer It does not create a ASCII dump file oracle limitations e
132. to a specific customer ERR40044 Customer Card No not entered An attempt is made to leave the Customer s Card No field 67 ERR40045 ATR Not Correct Invalid Card Card of proper type is not inserted Inserted Insert Proper Card And Continue ERR40046 Manufacturer Terminal If not terminal manufacturer information is Information Not Found Cannot there but an attempt is made to issue a Continue terminal 69 ERR50001 Customer with this 4 does not exist Invalid Customer No has been entered ERR50002 This Merchant Id does not exist Invalid Merchant Id has been entered 71 ERR50003 There are no transactions for which An attempt has been made to retrieve debit advice has not been raised transactions for which debit advice has not been raised 50004 Unable to update table Unable to update a particular table Page 86 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 73 ERR50005 settlement advice for this No transactions available for a particular transfer date have already been date Settlement Advice can not be raised raised 74 ERR50006 Unable to update ECH Settlement Unable to update ECH Settlement Advice Advice table table 75 ERR50007 Unable to update IEP Settlement Unable to update IEP Settlement Advice Advice table table 76 ERR50008 There no transactions made An attempt is made to raise Debit Advice for which d
133. tried to insert 210 ERR90109 Unable to Generate Bank Terminal Max limit of Bank Terminal Id has Id Max Limit 999999 exceeded and new Bank Terminal is tried to insert 211 ERR90110 Unable to generate both Bank Unable to generate both Bank Terminal and Terminal and Terminal Id Terminal Id ERR90111 Field must be of the form Invalid format is give for a particular field 213 90112 The System is Unable to Generate The System is Unable to Generate serial serial number for Bank Terminal Id number for Bank Terminal Id 214 ERR90113 The System is Unable to Generate The System is Unable to Generate serial serial number for Terminal Id number for Terminal Id 215 ERR90114 modified by another user Cannot The same data is already modified by save information another user 216 90115 Record For Customer Deleted Customer information abnormally deleted Contact System Administrator from the system 217 ERR90116 Form Running In Query only Change of database fields not allowed when Mode Cannot Change Database the form is running in query mode Fields 218 ERR90117 Key Version of card generation Key version of the new instance of key must be higher than should be higher than the version already present in the system 219 INF20001 Terminal Card s Issued Not Applicable Successfully INF20002 Card No successfully replaced by Not Applicable STARCOIN C amp A System User Manual 25 05 99 Vol Page 93 of
134. tton will close the form without exporting the data to a flat file Note It will not be possible to export the data from this screen for the particular record because data for this merchant will not be retrieved in this form again 3 3 1 3 Export Settlement Advice e Press Export button The settlement advice raised is exported to the flat files ISLDDMMY dat ESLDDMMY dat and POSDDMMY dat for IEP ECH and POS transactions respectively in the export directory of the STARCOIN Server as defined in STARCOIN ini SETTLEMENT EXPORT DIR path V The entire data from the settlement advice table is dumped in the file Page 28 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 4 Queries and Reports FINAL CONFIDENTIAL 4 4 1 4 1 1 4 2 4 2 1 4 2 2 Queries and Reports Introduction This section deals with generation of the standard queries and reports Prerequisites For Queries and Reports records should exist in all the master as well as transaction data stores Customer e Access Path Queries Reports Customer Displays all customers from a particular bank with vital data Retrieve the records e Either Enter valid data in Bank Id or enter valid data in Bank Name and Bank Id Searchable fields are in Yellow legend Wildcarding may be used in both of the fields e OR Press Search button in Bank Information block A List of Values appea
135. value entry FOR XX 153 ERR90042 Invalid Bank BIN Errors Warnings amp Information Id did not start with ERR WRN INF respectively 154 ERR90043 Error Numbers should be greater Entered Error Number is less than 20000 than 20000 155 ERR90044 Error Id should be in the format Error Id not in the format ERR WRN ERR WRN INF nnnnn where INF nnnnn where nnnnn 20000 nnnnn 20000 156 ERR90045 Period From cannot be greater Period From greater than Current Date Current Date 157 ERR90046 Period To cannot be greater than Period To greater than Current Date Current Date 158 90047 Period From should be less than Period From greater than Period equal to Period To 159 ERR90048 Invalid hex value Invalid hex value is entered Page 90 of 109 STARCOIN C amp A System User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 6 Appendices FINAL CONFIDENTIAL 160 ERR90049 Unable to Generate IEP Pool Id Max limit of IEP Pool Id exceeded and new Max Limit 32767 Pool is attempted to create ERR90050 Invalid account number Entered A c no is invalid in this context 162 ERR90051 Enter all the fields in all the Records have been tried to save when all screens fields in all the screens have not been entered 163 ERR90052 Enter unique value for service code Duplicate value for service code is entered corresponding to each service for different service category category 164 ERR900
136. ystem User Manual 25 05 99 Version 2 0 1 Revision 15 04 99 Vol Page 65 of 109 6 Appendices FINAL CONFIDENTIAL Table 6 18 Structure of table GDCA PARAMS Table Name GDSERV Description This table is used to keep information on system parameters set up during installation time Primary Key Foreign Key N A GDSERV SERVICECATEGORY NOT NULL NUMBER 1 Service Category type 1 Customer card 2 Bank Terminal Card 3 Purchase terminal card This category for dynamic controlling of list box GDSERV_SERVICETYPE NOT NULL VARCHAR2 15 Short description of service type e g BSTSAM POS Table 6 19 Structure of table GDSERV Table Name GDSYSPAR Description This table is used to keep information on system parameters set up during installation time Primary Key N A Foreign Key N A Maximum number of pools allowed in the System zi NU GDSYSPAR_ORGANISATIONNAME NOT NULL VARCHAR2 50 Name of STARCOIN system provider GDSYSPAR PID NOT NULL NUMBER 3 Serial number of the STARCOIN system Pilot Id used in CARD NR TERM ID PP PSAM GDSYSPAR PPIEP NOT NULL NUMBER 6 Purse Provider associated with IEP and ECH applications CCC Currency code PID Pilot Id number GDSYSPAR_PPPSAM NOT NULL NUMBER 6 Purse Provider for the Terminal card CCC Currency code PID Pilot Id number Table 6 20 Structure of table GDSYSPAR Page 66 of 109 STARCOIN C amp A System User Manual 25 05 9

STARCOIN C&A System User Manual Volume - II of II

Contents

Download Pdf Manuals

Related Search

Related Contents

STARCOIN C&amp;A System User Manual Volume - II of II

Contents

Download Pdf Manuals

Related Search

Related Contents

STARCOIN C&A System User Manual Volume - II of II