Workday Strategic Sourcing
Explore the interactive ERD
Table & Field Reference
award
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_id | Unknown | FK |
cons | Unknown | |
creator_id | Unknown | |
creator_type | Unknown | |
external_id | Unknown | |
pros | Unknown | |
state | Unknown | |
title | Unknown | |
updated_at | Unknown |
attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
download_url | Unknown | |
download_url_expires_at | Unknown | |
external_id | Unknown | |
file_size | Unknown | |
title | Unknown | |
uploaded_at | Unknown | |
uploaded_by | Unknown |
payment_currency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
alpha | Unknown | |
external_id | Unknown | |
numeric | Unknown |
contract_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
contract_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
contract_relationship_attachment_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | PKFK |
contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_type_id | Unknown | FK |
supplier_company_id | Unknown | FK |
actual_end_date | Unknown | |
actual_spend_amount | Unknown | |
actual_start_date | Unknown | |
approval_rounds | Unknown | |
approved_at | Unknown | |
auto_renewal | Unknown | |
description | Unknown | |
external_id | Unknown | |
first_sent_for_approval_at | Unknown | |
invoiced_po_amount | Unknown | |
marked_as_needs_attention_at | Unknown | |
needs_attention | Unknown | |
needs_attention_note | Unknown | |
needs_attention_reason | Unknown | |
non_po_invoiced_amount | Unknown | |
number | Unknown | |
po_amount | Unknown | |
relationships_creator_data_id | Unknown | |
relationships_creator_data_type | Unknown | |
relationships_owner_data_id | Unknown | |
relationships_owner_data_type | Unknown | |
renew_number_of_times | Unknown | |
renewal_term_unit | Unknown | |
renewal_term_value | Unknown | |
renewal_termination_notice_date | Unknown | |
renewal_termination_notice_unit | Unknown | |
renewal_termination_notice_value | Unknown | |
renewal_termination_reminder_date | Unknown | |
renewal_termination_reminder_unit | Unknown | |
renewal_termination_reminder_value | Unknown | |
request_opened_at | Unknown | |
request_submitted_at | Unknown | |
sent_for_approval_at | Unknown | |
spend_category_id | Unknown | |
state | Unknown | |
state_label | Unknown | |
terminated_note | Unknown | |
terminated_reason | Unknown | |
title | Unknown | |
total_invoiced_amount | Unknown | |
updated_at | Unknown |
event_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
event_relationship_attachment
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PKFK |
id | Unknown | PKFK |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bid_submission_deadline | Unknown | |
duplication_state | Unknown | |
event_type | Unknown | |
external_id | Unknown | |
instant_notifications | Unknown | |
late_bids | Unknown | |
relationships_commodity_codes_data | Json | |
relationships_event_template_data | Json | |
relationships_project_data | Json | |
request_type | Unknown | |
revise_bids | Unknown | |
spend_amount | Unknown | |
spend_category_id | Unknown | |
state | Unknown | |
supplier_question_deadline | Unknown | |
supplier_rsvp_deadline | Unknown | |
title | Unknown | |
updated_at | Unknown |
bid
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
supplier_company_id | Unknown | FK |
intend_to_bid | Unknown | |
intend_to_bid_answered_at | Unknown | |
resubmitted_at | Unknown | |
status | Unknown | |
submitted_at | Unknown |
supplier_company_risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
label | Unknown | |
orders | Unknown | |
slug | Unknown |
field_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
position | Unknown | |
target_object | Unknown |
projects_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
project_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
projects_relationship_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
project_id | Unknown | PKFK |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
project_type_id | Unknown | FK |
actual_end_date | Unknown | |
actual_savings_amount | Unknown | |
actual_spend_amount | Unknown | |
actual_start_date | Unknown | |
approval_rounds | Unknown | |
approved_at | Unknown | |
approved_spend_amount | Unknown | |
canceled_note | Unknown | |
canceled_reason | Unknown | |
description | Unknown | |
estimated_savings_amount | Unknown | |
estimated_spend_amount | Unknown | |
external_id | Unknown | |
first_sent_for_approval_at | Unknown | |
marked_as_needs_attention_at | Unknown | |
needs_attention | Unknown | |
needs_attention_note | Unknown | |
needs_attention_reason | Unknown | |
number | Unknown | |
on_hold_note | Unknown | |
on_hold_reason | Unknown | |
relationships_creator_data_id | Unknown | |
relationships_creator_data_type | Unknown | |
relationships_owner_data_id | Unknown | |
relationships_owner_data_type | Unknown | |
relationships_requester_data_id | Unknown | |
relationships_requester_data_type | Unknown | |
request_opened_at | Unknown | |
request_submitted_at | Unknown | |
sent_for_approval_at | Unknown | |
spend_category_id | Unknown | |
state | Unknown | |
state_label | Unknown | |
target_end_date | Unknown | |
target_start_date | Unknown | |
title | Unknown | |
updated_at | Unknown |
worksheet_column
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
worksheet_id | Unknown | PKFK |
data_identifier | Unknown | |
mapping_key | Unknown | |
name | Unknown |
worksheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
budget | Unknown | |
notes | Unknown | |
title | Unknown | |
updated_at | Unknown | |
worksheet_type | Unknown |
project_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
shortcode | Unknown |
bid_line_item
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
bid_id | Unknown | FK |
event_id | Unknown | FK |
line_item_id | Unknown | FK |
worksheet_id | Unknown | FK |
id | Unknown | |
updated_at | Unknown | |
attributes_data_** |
spend_category_usage
| Column | Type | Keys |
|---|---|---|
usage | Unknown | PK |
spend_category_id | Unknown | PKFK |
spend_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown |
event_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_type | Unknown | |
title | Unknown |
field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_group_id | Unknown | FK |
data_type | Unknown | |
name | Unknown | |
position | Unknown | |
required | Unknown | |
scout_data_type | Unknown | |
target_object | Unknown |
payment_term
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown |
supplier_company_segmentation_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
icon | Unknown | |
label | Unknown | |
orders | Unknown | |
slug | Unknown |
supplier_contact_type_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_contact_id | Unknown | PKFK |
supplier_contact_phone_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_contact_id | Unknown | PKFK |
supplier_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_company_id | Unknown | FK |
email | Unknown | |
external_id | Unknown | |
first_name | Unknown | |
is_suggested | Unknown | |
job_title | Unknown | |
last_name | Unknown | |
name | Unknown | |
notes | Unknown | |
phone_number | Unknown | |
updated_at | Unknown |
contract_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown | |
shortcode | Unknown |
payment_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown | |
payment_method | Unknown |
award_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
award_id | Unknown | FK |
supplier_company_id | Unknown | FK |
worksheet_id | Unknown | FK |
allocated_quantity | Unknown | |
is_quoted | Unknown | |
line_item_type | Unknown | |
net_savings | Unknown | |
net_savings_percentage | Unknown | |
price | Unknown | |
sought_quantity | Unknown | |
total_spend | Unknown | |
attributes_data_** |
line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
worksheet_id | Unknown | FK |
attributes_data_** |
supplier_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown |
supplier_company_tag
| Column | Type | Keys |
|---|---|---|
tags | Unknown | PK |
supplier_company_id | Unknown | PKFK |
supplier_company_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
supplier_company_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
supplier_company_attachment_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_company_id | Unknown | PKFK |
attachment_id | Unknown | FK |
supplier_company_supplier_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_company_id | Unknown | PKFK |
supplier_group_id | Unknown | FK |
supplier_company_supplier_classification_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_company_id | Unknown | PKFK |
supplier_company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_currency_id | Unknown | FK |
payment_term_id | Unknown | FK |
payment_type_id | Unknown | FK |
supplier_category_id | Unknown | FK |
supplier_classification_values_id | Unknown | FK |
accept_all_currencies | Unknown | |
description | Unknown | |
external_id | Unknown | |
is_suggested | Unknown | |
name | Unknown | |
public | Unknown | |
risk | Unknown | |
segmentation | Unknown | |
segmentation_notes | Unknown | |
segmentation_status | Unknown | |
updated_at | Unknown | |
url | Unknown |
supplier_company_segmentation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
label | Unknown | |
orders | Unknown | |
slug | Unknown |
supplier_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
name | Unknown |
field_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_id | Unknown | FK |
label | Unknown | |
position | Unknown |
supplier_classification_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_classification_id | Unknown | PKFK |
supplier_classification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
codename | Unknown | |
country_alpha_2 | Unknown | |
external_id | Unknown | |
name | Unknown | |
orders | Unknown | |
request_additional_information | Unknown |