| View Name: | sp_orders_v |
| View Number: | 6031 |
| Group: | Morder |
| Description: | Gets orders assigned to site part through order_line table. 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 | order_line | objid | Site_part internal record number | 3 (UNIQUE) |
| sp_objid | site_part | objid | Site_part internal record number | |
| 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 | |
| order_action | order_action | name | Name of action for presentation of order | |
| expire_date | contract | expire_date | The date the object ends. Where line items are involved, this is the ending service date of the latest line item | |
| account | bus_org | name | Name of the organization | |
| status | gbst_elm | title | Name of the item/element | |
| condition | condition | title | Title of condition | |
| first_name | contact | first_name | Contact's first name | |
| last_name | contact | last_name | Contact's last name | |
| account_objid | bus_org | objid | Internal record number | |
| contact_objid | contact | objid | Internal record number |
| Join From | Join To |
|---|---|
| (order_line).affected2site_part | (site_part).affected_order_line2site_part |
| (order_line).order_line2order_action | (order_action).order_action2order_line |
| (order_action).order_action2contract | (contract).contract2order_action |
| (contract).sell_to2bus_org | (bus_org).buyer2contract |
| (contract).contract2condition | (condition).condition2contract |
| (contract).primary2contact | (contact).primary2contract |
| (contract).status2gbst_elm | (gbst_elm).status2contract |
| sp_orders_v | |||