Organization Profile Schema
An instance of this profile schema stores data about organizations (trading partners, home companies, subsidiaries, and so on). 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
(join key) |
GUID | T | F | General Info |
Organization ID
Supplied by the system |
| name
(primary key) |
Unicode String |
T | F | General Info |
Name |
| date_created | Date Time |
F | F | Profile System |
Date created
The default is getdate() |
| date_last_changed | Date Time |
F | F | Profile System |
Date last changed
The default is getdate() |
| org_catalog_set | Unicode String |
F | F | General Info |
Organization catalog set
Specific to the organization |
| trading_partner_number | Unicode String |
F | F | General Info |
Trading partner number
Assigned by the supplier to the customer organization to represent an account number |
| user_id_admin_contact | GUID | F | F | General Info |
Administrative contact |
| user_id_changed_by | GUID | F | F | General Info |
Changed by
Person making the last change |
| user_id_purchasing_manager | GUID | F | F | Purchasing | Purchasing manager of the buying organization |
| user_id_receiver | GUID | F | F | General Info |
Receiver
The default person to receive products shipped from the supplier |
Copyright © 2005 Microsoft Corporation.
All rights reserved.