trading_partner
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 |