Purchase requisitions with every field of the records each row points at: asset, cost centre, department, maintenance plan, requested by, site, warehouse, work order.
Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose.
Headers
Limiting and Pagination
Limiting and Pagination
Preference
count=none Query Parameters
Filtering Columns
Ordering
Limiting and Pagination
Limiting and Pagination
Response
OK
200200602006080200402002008020025080120502006020200Note:
This is a Foreign Key to asset_contracts.asset_id.
8012060Note: This is a Primary Key.
200Note:
This is a Foreign Key to cost_centre_settings.id.
50200200Note:
This is a Foreign Key to capex_invite_candidates.id.
200320050200200200200Note:
This is a Foreign Key to department_settings.id.
Note:
This is a Foreign Key to asset_cost_to_keep.currency_id.
Note: This is a Primary Key.
200200200406025040150250602002004015050602010200Note:
This is a Foreign Key to maintenance_due.maintenance_plan_id.
250603020Note:
This is a Foreign Key to purchase_recommendations.id.
200200403020060150Note:
This is a Foreign Key to capex_invite_candidates.id.
602002005020020010050Note:
This is a Foreign Key to entry_currencies.for_site_id.
2006020250Note:
This is a Foreign Key to capex_invite_candidates.id.
200602002005020030Note:
This is a Foreign Key to warehouse_settings.id.
200250802002002008030401508020060200506020250200120406040150Note:
This is a Foreign Key to asset_maintenance_plans.next_work_order_id.
60
