Returns a list of expense summaries.

View-Specific Information

SELECT

To get a list of all of an office's expense 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 listed in 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 ExpenseReportUnits
SELECT * FROM ExpenseReportUnits WHERE OfficeId='X3r3q7IVSy4Vcj8GGZsQ1Q'
SELECT * FROM ExpenseReportUnits WHERE Id='12345'

Columns

Name	Type	Description
Id [KEY]	String	The expense report unit Id.
OfficeId	String	The office id.
PaymentDate	Date	The payment date.
UpdatedAt	Datetime	The date when the expense report unit was last updated.
ExOfficeAccountNumber	String	The ex office account number.
Number	Int	The expense report unit number.
Title	String	The expense report unit title.
CreatedAt	Datetime	The date when the expense report unit was created.
ExOfficeAccountBankBranchName	String	The ex office account bank branch name.
ExOfficeAccountBankBranchNameKana	String	The ex office account bank branch name kana.
ExOfficeAccountBankBranchCode	String	The ex office account bank branch code.
ExOfficeAccountBankName	String	The ex office account bank name.
ExOfficeAccountBankNameKana	String	The ex office account bank name kana.
ExOfficeAccountBankCode	String	The ex office account bank code.
ExOfficeAccountHolderName	String	The ex office account holder name.
ExOfficeAccountId	String	The ex office account Id.
ExOfficeAccountAccountType	Int	The ex office account type.
ExOfficeAccountHolderNameKana	String	The ex office account holder name kana.