OrganizationObject Table

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

The OrganizationObject table in the profiles database contains information about the organizations that can pay for orders by using a purchase order.

The following table describes the columns in the OrganizationObject table.

Column name

Type

Allow null

Description

u_org_id

nvarchar(50)

no

The ID of the organization.

This is the primary key.

u_Name

nvarchar(255)

no

The organization's name.

u_trading_partner_number

nvarchar(255)

yes

The organization's trading partner number.

u_user_id_admin_contact

nvarchar(50)

yes

The administrative contact at the organization.

u_user_id_receiver

nvarchar(50)

yes

The person at the organization who receives shipments.

u_preferred_address

nvarchar(50)

yes

The ID of the preferred address for the organization.

u_addresses

nvarchar(255)

yes

The IDs of all the addresses that are associated with the organization.

u_org_catalog_set

nvarchar(255)

yes

The ID of the catalog set that is associated with the organization.

u_user_id_changed_by

nvarchar(50)

yes

The Microsoft Windows user ID of the person who last modified the organization profile.

u_purchasing

nvarchar(255)

yes

Not used. You can use this column for your extensions to Commerce Server.

dt_date_last_changed

datetime

yes

The date that changes were last made to the organization profile.

dt_csadapter_date_last_changed

datetime

yes

The date the organization profile was last updated by BizTalk Server.

dt_date_created

datetime

yes

The date the organization profile was created.

See Also

Other Resources

Profiles System Database Tables