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 URLMethodAuthentication requirements
/v1/api/erp/svStmtServiceRQPOST1. 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-DDTHH:MM:SS",
          "toDate": "YYYY-MM-DDTHH:MM:SS"
        }
      ]
    }
  ]
}
}

Request description

JSON TagDescriptionData Type
clientid
Mandatory
Unique client identificationString
clientsecret
Mandatory
Unique client secret keyString
signature
Mandatory
64-Bit encrypted signature codeString
svStmtServiceRQ
Mandatory
Tag carrying information on request to generate statementObject
groupCode
Mandatory
Unique group codeNumerical
company
Mandatory
Tag carrying information about companyObject
companyCode
Mandatory
Unique company codeNumerical
userName
Mandatory
Unique user identification nameString
statement
Mandatory
Tag carrying information on account statement requestObject
acERPcode
Mandatory
Unique account ERP identification codeNumerical
fromDate
Mandatory
Unique customer reference detailsString
toDate
Mandatory
Cap limitString

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"
                  }
                ],
                "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 transactionString
UniqueReferenceUnique transaction referenceString
RelatedReferenceNumberRelated transaction reference numberNumerical
AccountNumberTransaction account numberString
StatementNoUnique statement numberString
TransactionTimeTime of the transactionString
CurrencyAmountCodeUnique code representing the currency amountString
OpeningBalanceOpening balance during the transactionNumerical
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
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