Cash Flow Report

The Cash Flow Report shows cash flow detail for each contributing account, transaction, and day. It contains the cash flow category and section (operating, investing, or financing) for each transaction line.

Column reference

Column	Type	Description
tenant_id	NUMBER(38,0)	R365 internal tenant identifier
location_id	VARCHAR	Location identifier for this leg
gl_account_id	VARCHAR	GL account identifier for this leg
transaction_id	VARCHAR	Transaction identifier this leg belongs to
approval_status	NUMBER(38,0)	Approval status of the transaction: 1 is unapproved and 2 is approved. The report includes both. Filter this column to select only approved transactions.
transaction_date	DATE	GL posting date of the transaction
account_number	VARCHAR	GL account number
account_name	VARCHAR	GL account name
cash_flow_category	NUMBER(38,0)	The GL account's cash flow category code, such as 100 for net income, 400 for the cash account category, 420 for the EBITDA interest and taxes add-back, 110 for depreciation and amortization add-back, and 115 for gain or loss on sale of assets.
cash_flow_category_name	VARCHAR	Human-readable cash flow category name
section	VARCHAR	Operating, Investing or Financing for the categories that form cash flow statement lines. Category 420 is EBITDA, category 400 is Cash Account, and category 0 is empty.
is_financial_report	BOOLEAN	True if this account is a profit and loss (income statement) account.
is_sale_of_assets_transaction	BOOLEAN	True if any leg of this transaction posts to a Gain/Loss on Sale of Assets account
debit_amount	NUMBER(38,4)	Debit amount contributed by this leg
credit_amount	NUMBER(38,4)	Credit amount contributed by this leg
cash_flow_amount	NUMBER(38,4)	Sign-adjusted amount for a cash flow statement line. Meaningful only when the cash flow category is not 0, 400, or 420. For net income and cash balance, use the debit amount and credit amount columns directly.