OrderFormLineItems

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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