payment

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
commissioncontract.payment_id FK_34122FF44C3A3BBR
customer.creditorPayment_id FK_81398E095DDE42F7R
customer.payment_id FK_81398E094C3A3BBR
ecreportitem.payment_id FK_4313015B4C3A3BBR
invoiceledgeritem.payment_id FK_E952138C4C3A3BBR
liability.payment_id FK_3B59ECCC4C3A3BBR
liabilitypayment.payment_id FK_153A78114C3A3BBR
offer.payment_id FK_29D6873E4C3A3BBR
orderpayment.payment_id FK_5794735B4C3A3BBR
orderpaymentcondition.payment_id FK_6502ABFB4C3A3BBR
orderrefund.payment_id FK_528A8C394C3A3BBR
payment_category.payment_id FK_468A5BA94C3A3BBC
payment_country.payment_id FK_4A3AC78C4C3A3BBC
payment_customergroup.payment_id FK_997099644C3A3BBC
payment_excludedcategory.payment_id FK_4490746C4C3A3BBC
payment_excludedclient.payment_id FK_5983CAC24C3A3BBC
payment_excludedcountry.payment_id FK_3D86084F4C3A3BBC
payment_excludedcustomergroup.payment_id FK_635305834C3A3BBC
payment_excludedproduct.payment_id FK_BDBFC5844C3A3BBC
payment_objectgroup.payment_id FK_5B7CD8174C3A3BBC
payment_onlycategory.payment_id FK_B1F468EA4C3A3BBC
payment_onlyproduct.payment_id FK_D66714D34C3A3BBC
payment_product.payment_id FK_CA030A474C3A3BBC
payment_saleschannel.payment_id FK_1FCE8CD64C3A3BBC
paymentfield.payment_id FK_2753A2374C3A3BBR
paymentmetafield.payment_id FK_FB7041084C3A3BBR
retailstore_cashlesspayment.payment_id FK_2165A9064C3A3BBC
retailstore_payment.payment_id FK_BCE69D554C3A3BBC
shipping_excludedpayment.payment_id FK_DDF66F0E4C3A3BBC
shipping_payment.payment_id FK_8B6082C94C3A3BBC
subscriptioncontract.payment_id FK_EED229BF4C3A3BBR
handler VARCHAR 36 null
ident VARCHAR 36 null
title VARCHAR 64 null
sort INT 10 null
creditorPayment BIT 1 null
active BIT 1 null
offsetting BIT 1 null
cashDiscountPercent DECIMAL 10,2 null
cashDiscountDays INT 10 null
paymentFeeForMerchantPercent DECIMAL 10,4 null
paymentFeeForMerchantFix DECIMAL 10,4 null
stornoFeeForMerchantPercent DECIMAL 10,4 null
stornoFeeForMerchantFix DECIMAL 10,4 null
assignmentKey VARCHAR 255 null
longdescription LONGTEXT 2147483647 null
paymentProcessingLink VARCHAR 255 null
paymentTerm INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships