Organization Profile Schema
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 |