null

View-Specific Information

SELECT

To get a list of all the departments of an office, the OfficeId column or the OfficeId connection string parameter is required. If not specified, the OfficeId of the first office from the Offices table is used.

The connector uses the Money Forward Expense APIs to process search criteria that refer to OfficeId or Id, and processes other filters client-side within the connector.

The following queries are processed server-side:

SELECT * FROM MyInvoiceReport

SELECT * FROM MyInvoiceReport WHERE Id='4cKGxwmME6arj27P1TY9Lw'

Columns

Name	Type	Description
Id [KEY]	String	id
CreatedAt	Datetime
OfficeId [KEY]	String	The office id
ApprovedAt	Datetime
Number	String
SubmittedAt	Datetime
Status	String
UpdatedAt	Datetime
Title	String
OfficeMemberId	String	OfficeMemberId
NumberWithoutPrefix	String	number_without_prefix
ReportApprovals	String	Report Approvals