Purchase orders with every field of the records each row points at: contract, cost centre, requisition, site, vendor, warehouse.
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
Note:
This is a Foreign Key to asset_contracts.asset_id.
2508012060Note: This is a Primary Key.
20030604015020012020020050200602020020060Note:
This is a Foreign Key to contract_cover.contract_id.
50Note:
This is a Foreign Key to cost_centre_settings.id.
20050200200Note:
This is a Foreign Key to capex_invite_candidates.id.
2003Note:
This is a Foreign Key to asset_cost_to_keep.currency_id.
120Note: This is a Primary Key.
2020060Note:
This is a Foreign Key to purchase_recommendations.purchase_requisition_id.
20602002005020020010050Note:
This is a Foreign Key to entry_currencies.for_site_id.
2006020250Note:
This is a Foreign Key to capex_invite_candidates.id.
2002002502004060202006040250Note:
This is a Foreign Key to assignable_vendors.id.
20060Note:
This is a Foreign Key to rfq_quote_comparison.vendor_quote_id.
120602002005020030Note:
This is a Foreign Key to warehouse_settings.id.
200Note:
This is a Foreign Key to asset_maintenance_plans.next_work_order_id.
60250
