11.4 Simulation File Upload

This topic describes the information about the various file upload for simulation.

Simulation for new prospect requires the following file uploads to simulate the structure.

File Type Supported: CSV & TXT

Customer Data

Customer Data Template:

LMPROSPECT~CustomerID~CustomerName~BranchCode~BankCode~ParentCustomerID~Address~Source_Customer_ID~Source_System~Short_Name~Customer_Type~Customer_Category~Relationship_Manager_ID~Address_Line_1~Address_Line_2~Address_Line_3~Address_Line_4~Country~Postal_Code~Deceased~Frozen~Whereabouts_Unkown~Sanction_Check_Required~Walk-in Customer~Language~Nationality~LMPROSPECT

Sample:

LMPROSPECT~P0001~TATAGROUP~APQ~0020~P0001~ADDR1~P0001~OBLMUI~TATAGROUP~I~~BIBILU~ADDR1~ADDR2~ADDR3~ADDR4~USA~~N~N~N~N~N~ENG~USA~LMPROSPECT

Account Data

Account Data Template:

LMSIACCOUNT~AccountNumber~CustomerName~CustomerId~AccountDescription~AccountResidentType~Accountstatus~AccountType~ExternalAccount~Currency~IBAN~BranchID~BranchDescription~AllowUnlimitedDebit~Account_category~CurrentBalance~LastUpdatedOn~NotionalPooling~Source_Customer_Account~Address_Line_1~Address_Line_2~Address_Line-3~Address-Line_4~Country~No_Credit~NoDebit~Blocked~Frozen~Dormant~ExternalCreditApproval_Required~ExternalCreditApprovalSystem~Host_Code~Account_Open_Date~Account_Class~Group_Code~LMSIACCOUNT

Sample:

LMSIACCOUNT~ACUSD0001~TATAGROUP~P0001~Tataaccount01~R~A~S~Internal~GBP~0000~APQ~DEB BRANCH~Y~S~0~2018-11-30~N~ACUSD0001~addr1~aadr2~addr3~addr4 ~USA~N~N~N~N~N~N~HOST1~FCUBS~2021-04-01~~~LMSIACCOUNT

Account Balance

Account Balance Template:

LMSIVDBALANCE~ACC_NO~CCY~BRANCH_CODE~ACY_AVL_BAL~VALUE_DT~LMSIVDBALANCE

Sample:

LMSIVDBALANCE~ACUSD0001~GBP~APQ~1000~2021-04-22~LMSIVDBALANCE