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 |