Company

Tabelle: company
Domain: Company · com.reybex.domain.pms
Modul: SYS

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

• tenant_id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
tenant_id	bigint auto_increment	Ja	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern)
name	varchar(100)	Nein	—	Bezeichnung / Name (Domain: name)
domain	varchar(200)	Ja	—	Domain-Feld domain
email_sender_name	varchar(100)	Ja	—	Domain-Feld emailSenderName
email_host	varchar(100)	Ja	—	Domain-Feld emailHost
file_id	bigint	Ja	—	Fremdschlüssel → file
email_username	varchar(100)	Ja	—	Domain-Feld emailUsername
email_port	int	Ja	0	Domain-Feld emailPort
email_password	varchar(100)	Ja	—	Domain-Feld emailPassword
is_active	smallint	Ja	1	Aktiv-Flag
street	varchar(255)	Ja	—	Domain-Feld street
zipcode	varchar(10)	Ja	—	Domain-Feld zipcode
city	varchar(50)	Ja	—	Domain-Feld city
phone	varchar(50)	Ja	—	Domain-Feld phone
country_id	bigint	Ja	—	Fremdschlüssel → country
culture	varchar(5)	Ja	—	Domain-Feld culture
date_created	datetime	Ja	—	Anlagezeitpunkt
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
pms_license_id	bigint	Ja	—	Fremdschlüssel → pms license
fax	varchar(50)	Ja	—	Domain-Feld fax
mobile	varchar(50)	Ja	—	Domain-Feld mobile
web	varchar(100)	Ja	—	Domain-Feld web
email	varchar(100)	Ja	—	Domain-Feld email
language	char(2)	Ja	'en'	Domain-Feld language
tax_number	varchar(100)	Ja	—	Domain-Feld taxNumber
defaul_sales_price_per_hour	decimal(12, 2)	Ja	0.00	Domain-Feld defaulSalesPricePerHour
user_count	int	Ja	0	user count
end_abo	datetime	Ja	—	Domain-Feld endAbo
start_abo	datetime	Ja	—	Domain-Feld startAbo
email_account_id	bigint	Ja	—	Fremdschlüssel → email account
home_currency_id	bigint	Ja	—	Fremdschlüssel → home currency
ustdid	varchar(50)	Ja	—	Domain-Feld ustdid
gln	varchar(13)	Ja	—	Domain-Feld gln
gs1	varchar(9)	Ja	—	Domain-Feld gs1
main_company_id	bigint	Ja	—	Fremdschlüssel → main company
company_register	varchar(300)	Ja	—	Domain-Feld companyRegister
ceos	varchar(100)	Ja	—	Domain-Feld ceos
report_logo_id	bigint	Ja	—	Fremdschlüssel → report logo
is_main_company	smallint	Ja	—	Boolean: Main Company
is_demo	smallint	Nein	0	Boolean: Demo
ews_host	varchar(500)	Ja	—	Domain-Feld ewsHost
price_decimal_places	smallint	Ja	2	price decimal places
quantity_decimal_places	smallint	Ja	0	quantity decimal places
quantity_price_decimal_places	smallint	Ja	0	Domain-Feld quantityPriceDecimalPlaces
is_quantity_price_rounding	smallint	Ja	0	Boolean: Quantity Price Rounding
product_id	bigint	Ja	—	Fremdschlüssel → product
partner	varchar(100)	Ja	—	Domain-Feld partner
datev_mandant_no	varchar(20)	Ja	—	Domain-Feld datevMandantNo
datev_berater_no	varchar(20)	Ja	—	Domain-Feld datevBeraterNo
elster_version	varchar(10)	Ja	—	Domain-Feld elsterVersion
report_template	smallint	Ja	1	report template
confirmation_date	datetime	Ja	—	Domain-Feld confirmationDate
is_testing	smallint	Ja	0	Boolean: Testing
customer_id	bigint	Ja	—	Domain-Feld customerId
sticker_template	varchar(50)	Ja	—	sticker template
account_type	varchar(50)	Ja	—	Domain-Feld accountType
custom_text	varchar(3000)	Ja	'{"questions":[{"question":"wizard.what.do.you.sell.question","answers":[{"name":"food.and.beverage.category","isSelected":FALSE},{"name":"pet.food.category","isSelected":TRUE},{"name":"travel.category","isSelected":FALSE},{"name":"music.category","isSelected":TRUE},{"name":"film.category","isSelected":FALSE},{"name":"software.category","isSelected":FALSE},{"name":"toys.category","isSelected":TRUE},{"name":"consumer.electronics.category","isSelected":FALSE},{"name":"baby.products.category","isSelected":FALSE},{"name":"consumer.electronics.category","isSelected":FALSE},{"name":"sports.products.category","isSelected":FALSE},{"name":"household.products.category","isSelected":FALSE},{"name":"furniture.category","isSelected":FALSE},{"name":"garden.products.category","isSelected":FALSE}]},{"question":"wizard.what.business.you.do.question","answers":[{"name":"module.ecommerce.title","isSelected":FALSE},{"name":"B2B","isSelected":FALSE},{"name":"B2C","isSelected":TRUE},{"name":"C2B","isSelected":FALSE},{"name":"finance.business.field","isSelected":FALSE},{"name":"ERP","isSelected":TRUE},{"name":"production.field","isSelected":FALSE},{"name":"logistics.field","isSelected":TRUE},{"name":"business.management.field","isSelected":FALSE},{"name":"Drop Shipping","isSelected":FALSE}]}],"modules":[{"moduleCode":"PUR","color":"orange lighten-1","subtitle":"suppliers, purchase orders are managed In this module","isSelected":FALSE,"avatar":"mdi-wallet","title":"module.purchase.title"},{"moduleCode":"SAL","color":"red lighten-1","subtitle":"Orders, Proposals, Invoices can be managed through this module","isSelected":TRUE,"avatar":"mdi-sale","title":"module.sales.title"},{"moduleCode":"INV","color":"blue lighten-1","subtitle":"Stock management and Inventory Here you can manage them all.","isSelected":FALSE,"avatar":"home","title":"module.warehouse.title"},{"moduleCode":"ECOM","color":"green lighten-1","subtitle":"E-commerce platforms management like Amazon, N11, Rakuten and so on","isSelected":TRUE,"avatar":"shop","title":"module.ecommerce.title"},{"moduleCode":"FIN","color":"teal lighten-1","subtitle":"All transactions Can be done in this module","isSelected":TRUE,"avatar":"mdi-bank","title":"finance.business.field"}]}'	Domain-Feld customText
elster_tax_number	varchar(13)	Ja	—	Domain-Feld elsterTaxNumber
fon_number	varchar(50)	Ja	—	Domain-Feld fonNumber
company_code	varchar(20)	Ja	—	Domain-Feld companyCode
is_ts_enabled	smallint	Ja	0	Set to true to enable the TS field for booking. Implemented for CornTec.
tax_office_id	bigint	Ja	—	Fremdschlüssel → tax office
time_zone	varchar(100)	Ja	'Europe/Berlin'	time zone
is_pre_company	smallint	Ja	0	Boolean: Pre Company
headquarter_address	varchar(255)	Ja	—	Domain-Feld headquarterAddress
need_confirm	smallint	Ja	0	need confirm
allow_delete_user_data	smallint	Ja	0	allow delete user data
expiring_days	smallint	Ja	14	expiring days
lock_date	datetime	Ja	—	Domain-Feld lockDate
is_demo_data_used	smallint	Ja	—	Domain-Feld isDemoDataUsed
abacus_client_number	varchar(100)	Ja	—	Domain-Feld abacusClientNumber
audit_proof_archiving	smallint	Ja	0	Domain-Feld auditProofArchiving
partner_tenant_id	bigint	Ja	—	Fremdschlüssel → partner tenant
allow_partner_login	smallint	Ja	0	allow partner login
use_range_in_days_calculation	smallint	Ja	0	use range in days calculation
item_range_value	smallint	Ja	0	item range value
demo_reactivated_count	smallint	Ja	0	demo reactivated count
is_credit_limit_exceedable	smallint	Ja	0	Boolean: Credit Limit Exceedable
is_partner_account	smallint	Ja	0	Boolean: Partner Account
display_name	varchar(255)	Ja	—	Domain-Feld displayName
sort_order	int	Ja	—	Domain-Feld sortOrder

Fremdschlüssel

Spalte(n)	Referenz
country_id	lt_country (id)
tax_office_id	lt_tax_office (id)
pms_license_id	pms_license (id)
partner_tenant_id	company (tenant_id)