OrderFormLineItems
The OrderFormLineItems class represents the items in an order form. An OrderFormHeader object, representing the information that is 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 |
money |
null |
None. |
cy_unit_price |
money |
null |
Stores the sales price of the item after any discounts or adjustments. |
d_DateCreated |
datetime |
null |
None. |
d_DateLastChanged |
datetime |
null |
None. |
description |
nvarchar(255) |
null |
None. |
g_UserIDChangedBy |
nvarchar(255) |
null |
None. |
lineitem_id |
nvarchar(255) |
Unknown |
Key member. |
OrderForm_id |
uniqueidentifier |
{00000000-0000-0000-0000-000000000000} |
Key member. |
OrderGroup_id |
uniqueidentifier |
{00000000-0000-0000-0000-000000000000} |
Key member. |
product_catalog |
nvarchar(255) |
null |
None. |
product_catalog_base |
nvarchar(255) |
null |
None. |
product_id |
nvarchar(255) |
null |
None. |
product_identifying_property |
nvarchar(255) |
null |
None. |
product_Variant_id |
nvarchar(255) |
null |
None. |
product_variant_identifying_property |
nvarchar(255) |
null |
None. |
quantity |
int |
null |
None. |
tax_exempt_code |
nvarchar(255) |
null |
None. |
tax_id |
nvarchar(255) |
null |
None. |
unit_code |
nvarchar(255) |
null |
None. |
OrderFormHeaderID |
binary |
1 |
None. |
OrderGroupAddressesID |
binary |
1 |
None. |
OrderGroupID |
binary |
1 |
None. |
ProductsID |
binary |
1 |
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 |