CommHead

Tabelle: comm_head
Domain: CommHead · com.reybex.domain.comm
Modul: EDI

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
tenant_id	bigint	Ja	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
profit_center	varchar(100)	Ja	—	Domain-Feld profitCenter
doc_type	varchar(100)	Ja	—	Belegart (Domain: docType)
doc_number	varchar(50)	Ja	—	Belegnummer (Domain: docNumber)
customer	varchar(200)	Ja	—	Domain-Feld customer
order_date	datetime	Ja	—	Domain-Feld orderDate
paymcond	varchar(500)	Ja	—	Domain-Feld paymcond
order_description	varchar(500)	Ja	—	Domain-Feld orderDescription
tax_type	varchar(100)	Ja	—	tax type
is_paid	smallint	Ja	0	Boolean: Paid
end_date	date	Ja	—	Domain-Feld endDate
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
start_date	date	Ja	—	Domain-Feld startDate
customer_employee	varchar(200)	Ja	—	Domain-Feld customerEmployee
notes	text	Ja	—	Interne Notizen (Domain: notes)
terms	text	Ja	—	Domain-Feld terms
currency	varchar(20)	Ja	—	Domain-Feld 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
vat_rate	decimal(15, 2)	Ja	0.00	Domain-Feld vatRate
items_discount_amount	decimal(15, 2)	Ja	0.00	items discount amount
balance_amount	decimal(15, 2)	Ja	0.00	balance amount
is_hours_proof	smallint	Ja	0	Boolean: Hours Proof
is_recur	smallint	Ja	0	Boolean: Recur
doc_date	datetime	Ja	—	Belegdatum (Domain: docDate)
is_printed	smallint	Ja	0	Boolean: Printed
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)	Ja	—	customer code
tmp_doctype	varchar(3)	Ja	—	tmp doctype
dunlevel_id	bigint	Ja	—	Fremdschlüssel → dunlevel
last_dun_date	datetime	Ja	—	Domain-Feld lastDunDate
date_created	datetime	Ja	—	Anlagezeitpunkt
vat_key	varchar(100)	Ja	—	Domain-Feld vatKey
dun_date	datetime	Ja	—	dun date
op_text	mediumtext	Ja	—	Domain-Feld opText
delivery_date	date	Ja	—	Domain-Feld deliveryDate
customer_addressline1	varchar(255)	Ja	—	Domain-Feld customerAddressline1
customer_zip_street	varchar(255)	Ja	—	Domain-Feld customerZipStreet
customer_addressline2	varchar(255)	Ja	—	Domain-Feld customerAddressline2
customer_street1	varchar(255)	Ja	—	Domain-Feld customerStreet1
customer_street2	varchar(255)	Ja	—	Domain-Feld customerStreet2
customer_is_pobox	smallint	Ja	0	Domain-Feld customerIsPobox
customer_pobox_street	varchar(255)	Ja	—	Domain-Feld customerPoboxStreet
customer_city	varchar(150)	Ja	—	Domain-Feld customerCity
customer_province	varchar(50)	Ja	—	Domain-Feld customerProvince
customer_language	varchar(20)	Ja	—	Domain-Feld customerLanguage
customer_country	varchar(200)	Ja	—	Domain-Feld customerCountry
customer_country_code	varchar(3)	Ja	—	Domain-Feld customerCountryCode
receiver_addressline1	varchar(255)	Ja	—	Domain-Feld receiverAddressline1
receiver_zip_street	varchar(255)	Ja	—	Domain-Feld receiverZipStreet
receiver_addressline2	varchar(255)	Ja	—	Domain-Feld receiverAddressline2
receiver_street1	varchar(255)	Ja	—	Domain-Feld receiverStreet1
receiver_street2	varchar(255)	Ja	—	Domain-Feld receiverStreet2
receiver_is_pobox	smallint	Ja	0	Domain-Feld receiverIsPobox
receiver_pobox_street	varchar(255)	Ja	—	Domain-Feld receiverPoboxStreet
receiver_city	varchar(100)	Ja	—	Domain-Feld receiverCity
receiver_province	varchar(50)	Ja	—	Domain-Feld receiverProvince
receiver_language	varchar(20)	Ja	—	Domain-Feld receiverLanguage
receiver_country	varchar(200) collate utf8mb4_general_ci	Ja	—	Domain-Feld receiverCountry
receiver_country_code	varchar(3)	Ja	—	Domain-Feld receiverCountryCode
customer_phone	varchar(50)	Ja	—	Domain-Feld customerPhone
receiver_phone	varchar(50)	Ja	—	Domain-Feld receiverPhone
customer_zip_pobox	varchar(50)	Ja	—	Domain-Feld customerZipPobox
receiver_zip_pobox	varchar(50)	Ja	—	Domain-Feld receiverZipPobox
receiver_fax	varchar(50)	Ja	—	Domain-Feld receiverFax
customer_fax	varchar(50)	Ja	—	Domain-Feld customerFax
customer_group	varchar(20)	Ja	—	Domain-Feld customerGroup
shipping_priority	smallint	Ja	—	Domain-Feld shippingPriority
shipping	varchar(100)	Ja	—	Domain-Feld shipping
freight	varchar(100)	Ja	—	Domain-Feld freight
product	varchar(100)	Ja	—	Domain-Feld product
carrier	varchar(100)	Ja	—	Domain-Feld carrier
invoice_addressline1	varchar(255)	Ja	—	Domain-Feld invoiceAddressline1
invoice_addressline2	varchar(255)	Ja	—	Domain-Feld invoiceAddressline2
invoice_zip_street	varchar(255)	Ja	—	Domain-Feld invoiceZipStreet
invoice_street1	varchar(255)	Ja	—	Domain-Feld invoiceStreet1
invoice_street2	varchar(255)	Ja	—	Domain-Feld invoiceStreet2
invoice_is_pobox	smallint	Ja	0	Domain-Feld invoiceIsPobox
invoice_pobox_street	varchar(255)	Ja	—	Domain-Feld invoicePoboxStreet
invoice_city	varchar(100)	Ja	—	Domain-Feld invoiceCity
invoice_province	varchar(50)	Ja	—	Domain-Feld invoiceProvince
invoice_language	varchar(20)	Ja	—	Domain-Feld invoiceLanguage
invoice_country	varchar(200) collate utf8mb4_general_ci	Ja	—	Domain-Feld invoiceCountry
invoice_country_code	varchar(3)	Ja	—	Domain-Feld invoiceCountryCode
invoice_phone	varchar(50)	Ja	—	Domain-Feld invoicePhone
invoice_fax	varchar(50)	Ja	—	Domain-Feld invoiceFax
invoice_zip_pobox	varchar(50)	Ja	—	Domain-Feld invoiceZipPobox
marktplace_id	bigint	Ja	—	Domain-Feld marktplaceId
language_id	bigint	Ja	—	Fremdschlüssel → language
partly_delivery	smallint	Ja	1	partly delivery
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	varchar(200)	Ja	—	Domain-Feld salesDepartment
is_manually_closed	smallint	Ja	0	Boolean: Manually Closed
customer_vat_key	varchar(100)	Ja	—	customer vat key
dunlevel	smallint	Ja	—	dunlevel
language	varchar(2)	Ja	—	Domain-Feld language
marktplace	varchar(200)	Ja	—	Domain-Feld marktplace
receiver	varchar(200)	Ja	—	Domain-Feld receiver
receiver_vat_key	varchar(100)	Ja	—	receiver vat key
file	longblob	Ja	—	Domain-Feld file
email_from	varchar(500)	Ja	—	Domain-Feld emailFrom
email_to	varchar(1000)	Ja	—	Domain-Feld emailTo
email_cc	varchar(1000)	Ja	—	Domain-Feld emailCc
email_bcc	varchar(1000)	Ja	—	Domain-Feld emailBcc
email_body	longtext	Ja	—	Domain-Feld emailBody
email_subject	varchar(500)	Ja	—	Domain-Feld emailSubject
postway	smallint	Ja	1	postway
customer_no	varchar(100)	Ja	—	Domain-Feld customerNo
type	varchar(100)	Ja	—	Domain-Feld type
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
company_gln	varchar(13)	Ja	—	Domain-Feld companyGln
delivery_gln	varchar(13)	Ja	—	delivery gln
customer_gln	varchar(13)	Ja	—	Domain-Feld customerGln
company_tax_num	varchar(50)	Ja	—	Domain-Feld companyTaxNum
company_ustd_id	varchar(50)	Ja	—	Domain-Feld companyUstdId
payment_date	date	Ja	—	Domain-Feld paymentDate
payment_day	int	Ja	—	Domain-Feld paymentDay
payment_rate	decimal(15, 2)	Ja	0.00	Domain-Feld paymentRate
payment_total	decimal(15, 2)	Ja	0.00	Domain-Feld paymentTotal
pur_info	varchar(500)	Ja	—	pur info
pur_date	date	Ja	—	pur date
ref_doc_number	varchar(50)	Ja	—	Domain-Feld refDocNumber
discount_amount1	decimal(15, 2)	Ja	0.00	discount amount1
discount_amount2	decimal(15, 2)	Ja	0.00	discount amount2
discount_amount3	decimal(15, 2)	Ja	0.00	discount amount3
discount_amount4	decimal(15, 2)	Ja	0.00	discount amount4
discount_amount5	decimal(15, 2)	Ja	0.00	discount amount5
discount_rate1	decimal(15, 2)	Ja	0.00	discount rate1
discount_rate2	decimal(15, 2)	Ja	0.00	discount rate2
discount_rate3	decimal(15, 2)	Ja	0.00	discount rate3
discount_rate4	decimal(15, 2)	Ja	0.00	discount rate4
discount_rate5	decimal(15, 2)	Ja	0.00	discount rate5
receiver_address_gln	varchar(13)	Ja	—	Domain-Feld receiverAddressGln
invoice_address_gln	varchar(13)	Ja	—	Domain-Feld invoiceAddressGln
customer_address_gln	varchar(13)	Ja	—	Domain-Feld customerAddressGln
invoice_list_number	varchar(50)	Ja	—	RFF+ABO
invoice_list_date	date	Ja	—	Domain-Feld invoiceListDate
customer_ref_no	varchar(50)	Ja	—	Domain-Feld customerRefNo
ref_sales_head	varchar(50)	Ja	—	ref salesHead.docNumber
ref_sales_head_doc_type	varchar(50)	Ja	—	ref salesHead.docType.type
our_customer_number	varchar(50)	Ja	—	Domain-Feld ourCustomerNumber
sales	bigint	Ja	—	sales_head_id
purchase	bigint	Ja	—	pur_head_id
discount_type1	varchar(100)	Ja	—	Domain-Feld discountType1
discount_type2	varchar(100)	Ja	—	Domain-Feld discountType2
discount_type3	varchar(100)	Ja	—	Domain-Feld discountType3
discount_type4	varchar(100)	Ja	—	Domain-Feld discountType4
discount_type5	varchar(100)	Ja	—	Domain-Feld discountType5
multiplier	smallint	Ja	1	multiplier
seller_channel	varchar(100)	Ja	—	Domain-Feld sellerChannel
marketplace_order_status	varchar(100)	Ja	—	Domain-Feld marketplaceOrderStatus
fulfillment_channel	varchar(100)	Ja	—	Domain-Feld fulfillmentChannel
is_prime	smallint	Ja	—	Domain-Feld isPrime
insurance_price_currency	varchar(100)	Ja	—	Domain-Feld insurancePriceCurrency
insurance_price_value	double(15, 2)	Ja	—	Domain-Feld insurancePriceValue
is_ebay_plus	smallint	Ja	—	Domain-Feld isEbayPlus
has_receiver_address	smallint	Ja	—	Domain-Feld hasReceiverAddress
receiver_name	varchar(100)	Ja	—	Domain-Feld receiverName
receiver_salutation	varchar(100)	Ja	—	Domain-Feld receiverSalutation
receiver_company	varchar(100)	Ja	—	Domain-Feld receiverCompany
receiver_email	varchar(200)	Ja	—	Domain-Feld receiverEmail
receiver_additional_address	varchar(100)	Ja	—	Domain-Feld receiverAdditionalAddress
customer_email	varchar(200)	Ja	—	Domain-Feld customerEmail
has_invoice_address	smallint	Ja	—	Domain-Feld hasInvoiceAddress
invoice_name	varchar(100)	Ja	—	Domain-Feld invoiceName
invoice_salutation	varchar(100)	Ja	—	Domain-Feld invoiceSalutation
invoice_company	varchar(100)	Ja	—	Domain-Feld invoiceCompany
invoice_email	varchar(200)	Ja	—	Domain-Feld invoiceEmail
invoice_additional_address	varchar(100)	Ja	—	Domain-Feld invoiceAdditionalAddress
payment_type	varchar(100)	Ja	—	Domain-Feld paymentType
shipping_type	varchar(100)	Ja	—	Domain-Feld shippingType
has_account	smallint	Ja	—	Domain-Feld hasAccount
payer_id	varchar(100)	Ja	—	Domain-Feld payerId
bank_iban	varchar(100)	Ja	—	Domain-Feld bankIban
bank_bic	varchar(100)	Ja	—	Domain-Feld bankBic
bank_name	varchar(100)	Ja	—	Domain-Feld bankName
bank_holder	varchar(100)	Ja	—	Domain-Feld bankHolder
payment_status	varchar(100)	Ja	—	Domain-Feld paymentStatus
order_status	varchar(100)	Ja	—	Domain-Feld orderStatus
is_hitmeister	smallint	Ja	—	Domain-Feld isHitmeister
shipping_price_for_order	double(15, 2)	Ja	—	Domain-Feld shippingPriceForOrder
klarna_invoice_cost	double(15, 2)	Ja	—	Domain-Feld klarnaInvoiceCost
transaction_number	varchar(100)	Ja	—	Domain-Feld transactionNumber
customer_comment	varchar(500)	Ja	—	Domain-Feld customerComment
processing_status_id	bigint	Ja	—	Fremdschlüssel → processing status
processing_tries	smallint	Ja	0	processing tries
transfer_original_doc_number	smallint	Ja	0	transfer original doc number
marketplace_username	varchar(100)	Ja	—	Domain-Feld marketplaceUsername
customer_ustd_id	varchar(50)	Ja	—	Domain-Feld customerUstdId
receiver_ustd_id	varchar(50)	Ja	—	Domain-Feld receiverUstdId
invoice_ustd_id	varchar(50)	Ja	—	Domain-Feld invoiceUstdId
entered_weight	decimal(20, 8)	Ja	0.00000000	entered weight
net_weight	decimal(20, 8)	Ja	0.00000000	net weight
gross_weight	decimal(20, 8)	Ja	0.00000000	gross weight
delivery_mail	varchar(200)	Ja	—	Domain-Feld deliveryMail
remote_reference_number	varchar(50)	Ja	—	Domain-Feld remoteReferenceNumber
einvoice_preview_url	varchar(300)	Ja	—	Domain-Feld einvoicePreviewUrl
company_tax_department	varchar(100)	Ja	—	Domain-Feld companyTaxDepartment
del_note_doc_number	varchar(25)	Ja	—	Domain-Feld delNoteDocNumber
set_default_warehouse	smallint	Ja	0	set default warehouse
connector_reference_number	varchar(100)	Ja	—	Domain-Feld connectorReferenceNumber