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

See Also

Other Resources

Data Warehouse Classes