# trading\$1partner
<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\$1partner | id, tpartner\$1type, geo\$1id, eff\$1start\$1date, eff\$1end\$1date | 

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\$1id unless explicitly stated otherwise.  | 
|  description  |  string  |  No  |  Description of the trading partner.  | 
|  company\$1id 2  |  string  |  No  |  Company ID.  | 
|  tpartner\$1type  |  string  |  Yes1  |  Type of partner, for example, vendor, channel partner, or 3PL.  | 
|  geo\$1id 2  |  string  |  Yes1  |  Region of the company associated with the trading partner.  | 
|  eff\$1start\$1date  |  timestamp  |  Yes1  |  The start timestamp of the relationship between the trading partner and the company.  | 
|  eff\$1end\$1date  |  timestamp  |  Yes1  |  The end timestamp of the relationship between the trading partner and the company.  | 
|  is\$1active  |  string  |  No  |  Indicates whether trading partner is active or inactive.  | 
|  address\$11  |  string  |  No  |  The address corresponding to the trading partner.  | 
|  address\$12  |  string  |  No  |  The address corresponding to the trading partner.  | 
|  address\$13  |  string  |  No  |  The address corresponding to the trading partner.  | 
|  city  |  string  |  No  |  The city corresponding to the trading partner.  | 
|  state\$1prov  |  string  |  No  |  The state corresponding to the trading partner.  | 
|  postal\$1code  |  string  |  No  |  The postal code of the trading partner.  | 
|  country  |  string  |  No  |  The country corresponding to the trading partner.  | 
|  phone\$1number  |  string  |  No  |  The trading partner's contact phone number.  | 
|  time\$1zone  |  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\$1id  |  string  |  No  |  Organizational identifier issued by Open Supplier Hub.  | 
|  duns\$1number  |  string  |  No  |  Unique nine-digit identification number provided by Dun and Bradstreet (D and B).  | 
|  source  |  string  | No |  Source of data.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.  | 
|  source\$1update\$1dttm  |  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\$1RESERVED\$1NO\$1VALUE\$1PROVIDED; 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\$1id | Organization | company | id | 
| geo\$1id | Organization | geography | id |