ExpenseReportUnits

Returns a list of expense summaries.

Table Specific Information

SELECT

To get a list of expense summaries, 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 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.

Cmdlets for Money Forward Expense

ExpenseReportUnits

Table Specific Information

SELECT

Columns