| Table Name: | order_line |
| Table Number: | 5770 |
| Group: | Morder |
| Description: | To store each product/service and option ordered for an order_action |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| change_ind | LONG | smallint | DIRECT, ALLOW_NULL | Indicates whether the order_line results in a 1 = Addition, 2 = Loss or 3 = Change of quantity, 4 = Change of status, 5= Change of Attriibutes | Search (1) | |||
| change_qty | LONG | int | DIRECT, ALLOW_NULL | The change to the existing quantity | Search (1) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| last_update | CLK_TIME | datetime | 46 | Date time of last update | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (6) | ||
| quantity | LONG | int | DIRECT | Quantity ordered | Search (1) | |||
| status | CHAR | varchar | 40 | Status of shipping to this shipping destination. Populated through a user defined popup list | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| order_line2offr_prod | MTO | offr_prod | offr_prod2order_line | Offering product that line originated from | Search (4) | ||
| order_line2order_action | MTO | order_action | order_action2order_line | Action that the line belongs to | Search (6) | ||
| order_line2order_line_price | OTM | order_line_price | order_line_price2order_line | Charges associated with this order line. Copied from offering at product negotiation time | |||
| order_line2site_part | OTM | site_part | site_part2order_line | Installed part records originated from this order line | |||
| affected2site_part | MTO | site_part | affected_order_line2site_part | The product/service affected by the change | Search (1) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| a2sp5770 | affected2site_part | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| ol2oa5770 | order_line2order_action | nonclustered located on PRIMARY |
| ol2op5770 | order_line2offr_prod | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5787 | order_modify_v | contact, contract, order_line, part_action, part_num |
| 5798 | sp_order_line_actions_v | contract, order_action, order_line, site_part |
| 5807 | order_line_v | contract, mod_level, offr_prod, order_action, order_line, price_qty |
| 5856 | order_line_parts_v | contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty |
| 6031 | sp_orders_v | bus_org, condition, contact, contract, gbst_elm, order_action, order_line, site_part |
| 6032 | order_line_view | contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty |
| order_line | |||