- Forum
- T24 Technical Discussions
- T42 Data Migration
- account numbers of old customers in DMT for upload
×
Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…
account numbers of old customers in DMT for upload
- jiban
- Topic Author
- Visitor
-
12 years 8 months ago - 12 years 8 months ago #10639
by jiban
account numbers of old customers in DMT for upload was created by jiban
hi all
We randomized check digit('0' to '9') by our own way(using excel functions(char(48+int(rand()*10))) and
After the migration new account numbers opened has been generated as defined in COMPANY,field ACCT.CHECKDIG.TYPE in normal way.
I am not talking about Alternate ID(Old Account Number),we kept the old account number as an alternate ID as it was in legacy system, (defined in ALT.ACCT.PARAMETER and ACCOUNT.PARAMETER).
.
Will there be any problem later?
Is this one of the right way to suffix the checkdigit to the account numbers generated manually in DMT for migrating accounts from old system To T24?
thank you.
jiban
AGRICULTURAL DEVELOPMENT BANK LIMITED
NEPAL
We randomized check digit('0' to '9') by our own way(using excel functions(char(48+int(rand()*10))) and
suffixed randomly generated check digit in manually generated account numbers of old customers in Data Migration Tool(DMT) for uploading old data to T24
at data migration time only.After the migration new account numbers opened has been generated as defined in COMPANY,field ACCT.CHECKDIG.TYPE in normal way.
I am not talking about Alternate ID(Old Account Number),we kept the old account number as an alternate ID as it was in legacy system, (defined in ALT.ACCT.PARAMETER and ACCOUNT.PARAMETER).
.
Will there be any problem later?
Is this one of the right way to suffix the checkdigit to the account numbers generated manually in DMT for migrating accounts from old system To T24?
thank you.
jiban
AGRICULTURAL DEVELOPMENT BANK LIMITED
NEPAL
Last edit: 12 years 8 months ago by jiban. Reason: change the content
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
12 years 8 months ago #10641
by durai611
Replied by durai611 on topic Re: account numbers of old customers in DMT for upload
Hi,
In the help text of Account application, you can find an example of the check digit logic used for account number generation.
If I am not mistaken, check digit validation is done only during input of a new account record. So once after account record is created, hope there won't be any problem.
In the help text of Account application, you can find an example of the check digit logic used for account number generation.
If I am not mistaken, check digit validation is done only during input of a new account record. So once after account record is created, hope there won't be any problem.
The following user(s) said Thank You: jiban
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
12 years 8 months ago #10643
by jpb
Replied by jpb on topic Re: account numbers of old customers in DMT for upload
As mentioned with the old topic the only problem is that the meaning of the check-digit is blasted and that there is no change for "offline-validation" of the account numbers.
E.g. in the UK most all banks publish their check-digit algorithm so that other bank can validate the accounts (what is more or less obsolete when using IBAN).
www.paymentscouncil.org.uk/files/payment...idelines_june_09.pdf
E.g. in the UK most all banks publish their check-digit algorithm so that other bank can validate the accounts (what is more or less obsolete when using IBAN).
www.paymentscouncil.org.uk/files/payment...idelines_june_09.pdf
The following user(s) said Thank You: jiban
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- T42 Data Migration
- account numbers of old customers in DMT for upload
Time to create page: 0.080 seconds