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