vendororder

422 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
liability.vendorOrder_id FK_3B59ECCC1ED6D67CR
liability_vendororder.vendororder_id FK_4D9803DEE7A0B42AC
vendororder_objectgroup.vendororder_id FK_DA62890CE7A0B42AC
vendororder_report.vendororder_id FK_8A515480E7A0B42AC
vendororderdelivery.order_id FK_44EAB7578D9F6D38R
vendororderitem.order_id FK_E2F83D158D9F6D38R
vendororderupload.vendorOrder_id FK_E7255A611ED6D67CR
vendor_id VARCHAR 36 null
vendor.id FK_82C1E65CF603EE73R
warehouse_id VARCHAR 36 null
warehouse.id FK_82C1E65C5080ECDER
client_id VARCHAR 36 null
client.id FK_82C1E65C19EB6921R
created DATETIME 19 null
updated DATETIME 19 null
orderNumber INT 10 null
total DECIMAL 10,2 null
status VARCHAR 50 null
vendorEMail VARCHAR 255 null
vendorCompany VARCHAR 255 null
vendorStreet VARCHAR 255 null
vendorCity VARCHAR 200 null
vendorZip VARCHAR 16 null
vendorPhone VARCHAR 128 null
vendorFax VARCHAR 128 null
vendorContact VARCHAR 128 null
billingEMail VARCHAR 255 null
billingSalutation VARCHAR 255 null
billingCompany VARCHAR 255 null
billingFirstName VARCHAR 255 null
billingLastName VARCHAR 255 null
billingStreet VARCHAR 255 null
billingVatId VARCHAR 50 null
billingCity VARCHAR 200 null
billingZip VARCHAR 16 null
billingPhone VARCHAR 128 null
billingFax VARCHAR 128 null
shippingSalutation VARCHAR 255 null
shippingCompany VARCHAR 255 null
shippingFirstName VARCHAR 255 null
shippingLastName VARCHAR 255 null
shippingStreet VARCHAR 255 null
shippingCity VARCHAR 200 null
shippingZip VARCHAR 16 null
shippingPhone VARCHAR 128 null
shippingFax VARCHAR 128 null
currency VARCHAR 32 null
note LONGTEXT 2147483647 null
quantity INT 10 null
deliveredQuantity INT 10 null
printDate DATE 10 null
mailDate DATE 10 null
faxDate DATE 10 null
remindDate DATE 10 null
vendorCountry_id VARCHAR 36 null
country.id FK_82C1E65C31894D3CR
billingCountry_id VARCHAR 36 null
country.id FK_82C1E65C4FFDFEE3R
billingState_id VARCHAR 36 null
state.id FK_82C1E65CE3C8343DR
shippingCountry_id VARCHAR 36 null
country.id FK_82C1E65CBD1BCD8AR
shippingState_id VARCHAR 36 null
state.id FK_82C1E65C6EAEB92ER
cachedDeliveredPercent DECIMAL 10,4 null
orderBuyingList_id VARCHAR 36 null
orderbuyinglist.id FK_82C1E65CB9BA2274R
updatedInForm DOUBLE 22 null
updateToken VARCHAR 36 null
internalOrder_id VARCHAR 36 null
orders.id FK_82C1E65C18B9AF25R
orderType INT 10 null
totalnetto DECIMAL 10,2 null
proformaInvoiceNumber VARCHAR 255 null
proformaInvoiceDate DATE 10 null
deliveryCost DECIMAL 10,2 null
creditorInvoiceBooked BIT 1 null
clerk_id INT 10 null
users.id FK_82C1E65CD95C1FC6R
paymentTerm INT 10 null
discountTime INT 10 null
discountPercent DECIMAL 10,2 null
exportDate DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_82C1E65C18B9AF25 Performance Asc internalOrder_id
IDX_82C1E65C19EB6921 Performance Asc client_id
IDX_82C1E65C31894D3C Performance Asc vendorCountry_id
IDX_82C1E65C4FFDFEE3 Performance Asc billingCountry_id
IDX_82C1E65C5080ECDE Performance Asc warehouse_id
IDX_82C1E65C6EAEB92E Performance Asc shippingState_id
IDX_82C1E65CB9BA2274 Performance Asc orderBuyingList_id
IDX_82C1E65CBD1BCD8A Performance Asc shippingCountry_id
IDX_82C1E65CD95C1FC6 Performance Asc clerk_id
IDX_82C1E65CE3C8343D Performance Asc billingState_id
IDX_82C1E65CF603EE73 Performance Asc vendor_id

Relationships