orders

22592 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.order_id FK_3E0BC42E8D9F6D38R
amazoninvoicejob.order_id FK_5B25E6558D9F6D38R
amazonorderadjustmentjob.order_id FK_8F4BA2E68D9F6D38R
amazonordersendjob.order_id FK_199C39F78D9F6D38R
cashreportitem.order_id FK_AA0D8828D9F6D38R
commissioncontract_order.order_id FK_6BF14E868D9F6D38R
contact.order_id FK_4C62E6388D9F6D38R
ebayorderjob.order_id FK_D49D7FD78D9F6D38R
ecreportitem.order_id FK_4313015B8D9F6D38R
hbci.order_id FK_EE3BFE268D9F6D38R
hbci_order.order_id FK_DDB6F5198D9F6D38C
invoiceledgeritem.order_id FK_E952138C8D9F6D38R
liabilityitem.agentOrder_id FK_590A525DD2F28CB9R
offer.order_id FK_29D6873E8D9F6D38R
order_objectgroup.order_id FK_B642774B8D9F6D38C
order_pickingwarehouse.order_id FK_F2D91A2F8D9F6D38C
order_report.order_id FK_7A067518D9F6D38C
orderinternalcomment.order_id FK_764879078D9F6D38R
ordermetafield.order_id FK_5A4EE1D18D9F6D38R
orderpayment.order_id FK_5794735B8D9F6D38R
orderpaymentcondition.order_id FK_6502ABFB8D9F6D38R
orderpicking.order_id FK_395899738D9F6D38R
orderrefund.order_id FK_528A8C398D9F6D38R
orderremind.order_id FK_90B7512C8D9F6D38R
orderreturn.order_id FK_AE38A76E8D9F6D38R
orders.parentOrder_id FK_E52FFDEE72E99A55R
orders.parentShippingOrder_id FK_E52FFDEE1BC170BAR
orders.splittedFromOrder_id FK_E52FFDEE5A494F36R
paypaltransaction.order_id FK_47BECB318D9F6D38R
picklistreservation_orders.order_id FK_786F01CB8D9F6D38C
realinvoicejob.order_id FK_77C5FFB98D9F6D38R
subscriptioncontract.lastOrder_id FK_EED229BF662DD25BR
trackinginfo.order_id FK_C192DB1E8D9F6D38R
vendororder.internalOrder_id FK_82C1E65C18B9AF25R
vendororderdelivery.customerOrder_id FK_44EAB7571C7C4AADR
voucherreportitem.order_id FK_7BED79A28D9F6D38R
warehousestoragelocation.order_id FK_CBC9E6B78D9F6D38R
offer_id VARCHAR 36 null
offer.id FK_E52FFDEE53C674EER
client_id VARCHAR 36 null
client.id FK_E52FFDEE19EB6921R
created DATETIME 19 null
updated DATETIME 19 null
foreign_id VARCHAR 36 null
orderNumber BIGINT 19 null
storno BIT 1 null
invoiceNumber BIGINT 19 null
invoiceFile VARCHAR 100 null
invoiceDate DATETIME 19 null
creditNoteNumber BIGINT 19 null
creditNoteFile VARCHAR 100 null
creditNoteDate DATETIME 19 null
trackingCode VARCHAR 128 null
pickList_id VARCHAR 36 null
picklist.id FK_E52FFDEE3F473D40R
orderBuyingList_id VARCHAR 36 null
orderbuyinglist.id FK_E52FFDEEB9BA2274R
clerk_id INT 10 null
users.id FK_E52FFDEED95C1FC6R
receiptNumber BIGINT 19 null
receiptDate DATETIME 19 null
posTerminal_id VARCHAR 36 null
posterminal.id FK_E52FFDEE4BE3C43ER
receiptFile VARCHAR 255 null
receiptStornoNumber BIGINT 19 null
receiptStornoDate DATETIME 19 null
cashReport_id VARCHAR 36 null
cashreport.id FK_E52FFDEE856092CER
receiptStornoFile VARCHAR 255 null
stornoBookingAwaited BIT 1 null
cashGiven DECIMAL 10,2 null
drawback DECIMAL 10,2 null
ecReport_id VARCHAR 36 null
ecreport.id FK_E52FFDEE5FFE0628R
voucherReport_id VARCHAR 36 null
voucherreport.id FK_E52FFDEE79443B8AR
remindDate DATETIME 19 null
remindCount INT 10 null
paymentTermDate DATETIME 19 null
parentOrder_id VARCHAR 36 null
orders.id FK_E52FFDEE72E99A55R
partialNumber INT 10 null
agentLiability_id VARCHAR 36 null
liability.id FK_E52FFDEEC8CACDD9R
salesChannel_id VARCHAR 36 null
saleschannel.id FK_E52FFDEE4C7A5B2ER
reservedField VARCHAR 100 null
hasPartialOrders BIT 1 null
paymentInvoiceTermDate DATETIME 19 null
ignoreReservation BIT 1 null
otherCreditNoteNumbers VARCHAR 255 null
mrnNumber VARCHAR 255 null
warehouse_id VARCHAR 36 null
warehouse.id FK_E52FFDEE5080ECDER
parentShippingOrder_id VARCHAR 36 null
orders.id FK_E52FFDEE1BC170BAR
splittedFromOrder_id VARCHAR 36 null
orders.id FK_E52FFDEE5A494F36R
reservedOrderNumber INT 10 null
uniqNumber VARCHAR 128 null
excludeFromStatistic BIT 1 null
signature VARCHAR 255 null
publicKeyObject_id VARCHAR 36 null
publickey.id FK_E52FFDEE3B0ABC10R
stornoSignature VARCHAR 255 null
stornoPublicKeyObject_id VARCHAR 36 null
publickey.id FK_E52FFDEE17458494R
dailyClosingDate DATETIME 19 null
invoiceUniqNumber VARCHAR 255 null
excludeFromStatisticAllClients BIT 1 null
wormSignature LONGTEXT 2147483647 null
stornoWormSignature LONGTEXT 2147483647 null
tseTransactionNumber VARCHAR 32 null
tseStartDate VARCHAR 20 null
tseFinishDate VARCHAR 20 null
tseStornoTransactionNumber VARCHAR 32 null
tseStornoStartDate VARCHAR 20 null
tseStornoFinishDate VARCHAR 20 null
tseSerialNumber VARCHAR 255 null
tseStornoSerialNumber VARCHAR 255 null
cashDiscountNotUsed BIT 1 null
costCenter_id VARCHAR 36 null
costcenter.id FK_E52FFDEE43237701R
returnTrackingCode VARCHAR 100 null
forceCashDiscount BIT 1 null
customDeliveryNoteNumber INT 10 null
uncollectible BIT 1 null
expedition_id VARCHAR 36 null
expedition.id FK_E52FFDEE576EF81ER

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
created_idx Performance Asc created
IDX_E52FFDEE17458494 Performance Asc stornoPublicKeyObject_id
IDX_E52FFDEE19EB6921 Performance Asc client_id
IDX_E52FFDEE1BC170BA Performance Asc parentShippingOrder_id
IDX_E52FFDEE3B0ABC10 Performance Asc publicKeyObject_id
IDX_E52FFDEE3F473D40 Performance Asc pickList_id
IDX_E52FFDEE43237701 Performance Asc costCenter_id
IDX_E52FFDEE4BE3C43E Performance Asc posTerminal_id
IDX_E52FFDEE4C7A5B2E Performance Asc salesChannel_id
IDX_E52FFDEE5080ECDE Performance Asc warehouse_id
IDX_E52FFDEE576EF81E Performance Asc expedition_id
IDX_E52FFDEE5A494F36 Performance Asc splittedFromOrder_id
IDX_E52FFDEE5FFE0628 Performance Asc ecReport_id
IDX_E52FFDEE72E99A55 Performance Asc parentOrder_id
IDX_E52FFDEE79443B8A Performance Asc voucherReport_id
IDX_E52FFDEE856092CE Performance Asc cashReport_id
IDX_E52FFDEEB9BA2274 Performance Asc orderBuyingList_id
IDX_E52FFDEEC8CACDD9 Performance Asc agentLiability_id
IDX_E52FFDEED95C1FC6 Performance Asc clerk_id
invoicenumber_idx Performance Asc invoiceNumber
ordernumber_idx Performance Asc orderNumber
receiptnumber_idx Performance Asc receiptNumber
UNIQ_E52FFDEE53C674EE Must be unique Asc offer_id
UNIQ_E52FFDEEA560F403 Must be unique Asc invoiceUniqNumber
UNIQ_E52FFDEEC20EA752 Must be unique Asc uniqNumber

Relationships