SalesHead

Tabelle: sales_head
Domain: SalesHead · com.reybex.domain.wws.sales
Modul: SAL

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)
profit_center_id	bigint	Ja	—	Fremdschlüssel → profit center
doc_type_id	bigint	Ja	—	Fremdschlüssel → doc type
doc_number	varchar(50) charset utf8mb4	Ja	—	Belegnummer (Domain: docNumber)
customer_id	bigint	Ja	—	Fremdschlüssel → customer
order_date	datetime	Ja	—	Domain-Feld orderDate
paymcond_id	bigint	Ja	—	Fremdschlüssel → paymcond
order_description	varchar(500) charset utf8mb4	Ja	—	Domain-Feld orderDescription
tax_type_id	bigint	Ja	—	Fremdschlüssel → tax type
is_paid	smallint	Ja	0	Boolean: Paid
project_id	bigint	Ja	—	Fremdschlüssel → project
end_date	date	Ja	—	Domain-Feld endDate
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
start_date	date	Ja	—	Domain-Feld startDate
customer_employee_id	bigint	Ja	—	Fremdschlüssel → customer employee
notes	text	Ja	—	Interne Notizen (Domain: notes)
terms	varchar(2000) collate utf8mb4_general_ci	Ja	—	Domain-Feld terms
currency_id	bigint	Ja	—	Fremdschlüssel → currency
exchange_rate	decimal(30, 20)	Ja	0.00000000000000000000	Domain-Feld exchangeRate
total_amount	decimal(15, 2)	Ja	0.00	Domain-Feld totalAmount
total_discount_amount	decimal(15, 2)	Ja	0.00	Domain-Feld totalDiscountAmount
tax_amount	decimal(15, 2)	Ja	0.00	Domain-Feld taxAmount
sub_total	decimal(15, 2)	Ja	0.00	Domain-Feld subTotal
head_discount_amount	decimal(15, 2)	Ja	0.00	head discount amount
items_discount_amount	decimal(15, 2)	Ja	0.00	items discount amount
balance_amount	decimal(15, 2)	Ja	0.00	balance amount
pur_price_amount	decimal(20, 8)	Ja	—	Domain-Feld purPriceAmount
is_hours_proof	smallint	Ja	0	Domain-Feld isHoursProof
is_recur	smallint	Ja	0	Boolean: Recur
recur_type_id	bigint	Ja	—	Fremdschlüssel → recur type
doc_date	datetime	Ja	—	Belegdatum (Domain: docDate)
is_printed	smallint	Ja	0	Boolean: Printed
blocked_delivery	smallint	Nein	0	blocked delivery
due_date	datetime	Ja	—	Domain-Feld dueDate
is_discount_in_amount	smallint	Ja	0	Boolean: Discount In Amount
crm_opportunity_id	bigint	Ja	—	Fremdschlüssel → crm opportunity
status	smallint	Ja	0	status
ref_sales_head_id	bigint	Ja	—	Fremdschlüssel → ref sales head
receiver_id	bigint	Ja	—	Fremdschlüssel → receiver
customer_code	varchar(10) charset utf8mb4	Ja	—	customer code
tmp_doctype	varchar(3) charset utf8mb4	Ja	—	tmp doctype
dunlevel_id	bigint	Ja	—	Fremdschlüssel → dunlevel
last_dun_date	datetime	Ja	—	last dun date
date_created	datetime	Ja	—	Anlagezeitpunkt
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
dun_date	datetime	Ja	—	dun date
op_text	mediumtext charset utf8mb4	Ja	—	Domain-Feld opText
delivery_date	date	Ja	—	Domain-Feld deliveryDate
requisition_date	datetime	Ja	—	Domain-Feld requisitionDate
customer_addressline1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld customerAddressline1
customer_zip_street	varchar(255) charset utf8mb4	Ja	—	Domain-Feld customerZipStreet
customer_addressline2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld customerAddressline2
customer_street1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld customerStreet1
customer_street2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld customerStreet2
customer_is_pobox	smallint	Ja	0	Domain-Feld customerIsPobox
customer_pobox_street	varchar(100) charset utf8mb4	Ja	—	Domain-Feld customerPoboxStreet
customer_city	varchar(150) charset utf8mb4	Ja	—	Domain-Feld customerCity
customer_province	varchar(50) charset utf8mb4	Ja	—	Domain-Feld customerProvince
customer_language_id	bigint	Ja	—	Fremdschlüssel → customer language
customer_country_id	bigint	Ja	—	Fremdschlüssel → customer country
customer_gln	varchar(13) charset utf8mb4	Ja	—	Domain-Feld customerGln
customer_ustd_id	varchar(50) charset utf8mb4	Ja	—	Domain-Feld customerUstdId
cover_addressline1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld coverAddressline1
cover_street1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld coverStreet1
cover_city	varchar(150) charset utf8mb4	Ja	—	Domain-Feld coverCity
cover_zip_street	varchar(255) charset utf8mb4	Ja	—	Domain-Feld coverZipStreet
cover_country_id	bigint	Ja	—	Fremdschlüssel → cover country
cover_gs1	varchar(9) charset utf8mb4	Ja	—	Domain-Feld coverGs1
receiver_customer_id	bigint	Ja	—	Fremdschlüssel → receiver customer
receiver_addressline1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld receiverAddressline1
receiver_zip_street	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverZipStreet
receiver_addressline2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld receiverAddressline2
receiver_street1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld receiverStreet1
receiver_street2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld receiverStreet2
receiver_is_pobox	smallint	Ja	0	Domain-Feld receiverIsPobox
receiver_pobox_street	varchar(100) charset utf8mb4	Ja	—	Domain-Feld receiverPoboxStreet
receiver_city	varchar(100) charset utf8mb4	Ja	—	Domain-Feld receiverCity
receiver_province	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverProvince
receiver_language_id	bigint	Ja	—	Fremdschlüssel → receiver language
receiver_country_id	bigint	Ja	—	Fremdschlüssel → receiver country
receiver_gln	varchar(13) charset utf8mb4	Ja	—	Domain-Feld receiverGln
receiver_ustd_id	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverUstdId
customer_phone	varchar(50) charset utf8mb4	Ja	—	Domain-Feld customerPhone
receiver_phone	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverPhone
receiver_email	varchar(200) charset utf8mb4	Ja	—	Domain-Feld receiverEmail
customer_zip_pobox	varchar(50) charset utf8mb4	Ja	—	Domain-Feld customerZipPobox
receiver_zip_pobox	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverZipPobox
receiver_fax	varchar(50) charset utf8mb4	Ja	—	Domain-Feld receiverFax
customer_fax	varchar(50) charset utf8mb4	Ja	—	Domain-Feld customerFax
customer_group_id	bigint	Ja	—	Fremdschlüssel → customer group
shipping_priority	smallint	Ja	10	shipping priority
shipping_id	bigint	Ja	—	Fremdschlüssel → shipping
freight_id	bigint	Ja	—	Fremdschlüssel → freight
invoice_customer_id	bigint	Ja	—	Fremdschlüssel → invoice customer
invoice_addressline1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld invoiceAddressline1
invoice_addressline2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld invoiceAddressline2
invoice_zip_street	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceZipStreet
invoice_street1	varchar(255) charset utf8mb4	Ja	—	Domain-Feld invoiceStreet1
invoice_street2	varchar(255) charset utf8mb4	Ja	—	Domain-Feld invoiceStreet2
invoice_is_pobox	smallint	Ja	0	Domain-Feld invoiceIsPobox
invoice_pobox_street	varchar(100) charset utf8mb4	Ja	—	Domain-Feld invoicePoboxStreet
invoice_city	varchar(100) charset utf8mb4	Ja	—	Domain-Feld invoiceCity
invoice_province	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceProvince
invoice_language_id	bigint	Ja	—	Fremdschlüssel → invoice language
invoice_country_id	bigint	Ja	—	Fremdschlüssel → invoice country
invoice_phone	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoicePhone
invoice_fax	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceFax
invoice_zip_pobox	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceZipPobox
invoice_gln	varchar(13) charset utf8mb4	Ja	—	Domain-Feld invoiceGln
invoice_ustd_id	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceUstdId
invoice_email	varchar(200) charset utf8mb4	Ja	—	Domain-Feld invoiceEmail
marktplace_id	bigint	Ja	—	Fremdschlüssel → marktplace
invoice_address_id	bigint	Ja	—	Fremdschlüssel → invoice address
receiver_address_id	bigint	Ja	—	Fremdschlüssel → receiver address
customer_address_id	bigint	Ja	—	Fremdschlüssel → customer address
language_id	bigint	Ja	—	Fremdschlüssel → language
partly_delivery	smallint	Ja	1	partly delivery
is_partly_delivery_requested	smallint	Ja	0	Boolean: Partly Delivery Requested
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
customer_vat_key_id	bigint	Ja	—	Fremdschlüssel → customer vat key
receiver_vat_key_id	bigint	Ja	—	Fremdschlüssel → receiver vat key
is_posted	smallint	Ja	0	Boolean: Posted
sales_department_id	bigint	Ja	—	Fremdschlüssel → sales department
is_manually_closed	smallint	Ja	0	Boolean: Manually Closed
export	smallint	Ja	1	export
payment_type_id	bigint	Ja	—	Fremdschlüssel → payment type
paid_amount	decimal(15, 2)	Ja	0.00	for cash register
payment_type2_id	bigint	Ja	—	Fremdschlüssel → payment type2
payment_type2amount	decimal(15, 2)	Ja	0.00	payment type2amount
payment_type3_id	bigint	Ja	—	Fremdschlüssel → payment type3
payment_type3amount	decimal(15, 2)	Ja	0.00	payment type3amount
check_doc_number	varchar(50) charset utf8mb4	Ja	—	check doc number
invoice_list_number	varchar(50) charset utf8mb4	Ja	—	Domain-Feld invoiceListNumber
invoice_list_date	date	Ja	—	Domain-Feld invoiceListDate
gross_amount	decimal(15, 2)	Ja	0.00	gross amount
cash_register_id	bigint	Ja	—	Fremdschlüssel → cash register
coll_head_id	bigint	Ja	—	Fremdschlüssel → coll head
finish_date	datetime	Ja	—	Domain-Feld finishDate
send_status	smallint	Ja	—	Domain-Feld sendStatus
is_packed	smallint	Ja	—	Domain-Feld isPacked
shipping_type_id	bigint	Ja	—	Fremdschlüssel → shipping type
carrier_id	bigint	Ja	—	Fremdschlüssel → carrier
product_id	bigint	Ja	—	Fremdschlüssel → product
service_id	bigint	Ja	—	Fremdschlüssel → service
delivery_id	bigint	Ja	—	Fremdschlüssel → delivery
fterm_id	bigint	Ja	—	Fremdschlüssel → fterm
transportation_number	int	Ja	—	Domain-Feld transportationNumber
avis_txt	varchar(765) charset utf8mb4	Ja	—	avis txt
avis	varchar(765) charset utf8mb4	Ja	—	Domain-Feld avis
delivery_txt	varchar(765) charset utf8mb4	Ja	—	delivery txt
delivery_text	varchar(765) charset utf8mb4	Ja	—	Domain-Feld deliveryText
shipping_txt	varchar(765) charset utf8mb4	Ja	—	shipping txt
shipping_text	varchar(765) charset utf8mb4	Ja	—	Domain-Feld shippingText
is_cod	smallint	Ja	—	Domain-Feld isCod
cod_value	decimal(17, 2)	Ja	—	Domain-Feld codValue
is_lifting_ramp	smallint	Ja	—	Domain-Feld isLiftingRamp
hg_points	int	Ja	—	Domain-Feld hgPoints
hg_weight	decimal(14)	Ja	—	Domain-Feld hgWeight
hg_vp_quan	int	Ja	—	Domain-Feld hgVpQuan
iln_id	bigint	Ja	—	Fremdschlüssel → iln
trans_number	varchar(30) charset utf8mb4	Ja	—	trans number
servicetags	varchar(600) charset utf8mb4	Ja	—	Domain-Feld servicetags
shipping_distance	decimal(11)	Ja	—	Domain-Feld shippingDistance
edv_weight	decimal(15, 2)	Ja	—	Domain-Feld edvWeight
is_send	smallint	Nein	0	Boolean: Send
is_weighted	smallint	Ja	—	Domain-Feld isWeighted
do_pack_list	smallint	Ja	—	Domain-Feld doPackList
updatestat	smallint	Ja	—	Domain-Feld updatestat
routingcode	varchar(492) charset utf8mb4	Ja	—	Domain-Feld routingcode
send_posted_id	bigint	Ja	—	Fremdschlüssel → send posted
product_key	int	Ja	—	Domain-Feld productKey
edi_string	varchar(765) charset utf8mb4	Ja	—	Domain-Feld ediString
billing_no	varchar(75) charset utf8mb4	Ja	—	Domain-Feld billingNo
payment_status_id	bigint	Ja	—	Fremdschlüssel → payment status
order_status_id	bigint	Ja	1	Fremdschlüssel → order status
transaction_number	varchar(100) charset utf8mb4	Ja	—	Domain-Feld transactionNumber
additional_addressline	varchar(255) charset utf8mb4	Ja	—	Domain-Feld additionalAddressline
is_email_send	smallint	Ja	0	Boolean: Email Send
dunning_level_id	bigint	Ja	—	Fremdschlüssel → dunning level
dunning_date	datetime	Ja	—	Domain-Feld dunningDate
order_email	varchar(100) charset utf8mb4	Ja	—	Domain-Feld orderEmail
cash_close_id	bigint	Ja	—	Fremdschlüssel → cash close
payer_id	varchar(50) charset utf8mb4	Ja	—	Domain-Feld payerId
bank_iban	varchar(50) charset utf8mb4	Ja	—	Domain-Feld bankIban
bank_bic	varchar(50) charset utf8mb4	Ja	—	Domain-Feld bankBic
bank_name	varchar(100) charset utf8mb4	Ja	—	Domain-Feld bankName
bank_holder	varchar(100) charset utf8mb4	Ja	—	Domain-Feld bankHolder
is_deposit	smallint	Nein	0	Boolean: Deposit
is_fba	smallint	Nein	0	Boolean: Fba
latest_ship_date	datetime	Ja	—	Domain-Feld latestShipDate
ship_service_level	varchar(80) charset utf8mb4	Ja	—	Domain-Feld shipServiceLevel
shipment_service_level_category	varchar(80) charset utf8mb4	Ja	—	Domain-Feld shipmentServiceLevelCategory
is_prime	smallint	Nein	0	Boolean: Prime
is_premium_order	smallint	Nein	0	Boolean: Premium Order
return_money	decimal(15, 2)	Ja	0.00	return money
is_gross_price	smallint	Nein	0	Boolean: Gross Price
marketplace_username	varchar(100) charset utf8mb4	Ja	—	Domain-Feld marketplaceUsername
pick_list_head_id	bigint	Ja	—	Fremdschlüssel → pick list head
is_avis	smallint	Ja	0	Boolean: Avis
sales_head_status_id	bigint	Ja	—	Fremdschlüssel → sales head status
is_disposal_calculation_skipped	smallint	Ja	0	Boolean: Disposal Calculation Skipped
is_invoice_send	smallint	Ja	0	Domain-Feld isInvoiceSend
invoice_send_date	datetime	Ja	—	Domain-Feld invoiceSendDate
einvoice_preview_url	varchar(300) charset utf8mb4	Ja	—	Domain-Feld einvoicePreviewUrl
einvoice_prefix_id	bigint	Ja	—	Fremdschlüssel → einvoice prefix
einvoice_number	varchar(100) charset utf8mb4	Ja	—	Domain-Feld einvoiceNumber
einvoice_status_text	varchar(100) charset utf8mb4	Ja	—	Domain-Feld einvoiceStatusText
tax_exemption_reason_code_id	varchar(10) charset utf8mb4	Ja	—	Fremdschlüssel → tax exemption reason code
remote_reference_number	varchar(50) charset utf8mb4	Ja	—	Domain-Feld remoteReferenceNumber
is_einvoice	smallint	Ja	—	Domain-Feld isEinvoice
einvoice_taxpayer_pk	varchar(150) charset utf8mb4	Ja	—	Domain-Feld einvoiceTaxpayerPk
picking_list_print_date	datetime	Ja	—	Domain-Feld pickingListPrintDate
net_weight	decimal(20, 8)	Ja	—	net weight
gross_weight	decimal(20, 8)	Ja	—	gross weight
entered_weight	decimal(20, 8)	Ja	—	Domain-Feld enteredWeight
range_number	bigint	Ja	—	Domain-Feld rangeNumber
customer_email	varchar(200) charset utf8mb4	Ja	—	Domain-Feld customerEmail
is_real_time	smallint	Ja	0	Boolean: Real Time
pre_payment_amount	decimal(15, 2)	Ja	0.00	pre payment amount
profit	decimal(20, 8)	Ja	—	Domain-Feld profit
is_refunded	smallint	Ja	—	Boolean: Refunded
total_deposit_amount	decimal(15, 2)	Ja	0.00	total deposit amount
packing_list_print_date	datetime	Ja	—	Domain-Feld packingListPrintDate
is_canceled	smallint	Ja	0	Boolean: Canceled
picking_list_number	smallint	Ja	—	Domain-Feld pickingListNumber
packing_list_number	smallint	Ja	—	Domain-Feld packingListNumber
connector_reference_number	varchar(100) charset utf8mb4	Ja	—	Domain-Feld connectorReferenceNumber
fiskaly_transaction_id	bigint	Ja	—	Fremdschlüssel → fiskaly transaction
connector_status	smallint	Ja	0	connector status
is_service	smallint	Ja	0	Boolean: Service
is_offer_confirmed	smallint	Ja	0	Boolean: Offer Confirmed
free_shipping_type	smallint	Ja	0	free shipping type
from_tenant_id	bigint	Ja	—	Domain-Feld fromTenantId
comm_message_id	bigint	Ja	—	Domain-Feld commMessageId
intrastat_profiles_id	bigint	Ja	—	Fremdschlüssel → intrastat profiles
ref_crm_action_id	bigint	Ja	—	Fremdschlüssel → ref crm action
book_obligatory_tax	smallint	Ja	0	book obligatory tax
marktplace_order_id	varchar(100)	Ja	—	Domain-Feld marktplaceOrderId
packaging_id	bigint	Ja	—	Fremdschlüssel → packaging
offer_lose_reason	longtext	Ja	—	Domain-Feld offerLoseReason
is_offer_lost	smallint	Ja	0	Boolean: Offer Lost
is_pre_invoice_created	smallint	Ja	0	Boolean: Pre Invoice Created
is_rolled_up_invoice_used	smallint	Ja	0	Boolean: Rolled Up Invoice Used
is_final_invoice_by_sales_price_list	smallint	Ja	0	Boolean: Final Invoice By Sales Price List
is_sales_set_separated	smallint	Ja	0	Boolean: Sales Set Separated
desired_invoice_date	datetime	Ja	—	Domain-Feld desiredInvoiceDate
ref_order_doc_number	varchar(50)	Ja	—	Domain-Feld refOrderDocNumber
wallee_transaction_id	bigint	Ja	—	Domain-Feld walleeTransactionId
is_price_only_for_quantity	smallint	Ja	0	Boolean: Price Only For Quantity
custom_fields	longtext	Ja	—	Domain-Feld customFields
pick_number	varchar(20)	Ja	—	Domain-Feld pickNumber
sales_condition_customer_id	bigint	Ja	—	Fremdschlüssel → sales condition customer
sales_person_id	bigint	Ja	—	Fremdschlüssel → sales person
fulfillment_id	bigint	Ja	—	Fremdschlüssel → fulfillment
fulfillment_order_id	varchar(100)	Ja	—	Domain-Feld fulfillmentOrderId
receiver_dispatch_info	varchar(300)	Ja	—	Domain-Feld receiverDispatchInfo
invoice_dispatch_info	varchar(300)	Ja	—	Domain-Feld invoiceDispatchInfo
customer_iln	varchar(100)	Ja	—	Domain-Feld customerIln
receiver_iln	varchar(100)	Ja	—	Domain-Feld receiverIln
invoice_iln	varchar(100)	Ja	—	Domain-Feld invoiceIln
is_open_status	tinyint(1)	Ja	—	Domain-Feld isOpenStatus

Fremdschlüssel

Spalte(n)	Referenz
doc_type_id	ltt_sales_doc_type (id)
ref_sales_head_id	sales_head (id)
customer_id	customer (id)
customer_group_id	ltt_customer_group (id)
marktplace_id	ltt_marktplace (id)
sales_department_id	ltt_sales_department (id)
payment_type_id	ltt_payment_type (id)
cash_register_id	cash_register (id)
payment_status_id	lt_payment_status (id)
tenant_id	company (tenant_id)
sales_head_status_id	lt_sales_head_status (id)
currency_id	ltt_currency (id)
fiskaly_transaction_id	fiskaly_transaction (id)