Bulk Upload of Account
Bulk upload of account enables the user to Import multiple account records in batch without needing to use the foreground static data transaction.
Bulk Upload of account can be achieved using Transaction IMPACT in DOKA SAAS
Why Transaction IMPACT ?
This transaction is used to import account data into the database of the application.
The text file to be imported is selected via path and file name and will be imported by clicking the icon.
The log file for this transaction can be displayed by clicking the icon. The log shows information about the updated and added records.
Note: The subdirectory BATIN must exist in the DATA directory of the application. The converted import file has to be in that subdirectory. The structure of the import file depends on each individual environment and has to be clarified between the user and Surecomp DOS.
The file has to be available in ASCII format and has to have a .txt extension.
Import File Requirements
-
Field seperator: The fields have to be seperated by tabulator
-
Fieldsize: All fields must have not more than the in column max. Size specified length
-
Fieldformat: The fields must have the in column Datatype specified format
-
Character set: ASCII
FEILD MAPPING
Fieldname |
Description |
Datatype |
max. Size |
PRI |
Priority for Defaulting |
Text |
1 |
CUR |
Currency |
Text |
3 |
EXTKEY |
Exteral Key |
Text |
34 |
SERACC |
Account Number Defined by Servicing Institute |
Text |
34 |
SERPTY |
Extkey of Servicing Party |
Text |
8 |
HOLACC |
Account Number of Control Account of Holder |
Text |
34 |
HOLPTY |
Extkey of Holder |
Text |
8 |
RMBFLG |
Reimbursement Account Flag |
Text |
1 |
DELFLG |
Deleted Flag |
Text |
1 |
DIRFLG |
Available for |
Text |
1 |
IBAN |
International Bank Account Number |
Text |
34 |
SPADAT |
SEPA Mandate Authorisation Date |
Date |
12 |
SPASRVID |
SEPA Service Id |
Text |
3 |
SPASTA |
SEPA Status |
Text |
4 |
SPAID |
Sepa Mandate ID |
Text |
35 |
SPAPRENOT |
Pre-Notification advance |
Numeric |
2 |
SPASNDPRENOT |
Send Pre-Notification |
Text |
4 |
NAM |
Name |
Text |
40 |
EXTTYP |
External Account Type |
Text |
3 |
TYP |
Account Type |
Text |
3 |
INFTXT |
Text |
Stream |
60 |
Importing of files :
Please follow the below gif and the step mentioned to upload files into the system :
1.Set up the putty configuration as shown
2.Select the file to transferred .Do a drag and drop
3.Execute the command in DOKA .
Comments
0 comments
Please sign in to leave a comment.