trading_partner - AWS Supply Chain

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