liability

122 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.liability_id FK_3E0BC42E1E88FF9FR
hbci.liability_id FK_EE3BFE261E88FF9FR
liability_objectgroup.liability_id FK_62A9ED4F1E88FF9FC
liability_vendororder.liability_id FK_4D9803DE1E88FF9FC
liabilityitem.liability_id FK_590A525D1E88FF9FR
liabilitypayment.liability_id FK_153A78111E88FF9FR
liabilitypaymentfield.liability_id FK_B6B7F54B1E88FF9FR
liabilityupload.liability_id FK_28858571E88FF9FR
orders.agentLiability_id FK_E52FFDEEC8CACDD9R
voucher.liability_id FK_1392A5D81E88FF9FR
customer_id VARCHAR 36 null
customer.id FK_3B59ECCC9395C3F3R
country_id VARCHAR 36 null
country.id FK_3B59ECCCF92F3E70R
state_id VARCHAR 36 null
state.id FK_3B59ECCC5D83CC1R
client_id VARCHAR 36 null
client.id FK_3B59ECCC19EB6921R
payment_id VARCHAR 36 null
payment.id FK_3B59ECCC4C3A3BBR
created DATETIME 19 null
updated DATETIME 19 null
number INT 10 null
creditNoteNumber BIGINT 19 null
creditorInvoiceNumber VARCHAR 255 null
total DECIMAL 10,2 null
discount DECIMAL 10,2 null
deliveryCost DECIMAL 10,2 null
paymentCost DECIMAL 10,2 null
deliveryVat DECIMAL 10,2 null
additionalCost DECIMAL 10,2 null
additionalCost2 DECIMAL 10,2 null
additionalCost3 DECIMAL 10,2 null
additionalCost4 DECIMAL 10,2 null
additionalCost5 DECIMAL 10,2 null
status VARCHAR 50 null
email VARCHAR 255 null
salutation VARCHAR 255 null
company VARCHAR 255 null
firstName VARCHAR 255 null
lastName VARCHAR 255 null
street VARCHAR 255 null
street2 VARCHAR 255 null
vatId VARCHAR 50 null
city VARCHAR 200 null
zip VARCHAR 16 null
phone VARCHAR 128 null
fax VARCHAR 128 null
currency VARCHAR 32 null
note LONGTEXT 2147483647 null
internalNote LONGTEXT 2147483647 null
additionalInfo LONGTEXT 2147483647 null
additionalInfo2 LONGTEXT 2147483647 null
additionalInfo3 LONGTEXT 2147483647 null
paymentTransactionId VARCHAR 128 null
paidDate DATETIME 19 null
transactionStatus VARCHAR 128 null
nettoMode BIT 1 null
calcPlusTax BIT 1 null
voucherDiscount DECIMAL 10,2 null
additInfo VARCHAR 255 null
completed BIT 1 null
creditNoteDate DATETIME 19 null
creditorInvoiceDate DATE 10 null
completedDate DATETIME 19 null
paymentDueDate DATE 10 null
vendor_id VARCHAR 36 null
vendor.id FK_3B59ECCCF603EE73R
vendorOrder_id VARCHAR 36 null
vendororder.id FK_3B59ECCC1ED6D67CR
creditorInvoiceFile VARCHAR 255 null
lastupdated INT 10 null
account VARCHAR 12 null
bookingText VARCHAR 255 null
vatNumber VARCHAR 50 null
commissionContract_id VARCHAR 36 null
commissioncontract.id FK_3B59ECCCB3B5D8FAR
cashDiscount DECIMAL 10,2 null
liabilityStatus_id VARCHAR 36 null
entitystatus.id FK_3B59ECCCBB7A1966R
clerk_id INT 10 null
users.id FK_3B59ECCCD95C1FC6R
liabilityTemplate VARCHAR 128 null
pureAccountBooking BIT 1 null
language_id VARCHAR 36 null
language.id FK_3B59ECCC82F1BAF4R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
created_idx Performance Asc created
IDX_3B59ECCC19EB6921 Performance Asc client_id
IDX_3B59ECCC1ED6D67C Performance Asc vendorOrder_id
IDX_3B59ECCC4C3A3BB Performance Asc payment_id
IDX_3B59ECCC5D83CC1 Performance Asc state_id
IDX_3B59ECCC82F1BAF4 Performance Asc language_id
IDX_3B59ECCC9395C3F3 Performance Asc customer_id
IDX_3B59ECCCB3B5D8FA Performance Asc commissionContract_id
IDX_3B59ECCCBB7A1966 Performance Asc liabilityStatus_id
IDX_3B59ECCCD95C1FC6 Performance Asc clerk_id
IDX_3B59ECCCF603EE73 Performance Asc vendor_id
IDX_3B59ECCCF92F3E70 Performance Asc country_id
template_idx Performance Asc liabilityTemplate

Relationships