# trading\_partner
<a name="organization-trading-partner-entity"></a>

**Primary key (PK)**

The table below lists the column names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| trading\_partner | id, tpartner\_type, geo\_id, eff\_start\_date, eff\_end\_date | 

The table below lists the column names supported by the data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
| id | string | Yes | Partner ID. Referred to by other entities as tpartner\_id unless explicitly stated otherwise. | 
| description | string | No | Description of the trading partner. | 
| company\_id 2 | string | No | Company ID. | 
| tpartner\_type | string | Yes1 | Type of partner, for example, vendor, channel partner, or 3PL. | 
| geo\_id 2 | string | Yes1 | Region of the company associated with the trading partner. | 
| eff\_start\_date | timestamp | Yes1 | The start timestamp of the relationship between the trading partner and the company. | 
| eff\_end\_date | timestamp | Yes1 | The end timestamp of the relationship between the trading partner and the company. | 
| is\_active | string | No | Indicates whether trading partner is active or inactive. | 
| address\_1 | string | No | The address corresponding to the trading partner. | 
| address\_2 | string | No | The address corresponding to the trading partner. | 
| address\_3 | string | No | The address corresponding to the trading partner. | 
| city | string | No | The city corresponding to the trading partner. | 
| state\_prov | string | No | The state corresponding to the trading partner. | 
| postal\_code | string | No | The postal code of the trading partner. | 
| country | string | No | The country corresponding to the trading partner. | 
| phone\_number | string | No | The trading partner's contact phone number. | 
| time\_zone | string | No | The trading partner's local time zone. | 
| latitude | double | No | Latitude of trading partner location. | 
| longitude | double | No | Longitude of trading partner location. | 
| os\_id | string | No | Organizational identifier issued by Open Supplier Hub. | 
| duns\_number | string | No | Unique nine-digit identification number provided by Dun and Bradstreet (D and B). | 
| source | string | No | Source of data. | 
| source\_event\_id | string | No | ID of the event created in the source system. | 
| source\_update\_dttm | timestamp | No | Date time stamp of the update made in the source system. | 

1You must enter a value. When you ingest data from SAP or EDI, the default value for *string* is SCN\_RESERVED\_NO\_VALUE\_PROVIDED; and the default value for *timestamp* is 1900-01-01 00:00:00 for start date, and 9999-12-31 23:59:59 for end date.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| company\_id | Organization | company | id | 
| geo\_id | Organization | geography | id |