Statements

Get transaction statements using API services

SingleView APIs allows you to generate, retrieve, and manage financial statements seamlessly within your ERP systems.

Endpoint details

Endpoint URL

Method

Authentication requirements

/v1/api/erp/svStmtServiceRQ

POST

1/. clientid
2. clientsecret
3. signature

Get Statement Services

Sample request

curl --location --request POST 'https://servicesuat.onesingleview.com/v1/api/erp/svStmtServiceRQ' \
--header 'clientid: Enter_Client_ID' \
--header 'clientsecret: Enter_Client_Secret' \
--header 'signature: Enter_Signature' \
--header 'Content-Type: application/json' \
--data-raw '{
"svStmtServiceRQ": {
  "groupCode": "Enter_Group_Code",
  "company": [
    {
      "companyCode": "Enter_Company_Code",
      "userName": "Enter_Username",
      "statement": [
        {
          "acERPcode": "Enter_Account_ERP_Code",
          "fromDate": "YYYY-MM-DD",
          "toDate": "YYYY-MM-DD"
        }
      ]
    }
  ]
}
}'

Request description

JSON Tag

Description

Data Type

clientid Mandatory

Unique client identification details

  • Length of input:
    Min 3 Characters
    Max 20 Characters_

String

clientsecret
Mandatory

Unique client secret code

  • Length of input:
    Min 3 Characters
    Max 20 Characters_

String

signature
Mandatory

64-Bit string obtained by processing client signature key through Base-64 and SHA-256

String

svStmtServiceRQ
Mandatory

Tag carrying information on request to generate statement

Object

groupCode
Mandatory

Unique group identification code

  • Length of input:
    Min 3 Characters
    Max 20 Characters_

Numerical

company
Mandatory

Tag carrying information about company

Object

companyCode
Mandatory

Unique company identification code

  • Length of input:
    Min 3 Characters
    Max 20 Characters_

Numerical

userName
Mandatory

Unique user identification name

  • Length of input:
    Min 3 Characters
    Max 20 Characters_

String

statement
Mandatory

Tag carrying information on account statement request

Object

acERPcode
Mandatory

Unique account ERP identification code
Min: 9 Digits

Numerical

fromDate
Mandatory

Starting date of the statement in YYYY-MM-DD format

Date

toDate
Mandatory

Ending date of the statement in YYYY-MM-DD format

Date

Sample response

{
  "svStmtServiceRS": {
    "company": [
      {
        "companyCode": "Company_Code",
        "userName": "Username",
        "statement": [
          {
            "acERPcode": "Account_ERP_Code",
            "Transactions": {
              "StatusCode": "Transaction_Status_Code",
              "StatusDetail": "Transaction_Status_Detail",
              "TransactionType": "Type_of_Transaction",
              "SequenceNum": "Squence_Number",
              "AccountNumber": "Account_Number",
              "ReceiptTime": "Receipt_Time",
              "ProcessStatus": "Process_Status",
              "TransactionData": {
                "UniqueReference": "Unique_Transaction_Reference",
                "RelatedReferenceNumber": "Related_Transaction_Reference_Number",
                "AccountNumber": "Account_Number",
                "StatementNo": "Statement_Number",
                "TransactionTime": "Transaction_Time",
                "CurrencyAmountCode": "Currency_Amount_Code",
                "OpeningBalance": {
                  "DCMark": "DC_Mark",
                  "Date": "Date",
                  "Currency": "Currency",
                  "Amount": "Amount"
                },
                "TransactionDetails": [
                  {
                    "ValueDate": "Value_Date",
                    "EntryDate": "Entry_Date",
                    "DCMark": "DC_Mark",
                    "FundsCode": "Funds_Code",
                    "Amount": 00000,
                    "PostingTime": "Posting_Time",
                    "TransactionType": "Transaction_Type",
                    "IdentificationCode": "ID_Code",
                    "AccountOwnerReference": "Owner_Account_Reference",
                    "BankReference": "Bank_Reference",
                    "Description": "Transaction_Description",
                    "SourceAccount": "Source_Account",
                    "SourceID": "Source_ID",
                    "SourceAccountName": "Source_Account_Name",
                    "CardType": "Card_Type",
                    "BillerId": "",
                    "Category": "Local Transfer",
                    "ExRate": "",
                    "VirtualAccount": "SA2017134859632587562269"
                  }
                ],
                "ClosingBalance": {
                  "DCMark": "DC_Mark",
                  "Date": "Date",
                  "Currency": "Currency",
                  "Amount": "Amount"
                },
                "ClosingAvailableBalance": {
                  "DCMark": "DC_Mark",
                  "Date": "Date",
                  "Currency": "Currency",
                  "Amount": "Amount"
                },
                "Comment": "",
                "TotalNumberOfDebits": "Number_of_Debits_In_Statement",
                "TotalNumberOfCredits": "Number_of_Credits_In_Statement"
              }
            }
          }
        ]
      }
    ]
  }
}

Response description

JSON TagDescriptionData Type
svStmtServiceRSTag carrying information on process response for statement servicesObject
companyTag carrying information on companyObject
companyCodeUnique company identification codeNumerical
userNameUnique usernameString
statementTag carrying information on acquired statementObject
acERPcodeUnique ERP account codeNumerical
TransactionsTag carrying information on fetched transactionsObject
StatusCodeSpecific transaction's status displayed via codeNumerical
StatusDetailSpecific transaction's status detailsString
TransactionTypeInformation on type of the transactionString
SequenceNumSequence number of the transactionNumerical
AccountNumberUnique account identificationString
ReceiptTimeTime of the transaction recieptString
ProcessStatusDetails on process statusString
TransactionDataTag carrying data for the specific transactionObject
UniqueReferenceUnique transaction referenceString
RelatedReferenceNumberRelated transaction reference numberNumerical
AccountNumberTransaction account numberString
StatementNoUnique statement numberString
TransactionTimeTime of the transactionString
CurrencyAmountCodeUnique code representing the currency amountString
OpeningBalanceTag carrying information on opening balance during the transactionObject
DCMarkDC mark of the transactionString
DateDate of the opening balanceString
CurrencyCurrency in which the opening balance is displayedString
AmountAmount representing the opening balanceNumerical
TransactionDetailsTag carrying information on transaction detailsObject
ValueDateDate of the transactionString
EntryDateDate of the transaction creation/initiationString
DCMarkDC mark of the transactionString
FundsCodeCode indicating the fundsString
AmountTransaction amountNumerical
PostingTimeTime of posting the transactionString
TransactionTypeType of the transactionString
IdentificationCodeUnique identification code of the transaction typeString
AccountOwnerReferenceAccount owner reference detailsString
BankReferenceBank reference detailsString
DescriptionDescription of the transactionString
SourceAccountSource account used for the transactionString
SourceIDUnique source identification for the transactionString
SourceAccountNameSource account name used for the transactionString
CardTypeDetails about card typeString
BillerIdUnique biller identification details for the transactionString
CategoryCategory of the transactionString
ExRateExchange rate for the transaction amountString
ClosingBalanceTag carrying information on closing balance of the account during the transactionObject
DCMarkDC mark information during the transactionString
DateDate of the closing balance during the transactionString
CurrencyCurrency representing the closing balanceString
AmountAmount representing the closing balanceNumerical
ClosingAvailableBalanceTag carrying information on closing balance during the response creationObject
DCMarkDC mark information during the transactionString
DateDate of the closing balance during the transactionString
CurrencyCurrency representing the closing balanceString
AmountAmount representing the closing balanceNumerical
CommentAdditional information about the transactionString
TotalNumberOfDebitsTotal number of debits occurred during the mentioned transaction periodString
TotalNumberOfCreditsTotal number of credits occurred during the mentioned transaction periodString