Prüftabellen (BAS01)

Transaktion: BAS01 Prüftabellen
UI-Pfad: /checkTables

Business-Zweck

Prüftabellen sind Konfigurations- und Lookup-Listen in reybex – vergleichbar mit Customizing-Tabellen in SAP. Sie definieren erlaubte Werte für Dropdowns, Defaults und fachliche Regeln.

Für Partner sind Prüftabellen relevant, weil Importe und API-Calls IDs oder Codes aus diesen Tabellen erwarten – nicht freie Texte.

Erkennungsmerkmal

Eine Prüftabelle ist ein mandantenspezifischer Lookup-Datensatz, dessen Datenbanktabelle mit ltt_ beginnt (Lookup Table).

Die UI BAS01 und die Check Tables API arbeiten über domainClass (Simple Class Name, z. B. Unit, MatGroup) – unabhängig davon, ob die Tabelle in der UI sichtbar registriert ist (sys_check_tables).

Merkmal	Bedeutung für Partner
Tabelle ltt_*	Stammdaten-/Lookup-Tabelle, mandantenspezifisch (tenantId)
*Translation + ltt_*_trans	Mehrsprachige Bezeichnungen zum Hauptdatensatz
Sortierbare Lookups	Sortierung (sortOrder), Aktiv/Inaktiv (isDisabled)
Abhängigkeiten	Felder verweisen auf andere ltt_*-Tabellen – zuerst anlegen

Stand Backend-Scan: 200 Haupt-Prüftabellen, 59 Übersetzungstabellen (259 gesamt).

Fachlicher Ablauf für Partner

1. Benötigte Lookups aus Integrations-Spezifikation ableiten (z. B. Artikel → Einheit, Artikelgruppe, USt-Schlüssel)
2. Abhängigkeiten beachten: Parent-Tabellen zuerst (z. B. Currency vor Paymcond, Unit vor abgeleiteter Einheit)
3. Werte per UI (BAS01) oder Check Tables API pflegen
4. In Import/API id oder code der Prüftabelle referenzieren – siehe Domain-Struktur

Typische Abhängigkeitsketten (Onboarding)

Szenario	Prüftabellen (Reihenfolge)	Verwendet in
Artikel anlegen	Language → Unit → MatGroup → MatStatus → MaterialType → VatKey → Warehouse	—, BAS02
Kunde / Kontakt	CustomerType → Title → Paymcond → Shipping → Currency	—, CRM
Vertriebsbeleg	SalesDocType → Paymcond → Shipping → VatKey → SalesDepartment	—
Einkaufsbeleg	PurDocType → PurDepartment → Paymcond	PUR-APIs
Lagerbuchung	Warehouse → StockPlace → StockMoveType	—

Gemeinsame Steuerfelder (sortierbare Lookup-Tabellen)

Feld	Typ	Ablauf	Wirkung / Entscheidung
isDisabled	Boolean	BAS01 / alle Lookups	Datensatz ist deaktiviert: erscheint nicht in Dropdowns und vielen Abfragen (isDisabled = false). Bestehende Belege behalten die Referenz – Partner-Imports mit ungültigem Code schlagen fehl.
sortOrder	Integer	BAS01 UI	Sortierung in Auswahllisten und Check-Tables-Grids.
code	String	API / Import	Stabile Partner-Referenz (z. B. prepareAndCreate, Flat-Imports). Bevorzugt gegenüber reinem name.
name	String	UI / Reports	Anzeigename; bei PUR prepareAndCreate oft Auflösung per Belegart-Name (docType).

Boolean-Felder (is…, viele check…): nur true / false. Wertelisten (z. B. „1 = Lieferschein“) gelten für *Type-Integer (delnoteType, invoiceType, …), nicht für das is*-Flag.

Wo welche Prüftabelle den Ablauf steuert

Partner-relevante Entscheidungspunkte – welche Lookup-Tabelle und welche Felder typischerweise den Prozess beeinflussen. Die Tabelle ist eine Landkarte (23 Abläufe); Felder im Detail: Feldreferenz. Mandantenweite Schalter ohne ltt_*: Konfig-Tabellen.

Ablauf	Prüftabellen	Entscheidende Felder / Flags
Artikel anlegen / Material-API (BAS02)	Unit, MatGroup, MatStatus, MaterialType, VatKey, Language, Warehouse	code/id, isDisabled; Unit.exchangeRatio; MaterialType/MatStatus für Defaults; VatKey.rate
Artikel-Import / Connector (BAS05, BAS13)	Unit, MatGroup, VatKey, MatStatus, Brand, Language	Lookup-Codes müssen existieren; isDisabled=false; ggf. Configuration (Import-Modus)
Debitor / Kunde (CRM, Customer-API)	CustomerType, Title, Paymcond, Shipping, Currency, CustomerGroup, Language, VatKey	Paymcond.nettoDays; PaymentType.blockedDelivery; CustomerGroup; ProfitCenter (optional)
Verkaufsbeleg anlegen (SalesHead-API, SAL)	SalesDocType, Paymcond, Shipping, VatKey, SalesDepartment, PaymentType, DiscountType	SalesDocType: isOrder/isInvoice + *Type; checkAvailableStock; stockMoveType; numberRange
Verfügbarkeit / Reservierung (SAL)	Warehouse, StockPlace, SalesDocType, Configuration	Warehouse.isAvailabilityCheckDisabled, isStockkeeping; StockPlace.isNegativeStockAllowed; SalesDocType.checkAvailableStock
Preise / Rabatte (SAL)	DiscountType, VatKey, Currency, CustomerGroup, SalesDocType	DiscountType.isHeadDiscount/isItemDiscount; amountOrPercentage; Kunden-discountType1–3
Folgebelege / Belegketten (SAL)	SalesDocType, SalesHeadDocRule, Report, InvDocType, StockMoveType	isOffer→isOrder→isDelnote→isInvoice; SalesHeadDocRule.fromDocType/toDocType; Druck-Flags
Versand / Packstück (SMP, Pick)	Shipping, ShippingProduct, Carrier, Packaging, ShippingConfig, StockMoveType	Shipping.isActive; Carrier-Zuordnung; StockMoveType.isShippingType; Label-/NVE-Flags
Lagerbuchung / Bestand (Stock-API, INV)	Warehouse, StockPlace, StockMoveType, Unit	StockMoveType.moveTypeCode; statPostway/statFactor; isNegativeStock; Warehouse.isStockplaceMust
Kommissionierung / Lagerplatz (INV)	StockPlace, Warehouse, StockMoveType	isPickplace, pickOrder; isDefault; reservationCheckType; ignorePickAvailability
Wareneingang / Bestellung (PUR)	PurDocType, PurDepartment, Paymcond, Unit, Warehouse, StockMoveType	PurDocType.type=2 (Bestellung); lowerDeliveryTolerance/upperDeliveryTolerance; automaticOrderSendMail
Einkauf Folgebelege (PUR)	PurDocType, PurHeadDocRule, InvDocType, Report	PurDocType.type (Anfrage/Kontrakt/Bestellung/Abruf); WE-Toleranzen; useInMrp
Retouren (SAL/INV)	ReturnReason, ReturnDocType, ReturnStatus, Warehouse, StockPlace, StockMoveType	Return-Grund → Lager/Platz; StockMoveType für Retourenbuchung
Marktplatz-Order-Import (OMP)	Marktplace, SalesDocType, PaymentType, CustomerGroup, Shipping, Warehouse	isActive; materialFindingAlgorithm; isPaidOrders; salesDocType; blockedDelivery; Preis-Sync-Flags
Marktplatz Artikel/Bestand (OMP)	Marktplace, Unit, Warehouse, StockPlace, VatKey	stockImportAlgorithm/stockExportAlgorithm; maxStock; Algorithmen in Marktplace
FiBu-Übergabe / OP (FIN)	VatKey, FinDocType, Paymcond, AccountType, PaymentType	VatKey.vatType, rate, datevPostKey; FinDocType; SalesDocType.finDocType
USt / E-Rechnung / XRechnung	VatKey, TextBlock, EInvoicePrefix, SalesDocType	VatKey.xInvoiceType; SalesDocType.dontSendEinvoice; TextBlock am USt-Schlüssel
Kasse / Fiskaly (CAS)	PaymentType, VatKey, SalesDocType, CashRegister (Stamm)	PaymentType.isCashRegister; VatKey.fiskalyType; Kassen-SalesDocType-Referenzen
Intrastat (Belege)	IntrastatProfiles, TypeOfBusiness, SalesDocType, PurDocType	IntrastatProfiles; SalesDocType.notUsedForIntrastat (Beleg); Profile am Belegkopf
Produktion / MRP (PRD)	Warehouse, PurDocType, SalesDocType, MaterialType, Unit	Warehouse.isNoMrp; PurDocType.useInMrp; SalesDocType.planMrp/useInMrp
Qualität / Prüfung (QLT)	VerificationCheckGroup, StockMoveType, Warehouse	Prüfgruppe; StockMoveType.doQualityControl; Ziel-Lager bei Freigabe
Chargen / Seriennummern (INV, mandantenweit)	Configuration, StockMoveType, Warehouse	Nicht ltt_*: siehe Konfig-Feldreferenz (isBatchnumRequired, …)
Mandanten-Stammdaten (nicht ltt_*)	Company, Configuration	Keine Prüftabellen – Konfiguration Company & Configuration

Feldreferenz (alle Prüftabellen)

Alle ltt_*-Haupt- und Übersetzungstabellen mit jedem Feld, das im Backend ein Boolean/Enum-Schalter ist oder eine dokumentierte Bedeutung hat (Domain-Javadoc, PROPERTY_TYPE_NAME_MAP, deutsche UI-Texte):

→ Prüftabellen – Feldreferenz (vollständig)

Quellen beim Generieren: Domänenmodelle aus com.reybex.domain, messages_de.properties, kuratierte Partner-Ergänzungen in scripts/prueftabellen-field-impact.mjs.

Partner-kritische Prüftabellen

Am häufigsten von Integrations-Domänen referenziert (71 Tabellen):

Prüftabelle	DB-Tabelle	Referenzen	Abhängigkeiten (ltt)	Domain
Unit	ltt_unit	66	Unit	Unit
Currency	ltt_currency	35	—	Currency
Warehouse	ltt_warehouse	30	Fulfillment, Shipping, StockPlace	Warehouse
Marktplace	ltt_marktplace	28	CustomerGroup, Freight, MarketplaceConfig, PaymentType, ProfitCenter, SalesDocType, Shipping, ShippingProduct	Marktplace
Profit Center	ltt_profit_center	26	Currency, ProfitCenter	ProfitCenter
Discount Type	ltt_discount_type	18	—	DiscountType
Stock Place	ltt_stockplace	18	Corridor, CorridorSide, Level, Line, Shelf, Warehouse	StockPlace
Vat Key	ltt_vat_key	17	TextBlock	VatKey
Language	ltt_language	13	—	Language
Sales Doc Type	ltt_sales_doc_type	12	FinDocType, IntrastatProfiles, InvDocType, Marktplace, ProdDocType, Report, SalesDocType, StockMoveType, Warehouse	SalesDocType
Stock Move Type	ltt_stock_move_typ	11	—	StockMoveType
Payment Type	ltt_payment_type	9	Paymcond, TextBlock	PaymentType
Account Type	ltt_account_type	9	—	AccountType
Packaging	ltt_packaging	7	Carrier, Report	Packaging
Shipping	ltt_shipping	7	Carrier, ShippingProduct	Shipping
Paymcond	ltt_paymcond	6	—	Paymcond
Report	ltt_report	6	SalesDocType	Report
Mat Group	ltt_mat_group	6	MatGroup	MatGroup
Fin Doc Type	ltt_fin_doc_type	6	Report	FinDocType
Shipping Product	ltt_shipping_product	5	Carrier	ShippingProduct
Customer Group	ltt_customer_group	5	CustomerGroup, Report	CustomerGroup
Pur Department	ltt_pur_department	5	—	PurDepartment
Sales Department	ltt_sales_department	5	ProfitCenter	SalesDepartment
Text Block	ltt_text_block	5	—	TextBlock
Shipping Config	ltt_shipping_config	5	BarcodeConfiguration, SalesDocType	ShippingConfig
Carrier	ltt_shipping_carrier	4	—	Carrier
Employee Right Type	ltt_employee_right_type	3	—	EmployeeRightType
Dunning Level	ltt_dunning_level	3	Report	DunningLevel
Expense Type	ltt_expense_type	3	—	ExpenseType
Task Type	ltt_task_type	3	—	TaskType
Freight	ltt_freight	3	—	Freight
Material Type	ltt_material_type	3	—	MaterialType
Ebay Seller Profile	ltt_ebay_seller_profile	3	Marktplace	EbaySellerProfile
Return Reason	ltt_return_reason	3	StockPlace, Warehouse	ReturnReason
Verification Check Group	ltt_verification_check_group	3	—	VerificationCheckGroup
Danger	ltt_danger	2	—	Danger
Brand	ltt_brand	2	—	Brand
Dangerous Code	ltt_dangerous_code	2	—	DangerousCode
Intrastat Profiles	ltt_intrastat_profiles	2	TypeOfBusiness	IntrastatProfiles
Inv Doc Type	ltt_inv_doc_type	2	—	InvDocType

UI-Funktionen (BAS01)

• Domänen-spezifische Listen pflegen (gesteuert über sys_check_tables)
• Sortierung (sortObjects)
• Aktiv/Inaktiv (setIsDisabled)
• Mehrsprachige Bezeichnungen (updateTranslations / getTranslationData)
• CSV-Export von Headern

API-Zugriff

Weg	Parameter	Hinweis
—	domainClass=Unit (Beispiel)	Speziell für BAS01, inkl. Übersetzungen
Domain-Struktur	Domain-Struktur	Felder und fachliche Bedeutung

Vollständiges Verzeichnis nach Modul

Basis / Stammdaten (BAS)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Barcode Configuration	ltt_barcode_configuration	—	—	Domain
Brand	ltt_brand	—	Material.brand, MaterialImport.brand	Domain
Dangerous Code	ltt_dangerous_code	—	Material.dangerousCode, MaterialVariant.dangerousCode	Domain
Data Export	ltt_data_export	—	—	Domain
Data Export Item	ltt_data_export_item	—	—	Domain
Disposal Category	ltt_disposal_category	—	MaterialDisposalCategory.disposalCategory	Domain
Disposal Category Fee	ltt_disposal_category_fee	DisposalCategory	—	Domain
EInvoice Prefix	ltt_einvoice_prefix	—	SalesHead.einvoicePrefix	Domain
Email Filter Detail	ltt_email_filter_detail	EmailFilterHead	—	Domain
Email Filter Head	ltt_email_filter_head	Report	EmailWorkflowQueue.emailFilterHead	Domain
Favorite Material	ltt_favorite_material	—	—	Domain
Favorite Material Group	ltt_favorite_material_group	—	—	Domain
Home Edition	ltt_home_edition	—	—	Domain
Integrator	ltt_integrator	IntegratorConfig	—	Domain
Integrator Config	ltt_integrator_config	—	—	Domain
Intrastat Profiles	ltt_intrastat_profiles	TypeOfBusiness	PurHead.intrastatProfiles, SalesHead.intrastatProfiles	Domain
Item Assignment	ltt_item_assignment	Report	SalesItem.itemAssignmentStatus	Domain
Language	ltt_language	—	Configuration.materialLabel3Language, ContactPerson.language, Customer.language, CustomerAddress.language, +9	Domain
Level	ltt_level	—	StockItem.level	Domain
Material Category	ltt_material_category	MaterialCategory	—	Domain
Material Energy Efficiency	ltt_material_energy_efficiency	—	Material.materialEnergyEfficiency	Domain
Material Energy Efficiency Picture	ltt_material_energy_efficiency_picture	—	—	Domain
Material Label	ltt_material_label	—	—	Domain
Material Label Report	ltt_material_label_reports	MaterialLabel, Report	—	Domain
Material Type	ltt_material_type	—	CalculationItem.materialType, Material.materialType, MaterialExport.materialType	Domain
Mat Group	ltt_mat_group	MatGroup	CustomerSalesPerson.matGroup, CustomerSalesPersonDefault.matGroup, Material.matGroup, MaterialGroupDiscount.matGroup, +2	Domain
Mat Status	ltt_mat_status	—	Material.matStatus, MaterialExport.matStatus	Domain
Plant	ltt_plant	—	—	Domain
Print Version	ltt_print_version	—	—	Domain
Raw Material	ltt_raw_material	—	—	Domain
Script Block	ltt_script_block	—	Material.purItemScriptBlock, Material.salesItemScriptBlock	Domain
Service Type	ltt_service_type	—	Material.serviceType	Domain
Stat Mat Num Custom Rate	ltt_stat_mat_num_custom_rate	—	—	Domain
Tax Exemption Default Reason Code	ltt_tax_exemption_default_reason_code	—	—	Domain
Text Block	ltt_text_block	—	MaterialSalesMapping.textBlock, PurHeadText.textBlock, SalesHeadText.textBlock, SalesItemText.textBlock, +1	Domain
Type Of Business	ltt_type_of_business	—	—	Domain
Unit	ltt_unit	Unit	Attribute.unit, AttributeOption.unit, BomHead.baseUnit, BomItem.unit, +62	Domain

Vertrieb (SAL)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Bonus Agreement Head	ltt_bonus_agreement_head	—	Customer.bonusAgreementHead	Domain
Bonus Agreement Item	ltt_bonus_agreement_item	BonusAgreementHead	—	Domain
Cash Move Reason	ltt_cash_move_reason	FinDocType	FinHead.cashMoveReason	Domain
Collective Invoice	ltt_collective_invoice	—	Customer.collectiveInvoice	Domain
Corridor	ltt_corridor	—	StockItem.corridor	Domain
Corridor Side	ltt_corridor_side	—	StockItem.corridorSide	Domain
Customer Branch	ltt_customer_branches	—	—	Domain
Customer Group	ltt_customer_group	CustomerGroup, Report	Customer.customerGroup, MaterialGroupDiscount.customerGroup, MaterialPrices.customerGroup, SalesCustomerMatGroupPricesHead.customerGroup, +1	Domain
Delivery Time	ltt_delivery_time	—	—	Domain
Discount Type	ltt_discount_type	—	Customer.discountType, Customer.discountType2, Customer.discountType3, Customer.itemDiscountType, +14	Domain
Doc Decline Reasons	ltt_doc_decline_reasons	—	DocClosedReason.docDeclineReasons	Domain
Etf Provider	ltt_etf_provider	—	WalleeTransaction.etfProvider	Domain
Etf Terminal	ltt_etf_terminal	EtfProvider	CashRegister.etfTerminal	Domain
Return Doc Type	ltt_return_doc_type	Report	ReturnHead.docType	Domain
Return Reason	ltt_return_reason	StockPlace, Warehouse	ReturnItem.returnReason, ReturnItemExchange.returnReason, ReturnItemSerialNumber.returnReason	Domain
Return Result	ltt_return_result	—	ReturnHead.returnResult	Domain
Return Status	ltt_return_status	—	ReturnItem.returnStatus, ReturnItemExchange.returnStatus	Domain
Sales Bundle Head	ltt_sales_bundle_head	—	SalesItem.salesBundleHead	Domain
Sales Bundle Item	ltt_sales_bundle_item	—	—	Domain
Sales Department	ltt_sales_department	ProfitCenter	CashRegister.salesDepartment, ChequePayrollItem.salesDepartment, Customer.salesDepartment, SalesHead.salesDepartment, +1	Domain
Sales Doc Type	ltt_sales_doc_type	FinDocType, IntrastatProfiles, InvDocType, Marktplace, ProdDocType, Report, SalesDocType, StockMoveType, Warehouse	AssetMove.salesDocType, CashRegister.cancelDocType, CashRegister.deliveryDocType, CashRegister.invoiceDocType, +8	Domain
Sales Head Doc Rule	ltt_sales_head_doc_rule	SalesDocType	—	Domain
Sales Head Intrastat Detail	ltt_sales_head_intrastat_detail	—	—	Domain
Sales Person Relation	ltt_sales_person_relation	—	—	Domain
Sales Positions Type	ltt_sales_positions_type	SalesDocType	SalesItem.salesPositionsType	Domain

Einkauf (PUR)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Pur Department	ltt_pur_department	—	Customer.purDepartment, Material.purDepartment, PurHead.purDepartment, PurPrice.purDepartment, +1	Domain
Pur Doc Type	ltt_pur_doc_type	InvDocType, Report	Material.purDocType, PurHead.docType	Domain
Pur Head Doc Rule	ltt_pur_head_doc_rule	PurDocType	—	Domain
Pur Order Status	ltt_pur_order_status	PurDocType	PurHead.purOrderStatus, PurItem.purOrderItemStatus	Domain
Pur Overdraft Status	ltt_pur_overdraft_status	—	PurItem.purOverdraftStatus	Domain

Lager / Inventur (INV)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Incoming Goods Log	ltt_incoming_goods_log	Unit	—	Domain
Inv Doc Type	ltt_inv_doc_type	—	StockHead.invDocType, StockTakingHead.docType	Domain
Line	ltt_line	—	StockItem.line	Domain
Location	ltt_location	—	Asset.location	Domain
Shelf	ltt_shelf	—	StockItem.shelf	Domain
Stock Move Type	ltt_stock_move_typ	—	StockItem.stockMoveType, StockTakingHead.availEntryMoveType, StockTakingHead.availIssueMoveType, StockTakingHead.blockedEntryMoveType, +7	Domain
Stock Place	ltt_stockplace	Corridor, CorridorSide, Level, Line, Shelf, Warehouse	Configuration.creditNoteStockPlace, MaterialStock.stockplace, PickListItem.stockplace, ProdOrder.stockPlace, +14	Domain
Transit Warehouse Definition	ltt_transit_warehouse_definition	StockMoveType, Warehouse	—	Domain
Warehouse	ltt_warehouse	Fulfillment, Shipping, StockPlace	BomItem.warehouse, CashRegister.warehouse, Configuration.creditNoteWarehouse, Customer.commissionWarehouse, +26	Domain

CRM (CRM)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Action Kind	ltt_action_kind	—	CrmAction.actionKind	Domain
Action Reason	ltt_action_reason	—	CrmAction.actionReason	Domain
Action Type	ltt_action_type	—	CampaignAction.actionType, CrmAction.actionType	Domain
Campaign Participant Status	ltt_crm_campaign_partic_status	—	CampaignParticipant.cpStatus	Domain
Company Department	ltt_company_department	—	—	Domain
Company Position	ltt_company_position	—	—	Domain
Company Source	ltt_company_source	—	CrmOpportunity.companySource	Domain
Contact Import	ltt_contact_import	ContactImportItem, Currency	—	Domain
Contact Import Contact Person Doublet	ltt_contact_import_contact_person_doublet	ContactImportCustomerDoublet, Language	—	Domain
Contact Import Customer Doublet	ltt_contact_import_doublet_customer	Branch, CollectiveInvoice, ContactImport, Currency, CustomerGroup, CustomerType, Freight, Language, LeadStatus, Paymcond, PaymentType, ProfitCenter, PurDepartment, Report, SalesDepartment, Shipping, VatKey	—	Domain
Contact Import Customer Employee Doublet	ltt_contact_import_customer_employee_doublet	ContactImportContactPersonDoublet, ContactImportCustomerDoublet	—	Domain
Contact Import Item	ltt_contact_import_item	ContactImport	—	Domain
Crm Action User To Be Informed	ltt_user_to_be_informed	—	—	Domain
Customer Competitor	ltt_customer_competitor	—	Customer.customerCompetitor	Domain
Customer Pur Text	ltt_pur_text_customer_relation	PurDocType, TextBlock	—	Domain
Customer Sales Text	ltt_sales_text_customer_relation	Marktplace, PaymentType, ProfitCenter, SalesDocType, TextBlock	—	Domain
Customer Type	ltt_customer_type	—	Customer.customerType	Domain
Employee Amount	ltt_employee_amount	—	Customer.employeeAmount	Domain
Employee Interest	ltt_employee_interest	—	—	Domain
Lead Status	ltt_lead_status	LeadStatus	Customer.leadStatus	Domain
Opportunity Status	ltt_opportunity_status	OpportunityStatus	CrmOpportunity.status, CrmOpportunityStatusHistory.opportunityStatus	Domain
Product Type	ltt_product_type	—	—	Domain
Title	ltt_title	—	—	Domain

Finanzen (FIN)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Account Group	ltt_account_group	—	Account.accountGroup, AccountReportingGroup.accountGroup	Domain
Account Mapping	ltt_account_mapping	CustomerGroup, DiscountType, Marktplace, MaterialType, MatGroup, ProfitCenter, SalesDocType, ServiceType, VatKey	—	Domain
Account Type	ltt_account_type	—	Account.accountType, ContactType.accountType, FinBalance.accountType, FinItem.accountType, +5	Domain
Calculation Scheme	ltt_calculation_scheme	—	Material.calculationScheme	Domain
Calculation Scheme Position	ltt_calculation_scheme_position	CalculationScheme, MaterialType	—	Domain
Department	ltt_department	Department	Employee.department, UserDepartment.department	Domain
Employee Health Organization	ltt_employee_health_organization	—	Employee.employeeHealthOrganization	Domain
Employee Right Type	ltt_employee_right_type	—	EmployeeRequest.employeeRightType, EmployeeRequestHistory.employeeRightType, EmployeeRight.employeeRightType	Domain
Fin Doc Type	ltt_fin_doc_type	Report	BankClearingHead.finDocType, FinHead.finDocType, FinItem.finDocType, FinOpenItem.finDocType, +2	Domain
Office	ltt_office	—	Employee.office	Domain
Profit Center	ltt_profit_center	Currency, ProfitCenter	Asset.profitCenter, CashRegister.profitCenter, CompanyBank.profitCenter, CostCenter.profitCenter, +22	Domain
Profit Center Picture	ltt_profit_center_picture	—	—	Domain
Tenant Bank	ltt_tenant_bank	—	—	Domain
Vat Key	ltt_vat_key	TextBlock	Account.vatKey, Configuration.defaultVatKey, Customer.vatKey, CustomerAddress.vatKey, +13	Domain
Vat Key Rule	ltt_vat_key_rule	Currency, Marktplace, MatGroup, ProfitCenter, SalesDocType, VatKey, VerificationDocType	—	Domain

Online Marktplätze (OMP)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Category Marktplace Mapping	ltt_category_marktplace_mapping	Marktplace, MaterialCategory, ShopCategory	—	Domain
Ebay Seller Profile	ltt_ebay_seller_profile	Marktplace	MaterialMarktplace.profilePayment, MaterialMarktplace.profileReturnPolicy, MaterialMarktplace.profileShipping	Domain
Marketplace Config	ltt_marketplace_config	EbaySellerProfile, SalesDocType, StockMoveType, StockPlace, Warehouse	—	Domain
Marketplace Order Import Error	ltt_marketplace_order_import_error	Marktplace	—	Domain
Marktplace	ltt_marktplace	CustomerGroup, Freight, MarketplaceConfig, PaymentType, ProfitCenter, SalesDocType, Shipping, ShippingProduct	AmazonAsinSkuMapping.marktplace, AmazonReportContents.marketplace, AmazonReportFbaInventory.marktplace, AttributeMarketplaceName.marktplace, +24	Domain
Marktplace Article Import	ltt_marktplace_article_import	Marktplace	—	Domain
Marktplace Material Transfer	ltt_marktplace_material_transfer	Marktplace, MarktplaceTransferError	—	Domain
Marktplace Order Transfer	ltt_marktplace_order_transfer	Marktplace, MarktplaceTransferError	—	Domain
Marktplace Transfer Error	ltt_marktplace_transfer_error	Marktplace	—	Domain
Marktplace Warehouse	ltt_marktplace_ltt_warehouse	Marktplace, Warehouse	—	Domain
Shop Category	ltt_shop_category	Marktplace, ShopCategory	—	Domain

Versand / Pick & Pack (SMP)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Carrier	ltt_shipping_carrier	—	DangerCarrier.carrier, MassPrintImport.carrier, SalesHead.carrier, SendPosted.carrier	Domain
Danger	ltt_danger	—	Material.danger, SalesItem.danger	Domain
Document Rules	ltt_shipping_rules	CustomerGroup, Marktplace, MaterialType, MatGroup, ProfitCenter, SalesDocType, Shipping, Warehouse	—	Domain
Freight	ltt_freight	—	Customer.freight, PurHead.freight, SalesHead.freight	Domain
Freight Calculation Config	ltt_freight_calc_config	Carrier, Unit	—	Domain
Freight Distance Api Configuration	ltt_freight_distance_api_configuration	—	—	Domain
Fterms	ltt_fterms	—	SalesHead.fterm	Domain
Fulfillment	ltt_fulfillment	ReturnReason	FulfillmentWarehouse.fulfillment	Domain
Fulfillment Order Status	ltt_fulfillment_order_status	Fulfillment	—	Domain
Iln	ltt_iln	Carrier	—	Domain
Label User Print	ltt_shipping_label_user_print	—	—	Domain
Packaging	ltt_packaging	Carrier, Report	Customer.packaging, Material.packaging, PurHead.packaging, SalesHead.packaging, +3	Domain
Pick Location	ltt_pick_location	—	Pick.location, PickBox.location	Domain
Product2Carrier	ltt_shipping_product_2_carrier	Carrier, ShippingProduct	—	Domain
Profit Center Product	ltt_profit_center_product	ProfitCenter	—	Domain
Shipping	ltt_shipping	Carrier, ShippingProduct	Customer.shipping, PacklistHead.shipping, PurHead.shipping, ReturnHead.shipping, +3	Domain
Shipping Config	ltt_shipping_config	BarcodeConfiguration, SalesDocType	Configuration.shippingConfig, PickingProfile.shippingConfig, SendPackImport.shippingConfig, Shippment.shippingConfig, +1	Domain
Shipping Product	ltt_shipping_product	Carrier	MassPrintImport.product, ProdServiceTags.product, ProdServices.product, SalesHead.product, +1	Domain
Shipping Receiver Id	ltt_shipping_receiver_id	Carrier	—	Domain
Shipping Service	ltt_shipping_service	ShippingProduct	SalesHead.service	Domain
Sortation	ltt_sortation	—	SalesHeadDetail.sortation	Domain
Web Service Connection	ltt_web_service_connection	—	—	Domain
Weight Codes	ltt_weight_codes	—	WeightcheckLog.weightCode	Domain

Produktion (PRD)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Mrp Lot Size	ltt_mrp_lot_size	—	—	Domain
Mrp Method	ltt_mrp_method	—	Material.mrpMethod	Domain
Prod Doc Type	ltt_prod_doc_type	InvDocType, PurDocType, Report, StockMoveType	Material.prodDocType, ProdOrder.docType	Domain
Production Person	ltt_production_person	—	—	Domain
Production Shift	ltt_production_shift	—	—	Domain

Qualität (QLT)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Confirmation Check Group	ltt_confirmation_check_group	ProfitCenter, VerificationCheckGroup, VerificationDocType	—	Domain
Quality Error Reasons	ltt_quality_error_reasons	—	QualityItem.errorReason	Domain
Quality Plan Area	ltt_quality_plan_area	—	QualityHead.qualityPlanArea, QualityPlan.qualityPlanArea	Domain
Quality Plan Check Type	ltt_quality_plan_check_type	—	QualityPlan.qualityPlanCheckType	Domain
Quality Plan Item Type	ltt_quality_plan_item_type	—	QualityItem.qualityPlanItemType, QualityPlanItem.qualityPlanItemType	Domain
Verification Check Group	ltt_verification_check_group	—	VerificationItem.checkGroup, VerificationItemConfirmation.checkGroup, VerificationItemConfirmation.checkGroupTo	Domain
Verification Doc Type	ltt_verification_doc_type	FinDocType, InvDocType, Report, StockMoveType, VerificationCheckGroup, Warehouse	VerificationHead.docType	Domain
Verification Head Doc Rule	ltt_verification_head_doc_rule	VerificationDocType	—	Domain

System (SYS)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Activity Type	ltt_activity_type	—	Task.activityType	Domain
Authority Map	ltt_authority_map	—	—	Domain
Branch	ltt_branch	Branch	Customer.branch	Domain
Crm Integration	ltt_crm_integration	—	CustomerCrmIntegration.crmIntegration	Domain
Crm Integration Customer Transfer	ltt_crm_integration_customer_transfer	CrmIntegration	—	Domain
Currency	ltt_currency	—	Account.currency, BankClearingHead.currency, BankClearingItem.currency, CashRegister.currency, +31	Domain
Domain Access Map	ltt_domain_access_map	—	—	Domain
Dunning Level	ltt_dunning_level	Report	DunningLog.dunningLevel, FinOpenItem.dunningLevel, SalesHead.dunningLevel	Domain
Email Template Rule Sales	ltt_email_template_rule_sales	EmailFilterHead, Marktplace, PaymentType, ProfitCenter, Report, SalesDocType	—	Domain
Expense Resource Type	ltt_expense_resource_type	—	Expense.resourceType, ProjectExpense.resourceType	Domain
Expense Type	ltt_expense_type	—	Expense.expenseType, ProjectExpense.expenseType, TaskCostExpense.expenseType	Domain
Kanban Column Type	ltt_kanban_column_type	—	KanbanColumn.kanbanColumnType	Domain
Menu	ltt_menu	—	User.menu	Domain
Menu Role	ltt_menu_role	—	—	Domain
Menu User	ltt_menu_user	—	—	Domain
Paymcond	ltt_paymcond	—	Customer.paymcond, FinItem.paymcond, FinOpenItem.paymcond, PurHead.paymcond, +2	Domain
Paymcond Op Split	ltt_paymcond_op_split	—	—	Domain
Payment Type	ltt_payment_type	Paymcond, TextBlock	CashRegister.paymentType, CompanyBank.paymentType, Customer.paymentType, FinItem.paymentType, +5	Domain
Picking Zone	ltt_picking_zone	—	Material.pickingZone	Domain
Project Type	ltt_project_type	—	Project.projectType	Domain
Property Access Map	ltt_property_access_map	—	—	Domain
Report	ltt_report	SalesDocType	Customer.deliveryLayout, Customer.invoiceLayout, Customer.orderLayout, CustomerSalesReport.report, +2	Domain
Report Type	ltt_report_type	Report	—	Domain
Role Authority Map	ltt_role_authority_map	—	—	Domain
Role Property Access Map	ltt_role_property_access_map	—	—	Domain
Skill	ltt_skill	—	DeliverableSkill.skill, UserSkill.skill	Domain
Storage	ltt_storage	—	—	Domain
System Property Access Rights	ltt_system_property_access_rights	—	—	Domain
Tags	ltt_tags	—	—	Domain
Task Type	ltt_task_type	—	SupportLineSla.taskType, Task.taskType, TaskTypeAssignStatus.taskType	Domain
Tax Type	ltt_tax_type	—	—	Domain
User Authority Map	ltt_user_authority_map	—	—	Domain
User Property Access Map	ltt_user_property_access_map	—	—	Domain
Widget Type Role List	ltt_widget_type_right	—	—	Domain

Kalender (CAL)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Calendar Holiday	ltt_calendar_holiday	—	—	Domain
Calendar Work Day	ltt_calendar_work_day	—	—	Domain

Dropshipping (DPS)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Dropshipping Customer	ltt_dropshipping_customer	SalesDocType, Shipping, Warehouse	—	Domain
Dropshipping Vendor	ltt_dropshipping_vendor	Warehouse	—	Domain

Webshop Connector (WCO)

Prüftabelle	DB-Tabelle	Abhängigkeiten	Referenziert von (Auszug)	Details
Transfer Reason	ltt_transfer_reason	StockMoveType	—	Domain

Übersetzungstabellen (ltt_*_trans)

Übersetzung	DB-Tabelle	Haupttabelle
AccountGroupTranslation	ltt_account_group_trans	AccountGroup
AccountTypeTranslation	ltt_account_type_trans	AccountType
ActionKindTranslation	ltt_action_kind_trans	ActionKind
ActionReasonTranslation	ltt_action_reason_trans	ActionReason
ActionTypeTranslation	ltt_action_type_trans	ActionType
BranchTranslation	ltt_branch_trans	Branch
CampaignParticipantStatusTranslation	ltt_crm_campaign_partic_status_trans	CampaignParticipantStatus
CollectiveInvoiceTranslation	ltt_collective_invoice_trans	CollectiveInvoice
CompanyDepartmentTranslation	ltt_company_department_trans	CompanyDepartment
CompanyPositionTranslation	ltt_company_position_trans	CompanyPosition
CompanySourceTranslation	ltt_company_source_trans	CompanySource
CurrencyTranslation	ltt_currency_trans	Currency
CustomerBranchTranslation	ltt_customer_branches_trans	CustomerBranch
CustomerGroupTranslation	ltt_customer_group_trans	CustomerGroup
CustomerTypeTranslation	ltt_customer_type_trans	CustomerType
DangerousCodeTranslation	ltt_dangerous_code_trans	DangerousCode
DiscountTypeTranslation	ltt_discount_type_trans	DiscountType
DunningLevelTranslation	ltt_dunning_level_trans	DunningLevel
EmployeeInterestTranslation	ltt_employee_interest_trans	EmployeeInterest
EmployeeRightTypeTranslation	ltt_employee_right_type_trans	EmployeeRightType
FinDocTypeTranslation	ltt_fin_doc_type_trans	FinDocType
FreightTranslation	ltt_freight_trans	Freight
InvDocTypeTranslation	ltt_inv_doc_type_trans	InvDocType
LanguageTranslation	ltt_language_trans	Language
LeadStatusTranslation	ltt_lead_status_trans	LeadStatus
MarktplaceTranslation	ltt_marktplace_trans	Marktplace
MaterialTypeTranslation	ltt_material_type_trans	MaterialType
MatGroupTranslation	ltt_mat_group_trans	MatGroup
MatStatusTranslation	ltt_mat_status_trans	MatStatus
MenuItemTranslation	ltt_menu_item_trans	—
MrpLotSizeTranslation	ltt_mrp_lot_size_trans	MrpLotSize
MrpMethodTranslation	ltt_mrp_method_trans	MrpMethod
OpportunityStatusTranslation	ltt_opportunity_status_trans	OpportunityStatus
PackagingTranslation	ltt_packaging_trans	Packaging
PaymcondTranslation	ltt_paymcond_trans	Paymcond
PaymentTypeTranslation	ltt_payment_type_trans	PaymentType
PlantTranslation	ltt_plant_trans	Plant
ProdDocTypeTranslation	ltt_prod_doc_type_trans	ProdDocType
ProfitCenterTranslation	ltt_profit_center_trans	ProfitCenter
ProjectTypeTranslation	ltt_project_type_trans	ProjectType
PurDocTypeTranslation	ltt_pur_doc_type_trans	PurDocType
PurOrderStatusTranslation	ltt_pur_order_status_trans	PurOrderStatus
RawMaterialTranslation	ltt_raw_material_trans	RawMaterial
ReportTranslation	ltt_report_trans	Report
ReturnReasonTranslation	ltt_return_reason_trans	ReturnReason
ReturnResultTranslation	ltt_return_result_trans	ReturnResult
ReturnStatusTranslation	ltt_return_status_trans	ReturnStatus
SalesDocTypeTranslation	ltt_sales_doc_type_trans	SalesDocType
SendPackStatusTranslation	ltt_send_pack_status_trans	—
ShippingTranslation	ltt_shipping_trans	Shipping
StockMoveTypeTranslation	ltt_stock_move_type_trans	StockMoveType
StockPlaceTranslation	ltt_stock_place_trans	StockPlace
TaskTypeTranslation	ltt_task_type_trans	TaskType
TextBlockTranslation	ltt_text_block_trans	TextBlock
TitleTranslation	ltt_title_trans	Title
UnitTranslation	ltt_unit_trans	Unit
VatKeyTranslation	ltt_vat_key_trans	VatKey
VerificationDocTypeTranslation	ltt_verification_doc_type_trans	VerificationDocType
WarehouseTranslation	ltt_warehouse_trans	Warehouse

Partner-Hinweise

• Vor Artikel-Import Einheiten, Artikelgruppen, USt-Schlüssel und Lager in den Prüftabellen prüfen
• Parent-Lookups (parentUnit, parentMatGroup, …) erfordern zuerst den übergeordneten Datensatz
• Änderungen (insb. isDisabled) können laufende Integrationen brechen, wenn Codes/IDs nicht mehr gültig sind
• Nicht jede ltt_*-Tabelle erscheint in BAS01 – technisch existiert sie dennoch und kann per API angesprochen werden, wenn freigegeben

Weiterlesen

• Domain-Struktur
• API
• Prüftabellen – Feldreferenz