# SAP Business ByDesign schema ERD

Table and field reference for the Fivetran SAP Business ByDesign connector.

## Table & Field Reference

### customer_contract_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| customer_contract_uuid | String | PK, FK |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| customer_contract_id | String |  |
| description_language_code | String |  |
| description_value | String |  |
| discount_amount | Double |  |
| discount_currency_code | String |  |
| discount_rate | Double |  |
| effective_indicator | Boolean |  |
| id | String |  |
| inactivity_reason_code | Int |  |
| product_id | String |  |
| product_type_code | String |  |
| product_unit_of_measure | String |  |
| quantity | Double |  |
| rate | Double |  |
| rate_quantity_code | String |  |
| unit_code | String |  |
| validity_period_end_date | Instant |  |
| validity_period_start_date | Instant |  |
| Status** |  |  |

### target_group

| Column | Type | Keys |
| --- | --- | --- |
| target_group_id | String | PK |

### read_access_log

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| end_date | Instant |  |
| log_data_content_character_set_code | String |  |
| log_data_content_file_name | String |  |
| log_data_content_format | String |  |
| log_data_content_mime_code | String |  |
| log_data_content_uri | String |  |
| log_data_signature_character_set_code | String |  |
| log_data_signature_file_name | String |  |
| log_data_signature_format | String |  |
| log_data_signature_mime_code | String |  |
| log_data_signature_uri | String |  |
| log_size | Double |  |
| start_date | Instant |  |

### business_partner

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| bidder_indicator | Boolean |  |
| carrier_indicator | Boolean |  |
| category_code | String |  |
| competitor_indicator | Boolean |  |
| created_date | Instant |  |
| customer_indicator | Boolean |  |
| employee_indicator | Boolean |  |
| freight_forwarder_indicator | Boolean |  |
| id | String |  |
| last_updated_date | Instant |  |
| organisation_legal_code | String |  |
| prospect_indicator | Boolean |  |
| sales_and_service_partner_indicator | Boolean |  |
| service_performer_indicator | Boolean |  |
| tax_authority_indicator | Boolean |  |
| warehouse_provider_indicator | Boolean |  |

### customer_partner_number

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | String | PK, FK |
| uuid | String | PK, FK |
| id | String |  |
| product_id | String |  |

### identified_stocks

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### shopping_cart

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| buyer_id | String | FK |
| employee_responsible_id | String | FK |
| recipient_id | String | FK |
| requestor_id | String | FK |
| id | String |  |
| ship_to_id | String |  |
| AccountingCodingBlock** |  |  |

### lease_contract_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| lease_contract_uuid | String | PK, FK |
| automatic_invoice_indicator | Boolean |  |
| cashflow_creation_status_code | String |  |
| description | String |  |
| external_reference_id | String |  |
| id | String |  |
| lease_contract_id | String |  |
| master_fixed_asset_id | String |  |
| object_type_code | String |  |
| payment_schedule_creation_status_code | String |  |
| right_of_use_asset_usage_end_date | LocalDate |  |
| sub_asset_id | String |  |
| Conditions** |  |  |
| OrganisationalAssignment** |  |  |
| SetOfBooks** |  |  |

### organisational_centre

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name_language_code | String |  |
| name_value | String |  |
| validity_end_date | LocalDate |  |
| validity_start_date | LocalDate |  |

### material

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| product_category_id | String | FK |
| base_unit_code | String |  |
| created_date | Instant |  |
| id | String |  |
| inventory_unit_code | String |  |
| last_updated_date | Instant |  |
| planning_unit_code | String |  |
| purchasing_life_cycle_status_code | String |  |
| purchasing_unit_code | String |  |

### service_request_duration_term

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| service_request_uuid | String | PK, FK |
| date_calculation_function_reference_date_calculation_function_code | String |  |
| date_calculation_function_reference_date_calculation_function_group_code | String |  |
| date_calculation_function_reference_date_calculation_function_version_id | String |  |
| duration | String |  |
| duration_role_code | String |  |
| service_request_id | String |  |

### opportunity_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| opportunity_uuid | String | PK, FK |
| product_category_hierarchy_id | String | FK |
| product_category_id | String | FK |
| product_id | String | FK |
| description_language_code | String |  |
| description_value | String |  |
| expected_net_amount | Double |  |
| expected_net_currency_code | String |  |
| id | String |  |
| opportunity_id | String |  |
| quantity | Double |  |
| unit_code | String |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| company_id | String | FK |
| accounting_business_transaction_date | LocalDate |  |
| accounting_closing_step_code | String |  |
| accounting_period_id | String |  |
| created_by_id | String |  |
| created_date | Instant |  |
| currency_conversion_date | LocalDate |  |
| fiscal_year | String |  |
| fiscal_year_variant_code | String |  |
| id | String |  |
| last_updated_by_id | String |  |
| last_updated_date | Instant |  |
| local_currency_exchange_rate | Double |  |
| note | String |  |
| posting_date | LocalDate |  |
| set_of_books_id | String |  |
| transaction_uuid | String |  |
| type_code | String |  |
| Document** |  |  |
| DocumentContainingObject** |  |  |

### allocation_document_item

| Column | Type | Keys |
| --- | --- | --- |
| item_id | String | PK |
| allocation_document_id | String | PK, FK |
| purchase_order_item_id | String | FK |
| supplier_id | String | FK |
| inbound_delivery_id | String |  |
| inbound_delivery_item_id | String |  |
| inbound_delivery_item_uuid | String |  |
| inbound_delivery_uuid | String |  |
| item_quantity | Double |  |
| item_unit_code | String |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| non_deductible_tax_amount | Double |  |
| non_deductible_tax_currency_code | String |  |
| percent | Double |  |
| planned_cost_amount | Double |  |
| planned_cost_currency_code | String |  |
| purchase_order_item_uuid | String |  |
| review_status | String |  |
| supplier_name | String |  |
| total_amount | Double |  |
| total_currency_code | String |  |

### journal_entry_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| journal_entry_uuid | String | PK, FK |
| cost_centre_id | String | FK |
| employee_id | String | FK |
| individual_material_id | String | FK |
| partner_company_id | String | FK |
| product_category_id | String | FK |
| product_id | String | FK |
| production_lot_id | String | FK |
| profit_centre_id | String | FK |
| sales_unit_id | String | FK |
| amount | Double |  |
| business_transaction_amount | Double |  |
| business_transaction_currency_code | String |  |
| cancelled | Boolean |  |
| cash_discount_deductible_indicator | Boolean |  |
| cash_storage_id | String |  |
| chart_of_accounts_code | String |  |
| clearing_posting_date | LocalDate |  |
| cost_object_id | String |  |
| cost_object_type_code | String |  |
| creditor_business_partner_id | String |  |
| creditor_business_partner_name | String |  |
| creditor_business_partner_uuid | String |  |
| currency_code | String |  |
| debit_credit_code | String |  |
| debtor_business_partner_id | String |  |
| debtor_business_partner_name | String |  |
| debtor_business_partner_uuid | String |  |
| distribution_channel_code | String |  |
| document_containing_object_item_id | String |  |
| document_item_type_code | String |  |
| due_category_code | String |  |
| entry_quantity | Double |  |
| entry_unit_code | String |  |
| expense_classification_functional_area_code | String |  |
| fixed_asset_id | String |  |
| gl_account_id | String |  |
| gl_movement_code | String |  |
| house_bank_account_id | String |  |
| house_bank_id | String |  |
| id | String |  |
| journal_entry_id | String |  |
| line_item_group_id | String |  |
| local_amount | Double |  |
| local_currency_code | String |  |
| master_fixed_asset_id | String |  |
| note | String |  |
| payment_form_code | String |  |
| permanent_establishment_id | String |  |
| price_specification_element_category_code | String |  |
| price_specification_element_purpose_group_code | String |  |
| product_requirement_specification_version_id | String |  |
| product_tax_percent | Double |  |
| product_taxation_characteristics_code | String |  |
| product_type_code | String |  |
| project_id | String |  |
| project_task_id | String |  |
| property_movement_direction_code | String |  |
| segment_id | String |  |
| subledger_account_type_code | String |  |
| subledger_movement_category_code | String |  |
| tax_country_code | String |  |
| tax_group_id | String |  |
| tax_jurisdiction_code | String |  |
| transaction_type_code | String |  |
| valuation_quantity | Double |  |
| valuation_unit_code | String |  |
| withholding_taxation_characteristics_code | String |  |
| OpenItem** |  |  |
| PurchasingOrderItem** |  |  |
| SalesAndServiceOrderItem** |  |  |

### product_requirement_specification

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_date | Instant |  |
| id | String |  |
| intended_for_reuse_indicator | Boolean |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| life_cycle_status_name | String |  |
| name | String |  |
| version_id | String |  |

### service_product_supplier_info

| Column | Type | Keys |
| --- | --- | --- |
| service_supplier_id | String | PK |
| service_product_uuid | String | PK, FK |
| supplier_internal_id | String | PK, FK |
| service_product_id | String |  |

### email_activity

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activity_unit_id | String | FK |
| blind_copy_message_to_id | String | FK |
| copy_message_to_id | String | FK |
| employee_responsible_id | String | FK |
| main_activity_id | String | FK |
| message_from_id | String | FK |
| message_to_id | String | FK |
| completed_date | Instant |  |
| created_date | Instant |  |
| group_code | String |  |
| groupware_item_id | String |  |
| id | String |  |
| information_sensitivity_code | String |  |
| initiator_code | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| name | String |  |
| priority_code | String |  |
| reference_id | String |  |

### business_partner_address

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| business_partner_uuid | String | PK, FK |
| business_partner_id | String |  |
| care_of_name | String |  |
| city_name | String |  |
| country_code | String |  |
| county_name | String |  |
| district_name | String |  |
| email_uri | String |  |
| house_id | String |  |
| region_code | String |  |
| street_name | String |  |
| street_postal_code | String |  |
| usage_code | String |  |
| usage_default_indicator | Boolean |  |
| web_uri | String |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| life_cycle_status_code | Int |  |
| name_language_code | String |  |
| name_value | String |  |
| prospect_formatted_name | String |  |

### sales_quote

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| account_id | String | FK |
| bill_from_id | String | FK |
| bill_to_id | String | FK |
| buyer_id | String | FK |
| employee_responsible_id | String | FK |
| freight_forwarder_id | String | FK |
| payer_id | String | FK |
| product_recipient_id | String | FK |
| sales_employee_id | String | FK |
| sales_partner_id | String | FK |
| sales_unit_id | String | FK |
| seller_id | String | FK |
| cancellation_reason_code | String |  |
| cash_and_discount_terms_code | String |  |
| cash_and_discount_terms_payment_baseline_date | LocalDate |  |
| currency_code | String |  |
| fulfillment_blocking_reason_code | String |  |
| id | String |  |
| incoterms_code | String |  |
| incoterms_location | String |  |
| master_quote_reference_id | String |  |
| name_language_code | String |  |
| name_value | String |  |
| posting_date | String |  |
| request_fulfillment_end_date | Instant |  |
| request_fulfillment_start_date | Instant |  |
| sales_business_area_organisation_id | String |  |
| Status** |  |  |

### business_partner_person

| Column | Type | Keys |
| --- | --- | --- |
| business_partner_uuid | String | PK, FK |
| birth_name | String |  |
| business_partner_id | String |  |
| family_name | String |  |
| form_of_address_code | String |  |
| gender_code | String |  |
| given_name | String |  |
| middle_name | String |  |

### opportunity_sales_quote_successor

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| opportunity_uuid | String | PK, FK |
| item_id | String | FK |
| id | String |  |
| item_type_code | String |  |
| opportunity_id | String |  |
| type_code | String |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| purchase_order_uuid | String | PK, FK |
| individual_material_id | String | FK |
| product_id | String | FK |
| product_recipient_uuid | String | FK |
| product_seller_id | String | FK |
| requestor_uuid | String | FK |
| service_performer_uuid | String | FK |
| taxation_buyer_id | String | FK |
| taxation_seller_id | String | FK |
| delivery_end_date | Instant |  |
| delivery_start_date | Instant |  |
| delivery_terms_over_percent | Double |  |
| delivery_terms_priority_code | String |  |
| delivery_terms_under_percent | Double |  |
| description_language_code | String |  |
| description_value | String |  |
| end_buyer_uuid | String |  |
| gross_amount | Double |  |
| gross_currency_code | String |  |
| gross_unit_amount | Double |  |
| gross_unit_base_quantity | Double |  |
| gross_unit_base_quantity_type_code | String |  |
| gross_unit_base_unit_code | String |  |
| gross_unit_currency_code | String |  |
| individual_material_type_code | Int |  |
| limit_amount | Double |  |
| limit_currency_code | String |  |
| list_unit_amount | Double |  |
| list_unit_base_quantity | Double |  |
| list_unit_base_quantity_type_code | String |  |
| list_unit_base_unit_code | String |  |
| list_unit_currency_code | String |  |
| price_component_code | String |  |
| price_component_currency_code | String |  |
| price_component_language_code | String |  |
| price_component_rate | Double |  |
| price_component_value | String |  |
| product_type_code | Int |  |
| purchase_order_id | String |  |
| purchasing_contract_item_id | String |  |
| purchasing_contract_item_type_code | String |  |
| purchasing_contract_item_uuid | String |  |
| quantity | Double |  |
| tax_calculation_status_code | String |  |
| tax_calculation_status_name | String |  |
| tax_calculation_uuid | String |  |
| tax_jurisdiction_code | String |  |
| tax_region_code | String |  |
| taxation_buyer_country_code | String |  |
| taxation_buyer_identification_code | String |  |
| taxation_buyer_identification_name | String |  |
| taxation_characteristics_code | String |  |
| taxation_country_code | String |  |
| taxation_date | LocalDate |  |
| taxation_due_date | LocalDate |  |
| taxation_exemption_certificate_id | String |  |
| taxation_exemption_reason_code | String |  |
| taxation_exemption_reason_name | String |  |
| taxation_follow_up_exemption_id | String |  |
| taxation_product_classification_code | String |  |
| taxation_product_classification_name | String |  |
| taxation_product_classification_system_code | String |  |
| taxation_product_classification_system_name | String |  |
| taxation_seller_country_code | String |  |
| taxation_seller_identification_code | String |  |
| taxation_seller_identification_name | String |  |
| taxation_uuid | String |  |
| taxation_withholding_characteristics_code | String |  |
| type_code | String |  |
| unit_code | String |  |
| CodingBlock** |  |  |
| ReceivingSite** |  |  |
| ShipFrom** |  |  |
| ShipTo** |  |  |

### shopping_cart_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| shopping_cart_uuid | String | PK, FK |
| customer_key_id | String | FK |
| preferred_supplier_key_id | String | FK |
| product_standard_id | String | FK |
| recipient_key_id | String | FK |
| supplier_party_key_id | String | FK |
| action_code | String |  |
| customer_object_node_party_technical_id | String |  |
| customeraction_code | String |  |
| delivery_period_end_date | LocalDate |  |
| delivery_period_start_date | LocalDate |  |
| description_language_code | String |  |
| description_value | String |  |
| item_imat_list_complete_transmission_indicator | Boolean |  |
| limit_amount | Double |  |
| limit_currency_code | String |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| object_node_sender_technical_id | String |  |
| preferred_supplier_object_node_party_technical_id | String |  |
| preferred_supplieraction_code | String |  |
| price_list_unit_price_amount | Double |  |
| price_list_unit_price_base_quantity | Double |  |
| price_list_unit_price_base_quantity_type_code | String |  |
| price_list_unit_price_base_unit_code | String |  |
| price_list_unit_price_currency_code | String |  |
| purchasing_contract_reference_action_code | String |  |
| purchasing_contract_reference_id | String |  |
| purchasing_contract_reference_item_id | String |  |
| purchasing_contract_reference_item_type_code | String |  |
| purchasing_contract_reference_item_uuid | String |  |
| purchasing_contract_reference_object_node_party_technical_id | String |  |
| purchasing_contract_reference_type_code | String |  |
| purchasing_contract_reference_uuid | String |  |
| quantity | Double |  |
| recipient_object_node_party_technical_id | String |  |
| recipientaction_code | String |  |
| ship_to_location_location_id | String |  |
| ship_to_location_object_node_party_technical_id | String |  |
| ship_to_locationaction_code | String |  |
| shopping_cart_id | String |  |
| supplier_party_object_node_party_technical_id | String |  |
| supplier_partyaction_code | String |  |
| type_code | String |  |
| unit_code | String |  |
| Product** |  |  |

### service_agent

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| academic_title_code | String |  |
| birth_date | LocalDate |  |
| birth_name | String |  |
| business_partner_formatted_name | String |  |
| business_partner_function_type_code | String |  |
| business_partner_functional_area_code | String |  |
| business_partner_id | String |  |
| business_partner_uuid | String |  |
| created_date | Instant |  |
| family_name | String |  |
| form_of_address_code | String |  |
| gender_code | String |  |
| given_name | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| main_business_partner_indicator | Boolean |  |
| middle_name | String |  |
| name_format_country_code | String |  |
| nick_name | String |  |
| non_verbal_communication_language_code | String |  |
| note_content_text | String |  |
| occupation_code | String |  |
| workplace_building_id | String |  |
| workplace_business_address_uuid | String |  |
| workplace_department_name | String |  |
| workplace_email_uri | String |  |
| workplace_facsimile_formatted_number_description | String |  |
| workplace_floor_id | String |  |
| workplace_functional_title_name | String |  |
| workplace_organisation_postal_address_additional_city_name | String |  |
| workplace_organisation_postal_address_additional_street_prefix_name | String |  |
| workplace_organisation_postal_address_additional_street_suffix_name | String |  |
| workplace_organisation_postal_address_care_of_name | String |  |
| workplace_organisation_postal_address_city_name | String |  |
| workplace_organisation_postal_address_company_postal_code | String |  |
| workplace_organisation_postal_address_country_code | String |  |
| workplace_organisation_postal_address_county_name | String |  |
| workplace_organisation_postal_address_district_name | String |  |
| workplace_organisation_postal_address_house_id | String |  |
| workplace_organisation_postal_address_po_box_deviating_region_code | String |  |
| workplace_organisation_postal_address_pobox_deviating_city_name | String |  |
| workplace_organisation_postal_address_pobox_deviating_country_code | String |  |
| workplace_organisation_postal_address_pobox_id | String |  |
| workplace_organisation_postal_address_pobox_indicator | Boolean |  |
| workplace_organisation_postal_address_pobox_postal_code | String |  |
| workplace_organisation_postal_address_region_code | String |  |
| workplace_organisation_postal_address_street_name | String |  |
| workplace_organisation_postal_address_street_postal_code | String |  |
| workplace_organisation_postal_address_street_prefix_name | String |  |
| workplace_organisation_postal_address_street_suffix_name | String |  |
| workplace_organisation_postal_address_tax_jurisdiction_code | String |  |
| workplace_organisation_postal_address_time_zone_code | String |  |
| workplace_preferred_communication_medium_type_code | String |  |
| workplace_room_id | String |  |
| workplace_web_uri | String |  |

### production_lot_confirmation_group_production_task

| Column | Type | Keys |
| --- | --- | --- |
| producion_task_uuid | String | PK |
| confirmation_group_uuid | String | PK, FK |
| operation_activity_type_code | String |  |
| operation_type_code | String |  |
| processing_status_code | Int |  |
| production_task_id | String |  |
| resource_uuid | String |  |
| start_feasibility_status_code | Int |  |

### phone_activity

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activity_unit_id | String | FK |
| communication_id | String | FK |
| employee_responsible_id | String | FK |
| main_activity_id | String | FK |
| reference_id | String | FK |
| completion_date | Instant |  |
| created_date | Instant |  |
| data_origin_type_code | String |  |
| end_date | Instant |  |
| group_code | String |  |
| id | String |  |
| information_sensitivity_code | String |  |
| initiator_code | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| name | String |  |
| priority_code | String |  |
| start_date | Instant |  |

### service_request

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| buyer_party_id | String | FK |
| processor_id | String | FK |
| sales_unit_id | String | FK |
| service_execution_id | String | FK |
| buyer_id | String |  |
| data_origin_type_code | String |  |
| id | String |  |
| name_language_code | String |  |
| name_value | String |  |
| ServiceTerms** |  |  |
| Status** |  |  |

### service_product_valuation

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| business_residence_id | String |  |
| company_id | String |  |
| id | String |  |
| life_cycle_status_code | Int |  |

### allocation_document

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| invoice_id | String | FK |
| invoice_item_id | String | FK |
| product_category_id | String | FK |
| product_id | String | FK |
| supplier_id | String | FK |
| approval_status | String |  |
| consistency_status_code | String |  |
| cost_component | String |  |
| created_by | String |  |
| created_on | Instant |  |
| document_type | String |  |
| item_description_language_code | String |  |
| item_description_value | String |  |
| item_total_net_value_amount | Double |  |
| item_total_net_value_currency_code | String |  |
| life_cycle_status | String |  |
| nondeductible_tax_amount | Double |  |
| nondeductible_tax_currency_code | String |  |
| posting_date | LocalDateTime |  |
| review_status | String |  |
| supplier_name | String |  |

### appointment_activity

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activity_unit_id | String | FK |
| employee_responsible_id | String | FK |
| main_activity_id | String | FK |
| organizer_id | String | FK |
| created_date | Instant |  |
| end_date | LocalDate |  |
| group_code | String |  |
| id | String |  |
| information_sensitivity_code | String |  |
| initiator_code | String |  |
| last_updated_date | Instant |  |
| name | String |  |
| priority_code | String |  |
| start_date | LocalDate |  |

### opportunity_sales_partner

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_uuid | String | PK, FK |
| partner_uuid | String | PK, FK |
| opportunity_id | String |  |
| partner_id | String |  |

### working_time_period_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| working_time_model_uuid | String | PK, FK |
| employee_time_item_category_code | String |  |
| employee_time_item_type_code | String |  |
| validity_employee_planned_working_time_day_type_code | String |  |
| working_time_model_id | String |  |
| WorkingTimeItemValuationTerms** |  |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| abc_classification_code | String |  |
| category_code | String |  |
| created_date | Instant |  |
| customer_indicator | Boolean |  |
| id | String |  |
| industrial_sector_code | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | Int |  |
| occupation_code | String |  |
| organisation_first_line_name | String |  |
| organisation_second_line_name | String |  |
| prospect_indicator | Boolean |  |

### customer_contract

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| buyer_contact_id | String | FK |
| buyer_id | String | FK |
| created_date | Instant |  |
| id | String |  |
| last_updated_date | Instant |  |
| name_language_code | String |  |
| name_value | String |  |
| service_confirmation_creation_code | String |  |
| validity_period_end_date | Instant |  |
| validity_period_start_date | Instant |  |
| vendor_id | String |  |
| Status** |  |  |

### production_lot_confirmation_group_reporting_point

| Column | Type | Keys |
| --- | --- | --- |
| reporting_point_id | String | PK |
| confirmation_group_uuid | String | PK, FK |
| reporting_point_uuid | String |  |

### sales_order_item_product_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| sales_order_item_id | String | PK, FK |
| sales_order_uuid | String | PK, FK |
| taxation_characteristics_code | String |  |
| ProductTax** |  |  |
| TransactionProductTax** |  |  |

### kit_item_list

| Column | Type | Keys |
| --- | --- | --- |
| kit_id | String | PK |
| description_language_code | String |  |
| description_value | String |  |
| kit_identifier_type_code | Int |  |
| kit_quantity | Double |  |
| kit_quantity_type_code | String |  |
| kit_type_code | Int |  |
| kit_unit_code | String |  |
| life_cycle_status_code | String |  |

### purchasing_contract_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### labour

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| site_id | String |  |

### production_order

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| lot_id | String | FK |
| created_date | Instant |  |
| id | String |  |
| last_updated_date | Instant |  |
| priority | String |  |
| release_date | Instant |  |
| requested_end_date | Instant |  |
| requested_start_date | Instant |  |
| scheduled_status | String |  |
| start_date | Instant |  |
| status | String |  |

### customer_invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| invoice_uuid | String | PK |
| customer_contract_id | String | FK |
| customer_return_id | String | FK |
| employee_responsible_id | String | FK |
| kit_item_list_id | String | FK |
| original_invoice_id | String | FK |
| outbound_delivery_id | String | FK |
| product_id | String | FK |
| product_recipient_id | String | FK |
| purchase_order_id | String | FK |
| sales_order_id | String | FK |
| sales_service_organisation_id | String | FK |
| service_confirmation_id | String | FK |
| cash_discount_deductible_indicator | Boolean |  |
| description_language_code | String |  |
| description_value | String |  |
| gross_amount | Double |  |
| gross_currency_code | String |  |
| intercompany_contract_id | String |  |
| invoice_id | String |  |
| item_process_type_code | String |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| quantity | Double |  |
| service_order_id | String |  |
| tax_amount | Double |  |
| tax_currency_code | String |  |
| tax_date | LocalDate |  |
| unit_code | String |  |

### supplier_invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| invoice_uuid | String | PK, FK |
| end_buyer_uuid | String | FK |
| internal_charge_to_uuid | String | FK |
| product_id | String | FK |
| product_recipient_uuid | String | FK |
| requestor_uuid | String | FK |
| service_performer_uuid | String | FK |
| cost_distribution_indicator | Boolean |  |
| cost_distribution_percent | Double |  |
| delivery_period_end_date | Instant |  |
| delivery_period_start_date | Instant |  |
| description_language_code | String |  |
| description_value | String |  |
| end_buyer_id | String |  |
| gross_amount | Double |  |
| gross_currency_code | String |  |
| gross_unit_price_amount | Double |  |
| gross_unit_price_base_quantity | Double |  |
| gross_unit_price_base_quantity_type_code | String |  |
| gross_unit_price_base_unit_code | String |  |
| gross_unit_price_currency_code | String |  |
| id | String |  |
| internal_charge_to_id | String |  |
| invoice_id | String |  |
| invoicing_period_end_date | LocalDate |  |
| invoicing_period_start_date | LocalDate |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| net_unit_price_amount | Double |  |
| net_unit_price_base_quantity | Double |  |
| net_unit_price_base_quantity_type_code | String |  |
| net_unit_price_base_unit_code | String |  |
| net_unit_price_currency_code | String |  |
| parent_item_type_code | String |  |
| parent_item_uuid | String |  |
| product_recipient_id | String |  |
| product_type_code | Int |  |
| purchasing_contract_id | String |  |
| purchasing_contract_item_id | String |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| requestor_id | String |  |
| service_performer_id | String |  |
| ship_from_location_location_id | String |  |
| ship_from_location_location_uuid | String |  |
| ship_to_location_location_id | String |  |
| ship_to_location_location_uuid | String |  |
| type_code | String |  |
| unit_code | String |  |
| Gsa** |  |  |
| InboundDelivery** |  |  |
| PurchaseOrder** |  |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_date | Instant |  |
| family_name | String |  |
| form_of_address_code | String |  |
| gender_code | String |  |
| given_name | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |

### product_category_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_date | Instant |  |
| id | String |  |
| last_updated_date | Instant |  |
| usage_code | String |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| authorisation_to_defer_tax_indicator | Boolean |  |
| created_date | Instant |  |
| enterprise_identification_number | String |  |
| enterprise_identification_supplement_code | String |  |
| first_line_name | String |  |
| freight_forwarder_indicator | Boolean |  |
| id | String |  |
| industrial_sector_code | String |  |
| last_updated_date | Instant |  |
| minimum_order_amount | Double |  |
| minimum_order_currency_code | String |  |
| second_line_name | String |  |
| standard_carrier_alpha_code | String |  |
| supplier_indicator | Boolean |  |
| supplier_non_company_indicator | Boolean |  |
| tax_payer_category_code | String |  |
| warehouse_provider_indicator | Boolean |  |
| withholding_tax_office_code | String |  |

### site_logistics_lot_material_output

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| site_logistics_task_uuid | String | PK, FK |
| identified_stock_id | String | FK |
| material_id | String | FK |
| confirm_quantity | Double |  |
| confirm_unit_code | String |  |
| line_item_id | Int |  |
| logistics_deviation_reason_code | String |  |
| material_deviation_status_code | String |  |
| material_inspection_id | String |  |
| material_inspection_skipping_status_code | String |  |
| open_quantity | Double |  |
| open_unit_code | String |  |
| plan_quantity | Double |  |
| plan_unit_code | String |  |
| product_specification_id | String |  |
| restricted_indicator | Boolean |  |
| site_logistics_task_id | String |  |
| target_logistics_area_id | String |  |
| LogisticPackageOutput** |  |  |

### vehicle

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| site_id | String |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| goods_and_service_acknowledgement_id | String | FK |
| outbound_delivery_id | String | FK |
| purchase_request_id | String | FK |
| purchasing_contract_id | String | FK |
| approval_status_code | Int |  |
| buyer_id | String |  |
| created_date | Instant |  |
| currency_code | String |  |
| delivery_processing_status_code | Int |  |
| delivery_status_code | Int |  |
| id | String |  |
| internal_request_id | String |  |
| invoice_processing_status_code | Int |  |
| last_updated_date | Instant |  |
| order_confirmation_status_code | Int |  |
| order_date | Instant |  |
| responsible_purchasing_id | String |  |
| seller_id | String |  |
| total_net_amount | Double |  |
| total_net_currency_code | String |  |

### supplier_invoice

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| bill_from_uuid | String | FK |
| bill_to_uuid | String | FK |
| buyer_uuid | String | FK |
| customer_uuid | String | FK |
| payee_uuid | String | FK |
| payer_uuid | String | FK |
| seller_uuid | String | FK |
| accounts_payable_due_item_type_code | String |  |
| balance_amount | Double |  |
| balance_currency_code | String |  |
| bill_from_id | String |  |
| bill_to_id | String |  |
| buyer_id | String |  |
| chain_liability_base | String |  |
| chain_liability_g_account_amount | Double |  |
| chain_liability_g_account_currency_code | String |  |
| chain_liability_percent | Double |  |
| created_date | Instant |  |
| customer_id | String |  |
| data_origin_type_code | String |  |
| date | LocalDate |  |
| evaluate_receipt_settlement_run_execution_uuid | String |  |
| id | String |  |
| invoice_legally_authorised_id | String |  |
| invoicing_end_date | LocalDate |  |
| invoicing_start_date | LocalDate |  |
| is_cancelled | Boolean |  |
| last_updated_date | Instant |  |
| name_language_code | String |  |
| name_value | String |  |
| payee_id | String |  |
| payer_id | String |  |
| payment_bank_details_account | String |  |
| payment_bank_details_account_owner | String |  |
| payment_bank_details_business_partner_id | String |  |
| payment_bank_details_business_partner_uuid | String |  |
| payment_bank_details_name | String |  |
| payment_blocking_reason_code | String |  |
| payment_form_code | String |  |
| payment_reason_language_code | String |  |
| payment_reason_value | String |  |
| processing_type_code | String |  |
| receipt_date | LocalDate |  |
| seller_id | String |  |
| ship_from_location_id | String |  |
| ship_from_location_uuid | String |  |
| ship_to_location_id | String |  |
| ship_to_location_uuid | String |  |
| supplier_invoice_id | String |  |
| template_indicator | Boolean |  |
| total_down_payment_amount | Double |  |
| total_down_payment_currency_code | String |  |
| total_due_amount | Double |  |
| total_due_currency_code | String |  |
| total_gross_amount | Double |  |
| total_gross_currency_code | String |  |
| total_net_amount | Double |  |
| total_net_currency_code | String |  |
| total_tax_amount | Double |  |
| total_tax_currency_code | String |  |
| transaction_date | LocalDate |  |
| type_code | String |  |
| CashDiscountTerms** |  |  |
| ExternalDocument** |  |  |
| Status** |  |  |
| TaxCalculation** |  |  |

### supplier_invoice_withholding_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| invoice_uuid | String | PK, FK |
| invoice_id | String |  |
| taxation_characteristics_code | String |  |
| taxation_characteristics_name | String |  |
| TransactionWithholdingTax** |  |  |
| WithholdingTax** |  |  |

### return_to_supplier_line_item_text

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| return_to_supplier_item_uuid | String | PK, FK |
| creation_date | String |  |
| language_code | String |  |
| technical_id | String |  |
| text_content_technical_id | String |  |
| type_code | String |  |
| value | String |  |

### product_category_hierarchy_description

| Column | Type | Keys |
| --- | --- | --- |
| language_code | String | PK |
| uuid | String | PK, FK |
| description | String |  |
| description_id | String |  |

### service_request_reference_object

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| service_request_uuid | String | PK, FK |
| individual_material_id | String | FK |
| installation_point_uuid | String |  |
| main_indicator | Boolean |  |
| material_id | String |  |
| service_request_id | String |  |

### material_quantity_characteristic

| Column | Type | Keys |
| --- | --- | --- |
| measure_unit_code | String | PK |
| material_uuid | String | PK, FK |
| material_id | String |  |
| quantity | Double |  |
| type_code | String |  |
| unit_code | String |  |

### supplier_invoice_item_product_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| item_invoice_uuid | String | PK, FK |
| exchange_rate_quoted_currency_name | String |  |
| exchange_rate_unit_currency_name | String |  |
| taxation_characteristics_code | String |  |
| taxation_characteristics_name | String |  |
| ProductTax** |  |  |
| TransactionCurrencyProductTax** |  |  |

### purchase_request

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_date | Instant |  |
| id | String |  |
| last_updated_date | Instant |  |

### kit_item_list_component

| Column | Type | Keys |
| --- | --- | --- |
| item_product_id | String | PK |
| kit_item_list_id | String | PK, FK |
| base_quantity | Double |  |
| base_quantity_type_code | String |  |
| base_unit_code | String |  |
| distribution_percentage | Double |  |
| item_product_identifier_type_code | Int |  |
| item_product_type_code | Int |  |
| line_item | Int |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| unit_code | String |  |

### business_partner_contact

| Column | Type | Keys |
| --- | --- | --- |
| business_partner_uuid | String | PK, FK |
| contact_id | String | PK, FK |
| business_partner_id | String |  |

### return_to_supplier_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### service_product_sale

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| sales_organisation_id | String | FK |
| distribution_channel_code | String |  |
| id | String |  |
| item_group_code | String |  |
| life_cycle_status_code | String |  |
| minimum_order_quantity_value | Double |  |
| reference_price_service_internal_id | String |  |

### supplier_invoice_tax_calculation_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| invoice_uuid | String | PK, FK |
| country | String |  |
| invoice_id | String |  |
| status | String |  |
| taxation_characteristics | String |  |
| withholding_taxation_characteristics | String |  |

### service_product_customer_info

| Column | Type | Keys |
| --- | --- | --- |
| service_customer_id | String | PK |
| customer | String | PK, FK |
| service_product_uuid | String | PK, FK |
| service_product_id | String |  |

### opportunity_sales_employee

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_uuid | String | PK |
| employee_uuid | String | PK, FK |
| opportunity_id | String | FK |
| employee_id | String |  |

### production_bill_of_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| base_quantity | Double |  |
| base_quantity_type_code | String |  |
| base_unit_code | String |  |
| created_date | Instant |  |
| description_language_code | String |  |
| description_value | String |  |
| execution_consistency_status_code | String |  |
| last_updated_date | Instant |  |
| logistics_order_automatic_output_rule_code | String |  |
| logistics_task_automatic_output_rule_code | String |  |
| logistics_task_generation_strategy_code | String |  |
| planning_consistency_status_code | String |  |
| site_id | String |  |
| site_name | String |  |
| supply_to_production_enabled_indicator | Boolean |  |

### service_product

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| product_category_id | String | FK |
| base_unit_code | String |  |
| created_date | Instant |  |
| expense_indicator | Boolean |  |
| id | String |  |
| last_updated_date | Instant |  |
| purchasing_life_cycle_status_code | String |  |
| purchasing_unit_code | String |  |
| valuation_unit_code | String |  |

### production_bill_of_material_item_group_change_state

| Column | Type | Keys |
| --- | --- | --- |
| change_state_uuid | String | PK |
| item_uuid | String | PK, FK |
| input_product_id | String | FK |
| change_order_id | String |  |
| deletion_indicator | Boolean |  |
| fixed_quantity_indicator | Boolean |  |
| input_product_quantity | Double |  |
| input_product_quantity_uo_mcode | String |  |
| input_product_type_code | Int |  |
| input_product_unit_code | String |  |
| item_id | String |  |
| migrated_data_adaptation_type_code | String |  |
| text_item | Boolean |  |

### sales_product_catalogue

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name_language_code | String |  |
| name_value | String |  |

### goods_and_activity_confirmation

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| confirmation_company_id | String | FK |
| identified_stock_inventory_separating_id | String | FK |
| main_inventory_separating_material_id | String | FK |
| main_inventory_separating_owner_party_id | String | FK |
| main_inventory_separating_supply_planning_area_id | String | FK |
| outbound_delivery_product_recipient_id | String | FK |
| outbound_delivery_root_id | String | FK |
| special_stock_inventory_separating_reference_id | String | FK |
| change_reason_code | String |  |
| confirmation_business_transaction_date_time | Instant |  |
| confirmation_cancellation_document_indicator | Boolean |  |
| confirmation_cancellation_status_code | String |  |
| confirmation_cancelled_uuid | String |  |
| confirmation_company_uuid | String |  |
| confirmation_creation_date_time | Instant |  |
| default_recorded_quantity | Double |  |
| default_recorded_quantity_type_code | String |  |
| default_recorded_unit_code | String |  |
| id | String |  |
| identified_stock_inventory_separating_type_code | Int |  |
| identified_stock_inventory_separating_uuid | String |  |
| main_inventory_separating_material_type_code | Int |  |
| main_inventory_separating_material_uuid | String |  |
| main_inventory_separating_owner_party_uuid | String |  |
| main_inventory_separating_restricted_use_indicator | Boolean |  |
| main_inventory_separating_stock_status_code | String |  |
| main_inventory_separating_supply_planning_area_uuid | String |  |
| outbound_delivery_item_id | String |  |
| outbound_delivery_item_uuid | String |  |
| outbound_delivery_processing_type_code | String |  |
| outbound_delivery_root_uuid | String |  |
| serial_number_adjustment_not_allowed | Boolean |  |
| serial_number_id | String |  |
| serial_number_individual_product_uuid | String |  |
| serial_number_revocation_indicator | Boolean |  |
| serial_number_uuid | String |  |
| site_uuid | String |  |
| special_stock_inventory_separating_reference_uuid | String |  |
| special_stock_inventory_separating_site_logistics_lot_id | String |  |
| special_stock_inventory_separating_site_logistics_lot_uuid | String |  |
| transfer_group_id | String |  |
| Inventory** |  |  |

### customer_contract_item_product_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| customer_contract_item_uuid | String | PK, FK |
| customer_contract_item_id | String |  |
| taxation_characteristics_code | String |  |
| ProductTax** |  |  |
| TransactionProductTax** |  |  |

### equipment

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| site_id | String |  |

### marketing_consent

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| channel_permission_contact_allowed_code | String |  |
| channel_permission_details | String |  |
| channel_permission_type_code | String |  |
| created_date | Instant |  |
| general_contact_permission | String |  |
| id | String |  |
| last_updated_date | Instant |  |

### trade_receivable_payable_account

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| business_partner_id | String |  |
| clearing_strategy_code | String |  |
| company_id | String |  |
| created_date | Instant |  |
| debtor_doubtful_indicator | Boolean |  |
| dunning_blocked_indicator | Boolean |  |
| dunning_blocking_expiration_date | LocalDate |  |
| dunning_blocking_reason_code | String |  |
| dunning_procedure_code | String |  |
| last_dunning_date | LocalDate |  |
| last_updated_date | Instant |  |
| netting_blocked_indicator | Boolean |  |
| party_role_category_code | String |  |
| payment_strategy_code | String |  |

### production_bill_of_material

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| variant_product_id | String | FK |
| variant_product_requirement_specification_id | String | FK |
| variant_state_input_product_id | String | FK |
| created_by_uuid | String |  |
| created_date | Instant |  |
| description_language_code | String |  |
| description_value | String |  |
| last_updated_date | Instant |  |
| logistics_preparation_functional_unit_id | String |  |
| logistics_preparation_functional_unit_uuid | String |  |
| migrated_data_adaptation_type_code | String |  |
| updated_by_uuid | String |  |
| Variant** |  |  |

### production_bill_of_material_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| item_group_uuid | String | PK, FK |
| id | String |  |
| item_group_id | String |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| employee_responsible_uuid | String | FK |
| organisation_id | String | FK |
| prospect_uuid | String | FK |
| sales_unit_uuid | String | FK |
| consistency_status_code | Int |  |
| employee_responsible_id | String |  |
| expected_net_amount | Double |  |
| expected_net_currency_code | String |  |
| expected_processing_end_date | Instant |  |
| expected_processing_start_date | Instant |  |
| expected_revenue_amount | Double |  |
| expected_revenue_currency_code | String |  |
| id | String |  |
| life_cycle_status_code | Int |  |
| name_language_code | String |  |
| name_value | String |  |
| priority_code | String |  |
| probability_percent | Double |  |
| process_status_valid_since_date | LocalDate |  |
| prospect_budget_amount | Double |  |
| prospect_budget_currency_code | String |  |
| prospect_id | String |  |
| sales_cycle_code | String |  |
| sales_cycle_phase_code | String |  |
| sales_cycle_phase_processing_start_date | LocalDate |  |
| sales_revenue_forecast_relevance_indicator | Boolean |  |
| sales_unit_id | String |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| identifier | String |  |
| name_language_code | String |  |
| name_validity_period_end_date | LocalDate |  |
| name_validity_period_start_date | LocalDate |  |
| name_value | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| buyer_party_id | String | FK |
| id | String |  |
| project_life_cycle_status_code | String |  |
| scheduling_up_to_dateness_status_code | String |  |
| starting_status_code | String |  |
| task_blocking_status_code | String |  |
| task_life_cycle_status_code | String |  |
| BuyerParty** |  |  |

### task_activity

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activity_unit_id | String | FK |
| employee_responsible_id | String | FK |
| main_activity_id | String | FK |
| processor_id | String | FK |
| reference_id | String | FK |
| activity_body_text | String |  |
| completion_date | Instant |  |
| completion_percent | Double |  |
| created_date | Instant |  |
| data_origin_type_code | String |  |
| end_date | LocalDate |  |
| group_code | String |  |
| id | String |  |
| information_sensitivity_code | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| name | String |  |
| priority_code | String |  |
| start_date | LocalDate |  |

### direct_debit_mandate

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| alternate_payer_name | String |  |
| blocked_indicator | Boolean |  |
| company_id | String |  |
| company_name | String |  |
| company_uuid | String |  |
| created_date | Instant |  |
| debtor_identification_code | String |  |
| description | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| last_used_document_date | LocalDate |  |
| last_used_document_id | String |  |
| life_cycle_status_code | String |  |
| mandate_type_code | String |  |
| payer_bank_account_standard_id | String |  |
| payer_bank_details_id | String |  |
| payer_bank_name | String |  |
| payer_bank_standard_id | String |  |
| payer_id | String |  |
| payer_role_code | String |  |
| request_issuing_status_code | String |  |
| sepacreditor_id | String |  |
| signature_city_name | String |  |
| signature_date | LocalDate |  |
| single_use_indicator | Boolean |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| AmendmentHistoryItem** |  |  |

### purchase_contract

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### purchasing_contract

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activation_status_code | String |  |
| activation_status_name | String |  |
| approval_status_code | String |  |
| approval_status_name | String |  |
| closure_status_code | String |  |
| closure_status_name | String |  |
| consistency_status_code | String |  |
| consistency_status_name | String |  |
| created_date | Instant |  |
| currency_code | String |  |
| currency_name | String |  |
| expiry_status_code | String |  |
| expiry_status_name | String |  |
| follow_up_invoice_posting_confirmation_required_indicator | Boolean |  |
| id | String |  |
| last_updated_date | Instant |  |
| migrated_data_adaptation_type_code | String |  |
| migrated_data_adaptation_type_name | String |  |
| name_language_code | String |  |
| name_value | String |  |
| negotiation_status_code | String |  |
| negotiation_status_name | String |  |
| negotiation_type_code | String |  |
| negotiation_type_name | String |  |
| processing_type_code | String |  |
| processing_type_name | String |  |
| purchasing_contract_life_cycle_status_code | String |  |
| purchasing_contract_life_cycle_status_name | String |  |
| release_status_code | String |  |
| release_status_name | String |  |
| sourcing_availability_status_code | String |  |
| sourcing_availability_status_name | String |  |
| target_amount | Double |  |
| target_currency_code | String |  |
| template_indicator | Boolean |  |
| total_release_amount | Double |  |
| total_release_currency_code | String |  |
| type_code | String |  |
| type_name | String |  |
| validity_period_end_date | Instant |  |
| validity_period_start_date | Instant |  |
| StrategicSourcingProject** |  |  |

### person_history

| Column | Type | Keys |
| --- | --- | --- |
| validity_period_end_date | LocalDate | PK |
| validity_period_start_date | LocalDate | PK |
| employee_uuid | String | PK, FK |
| academic_title_code | String |  |
| birth_date | LocalDate |  |
| birth_name | String |  |
| birth_place | String |  |
| employee_id | String |  |
| family_name | String |  |
| form_of_address_code | String |  |
| gender_code | String |  |
| given_name | String |  |
| marital_status_code | String |  |
| middle_name | String |  |
| nationality_country_code | String |  |
| nickname | String |  |

### supplier_business_partner_relationship

| Column | Type | Keys |
| --- | --- | --- |
| related_business_partner_id | String | PK |
| relationship_business_partner_uuid | String | PK |
| relationship_supplier_uuid | String | PK, FK |
| relationship_supplier_id | String |  |
| role_code_code | String |  |

### target_group_member

| Column | Type | Keys |
| --- | --- | --- |
| target_group_id | String | PK |
| target_group_member_uuid | String | PK |
| addressable_checklist_result_status_code | Int |  |
| ContactInformation** |  |  |

### opportunity_competitor

| Column | Type | Keys |
| --- | --- | --- |
| competitor_uuid | String | PK, FK |
| opportunity_uuid | String | PK, FK |
| competitor_id | String |  |
| opportunity_id | String |  |

### production_lot_confirmation_group

| Column | Type | Keys |
| --- | --- | --- |
| confirmation_group_uuid | String | PK |
| production_lot_uuid | String | PK, FK |
| confirmation_finished_indicator | Boolean |  |
| confirmed_quantity | Double |  |
| confirmed_scrap_quantity | Double |  |
| confirmed_scrap_unit_code | String |  |
| confirmed_unit_code | String |  |
| deviation_reason_code | String |  |
| open_quantity | Double |  |
| open_unit_code | String |  |
| planned_quantity | Double |  |
| planned_unit_code | String |  |
| processor_object_type_code | String |  |
| production_lot_id | String |  |
| total_confirmed_quantity | Double |  |
| total_confirmed_scrap_quantity | Double |  |
| total_confirmed_scrap_unit_code | String |  |
| total_confirmed_unit_code | String |  |

### product_design_version

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| activation_date | LocalDate |  |
| activation_status_code | String |  |
| activation_status_name | String |  |
| application_log_uuid | String |  |
| assembly_indicator | Boolean |  |
| base_quantity | Double |  |
| base_quantity_type_code | String |  |
| base_quantity_type_name | String |  |
| base_unit_code | String |  |
| blocking_status_code | String |  |
| blocking_status_name | String |  |
| consistency_status_code | String |  |
| consistency_status_name | String |  |
| created_date | Instant |  |
| design_version_identification_id | String |  |
| design_version_identification_internal_id | String |  |
| engineering_design_change_order_id | String |  |
| engineering_design_version_created_date | Instant |  |
| engineering_design_version_last_updated_date | Instant |  |
| engineering_design_version_primary_viewable_created_date | Instant |  |
| engineering_design_version_release_date | LocalDate |  |
| engineering_design_version_release_status_code | String |  |
| engineering_design_version_release_status_name | String |  |
| engineering_design_version_replication_cancelled_indicator | Boolean |  |
| engineering_design_version_responsible_engineer_person_family_name | String |  |
| engineering_design_version_responsible_engineer_person_given_name | String |  |
| engineering_design_version_status_name | String |  |
| execution_usage_blocking_status_code | String |  |
| execution_usage_blocking_status_name | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| life_cycle_status_name | String |  |
| manually_created_indicator | Boolean |  |
| name | String |  |
| obsolescence_status_code | String |  |
| obsolescence_status_name | String |  |
| predecessor_version_uuid | String |  |
| product_design_id | String |  |
| proposed_procurement_method_code | String |  |
| proposed_procurement_method_name | String |  |
| review_processing_status_code | String |  |
| review_processing_status_name | String |  |
| validity_start_date | LocalDate |  |
| PredecessorDesignVersionIdentification** |  |  |

### object_id_mapping

| Column | Type | Keys |
| --- | --- | --- |
| local_object_uuid | String | PK |
| remote_business_system_uuid | String | PK |
| last_change_date | LocalDateTime |  |
| local_identifier_type | String |  |
| local_object_id | String |  |
| local_object_node_type_code | String |  |
| local_object_type_code | String |  |
| remote_identifier_type | String |  |
| remote_object_id | String |  |

### entitlement_product_valuation

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| business_residence_id | String |  |
| company_id | String |  |
| id | String |  |
| life_cycle_status_code | Int |  |

### vehicle_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| vehicle_uuid | String | PK, FK |
| language_code | String |  |
| value | String |  |

### sales_quote_item_schedule_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_quote_item_id | String | PK, FK |
| end_date | Instant |  |
| product_availability_confirmation_commitment_code | String |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| related_id | String |  |
| start_date | Instant |  |
| type_code | String |  |
| unit_code | String |  |

### service_confirmation_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| service_confirmation_uuid | String | PK, FK |
| product_identified_stock_key_id | String | FK |
| actual_fulfillment_period_item_period_terms_technical_id | String |  |
| actual_fulfillment_period_item_period_terms_time_point_period_duration | String |  |
| actual_fulfillment_period_item_period_terms_time_point_period_end_date | LocalDate |  |
| actual_fulfillment_period_item_period_terms_time_point_period_end_time_point_type_name | String |  |
| actual_fulfillment_period_item_period_terms_time_point_period_interval_boundary_type_code | String |  |
| actual_fulfillment_period_item_period_terms_time_point_period_start_date | LocalDate |  |
| business_process_variant_type_code | String |  |
| business_process_variant_type_name | String |  |
| business_process_variant_type_technical_id | String |  |
| buyer_id | String |  |
| cancellation_status_code | String |  |
| cancellation_status_name | String |  |
| confirmation_duration | String |  |
| confirmation_technical_id | String |  |
| customer_order_life_cycle_status_code | String |  |
| customer_order_life_cycle_status_name | String |  |
| description_language_code | String |  |
| description_value | String |  |
| duration_terms_role_code | String |  |
| duration_terms_role_name | String |  |
| duration_terms_technical_id | String |  |
| fulfilment_processing_status_code | String |  |
| fulfilment_processing_status_name | String |  |
| id | String |  |
| pricing_terms_technical_id | String |  |
| pricing_terms_warranty_goodwill_code | String |  |
| pricing_terms_warranty_goodwill_name | String |  |
| processing_type_code | String |  |
| processing_type_name | String |  |
| schedule_line_quantity | Double |  |
| schedule_line_unit_code | String |  |
| schedule_line_uuid | String |  |
| service_confirmation_id | String |  |
| service_performer_item_party_party_key_party_id | String |  |
| service_performer_item_party_technical_id | String |  |
| type_code | String |  |
| type_name | String |  |
| BusinessTransactionDocumentReference** |  |  |
| Product** |  |  |
| TotalValues** |  |  |

### project_task

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| project_uuid | String | PK, FK |
| blocking_status_code | String |  |
| closure_status_code | String |  |
| earliest_start_date | Instant |  |
| financial_function_id | String |  |
| fulfilment_processing_status_code | String |  |
| latest_end_date | Instant |  |
| left_neighbour_task_uuid | String |  |
| life_cycle_status_code | String |  |
| milestone_indicator | Boolean |  |
| project_element_id | String |  |
| project_id | String |  |
| project_milestone_status_code | String |  |
| project_starting_status_code | String |  |
| release_status_code | String |  |
| responsible_employee_id | String |  |
| right_neighbour_task_uuid | String |  |
| stopping_status_code | String |  |
| summary_task_indicator | Boolean |  |
| TaskExpense** |  |  |
| TaskFundAssignment** |  |  |
| TaskRevenue** |  |  |

### exchange_rate

| Column | Type | Keys |
| --- | --- | --- |
| source_currency_code | String | PK |
| target_currency_code | String | PK |
| ask_exchange_rate_uuid | String |  |
| ask_rate | Double |  |
| bid_exchange_rate_uuid | String |  |
| bid_rate | Double |  |
| deleted_indicator_code | Boolean |  |
| mid_exchange_rate_uuid | String |  |
| mid_rate | Double |  |
| register_date | Instant |  |
| type_code | String |  |
| valid_from_date | Instant |  |

### partner_company

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String | FK |
| affiliation_end_date | LocalDate |  |
| affiliation_start_date | LocalDate |  |
| business_partner_only_indicator | Boolean |  |
| created_date | Instant |  |
| last_updated_date | Instant |  |
| name_language_code | String |  |
| name_value | String |  |

### account_contact

| Column | Type | Keys |
| --- | --- | --- |
| account_uuid | String | PK, FK |
| contact_uuid | String | PK, FK |
| contact_id | String | FK |
| account_id | String |  |

### message_monitoring_information

| Column | Type | Keys |
| --- | --- | --- |
| business_document_message_id | String | PK |
| adapter_type_code | Int |  |
| business_document_object_node_type_code | String |  |
| business_document_object_type_code | String |  |
| business_document_uuid | String |  |
| creation_date | Instant |  |
| execution_date | Instant |  |
| local_party_id | String |  |
| message_direction_code | String |  |
| message_status_code | String |  |
| remote_party_id | String |  |
| service_interface_code | String |  |
| service_interface_operation_code | String |  |

### business_role

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name_language_code | String |  |
| name_value | String |  |

### material_supply_planning

| Column | Type | Keys |
| --- | --- | --- |
| area_id | String | PK |
| material_uuid | String | PK, FK |
| delivery_duration | String |  |
| demand_management_procedure_code | String |  |
| fixed_lot_size_quantity | Double |  |
| goods_receipt_processing_duration | String |  |
| life_cycle_status_code | Int |  |
| lot_size_procedure_code | String |  |
| lot_size_rounding_quantity | Double |  |
| material_id | String |  |
| min_shelf_life_duration | String |  |
| minimum_receipt_supply_duration | String |  |
| minimum_supply_duration | String |  |
| period_type_code | String |  |
| procedure_code | String |  |
| procurement_type_code | String |  |
| reorder_quantity | Double |  |
| safety_stock_quantity | Double |  |
| safety_supply_duration | String |  |
| supply_planning_category_id | String |  |
| target_stock_quantity | Double |  |
| target_supply_duration | String |  |
| time_fence_duration | String |  |

### site_logistics_lot_material_input

| Column | Type | Keys |
| --- | --- | --- |
| site_logistics_task_uuid | String | PK, FK |
| identified_stock_id | String | FK |
| material_id | String | FK |
| confirm_quantity | Double |  |
| confirm_unit_code | String |  |
| line_item_id | Int |  |
| logistics_deviation_reason_code | String |  |
| material_deviation_status_code | String |  |
| open_quantity | Double |  |
| open_unit_code | String |  |
| plan_quantity | Double |  |
| plan_unit_code | String |  |
| product_specification_id | String |  |
| restricted_indicator | Boolean |  |
| site_logistics_task_id | String |  |
| source_logistics_area_id | String |  |
| total_confirmed_quantity | Double |  |
| total_confirmed_unit_code | String |  |
| uuid | String |  |
| LogisticPackageInput** |  |  |

### bank_statement_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| bank_statement_uuid | String | PK, FK |
| approval_date | Instant |  |
| bank_charge_bearer_code | String |  |
| bank_item_id | String |  |
| bank_payment_transaction_reference_id | String |  |
| bank_posting_date | LocalDate |  |
| bank_statement_id | String |  |
| bank_value_date | LocalDate |  |
| business_partner_bank_details_key_id | String |  |
| business_partner_bank_details_key_uuid | String |  |
| business_partner_id | String |  |
| business_partner_party_role_category_code | String |  |
| business_process_variant_type_code | String |  |
| change_state_id | String |  |
| house_bank_fee_amount | Double |  |
| house_bank_fee_currency_code | String |  |
| id | String |  |
| note | String |  |
| original_currency_amount | Double |  |
| original_currency_currency_code | String |  |
| partner_bank_fee_amount | Double |  |
| partner_bank_fee_currency_code | String |  |
| payment_allocation_uuid | String |  |
| payment_approval_id | String |  |
| payment_explanation_uuid | String |  |
| payment_register_item_uuid | String |  |
| payment_transaction_category_code | String |  |
| payment_transaction_supplement_category_code | String |  |
| payment_transaction_supplement_type_code | String |  |
| payment_transaction_type_code | String |  |
| posted_amount | Double |  |
| posted_currency_code | String |  |
| BankExchangeRate** |  |  |
| BusinessPartnerBankAccount** |  |  |

### service_request_period_term

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| service_request_uuid | String | PK, FK |
| end_time_point_date_calculation_function_reference_date_calculation_function_code | String |  |
| end_time_point_date_calculation_function_reference_date_calculation_function_group_code | String |  |
| end_time_point_date_calculation_function_reference_date_calculation_function_version_id | String |  |
| period_role_code | String |  |
| service_request_id | String |  |
| start_time_point_date_calculation_function_reference_date_calculation_function_code | String |  |
| start_time_point_date_calculation_function_reference_date_calculation_function_group_code | String |  |
| start_time_point_date_calculation_function_reference_date_calculation_function_version_id | String |  |
| TimePointPeriod** |  |  |

### entitlement_product_sale

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| sales_organisation_id | String | FK |
| distribution_channel_code | String |  |
| id | String |  |
| item_group_code | String |  |
| life_cycle_status_code | String |  |
| minimum_order_quantity_value | Double |  |
| reference_price_service_internal_id | String |  |

### return_to_supplier

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| buyer_responsible_id | String |  |
| delivery_priority_code | Int |  |
| freight_forwarder_id | String |  |
| id | String |  |
| incoterms_classification_code | String |  |
| incoterms_transfer_location_name | String |  |
| receipient_party_id | String |  |
| return_to_supplier_life_cycle_status_code | Int |  |
| site_id | String |  |
| supplier_id | String |  |
| text_collection_uuid | String |  |
| SystemAdministrative** |  |  |

### labour_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| labour_uuid | String | PK, FK |
| language_code | String |  |
| value | String |  |

### employee_assignment_history

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| employee_uuid | String | PK, FK |
| employee_id | String |  |
| id | String |  |
| job_name_language_code | String |  |
| job_name_value | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |

### opportunity_activity_predecessor

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| opportunity_uuid | String | PK, FK |
| item_id | String | FK |
| id | String |  |
| item_type_code | String |  |
| opportunity_id | String |  |
| type_code | String |  |

### production_lot_confirmation_group_material_output

| Column | Type | Keys |
| --- | --- | --- |
| material_output_uuid | String | PK |
| confirmation_group_uuid | String | PK, FK |
| identified_stock_id | String | FK |
| inspection_sample_identified_stock_id | String | FK |
| activity_id | String |  |
| activity_type_code | String |  |
| activity_uuid | String |  |
| confirmation_finished | Boolean |  |
| identified_stock_type_code | String |  |
| open_quantity | Double |  |
| open_unit_code | String |  |
| operation_id | String |  |
| planned_indicator | Boolean |  |
| planned_quantity | Double |  |
| planned_unit_code | String |  |
| product_id | String |  |
| product_specification_id | String |  |
| product_uuid | String |  |
| site_id | String |  |
| supply_planning_area_uuid | String |  |
| target_logistics_area_id | String |  |
| total_confirmed_quantity | Double |  |
| total_confirmed_unit_code | String |  |
| Inspection** |  |  |

### material_availability_confirmation

| Column | Type | Keys |
| --- | --- | --- |
| planning_area_id | String | PK |
| material_uuid | String | PK, FK |
| goods_issue_processing_duration | String |  |
| horizon_duration | String |  |
| life_cycle_status_code | Int |  |
| material_id | String |  |
| scope_code | String |  |

### bank_statement

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| approval_status_code | String |  |
| automatically_generated_indicator | Boolean |  |
| bank_id | String |  |
| bank_stat_origin_code | String |  |
| bank_statement_date | LocalDate |  |
| closing_balance_amount | Double |  |
| closing_balance_currency_code | String |  |
| company_id | String |  |
| consistency_status_code | String |  |
| created_date | Instant |  |
| credit_total_amount | Double |  |
| credit_total_currency_code | String |  |
| currency_code | String |  |
| debit_total_amount | Double |  |
| debit_total_currency_code | String |  |
| external_service_provider_id | String |  |
| format_code | String |  |
| house_bank_id | String |  |
| id | String |  |
| item_total_number_value | Int |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |
| opening_balance_amount | Double |  |
| opening_balance_currency_code | String |  |
| posting_date | LocalDate |  |
| validity_year | String |  |
| HouseBankAccount** |  |  |

### entitlement_product_description

| Column | Type | Keys |
| --- | --- | --- |
| language_code | String | PK |
| uuid | String | PK, FK |
| description | String |  |
| description_id | String |  |

### service_product_deviant_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| region_code | String |  |
| service_point_taxable_indicator | Boolean |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_type_code | String |  |

### identified_stock

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| supplier_id | String | FK |
| description_language_code | String |  |
| description_value | String |  |
| expiration_date_time | Instant |  |
| external_id | String |  |
| life_cycle_status_code | String |  |
| product_id | String |  |
| production_date_time | Instant |  |
| supplier_type_code | Int |  |

### company_payment_file_register_outgoing_files_integration

| Column | Type | Keys |
| --- | --- | --- |
| company_id | String | PK |
| File** |  |  |

### customer_contract_business_transaction_document_reference

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| contract_uuid | String | PK, FK |
| contract_id | String |  |
| id | String |  |
| item_id | String |  |
| item_type_code | String |  |
| type_code | Int |  |

### purchase_order_item_schedule_line

| Column | Type | Keys |
| --- | --- | --- |
| item_id | String | PK |
| item_schedule_line_id | String | PK |
| delivery_end_date | Instant |  |
| delivery_start_date | Instant |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| unit_code | String |  |

### return_to_supplier_text

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| return_to_supplier_uuid | String | PK, FK |
| creation_date | String |  |
| language_code | String |  |
| technical_id | String |  |
| text_content_technical_id | String |  |
| type_code | String |  |
| value | String |  |

### organisational_center

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### entitlement_product

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| customer_id | String | FK |
| product_category_id | String | FK |
| base_unit_code | String |  |
| created_date | Instant |  |
| customer_entitlement_id | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| valuation_unit_code | String |  |

### service_confirmation

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| actual_arrival_at_customer_time_point_terms_technical_id | String |  |
| actual_arrival_at_customer_time_point_terms_time_point_date | LocalDate |  |
| actual_arrival_at_customer_time_point_terms_time_point_type_name | String |  |
| buyer_id | String |  |
| buyer_party_key_party_id | String |  |
| buyer_technical_id | String |  |
| buyer_used_address_formatted_address_formatted_name | String |  |
| consistency_status_code | String |  |
| consistency_status_name | String |  |
| id | String |  |
| incident_completion_time_point_terms_technical_id | String |  |
| incident_completion_time_point_terms_time_point_date | LocalDate |  |
| incident_completion_time_point_terms_time_point_type_name | String |  |
| incident_service_issue_category_catalogue_key_service_issue_category_id | String |  |
| incident_service_issue_category_id | String |  |
| incident_service_issue_category_name_language_code | String |  |
| incident_service_issue_category_name_value | String |  |
| item_list_cancellation_status_code | String |  |
| item_list_cancellation_status_name | String |  |
| item_list_customer_order_life_cycle_status_code | String |  |
| item_list_customer_order_life_cycle_status_name | String |  |
| item_list_fulfilment_processing_status_code | String |  |
| item_list_fulfilment_processing_status_name | String |  |
| name_language_code | String |  |
| name_value | String |  |
| sales_terms_cancellation_reason_code | String |  |
| sales_terms_cancellation_reason_name | String |  |
| sales_terms_technical_id | String |  |
| service_performer_party_key_party_id | String |  |
| service_performer_technical_id | String |  |
| service_performer_used_address_formatted_address_formatted_name | String |  |
| service_point_location_technical_id | String |  |
| service_terms_service_issue_category_catalogue_category_key_service_issue_category_id | String |  |
| service_terms_service_issue_category_name_language_code | String |  |
| service_terms_service_issue_category_name_value | String |  |
| service_terms_technical_id | String |  |
| type_code | String |  |
| type_name | String |  |
| Document** |  |  |
| ItemOverview** |  |  |
| ServiceReferenceObject** |  |  |

### sales_quote_price_component

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| sales_quote_item_id | String | PK, FK |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| description_language_code | String |  |
| description_value | String |  |
| effective_indicator | Boolean |  |
| inactivity_reason_code | Int |  |
| rate | Double |  |
| rate_quantity_code | String |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_by_uuid | String | FK |
| last_changed_by_uuid | String | FK |
| creation_date | Instant |  |
| description_language_code | String |  |
| description_value | String |  |
| execution_step_type_code | String |  |
| execution_step_type_name | String |  |
| id | String |  |
| last_change_date | Instant |  |
| planned_end_date | LocalDate |  |
| planned_start_date | LocalDate |  |

### sales_order_contact_party

| Column | Type | Keys |
| --- | --- | --- |
| party_id | String | PK |
| address_host_uuid | String |  |
| main_indicator | Boolean |  |

### material_logistic

| Column | Type | Keys |
| --- | --- | --- |
| site_id | String | PK |
| material_uuid | String | PK, FK |
| life_cycle_status_code | Int |  |
| material_id | String |  |

### material_description

| Column | Type | Keys |
| --- | --- | --- |
| language_code | String | PK |
| uuid | String | PK, FK |
| description | String |  |
| description_id | String |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| created_date | Instant |  |
| employee_id | String |  |
| last_updated_date | Instant |  |
| workplace_address_building_id | String |  |
| workplace_address_correspondence_short_name | String |  |
| workplace_address_department_name | String |  |
| workplace_address_floor_id | String |  |
| workplace_address_functional_title_name | String |  |
| workplace_address_inhouse_mail_id | String |  |
| workplace_address_room_id | String |  |
| workplace_address_script_code | String |  |
| workplace_email_uri | String |  |
| workplace_mobile_phone | String |  |
| workplace_phone | String |  |

### sales_order_price_component

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| sales_order_item_id | String | PK, FK |
| sales_order_uuid | String | PK, FK |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| description_language_code | String |  |
| description_value | String |  |
| effective_indicator | Boolean |  |
| inactivity_reason_code | Int |  |
| rate | Double |  |
| rate_quantity_code | String |  |

### customer_contract_covered_object

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| customer_contract_uuid | String | PK, FK |
| product_category_hierarchy_id | String | FK |
| product_id | String | FK |
| registered_product_id | String | FK |
| customer_contract_id | String |  |

### service_product_description

| Column | Type | Keys |
| --- | --- | --- |
| language_code | String | PK |
| uuid | String | PK, FK |
| description | String |  |
| description_id | String |  |

### opportunity_lead_predecessor

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| opportunity_uuid | String | PK, FK |
| item_id | String | FK |
| id | String |  |
| item_type_code | String |  |
| opportunity_id | String |  |
| type_code | String |  |

### production_bill_of_material_item_group

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| production_bill_of_material_id | String | PK, FK |
| id | String |  |
| multi_select_allowed_indicator | Boolean |  |
| required_indicator | Boolean |  |

### sales_quote_item_product_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| sales_quote_item_id | String | PK, FK |
| taxation_characteristics_code | String |  |
| ProductTax** |  |  |
| TransactionProductTax** |  |  |

### sales_order_item_schedule_line

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_order_item_id | String | PK, FK |
| sales_order_uuid | String | PK, FK |
| end_date | Instant |  |
| measure_unit_name_language_code | String |  |
| measure_unit_name_value | String |  |
| product_availability_commitment_code | String |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| quantity_type_name_language_code | String |  |
| quantity_type_name_value | String |  |
| related_id | String |  |
| start_date | Instant |  |
| type_code | String |  |
| unit_code | String |  |

### production_model

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| product_id | String | FK |
| description_language_code | String |  |
| description_value | String |  |
| execution_enabled_indicator | String |  |
| maximum_lot_size_quantity | Double |  |
| maximum_lot_size_unit_code | String |  |
| minimum_lot_size_quantity | Double |  |
| minimum_lot_size_unit_code | String |  |
| planning_enabled_indicator | Boolean |  |
| product_specification_id | String |  |
| site_id | String |  |
| supply_planning_area_id | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |

### lease_contract

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| changed_by | String |  |
| created_by | String |  |
| created_date | Instant |  |
| currency_code | String |  |
| description | String |  |
| employee_responsible_id | String |  |
| external_reference_id | String |  |
| frame_agreement_id | String |  |
| historic_lease_contract_indicator | Boolean |  |
| id | String |  |
| inception_date | LocalDate |  |
| interest_rate_percent | Double |  |
| interest_rate_type_code | String |  |
| invoice_offset_days_number | Int |  |
| last_updated_date | Instant |  |
| lease_first_end_date | LocalDate |  |
| lease_start_date | LocalDate |  |
| lease_term_end_date | LocalDate |  |
| lease_term_in_months_number | Int |  |
| lessee_company_id | String |  |
| lessor_contact_person_id | String |  |
| lessor_id | String |  |
| lifecycle_status_code | String |  |
| transition_type | String |  |
| unlimited_lease_contract_indicator | Boolean |  |
| version_end_date | LocalDate |  |
| version_id | String |  |
| version_start_date | LocalDate |  |
| NoticeAgreement** |  |  |
| RenewalTerm** |  |  |

### return_to_supplier_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_uuid | String | PK |
| return_to_supplier_uuid | String | PK, FK |
| identified_stock_key_id | String | FK |
| product_requirement_specification_key_id | String | FK |
| supplier_part_number_id | String | FK |
| acceptance_status_code | String |  |
| cancellation_initiator_code | String |  |
| credit_memo_quantity | Double |  |
| credit_memo_unit_code | String |  |
| customer_return_reason_code | String |  |
| delivery_notification_id | String |  |
| inbound_delivery_id | String |  |
| inbound_delivery_line_item_id | String |  |
| language_code | String |  |
| line_item_id | String |  |
| product_id | String |  |
| purchase_order_id | String |  |
| purchase_order_item_id | String |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| replacement_date | String |  |
| replacement_quantity | Double |  |
| replacement_unit_code | String |  |
| ship_from_location_id | String |  |
| shipment_date | String |  |
| srmfollow_up_decision_type_code | String |  |
| unit_code | String |  |
| value | String |  |

### opportunity_activity_successor

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_uuid | String | PK, FK |
| id | String |  |
| item_id | String |  |
| item_type_code | String |  |
| item_uuid | String |  |
| opportunity_id | String |  |
| sales_cycle_code | String |  |
| sales_cycle_phase_code | String |  |
| sales_cycle_phase_step_code | String |  |
| type_code | String |  |
| uuid | String |  |

### shopping_cart_accounting_coding_block_assignment

| Column | Type | Keys |
| --- | --- | --- |
| shopping_cart_uuid | String | PK |
| technical_id | String | PK |
| company_id | String | FK |
| cost_centre_id | String | FK |
| customer_contract_uuid | String | FK |
| employee_id | String | FK |
| individual_material_id | String | FK |
| profit_centre_id | String | FK |
| project_reference_project_id | String | FK |
| sales_order_reference_id | String | FK |
| account_determination_expense_group_code | String |  |
| amount | Double |  |
| cost_object_reference_cost_object_id | String |  |
| cost_object_reference_cost_object_type_code | String |  |
| currency_code | String |  |
| financial_function_id | String |  |
| financial_fund_id | String |  |
| gl_account_alias_code | String |  |
| grant_id | String |  |
| individual_material_identifier_type_code | String |  |
| individual_material_type_code | String |  |
| percent | Double |  |
| project_task_key_task_id | String |  |
| quantity | Double |  |
| sales_order_name_language_code | String |  |
| sales_order_name_value | String |  |
| service_order_name_language_code | String |  |
| service_order_name_value | String |  |
| shopping_cart_id | String |  |
| type_code | String |  |
| unit_code | String |  |
| CustomerContract** |  |  |
| LeaseContractReference** |  |  |
| ProjectReference** |  |  |
| SalesOrderReference** |  |  |
| ServiceOrderReference** |  |  |

### entitlement_product_deviant_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| region_code | String |  |
| service_point_taxable_indicator | Boolean |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_type_code | String |  |

### product_category_description

| Column | Type | Keys |
| --- | --- | --- |
| language_code | String | PK |
| uuid | String | PK, FK |
| description | String |  |
| description_id | String |  |

### customer_contract_price_component

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| customer_contract_item_uuid | String | PK, FK |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| customer_contract_item_id | String |  |
| description_language_code | String |  |
| description_value | String |  |
| effective_indicator | Boolean |  |
| inactivity_reason_code | Int |  |
| rate | Double |  |
| rate_quantity_code | String |  |

### material_sale

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| sales_organisation_id | String | FK |
| distribution_channel_code | String |  |
| id | String |  |
| item_group_code | String |  |
| life_cycle_status_code | String |  |
| minimum_order_quantity_value | Double |  |
| reference_price_service_internal_id | String |  |

### supplier_partner_number

| Column | Type | Keys |
| --- | --- | --- |
| supplier_id | String | PK, FK |
| uuid | String | PK, FK |
| id | String |  |
| product_id | String |  |
| supplier_lead_time_duration | String |  |

### account_open_amount

| Column | Type | Keys |
| --- | --- | --- |
| account_id | String | PK, FK |
| company_id | String | PK, FK |
| credit_limit_amount | Double |  |
| credit_limit_currency_code | String |  |
| credit_limit_maintained_indicator | Boolean |  |
| current_spending_limit_amount | Double |  |
| current_spending_limit_currency_code | String |  |
| delivery_block_indicator | Boolean |  |
| doubtful_debtor_indicator | Boolean |  |
| invoice_block_indicator | Boolean |  |
| order_block_indicator | Boolean |  |
| receivables_balance_amount | Double |  |
| receivables_balance_currency_code | String |  |
| sales_order_amount | Double |  |
| sales_order_currency_code | String |  |
| service_order_amount | Double |  |
| service_order_currency_code | String |  |

### goods_and_service_ack_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| goods_and_service_ack_uuid | String | PK, FK |
| customer_id | String | FK |
| individual_material_id | String | FK |
| product_id | String | FK |
| product_recipient_id | String | FK |
| requestor_id | String | FK |
| delivery_period_end_date | Instant |  |
| delivery_period_start_date | Instant |  |
| goods_and_service_ack_id | String |  |
| gross_amount | Double |  |
| gross_currency_code | String |  |
| gross_unit_amount | Double |  |
| gross_unit_base_quantity | Double |  |
| gross_unit_base_quantity_type_code | String |  |
| gross_unit_base_unit_code | String |  |
| gross_unit_currency_code | String |  |
| id | String |  |
| individual_material_type_code | Int |  |
| limit_amount | Double |  |
| limit_currency_code | String |  |
| list_unit_amount | Double |  |
| list_unit_base_quantity | Double |  |
| list_unit_base_quantity_type_code | String |  |
| list_unit_base_unit_code | String |  |
| list_unit_currency_code | String |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| net_unit_amount | Double |  |
| net_unit_base_quantity | Double |  |
| net_unit_base_quantity_type_code | String |  |
| net_unit_base_unit_code | String |  |
| net_unit_currency_code | String |  |
| quantity | Double |  |
| quantity_type_code | String |  |
| ship_to_location_id | String |  |
| ship_to_location_technical_id | String |  |
| type_code | String |  |
| unit_code | String |  |
| Accounting** |  |  |
| PurchaseOrder** |  |  |

### service_request_time_point_term

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| service_request_uuid | String | PK, FK |
| date_calculation_function_reference_date_calculation_function_code | String |  |
| date_calculation_function_reference_date_calculation_function_group_code | String |  |
| date_calculation_function_reference_date_calculation_function_version_id | String |  |
| service_request_id | String |  |
| time_point_date | LocalDate |  |
| time_point_role_code | String |  |

### material_deviant_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| region_code | String |  |
| service_point_taxable_indicator | Boolean |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_type_code | String |  |

### organisational_centre_relationship

| Column | Type | Keys |
| --- | --- | --- |
| subordinate_id | String | PK, FK |
| superordinate_id | String | PK, FK |

### supplier_invoice_payment_installment

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | String | PK |
| supplier_invoice_uuid | String | PK, FK |
| description_language_code | String |  |
| description_value | String |  |
| due_amount | Double |  |
| due_currency_code | String |  |
| payment_due_date | LocalDate |  |
| percent | Double |  |
| reconciliation_account_code | String |  |
| supplier_invoice_id | String |  |

### opportunity_prospect_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_uuid | String | PK, FK |
| prospect_uuid | String | PK, FK |
| contact_id | String |  |
| prospect_id | String |  |

### material_valuation

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| business_residence_id | String |  |
| company_id | String |  |
| id | String |  |
| life_cycle_status_code | Int |  |

### customer_invoice

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| bill_from_id | String | FK |
| bill_to_id | String | FK |
| buyer_id | String | FK |
| invoicing_id | String | FK |
| original_invoice_reference_id | String | FK |
| payer_id | String | FK |
| reference_transaction_document_id | String | FK |
| seller_id | String | FK |
| tax_reporting_unit_id | String | FK |
| created_date | Instant |  |
| customer_tax_country_code | String |  |
| customer_tax_id | String |  |
| date | LocalDate |  |
| id | String |  |
| is_cancelled | Boolean |  |
| last_updated_date | Instant |  |
| processing_type_code | String |  |
| seller_tax_country_code | String |  |
| seller_tax_id | String |  |
| tax_due_date | LocalDate |  |
| PaymentControl** |  |  |

### account_address

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| account_uuid | String | PK, FK |
| account_id | String |  |
| correspondence_language_code | String |  |
| postal_additional_city_name | String |  |
| postal_additional_street_prefix_name | String |  |
| postal_additional_street_suffix_name | String |  |
| postal_care_of_name | String |  |
| postal_city_name | String |  |
| postal_company_postal_code | String |  |
| postal_country_code | String |  |
| postal_county_name | String |  |
| postal_district_name | String |  |
| postal_house_id | String |  |
| postal_po_box_postal_code | String |  |
| postal_region_code | String |  |
| postal_street_name | String |  |
| postal_street_postal_code | String |  |
| postal_street_prefix_name | String |  |
| postal_street_suffix_name | String |  |
| postal_tax_jurisdiction_code | String |  |
| postal_time_zone_code | String |  |
| preferred_communication_medium_code | String |  |
| telephone_formatted_number_description | String |  |
| telephone_mobile_phone_number_indicator | Boolean |  |
| usage_code | String |  |
| usage_default_indicator | Boolean |  |
| usage_validity_period_end_date | LocalDate |  |
| usage_validity_period_start_date | LocalDate |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| web_uri | String |  |

### supply_planning_area

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| hierarchy_uuid | String | PK, FK |
| hierarchy_id | String |  |
| id | String |  |
| product_assignment_allowed_indicator | Boolean |  |

### business_partner_hierarchy_request_group

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| business_partner_hierarchy_uuid | String | PK, FK |
| business_partner_hierarchy_id | String |  |
| business_partner_id | String |  |
| business_partner_uuid | String |  |
| id | String |  |
| name | String |  |
| note | String |  |

### appointment_activity_attendee

| Column | Type | Keys |
| --- | --- | --- |
| appointment_uuid | String | PK, FK |
| business_partner_id | String | PK, FK |
| appointment_id | String |  |
| email_uriuri | String |  |
| formatted_name | String |  |

### production_lot

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| order_uuid | String | FK |
| id | String |  |
| main_output_product_id | String |  |
| main_output_product_site_id | String |  |
| order_id | String |  |
| production_end_date | Instant |  |
| production_start_date | Instant |  |
| status_activity_process_code | Int |  |
| status_life_cycle_code | Int |  |
| status_rep_point_processing_code | Int |  |

### service_agent_relationship

| Column | Type | Keys |
| --- | --- | --- |
| relationship_business_partner_uuid | String | PK |
| service_agent_uuid | String | PK, FK |
| relationship_business_partner_internal_id | String |  |
| role_code | String |  |
| service_agent_id | String |  |

### supplier_invoice_product_tax_details

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| invoice_uuid | String | PK, FK |
| invoice_id | String |  |
| taxation_characteristics_code | String |  |
| taxation_characteristics_name | String |  |
| ProductTax** |  |  |
| TransactionProduct** |  |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| account_id | String | FK |
| bill_from_id | String | FK |
| bill_to_id | String | FK |
| buyer_id | String | FK |
| employee_responsible_id | String | FK |
| freight_forwarder_id | String | FK |
| payer_id | String | FK |
| product_recipient_id | String | FK |
| sales_employee_party_id | String | FK |
| sales_partner_id | String | FK |
| sales_unit_id | String | FK |
| seller_id | String | FK |
| service_execution_team_id | String | FK |
| service_performer_id | String | FK |
| cash_discount_terms_code | String |  |
| cash_discount_terms_payment_baseline_date | Instant |  |
| currency_code | String |  |
| data_origin_type_code | String |  |
| fulfillment_blocking_reason_code | String |  |
| id | String |  |
| incoterms_code | String |  |
| incoterms_location | String |  |
| invoice_terms_invoicing_blocking_reason_code | String |  |
| invoice_terms_proposed_invoice_date | LocalDate |  |
| name_language_code | String |  |
| name_value | String |  |
| posting_date | Instant |  |
| requested_fulfillment_period_end_date | Instant |  |
| requested_fulfillment_period_start_date | Instant |  |
| sales_terms_cancellation_reason_code | String |  |
| service_confirmation_creation_code_code | String |  |
| Status** |  |  |

### service_product_withholding_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| il_last_change_date | LocalDate |  |
| il_service_and_shaam_group | String |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_recipient_code | String |  |
| tax_type_code | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| withholding_tax_certificate_id | String |  |
| withholding_tax_income_type_code | String |  |

### production_lot_service

| Column | Type | Keys |
| --- | --- | --- |
| service_uuid | String | PK |
| confirmation_group_uuid | String | PK, FK |
| confirmation_finished | Boolean |  |
| confirmed_quantity | Double |  |
| confirmed_unit_code | String |  |
| main_resource | Boolean |  |
| resource_id | String |  |
| service_consumption_calculation_method_code | String |  |
| service_description | String |  |
| service_id | String |  |
| total_confirmed_quantity | Double |  |
| total_confirmed_unit_code | String |  |

### outbound_delivery

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| processing_type_code | String |  |
| release_status_code | Int |  |

### service_product_valuation_data_cost_rate

| Column | Type | Keys |
| --- | --- | --- |
| set_of_books_id | String | PK |
| service_product_uuid | String | PK, FK |
| company_id | String | FK |
| amount | Double |  |
| currency_code | String |  |
| end_date | LocalDate |  |
| quantity | Double |  |
| service_product_id | String |  |
| start_date | LocalDate |  |
| unit_code | String |  |

### supplier_invoice_items

| Column | Type | Keys |
| --- | --- | --- |
| invoice_uuid | String | PK |
| uuid | String | PK |
| purchase_order_uuid | String | FK |
| cost_distribution_indicator | String |  |
| cost_distribution_percent | String |  |
| delivery_period | String |  |
| description | String |  |
| end_buyer_uuid | String |  |
| gross_amount | String |  |
| id | String |  |
| internal_charge_to_uuid | String |  |
| invoice_id | String |  |
| invoicing_period | String |  |
| net_amount | String |  |
| parent_item_type_code | String |  |
| parent_item_uuid | String |  |
| product_id | String |  |
| product_recipient_uuid | String |  |
| quantity | String |  |
| quantity_type_code | String |  |
| requestor_uuid | String |  |
| service_performer_uuid | String |  |
| ship_from_location_id | String |  |
| ship_to_location_id | String |  |
| type_code | String |  |

### price_list

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| approval_status_code | Int |  |
| consistency_status_code | Int |  |
| created_date | Instant |  |
| currency_code | String |  |
| id | String |  |
| last_updated_date | Instant |  |
| not_released_price_specification_elements_value | String |  |
| price_specification_list_release_status_code | Int |  |
| property_value_search_text | String |  |
| release_status_code | Int |  |
| type_code | String |  |
| ValidityPeriod** |  |  |

### business_partner_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| id | String |  |
| name | String |  |

### purchase_request_item

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| purchase_request_uuid | String | PK, FK |
| company_id | String | FK |
| employee_responsible_id | String | FK |
| preferred_supplier_id | String | FK |
| product_id | String | FK |
| purchasing_unit_id | String | FK |
| recipient_id | String | FK |
| request_id | String | FK |
| service_agent_id | String | FK |
| supplier_id | String | FK |
| supplier_part_number_id | String | FK |
| delivery_end_date | Instant |  |
| delivery_start_date | Instant |  |
| direct_material_indicator | Boolean |  |
| gross_unit_price_amount | Double |  |
| gross_unit_price_base_quantity | Double |  |
| gross_unit_price_base_quantity_type_code | String |  |
| gross_unit_price_base_unit_code | String |  |
| gross_unit_price_currency_code | String |  |
| id | String |  |
| net_amount | Double |  |
| net_currency_code | String |  |
| net_unit_price_amount | Double |  |
| net_unit_price_base_quantity | Double |  |
| net_unit_price_base_quantity_type_code | String |  |
| net_unit_price_base_unit_code | String |  |
| net_unit_price_currency_code | String |  |
| open_quantity | Double |  |
| open_unit_code | String |  |
| purchase_request_id | String |  |
| quantity | Double |  |
| release_quantity | Double |  |
| release_unit_code | String |  |
| ship_to_location_id | String |  |
| site_location_id | String |  |
| type | String |  |
| unit_code | String |  |

### supplier_deviant_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| region_code | String |  |
| service_point_taxable_indicator | Boolean |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_type_code | String |  |

### supplier_withholding_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| il_last_change_date | LocalDate |  |
| il_service_and_shaam_group | String |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_recipient_code | String |  |
| tax_type_code | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| withholding_tax_certificate_id | String |  |
| withholding_tax_income_type_code | String |  |

### working_time_model

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| country_code | String |  |
| description_language_code | String |  |
| description_uuid | String |  |
| description_value | String |  |
| id | String |  |
| type_code | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| WorkingTime** |  |  |

### material_withholding_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| uuid | String | PK, FK |
| country_code | String |  |
| id | String |  |
| il_last_change_date | LocalDate |  |
| il_service_and_shaam_group | String |  |
| tax_exemption_reason_code | String |  |
| tax_rate_type_code | String |  |
| tax_recipient_code | String |  |
| tax_type_code | String |  |
| validity_period_end_date | LocalDate |  |
| validity_period_start_date | LocalDate |  |
| withholding_tax_certificate_id | String |  |
| withholding_tax_income_type_code | String |  |

### production_lot_confirmation_group_activity

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK |
| confirmation_group_uuid | String | PK, FK |
| activity_uuid | String |  |
| category_code | String |  |
| confirmation_completed_indicator | Boolean |  |
| end_date | Instant |  |
| material_inspection_uuid | String |  |
| open_duration | String |  |
| planned_duration | String |  |
| start_date | Instant |  |
| total_confirmed_duration | String |  |
| type_code | String |  |

### production_lot_confirmation_group_material_input

| Column | Type | Keys |
| --- | --- | --- |
| material_input_uuid | String | PK |
| confirmation_group_uuid | String | PK, FK |
| identified_stock_id | String | FK |
| activity_id | String |  |
| activity_type_code | String |  |
| activity_uuid | String |  |
| confirm_logistics_area_id | String |  |
| confirm_quantity | Double |  |
| confirm_unit_code | String |  |
| confirmation_finished | Boolean |  |
| confirmation_method_code | String |  |
| identified_stock_type_code | String |  |
| input_product_quantity | Double |  |
| input_product_unit_code | String |  |
| line_item_group_id | String |  |
| operation_id | String |  |
| planned_indicator | Boolean |  |
| planned_quantity | Double |  |
| planned_unit_code | String |  |
| product_id | String |  |
| product_specification_id | String |  |
| product_uuid | String |  |
| site_id | String |  |
| source_logistics_area_id | String |  |
| supply_planning_area_uuid | String |  |
| total_confirmed_quantity | Double |  |
| total_confirmed_unit_code | String |  |

### service_product_valuation_data

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| account_determination_group_code | String |  |
| company_id | String |  |
| created_date | Instant |  |
| id | String |  |
| last_updated_date | Instant |  |
| life_cycle_status_code | String |  |

### sales_quote_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| sales_quote_uuid | String | PK, FK |
| buyer_id | String | FK |
| product_id | String | FK |
| vendor_id | String | FK |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| description_language_code | String |  |
| description_value | String |  |
| discount_amount | Double |  |
| discount_currency_code | String |  |
| discount_rate | Double |  |
| effective_indicator | Boolean |  |
| fulfilment_category_code | String |  |
| inactivity_reason_code | Int |  |
| optional_indicator | Boolean |  |
| posting_date | String |  |
| processing_type_code | String |  |
| rate | Double |  |
| rate_quantity_code | String |  |
| sales_quote_id | String |  |
| ship_from_location_id | String |  |
| Status** |  |  |

### equipment_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| equipment_uuid | String | PK, FK |
| description | String |  |
| language_code | String |  |

### production_lot_confirmation_group_operation

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| confirmation_group_uuid | String | PK, FK |
| activity_process_code | Int |  |
| category_code | String |  |
| confirm_main_resource_id | String |  |
| confirm_main_resource_uuid | String |  |
| description_language_code | String |  |
| description_value | String |  |
| end_date | Instant |  |
| id | String |  |
| life_cycle_code | Int |  |
| rep_point_processing_code | Int |  |
| start_date | Instant |  |
| type_code | String |  |

### sales_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| sales_order_uuid | String | PK, FK |
| buyer_id | String | FK |
| product_id | String | FK |
| service_performer_id | String | FK |
| vendor_id | String | FK |
| accounting_block_distribution_id | String |  |
| basis_code | String |  |
| basis_quantity | Double |  |
| basis_quantity_code | String |  |
| basis_unit_code | String |  |
| calculated_amount | Double |  |
| calculated_currency_code | String |  |
| currency_code | String |  |
| description_language_code | String |  |
| description_value | String |  |
| discount_amount | Double |  |
| discount_currency_code | String |  |
| discount_rate | Double |  |
| effective_indicator | Boolean |  |
| inactivity_reason_code | Int |  |
| processing_type_code | String |  |
| rate | Double |  |
| rate_quantity_code | String |  |
| sales_order_id | String |  |
| ship_from_location_id | String |  |
| Status** |  |  |

### site_logistics_task

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| customer_id | String | FK |
| business_transaction_document_reference_id | String |  |
| customer_name_language_code | String |  |
| customer_name_value | String |  |
| earliest_execution_start_date | Instant |  |
| id | String |  |
| latest_execution_end_date | Instant |  |
| operation_type_code | String |  |
| referenced_object_operation_activity_uuid | String |  |
| referenced_object_uuid | String |  |

### goods_and_service_ack

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| approval_status_code | String |  |
| buyer_id | String |  |
| buyer_type_code | String |  |
| cancellation_status_code | String |  |
| consistency_status_code | String |  |
| data_entry_processing_status_code | String |  |
| delivery_note_id | String |  |
| goods_return_status_code | String |  |
| id | String |  |
| life_cycle_status_code | String |  |
| po_id | String |  |
| posting_date | LocalDate |  |
| release_status_code | String |  |
| supplier_id | String |  |
| supplier_type_code | String |  |

### customer_contract_item_entitled_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| item_uuid | String | PK, FK |
| entitlement_product_id | String | FK |
| product_category_hierarchy_id | String | FK |
| description_language_code | String |  |
| description_value | String |  |
| item_id | String |  |
| type_code | String |  |

### registered_product

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| account_id | String | FK |
| contact_id | String | FK |
| material_id | String | FK |
| parent_registered_reference_id | String | FK |
| supplier_id | String | FK |
| account_type_code | String |  |
| contact_type_code | String |  |
| created_date | Instant |  |
| description_language_code | String |  |
| description_value | String |  |
| id | String |  |
| inventory_status_code | String |  |
| last_updated_date | Instant |  |
| material_type_code | Int |  |
| parent_registered_product_id | String |  |
| parent_registered_reference_type_code | Int |  |
| status | String |  |
| supplier_type_code | String |  |
| warranty_end_date | LocalDate |  |
| warranty_id | String |  |
| warranty_reference_date | LocalDate |  |
| warranty_start_date | LocalDate |  |
| Location** |  |  |

### opportunity_sales_order_successor

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| opportunity_uuid | String | PK, FK |
| item_id | String | FK |
| id | String |  |
| item_type_code | String |  |
| opportunity_id | String |  |
| type_code | String |  |

### document_output_request_information

| Column | Type | Keys |
| --- | --- | --- |
| uuid | String | PK |
| host_document_id | String |  |
| host_object_node_id | String |  |
| host_object_node_type_code | String |  |
| host_object_type_code | String |  |
| output_attachments_uuid | String |  |
| recipient_business_partner_uuid | String |  |
| responsible_identity_id | String |  |
| sender_company_id | String |  |
| sender_organisational_centre_id | String |  |
| DocumentDetails** |  |  |
| OutputDetails** |  |  |

## Relationships

- customer_contract_item(customer_contract_uuid) → customer_contract(uuid)
- customer_partner_number(uuid) → material(uuid)
- customer_partner_number(customer_id) → account(uuid)
- shopping_cart(buyer_id) → business_partner(uuid)
- shopping_cart(employee_responsible_id) → business_partner(uuid)
- shopping_cart(requestor_id) → business_partner(uuid)
- shopping_cart(recipient_id) → business_partner(uuid)
- lease_contract_item(lease_contract_uuid) → lease_contract(uuid)
- material(product_category_id) → product_category(uuid)
- service_request_duration_term(service_request_uuid) → service_request(uuid)
- opportunity_item(opportunity_uuid) → opportunity(uuid)
- opportunity_item(product_id) → material(uuid)
- opportunity_item(product_category_hierarchy_id) → product_category_hierarchy(uuid)
- opportunity_item(product_category_id) → product_category(uuid)
- journal_entry(company_id) → organisational_centre(id)
- allocation_document_item(allocation_document_id) → allocation_document(id)
- allocation_document_item(purchase_order_item_id) → purchase_order_item(purchase_order_uuid)
- allocation_document_item(supplier_id) → supplier(uuid)
- journal_entry_item(journal_entry_uuid) → journal_entry(uuid)
- journal_entry_item(profit_centre_id) → organisational_centre(id)
- journal_entry_item(partner_company_id) → partner_company(uuid)
- journal_entry_item(product_id) → material(uuid)
- journal_entry_item(product_category_id) → product_category(uuid)
- journal_entry_item(production_lot_id) → production_lot(uuid)
- journal_entry_item(individual_material_id) → material(uuid)
- journal_entry_item(sales_unit_id) → business_partner(uuid)
- journal_entry_item(cost_centre_id) → organisational_centre(id)
- journal_entry_item(employee_id) → employee(uuid)
- service_product_supplier_info(supplier_internal_id) → supplier(uuid)
- service_product_supplier_info(service_product_uuid) → service_product(uuid)
- email_activity(message_from_id) → business_partner(uuid)
- email_activity(message_to_id) → business_partner(uuid)
- email_activity(copy_message_to_id) → business_partner(uuid)
- email_activity(blind_copy_message_to_id) → business_partner(uuid)
- email_activity(employee_responsible_id) → employee(uuid)
- email_activity(main_activity_id) → business_partner(uuid)
- email_activity(activity_unit_id) → business_partner(uuid)
- business_partner_address(business_partner_uuid) → business_partner(uuid)
- sales_quote(buyer_id) → business_partner(uuid)
- sales_quote(bill_to_id) → business_partner(uuid)
- sales_quote(account_id) → business_partner(uuid)
- sales_quote(payer_id) → business_partner(uuid)
- sales_quote(product_recipient_id) → business_partner(uuid)
- sales_quote(sales_partner_id) → business_partner(uuid)
- sales_quote(freight_forwarder_id) → business_partner(uuid)
- sales_quote(employee_responsible_id) → employee(uuid)
- sales_quote(seller_id) → business_partner(uuid)
- sales_quote(sales_unit_id) → business_partner(uuid)
- sales_quote(sales_employee_id) → employee(uuid)
- sales_quote(bill_from_id) → business_partner(uuid)
- business_partner_person(business_partner_uuid) → business_partner(uuid)
- opportunity_sales_quote_successor(opportunity_uuid) → opportunity(uuid)
- opportunity_sales_quote_successor(item_id) → sales_quote(uuid)
- purchase_order_item(purchase_order_uuid) → purchase_order(uuid)
- purchase_order_item(product_id) → registered_product(uuid)
- purchase_order_item(product_id) → material(uuid)
- purchase_order_item(product_id) → product_requirement_specification(uuid)
- purchase_order_item(product_seller_id) → business_partner(uuid)
- purchase_order_item(individual_material_id) → material(uuid)
- purchase_order_item(product_recipient_uuid) → business_partner(uuid)
- purchase_order_item(service_performer_uuid) → business_partner(uuid)
- purchase_order_item(requestor_uuid) → business_partner(uuid)
- purchase_order_item(taxation_seller_id) → business_partner(uuid)
- purchase_order_item(taxation_buyer_id) → business_partner(uuid)
- shopping_cart_item(shopping_cart_uuid) → shopping_cart(uuid)
- shopping_cart_item(product_standard_id) → registered_product(uuid)
- shopping_cart_item(supplier_party_key_id) → business_partner(uuid)
- shopping_cart_item(preferred_supplier_key_id) → business_partner(uuid)
- shopping_cart_item(recipient_key_id) → business_partner(uuid)
- shopping_cart_item(customer_key_id) → business_partner(uuid)
- production_lot_confirmation_group_production_task(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- phone_activity(communication_id) → business_partner(uuid)
- phone_activity(employee_responsible_id) → employee(uuid)
- phone_activity(main_activity_id) → business_partner(uuid)
- phone_activity(reference_id) → business_partner(uuid)
- phone_activity(activity_unit_id) → business_partner(uuid)
- service_request(processor_id) → business_partner(uuid)
- service_request(service_execution_id) → business_partner(uuid)
- service_request(sales_unit_id) → business_partner(uuid)
- service_request(buyer_party_id) → business_partner(uuid)
- service_product_valuation(uuid) → service_product(uuid)
- allocation_document(invoice_id) → customer_invoice(uuid)
- allocation_document(invoice_item_id) → customer_invoice_item(id)
- allocation_document(product_id) → registered_product(uuid)
- allocation_document(product_category_id) → product_category(uuid)
- allocation_document(supplier_id) → supplier(uuid)
- appointment_activity(organizer_id) → business_partner(uuid)
- appointment_activity(employee_responsible_id) → employee(uuid)
- appointment_activity(main_activity_id) → supplier(uuid)
- appointment_activity(activity_unit_id) → contact(uuid)
- opportunity_sales_partner(opportunity_uuid) → opportunity(uuid)
- opportunity_sales_partner(partner_uuid) → business_partner(uuid)
- working_time_period_item(working_time_model_uuid) → working_time_model(uuid)
- customer_contract(buyer_id) → account(uuid)
- customer_contract(buyer_contact_id) → contact(uuid)
- production_lot_confirmation_group_reporting_point(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- sales_order_item_product_tax_details(sales_order_item_id) → sales_order_item(sales_order_uuid)
- sales_order_item_product_tax_details(sales_order_uuid) → sales_order(uuid)
- production_order(lot_id) → production_lot(uuid)
- customer_invoice_item(product_id) → material(uuid)
- customer_invoice_item(employee_responsible_id) → employee(uuid)
- customer_invoice_item(kit_item_list_id) → kit_item_list(kit_id)
- customer_invoice_item(sales_service_organisation_id) → business_partner(uuid)
- customer_invoice_item(product_recipient_id) → business_partner(uuid)
- customer_invoice_item(sales_order_id) → sales_order(uuid)
- customer_invoice_item(purchase_order_id) → purchase_order(uuid)
- customer_invoice_item(service_confirmation_id) → service_confirmation(uuid)
- customer_invoice_item(customer_return_id) → account(uuid)
- customer_invoice_item(outbound_delivery_id) → outbound_delivery(uuid)
- customer_invoice_item(original_invoice_id) → customer_invoice(uuid)
- customer_invoice_item(customer_contract_id) → customer_contract(uuid)
- supplier_invoice_item(invoice_uuid) → supplier_invoice(uuid)
- supplier_invoice_item(product_id) → material(uuid)
- supplier_invoice_item(product_recipient_uuid) → business_partner(uuid)
- supplier_invoice_item(requestor_uuid) → employee(uuid)
- supplier_invoice_item(service_performer_uuid) → employee(uuid)
- supplier_invoice_item(end_buyer_uuid) → business_partner(uuid)
- supplier_invoice_item(internal_charge_to_uuid) → business_partner(uuid)
- site_logistics_lot_material_output(site_logistics_task_uuid) → site_logistics_task(uuid)
- site_logistics_lot_material_output(material_id) → material(uuid)
- site_logistics_lot_material_output(identified_stock_id) → identified_stock(id)
- purchase_order(goods_and_service_acknowledgement_id) → goods_and_service_ack(uuid)
- purchase_order(purchasing_contract_id) → purchasing_contract(uuid)
- purchase_order(outbound_delivery_id) → outbound_delivery(uuid)
- purchase_order(purchase_request_id) → purchase_request(uuid)
- supplier_invoice(bill_to_uuid) → business_partner(uuid)
- supplier_invoice(buyer_uuid) → business_partner(uuid)
- supplier_invoice(payee_uuid) → business_partner(uuid)
- supplier_invoice(customer_uuid) → account(uuid)
- supplier_invoice(payer_uuid) → business_partner(uuid)
- supplier_invoice(seller_uuid) → business_partner(uuid)
- supplier_invoice(bill_from_uuid) → business_partner(uuid)
- supplier_invoice_withholding_tax_details(invoice_uuid) → supplier_invoice(uuid)
- return_to_supplier_line_item_text(return_to_supplier_item_uuid) → return_to_supplier_line_item(return_to_supplier_uuid)
- product_category_hierarchy_description(uuid) → product_category_hierarchy(uuid)
- service_request_reference_object(service_request_uuid) → service_request(uuid)
- service_request_reference_object(individual_material_id) → material(uuid)
- material_quantity_characteristic(material_uuid) → material(uuid)
- supplier_invoice_item_product_tax_details(item_invoice_uuid) → supplier_invoice_tax_calculation_item(invoice_uuid)
- kit_item_list_component(kit_item_list_id) → kit_item_list(kit_id)
- business_partner_contact(business_partner_uuid) → business_partner(uuid)
- business_partner_contact(contact_id) → contact(uuid)
- service_product_sale(sales_organisation_id) → organisational_centre(id)
- service_product_sale(uuid) → service_product(uuid)
- supplier_invoice_tax_calculation_item(invoice_uuid) → supplier_invoice(uuid)
- service_product_customer_info(service_product_uuid) → service_product(uuid)
- service_product_customer_info(customer) → business_partner(uuid)
- opportunity_sales_employee(opportunity_id) → opportunity(uuid)
- opportunity_sales_employee(employee_uuid) → employee(uuid)
- service_product(product_category_id) → product_category(uuid)
- production_bill_of_material_item_group_change_state(item_uuid) → production_bill_of_material_item(uuid)
- production_bill_of_material_item_group_change_state(input_product_id) → material(uuid)
- goods_and_activity_confirmation(main_inventory_separating_material_id) → material(uuid)
- goods_and_activity_confirmation(main_inventory_separating_owner_party_id) → business_partner(uuid)
- goods_and_activity_confirmation(main_inventory_separating_supply_planning_area_id) → supply_planning_area(id)
- goods_and_activity_confirmation(identified_stock_inventory_separating_id) → identified_stock(id)
- goods_and_activity_confirmation(identified_stock_inventory_separating_id) → material(uuid)
- goods_and_activity_confirmation(special_stock_inventory_separating_reference_id) → outbound_delivery(uuid)
- goods_and_activity_confirmation(confirmation_company_id) → business_partner(uuid)
- goods_and_activity_confirmation(outbound_delivery_root_id) → outbound_delivery(uuid)
- goods_and_activity_confirmation(outbound_delivery_product_recipient_id) → business_partner(uuid)
- customer_contract_item_product_tax_details(customer_contract_item_uuid) → customer_contract_item(uuid)
- production_bill_of_material(variant_product_id) → material(uuid)
- production_bill_of_material(variant_product_requirement_specification_id) → product_requirement_specification(uuid)
- production_bill_of_material(variant_state_input_product_id) → material(uuid)
- production_bill_of_material_item(item_group_uuid) → production_bill_of_material_item_group(uuid)
- opportunity(prospect_uuid) → account(uuid)
- opportunity(employee_responsible_uuid) → employee(uuid)
- opportunity(sales_unit_uuid) → business_partner(uuid)
- opportunity(organisation_id) → business_partner(uuid)
- project(buyer_party_id) → business_partner(uuid)
- task_activity(processor_id) → business_partner(uuid)
- task_activity(employee_responsible_id) → employee(uuid)
- task_activity(main_activity_id) → business_partner(uuid)
- task_activity(reference_id) → business_partner(uuid)
- task_activity(activity_unit_id) → business_partner(uuid)
- person_history(employee_uuid) → employee(uuid)
- supplier_business_partner_relationship(relationship_supplier_uuid) → supplier(uuid)
- opportunity_competitor(opportunity_uuid) → opportunity(uuid)
- opportunity_competitor(competitor_uuid) → business_partner(uuid)
- production_lot_confirmation_group(production_lot_uuid) → production_lot(uuid)
- entitlement_product_valuation(uuid) → entitlement_product(uuid)
- vehicle_description(vehicle_uuid) → vehicle(uuid)
- sales_quote_item_schedule_line(sales_quote_item_id) → sales_quote_item(sales_quote_uuid)
- service_confirmation_item(service_confirmation_uuid) → service_confirmation(uuid)
- service_confirmation_item(product_identified_stock_key_id) → identified_stock(id)
- project_task(project_uuid) → project(uuid)
- partner_company(id) → organisational_centre(id)
- account_contact(account_uuid) → account(uuid)
- account_contact(contact_id) → contact(uuid)
- account_contact(contact_uuid) → contact(uuid)
- material_supply_planning(material_uuid) → material(uuid)
- site_logistics_lot_material_input(site_logistics_task_uuid) → site_logistics_task(uuid)
- site_logistics_lot_material_input(material_id) → material(uuid)
- site_logistics_lot_material_input(identified_stock_id) → identified_stock(id)
- bank_statement_item(bank_statement_uuid) → bank_statement(uuid)
- service_request_period_term(service_request_uuid) → service_request(uuid)
- entitlement_product_sale(sales_organisation_id) → organisational_centre(id)
- entitlement_product_sale(uuid) → entitlement_product(uuid)
- labour_description(labour_uuid) → labour(uuid)
- employee_assignment_history(employee_uuid) → employee(uuid)
- opportunity_activity_predecessor(opportunity_uuid) → opportunity(uuid)
- opportunity_activity_predecessor(item_id) → appointment_activity(uuid)
- production_lot_confirmation_group_material_output(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- production_lot_confirmation_group_material_output(identified_stock_id) → identified_stock(id)
- production_lot_confirmation_group_material_output(inspection_sample_identified_stock_id) → identified_stock(id)
- material_availability_confirmation(material_uuid) → material(uuid)
- entitlement_product_description(uuid) → entitlement_product(uuid)
- service_product_deviant_tax_classification(uuid) → service_product(uuid)
- identified_stock(supplier_id) → supplier(uuid)
- customer_contract_business_transaction_document_reference(contract_uuid) → customer_contract(uuid)
- return_to_supplier_text(return_to_supplier_uuid) → return_to_supplier(uuid)
- entitlement_product(product_category_id) → product_category(uuid)
- entitlement_product(customer_id) → account(uuid)
- sales_quote_price_component(sales_quote_item_id) → sales_quote_item(sales_quote_uuid)
- campaign(created_by_uuid) → business_partner(uuid)
- campaign(last_changed_by_uuid) → business_partner(uuid)
- material_logistic(material_uuid) → material(uuid)
- material_description(uuid) → material(uuid)
- sales_order_price_component(sales_order_item_id) → sales_order_item(sales_order_uuid)
- sales_order_price_component(sales_order_uuid) → sales_order(uuid)
- customer_contract_covered_object(customer_contract_uuid) → customer_contract(uuid)
- customer_contract_covered_object(registered_product_id) → registered_product(uuid)
- customer_contract_covered_object(product_id) → material(uuid)
- customer_contract_covered_object(product_category_hierarchy_id) → product_category_hierarchy(uuid)
- service_product_description(uuid) → service_product(uuid)
- opportunity_lead_predecessor(opportunity_uuid) → opportunity(uuid)
- opportunity_lead_predecessor(item_id) → lead(uuid)
- production_bill_of_material_item_group(production_bill_of_material_id) → production_bill_of_material(id)
- sales_quote_item_product_tax_details(sales_quote_item_id) → sales_quote_item(sales_quote_uuid)
- sales_order_item_schedule_line(sales_order_item_id) → sales_order_item(sales_order_uuid)
- sales_order_item_schedule_line(sales_order_uuid) → sales_order(uuid)
- production_model(product_id) → registered_product(uuid)
- return_to_supplier_line_item(return_to_supplier_uuid) → return_to_supplier(uuid)
- return_to_supplier_line_item(supplier_part_number_id) → supplier_partner_number(uuid)
- return_to_supplier_line_item(identified_stock_key_id) → identified_stock(id)
- return_to_supplier_line_item(product_requirement_specification_key_id) → product_requirement_specification(uuid)
- opportunity_activity_successor(opportunity_uuid) → opportunity(uuid)
- shopping_cart_accounting_coding_block_assignment(customer_contract_uuid) → customer_contract(uuid)
- shopping_cart_accounting_coding_block_assignment(profit_centre_id) → organisational_centre(id)
- shopping_cart_accounting_coding_block_assignment(cost_centre_id) → organisational_centre(id)
- shopping_cart_accounting_coding_block_assignment(individual_material_id) → material(uuid)
- shopping_cart_accounting_coding_block_assignment(project_reference_project_id) → project(uuid)
- shopping_cart_accounting_coding_block_assignment(sales_order_reference_id) → sales_order(uuid)
- shopping_cart_accounting_coding_block_assignment(employee_id) → employee(uuid)
- shopping_cart_accounting_coding_block_assignment(company_id) → partner_company(uuid)
- entitlement_product_deviant_tax_classification(uuid) → entitlement_product(uuid)
- product_category_description(uuid) → product_category(uuid)
- customer_contract_price_component(customer_contract_item_uuid) → customer_contract_item(uuid)
- material_sale(sales_organisation_id) → organisational_centre(id)
- material_sale(uuid) → material(uuid)
- supplier_partner_number(uuid) → material(uuid)
- supplier_partner_number(supplier_id) → supplier(uuid)
- account_open_amount(company_id) → business_partner(uuid)
- account_open_amount(account_id) → account(uuid)
- goods_and_service_ack_item(goods_and_service_ack_uuid) → goods_and_service_ack(uuid)
- goods_and_service_ack_item(product_id) → product_requirement_specification(uuid)
- goods_and_service_ack_item(customer_id) → business_partner(uuid)
- goods_and_service_ack_item(requestor_id) → business_partner(uuid)
- goods_and_service_ack_item(product_recipient_id) → business_partner(uuid)
- goods_and_service_ack_item(individual_material_id) → material(uuid)
- service_request_time_point_term(service_request_uuid) → service_request(uuid)
- material_deviant_tax_classification(uuid) → material(uuid)
- organisational_centre_relationship(superordinate_id) → organisational_centre(id)
- organisational_centre_relationship(subordinate_id) → organisational_centre(id)
- supplier_invoice_payment_installment(supplier_invoice_uuid) → supplier_invoice(uuid)
- opportunity_prospect_contact(prospect_uuid) → opportunity(uuid)
- opportunity_prospect_contact(contact_uuid) → contact(uuid)
- material_valuation(uuid) → material(uuid)
- customer_invoice(original_invoice_reference_id) → customer_invoice(uuid)
- customer_invoice(reference_transaction_document_id) → customer_invoice(uuid)
- customer_invoice(seller_id) → partner_company(uuid)
- customer_invoice(buyer_id) → business_partner(uuid)
- customer_invoice(bill_to_id) → business_partner(uuid)
- customer_invoice(payer_id) → business_partner(uuid)
- customer_invoice(bill_from_id) → business_partner(uuid)
- customer_invoice(invoicing_id) → business_partner(uuid)
- customer_invoice(tax_reporting_unit_id) → business_partner(uuid)
- account_address(account_uuid) → account(uuid)
- product_category(hierarchy_uuid) → product_category_hierarchy(uuid)
- business_partner_hierarchy_request_group(business_partner_hierarchy_uuid) → business_partner_hierarchy(uuid)
- appointment_activity_attendee(appointment_uuid) → appointment_activity(uuid)
- appointment_activity_attendee(business_partner_id) → business_partner(uuid)
- production_lot(order_uuid) → production_order(uuid)
- service_agent_relationship(service_agent_uuid) → service_agent(uuid)
- supplier_invoice_product_tax_details(invoice_uuid) → supplier_invoice(uuid)
- sales_order(buyer_id) → business_partner(uuid)
- sales_order(bill_to_id) → business_partner(uuid)
- sales_order(account_id) → account(uuid)
- sales_order(payer_id) → business_partner(uuid)
- sales_order(product_recipient_id) → business_partner(uuid)
- sales_order(sales_partner_id) → business_partner(uuid)
- sales_order(freight_forwarder_id) → business_partner(uuid)
- sales_order(employee_responsible_id) → employee(uuid)
- sales_order(seller_id) → business_partner(uuid)
- sales_order(sales_unit_id) → business_partner(uuid)
- sales_order(service_execution_team_id) → business_partner(uuid)
- sales_order(service_performer_id) → business_partner(uuid)
- sales_order(sales_employee_party_id) → employee(uuid)
- sales_order(bill_from_id) → business_partner(uuid)
- service_product_withholding_tax_classification(uuid) → service_product(uuid)
- production_lot_service(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- service_product_valuation_data_cost_rate(service_product_uuid) → service_product_valuation_data(uuid)
- service_product_valuation_data_cost_rate(company_id) → business_partner(uuid)
- supplier_invoice_items(purchase_order_uuid) → purchase_order(uuid)
- purchase_request_item(purchase_request_uuid) → purchase_request(uuid)
- purchase_request_item(product_id) → material(uuid)
- purchase_request_item(supplier_part_number_id) → supplier_partner_number(uuid)
- purchase_request_item(company_id) → organisational_centre(id)
- purchase_request_item(request_id) → business_partner(uuid)
- purchase_request_item(recipient_id) → business_partner(uuid)
- purchase_request_item(employee_responsible_id) → employee(uuid)
- purchase_request_item(purchasing_unit_id) → business_partner(uuid)
- purchase_request_item(preferred_supplier_id) → supplier(uuid)
- purchase_request_item(supplier_id) → supplier(uuid)
- purchase_request_item(service_agent_id) → business_partner(uuid)
- supplier_deviant_tax_classification(uuid) → supplier(uuid)
- supplier_withholding_tax_classification(uuid) → supplier(uuid)
- material_withholding_tax_classification(uuid) → material(uuid)
- production_lot_confirmation_group_activity(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- production_lot_confirmation_group_material_input(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- production_lot_confirmation_group_material_input(identified_stock_id) → identified_stock(id)
- sales_quote_item(sales_quote_uuid) → sales_quote(uuid)
- sales_quote_item(buyer_id) → business_partner(uuid)
- sales_quote_item(product_id) → material(uuid)
- sales_quote_item(vendor_id) → business_partner(uuid)
- equipment_description(equipment_uuid) → equipment(uuid)
- production_lot_confirmation_group_operation(confirmation_group_uuid) → production_lot_confirmation_group(production_lot_uuid)
- sales_order_item(sales_order_uuid) → sales_order(uuid)
- sales_order_item(buyer_id) → business_partner(uuid)
- sales_order_item(product_id) → material(uuid)
- sales_order_item(vendor_id) → business_partner(uuid)
- sales_order_item(service_performer_id) → business_partner(uuid)
- sales_order_item(id) → material(uuid)
- site_logistics_task(customer_id) → business_partner(uuid)
- customer_contract_item_entitled_product(entitlement_product_id) → entitlement_product(uuid)
- customer_contract_item_entitled_product(item_uuid) → customer_contract_item(uuid)
- customer_contract_item_entitled_product(product_category_hierarchy_id) → product_category_hierarchy(uuid)
- registered_product(material_id) → material(uuid)
- registered_product(account_id) → account(uuid)
- registered_product(contact_id) → contact(uuid)
- registered_product(parent_registered_reference_id) → material(uuid)
- registered_product(supplier_id) → supplier(uuid)
- opportunity_sales_order_successor(opportunity_uuid) → opportunity(uuid)
- opportunity_sales_order_successor(item_id) → sales_order(uuid)