Workday Financial Management schema and ERD

45 tables

Joins between these tables aren't mapped yet.

Loading diagram…

purchase_order

receipt

purchase_order

114

string

descriptor

string

purchase_order_code

string

locked_in_workday

boolean

exclude_from_mass_close

boolean

document_number

string

purchase_order_document_status_id

string

purchase_order_document_status_descriptor

string

purchase_order_document_status_code

string

purchase_order_goods_line

purchase_order_id

string

goods_purchase_order_line_id

string

item_id

string

item_descriptor

string

item_code

string

line_number

long

line_company_id

string

line_company_descriptor

string

line_company_code

string

purchase_order_goods_line_worktag

string

purchase_order_id

string

goods_purchase_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_goods_line_split

purchase_order_id

string

goods_purchase_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

string

quantity

double

extended_amount

double

budget_date

date

purchase_order_goods_line_split_worktag

string

purchase_order_id

string

goods_purchase_order_line_id

string

business_document_line_split_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_goods_line_alternate_item_identifier

purchase_order_id

string

goods_purchase_order_line_id

string

item_identifier_type_id

string

item_identifier_type_descriptor

string

item_identifier_type_code

string

alternate_item_identifier_value

string

unit_of_measure_id

string

unit_of_measure_descriptor

string

unit_of_measure_code

string

manufacturer_id

string

manufacturer_descriptor

string

manufacturer_code

string

_weld_synced

date

purchase_order_goods_line_item_tag

string

purchase_order_id

string

goods_purchase_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_goods_line_close_status

purchase_order_id

string

goods_purchase_order_line_id

string

closed_on

date

closed_by_id

string

closed_by_descriptor

string

closed_by_code

string

reason_code_id

string

reason_code_descriptor

string

reason_code_code

string

_weld_synced

date

purchase_order_service_line

purchase_order_id

string

service_order_line_id

string

item_id

string

item_descriptor

string

item_code

string

line_number

long

line_company_id

string

line_company_descriptor

string

line_company_code

string

purchase_order_service_line_worktag

string

purchase_order_id

string

service_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_service_line_split

purchase_order_id

string

service_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

string

quantity

double

extended_amount

double

budget_date

date

purchase_order_service_line_split_worktag

string

purchase_order_id

string

service_order_line_id

string

business_document_line_split_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_service_line_close_status

purchase_order_id

string

service_order_line_id

string

closed_on

date

closed_by_id

string

closed_by_descriptor

string

closed_by_code

string

reason_code_id

string

reason_code_descriptor

string

reason_code_code

string

_weld_synced

date

purchase_order_deliverables_line

purchase_order_id

string

deliverables_order_line_id

string

line_number

long

line_company_id

string

line_company_descriptor

string

line_company_code

string

project_id

string

project_descriptor

string

project_code

string

purchase_order_deliverables_line_worktag

string

purchase_order_id

string

deliverables_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_deliverables_line_requisition_line

string

purchase_order_id

string

deliverables_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_deliverables_line_split

purchase_order_id

string

deliverables_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

string

quantity

double

extended_amount

double

budget_date

date

purchase_order_deliverables_line_split_worktag

string

purchase_order_id

string

deliverables_order_line_id

string

business_document_line_split_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_deliverables_line_project_phase

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

string

project_plan_phase_descriptor

string

project_plan_phase_code

string

_weld_synced

date

purchase_order_deliverables_line_project_phase_task

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

string

project_plan_task_id

string

project_plan_task_descriptor

string

project_plan_task_code

string

_weld_synced

date

purchase_order_deliverables_line_project_phase_task_subtask

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

string

project_plan_task_id

string

index

long

description

string

amount

double

_weld_synced

date

purchase_order_deliverables_line_close_status

purchase_order_id

string

deliverables_order_line_id

string

closed_on

date

closed_by_id

string

closed_by_descriptor

string

closed_by_code

string

reason_code_id

string

reason_code_descriptor

string

reason_code_code

string

_weld_synced

date

purchase_order_contingent_worker_line

purchase_order_id

string

line_number

long

contingent_worker_id

string

contingent_worker_descriptor

string

contingent_worker_code

string

position_id

string

position_descriptor

string

position_code

string

location_id

string

purchase_order_contingent_worker_line_worktag

string

purchase_order_id

string

line_number

long

descriptor

string

code

string

code_type

string

_weld_synced

date

purchase_order_contingent_worker_line_time_code

purchase_order_id

string

line_number

long

time_code_id

string

time_code_descriptor

string

time_code_code

string

_weld_synced

date

purchase_order_tax_code

purchase_order_id

string

tax_code_id

string

tax_applicability_id

string

tax_applicability_descriptor

string

tax_applicability_code

string

tax_code_descriptor

string

tax_code_code

string

tax_amount

double

_weld_synced

date

purchase_order_tax_code_rate

purchase_order_id

string

tax_code_id

string

tax_rate_id

string

tax_rate_descriptor

string

tax_rate_code

string

tax_amount

double

tax_recoverability_id

string

tax_recoverability_descriptor

string

tax_recoverability_code

string

purchase_order_procedure

purchase_order_id

string

procedure_number

string

procedure_date

date

procedure

string

patient_id

string

medical_record_number

string

physician_id

string

verified_by

string

supplier_representative

string

supplier_sales_order_number

double

additional_procedure_details

string

_weld_synced

date

purchase_order_issue_email

purchase_order_id

string

email_address

string

email_id

string

email_descriptor

string

email_code

string

_weld_synced

date

purchase_order_requisition_type

string

purchase_order_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt

string

descriptor

string

receipt_number

string

locked_in_workday

boolean

receipt_creation_source_id

string

receipt_creation_source_descriptor

string

receipt_creation_source_code

string

submit

boolean

company_id

string

receipt_line_goods_item

receipt_id

string

purchase_order_line_id

string

purchase_order_line_descriptor

string

purchase_order_line_code

string

supplier_contract_line_id

string

supplier_contract_line_descriptor

string

supplier_contract_line_code

string

line_company_id

string

line_company_descriptor

string

receipt_line_goods_item_receipt_adjustment

string

receipt_id

string

purchase_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_line_goods_item_split

receipt_id

string

purchase_order_line_id

string

line_split_allocated_from_id

string

quantity

double

extended_amount

double

memo

string

line_split_allocated_from_descriptor

string

line_split_allocated_from_code

string

_weld_synced

date

receipt_line_goods_item_lot

receipt_id

string

purchase_order_line_id

string

item_lot_id

string

lot_quantity

double

item_lot_descriptor

string

item_lot_code

string

_weld_synced

date

receipt_line_goods_item_lot_serial

receipt_id

string

purchase_order_line_id

string

item_lot_id

string

serial_identifier

string

expiration_date

date

_weld_synced

date

receipt_line_service

receipt_id

string

purchase_order_line_id

string

purchase_order_line_descriptor

string

purchase_order_line_code

string

supplier_contract_line_id

string

supplier_contract_line_descriptor

string

supplier_contract_line_code

string

line_company_id

string

line_company_descriptor

string

receipt_line_service_receipt_adjustment

string

receipt_id

string

purchase_order_line_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_line_service_split

receipt_id

string

purchase_order_line_id

string

line_split_allocated_from_id

string

extended_amount

double

memo

string

line_split_allocated_from_descriptor

string

line_split_allocated_from_code

string

_weld_synced

date

receipt_line_contingent_worker_hours

receipt_id

string

time_code_id

string

time_code_descriptor

string

time_code_code

string

hours

double

_weld_synced

date

receipt_requester

string

receipt_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_requisition

string

receipt_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_requisition_type

string

receipt_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_receipt_adjustment

string

receipt_id

string

descriptor

string

code

string

code_type

string

_weld_synced

date

receipt_tracking_number

receipt_id

string

tracking_number

string

_weld_synced

date