cost_reimbursable_billable_transactions
Summarize undistributed cost-reimbursable billable transactions per project, returning total billable amounts and earliest/latest accounting dates. Filter by business unit, project, and date range.
Instructions
Summarize undistributed cost-reimbursable billable transactions
(PROJ_RESOURCE rows with ANALYSIS_TYPE = 'BIL' and
BI_DISTRIB_STATUS = 'N', i.e. billable but not yet distributed).
For each project, returns the summed BIL amount and the earliest/
latest accounting date in the matched transactions.
:param business_unit: Optional business unit code (e.g., 'UCD', 'UCB')
:param project_id: Optional project ID
:param begin_dt: Optional accounting date lower bound, inclusive (YYYY-MM-DD)
:param end_dt: Optional accounting date upper bound, inclusive (YYYY-MM-DD)
:return: Per-project sums of billable amounts with min/max accounting dates
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_dt | No | ||
| begin_dt | No | ||
| project_id | No | ||
| business_unit | No |