CommItem

Tabelle: comm_item
Domain: CommItem · 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)
comm_head_id	bigint	Ja	—	Fremdschlüssel → comm head
set_item_number	int	Ja	—	set item number
is_set_head	smallint	Ja	0	Boolean: Set Head
item_number	int	Ja	0	Domain-Feld itemNumber
material	varchar(200)	Ja	—	Domain-Feld material
short_description	varchar(500)	Ja	—	Domain-Feld shortDescription
long_description	text collate utf8mb4_unicode_ci	Ja	—	Domain-Feld longDescription
quantity	decimal(20, 8)	Ja	0.00000000	Menge (Domain: quantity)
delivery_date	datetime	Ja	—	delivery date
price	decimal(20, 8)	Ja	0.00000000	Domain-Feld price
price_unit	int	Ja	0	Domain-Feld priceUnit
unit	varchar(20)	Ja	—	Domain-Feld unit
warehouse	varchar(200)	Ja	—	Domain-Feld warehouse
stockplace	varchar(200)	Ja	—	Domain-Feld stockplace
specialstock	varchar(200)	Ja	—	Domain-Feld specialstock
batchnum	varchar(50)	Ja	—	Domain-Feld batchnum
variant_code	varchar(1000)	Ja	—	Domain-Feld variantCode
customer_mat_code	varchar(100)	Ja	—	Domain-Feld customerMatCode
customer_mat_name	varchar(200)	Ja	—	Domain-Feld customerMatName
delivery_status	int	Ja	0	delivery status
delivered_quantity	decimal(20, 8)	Ja	0.00000000	Domain-Feld deliveredQuantity
invoice_status	int	Ja	0	invoice status
invoiced_quantity	decimal(20, 8)	Ja	0.00000000	invoiced quantity
vat_key	varchar(20)	Ja	—	Domain-Feld vatKey
total_amount	decimal(20, 8)	Ja	0.00000000	total amount
total_discount_amount	decimal(20, 8)	Ja	0.00000000	total discount amount
nett_amount	decimal(20, 8)	Ja	0.00000000	nett amount
vat_amount	decimal(20, 8)	Ja	0.00000000	vat amount
gross_amount	decimal(20, 8)	Ja	0.00000000	gross amount
cost_center	varchar(200)	Ja	—	Domain-Feld costCenter
internal_order_number	varchar(20)	Ja	—	Domain-Feld internalOrderNumber
internal_order_item	varchar(20)	Ja	—	Domain-Feld internalOrderItem
variant_config	varchar(200)	Ja	—	Domain-Feld variantConfig
date_created	datetime	Ja	—	Anlagezeitpunkt
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
sales_head_deleted	smallint	Nein	0	corresponding salesHead has been deleted
item_code	varchar(50)	Ja	—	Domain-Feld itemCode
item_unity	varchar(50)	Ja	—	Domain-Feld itemUnity
position	int	Ja	0	Domain-Feld position
open_quantity	decimal(20, 8)	Ja	0.00000000	open quantity
volume	decimal(30, 8)	Ja	0.00000000	volume
width	decimal(30, 8)	Ja	0.00000000	width
depth	decimal(30, 8)	Ja	0.00000000	depth
height	decimal(30, 8)	Ja	0.00000000	height
is_print_packlist	smallint	Ja	0	Kommissionierschein gedruckt
print_packlist_date	datetime	Ja	—	Domain-Feld printPacklistDate
close_ref_sales_item	smallint	Ja	0	close ref sales item
is_third_party	smallint	Ja	0	Boolean: Third Party
warehouse_unit	varchar(20)	Ja	—	Domain-Feld warehouseUnit
warehouse_unit_quantity	decimal(30, 8)	Ja	0.00000000	warehouse unit quantity
warehouse_unit_exchange_ratio	decimal(40, 8)	Ja	1.00000000	warehouse unit exchange ratio
material_price_unit	decimal(20, 8)	Ja	—	Domain-Feld materialPriceUnit
pur_price	decimal(20, 8)	Ja	—	Domain-Feld purPrice
average_price	decimal(20, 8)	Ja	—	Domain-Feld averagePrice
last_pur_price	decimal(20, 8)	Ja	—	Domain-Feld lastPurPrice
aquisition_price	decimal(20, 8)	Ja	—	Domain-Feld aquisitionPrice
cost_price	decimal(20, 8)	Ja	—	Domain-Feld costPrice
pur_value_for_pur_price	decimal(20, 8)	Ja	—	Domain-Feld purValueForPurPrice
pur_value_for_average_price	decimal(20, 8)	Ja	—	Domain-Feld purValueForAveragePrice
pur_value_for_last_pur_price	decimal(20, 8)	Ja	—	Domain-Feld purValueForLastPurPrice
pur_value_for_aquisition_price	decimal(20, 8)	Ja	—	Domain-Feld purValueForAquisitionPrice
pur_value_for_cost_price	decimal(20, 8)	Ja	—	Domain-Feld purValueForCostPrice
evaluation_type	smallint	Ja	—	Domain-Feld evaluationType
availability_date	date	Ja	—	Domain-Feld availabilityDate
head_proportion	decimal(20, 8)	Ja	0.00000000	head proportion
head_proportion_discount_amount	decimal(20, 8)	Ja	0.00000000	head proportion discount amount
net_weight	decimal(30, 8)	Ja	0.00000000	net weight
net_weight_unit	varchar(20)	Ja	—	Domain-Feld netWeightUnit
gross_weight	decimal(30, 8)	Ja	0.00000000	gross weight
gross_weight_unit	varchar(20)	Ja	—	Domain-Feld grossWeightUnit
set_item_quantity	double	Ja	1	set item quantity
is_gross_price	smallint	Ja	0	Boolean: Gross Price
print_packlist_by	varchar(200)	Ja	—	Domain-Feld printPacklistBy
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
material_mat_code	varchar(100)	Ja	—	Domain-Feld materialMatCode
material_sku	varchar(100)	Ja	—	Domain-Feld materialSku
material_gtin	varchar(50)	Ja	—	Domain-Feld materialGtin
vat_rate	decimal(15, 2)	Ja	0.00	vat rate
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
gross_price	decimal(20, 8)	Ja	0.00000000	gross price
discount_input	varchar(20)	Ja	—	Domain-Feld discountInput
material_variant_gtin	varchar(20)	Ja	—	Domain-Feld materialVariantGtin
bom_item_number	int	Ja	—	Domain-Feld bomItemNumber
template_position	int	Ja	—	template position
discount_name1	varchar(200)	Ja	—	Domain-Feld discountName1
discount_name2	varchar(200)	Ja	—	Domain-Feld discountName2
discount_name3	varchar(200)	Ja	—	Domain-Feld discountName3
discount_name4	varchar(200)	Ja	—	Domain-Feld discountName4
discount_name5	varchar(200)	Ja	—	Domain-Feld discountName5
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
currency	varchar(20)	Ja	—	Domain-Feld currency
shipping_price	double(15, 2)	Ja	—	Domain-Feld shippingPrice
material_asin	varchar(100)	Ja	—	Domain-Feld materialAsin
betterment_tax	double(15, 2)	Ja	—	Domain-Feld bettermentTax
discount	double(15, 2)	Ja	—	Domain-Feld discount
shipping_currency	varchar(20)	Ja	—	Domain-Feld shippingCurrency
created_sales_item_id	bigint	Ja	—	Fremdschlüssel → created sales item
dropshippin_customer_pur_item_id	bigint	Ja	—	Domain-Feld dropshippinCustomerPurItemId
edi_qty_code	varchar(3)	Ja	—	Domain-Feld ediQtyCode
attribute_code	varchar(5000) collate utf8mb4_general_ci	Ja	—	Domain-Feld attributeCode
variant_sku	varchar(100)	Ja	—	Domain-Feld variantSku
variant_name	varchar(500)	Ja	—	Domain-Feld variantName
sales_head_doc_number	varchar(20)	Ja	—	Domain-Feld salesHeadDocNumber
is_imported	smallint	Ja	0	Boolean: Imported
commission_number	varchar(50)	Ja	—	Domain-Feld commissionNumber
nve	varchar(100)	Ja	—	Domain-Feld nve
gin_bj	varchar(100)	Ja	—	Domain-Feld ginBj
material_id	bigint	Ja	—	Domain-Feld materialId
master_sku	varchar(100)	Ja	—	Domain-Feld masterSku
order_description	varchar(200)	Ja	—	Domain-Feld orderDescription

Fremdschlüssel

Spalte(n)	Referenz
comm_head_id	comm_head (id)