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. |