Transaction Data File
You can upload a transaction data file in the following formats:
-
Comma Separated Values
-
JavaScript Object Notation
-
Fixed Position
-
Pipe Separated Values
-
Tilde Separated Values
-
Extensible Markup Language
Before uploading a transaction data file, you need to ensure that it contains the following:
-
File Header - Every file must have one header record. It should contain the following details:
Header Data Description Mandatory (Yes or No) Transaction Source Used to specify the source from where the transactions are received. Yes Header Date (YYYYMMDD) Used to specify the header date. Yes Transaction Header ID Used to specify the external transaction header ID. Yes File Name Used to specify the file name. Yes Number of Transactions Used to specify the total number of transaction records in the file. Yes Total Transaction Volume Used to specify the total transaction volume. Yes Total Transaction Amount Used to specify the total transaction amount. Yes -
Transaction Record - Every file must have one or more transaction records. It should contain the following details:
Record Data Description Mandatory (Yes or No) Transaction Record Type Used to specify the record type of the transaction. Yes Transaction Source Used to specify the source from where the transaction is received. Yes Transaction Date (YYYYMMDD) Used to specify the date when the transaction was performed. Yes External Reference Number Used to specify the external reference number of the transaction. Yes Customer Reference Number Used to indicate the customer who has performed the transaction. No Division Used to specify the division to which the transaction belongs. Yes Transaction Volume Used to specify the transaction volume. Yes Transaction Amount Used to specify the transaction amount. Yes Transaction Currency Used to specify the currency in which the transaction was performed. Note: If you specify a currency other than the pricing currency, the system will do the currency conversion when the appropriate exchange rate is available in the system.Yes Credit/Debit Indicator Used to indicate whether the transaction is a debit or a credit transaction. The valid values are: -
Plus (+)
-
Minus (-)
Yes Account Identifier Type Used to indicate the account identifier type. Yes Account Identifier Used to indicate the account for which the transaction was performed. Yes UDF_NUM_1, UDF_NUM_2, UDF_NUM_3, ..., UDF_NUM_20 Used to specify additional information about the transaction. No UDF_AMT_1, UDF_AMT_2, UDF_AMT_3, ..., UDF_AMT_10 Used to specify additional transaction amount. Yes (Conditional) Note: The UDF_AMT_N is required when the corresponding UDF_CCY_N is specified.UDF_CCY_1, UDF_CCY_2, UDF_CCY_3, ...., UDF_CCY_10 Used to specify additional transaction currency. Note: If you specify a currency other than the pricing currency, the system will do the currency conversion when the appropriate exchange rate is available in the system.Yes (Conditional) Note: The UDF_CCY_N is required when the corresponding UDF_AMT_N is specified.UDF_DTTM_1, UDF_DTTM_2, ...., UDF_DTTM_5 Used to specify additional information about the transaction. No UDF_CHAR_1, UDF_CHAR_2, UDF_CHAR_3, ..., UDF_CHAR_50 Used to specify additional information about the transaction. Note: If the data in these columns will be used for price item parameter mapping, you must not use the equal to (=) and tilde (~) symbols in these columns.No -