SingleView statements API service allows you to fetch account statements for one or more ERP-linked accounts in RAW MT940 format or parsed JSON format for a given date range. This allows you to generate, retrieve, and manage financial statements seamlessly within your ERP systems.

❗️
Important information

type parameter should be mentioned as JSON or RAW

If no input is provided, the system will fetch the statement in default JSON format

Endpoint details

Endpoint URL	Method	Authentication requirements
`/v1/api/erp/svStmtServiceRQ`	POST	`clientid` `clientsecret` `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": "1234",
  "company": [
    {
      "companyCode": "MYCOMPANY",
      "userName": "12345",
      "statement": [
        {
          "acERPcode": "24567",
          "type": "RAW", // "JSON"
          "fromDate": "2025-03-12T00:00:00",
          "toDate": "2025-03-12T23:59:59"
        }
      ]
    }
  ]
}
}'

Request description

JSON Tag	Description	Data Type
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	String
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 Characters	Alphanumerical
type Optional	Type of statement output to be mentioned as `JSON` or `RAW`	String
fromDate Mandatory	Starting date of the statement in ISO 8601 date format	Date
toDate Mandatory	Ending date of the statement in ISO 8601 date format	Date

Sample response

{
  "svStmtServiceRS": {
    "company": [
      {
        "companyCode": "MYCOMPANY",
        "userName": "12345",
        "statement": [
          {
            "acERPcode": "24567",
            "Transactions": {
              "StatusCode": "OK",
              "StatusDetail": "N/A",
              "TransactionType": "940",
              "SequenceNum": "0",
              "AccountNumber": "2011682739940",
              "ReceiptTime": "2025-05-21T09:05:58",
              "ProcessStatus": "1",
              "TransactionData": {
                "UniqueReference": "MT940-2105202501",
                "RelatedReferenceNumber": "",
                "AccountNumber": "2011682739940",
                "StatementNo": "071/0001",
                "TransactionTime": "",
                "CurrencyAmountCode": "",
                "OpeningBalance": {
                  "DCMark": "C",
                  "Date": "250312",
                  "Currency": "SAR",
                  "Amount": 8958833079.4
                },
                "TransactionDetails": [
                  {
                    "ValueDate": "250312",
                    "EntryDate": "0312",
                    "DCMark": "D",
                    "FundsCode": "NA",
                    "Amount": 484.25,
                    "PostingTime": "",
                    "TransactionType": "N",
                    "IdentificationCode": "TRF",
                    "AccountOwnerReference": "2025031200001080",
                    "BankReference": "4250312120633610",
                    "Description": "OUTGOING TRANSFER",
                    "SourceAccount": "Source_Account",
                    "SourceID": "Source_ID",
                    "SourceAccountName": "Source_Account_Name",
                    "CardType": "Card_Type",
                    "BillerId": "",
                    "Category": "Local Transfer",
                    "ExRate": "",
                    "VirtualAccount": "SA2017134859632587562269"
                  }
                ],
                "ClosingBalance": {
                  "DCMark": "C",
                  "Date": "250312",
                  "Currency": "SAR",
                  "Amount": 8958824774.89
                },
                "ClosingAvailableBalance": {
                  "DCMark": "C",
                  "Date": "250312",
                  "Currency": "SAR",
                  "Amount": "8958824774.89"
                },
                "Comment": "Comments",
                "TotalNumberOfDebits": "10",
                "TotalNumberOfCredits": "12"
              }
            }
          }
        ]
      }
    ]
  }
}

{
  "svStmtServiceRS": {
    "company": [
      {
        "companyCode": "MYCOMPANY",
        "userName": "12345",
        "statement": [
          {
            "acERPcode": "24567",
            "RawStatement": "<?xml version='1.0' encoding='UTF-8'?>\n<PaymentInfoMessageResponse>\n  <PaymentInfoResponse>\n    <TransactionType>940</TransactionType>\n    <SequenceNum>0</SequenceNum>\n    <ReceiptTime>2025-05-21T09:05:57</ReceiptTime>\n    <ProcessStatus>1</ProcessStatus>\n    <Comment>N/A</Comment>\n    <TransactionData>:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0001\n:60F:C250312SAR8958833079,40\n:61:2503120312C0,00NCHG2507108414884000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507108435211000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507108454703000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507109490410000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507110081818000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507110332162000//NONREF\n:86:UTILITY BILL PAYMENT\n:62M:C250312SAR8958833079,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0002\n:60M:C250312SAR8958833079,40\n:61:2503120312C0,00NCHG2507110384639000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507111460008000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507111514908000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507111561869000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507112052665000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507112105792000//NONREF\n:86:UTILITY BILL PAYMENT\n:62M:C250312SAR8958833079,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0003\n:60M:C250312SAR8958833079,40\n:61:2503120312C0,00NCHG2507112211815000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312C0,00NCHG2507112434496000//NONREF\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG3031662//2507108040823000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG33642523//2507108414754000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG26230267//2507108435075000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG85928143//2507108454608000\n:86:UTILITY BILL PAYMENT\n:62M:C250312SAR8958832479,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0004\n:60M:C250312SAR8958832479,40\n:61:2503120312D150,00NCHG37621482//2507109490208000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG96999889//2507110081693000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG5605413//2507110331982000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG74242641//2507110370674000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG30744869//2507110384475000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG89950483//2507111455867000\n:86:UTILITY BILL PAYMENT\n:62M:C250312SAR8958831579,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0005\n:60M:C250312SAR8958831579,40\n:61:2503120312D150,00NCHG90563033//2507111514795000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG47771634//2507111561683000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG41413520//2507112052395000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG10817371//2507112105603000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG56253454//2507112211685000\n:86:UTILITY BILL PAYMENT\n:61:2503120312D150,00NCHG91912131//2507112434435000\n:86:UTILITY BILL PAYMENT\n:62M:C250312SAR8958830679,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0006\n:60M:C250312SAR8958830679,40\n:61:2503120312D310,00NTRF0000000009997794//4250312080407190\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000035137272//4250312084147632\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000075720556//4250312084350644\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000016579856//4250312084545653\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000078361857//4250312094901306\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000005926956//4250312100817629\n:86:OUTGOING TRANSFER\n:62M:C250312SAR8958828819,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0007\n:60M:C250312SAR8958828819,40\n:61:2503120312D310,00NTRF0000000011457112//4250312103319890\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000071023840//4250312103706909\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000036681166//4250312103844912\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000083183192//4250312114558409\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000060595956//4250312115147439\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000086996965//4250312115616447\n:86:OUTGOING TRANSFER\n:62M:C250312SAR8958826959,40\n-\n:20:MT940-2105202501\n:25:2011682739940\n:28C:071/0008\n:60M:C250312SAR8958826959,40\n:61:2503120312D310,00NTRF0000000066598348//4250312120523604\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000043562093//4250312121055638\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000058102371//4250312122116730\n:86:OUTGOING TRANSFER\n:61:2503120312D310,00NTRF0000000012626672//4250312124343864\n:86:OUTGOING TRANSFER\n:61:2503120312D460,26NTRF2025031200001079//4250312115824459\n:86:OUTGOING TRANSFER\n:61:2503120312D484,25NTRF2025031200001080//4250312120633610\n:86:OUTGOING TRANSFER\n:62F:C250312SAR8958824774,89\n-\n</TransactionData>\n    <CompanyCode>UMGAT001</CompanyCode>\n  </PaymentInfoResponse>\n  <StatusCode>OK</StatusCode>\n  <StatusDetail>OK</StatusDetail>\n  <ResponseItemCount>1</ResponseItemCount>\n</PaymentInfoMessageResponse>"
          }
        ]
      }
    ]
  }
}

Response description

JSON Tag	Description	Data Type
svStmtServiceRS	Tag carrying information on process response for statement services	Object
company	Tag carrying information on company	Object
companyCode	Unique company identification code	String
userName	Unique username	String
statement	Tag carrying information on acquired statement	Object
acERPcode	Unique ERP account code	Alphanumeric
RawStatement	Information on fetched transactions in raw format	String
Transactions	Tag carrying information on fetched transactions for JSON statement	Object
StatusCode	Specific transaction's status displayed via code	Numerical
StatusDetail	Specific transaction's status details	String
TransactionType	Information on type of the transaction	String
SequenceNum	Sequence number of the transaction	Numerical
AccountNumber	Unique account identification	String
ReceiptTime	Time of the transaction reciept	String
ProcessStatus	Details on process status	String
TransactionData	Tag carrying data for the specific transaction	Object
UniqueReference	Unique transaction reference	String
RelatedReferenceNumber	Related transaction reference number	Numerical
AccountNumber	Transaction account number	String
StatementNo	Unique statement number	String
TransactionTime	Time of the transaction	String
CurrencyAmountCode	Unique code representing the currency amount	String
OpeningBalance	Tag carrying information on opening balance during the transaction	Object
DCMark	DC mark of the transaction	String
Date	Date of the opening balance	String
Currency	Currency in which the opening balance is displayed	String
Amount	Amount representing the opening balance	Numerical
TransactionDetails	Tag carrying information on transaction details	Object
ValueDate	Date of the transaction	String
EntryDate	Date of the transaction creation/initiation	String
DCMark	DC mark of the transaction	String
FundsCode	Code indicating the funds	String
Amount	Transaction amount	Numerical
PostingTime	Time of posting the transaction	String
TransactionType	Type of the transaction	String
IdentificationCode	Unique identification code of the transaction type	String
AccountOwnerReference	Account owner reference details	String
BankReference	Bank reference details	String
Description	Description of the transaction	String
SourceAccount	Source account used for the transaction	String
SourceID	Unique source identification for the transaction	String
SourceAccountName	Source account name used for the transaction	String
CardType	Details about card type	String
BillerId	Unique biller identification details for the transaction	String
Category	Category of the transaction	String
ExRate	Exchange rate for the transaction amount	String
ClosingBalance	Tag carrying information on closing balance of the account during the transaction	Object
DCMark	DC mark information during the transaction	String
Date	Date of the closing balance during the transaction	String
Currency	Currency representing the closing balance	String
Amount	Amount representing the closing balance	Numerical
ClosingAvailableBalance	Tag carrying information on closing balance during the response creation	Object
DCMark	DC mark information during the transaction	String
Date	Date of the closing balance during the transaction	String
Currency	Currency representing the closing balance	String
Amount	Amount representing the closing balance	Numerical
Comment	Additional information about the transaction	String
TotalNumberOfDebits	Total number of debits occurred during the mentioned transaction period	String
TotalNumberOfCredits	Total number of credits occurred during the mentioned transaction period	String