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 | |||