zen_shipped_orders

Tabelle: zen_shipped_orders
Domain: Keine zugeordnete Domain-Entität (Hilfstabelle, Legacy oder mandantenspezifisch).

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)

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
_id	varchar(100)	Ja	—	Fremdschlüssel →
store_id	varchar(100)	Ja	—	Fremdschlüssel → store
reference	varchar(100)	Ja	—	reference
status	varchar(100)	Ja	—	status
shop_order_reference	varchar(100)	Ja	—	shop order reference
shop_order_id	varchar(100)	Ja	—	Fremdschlüssel → shop order
created_at	varchar(100)	Ja	—	created at
processed_at	varchar(100)	Ja	—	processed at
updated_at	varchar(100)	Ja	—	updated at
shipping_additional_details	varchar(100)	Ja	—	shipping additional details
shipping_address_email	varchar(100)	Ja	—	shipping address email
shipping_address_phone	varchar(100)	Ja	—	shipping address phone
shipping_address_country	varchar(100)	Ja	—	shipping address country
shipping_address_region	varchar(100)	Ja	—	shipping address region
shipping_address_city	varchar(100)	Ja	—	shipping address city
shipping_address_zip	varchar(100)	Ja	—	shipping address zip
shipping_address_street2	varchar(100)	Ja	—	shipping address street2
shipping_address_street	varchar(100)	Ja	—	shipping address street
shipping_address_company	varchar(100)	Ja	—	shipping address company
shipping_address_name	varchar(100)	Ja	—	shipping address name
shipping_remote_area	varchar(100)	Ja	—	shipping remote area
shipping_total	varchar(100)	Ja	—	shipping total
shipping_subtotal	varchar(100)	Ja	—	shipping subtotal
billing_email	varchar(100)	Ja	—	billing email
billing_phone	varchar(100)	Ja	—	billing phone
billing_country	varchar(100)	Ja	—	billing country
billing_region	varchar(100)	Ja	—	billing region
billing_city	varchar(100)	Ja	—	billing city
billing_zip	varchar(100)	Ja	—	billing zip
billing_street2	varchar(100)	Ja	—	billing street2
billing_street	varchar(100)	Ja	—	billing street
billing_company	varchar(100)	Ja	—	billing company
billing_name	varchar(100)	Ja	—	billing name
shipment_created_at	varchar(100)	Ja	—	shipment created at
shipment_shipping_option	varchar(100)	Ja	—	shipment shipping option
shipment_tracking_number	varchar(100)	Ja	—	shipment tracking number
shipment_delivery_note	varchar(100)	Ja	—	shipment delivery note
product__id	varchar(100)	Ja	—	Fremdschlüssel → product
product_shop_product_id	varchar(100)	Ja	—	Fremdschlüssel → product shop product
product_shop_variant_id	varchar(100)	Ja	—	Fremdschlüssel → product shop variant
product_price_excl_vat	varchar(100)	Ja	—	product price excl vat
product_price_incl_vat	varchar(100)	Ja	—	product price incl vat
product_variant	varchar(100)	Ja	—	product variant
product_sku	varchar(100)	Ja	—	product sku
product_barcode	varchar(100)	Ja	—	product barcode
product_status	varchar(100)	Ja	—	product status
product_quantity_returned	varchar(100)	Ja	—	product quantity returned
product_quantity_refunded	varchar(100)	Ja	—	product quantity refunded
product_quantity_shipped	varchar(100)	Ja	—	product quantity shipped
product_quantity_ordered	varchar(100)	Ja	—	product quantity ordered
product_lot	varchar(100)	Ja	—	product lot
product_bbd	varchar(100)	Ja	—	product bbd