| View Name: | sp_order_line_actions_v |
| View Number: | 5798 |
| Group: | Morder |
| Description: | Gets orders assigned to site part through order_line table. Used in site_part_orders_search.jsp page. Reserved, obsolete |
| 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_line_objid | order_line | objid | Order_line internal record number | |
| order_objid | contract | objid | Order internal record number | |
| order_id | contract | id | Order ID number | |
| order_date | contract | start_date | Order start date | |
| action | order_action | name | Name of action for presentation of order |
| Join From | Join To |
|---|---|
| (site_part).site_part2order_line | (order_line).order_line2site_part |
| (order_line).order_line2order_action | (order_action).order_action2order_line |
| (order_action).order_action2contract | (contract).contract2order_action |
| sp_order_line_actions_v | |||