ContactImportCustomerDoublet

Tabelle: ltt_contact_import_doublet_customer
Domain: ContactImportCustomerDoublet · com.reybex.domain.crm
Modul: CRM

Partner-Hinweise

• Daten liegen mandantengetrennt – bei SELECT fast immer tenant_id = :mandant setzen (Spalte ggf. TenantId in älteren Tabellen).
• Schreibende SQL (INSERT/UPDATE/DELETE) nur in abgestimmten Export-/Report-Jobs (Transaktion BAS23) und nie ohne Freigabe durch reybex.
• Für API-Integrationen bevorzugt die API statt direkter DB-Zugriffe.

→ Beispiel-SQLs (BAS23)

Primärschlüssel

• id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
id	bigint auto_increment	Ja	—	Primärschlüssel (Domain: id)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
customer_id	bigint	Nein	—	Fremdschlüssel → customer
contact_import_id	bigint	Nein	—	Fremdschlüssel → contact import
line	int	Ja	—	Domain-Feld line
name	varchar(100)	Nein	—	Bezeichnung / Name (Domain: name)
street	varchar(255)	Ja	—	Domain-Feld street
zipcode	varchar(10)	Ja	—	Domain-Feld zipcode
city	varchar(50)	Ja	—	Domain-Feld city
po_box	varchar(50)	Ja	—	Domain-Feld poBox
po_zipcode	varchar(50)	Ja	—	Domain-Feld poZipcode
phone	varchar(50)	Ja	—	Domain-Feld phone
fax	varchar(50)	Ja	—	Domain-Feld fax
email	varchar(100)	Ja	—	Domain-Feld email
web	varchar(100)	Ja	—	Domain-Feld web
allow_activity	smallint	Ja	1	allow activity
customer_no	varchar(20)	Ja	—	Domain-Feld customerNo
is_delete	smallint	Nein	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
search_keys	varchar(1000)	Ja	—	Domain-Feld searchKeys
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
contact_type_id	bigint	Ja	—	Fremdschlüssel → contact type
show_in_pms	smallint	Ja	0	show in pms
changed	date	Ja	—	changed
changed_by	bigint	Ja	—	changed by
created_by	bigint	Ja	—	created by
mobile	varchar(30)	Ja	—	Domain-Feld mobile
created	date	Ja	—	created
referenced_by_id	bigint	Ja	—	Fremdschlüssel → referenced by
employee_count	int	Ja	0	Domain-Feld employeeCount
main_contact_id	bigint	Ja	—	Fremdschlüssel → main contact
central_customer_id	bigint	Ja	—	Fremdschlüssel → central customer
country_id	bigint	Ja	—	Fremdschlüssel → country
notes	varchar(2000)	Ja	—	Interne Notizen (Domain: notes)
branch	varchar(500)	Ja	—	Domain-Feld branch
customer_type_id	bigint	Ja	—	Fremdschlüssel → customer type
competitor_it	varchar(255)	Ja	—	Domain-Feld competitorIt
source	varchar(255)	Ja	—	Domain-Feld source
lead_status_id	bigint	Ja	—	Fremdschlüssel → lead status
volume_of_assets	double	Ja	0	Domain-Feld volumeOfAssets
status_reason	varchar(255)	Ja	—	Domain-Feld statusReason
file_id	bigint	Ja	—	Fremdschlüssel → file
tax_department	varchar(100)	Ja	—	Domain-Feld taxDepartment
tax_number	varchar(100)	Ja	—	Domain-Feld taxNumber
rating_id	bigint	Ja	—	Fremdschlüssel → rating
is_dunning	smallint	Ja	1	Boolean: Dunning
name2	varchar(400)	Ja	—	Domain-Feld name2
in_holding	smallint	Ja	0	Domain-Feld inHolding
currency_id	bigint	Ja	—	Fremdschlüssel → currency
is_locked	smallint	Ja	0	Boolean: Locked
language_id	bigint	Ja	—	Fremdschlüssel → language
shipping_id	bigint	Ja	—	Fremdschlüssel → shipping
freight_id	bigint	Ja	—	Fremdschlüssel → freight
main_address_id	bigint	Ja	—	Fremdschlüssel → main address
ustdid	varchar(50)	Ja	—	Domain-Feld ustdid
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
customer_group_id	bigint	Ja	—	Fremdschlüssel → customer group
sales_pricelist_id	bigint	Ja	—	Fremdschlüssel → sales pricelist
sales_department_id	bigint	Ja	—	Fremdschlüssel → sales department
purchase_pricelist_id	bigint	Ja	—	Fremdschlüssel → purchase pricelist
pur_department_id	bigint	Ja	—	Fremdschlüssel → pur department
abc_category	varchar(100)	Ja	—	Domain-Feld abcCategory
credit_limit	decimal(20, 2)	Ja	0.00	Domain-Feld creditLimit
offer_layout	varchar(100)	Ja	—	offer layout
order_layout	varchar(100)	Ja	—	Domain-Feld orderLayout
delivery_layout	varchar(100)	Ja	—	Domain-Feld deliveryLayout
invoice_layout	varchar(100)	Ja	—	Domain-Feld invoiceLayout
distance	decimal(20, 2)	Ja	0.00	Domain-Feld distance
sales_condition_customer_id	bigint	Ja	—	Fremdschlüssel → sales condition customer
sales_person_id	bigint	Ja	—	Fremdschlüssel → sales person
key_account_manager_id	bigint	Ja	—	Fremdschlüssel → key account manager
branch_id	bigint	Ja	—	Fremdschlüssel → branch
offer_layout_id	bigint	Ja	—	Fremdschlüssel → offer layout
order_layout_id	bigint	Ja	—	Fremdschlüssel → order layout
delivery_layout_id	bigint	Ja	—	Fremdschlüssel → delivery layout
invoice_layout_id	bigint	Ja	—	Fremdschlüssel → invoice layout
paymcond_id	bigint	Ja	—	Fremdschlüssel → paymcond
payment_type_id	bigint	Ja	—	Fremdschlüssel → payment type
partly_delivery	smallint	Ja	1	Teillieferung
datev_debitor_no	varchar(10)	Ja	—	Domain-Feld datevDebitorNo
blocked_delivery	smallint	Ja	0	Liefersperre
collective_invoice_id	bigint	Ja	—	Fremdschlüssel → collective invoice
invoice_print_quantity	int	Ja	1	invoice print quantity
invoice_copy_quantity	int	Ja	1	invoice copy quantity
remind_confirmation_days	int	Ja	1	remind confirmation days
remind_delivery_days	int	Ja	1	remind delivery days
remind_due_days	int	Ja	1	remind due days
is_template	smallint	Nein	0	Boolean: Template
ustdid_Last_Check_Date	date	Ja	—	Domain-Feld ustdidLastCheckDate
ustdid_last_check_result	varchar(100)	Ja	'000'	ustdid last check result
our_customer_number	varchar(25)	Ja	—	Domain-Feld ourCustomerNumber
gln	varchar(13)	Ja	—	Domain-Feld gln
print_old_ud	smallint	Ja	1	print old ud
account_id	bigint	Ja	—	Fremdschlüssel → account
delivery_tolerance	decimal(20, 2)	Ja	—	delivery tolerance
print_delivery_date_incw	smallint	Ja	0	print delivery date incw
acquisition_cost	decimal(12, 4)	Ja	—	Domain-Feld acquisitionCost
is_cash_register	smallint	Ja	0	Boolean: Cash Register
date_created	datetime	Ja	—	Anlagezeitpunkt
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
is_gross_price	smallint	Ja	0	Boolean: Gross Price
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)

Fremdschlüssel

Spalte(n)	Referenz
tenant_id	company (tenant_id)
language_id	ltt_language (id)
shipping_id	ltt_shipping (id)
freight_id	ltt_freight (id)
main_address_id	customer_address (id)
customer_group_id	ltt_customer_group (id)
sales_pricelist_id	sales_pricelist_head (id)
sales_department_id	ltt_sales_department (id)
purchase_pricelist_id	ltt_price_list (id)
sales_condition_customer_id	customer (id)
sales_person_id	user (id)
contact_type_id	lt_contact_type (id)
key_account_manager_id	user (id)
branch_id	ltt_branch (id)
offer_layout_id	ltt_report (id)
order_layout_id	ltt_report (id)
delivery_layout_id	ltt_report (id)
invoice_layout_id	ltt_report (id)
pur_department_id	ltt_pur_department (id)
collective_invoice_id	ltt_collective_invoice (id)
payment_type_id	ltt_payment_type (id)
customer_type_id	ltt_customer_type (id)
customer_id	customer (id)
account_id	account (id)
paymcond_id	ltt_paymcond (id)
central_customer_id	customer (id)
main_contact_id	customer_address (id)
lead_status_id	ltt_lead_status (id)
rating_id	lt_rating_type (id)