Warehouse

Tabelle: ltt_warehouse
Domain: Warehouse · com.reybex.domain.wws
Modul: INV

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)
name	varchar(50)	Ja	—	Bezeichnung / Name (Domain: name)
code	varchar(50)	Ja	—	Code / Kurzkennzeichen (Domain: code)
is_stockkeeping	smallint	Nein	0	Boolean: Stockkeeping
is_only_dummy	smallint	Nein	0	Boolean: Only Dummy
is_stockplace_must	smallint	Nein	0	Boolean: Stockplace Must
is_external	smallint	Nein	0	Boolean: External
is_availability_check_disabled	smallint	Ja	0	Boolean: Availability Check Disabled
is_consignment_stock	smallint	Nein	0	Boolean: Consignment Stock
is_virtual	smallint	Nein	0	Boolean: Virtual
customer_id	bigint	Ja	—	Fremdschlüssel → customer
shared_warehouse_token	varchar(33)	Ja	—	Domain-Feld sharedWarehouseToken
addressline1	varchar(255)	Ja	—	Domain-Feld addressline1
addressline2	varchar(255)	Ja	—	Domain-Feld addressline2
street1	varchar(255)	Ja	—	Domain-Feld street1
street2	varchar(255)	Ja	—	Domain-Feld street2
zip_street	varchar(25)	Ja	—	Domain-Feld zipStreet
is_pobox	smallint	Ja	0	Boolean: Pobox
pobox_street	varchar(100)	Ja	—	pobox street
zip_pobox	varchar(50)	Ja	—	zip pobox
country_id	bigint	Ja	—	Fremdschlüssel → country
shipping_id	bigint	Ja	—	Fremdschlüssel → shipping
city	varchar(100)	Ja	—	Domain-Feld city
is_default	tinyint(1)	Nein	0	Boolean: Default
is_active_for_mobile	tinyint(1)	Nein	0	Boolean: Active For Mobile
is_default_warehouse_for_mobile	tinyint(1)	Nein	0	Boolean: Default Warehouse For Mobile
is_stockplace_active_for_mobile	tinyint(1)	Nein	0	Boolean: Stockplace Active For Mobile
is_batchnum_active_for_mobile	tinyint(1)	Nein	0	Boolean: Batchnum Active For Mobile
is_specialstock_active_for_mobile	tinyint(1)	Nein	0	Boolean: Specialstock Active For Mobile
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)
unique_name	varchar(20)	Ja	—	unique name
is_customer_specific	smallint	Nein	0	Boolean: Customer Specific
dont_create_nve	smallint	Ja	0	dont create nve
is_production_warehouse	smallint	Ja	0	Boolean: Production Warehouse
is_fba	smallint	Nein	0	Boolean: Fba
is_disabled	smallint	Ja	0	Boolean: Disabled
sort_order	int	Ja	—	sort order
goods_issue_factor	decimal(20, 8)	Ja	1.00000000	goods issue factor
is_no_mrp	smallint	Ja	0	Boolean: No Mrp
incoming_goods_stock_place_id	bigint	Ja	—	Fremdschlüssel → incoming goods stock place
vendor_id	bigint	Ja	—	Fremdschlüssel → vendor
stock_owner_id	bigint	Ja	—	Fremdschlüssel → stock owner
is_active_for_availability_check	smallint	Ja	1	Boolean: Active For Availability Check
is_apart_grouped_for_mrp	smallint	Ja	0	Boolean: Apart Grouped For Mrp
is_price_evaluation	smallint	Ja	1	Boolean: Price Evaluation
fulfillment_id	bigint	Ja	—	Fremdschlüssel → fulfillment
print_packing_list_at_incoming	smallint	Ja	0	print packing list at incoming
is_transit	smallint	Nein	0	Boolean: Transit
email	varchar(100)	Ja	—	Domain-Feld email
phone	varchar(100)	Ja	—	Domain-Feld phone
homepage	varchar(100)	Ja	—	Domain-Feld homepage
is_not_average_price_calculation	smallint	Ja	0	Boolean: Not Average Price Calculation
pallet_label_print_quantity	int	Ja	1	pallet label print quantity

Fremdschlüssel

Spalte(n)	Referenz
incoming_goods_stock_place_id	ltt_stockplace (id)
vendor_id	customer (id)
tenant_id	company (tenant_id)
country_id	lt_country (id)
fulfillment_id	ltt_fulfillment (id)