PurItem

Tabelle: pur_item
Domain: PurItem · com.reybex.domain.wws.purchase
Modul: PUR

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	Ja	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
pur_head_id	bigint	Ja	—	Fremdschlüssel → pur head
reference_pur_item_id	bigint	Ja	—	for example is referenced from Anfrage
item_number	int	Ja	0	Domain-Feld itemNumber
material_id	bigint	Ja	—	Fremdschlüssel → material
name	varchar(200)	Ja	—	Bezeichnung / Name (Domain: name)
long_description	text collate utf8mb4_unicode_ci	Ja	—	Domain-Feld longDescription
short_description	text	Ja	—	Domain-Feld shortDescription
quantity	decimal(20, 8)	Ja	0.00000000	Menge
delivery_date	date	Ja	—	Domain-Feld deliveryDate
expiry_date	date	Ja	—	Domain-Feld expiryDate
price	decimal(20, 8)	Ja	0.00000000	price
price_unit	decimal(20, 8)	Ja	0.00000000	price unit
bonus	decimal(20, 8)	Ja	0.00000000	Domain-Feld bonus
unit_id	bigint	Ja	—	Fremdschlüssel → unit
warehouse_id	bigint	Ja	—	Fremdschlüssel → warehouse
stockplace_id	bigint	Ja	—	Fremdschlüssel → stockplace
specialstock_id	bigint	Ja	—	Fremdschlüssel → specialstock
batchnum	varchar(50)	Ja	—	Domain-Feld batchnum
variant	varchar(100)	Ja	—	Domain-Feld variant
vendor_mat_code	varchar(150)	Ja	—	Domain-Feld vendorMatCode
vendor_mat_name	varchar(150)	Ja	—	Domain-Feld vendorMatName
vendor_mat_description	varchar(100)	Ja	—	Domain-Feld vendorMatDescription
delivery_status	int	Ja	0	0=offen, 1=teilweise gelief., 2=komplett, 3=überliefert
delivered_quantity	decimal(20, 8)	Ja	0.00000000	Domain-Feld deliveredQuantity
is_completed_manually	smallint	Ja	0	manuell die Bestellung abschließen
pur_overdraft_status_id	bigint	Ja	—	Fremdschlüssel → pur overdraft status
invoice_status	int	Ja	0	Domain-Feld invoiceStatus
invoiced_quantity	decimal(20, 8)	Ja	0.00000000	invoiced quantity
drop_shipping_sal_item_id	bigint	Ja	—	if drop Shipping from sales module, here is the sales document item id
vat_key_id	bigint	Ja	—	Fremdschlüssel → vat key
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_id	bigint	Ja	—	Fremdschlüssel → cost center
sal_item_requirements_id	bigint	Ja	—	Fremdschlüssel → sal item requirements
prod_order_component_requirements_id	bigint	Ja	—	Fremdschlüssel → prod order component requirements
internal_order_number	varchar(25)	Ja	—	Domain-Feld internalOrderNumber
internal_order_item	varchar(25)	Ja	—	Domain-Feld internalOrderItem
vendor_order_number	varchar(200)	Ja	—	Domain-Feld vendorOrderNumber
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)
item_code	varchar(100)	Ja	—	Domain-Feld itemCode
position	int	Ja	0	Domain-Feld position
ref_item_id	bigint	Ja	—	Fremdschlüssel → ref item
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
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
length	decimal(30, 8)	Ja	0.00000000	length
proposal_id	bigint	Ja	—	Fremdschlüssel → proposal
confirmed_delivery_date	datetime	Ja	—	Domain-Feld confirmedDeliveryDate
image_to_vendor_date	datetime	Ja	—	Domain-Feld imageToVendorDate
image_to_sales_date	datetime	Ja	—	Domain-Feld imageToSalesDate
image_to_release_date	datetime	Ja	—	Domain-Feld imageToReleaseDate
is_image_assigned_to_vendor	smallint	Ja	0	Boolean: Image Assigned To Vendor
is_image_assigned_to_sales	smallint	Ja	0	Boolean: Image Assigned To Sales
is_image_released	smallint	Ja	0	Boolean: Image Released
ref_open_quantity	decimal(20, 8)	Ja	0.00000000	ref open quantity
is_third_party	smallint	Ja	0	Boolean: Third Party
dun_level	int	Ja	0	dun level
last_dun_date	date	Ja	—	Domain-Feld lastDunDate
remind_level	int	Ja	0	remind level
last_remind_date	date	Ja	—	Domain-Feld lastRemindDate
confirmation_remind_level	int	Ja	0	confirmation remind level
last_confirmation_remind_date	date	Ja	—	Domain-Feld lastConfirmationRemindDate
warehouse_unit_id	bigint	Ja	—	Fremdschlüssel → warehouse unit
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
individual_date	datetime	Ja	—	Domain-Feld individualDate
customer_order_number	varchar(100)	Ja	—	Domain-Feld customerOrderNumber
container_number	varchar(100)	Ja	—	Domain-Feld containerNumber
variant_code	varchar(1000)	Ja	—	Domain-Feld variantCode
is_virtual_material	smallint	Ja	0	Boolean: Virtual Material
is_verification_manually_closed	smallint	Ja	0	Boolean: Verification Manually Closed
attribute_code	varchar(5000) collate utf8mb4_general_ci	Ja	—	Domain-Feld attributeCode
attribute_json	varchar(10000)	Ja	—	Domain-Feld attributeJson
specialstock	varchar(20)	Ja	—	specialstock
pur_order_item_status_id	bigint	Ja	—	Fremdschlüssel → pur order item status
request_change_date	datetime	Ja	—	Domain-Feld requestChangeDate
request_date	date	Ja	—	request date
open_freight_quantity	decimal(20, 8)	Ja	—	open freight quantity
transfer_sales_item_id	bigint	Ja	—	Fremdschlüssel → transfer sales item
open_freight_order_quantity	decimal(20, 8)	Ja	—	Domain-Feld openFreightOrderQuantity
open_freight_invoice_quantity	decimal(20, 8)	Ja	—	Domain-Feld openFreightInvoiceQuantity
base_amount	decimal(30, 8)	Ja	0.00000000	base amount
head_proportion	decimal(20, 8)	Ja	0.00000000	head proportion
head_proportion_discount_amount	decimal(30, 8)	Ja	0.00000000	head proportion discount amount
purchase_comment	text	Ja	—	Domain-Feld purchaseComment
order_description	varchar(200)	Ja	—	Domain-Feld orderDescription
is_pre_selected	smallint	Ja	0	Boolean: Pre Selected
incoming_good_quantity	decimal(20, 8)	Ja	—	Domain-Feld incomingGoodQuantity
is_price_set_manually	smallint	Ja	0	Boolean: Price Set Manually
cargo_ready_date	date	Ja	—	Domain-Feld cargoReadyDate
estimated_departure_date	date	Ja	—	Domain-Feld estimatedDepartureDate
estimated_arrival_date	date	Ja	—	Domain-Feld estimatedArrivalDate

Fremdschlüssel

Spalte(n)	Referenz
pur_order_item_status_id	ltt_pur_order_status (id)
pur_head_id	pur_head (id)
warehouse_id	ltt_warehouse (id)
stockplace_id	ltt_stockplace (id)
tenant_id	company (tenant_id)
ref_item_id	pur_item (id)
proposal_id	proposal (id)
warehouse_unit_id	ltt_unit (id)
cost_center_id	cost_center (id)
vat_key_id	ltt_vat_key (id)
unit_id	ltt_unit (id)
reference_pur_item_id	pur_item (id)
material_id	material (id)