Return a list of suspense payment reports across the entire business.

View-Specific Information

SELECT

To get a list of all of a particular office's suspense payment reports, you must provide either its OfficeId column or the relevant OfficeId connection string parameter. If neither of these is specified, the query returns the list based on the OfficeId of the first office from the Offices table.

The 本製品 uses the Money Forward Expense APIs to process search criteria that refer to OfficeId and processes other filters client-side within the 本製品.

The following queries are processed server-side:

SELECT * FROM SuspensePaymentReports
SELECT * FROM SuspensePaymentReports WHERE OfficeId='X3r3q7IVSy4Vcj8GGZsQ1Q'

Columns

Name	Type	Description
Id [KEY]	String	The suspense payment report Id.
OfficeId	String	The office id.
CreatedAt	Datetime	The date when the suspense payment report was created.
ExReportTypeId	String	The ex report type Id.
Title	String	The suspense payment report title.
Status	String	The suspense payment report status.
Number	Int	The suspense payment report number.
ApprovedAt	Datetime	The date when the suspense payment report was approved.
SubmittedAt	Datetime	The date when the suspense payment report was submitted.
UpdatedAt	Datetime	The date when the suspense payment report was updated.
OfficeMemberId	String	The office member Id.
ExReportFormInputs	String	Ex Report Form Inputs
ExReportApprovals	String	Ex Report Approvals