Share via


Organization Profile Schema

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

An instance of this profile schema stores data about organizations (trading partners, home companies, subsidiaries, and so on). The profile is mapped to the physical OrganizationObject table. This profile is not imported into the Data Warehouse by default. For information about the table entries, see Conventions.

Property Name

Data

Type

Req

Exp

Group

Display Name/

Description

org_id

(primary and join key)

GUID

T

T

GeneralInfo

Unique ID of this organization

name

Unicode String

T

T

GeneralInfo

Name of this organization

trading_partner_number

Unicode String

F

F

GeneralInfo

Trading partner number of this organization

user_id_admin_contact

GUID

F

F

GeneralInfo

User ID of the administrative contact for this organization

user_id_receiver

GUID

F

F

GeneralInfo

User ID of the default person to receive products shipped from the supplier

preferred_address

GUID

F

F

GeneralInfo

Name of preferred address from this organization's address book

address_list

GUID

F

F

GeneralInfo

List of addresses associated with this organization

org_catalog_set

Unicode String

F

F

GeneralInfo

Catalog set specific for the organization

purchasing

GUID

F

F

GeneralInfo

User ID of purchasing manager of buying organization

user_id_changed_by

GUID

F

F

ProfileSystem

ID of the user that last changed this organization

date_last_changed

Date Time

F

F

ProfileSystem

Date that this organization was last changed

date_created

Date Time

F

F

ProfileSystem

Date that this organization was created

csadapter_date_last_changed

Date Time

F

F

ProfileSystem

Reserved for BizTalk adapter functionality

See Also

Other Resources

Address Profile Schema

BlanketPOs Profile Schema

CreditCard Profile Schema

Currency Profile Schema

UserObject Profile Schema

Profiles Schema