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 InvoiceReports

SELECT * FROM InvoiceReports 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	unsubmitted: 下書き, waiting_step_one: 第一承認待ち, waiting_step_two: 第二承認待ち, waiting_step_three: 第三承認待ち, waiting_step_four: 第四承認待ち, waiting_step_five: 第五承認待ち, approved: 承認済み, canceled: 取消済み, rejected: 却下済み
UpdatedAt	Datetime	更新日時
Title	String	タイトル
OfficeMemberId	String	従業員Id
NumberWithoutPrefix	String	number_without_prefix
ReportApprovals	String	Report Approvals