| View Name: | order_modify_v |
| View Number: | 5787 |
| Group: | Morder |
| Description: | Shows the status of all order_line records for the order. Used in order_modify_list.jsp page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | order_line | objid | Line Order internal record number | 3 (UNIQUE) |
| order_objid | contract | objid | Order internal record number | |
| con_objid | contact | objid | Contact internal record number | |
| order_id | contract | id | Order ID number | |
| contact_fname | contact | first_name | Contact's first name | |
| contact_lname | contact | last_name | Contact's last name | |
| action | part_action | name | Name of action that can be performed on product | |
| service | part_num | description | Description of service | |
| status | order_line | status | Status of shipping to this shipping destination. Populated through a user defined popup list |
| Join From | Join To |
|---|---|
| (order_line).order_line2order_action | (order_action).order_action2order_line |
| (order_action).order_action2contract | (contract).contract2order_action |
| (order_action).order_action2part_action | (part_action).part_action2order_action |
| (order_action).order_action2contact | (contact).contact2order_action |
| (order_line).order_line2offr_prod | (offr_prod).offr_prod2order_line |
| (offr_prod).offr_prod2price_qty | (price_qty).price_qty2offr_prod |
| (price_qty).priced_part2mod_level | (mod_level).priced_part2price_qty |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| order_modify_v | |||