SAP Business ByDesign

Explore the interactive ERD

Table & Field Reference

customer_contract_item

Column	Type	Keys
`uuid`	String	PK
`customer_contract_uuid`	String	PKFK
`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	PKFK
`uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`supplier_internal_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`partner_uuid`	String	PKFK
`opportunity_id`	String
`partner_id`	String

working_time_period_item

Column	Type	Keys
`uuid`	String	PK
`working_time_model_uuid`	String	PKFK
`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	PKFK
`reporting_point_uuid`	String

sales_order_item_product_tax_details

Column	Type	Keys
`uuid`	String	PK
`sales_order_item_id`	String	PKFK
`sales_order_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`description`	String
`description_id`	String

service_request_reference_object

Column	Type	Keys
`id`	String	PK
`service_request_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`contact_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`service_product_uuid`	String	PKFK
`service_product_id`	String

opportunity_sales_employee

Column	Type	Keys
`opportunity_uuid`	String	PK
`employee_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`opportunity_uuid`	String	PKFK
`competitor_id`	String
`opportunity_id`	String

production_lot_confirmation_group

Column	Type	Keys
`confirmation_group_uuid`	String	PK
`production_lot_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`language_code`	String
`value`	String

sales_quote_item_schedule_line

Column	Type	Keys
`id`	String	PK
`sales_quote_item_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`contact_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`language_code`	String
`value`	String

employee_assignment_history

Column	Type	Keys
`uuid`	String	PK
`employee_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`description`	String
`description_id`	String

service_product_deviant_tax_classification

Column	Type	Keys
`index`	Int	PK
`uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`life_cycle_status_code`	Int
`material_id`	String

material_description

Column	Type	Keys
`language_code`	String	PK
`uuid`	String	PKFK
`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	PKFK
`sales_order_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`description`	String
`description_id`	String

opportunity_lead_predecessor

Column	Type	Keys
`uuid`	String	PK
`opportunity_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`taxation_characteristics_code`	String
`ProductTax`
`TransactionProductTax`

sales_order_item_schedule_line

Column	Type	Keys
`id`	String	PK
`sales_order_item_id`	String	PKFK
`sales_order_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`description`	String
`description_id`	String

customer_contract_price_component

Column	Type	Keys
`uuid`	String	PK
`customer_contract_item_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`uuid`	String	PKFK
`id`	String
`product_id`	String
`supplier_lead_time_duration`	String

account_open_amount

Column	Type	Keys
`account_id`	String	PKFK
`company_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`superordinate_id`	String	PKFK

supplier_invoice_payment_installment

Column	Type	Keys
`payment_id`	String	PK
`supplier_invoice_uuid`	String	PKFK
`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	PKFK
`prospect_uuid`	String	PKFK
`contact_id`	String
`prospect_id`	String

material_valuation

Column	Type	Keys
`index`	Int	PK
`uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`business_partner_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`description`	String
`language_code`	String

production_lot_confirmation_group_operation

Column	Type	Keys
`uuid`	String	PK
`confirmation_group_uuid`	String	PKFK
`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	PKFK
`sales_order_uuid`	String	PKFK
`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	PKFK
`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	PKFK
`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`