VendorOrder

Aggrosoft\WAWIBundle\Entity\VendorOrder
66
Columns
23
Relations
125
Properties

Relationships

Click entity to navigate
erDiagram
    VendorOrder {
                string id PK
                datetime created
                datetime updated
                float updatedInForm
                string updateToken
                integer orderNumber
                        ___ ___more___
            }
                VendorOrder }o--|| Vendor : "vendor"
        Vendor {
        int id PK
    }
                VendorOrder }o--|| Warehouse : "warehouse"
        Warehouse {
        int id PK
    }
                VendorOrder }o--o{ Warehouse : "materialWarehouses"
        Warehouse {
        int id PK
    }
                VendorOrder }o--|| EntityStatus : "orderStatus"
        EntityStatus {
        int id PK
    }
                VendorOrder }o--|| Country : "vendorCountry"
        Country {
        int id PK
    }
                VendorOrder }o--|| Country : "billingCountry"
        Country {
        int id PK
    }
                VendorOrder }o--|| State : "billingState"
        State {
        int id PK
    }
                VendorOrder }o--|| Country : "shippingCountry"
        Country {
        int id PK
    }
                VendorOrder }o--|| State : "shippingState"
        State {
        int id PK
    }
                VendorOrder }o--|| User : "clerk"
        User {
        int id PK
    }
                VendorOrder ||--o{ VendorOrderItem : "items"
        VendorOrderItem {
        int id PK
    }
                VendorOrder ||--o{ VendorOrderPackage : "packages"
        VendorOrderPackage {
        int id PK
    }
                VendorOrder ||--o{ VendorOrderDelivery : "deliveries"
        VendorOrderDelivery {
        int id PK
    }
                VendorOrder ||--o{ Liability : "liabilities"
        Liability {
        int id PK
    }
                VendorOrder }o--|| OrderBuyingList : "orderBuyingList"
        OrderBuyingList {
        int id PK
    }
                VendorOrder }o--|| Order : "internalOrder"
        Order {
        int id PK
    }
                VendorOrder }o--o{ Liability : "commonLiabilities"
        Liability {
        int id PK
    }
                VendorOrder ||--o{ VendorOrderUpload : "uploads"
        VendorOrderUpload {
        int id PK
    }
                VendorOrder }o--|| Client : "client"
        Client {
        int id PK
    }
                VendorOrder }o--|| Shipping : "shipping"
        Shipping {
        int id PK
    }
                VendorOrder }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }
                VendorOrder }o--o{ Report : "reports"
        Report {
        int id PK
    }
                VendorOrder ||--o{ VendorOrderMetaField : "metafields"
        VendorOrderMetaField {
        int id PK
    }
                    

Metadaten

Tabelle vendororder
Bundle WAWIBundle
Interfaces
IClientable IPricingItemContainer IHasLanguage IGroupable IReportable IPrototype IMetaExtendable
Property Column Type Flags Twig Access
id id string(36)
PK AUTO
{{ entity.id }}
created created datetime
{{ entity.created }}
updated updated datetime
{{ entity.updated }}
updatedInForm updatedInForm float
{{ entity.updatedInForm }}
updateToken updateToken string(36)
{{ entity.updateToken }}
orderNumber orderNumber integer(11)
{{ entity.orderNumber }}
foreignOrderNumber foreignOrderNumber string(128)
{{ entity.foreignOrderNumber }}
foreignId foreignId string(128)
{{ entity.foreignId }}
total total decimal
{{ entity.total }}
totalnetto totalnetto decimal
{{ entity.totalnetto }}
status status string(50)
{{ entity.status }}
orderType orderType integer(11)
{{ entity.orderType }}
vendorEMail vendorEMail string(255)
{{ entity.vendorEMail }}
vendorCompany vendorCompany string(255)
{{ entity.vendorCompany }}
vendorStreet vendorStreet string(255)
{{ entity.vendorStreet }}
vendorCity vendorCity string(200)
{{ entity.vendorCity }}
vendorZip vendorZip string(16)
{{ entity.vendorZip }}
vendorPhone vendorPhone string(128)
{{ entity.vendorPhone }}
vendorFax vendorFax string(128)
{{ entity.vendorFax }}
vendorGlnNumber vendorGlnNumber string(128)
{{ entity.vendorGlnNumber }}
vendorContact vendorContact string(128)
{{ entity.vendorContact }}
billingEMail billingEMail string(255)
{{ entity.billingEMail }}
billingSalutation billingSalutation string(255)
{{ entity.billingSalutation }}
billingCompany billingCompany string(255)
{{ entity.billingCompany }}
billingFirstName billingFirstName string(255)
{{ entity.billingFirstName }}
billingLastName billingLastName string(255)
{{ entity.billingLastName }}
billingStreet billingStreet string(255)
{{ entity.billingStreet }}
billingVatId billingVatId string(50)
{{ entity.billingVatId }}
billingCity billingCity string(200)
{{ entity.billingCity }}
billingZip billingZip string(16)
{{ entity.billingZip }}
billingPhone billingPhone string(128)
{{ entity.billingPhone }}
billingFax billingFax string(128)
{{ entity.billingFax }}
billingGlnNumber billingGlnNumber string(128)
{{ entity.billingGlnNumber }}
shippingSalutation shippingSalutation string(255)
{{ entity.shippingSalutation }}
shippingCompany shippingCompany string(255)
{{ entity.shippingCompany }}
shippingFirstName shippingFirstName string(255)
{{ entity.shippingFirstName }}
shippingLastName shippingLastName string(255)
{{ entity.shippingLastName }}
shippingStreet shippingStreet string(255)
{{ entity.shippingStreet }}
shippingCity shippingCity string(200)
{{ entity.shippingCity }}
shippingZip shippingZip string(16)
{{ entity.shippingZip }}
shippingPhone shippingPhone string(128)
{{ entity.shippingPhone }}
shippingFax shippingFax string(128)
{{ entity.shippingFax }}
shippingGlnNumber shippingGlnNumber string(128)
{{ entity.shippingGlnNumber }}
shippingEMail shippingEMail string(128)
{{ entity.shippingEMail }}
currency currency string(32)
{{ entity.currency }}
note note text
{{ entity.note }}
quantity quantity integer(11)
{{ entity.quantity }}
deliveredQuantity deliveredQuantity integer(11)
{{ entity.deliveredQuantity }}
cachedDeliveredPercent cachedDeliveredPercent decimal
{{ entity.cachedDeliveredPercent }}
creditorInvoiceBooked creditorInvoiceBooked boolean
{{ entity.creditorInvoiceBooked }}
printDate printDate date
{{ entity.printDate }}
mailDate mailDate date
{{ entity.mailDate }}
faxDate faxDate date
{{ entity.faxDate }}
remindDate remindDate date
{{ entity.remindDate }}
exportDate exportDate datetime
{{ entity.exportDate }}
shippingDate shippingDate datetime
{{ entity.shippingDate }}
estimatedShippingDate estimatedShippingDate datetime
{{ entity.estimatedShippingDate }}
trackingCode trackingCode text
{{ entity.trackingCode }}
trackingUrl trackingUrl text
{{ entity.trackingUrl }}
proformaInvoiceNumber proformaInvoiceNumber string(255)
{{ entity.proformaInvoiceNumber }}
proformaInvoiceDate proformaInvoiceDate date
{{ entity.proformaInvoiceDate }}
paymentTerm paymentTerm integer(2)
{{ entity.paymentTerm }}
discountTime discountTime integer(2)
{{ entity.discountTime }}
discountPercent discountPercent decimal
{{ entity.discountPercent }}
deliveryCost deliveryCost decimal
{{ entity.deliveryCost }}
discount discount decimal
{{ entity.discount }}

Tipp: Diese Properties sind über Getter/Setter-Methoden in Twig verfügbar. Verwende {{ entity.propertyName }} zum Lesen.

Property Access Twig Usage Methods Return Type
shippingStreetParts Computed
read
{{ entity.shippingStreetParts }}
getShippingStreetParts()
-
billingAddressFromClient Computed
write

setBillingAddressFromClient()
-
vendorInfoFromVendor Computed
write

setVendorInfoFromVendor()
-
shippingAddressFromWarehouse Computed
write

setShippingAddressFromWarehouse()
-
shippingAddressFromOrder Computed
write

setShippingAddressFromOrder()
-
shippingAddress Computed
read
{{ entity.shippingAddress }}
hasShippingAddress()
-
deliveredPercent Computed
read
{{ entity.deliveredPercent }}
getDeliveredPercent()
-
delivered Computed
read
{{ entity.delivered }}
isDelivered()
-
sum Computed
read
{{ entity.sum }}
getSum()
-
nettoSum Computed
read
{{ entity.nettoSum }}
getNettoSum()
-
vatSum Computed
read
{{ entity.vatSum }}
getVatSum()
-
pricingItemsWithoutGrouping Computed
read
{{ entity.pricingItemsWithoutGrouping }}
getPricingItemsWithoutGrouping()
-
pricingItemsWithOrderSorting Computed
read
{{ entity.pricingItemsWithOrderSorting }}
getPricingItemsWithOrderSorting()
-
pricingItems Computed
read
{{ entity.pricingItems }}
getPricingItems()
-
pricingItemsSplittedOndemand Computed
read
{{ entity.pricingItemsSplittedOndemand }}
getPricingItemsSplittedOndemand()
-
pricingTotals Computed
read
{{ entity.pricingTotals }}
getPricingTotals()
-
client DB
read write
{{ entity.client }}
getClient()
setClient()
\Aggrosoft\WAWIBundle\Entity\Client
id DB
read
{{ entity.id }}
getId()
string
foreignId DB
read write
{{ entity.foreignId }}
getForeignId()
setForeignId()
string
created DB
read write
{{ entity.created }}
getCreated()
setCreated()
\DateTime
updated DB
read write
{{ entity.updated }}
getUpdated()
setUpdated()
\DateTime
orderNumber DB
read write
{{ entity.orderNumber }}
getOrderNumber()
setOrderNumber()
integer
total DB
read write
{{ entity.total }}
getTotal()
setTotal()
float
status DB
read write
{{ entity.status }}
getStatus()
setStatus()
string
billingEMail DB
read write
{{ entity.billingEMail }}
getBillingEMail()
setBillingEMail()
string
billingSalutation DB
read write
{{ entity.billingSalutation }}
getBillingSalutation()
setBillingSalutation()
string
billingCompany DB
read write
{{ entity.billingCompany }}
getBillingCompany()
setBillingCompany()
string
billingFirstName DB
read write
{{ entity.billingFirstName }}
getBillingFirstName()
setBillingFirstName()
string
billingLastName DB
read write
{{ entity.billingLastName }}
getBillingLastName()
setBillingLastName()
string
billingStreet DB
read write
{{ entity.billingStreet }}
getBillingStreet()
setBillingStreet()
string
billingVatId DB
read write
{{ entity.billingVatId }}
getBillingVatId()
setBillingVatId()
string
billingCity DB
read write
{{ entity.billingCity }}
getBillingCity()
setBillingCity()
string
billingZip DB
read write
{{ entity.billingZip }}
getBillingZip()
setBillingZip()
string
billingPhone DB
read write
{{ entity.billingPhone }}
getBillingPhone()
setBillingPhone()
string
billingFax DB
read write
{{ entity.billingFax }}
getBillingFax()
setBillingFax()
string
shippingSalutation DB
read write
{{ entity.shippingSalutation }}
getShippingSalutation()
setShippingSalutation()
string
shippingCompany DB
read write
{{ entity.shippingCompany }}
getShippingCompany()
setShippingCompany()
string
shippingFirstName DB
read write
{{ entity.shippingFirstName }}
getShippingFirstName()
setShippingFirstName()
string
shippingLastName DB
read write
{{ entity.shippingLastName }}
getShippingLastName()
setShippingLastName()
string
shippingStreet DB
read write
{{ entity.shippingStreet }}
getShippingStreet()
setShippingStreet()
string
shippingCity DB
read write
{{ entity.shippingCity }}
getShippingCity()
setShippingCity()
string
shippingZip DB
read write
{{ entity.shippingZip }}
getShippingZip()
setShippingZip()
string
shippingPhone DB
read write
{{ entity.shippingPhone }}
getShippingPhone()
setShippingPhone()
string
shippingFax DB
read write
{{ entity.shippingFax }}
getShippingFax()
setShippingFax()
string
currency DB
read write
{{ entity.currency }}
getCurrency()
setCurrency()
string
note DB
read write
{{ entity.note }}
getNote()
setNote()
string
printDate DB
read write
{{ entity.printDate }}
getPrintDate()
setPrintDate()
\DateTime
mailDate DB
read write
{{ entity.mailDate }}
getMailDate()
setMailDate()
\DateTime
faxDate DB
read write
{{ entity.faxDate }}
getFaxDate()
setFaxDate()
\DateTime
remindDate DB
read write
{{ entity.remindDate }}
getRemindDate()
setRemindDate()
\DateTime
vendor DB
read write
{{ entity.vendor }}
getVendor()
setVendor()
\Aggrosoft\WAWIBundle\Entity\Vendor
warehouse DB
read write
{{ entity.warehouse }}
getWarehouse()
setWarehouse()
\Aggrosoft\WAWIBundle\Entity\Warehouse
billingCountry DB
read write
{{ entity.billingCountry }}
getBillingCountry()
setBillingCountry()
\Aggrosoft\WAWIBundle\Entity\Country
billingState DB
read write
{{ entity.billingState }}
getBillingState()
setBillingState()
\Aggrosoft\WAWIBundle\Entity\State
shippingCountry DB
read write
{{ entity.shippingCountry }}
getShippingCountry()
setShippingCountry()
\Aggrosoft\WAWIBundle\Entity\Country
shippingState DB
read write
{{ entity.shippingState }}
getShippingState()
setShippingState()
\Aggrosoft\WAWIBundle\Entity\State
items DB
read
{{ entity.items }}
getItems()
\Doctrine\Common\Collections\Collection
vendorEMail DB
read write
{{ entity.vendorEMail }}
getVendorEMail()
setVendorEMail()
string
vendorCompany DB
read write
{{ entity.vendorCompany }}
getVendorCompany()
setVendorCompany()
string
vendorStreet DB
read write
{{ entity.vendorStreet }}
getVendorStreet()
setVendorStreet()
string
vendorCity DB
read write
{{ entity.vendorCity }}
getVendorCity()
setVendorCity()
string
vendorZip DB
read write
{{ entity.vendorZip }}
getVendorZip()
setVendorZip()
string
vendorPhone DB
read write
{{ entity.vendorPhone }}
getVendorPhone()
setVendorPhone()
string
vendorFax DB
read write
{{ entity.vendorFax }}
getVendorFax()
setVendorFax()
string
vendorContact DB
read write
{{ entity.vendorContact }}
getVendorContact()
setVendorContact()
string
vendorCountry DB
read write
{{ entity.vendorCountry }}
getVendorCountry()
setVendorCountry()
\Aggrosoft\WAWIBundle\Entity\Country
deliveries DB
read
{{ entity.deliveries }}
getDeliveries()
\Doctrine\Common\Collections\Collection
quantity DB
read write
{{ entity.quantity }}
getQuantity()
setQuantity()
integer
deliveredQuantity DB
read write
{{ entity.deliveredQuantity }}
getDeliveredQuantity()
setDeliveredQuantity()
integer
minimalDeliveredQuantity Computed
read
{{ entity.minimalDeliveredQuantity }}
getMinimalDeliveredQuantity()
-
liabilities DB
read
{{ entity.liabilities }}
getLiabilities()
\Doctrine\Common\Collections\Collection
language Computed
read
{{ entity.language }}
getLanguage()
-
selectedLanguage Computed
read write
{{ entity.selectedLanguage }}
getSelectedLanguage()
setSelectedLanguage()
-
translatableLocale Computed
write

setTranslatableLocale()
-
groups DB
read
{{ entity.groups }}
getGroups()
\Doctrine\Common\Collections\Collection
reports DB
read
{{ entity.reports }}
getReports()
\Doctrine\Common\Collections\Collection
commonLiabilities DB
read
{{ entity.commonLiabilities }}
getCommonLiabilities()
\Doctrine\Common\Collections\Collection
allLiabilities Computed
read
{{ entity.allLiabilities }}
getAllLiabilities()
-
ondemandItems Computed
read
{{ entity.ondemandItems }}
getOndemandItems()
-
orderedOndemandItems Computed
read
{{ entity.orderedOndemandItems }}
getOrderedOndemandItems()
-
orderWeight Computed
read
{{ entity.orderWeight }}
getOrderWeight()
-
totalQuantity Computed
read
{{ entity.totalQuantity }}
getTotalQuantity()
-
cachedDeliveredPercent DB
read write
{{ entity.cachedDeliveredPercent }}
getCachedDeliveredPercent()
setCachedDeliveredPercent()
string
orderBuyingList DB
read write
{{ entity.orderBuyingList }}
getOrderBuyingList()
setOrderBuyingList()
\Aggrosoft\WAWIBundle\Entity\OrderBuyingList
updatedInForm DB
read write
{{ entity.updatedInForm }}
getUpdatedInForm()
setUpdatedInForm()
float
updateToken DB
read write
{{ entity.updateToken }}
getUpdateToken()
setUpdateToken()
string
internalOrder DB
read write
{{ entity.internalOrder }}
getInternalOrder()
setInternalOrder()
\Aggrosoft\WAWIBundle\Entity\Order
internalVendorOrder Computed
read
{{ entity.internalVendorOrder }}
isInternalVendorOrder()
-
orderType DB
read write
{{ entity.orderType }}
getOrderType()
setOrderType()
integer
totalnetto DB
read write
{{ entity.totalnetto }}
getTotalnetto()
setTotalnetto()
string
proformaInvoiceNumber DB
read write
{{ entity.proformaInvoiceNumber }}
getProformaInvoiceNumber()
setProformaInvoiceNumber()
string
proformaInvoiceDate DB
read write
{{ entity.proformaInvoiceDate }}
getProformaInvoiceDate()
setProformaInvoiceDate()
\DateTime
deliveryCost DB
read write
{{ entity.deliveryCost }}
getDeliveryCost()
setDeliveryCost()
string
creditorInvoiceBooked DB
read write
{{ entity.creditorInvoiceBooked }}
getCreditorInvoiceBooked()
setCreditorInvoiceBooked()
boolean
clerk DB
read write
{{ entity.clerk }}
getClerk()
setClerk()
\Aggrosoft\WAWIBundle\Entity\User
uploads DB
read
{{ entity.uploads }}
getUploads()
\Doctrine\Common\Collections\Collection
paymentTerm DB
read write
{{ entity.paymentTerm }}
getPaymentTerm()
setPaymentTerm()
integer
discountTime DB
read write
{{ entity.discountTime }}
getDiscountTime()
setDiscountTime()
integer
discountPercent DB
read write
{{ entity.discountPercent }}
getDiscountPercent()
setDiscountPercent()
string
productionOrder Computed
read
{{ entity.productionOrder }}
isProductionOrder()
-
materialPickLists Computed
read
{{ entity.materialPickLists }}
getMaterialPickLists()
-
materialPickList Computed
read
{{ entity.materialPickList }}
getMaterialPickList()
-
totalDeliveredQuantity Computed
read
{{ entity.totalDeliveredQuantity }}
getTotalDeliveredQuantity()
-
exportDate DB
read write
{{ entity.exportDate }}
getExportDate()
setExportDate()
\DateTime
dropshippingItems Computed
read
{{ entity.dropshippingItems }}
getDropshippingItems()
-
dropshippingOrder Computed
read
{{ entity.dropshippingOrder }}
getDropshippingOrder()
-
shipping DB
read write
{{ entity.shipping }}
getShipping()
setShipping()
\Aggrosoft\WAWIBundle\Entity\Shipping
foreignOrderNumber DB
read write
{{ entity.foreignOrderNumber }}
getForeignOrderNumber()
setForeignOrderNumber()
string
vendorGlnNumber DB
read write
{{ entity.vendorGlnNumber }}
getVendorGlnNumber()
setVendorGlnNumber()
string
billingGlnNumber DB
read write
{{ entity.billingGlnNumber }}
getBillingGlnNumber()
setBillingGlnNumber()
string
shippingGlnNumber DB
read write
{{ entity.shippingGlnNumber }}
getShippingGlnNumber()
setShippingGlnNumber()
string
metafields DB
read
{{ entity.metafields }}
getMetafields()
\Doctrine\Common\Collections\Collection
maxTaxRate Computed
read
{{ entity.maxTaxRate }}
getMaxTaxRate()
-
deliveryNettoCostForCalc Computed
read write
{{ entity.deliveryNettoCostForCalc }}
getDeliveryNettoCostForCalc()
setDeliveryNettoCostForCalc()
-
shippingEMail DB
read write
{{ entity.shippingEMail }}
getShippingEMail()
setShippingEMail()
string
orderStatus DB
read write
{{ entity.orderStatus }}
getOrderStatus()
setOrderStatus()
\Aggrosoft\WAWIBundle\Entity\EntityStatus
notDeliveredItems Computed
read
{{ entity.notDeliveredItems }}
getNotDeliveredItems()
-
shippingDate DB
read write
{{ entity.shippingDate }}
getShippingDate()
setShippingDate()
\DateTime
trackingCode DB
read write
{{ entity.trackingCode }}
getTrackingCode()
setTrackingCode()
string
trackingUrl DB
read write
{{ entity.trackingUrl }}
getTrackingUrl()
setTrackingUrl()
string
packages DB
read
{{ entity.packages }}
getPackages()
\Doctrine\Common\Collections\Collection
materialWarehouses DB
read
{{ entity.materialWarehouses }}
getMaterialWarehouses()
\Doctrine\Common\Collections\Collection
discount DB
read write
{{ entity.discount }}
getDiscount()
setDiscount()
string
discountPercentForCalc Computed
read write
{{ entity.discountPercentForCalc }}
getDiscountPercentForCalc()
setDiscountPercentForCalc()
-
estimatedShippingDate DB
read write
{{ entity.estimatedShippingDate }}
getEstimatedShippingDate()
setEstimatedShippingDate()
\DateTime
Property Type Target Entity Mapped By Inversed By Cascade Twig Access
vendor ManyToOne Vendor - - - {{ entity.vendor }}
warehouse ManyToOne Warehouse - - - {{ entity.warehouse }}
materialWarehouses ManyToMany Warehouse - vendorOrdersForMaterial - {{ entity.materialWarehouses }}
orderStatus ManyToOne EntityStatus - - - {{ entity.orderStatus }}
vendorCountry ManyToOne Country - - - {{ entity.vendorCountry }}
billingCountry ManyToOne Country - - - {{ entity.billingCountry }}
billingState ManyToOne State - - - {{ entity.billingState }}
shippingCountry ManyToOne Country - - - {{ entity.shippingCountry }}
shippingState ManyToOne State - - - {{ entity.shippingState }}
clerk ManyToOne User - vendororders - {{ entity.clerk }}
items OneToMany VendorOrderItem order -
persist remove refresh
{{ entity.items }}
packages OneToMany VendorOrderPackage order - - {{ entity.packages }}
deliveries OneToMany VendorOrderDelivery order - - {{ entity.deliveries }}
liabilities OneToMany Liability vendorOrder - - {{ entity.liabilities }}
orderBuyingList ManyToOne OrderBuyingList - - - {{ entity.orderBuyingList }}
internalOrder ManyToOne Order - - - {{ entity.internalOrder }}
commonLiabilities ManyToMany Liability vendorOrders - - {{ entity.commonLiabilities }}
uploads OneToMany VendorOrderUpload vendorOrder -
persist remove
{{ entity.uploads }}
client ManyToOne Client - - - {{ entity.client }}
shipping ManyToOne Shipping - - - {{ entity.shipping }}
groups ManyToMany ObjectGroup - vendororders - {{ entity.groups }}
reports ManyToMany Report - vendororders
persist
{{ entity.reports }}
metafields OneToMany VendorOrderMetaField vendorOrder -
persist remove
{{ entity.metafields }}
Keine Indexes definiert