Gets the transaction facts. Run in API Explorer
This request should be used to retrieve transaction details including amounts, dates, who added the item, when it was added as well as the status for the specified transaction and account in the fiscal period for the selected engagement(s). This would be information that is found on the transactions on a given account under the Accounts and Status tab.
Query parameters
-
possible values : Current or 0 - Current period for filtered engagement(s), LastThree or 1(Default option) - Last three periods for filtered engagement(s), LastThirteen or 13 - Last thirteen periods for filtered engagement(s), LastTwentyFive or 25 - Last twenty five periods for filtered engagement(s), All or 99
-
Short Guid of desired engagement Ex - ESXmkya-nEeWMX-7_3fSxA or Guid of desired engagement Ex - 45c31339-96d0-4262-b051-c00f392685c1
curl \
--request GET 'https://analyticsapi.adra.com/balancer/api/TransactionFacts' \
--user "username:password"
[
{
"Text": "Fedex charges for package 002",
"Amount": 2000.0,
"AgeDays": 1261,
"AgeGroup": "90 Days or Older",
"Currency": 73,
"AmountABS": 2001.0,
"Period_Key": 4123,
"Account_Key": 5234,
"BoookingDate": "2022-12-06T08:23:18.919Z",
"CurrencyName": "Dollar",
"CurrencyRate": 167.25,
"AccountStatus": "Approved",
"AccountBalance": 2011.0,
"EngagementGuid": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"Engagement_Key": 1987,
"ItemAddedByName": "Hex David",
"ItemCreatedDate": "2022-12-06T08:23:18.919Z",
"LegalEntity_Key": 2876,
"TransactionType": "Bank transaction",
"Transaction_Key": 3765,
"TransactionAmount": 12.0,
"TransactionStatus": "Not Set",
"AccountIsFinalized": "False",
"CountOfAttachments": 0,
"ItemAddedByUsername": "abd@99x.io",
"AccountIsCarriedForward": "False",
"AccountBalanceEngagement": 2011.0,
"AccountUnidentifiedBalance": 0.0,
"ReferenceOverJournalNumber": "FED no: 000200562",
"AccountPeriodTransaction_Key": 1234,
"AccountUnidentifiedBalanceEngagement": 0.0
}
]