SuspensePaymentReports
Return a list of advance payment requests for the entire business.
Table Specific Information
SELECT
To get a list of advance payment requests for the entire business, the OfficeId column or the OfficeId connection string parameter is required. If not specified, the OfficeId of the first office from the Offices table will be used.
The 本製品 uses the Money Forward Expense APIs to process search criteria that refer to OfficeId and processes other filters client-side within the 本製品. For example, the following query is 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 |