artix -t24 field mapping sheet-nileshshihaal-07dec2010 (2)
TRANSCRIPT
Sr. No. Service Operation
1 CustomerService RetrieveInternalContact
2 CustomerService RetrieveAddress
3 CustomerService ValidateCustomer
4 CustomerService UpdateDocument
5 CustomerService UpdateCustomer
Artix -T24 Field Mapping Sheet
T24 Enquiry Request / Response
KYC.GET.DAO.DETS.INET.MB Request
Response
KYC.GET.CIF.ADD.INET.MB Request
Response
KYC.CUST.NO.CHECK.INET.MB Request
Response
KYC.DOC.INET.MB Request
Response
KYC.CLIENT.INET.MB Request
Response
Artix -T24 Field Mapping Sheet
Artix field name T24 Field New T24 mapping
proposedCIF CUSTOMER.CODE
proposedCIF CUSTOMER.CODEprimaryRM ACCOUNT.OFFICER
bookingCenterOfficerBOOK.CENTER.OFF
investmentConsultantInvest.Consult
financialPlannerFinancial.Plann
structuredProductAdvisorSPA
creditOfficerCREDIT.OFFICER
proposedCIF CIF.ID
T24 Address ID IDOutput Name 1 NAME.1Output Name 2 NAME.2Street STREET.ADDRStreet 2 TOWN.COUNTRYCity CITYCountry ADDR.COUNTRYMailing type MAILING.TYPE
proposedCIF CUSTOMER.CODE
proposedCIF CUSTOMER.CODErecordstatus RECORD.STATUS
proposedCIF transactionId
apacUniqueId APAC.UNIQUE.IDApacMsgId APAC.MSG.IDformalityGRP FORMALITY.GRPformalityType FORMALITY.TYPE
These fields are related to Document
docApprovalDate DOC.DATE
Reviewduedate DOC.VALID.TO
docAckDate DOC.ACK.DATE
formalitySts FORMALITY.STSNO.OF.CUSTOMERS
JNT.NATIONALITY
JNT.LEGAL.TYPE
JNT.LEGAL.ID
JNT.NAME
JNT.RESIDENCE
JNT.DOB.DOI
cif transactionIdFORMALITY.GRPFORMALITY.TYPEDOC.DATEDOC.VALID.TODOC.ACK.DATEFORMALITY.TXTFORMALITY.TXT2FORMALITY.STSCREDIT.EXPOSURETRADING.SCHEMENO.OF.CUSTOMERSJNT.NATIONALITYJNT.LEGAL.TYPEJNT.LEGAL.IDJNT.NAME
These fields are related to Document
These fields are related to Joint Partner details
JNT.RESIDENCEJNT.DOB.DOIAPAC.UNIQUE.IDAPAC.MSG.IDCURR.NOINPUTTERDATE.TIMEAUTHORISERCO.CODEDEPT.CODEOFS.RESPONSE
cif transactionId
APAC.UNIQUE.ID APAC.UNIQUE.IDAPAC.MSG.ID APAC.MSG.IDProposed CIF MNEMONICshortName SHORT.NAME
Salutation, firstName, name, jointPartnerName NAME.1lastName, name NAME.2STREET STREET
Client managed by CLIENT.BR.EMD
RM.C.ACCT.TYPE RM.C.ACCT.TYPELiquidity ranking CLIENT.LIQ.RATNationality NATIONALITYTax residence RESIDENCEAPAC Type of Trust TRUST
ULT.ECO.BENFI ULT.ECO.BENFI
Is wholesale client CLIENT.TYPE
Is exception EXCEPTION
Wholesale basis WHOLESALE.BASISWholesale basis comment COMMENTSID Document Type LEGAL.ID.TYPEID Document Number LEGAL.IDExpiry Date LEGAL.ID.EXPJNT.CUST.HK JNT.CUST.HKDate of birth , Date of formation , Date of incorporation BIRTH.INCORP.DATE
Marital Status CIVIL.STATUS
Country of birth PLACE.OF.BIRTH
Primary RM ACCOUNT.OFFICERIs PEP PEP
Is trading shares Exec.Listed.Co
Finder CIF number DUMMY
Contract type FINDER.CON.TYPEFinder CIF Number FINDER.CIFReferred by REFERRED.BY
RM.DEP.CODE.REF RM.DEP.CODE.REF
Internal referee PID RM.PID.NO.REF
Intermediary CIF number INTER.NO.REFClient managed by IAMClient managed by IAM.ManagedBranch of EAM CIF
IAM.BKST
EAM CIF number IAM.CIF.NO
EAM pricing type EAM.TYPE
Identification delegation to EAM EAM.DELEGATIONSend to Quartal for Retro EAM.TO.QUARTALEAM BIC code PSN.BIC.CODE
Client segment Client.Segment.Client code Client.CodeCompany industry SECTOREAM Swiss stamp tax EAM.SSTS
Employment status LCD.CUST.TYPE
Gender GENDERDomicile Country, countryOfIncorportaion DOMICILE
2nd Nationality OTHER.NATIONALITYPERS.COMP PERS.COMP
clientType CLIENT.REL.TYPE
CS staff ID STAFF.MPIDSalutation SALUTATION
cif transactionIdCIF MNEMONICshortName SHORT.NAMESalutation, firstName, name, jointPartnerName NAME.1lastName, name NAME.2street STREETstreet2 TOWN.COUNTRYcountry COUNTRYindustryOfCompany SECTORprimaryRM ACCOUNT.OFFICER
OTHER.OFFICERINDUSTRYTARGET
nationality, countryOfIncorportaion NATIONALITYCUSTOMER.STATUS
taxResidence RESIDENCE
LANGAUGECOMPNAY.BOOKCLS.CPARTY
gender GENDER
Domicile Country, countryOfIncorportaion DOMICILE
2nd Nationality OTHER.NATIONALITYTRAIDING.SCALESAFEKEEP.SCALEMANAGED.SCLAEADVISORY.DISCREGST.EXEMPTEDUS.PERSONBOOKING.CENTRECSS.CUST.TYPESOURCE.AQUISITOPENING.DATEADDR.COUNTRYPERS.COMP
city CITY
typeOfTrust TRUSTmailingType MAILING.TYPE
PROF.CODE.HOALLOC.CODE
clientManagedBy CLIENT.BR.EMDFISKA.OEJNT.CUST.HK
Booking Center Officer (Account Manager) BOOK.CENTER.OFFWAIVERREP.OFFICECPNC.CUST.TYPECPNC.INDVD.FORMCPNC.CORP.FORMCPNC.DTA.FORMGEN.RUBRIC.CODEUS.RUBRICNON.US.RUBRICSTP.DEPOD.JUMBOSTP.BRKB.JUMBORM.C.FIRST.NAMERM.C.LAST.NAME1
pep PEPCCY.JUMBO.LCYCUST.DEFAULT
Wholesale Basis Comment COMMENTSLiquidity Ranking CLIENT.LIQ.RATCountry of Birth PLACE.OF.BIRTH
REGISTER.GSTBELONG.STATUSPI.STATUSPI.MAN.OVERRIDEMPA.SUBMITTED
CIF.SUMMARY.CCYclientType CLIENT.REL.TYPE
APAC.UNIQUE.IDAPAC.MSG.IDCURR.NOINPUTTERDATE.TIMEAUTHORISERCO.CODEDEPT.CODEOFS.RESPONSE
Value (if hard coded) Severity StatusMapping Unit
M35RAA033
hard coded O
this can be system date, and there's no aBOM mapping field, may need to consult CTS team or ZH SE
this is the next review date and it's
not stored in any aBOM field, suggest consult ZH SE team where this infor in the backend would
be stored
no value need to be populated to this field
there's no aBOM mapping field, may
need to consult CTS team or ZH SE
where this infor in the backend would
be stored
please refer to FSD 6.5.6
please refer to FSD 6.5.6
please refer to FSD 6.5.6
please refer to FSD 6.5.6
please refer to FSD 6.5.6
please refer to FSD 6.5.6
M34R
1) Individual.First Name + Individual.Last Name2) NON INDIVIDUAL.NAME3) JOINT PARTNER.NAME 1ST LINE
mapping logic as below:1 CS Trust---CST2 non-CS Trust---TRUST
refer to FSD 6.5.9, it's the BO/AH's Domicile, refering to the DFC, it's mapped to Official Registered Address.Country
Wholesale Client Field => If "Yes" select WHOLESALE, If "No" select RETAIL
Is Exception, populate to "Yes"/"No" value accordingly
only applicable to SG location
Mapping as below:1. Single--SINGLE2. Married--MARRIED3. Seperated--SEPERATED4. Divorced--DIVORCED5. Widowed--WIDOW(ER)6. Registered Relationship--REG RELP(new value to be created in T24)
changed from GKYC DD.MM.YYYY to T24 (YYYYMMDD)
For AH's "Is Trading Shares" field, mapping as belows:Yes--Trading in Own SharesNo--No Trading Own Shares
DUMMY: Populate "YES" if Finder CIF number field is entered, otherwise"NO"
mappings as below:internal referral--1 INTERNAL REFERRALExternal referral--2 EXTERNAL REFERRALIndirect Business--4 INDIRECTDirect Business--3 DIRECT
it's the Internal Referee RM field that shall be mapped, but need to be converted to DAO code
Please refer 'RM.DEP.CODE' for this field as following :convert to DAO code and send to T24, it is the exisitng behavior to populate the MPID to RM.PID.NO.REF field
Branch of EAM CIF, use Key to map for SG T24. field in HK T24 is a free text field, thus the value should be directly populated to HK T24 field
1 Asia--Asia2 Europe--EUR
For AH's "Employment Status" field, populate "SA" to T24 LCD.CUST.TYPE field when satisfying either of the below two sceanrios:value for field "Employment Status" is "CS Employed", or "Employment Status" is not chosen as "CS Employed" and "CS Staff ID" field is not blank, and "Family Relative Type" field is chosen as "Spouse", then
refer to DFC for the mapping
this is based on the client relationship type. If it's individual, then will populate person, if it's in legal entity(non individual), then will populate Company
there's no aBOM mapping field, may need to consult CTS team or ZH SE where this infor in the backend would be stored
MVMVMVMV
mapping logic as below:1 CS Trust---CST2 non-CS Trust---TRUST
MV
Remarks
APAC Postal Address Entity Name, check IF lifecycle status = activeAPAC Postal Address Entity NameAPAC Postal Address Entity NamePostal Address Entity NamePostal Address Entity NamePostal Address Entity NamePostal Address Entity NameMailing Instruction Entity Name
Possible values for recordstatus will be "Record Found" or "Record Not Found"
operand = "EQ" (EQ meaning Equal, is this understanding is correct?) Yes
User. Last name, User. First name - User. Internal identifier (PID)Where FunctionHolder. Function = 'Primary Relationship Manager'"User. Last name, User. First name - User. Internal identifier (PID)"Where FunctionHolder. Function = 'Booking Center Officer (Account Manager)'
"User. Last name, User. First name - User. Internal identifier (PID)"Where FunctionHolder. Function = 'Investment Consultant'
"User. Last name, User. First name - User. Internal identifier (PID)"Where FunctionHolder. Function = 'Financial Planner'
"User. Last name, User. First name - User. Internal identifier (PID)"Where FunctionHolder. Function = 'Structured Product Advisor'
"User. Last name, User. First name - User. Internal identifier (PID)"Where FunctionHolder. Function = 'Credit Officer'
operand = "LK" (What is LK?), not LK, now operand = "EQ"
operand = "EQ", APAC Dossier entity Name
To be constructed at KYC side and sent to T24. See DS for more details section 5.12.3.1
Date when kyc review is approved
Review.Review due date
BLANK
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELDAPAC Dossier - Liquidity rankingIndividual - NationalityAPAC KYC Profile Partner - Tax residenceAPAC Trust - APAC Type of Trust
BLANK FIELD
Australian Domicile Legal Check List - Is wholesale client
Australian Domicile Legal Check List - Is exception
APAC Australian Domicile Check List - Wholesale basisAPAC Australian Domicile Check List - Wholesale basis commentProof Of Identity - ID Document TypeProof Of Identity - ID Document NumberProof Of Identity - Expiry DateBLANK FIELDIndividual - Date of birth , Trust - Date of formation , Corporate - Date of incorporation
To be constructed at KYC side and sent to T24. See DS for more details section 5.12.3.1
in N3147_GFS_Data_Field_Catalogue.xlsx its mentioned that - 'populated from T24'Is it same as STREET.ADDR in mapping sheet?
APAC Client Management - Client managed by refer to T24 FSD section 6.5.3
Individual - Marital Status
Individual - Country of birth refer to T24 FSD section 6.5.7.1
Insider - Is trading shares
APAC External Finder - Finder CIF number
APAC External Finder - Contract type
APAC Client Referral - Referred by
BLANK FIELD
APAC Client Referral - Internal referee PID
APAC Client Referral - Intermediary CIF numberAPAC Client Management - Client managed by refer to T24 FSD section 6.5.3 APAC Client Management - Client managed by refer to T24 FSD section 6.5.3 APAC Client Management - Branch of EAM CIF
APAC Client Management - EAM CIF numberAPAC Client Management - EAM pricing type
APAC Client Management - Identification delegation to EAMAPAC Client Management - Send to Quartal for RetroAPAC Client Management - EAM BIC code
KYCProfilePartner - Is PEP the field "KYCProfileDossier. Is PEP relationship" should be used in this case, refer to T24 FSD section, section 6.5.8
Dossier - Client segmentAPAC Dossier - Client codeCorporate - Company industry
ProfessionalStatus - Employment status FamilyRelative - Type
Individual - GenderOfficial Registered Address - Country
Individual - 2nd Nationality
spelling need to be corrected in catalogue, Partner.Concrete Type of Partner
Individual - Salutation
when popuate to MNEMONIC field, Add "A" infront of the CIF Number
Is it same as STREET.ADDR in mapping sheet?
List is different based on location,e.g. KYC SG value should be mapped to SG T24 SECTOR list
BLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELD
Is this field is EAM.SSTS in mapping sheet? Yes APAC Client Management - EAM Swiss stamp tax
ProfessionalStatus - CS staff ID only AH's CS Sfaff ID
BLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELD
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELD
BLANK FIELD
BLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDBLANK FIELDReply message from T24
T24 response
will be updated to send the PID number
and Credit Officer.
For these fields
separate FUnctionContext Obejects
will be created in Solution and will
be sent to Compone
nts
Addresses can be
pushed to KYC min one and max any number
APAC Client Management - EAM Swiss stamp tax