OrderFormHeader

The OrderFormHeader class represents the header information for an order form. An OrderFormHeader object has contact information, buyer information, and other data necessary to process an order form. An OrderFormHeader object links to zero or more OrderFormLineItems objects, representing the ordered items. An OrderGroup object, representing a purchase order, links to zero or more OrderFormHeader objects.

Data Members

Data member name

Data type

Default value

Description

billing_currency

nvarchar(255)

null

None.

buying_org_name

nvarchar(255)

null

Stores the name of the buyer organization.

cc_auth_number

nvarchar(255)

null

Stores the authorization code for the credit card.

d_DateCreated

datetime

null

None.

d_DateLastChanged

datetime

null

None.

g_UserIDChangedBy

nvarchar(255)

null

None.

OrderForm_date_UnNorm

datetime

null

None.

OrderForm_Id

uniqueidentifier

{00000000-0000-0000-0000-000000000000}

Stores the second part of the unique key of the object. Key member.

ordergroup_id

uniqueidentifier

{00000000-0000-0000-0000-000000000000}

Stores the first part of the unique key of the object. Key member.

po_number

nvarchar(255)

null

None.

receiver_email_address

nvarchar(255)

null

None.

receiver_fax_number

nvarchar(255)

null

None.

receiver_first_name

nvarchar(255)

null

Stores the first name of the receiver.

receiver_last_name

nvarchar(255)

null

Stores the last name of the receiver.

receiver_tel_number

nvarchar(255)

null

None.

saved_cc_expiration

nvarchar(255)

null

Stores the expiration code of the saved credit card.

saved_cc_number

nvarchar(255)

null

Stores the number of the saved credit card.

saved_cy_tax_total

money

null

None.

saved_cy_total_total

money

null

None.

selling_org_name

nvarchar(255)

null

Stores the name of the seller organization.

tax_exempt_code

nvarchar(255)

null

None.

tax_exempt_id

nvarchar(255)

null

None.

total_lineitems

int

null

None.

user_email_address

nvarchar(255)

null

Stores the e-mail address of the purchaser.

user_fax_number

nvarchar(255)

null

Stores the fax number of the purchaser.

user_first_name

nvarchar(255)

null

Stores the first name of the purchaser.

user_id

nvarchar(255)

null

Stores the user ID of the purchaser.

user_last_name

nvarchar(255)

null

Stores the last name of the purchaser.

user_name

nvarchar(255)

null

Stores the name of the purchaser.

user_org_id

nvarchar(255)

null

Stores the identifier of the organization of the purchaser.

user_org_name

nvarchar(255)

null

Stores the organization name of the purchaser.

user_tel_number

nvarchar(255)

null

Stores the telephone number of the purchaser.

DateID

binary

1

None.

Order_CurrencyCodeID

binary

1

Stores the code for the date of the order form.

Class Key

OrderFormHeaderKey is composed of the following data members:

   ordergroup_id + OrderForm_Id

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation name

Parent

Child

Type

CurrencyCodeToOrderFormHeader

CurrencyCode

OrderFormHeader

2

DateToOrderFormHeader

Date

OrderFormHeader

2

OrderFormHeaderToOrderFormLineItems

OrderFormHeader

OrderFormLineItems

2

OrderGroupToOrderFormHeader

OrderGroup

OrderFormHeader

2

See Also

Other Resources

Data Warehouse Classes