OrderFormLineItems
This class represents the items in an order form. An OrderFormHeader object, representing the information used to process the order form, links to zero or more OrderFormLineItems objects.
Data Members
Data Member Name | Data Type | Default Value | Description |
cy_lineitem_total | CURRENCY | None | None |
cy_unit_price | CURRENCY | None | Stores the sales price of the item after any discounts or adjustments. |
d_DateCreated | DATETIME | None | None |
d_DateLastChanged | DATETIME | None | None |
description | WSTR | None | None |
g_UserIDChangedBy | WSTR | None | None |
lineitem_id | WSTR | Not available | Key member |
OrderForm_id | UUID | {00000000-0000-0000-0000-000000000000} | Key member |
ordergroup_id | UUID | {00000000-0000-0000-0000-000000000000} | Key member |
product_catalog | WSTR | None | None |
product_catalog_base | WSTR | None | None |
product_id | WSTR | None | None |
product_identifying_property | WSTR | None | None |
product_Variant_id | WSTR | None | None |
product_variant_identifying_property | WSTR | None | None |
ProductNameCat | WSTR400 | Not available | Stores the catalog name concatenated with the product name and the variant name. |
quantity | LONG | None | None |
shipping_address_id | WSTR | None | None |
shipping_method_name | WSTR | None | None |
tax_exempt_code | WSTR | None | None |
tax_id | WSTR | None | None |
unit_code | WSTR | None | None |
Class Key
OrderFormLineItemsKey is composed of the following data members:
** lineitem_id + OrderForm_id + ordergroup_id**
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation Name | Parent | Child | Type |
OrderFormHeaderToOrderFormLineItems | OrderFormHeader | OrderFormLineItems | 2 |
OrderFormLineItemsToOrderGroupAddresses | OrderGroupAddresses | OrderFormLineItems | 2 |
OrderFormLineItemsToProducts | Products | OrderFormLineItems | 2 |
OrderGroupToOrderFormLineItems | OrderGroup | OrderFormLineItems | 2 |