OrderLines
order_line__v
Columns
| Name | Type | Description |
| ID [KEY] | String | id |
| Order Line Type | String | object_type__v |
| Global ID | String | global_id__sys |
| Link | String | link__sys |
| Order Line Name | String | name__v |
| Status | String | status__v |
| Created By | String | created_by__v |
| Created Date | Datetime | created_date__v |
| Last Modified By | String | modified_by__v |
| Last Modified Date | Datetime | modified_date__v |
| Added From Pack? | Bool | added_from_pack__v |
| Brand Best Rule | String | brand_best_price_rule__v |
| Brand Discount Rule | Double | brand_discount_rule__v |
| Brand Discount | Double | brand_discount__v |
| Brand Warning | String | brand_warning__v |
| Discount Calculation Path | Decimal | discount_calculation_path__v |
| Final Net Price Rule | Decimal | final_net_price_rule__v |
| Final Net Price Rule Corp | Decimal | final_net_price_rule_corpv__sys |
| Local Currency | String | local_currency__sys |
| Final Net Price | Decimal | final_net_price__v |
| Final Net Price Corp | Decimal | final_net_price_corpv__sys |
| Free Good Best Rule | String | free_good_best_price_rule__v |
| Free Goods Rule | Decimal | free_goods_rule__v |
| Free Goods | Decimal | free_goods__v |
| Group Discount Rule | Double | group_discount_rule__v |
| Group Discount | Double | group_discount__v |
| Group Warning | String | group_warning__v |
| Line Best Rule | String | line_best_price_rule__v |
| Line Discount Rule | Double | line_discount_rule__v |
| Line Discount | Double | line_discount__v |
| Line Warning | String | line_warning__v |
| List Amount | Decimal | list_amount__v |
| List Amount Corp | Decimal | list_amount_corpv__sys |
| List Price | Decimal | list_price_rule__v |
| List Price Corp | Decimal | list_price_rule_corpv__sys |
| Mobile ID | String | mobile_id__v |
| Net Amount Rule | Decimal | net_amount_rule__v |
| Net Amount Rule Corp | Decimal | net_amount_rule_corpv__sys |
| Net Amount | Decimal | net_amount__v |
| Net Amount Corp | Decimal | net_amount_corpv__sys |
| Net Price Rule | Decimal | net_price_rule__v |
| Net Price Rule Corp | Decimal | net_price_rule_corpv__sys |
| Net Price | Decimal | net_price__v |
| Net Price Corp | Decimal | net_price_corpv__sys |
| Order Discount Rule | Double | order_discount_rule__v |
| Order Discount | Double | order_discount__v |
| Override Lock | Bool | override_lock__v |
| Payment Brand Rule | String | payment_brand_rule__v |
| Payment Brand | String | payment_brand__v |
| Payment Group Rule | String | payment_group_rule__v |
| Payment Group | String | payment_group__v |
| Payment Rule | String | payment_rule__v |
| Payment | String | payment__v |
| Product Identifier | String | product_identifier__v |
| Profit | Decimal | profit__v |
| Profit Corp | Decimal | profit_corpv__sys |
| Quantity From Pack | Decimal | quantity_from_pack__v |
| Quantity Override | Decimal | quantity_override__v |
| Quantity | Decimal | quantity__v |
| Rule | String | rule__v |
| Suggested Retail Price Rule | Decimal | suggested_retail_price_rule__v |
| Suggested Retail Price Rule Corp | Decimal | suggested_retail_price_rule_corpv__sys |
| Suggested Retail Price | Decimal | suggested_retail_price__v |
| Suggested Retail Price Corp | Decimal | suggested_retail_price_corpv__sys |
| Total Discount Rule | Double | total_discount_rule__v |
| Total Discount | Double | total_discount__v |
| Total Payment Rule | String | total_payment_rule__v |
| Total Payment | String | total_payment__v |
| Unit of Measure | String | u_m__v |
| Recommended Quantity | Decimal | recommended_quantity__v |
| Recommendation Reason | String | recommended_quantity_reason__v |
| Recommendation Used? | Bool | recommended_quantity_used__v |
| Bundle Pack Name | String | bundle_pack_name__v |
| Order | String | order__v |
| Product Group | String | product_group__v |
| Product | String | product__v |
| Delivery Quantity | Decimal | delivery_quantity__v |
| Legacy CRM Id | String | legacy_crm_id__v |
| Combined Discount | Double | combined_discount__v |
| Combined Net Amount | Decimal | combined_net_amount__v |
| Combined Net Amount Corp | Decimal | combined_net_amount_corpv__sys |
| Delivery Brand Discount Rule | Double | delivery_brand_discount_rule__v |
| Delivery Brand Discount | Double | delivery_brand_discount__v |
| Delivery Discount Value | Decimal | delivery_discount_value__v |
| Delivery Discount Value Corp | Decimal | delivery_discount_value_corpv__sys |
| Delivery Discounted Quantity | Decimal | delivery_discounted_quantity__v |
| Delivery Product Group Discount Rule | Double | delivery_group_discount_rule__v |
| Delivery Product Group Discount | Double | delivery_group_discount__v |
| Delivery Line Discount Rule | Double | delivery_line_discount_rule__v |
| Delivery Line Discount | Double | delivery_line_discount__v |
| Delivery List Amount | Decimal | delivery_list_amount__v |
| Delivery List Amount Corp | Decimal | delivery_list_amount_corpv__sys |
| Delivery Net Amount | Decimal | delivery_net_amount__v |
| Delivery Net Amount Corp | Decimal | delivery_net_amount_corpv__sys |
| Delivery Net Price | Decimal | delivery_net_price__v |
| Delivery Net Price Corp | Decimal | delivery_net_price_corpv__sys |
| Delivery Pricing Rules | String | delivery_pricing_rules__v |
| Total Delivery Discount | Double | total_delivery_discount__v |
| Lock | Bool | lock__v |