Get Expense Transaction List

get

https://api.data-basics.net/apihub/apis/getExpenseTransactionList

Expense Search Transactions Utility to retrieve expense transactions based on filter query

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

level1Code

string

WBS Level1 Code - Max size 20 Characters

hdrStatus

string

Current Status. The values are R - For Released, H - For Draft/On Hold, Z - Closed, J - Rejected, P - In Approval Process, O - for Opened, A - Approved

attendeeCnt

string

Number of Attendees

level3Code

string

WBS Level3 Code - Max size 20 Characters

rptCurr

string

Report Currency Id

level1Ftext

string

WBS Level1 Name

myGroup

string

Filter based on My Group - D - My Department Approval, P - My Proxy , U - My team approval. No need to provide anything and it retrieve the data based on the filter.

reimbursable

string

Reimbursable - Y - Yes and N - No

level2Ftext

string

WBS Level2 Name

level2Code

string

WBS Level2 Code - Max size 20 Characters

dateTo

string

To Date - Format YYYY-MM-DD

batchId

string

Posted Batch Number

optCode

string

Operation Unit Code - Max size is 20 Characters

emplyId

string

Employee ID

dateFrom

string

From Date - Format YYYY-MM-DD

notPostedTo

string

Not Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

postedTo

string

Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

amtTo

string

Amount Range To - Format ##.00

modifiedDateTo

string

Last Modified Date To. Filters to the date provided and defaults time to 23:59 hours - format YYYY-MM-DD (Available Version 7.5 and up)

amtFrom

string

Amount Range From - Format ##.00

reportId

string

Report Id

countryId

string

Country Id

stateId

string

State Id - Max size 20 Characters

postedFromDate

string

From Posted Date

expCode

string

Expense Code - Max size 20 Characters

reportType

string

Report Type Id

modifiedDateFrom

string

Last Modified Date From. Filters from the date provided and defaults time to 00:00 hours - format YYYY-MM-DD (Available Version 7.5 and up)

level4Code

string

WBS Level4 Code - Max size 20 Characters

currencyFrom

string

Charged Currency Code

groupTitle

string

Itemized Charge Group Title

deptCode

string

Department Code

placeId

string

Place Id - Max size 20 Characters

jobTitle

string

Employee Job Title

postedToDate

string

To Posted Date

fileAttachment

string

File Attached - Y - Yes and N - No file attached

custfieldCnt

string

Additional Fields Linked to this charge

expType

string

Expense Type Id

payId

string

Payment Type Id

limit

integer

Return number of records per page. Default page size is 20 rows. If you want to run 100 rows per page set it to 100. Max is 1000 per page.

start

integer

Start defines which record to begin from in the response. If the response has 20 records and you only want to return the last 10, then set the start equal to 9 to only return records 10 through 20.

Response

200successful operation