Get Vendor Payment Search List

get

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

Vendor Payment Utility to retrieve Vendor Payment Reports based on filter query

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

vInvoiceno

string

Vendor Invoice Number

approver

string

Approver ID

level2Ftext

string

WBS Level 2 Name

nLast

string

Last Name

vendorId

string

Vendor Id - Max size 20 Characters

vState

string

Vendor State

reportType

string

Report Type Id

level1Ftext

string

WBS Level1 Name

level1Code

string

WBS Level1 Code - Max size 20 Characters

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

vName

string

Vendor Name

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

dateTo

string

To Date - Format YYYY-MM-DD

emplyId

string

Employee ID

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

vCity

string

Vendor City

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)

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)

nFirst

string

First Name

batchId

string

Posted Batch Number

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.

vZipcode

string

Vendor Zip Code

vAddress1

string

Vendor Address 1

optCode

string

Operation Unit Code - Max size is 20 Characters

deptCode

string

Department Code

locationCode

string

Location Code - Max size 20 Characters

vCountry

string

Vendor Country

emplyType

string

Employee Type ID

fileAttachment

string

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

reportCurrency

string

Report Currency ID

dateFrom

string

From Date - Format YYYY-MM-DD

prevStatus

string

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

validationStatus

string

Validation Status - X - No validation available, V - Passed with warnings, R Passed and I - Failed

level2Code

string

WBS Level2 Code - Max size 20 Characters

reportId

integer

Report 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