Share via


BlanketPOs Profile Schema

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

An instance of this profile schema stores purchase orders issued by an organization. The profile is mapped to the physical BlanketPOs table. The Commerce Server 2007 User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). For information about the table entries, see Conventions.

Property Name

Data

Type

Req

Exp

Group

Display Name/

Description

po_id (primary and join key)

GUID

T

T

GeneralInfo

Unique ID of the purchase order

org_id

GUID

F

F

GeneralInfo

ID of the organization this purchase order is associated with

po_number

Unicode String

T

F

GeneralInfo

Numeric ID of this purchase order

description

Unicode String

F

F

GeneralInfo

Description of this purchase order

user_id_changed_by

Unicode String

F

F

ProfileSystem

ID of the user that last changed this purchase order

date_last_changed

Date Time

F

F

ProfileSystem

Date that this purchase order was last changed

date_created

Date Time

F

F

ProfileSystem

Date that this purchase order was created

csadapter_date_last_changed

Date Time

F

F

ProfileSystem

Reserved for BizTalk adapter functionality

See Also

Other Resources

Address Profile Schema

CreditCard Profile Schema

Currency Profile Schema

Organization Profile Schema

UserObject Profile Schema

Profiles Schema