| View Name: | sp_order_actions_v |
| View Number: | 5801 |
| Group: | Morder |
| Description: | Gets orders assigned to site part. Used in site_part_orders_search.jsp page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | site_part | objid | Site_part internal record number | 3 (UNIQUE) |
| order_act_objid | order_action | objid | Order action internal record number | |
| order_objid | contract | objid | Order internal record number | |
| order_id | contract | id | Order ID number | |
| order_date | contract | start_date | Order placement date | |
| action | order_action | name | Name of action for presentation of order |
| Join From | Join To |
|---|---|
| (order_action).order_action_svc2site_part | (site_part).site_part_svc2order_action |
| (order_action).order_action2contract | (contract).contract2order_action |
| sp_order_actions_v | |||