Get transaction statements using API services
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.
type parameter should be mentioned as JSON or RAWJSON formatEndpoint URL | Method | Authentication requirements |
|---|---|---|
| POST |
|
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 | Type of statement output to be mentioned as | 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 |
{
"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"
}
}
}
]
}
]
}
}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 |