OrganizationObject Table
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 Core Systems. |
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. |