reybex-Datenbank (Reports)

Leitfaden 4.3 – Tabellen- und Spaltenreferenz. SQL-Muster: 4.4 Beispiel-SQLs (BAS23).

→ Technische Integration · Partner-Leitfaden

Technische Referenz der 1139 Tabellen aus der reybex-Mandanten-Datenbank (MySQL-DDL). Wo eine Domain-Entität existiert, ist der Dokumentationspfad identisch zur Domain-Struktur.

860 Tabellen sind Domain-Entitäten zugeordnet; weitere Tabellen (Join-, Staging-, Legacy-) stehen unter Ohne Domain.

Module (Domain-Tabellen)

Modul	Tabellen
Basis / Stammdaten (BAS)	117
Business Process Management (BPM)	7
CRM (CRM)	65
Dropshipping (DPS)	3
EDI (EDI)	6
Einkauf (PUR)	24
Entwicklung (DEV)	11
Finanzen (FIN)	96
Kalender (CAL)	3
Kasse (CAS)	13
Lager / Inventur (INV)	27
Online Marktplätze (OMP)	42
Produktion (PRD)	29
Projektmanagement (PRM)	2
Qualität (QLT)	26
System (SYS)	210
Versand / Pick & Pack (SMP)	71
Vertrieb (SAL)	89
Webshop Connector (WCO)	1

SQL (Leitfaden)

Partner mit Berechtigung für BAS23 Reports and Export Jobs legen SQL-Exporte und Reports an. Kuratierte Muster: Beispiel-SQLs.

Alle Tabellen

Tabelle	Modul	Domain
account	FIN	Account
account_reporting_group	FIN	AccountReportingGroup
account_trans	FIN	AccountTranslation
action_email	CRM	ActionEmail
address_book	CRM	AddressBook
address_book_right	CRM	AddressBookRight
advertising_medium	—	—
agent_event_outbox	SYS	AgentEventOutbox
agent_event_subscription	SYS	AgentEventSubscription
amazon_asin_sku_mapping	SYS	AmazonAsinSkuMapping
amazon_asin_sku_mapping_csv	—	—
amazon_orders_with_missing_ustid	—	—
amazon_report_contents	SYS	AmazonReportContents
amazon_report_fba_inventory	OMP	AmazonReportFbaInventory
amazon_report_fba_order	—	—
amazon_report_test	—	—
amazon_sku_asin_template	—	—
amazon_synch_babyland	—	—
api_request	—	—
app_item	—	—
app_order	—	—
app_subscription	—	—
app_subscription_user	—	—
appointment	SYS	Appointment
appointment_category	SYS	AppointmentCategory
archived_document	SYS	ArchivedDocument
assembly_log	SAL	AssemblyLog
asset	FIN	Asset
asset_deprecation	FIN	AssetDeprecation
asset_deprecation_fin_item	—	—
asset_group	FIN	AssetGroup
asset_move	FIN	AssetMove
attachment	SYS	Attachment
attendee	SYS	Attendee
attribute	BAS	Attribute
attribute_group	BAS	AttributeGroup
attribute_group_attribute	—	—
attribute_import	BAS	AttributeImport
attribute_import_item	BAS	AttributeImportItem
attribute_marketplace_name	BAS	AttributeMarketplaceName
attribute_option	BAS	AttributeOption
attribute_option_marketplace_name	BAS	AttributeOptionMarketplaceName
attribute_option_trans	BAS	AttributeOptionTranslation
attribute_trans	BAS	AttributeTranslation
audit_log	—	—
auth_token	SYS	AuthToken
background_job	SYS	BackgroundJob
bank_account	FIN	BankAccount
bank_clearing_head	FIN	BankClearingHead
bank_clearing_item	FIN	BankClearingItem
bank_credential	FIN	BankCredential
bank_mt_txt	FIN	BankMtTxt
bank_op_search	FIN	BankOpSearch
bank_transaction	FIN	BankTransaction
bank_transaction_amazon_fee_map	—	—
bank_transaction_fin_item	—	—
bank_transaction_fin_open_item	—	—
bank_transaction_item	FIN	BankTransactionItem
bank_transaction_sales_head	—	—
batchnum_attribute_temp	—	—
bom_direct_demand	—	—
bom_head	PRD	BomHead
bom_item	PRD	BomItem
bpm_definition_head	BPM	BpmDefinitionHead
bpm_definition_item	BPM	BpmDefinitionItem
bpm_definition_item_route	BPM	BpmDefinitionItemRoute
bpm_head	BPM	BpmHead
bpm_item	BPM	BpmItem
bpm_item_route	BPM	BpmItemRoute
business_report	SYS	BusinessReport
calculation_head	FIN	CalculationHead
calculation_item	FIN	CalculationItem
cash_balance	SAL	CashBalance
cash_balance_item	SAL	CashBalanceItem
cash_close	SAL	CashClose
cash_register	CAS	CashRegister
cash_register_ltt_cash_move_reason	—	—
cash_register_ltt_payment_type	—	—
cash_register_trans	SAL	CashRegisterTranslation
cb_stock_check	—	—
cbv_accounting_report	—	—
check_list_head	SYS	CheckListHead
check_list_item	SYS	CheckListItem
cheque	FIN	Cheque
cheque_payroll	FIN	ChequePayroll
cheque_payroll_item	FIN	ChequePayrollItem
cms_cms_comment	—	—
cms_content_part	—	—
cms_doc_attachment	—	—
cms_doc_change	—	—
cms_doc_change_type	—	—
cms_document_base	—	—
cms_document_base_cms_cms_comment	—	—
cms_document_base_cms_doc_attachment	—	—
cms_document_base_user	—	—
cms_document_last_viewed	—	—
cms_documentation_cms_document_base	—	—
cms_layout	—	—
cms_share_document	—	—
cms_share_document_lt_social_provider	—	—
cms_tag	—	—
cms_tag_link	—	—
cms_tweet	—	—
code_examples	—	—
column_group	SYS	ColumnGroup
column_group_lt_task_status	—	—
column_group_lt_task_status_backup	—	—
column_settings	SYS	ColumnSettings
comm_as2_config	—	—
comm_customer_config	EDI	CommCustomerConfig
comm_head	EDI	CommHead
comm_head_email	EDI	CommHeadEmail
comm_item	EDI	CommItem
comm_message	EDI	CommMessage
comm_protocoll	EDI	CommProtocoll
company	SYS	Company
company_bank	SYS	CompanyBank
company_cross_tenant	SYS	CompanyCrossTenant
company_payment	SYS	CompanyPayment
company_payment_method	—	—
company_product	SYS	CompanyProduct
company_product_draft	—	—
company_product_option	SYS	CompanyProductOption
configuration	SYS	Configuration
contact_import_from_csv	—	—
contact_person	CRM	ContactPerson
contact_person_opportunities	—	—
contact_person_type	SYS	ContactPersonType
contact_person_type_trans	SYS	ContactPersonTypeTranslation
contact_type_account	CRM	ContactTypeAccount
contract_head	SAL	ContractHead
contract_head_attachment	—	—
contract_head_documents	SAL	ContractHeadDocuments
coordinate	SYS	Coordinate
cost_center	FIN	CostCenter
cost_center_distribution	FIN	CostCenterDistribution
create_return_template	SAL	CreateReturnTemplate
crm_action	CRM	CrmAction
crm_action_attachment	—	—
crm_campaign	CRM	Campaign
crm_campaign_action	CRM	CampaignAction
crm_campaign_participant	CRM	CampaignParticipant
crm_opportunity	CRM	CrmOpportunity
crm_opportunity_attachment	—	—
crm_opportunity_email	CRM	CrmOpportunityEmail
crm_opportunity_item	CRM	CrmOpportunityItem
crm_opportunity_pipeline	CRM	CrmOpportunityPipeline
crm_opportunity_status_history	CRM	CrmOpportunityStatusHistory
cross_tenant_property_copy_config	SYS	CrossTenantPropertyCopyConfig
cross_tenant_property_copy_filter	SYS	CrossTenantPropertyCopyFilter
cross_tenant_transfer	SYS	CrossTenantTransfer
csv_header	SYS	CsvHeader
csv_row	SYS	CsvRow
custom_query_template	BAS	CustomQueryTemplate
custom_table_button	SYS	CustomTableButton
custom_table_config	SYS	CustomTableConfig
custom_table_record	SYS	CustomTableRecord
custom_xml_template	BAS	CustomXmlTemplate
customer	SAL	Customer
customer_address	CRM	CustomerAddress
customer_attachment	—	—
customer_bank	CRM	CustomerBank
customer_branch	—	—
customer_crm_integration	SYS	CustomerCrmIntegration
customer_distribution_place	—	—
customer_distribution_place_customer	—	—
customer_distribution_place_customer_distribution_place_type	—	—
customer_distribution_place_type	—	—
customer_employee	SYS	CustomerEmployee
customer_ltt_branch	—	—
customer_ltt_material_category	—	—
customer_ltt_verification_doc_type	—	—
customer_sales_person	CRM	CustomerSalesPerson
customer_sales_person_default	CRM	CustomerSalesPersonDefault
customer_sales_report	CRM	CustomerSalesReport
customer_ust_check_history	CRM	CustomerUstCheckHistory
danger_carrier	SMP	DangerCarrier
dashboard	DEV	Dashboard
dashboard_widget	DEV	DashboardWidget
data_export_right	BAS	DataExportRight
data_export_script	BAS	DataExportScript
datev_client	FIN	DatevClient
datev_connect	—	—
datev_connect_item	—	—
datev_dxso_job	FIN	DatevDxsoJob
datev_dxso_job_item	FIN	DatevDxsoJobItem
datev_export_log	FIN	DatevExportLog
datev_export_log_item	FIN	DatevExportLogItem
datev_user	FIN	DatevUser
default_table_columns	SYS	DefaultTableColumns
delivery	SMP	Delivery
delivery_date_calculation	SAL	DeliveryDateCalculation
doc_closed_reason	SAL	DocClosedReason
doc_comments	SAL	DocComments
document_export_log	—	—
domain_access_log	SYS	DomainAccessLog
domain_access_right_config	SYS	DomainAccessRightConfig
domain_locker	SYS	DomainLocker
dropshipping_customer	—	—
dynamic_attachment	SYS	DynamicAttachment
dynamic_attachment_attachment	—	—
ebay_account_deletion_closure_notification	SYS	EbayAccountDeletionClosureNotification
ebay_spec_temporary	SYS	EbaySpecTemporary
einvoice_taxpayer	—	—
einvoice_taxpayer_pk	—	—
einvoice_taxpayer_tmp	—	—
email	SYS	Email
email_account	SYS	EmailAccount
email_attachment	SYS	EmailAttachment
email_template	SYS	EmailTemplate
email_template_files	—	—
email_template_trans	SYS	EmailTemplateTranslation
email_template_trans_files	—	—
email_template_trans_ufile	—	—
email_template_ufile	—	—
email_workflow	—	—
email_workflow_queue	BAS	EmailWorkflowQueue
emojis	—	—
employee	FIN	Employee
employee_attachment	FIN	EmployeeAttachment
employee_education	FIN	EmployeeEducation
employee_folder_employee_attachment	—	—
employee_request	FIN	EmployeeRequest
employee_request_history	FIN	EmployeeRequestHistory
employee_right	FIN	EmployeeRight
employee_time_history	FIN	EmployeeTimeHistory
error_marketplace_amazon_import	—	—
event_log	SYS	EventLog
exchange_rate	FIN	ExchangeRate
expense	SYS	Expense
export_data	—	—
farmsolutionPrices	—	—
fba_stock_util	—	—
feature_flag	SYS	FeatureFlag
feature_flag_tenant	SYS	FeatureFlagTenant
figo_account	FIN	FigoAccount
figo_account_figo_credential	—	—
figo_credential	FIN	FigoCredential
figo_user	FIN	FigoUser
files	SYS	UFile
filter_configuration	DEV	FilterConfiguration
filter_group	DEV	FilterGroup
filter_settings	SYS	FilterSettings
filter_settings_object	SYS	FilterSettingsObject
fin_api_user	—	—
fin_balance	FIN	FinBalance
fin_bank_booking	FIN	FinBankBooking
fin_cost_center_distribution	FIN	FinCostCenterDistribution
fin_head	FIN	FinHead
fin_head_attachment	—	—
fin_head_recurrence	FIN	FinHeadRecurrence
fin_item	FIN	FinItem
fin_item_open_item	FIN	FinItemOpenItem
fin_matching	FIN	FinMatching
fin_open_item	FIN	FinOpenItem
fin_open_item_history	FIN	FinOpenItemHistory
fin_page	FIN	FinPage
fin_payment_head	FIN	FinPaymentHead
fin_payment_item	FIN	FinPaymentItem
fin_period	FIN	Period
fin_period_config	FIN	PeriodConfig
fin_post_stock	FIN	FinPostStock
fin_post_stock_item	FIN	FinPostStockItem
fin_post_stock_item_ltt_mat_group	—	—
fin_post_stock_item_ltt_material_type	—	—
fin_post_stock_item_ltt_vat_key	—	—
fin_post_stock_item_ltt_warehouse	—	—
fin_post_stock_item_material	—	—
fin_rep_item	FIN	FinRepItem
fiskaly_amount_per_discount_type	CAS	FiskalyAmountPerDiscountType
fiskaly_amount_per_payment_type	CAS	FiskalyAmountPerPaymentType
fiskaly_amount_per_vat_rate	CAS	FiskalyAmountPerVatRate
fiskaly_api_key	CAS	FiskalyApiKey
fiskaly_austria_cash_register	CAS	FiskalyAustriaCashRegister
fiskaly_cash_close	CAS	FiskalyCashClose
fiskaly_configuration	CAS	FiskalyConfiguration
fiskaly_line	—	—
fiskaly_order_line	CAS	FiskalyOrderLine
fiskaly_organization	CAS	FiskalyOrganization
fiskaly_transaction	CAS	FiskalyTransaction
fiskaly_tss	CAS	FiskalyTss
fiskaly_tss_client	CAS	FiskalyTssClient
folder	—	—
fulfillment_import_request	—	—
fulfillment_imported_stocks	—	—
fulfillment_info	SMP	FulfillmentInfo
fulfillment_warehouse	SMP	FulfillmentWarehouse
gantt_links	SYS	GanttLinks
gdpdu	FIN	Gdpdu
gdpdu_item	FIN	GdpduItem
guest_project	SYS	GuestProject
help_entry	SYS	HelpEntry
hidden_form_control	SYS	HiddenFormControl
import_account	—	—
import_account_report_group	—	—
import_account_skr_07_at	—	—
import_account_skr_ch	—	—
import_account_skr_free	—	—
import_account_skr04	—	—
import_account_skr07	—	—
import_attributes	—	—
import_brands	—	—
import_log	BAS	ImportLog
import_log_item	BAS	ImportLogItem
import_matching_head	BAS	ImportMatchingHead
import_matching_item	BAS	ImportMatchingItem
import_skr_mapping	—	—
incoming_goods_relation	INV	IncomingGoodsRelation
invoice	—	—
invoice_item	—	—
invoice_recurrence	—	—
item	—	—
java_script_error	SYS	JavaScriptError
job	SYS	Job
job_history	SYS	JobHistory
job_server	SYS	JobServer
kanban_column	SYS	KanbanColumn
kanban_column_lt_task_status	—	—
localization	SYS	Localization
lt_action_priority	CRM	ActionPriority
lt_action_priority_trans	CRM	ActionPriorityTranslation
lt_action_status	CRM	ActionStatus
lt_action_status_trans	CRM	ActionStatusTranslation
lt_activity_type	—	—
lt_advance_turnover_tax_return_structure	FIN	AdvanceTurnoverTaxReturnStructure
lt_amazon_fee_type	—	—
lt_amazon_fulfillment_center	OMP	AmazonFulfillmentCenter
lt_asset_move_type	FIN	AssetMoveType
lt_attachment_type	SYS	AttachmentType
lt_attribute_type	BAS	AttributeType
lt_bpm_process_type	BPM	BpmProcessType
lt_calendar	CAL	Calendar
lt_campaign_status	—	—
lt_campaign_type	CRM	CampaignType
lt_category	SYS	Category
lt_category_marktplace_mapping	—	—
lt_category_marktplace_mapping_lt_marketplace_category	—	—
lt_category_marktplace_mapping_ltt_shop_category	—	—
lt_change_type	SYS	ChangeType
lt_cheque_process_type	FIN	ChequeProcessType
lt_cheque_process_type_trans	FIN	ChequeProcessTypeTranslation
lt_cheque_status	FIN	ChequeStatus
lt_cheque_status_trans	FIN	ChequeStatusTranslation
lt_contact_type	CRM	ContactType
lt_contact_type_trans	CRM	ContactTypeTranslation
lt_country	SYS	Country
lt_country_subdivision	SYS	CountrySubdivision
lt_country_subdivision_ltt_calendar_holiday	—	—
lt_country_subdivision_trans	SYS	CountrySubdivisionTranslation
lt_country_trans	SYS	CountryTranslation
lt_crm_integration_provider	SYS	CrmIntegrationProvider
lt_danger	—	—
lt_data_export_type	BAS	DataExportType
lt_data_export_type_trans	BAS	DataExportTypeTranslation
lt_default_hidden_fields	SYS	DefaultHiddenFields
lt_email_filter	BAS	EmailFilter
lt_email_provider	SYS	EmailProvider
lt_email_receiver_option	BAS	EmailReceiverOption
lt_email_receiver_option_trans	BAS	EmailReceiverOptionTranslation
lt_eu_excepted_area	SMP	EuExceptedArea
lt_expense_subsistence_country	SYS	ExpenseSubsistenceCountry
lt_expense_type	—	—
lt_expense_unit	SYS	ExpenseUnit
lt_import_matching_lookup	BAS	ImportMatchingLookup
lt_intrastat_mode_of_transport	BAS	IntrastatModeOfTransport
lt_label	—	—
lt_marketplace_brand	OMP	MarketplaceBrand
lt_marketplace_category	OMP	MarketplaceCategory
lt_marketplace_export_fields	SYS	MarketplaceExportFields
lt_marketplace_export_fields_trans	—	—
lt_marketplace_shipping	SMP	MarketplaceShipping
lt_marktplace_transfer_status	OMP	MarktplaceTransferStatus
lt_marktplace_transfer_status_trans	OMP	MarktplaceTransferStatusTranslation
lt_marktplace_variant_attribute	OMP	MarktplaceVariantAttribute
lt_marktplace_variant_attribute_lt_marketplace_category	—	—
lt_marktplace_visibility	OMP	MarktplaceVisibility
lt_material_field	BAS	MaterialField
lt_material_field_trans	BAS	MaterialFieldTranslation
lt_material_import_fields	—	—
lt_notification_type	SYS	NotificationType
lt_order_status	SAL	OrderStatus
lt_order_status_trans	SAL	OrderStatusTranslation
lt_packlist_type	SMP	PacklistType
lt_payment_status	SAL	PaymentStatus
lt_payment_status_trans	SAL	PaymentStatusTranslation
lt_pick_list_head_status	SMP	PickListHeadStatus
lt_pick_list_head_status_trans	SMP	PickListHeadStatusTranslation
lt_prod_service_tags	—	—
lt_prod_services	—	—
lt_production_status	PRD	ProductionStatus
lt_production_status_trans	PRD	ProductionStatusTranslation
lt_project_status	SYS	ProjectStatus
lt_project_type	—	—
lt_provider	SMP	CarrierProvider
lt_province	SYS	Province
lt_pur_head_delivery_status	PUR	PurHeadDeliveryStatus
lt_pur_head_delivery_status_trans	PUR	PurHeadDeliveryStatusTranslation
lt_rating_type	CRM	RatingType
lt_recur	SYS	RecurType
lt_reference_number_field	SMP	ReferenceNumberField
lt_reference_number_field_trans	SMP	ReferenceNumberFieldTranslation
lt_sales_head_status	SAL	SalesHeadStatus
lt_sales_head_status_trans	SAL	SalesHeadStatusTranslation
lt_sales_item_delivery_status	SAL	SalesItemDeliveryStatus
lt_sales_item_delivery_status_trans	SAL	SalesItemDeliveryStatusTranslation
lt_salutation_type	SYS	SalutationType
lt_service_tag_list	—	—
lt_shipping_carrier_error_mapping	SMP	CarrierErrorMapping
lt_shipping_label	SMP	Label
lt_shipping_prod_service_tags	SMP	ProdServiceTags
lt_shipping_prod_services	SMP	ProdServices
lt_shipping_service_tag_list	SMP	ServiceTagList
lt_social_provider	—	—
lt_supported_fulfillment	SMP	SupportedFulfillment
lt_supported_integrator	BAS	SupportedIntegrator
lt_supported_marktplace	OMP	SupportedMarktplace
lt_supported_marktplace_material_condition	OMP	SupportedMarktplaceMaterialCondition
lt_supported_marktplace_material_condition_trans	OMP	SupportedMarktplaceMaterialConditionTranslation
lt_supported_payment_type	OMP	SupportedPaymentType
lt_supported_payment_type_marktplace_mapping	OMP	SupportedPaymentTypeMarktplaceMapping
lt_supported_payment_type_trans	OMP	SupportedPaymentTypeTranslation
lt_supported_shipping_carrier	SMP	SupportedCarrier
lt_supported_shipping_product	SMP	SupportedShippingProduct
lt_supported_shipping_product_marktplace_mapping	SMP	SupportedShippingProductMarktplaceMapping
lt_supported_shipping_service	SMP	SupportedShippingService
lt_supported_storage	SYS	SupportedStorage
lt_task_priority	SYS	TaskPriority
lt_task_status	SYS	TaskStatus
lt_task_status_trans	SYS	TaskStatusTranslation
lt_tax_office	FIN	TaxOffice
lt_test_status	—	—
lt_vat_threshold	—	—
lt_verification_status	QLT	VerificationStatus
lt_verification_status_trans	QLT	VerificationStatusTranslation
lt_voucher_status	SYS	VoucherStatus
lt_widget_type	SYS	WidgetType
lt_widget_type_filter	SYS	WidgetTypeFilter
lt_widget_type_trans	SYS	WidgetTypeTranslation
lt_xslt_templates	—	—
lt_zip_code_pattern	SMP	ZipCodePattern
ltt_account_group	FIN	AccountGroup
ltt_account_group_trans	FIN	AccountGroupTranslation
ltt_account_mapping	FIN	AccountMapping
ltt_account_mapping_customer	—	—
ltt_account_mapping_material	—	—
ltt_account_type	FIN	AccountType
ltt_account_type_trans	FIN	AccountTypeTranslation
ltt_action_kind	CRM	ActionKind
ltt_action_kind_trans	CRM	ActionKindTranslation
ltt_action_reason	CRM	ActionReason
ltt_action_reason_trans	CRM	ActionReasonTranslation
ltt_action_type	CRM	ActionType
ltt_action_type_trans	CRM	ActionTypeTranslation
ltt_activity_type	SYS	ActivityType
ltt_authority_map	SYS	AuthorityMap
ltt_barcode_configuration	BAS	BarcodeConfiguration
ltt_barcode_configuration_ltt_shipping_carrier	—	—
ltt_bonus_agreement_head	SAL	BonusAgreementHead
ltt_bonus_agreement_item	SAL	BonusAgreementItem
ltt_branch	SYS	Branch
ltt_branch_trans	BAS	BranchTranslation
ltt_brand	BAS	Brand
ltt_calcualtion_scheme	—	—
ltt_calculation_scheme	FIN	CalculationScheme
ltt_calculation_scheme_position	FIN	CalculationSchemePosition
ltt_calendar_holiday	CAL	CalendarHoliday
ltt_calendar_work_day	CAL	CalendarWorkDay
ltt_cash_move_reason	SAL	CashMoveReason
ltt_category_marktplace_mapping	OMP	CategoryMarktplaceMapping
ltt_category_marktplace_mapping_ltt_marketplace_category	—	—
ltt_category_marktplace_mapping_ltt_shop_category	—	—
ltt_collective_invoice	SAL	CollectiveInvoice
ltt_collective_invoice_trans	SAL	CollectiveInvoiceTranslation
ltt_company_department	CRM	CompanyDepartment
ltt_company_department_trans	CRM	CompanyDepartmentTranslation
ltt_company_position	CRM	CompanyPosition
ltt_company_position_trans	CRM	CompanyPositionTranslation
ltt_company_source	CRM	CompanySource
ltt_company_source_trans	CRM	CompanySourceTranslation
ltt_confirmation_check_group	QLT	ConfirmationCheckGroup
ltt_confirmation_decline_title	—	—
ltt_contact_import	CRM	ContactImport
ltt_contact_import_contact_person_doublet	CRM	ContactImportContactPersonDoublet
ltt_contact_import_customer_employee_doublet	CRM	ContactImportCustomerEmployeeDoublet
ltt_contact_import_doublet_customer	CRM	ContactImportCustomerDoublet
ltt_contact_import_item	CRM	ContactImportItem
ltt_corridor	SAL	Corridor
ltt_corridor_side	SAL	CorridorSide
ltt_country_trans	—	—
ltt_crm_campaign_partic_status	CRM	CampaignParticipantStatus
ltt_crm_campaign_partic_status_trans	CRM	CampaignParticipantStatusTranslation
ltt_crm_integration	SYS	CrmIntegration
ltt_crm_integration_customer_transfer	SYS	CrmIntegrationCustomerTransfer
ltt_currency	SYS	Currency
ltt_currency_trans	SYS	CurrencyTranslation
ltt_customer_branches	SAL	CustomerBranch
ltt_customer_branches_trans	SAL	CustomerBranchTranslation
ltt_customer_competitor	CRM	CustomerCompetitor
ltt_customer_group	SAL	CustomerGroup
ltt_customer_group_trans	SAL	CustomerGroupTranslation
ltt_customer_type	CRM	CustomerType
ltt_customer_type_trans	CRM	CustomerTypeTranslation
ltt_danger	SMP	Danger
ltt_dangerous_code	BAS	DangerousCode
ltt_dangerous_code_trans	BAS	DangerousCodeTranslation
ltt_data_export	BAS	DataExport
ltt_data_export_history	—	—
ltt_data_export_item	BAS	DataExportItem
ltt_delivery_time	SAL	DeliveryTime
ltt_department	FIN	Department
ltt_discount_type	SAL	DiscountType
ltt_discount_type_trans	SAL	DiscountTypeTranslation
ltt_disposal_category	BAS	DisposalCategory
ltt_disposal_category_fee	BAS	DisposalCategoryFee
ltt_doc_decline_reasons	SAL	DocDeclineReasons
ltt_doc_type	—	—
ltt_doc_type_trans	—	—
ltt_domain_access_map	SYS	DomainAccessMap
ltt_dropshipping_customer	DPS	DropshippingCustomer
ltt_dropshipping_vendor	DPS	DropshippingVendor
ltt_dunning_level	SYS	DunningLevel
ltt_dunning_level_trans	SYS	DunningLevelTranslation
ltt_ebay_seller_profile	OMP	EbaySellerProfile
ltt_einvoice_prefix	BAS	EInvoicePrefix
ltt_email_filter_detail	BAS	EmailFilterDetail
ltt_email_filter_head	BAS	EmailFilterHead
ltt_email_template_rule_sales	SYS	EmailTemplateRuleSales
ltt_employee_amount	CRM	EmployeeAmount
ltt_employee_health_organization	FIN	EmployeeHealthOrganization
ltt_employee_interest	CRM	EmployeeInterest
ltt_employee_interest_trans	CRM	EmployeeInterestTranslation
ltt_employee_right_type	FIN	EmployeeRightType
ltt_employee_right_type_trans	FIN	EmployeeRightTypeTranslation
ltt_etf_provider	SAL	EtfProvider
ltt_etf_terminal	SAL	EtfTerminal
ltt_expense_resource_type	SYS	ExpenseResourceType
ltt_expense_type	SYS	ExpenseType
ltt_favorite_material	BAS	FavoriteMaterial
ltt_favorite_material_group	BAS	FavoriteMaterialGroup
ltt_fin_doc_type	FIN	FinDocType
ltt_fin_doc_type_trans	FIN	FinDocTypeTranslation
ltt_freight	SMP	Freight
ltt_freight_calc_config	SMP	FreightCalculationConfig
ltt_freight_distance_api_configuration	SMP	FreightDistanceApiConfiguration
ltt_freight_trans	SMP	FreightTranslation
ltt_fterms	SMP	Fterms
ltt_fulfillment	SMP	Fulfillment
ltt_fulfillment_order_status	SMP	FulfillmentOrderStatus
ltt_gittigidiyor_category	—	—
ltt_gittigidiyor_config	—	—
ltt_home_edition	BAS	HomeEdition
ltt_iln	SMP	Iln
ltt_incoming_goods_log	INV	IncomingGoodsLog
ltt_integrator	BAS	Integrator
ltt_integrator_config	BAS	IntegratorConfig
ltt_intrastat_profiles	BAS	IntrastatProfiles
ltt_inv_doc_type	INV	InvDocType
ltt_inv_doc_type_trans	INV	InvDocTypeTranslation
ltt_item_assignment	BAS	ItemAssignment
ltt_kanban_column_type	SYS	KanbanColumnType
ltt_language	BAS	Language
ltt_language_trans	BAS	LanguageTranslation
ltt_lead_status	CRM	LeadStatus
ltt_lead_status_trans	CRM	LeadStatusTranslation
ltt_level	BAS	Level
ltt_line	INV	Line
ltt_location	INV	Location
ltt_marketplace_config	OMP	MarketplaceConfig
ltt_marketplace_order_import_error	OMP	MarktplaceOrderImportError
ltt_marktplace	OMP	Marktplace
ltt_marktplace_article_import	OMP	MarktplaceArticleImport
ltt_marktplace_import_warehouse	—	—
ltt_marktplace_ltt_payment_type	—	—
ltt_marktplace_ltt_shipping	—	—
ltt_marktplace_ltt_warehouse	OMP	MarktplaceWarehouse
ltt_marktplace_material_transfer	OMP	MarktplaceMaterialTransfer
ltt_marktplace_material_transfer_temporary	—	—
ltt_marktplace_order_transfer	OMP	MarktplaceOrderTransfer
ltt_marktplace_pre_order_warehouse	—	—
ltt_marktplace_trans	OMP	MarktplaceTranslation
ltt_marktplace_transfer_error	OMP	MarktplaceTransferError
ltt_marktplace_unpaid_imported_payment_type	—	—
ltt_mat_energy_eff	—	—
ltt_mat_group	BAS	MatGroup
ltt_mat_group_trans	BAS	MatGroupTranslation
ltt_mat_status	BAS	MatStatus
ltt_mat_status_trans	BAS	MatStatusTranslation
ltt_material_category	BAS	MaterialCategory
ltt_material_energy_efficiency	BAS	MaterialEnergyEfficiency
ltt_material_energy_efficiency_picture	BAS	MaterialEnergyEfficiencyPicture
ltt_material_label	BAS	MaterialLabel
ltt_material_label_reports	BAS	MaterialLabelReport
ltt_material_type	BAS	MaterialType
ltt_material_type_trans	BAS	MaterialTypeTranslation
ltt_menu	SYS	Menu
ltt_menu_item_trans	SYS	MenuItemTranslation
ltt_menu_role	SYS	MenuRole
ltt_menu_user	SYS	MenuUser
ltt_menue	—	—
ltt_mrp_lot_size	PRD	MrpLotSize
ltt_mrp_lot_size_trans	PRD	MrpLotSizeTranslation
ltt_mrp_method	PRD	MrpMethod
ltt_mrp_method_trans	PRD	MrpMethodTranslation
ltt_office	FIN	Office
ltt_opportunity_status	CRM	OpportunityStatus
ltt_opportunity_status_trans	CRM	OpportunityStatusTranslation
ltt_packaging	SMP	Packaging
ltt_packaging_trans	SMP	PackagingTranslation
ltt_paymcond	SYS	Paymcond
ltt_paymcond_op_split	SYS	PaymcondOpSplit
ltt_paymcond_trans	SYS	PaymcondTranslation
ltt_payment_type	SYS	PaymentType
ltt_payment_type_trans	SYS	PaymentTypeTranslation
ltt_pick_location	SMP	PickLocation
ltt_picking_zone	SYS	PickingZone
ltt_plant	BAS	Plant
ltt_plant_trans	BAS	PlantTranslation
ltt_price_list	—	—
ltt_price_list_trans	—	—
ltt_print_version	BAS	PrintVersion
ltt_prod_doc_type	PRD	ProdDocType
ltt_prod_doc_type_trans	PRD	ProdDocTypeTranslation
ltt_product_type	CRM	ProductType
ltt_production_person	PRD	ProductionPerson
ltt_production_shift	PRD	ProductionShift
ltt_profit_center	FIN	ProfitCenter
ltt_profit_center_picture	FIN	ProfitCenterPicture
ltt_profit_center_product	SMP	ProfitCenterProduct
ltt_profit_center_trans	FIN	ProfitCenterTranslation
ltt_project_type	SYS	ProjectType
ltt_project_type_trans	SYS	ProjectTypeTranslation
ltt_property_access_map	SYS	PropertyAccessMap
ltt_pur_department	PUR	PurDepartment
ltt_pur_doc_type	PUR	PurDocType
ltt_pur_doc_type_trans	PUR	PurDocTypeTranslation
ltt_pur_head_doc_rule	PUR	PurHeadDocRule
ltt_pur_order_status	PUR	PurOrderStatus
ltt_pur_order_status_trans	PUR	PurOrderStatusTranslation
ltt_pur_overdraft_status	PUR	PurOverdraftStatus
ltt_pur_text_customer_relation	CRM	CustomerPurText
ltt_quality_error_reasons	QLT	QualityErrorReasons
ltt_quality_plan_area	QLT	QualityPlanArea
ltt_quality_plan_check_type	QLT	QualityPlanCheckType
ltt_quality_plan_item_type	QLT	QualityPlanItemType
ltt_quality_plan_operation_type	—	—
ltt_quality_plan_type_id	—	—
ltt_raw_material	BAS	RawMaterial
ltt_raw_material_trans	BAS	RawMaterialTranslation
ltt_report	SYS	Report
ltt_report_trans	SYS	ReportTranslation
ltt_report_type	SYS	ReportType
ltt_return_doc_type	SAL	ReturnDocType
ltt_return_reason	SAL	ReturnReason
ltt_return_reason_trans	SAL	ReturnReasonTranslation
ltt_return_result	SAL	ReturnResult
ltt_return_result_trans	SAL	ReturnResultTranslation
ltt_return_status	SAL	ReturnStatus
ltt_return_status_trans	SAL	ReturnStatusTranslation
ltt_role_authority_map	SYS	RoleAuthorityMap
ltt_role_property_access_map	SYS	RolePropertyAccessMap
ltt_sales_bundle_head	SAL	SalesBundleHead
ltt_sales_bundle_item	SAL	SalesBundleItem
ltt_sales_department	SAL	SalesDepartment
ltt_sales_doc_rule	—	—
ltt_sales_doc_type	SAL	SalesDocType
ltt_sales_doc_type_contact_persons	—	—
ltt_sales_doc_type_trans	SAL	SalesDocTypeTranslation
ltt_sales_head_doc_rule	SAL	SalesHeadDocRule
ltt_sales_head_intrastat_detail	SAL	SalesHeadIntrastatInfo
ltt_sales_person_relation	SAL	SalesPersonRelation
ltt_sales_positions_type	SAL	SalesPositionsType
ltt_sales_text_customer_relation	CRM	CustomerSalesText
ltt_script_block	BAS	ScriptBlock
ltt_send_pack_status	—	—
ltt_send_pack_status_trans	SMP	SendPackStatusTranslation
ltt_service_type	BAS	ServiceType
ltt_shelf	INV	Shelf
ltt_shipping	SMP	Shipping
ltt_shipping_carrier	SMP	Carrier
ltt_shipping_carrier_ltt_packaging	—	—
ltt_shipping_config	SMP	ShippingConfig
ltt_shipping_label_user_print	SMP	LabelUserPrint
ltt_shipping_product	SMP	ShippingProduct
ltt_shipping_product_2_carrier	SMP	Product2Carrier
ltt_shipping_product2carrier	—	—
ltt_shipping_receiver_id	SMP	ShippingReceiverId
ltt_shipping_rules	SMP	DocumentRules
ltt_shipping_rules_ltt_sales_doc_type	—	—
ltt_shipping_rules_ltt_tags	—	—
ltt_shipping_service	SMP	ShippingService
ltt_shipping_trans	SMP	ShippingTranslation
ltt_shipping_type	—	—
ltt_shipping_type_trans	—	—
ltt_shop_category	OMP	ShopCategory
ltt_sortation	SMP	Sortation
ltt_source	—	—
ltt_source_trans	—	—
ltt_stat_mat_num_custom_rate	BAS	StatMatNumCustomRate
ltt_stock_move_typ	INV	StockMoveType
ltt_stock_move_type_trans	INV	StockMoveTypeTranslation
ltt_stock_place_trans	INV	StockPlaceTranslation
ltt_stockplace	INV	StockPlace
ltt_stockplace_lagerkarte	—	—
ltt_storage	SYS	Storage
ltt_system_property_access_rights	SYS	SystemPropertyAccessRights
ltt_tags	SYS	Tags
ltt_target_group_product	—	—
ltt_task_type	SYS	TaskType
ltt_task_type_trans	SYS	TaskTypeTranslation
ltt_tax_exemption_default_reason_code	BAS	TaxExemptionDefaultReasonCode
ltt_tax_type	SYS	TaxType
ltt_tenant	—	—
ltt_tenant_bank	FIN	TenantBank
ltt_tenant_trans	—	—
ltt_text_block	BAS	TextBlock
ltt_text_block_ltt_report	—	—
ltt_text_block_trans	BAS	TextBlockTranslation
ltt_title	CRM	Title
ltt_title_trans	CRM	TitleTranslation
ltt_transfer_reason	WCO	TransferReason
ltt_transit_warehouse_definition	INV	TransitWarehouseDefinition
ltt_type_of_business	BAS	TypeOfBusiness
ltt_unit	BAS	Unit
ltt_unit_trans	BAS	UnitTranslation
ltt_user_authority_map	SYS	UserAuthorityMap
ltt_user_property_access_map	SYS	UserPropertyAccessMap
ltt_user_to_be_informed	CRM	CrmActionUserToBeInformed
ltt_vat_key	FIN	VatKey
ltt_vat_key_rule	FIN	VatKeyRule
ltt_vat_key_trans	FIN	VatKeyTranslation
ltt_verification_check_group	QLT	VerificationCheckGroup
ltt_verification_doc_type	QLT	VerificationDocType
ltt_verification_doc_type_trans	QLT	VerificationDocTypeTranslation
ltt_verification_head_doc_rule	QLT	VerificationHeadDocRule
ltt_warehouse	INV	Warehouse
ltt_warehouse_trans	INV	WarehouseTranslation
ltt_web_service_connection	SMP	WebServiceConnection
ltt_weight_codes	SMP	WeightCodes
ltt_widget_type_right	SYS	WidgetTypeRoleList
ltt_widget_type_role_list	—	—
machine	PRD	Machine
marketplace_check_stock	—	—
marketplace_external	OMP	MarketplaceExternal
marketplace_import_material	OMP	MarketplaceImportMaterial
marketplace_job_request	OMP	MarketplaceJobRequest
marketplace_log_head	OMP	MarketplaceLogHead
marketplace_log_item	OMP	MarketplaceLogItem
marketplace_order_status	OMP	MarketplaceOrderStatus
marketplace_payment_status	OMP	MarketplacePaymentStatus
marketplace_price_import	—	—
marketplace_valid_carrier	OMP	MarketplaceValidCarrier
marktplace_category_custom_spec	—	—
marktplace_category_custom_spec_item	OMP	MarktplaceCategoryCustomSpecItem
marktplace_category_spec_head	OMP	MarktplaceCategorySpecHead
marktplace_category_spec_item	OMP	MarktplaceCategorySpecItem
marktplace_category_spec_item_map	OMP	MarktplaceCategorySpecItemMap
marktplace_category_spec_value	OMP	MarktplaceCategorySpecValue
marktplace_material_import_log	OMP	MarktplaceMaterialImportLog
marktplace_token_request	SYS	MarktplaceTokenRequest
marktplace_variant_mapping	OMP	MarktplaceVariantMapping
mass_print_import	SMP	MassPrintImport
material	BAS	Material
material_19482_04022026	—	—
material_attachment	—	—
material_attribute	BAS	MaterialAttribute
material_attribute_active_option	BAS	MaterialAttributeActiveOption
material_attribute_csv	—	—
material_attribute_value	BAS	MaterialAttributeValue
material_attribute_value_trans	BAS	MaterialAttributeValueTranslation
material_average_price_history	BAS	MaterialAveragePriceHistory
material_bom	BAS	MaterialBom
material_bom_detail	BAS	MaterialBomDetail
material_campaign	BAS	MaterialCampaign
material_clone	BAS	MaterialClone
material_clone_marketplace	BAS	MaterialCloneMarketplace
material_clone_variant	BAS	MaterialCloneVariant
material_collectible	BAS	MaterialCollectible
material_coupon	BAS	MaterialCoupon
material_coupon_group	BAS	MaterialCouponGroup
material_coupon_group_email	BAS	MaterialCouponGroupEmail
material_deprecation	—	—
material_discount	BAS	MaterialDiscount
material_disposal_category	BAS	MaterialDisposalCategory
material_export	BAS	MaterialExport
material_export_item	BAS	MaterialExportItem
material_export_ltt_brand	—	—
material_export_ltt_mat_group	—	—
material_export_ltt_warehouse	—	—
material_group_discount	BAS	MaterialGroupDiscount
material_group_discount_item	BAS	MaterialGroupDiscountItem
material_import	BAS	MaterialImport
material_import_from_csv	—	—
material_import_item	BAS	MaterialImportItem
material_import_log	—	—
material_import_log_item	—	—
material_ltt_material_category	—	—
material_ltt_tags	—	—
material_marktplace	OMP	MaterialMarktplace
material_marktplace_lt_marketplace_category	—	—
material_marktplace_ltt_shop_category	—	—
material_material_campaign	—	—
material_material_collectible	—	—
material_pictures	BAS	MaterialPictures
material_pictures_attribute_option	—	—
material_pictures_ltt_marktplace	—	—
material_prices	BAS	MaterialPrices
material_prices_attribute	BAS	MaterialPricesAttribute
material_prices_variant	BAS	MaterialPricesVariant
material_raw_material	BAS	MaterialRawMaterial
material_reorder_level	BAS	MaterialReorderLevel
material_sales_mapping	CRM	MaterialSalesMapping
material_sales_mapping_customer	—	—
material_search	BAS	MaterialSearch
material_stock	BAS	MaterialStock
material_stock_import_template	—	—
material_stock_statistics	INV	MaterialStockStatistics
material_stock_statistics_import	—	—
material_stock_statistics_import_temp	—	—
material_sync_rule	DPS	MaterialSyncRule
material_trans	BAS	MaterialTranslation
material_units	BAS	MaterialUnits
material_variant	BAS	MaterialVariant
material_variant_config	BAS	MaterialVariantConfig
material_variant_marketplace_config	BAS	MaterialVariantMarketplaceConfig
material_variant_picture	BAS	MaterialVariantPicture
material_variant_search	—	—
mediamarkt_variant	—	—
metrics	—	—
mollie	SYS	Mollie
mrp_material_plan_entry	PRD	MrpMaterialPlanEntry
note	SYS	Note
notification	SYS	Notification
notification_read	SYS	NotificationRead
number_range_reservation	SYS	NumberRangeReservation
number_ranges	SYS	NumberRanges
number_ranges_trans	SYS	NumberRangesTranslation
oauth2_server	SYS	Oauth2Server
observed_customer	SYS	ObservedCustomer
observed_project	SYS	ObservedProject
observed_support_line	SYS	ObservedSupportLine
observed_task	SYS	ObservedTask
open_id	—	—
opportunity_user	CRM	OpportunityUser
packlist_head	SMP	PacklistHead
packlist_item	SMP	PacklistItem
partner_scope_calculation	SYS	PartnerScopeCalculation
payment	—	—
payment_history	—	—
payment_item	—	—
persistent_logins	SYS	PersistentLogin
person	—	—
pick	SMP	Pick
pick_box	SMP	PickBox
pick_box_item	SMP	PickBoxItem
pick_box_label_content	—	—
pick_list_head	SMP	PickListHead
pick_list_item	SMP	PickListItem
pick_list_profile	SMP	PickListProfile
picking_item_reservation	SMP	PickingItemReservation
picking_profile	SMP	PickingProfile
pivot_mode_settings	SYS	PivotModeSettings
plugin_access	DEV	PluginAccess
plugin_access_grant	—	—
plugin_config	DEV	PluginConfig
plugin_pricing	—	—
pms_job	—	—
pms_license	SYS	PmsLicense
pms_trigger	—	—
portal_customer	SYS	PortalCustomer
print_log	SYS	PrintLog
process_status	SYS	ProcessStatus
prod_component	—	—
prod_operation	—	—
prod_operation_confirmation	—	—
prod_order	PRD	ProdOrder
prod_order_component	PRD	ProdOrderComponent
prod_order_confirmation	PRD	ProdOrderConfirmation
prod_order_operation	PRD	ProdOrderOperation
prod_order_relation	PRD	ProdOrderRelation
product	SYS	Product
product_option	SYS	ProductOption
product_prop	SYS	ProductProp
production_capacity_reserve	PRD	ProductionCapacityReserve
production_department	PRD	ProductionDepartment
production_department_capacity	PRD	ProductionDepartmentCapacity
production_department_user	PRD	ProductionDepartmentUser
production_operation	PRD	ProductionOperation
production_status	—	—
project	PRM	Project
project_expense	SYS	ProjectExpense
project_sales_item_mapping	—	—
project_user	—	—
proposal	PRD	Proposal
proposal_demand	PRD	ProposalDemand
pur_delivery_share	INV	PurDeliveryShare
pur_delivery_share_invoice	—	—
pur_head	PUR	PurHead
pur_head_19559	—	—
pur_head_attachment	—	—
pur_head_comm_message	PUR	PurHeadCommMessage
pur_head_comment	—	—
pur_head_discount	PUR	PurHeadDiscount
pur_head_email	PUR	PurHeadEmail
pur_head_text	PUR	PurHeadText
pur_item	PUR	PurItem
pur_item_delivery_date	PUR	PurItemDeliveryDate
pur_item_discount	PUR	PurItemDiscount
pur_price	PUR	PurPrice
pur_price_attribute	PUR	PurPriceAttribute
pur_price_discount	PUR	PurPriceDiscount
pur_price_double_delete	—	—
pur_price_scaled	PUR	PurPriceScaled
pur_price_variant	PUR	PurPriceVariant
pur_reminders	PUR	PurReminder
pur_sales_price	PUR	PurSalesPrice
quality_head	QLT	QualityHead
quality_item	QLT	QualityItem
quality_item_attachments	QLT	QualityItemAttachments
quality_plan	QLT	QualityPlan
quality_plan_item	QLT	QualityPlanItem
quality_plan_item_attachments	QLT	QualityPlanItemAttachments
quality_plan_operation_item_attachments	—	—
rakuten_category_temp	—	—
rbx_new_contracts	—	—
rest_log	SYS	RestLog
rest_log_archive	—	—
return_head	SAL	ReturnHead
return_head_attachment	—	—
return_item	SAL	ReturnItem
return_item_exchange	SAL	ReturnItemExchange
return_item_serial_number	SAL	ReturnItemSerialNumber
return_packs	SAL	ReturnPacks
reybex_domains	—	—
reybex_menu_item	SYS	MenuItem
reybex_stock_check	—	—
reybex_table_size_daily	—	—
reybex_tables	—	—
reybex_transaction	SYS	Transaction
reybex_transaction_favorite	SYS	TransactionFavorite
reybex_transaction_right	SYS	TransactionRight
reybex_transaction_trans	SYS	TransactionTranslation
role	SYS	Role
rou_head	PRD	RouHead
rou_item	PRD	RouItem
rou_item_component	PRD	RouItemComponent
rou_item_tools	—	—
runnable_service_event	DEV	RunnableServiceEvent
runnable_service_event_history	—	—
sal_item_deldate_update	SAL	SalesItemDeliveryDateUpdate
sales_customer_mat_group_prices_head	SAL	SalesCustomerMatGroupPricesHead
sales_customer_mat_group_prices_item	SAL	SalesCustomerMatGroupPricesItem
sales_customer_price	SAL	SalesCustomerPrice
sales_customer_price_discount	SAL	SalesCustomerPriceDiscount
sales_customer_price_scaled	SAL	SalesCustomerPriceScaled
sales_dunning_log	SYS	DunningLog
sales_expense	SAL	SalesExpense
sales_goods_relation	SAL	SalesGoodsRelation
sales_head	SAL	SalesHead
sales_head_attachment	—	—
sales_head_cash_discount	SAL	SalesHeadCashDiscount
sales_head_comm_message	SAL	SalesHeadCommMessage
sales_head_comment	SAL	SalesHeadComment
sales_head_detail	SAL	SalesHeadDetail
sales_head_discount	SAL	SalesHeadDiscount
sales_head_email	SAL	SalesHeadEmail
sales_head_export	—	—
sales_head_ltt_tags	—	—
sales_head_packaging	SAL	SalesHeadPackaging
sales_head_recurrence	SAL	SalesHeadRecurrence
sales_head_search	—	—
sales_head_search2	—	—
sales_head_text	SAL	SalesHeadText
sales_head_text_ltt_report	—	—
sales_head_vat_key_wrong	—	—
sales_item	SAL	SalesItem
sales_item_customer_bundle	SAL	SalesItemCustomerBundle
sales_item_deldate_calculation	—	—
sales_item_discount	SAL	SalesItemDiscount
sales_item_disposal	SAL	SalesItemDisposal
sales_item_serial_number	SAL	SalesItemSerialNumber
sales_item_text	SAL	SalesItemText
sales_payment	SAL	SalesPayment
sales_price_variant	SAL	SalesPriceVariant
sales_pricelist_head	SAL	SalesPriceListHead
sales_pricelist_item	SAL	SalesPriceListItem
sales_pricelist_scaled	SAL	SalesPriceListScaled
sales_profit	SAL	SalesProfit
sales_recurrence	—	—
sales_report_temp	—	—
scheduled_job	SYS	ScheduledJob
select_right	—	—
send_pack_import	SMP	SendPackImport
send_pack_import_item	SMP	SendPackImportItem
send_pack_status	SMP	SendPackStatus
send_packs	SMP	SendPacks
send_packs_material	SMP	SendPacksMaterial
send_packs_sales_item	SMP	SendPacksSalesItem
send_posted	SMP	SendPosted
sending_dialog_settings	SAL	SendingDialogSettings
server_health_check	SYS	ServerHealthCheck
shared_warehouse	INV	SharedWarehouse
shippment	SMP	Shippment
shippment_item	SMP	ShippmentItem
social_link	—	—
social_link_viewed	—	—
sold_material_stock	—	—
spotlight_changes	—	—
spotlight_configuration	SYS	SpotlightConfiguration
sprint_user_holidays	—	—
station_invoice	BAS	StationInvoice
status_message	SYS	StatusMessage
stock_head	INV	StockHead
stock_history	INV	StockHistory
stock_history_fin_item	—	—
stock_item	INV	StockItem
stock_item_license_key_mapping	INV	StockItemLicenseKeyMapping
stock_list	INV	StockList
stock_list_history	INV	StockListHistory
stock_list_history_logs	—	—
stock_list_meta_data	INV	StockListMetaData
stock_list_temp	—	—
stock_list_temp_for_history	—	—
stock_number_ranges	SYS	StockNumberRanges
stock_reservation_list	INV	StockReservationList
stock_taking_head	INV	StockTakingHead
stock_taking_item	INV	StockTakingItem
sub_domain_access_right_config	SYS	SubDomainAccessRightConfig
sub_task	SYS	SubTask
support_line	SYS	SupportLine
support_line_sla	SYS	SupportLineSla
sys_audit_event_log	SYS	SysAuditEventLog
sys_audit_log	SYS	SysAuditLog
sys_audit_log_archiv	—	—
sys_bounced_email	SYS	BouncedEmail
sys_check_modul	SYS	CheckModul
sys_check_tables	BAS	CheckTable
sys_exchange_rate	FIN	SysExchangeRate
sys_info_log	SYS	SysInfoLog
sys_log	SYS	Log
sys_printer	SYS	SysPrinter
sys_select_right	SYS	SelectRight
sys_select_right_user	SYS	UserSelectRight
sys_session	SYS	SysSession
sys_session_history	—	—
sys_table_config	SYS	TableConfig
sys_table_config_item	SYS	TableConfigItem
table_copied	—	—
table_dont_copy	—	—
table_filter	SYS	TableFilter
table_localization	SYS	TableLocalization
table_setting	—	—
table_settings	SYS	TableSettings
table_settings_list	—	—
task	PRM	Task
task_changes	SYS	TaskChanges
task_comment	SYS	TaskComment
task_cost	SYS	TaskCost
task_cost_expense	SYS	TaskCostExpense
task_history	SYS	TaskHistory
task_ltt_tags	—	—
task_status_history	SYS	TaskStatusHistory
task_status_list_task_status	—	—
task_type_assign_status	SYS	TaskTypeAssignStatus
task_vcs_status	DEV	TaskVcsStatus
tax_exemption_reason_code	BAS	TaxExemptionReasonCode
temp_database_differences	—	—
temp_shopify	—	—
temp_units	—	—
tenant_to_delete	—	—
tenant_to_delete_old	—	—
test	—	—
test_cases	SYS	TestCases
test_cases_history	SYS	TestCasesHistory
test_cases_positions	SYS	TestCasesPositions
test_cases_positions_history	—	—
test_csv	—	—
test_timestamp	—	—
test_zen	—	—
theme	—	—
ticket_filter	SYS	TicketFilter
tour	SYS	Tour
tradebyte_return	—	—
tradebyte_return_temp	—	—
transaction_assign_item	FIN	TransactionAssignItem
transaction_assign_rule	FIN	TransactionAssignRule
transaction_assign_rule_item	FIN	TransactionAssignRuleItem
transaction_book_error	FIN	TransactionBookError
transaction_refund	FIN	TransactionRefund
ufile	—	—
ufile_transfer	—	—
user	SYS	User
user_cash_register	—	—
user_department	FIN	UserDepartment
user_email_account	—	—
user_email_folders	SYS	UserEmailFolders
user_ltt_shipping_config	—	—
user_ltt_verification_check_group	—	—
user_ltt_warehouse	—	—
user_menu	SYS	UserMenu
user_old_passwords	SYS	UserOldPasswords
user_picking_profile	—	—
user_printer	SYS	UserPrinter
user_role	SYS	UserRole
user_select_right	—	—
user_tenant	SYS	UserTenant
user_warehouse	—	—
userconnection	—	—
variant	—	—
variant_attribute	—	—
variant_attribute_option	—	—
variant_config	—	—
variant_config_value	—	—
variant_value	—	—
vcs_configuration	DEV	VcsConfiguration
verification_head	QLT	VerificationHead
verification_head_attachment	—	—
verification_head_comm_message	—	—
verification_head_comment	—	—
verification_head_discount	QLT	VerificationHeadDiscount
verification_head_email	QLT	VerificationHeadEmail
verification_head_op_split	QLT	VerificationHeadOpSplit
verification_head_text	QLT	VerificationHeadText
verification_head_text_ltt_report	—	—
verification_item	QLT	VerificationItem
verification_item_confirmation	QLT	VerificationItemConfirmation
verification_item_discount	QLT	VerificationItemDiscount
verification_item_sales	QLT	VerificationItemSales
vertreter_update_16670	—	—
wallee_line	FIN	WalleeLine
wallee_transaction	FIN	WalleeTransaction
weightcheck_log	SMP	WeightcheckLog
widget	DEV	Widget
widget_dashboard	DEV	WidgetDashboard
ws_action_log	—	—
ws_description_template	SYS	DescriptionTemplate
ws_property_map	SYS	WsPropertyMap
ws_response_log	SYS	ResponseLog
ws_response_log_request	—	—
zen_shipped_orders	—	—