VendorOrderItem

Aggrosoft\WAWIBundle\Entity\VendorOrderItem

Columns

Relations

Properties

Relationships

Click entity to navigate

→ EntityStatus → VendorOrder ↔ OfferItem ← VendorOrderItemDelivery ← VendorOrderItemMaterial ← VendorOrderItemAvailability → Product → MaterialPickList → WarehouseStorageLocation ← VendorOrderItemMetaField

erDiagram
    VendorOrderItem {
                string id PK
                integer sort
                decimal quantity
                decimal deliveredQuantity
                datetime created
                text ean
                        ___ ___more___
            }
                VendorOrderItem }o--|| EntityStatus : "status"
        EntityStatus {
        int id PK
    }
                VendorOrderItem }o--|| VendorOrder : "order"
        VendorOrder {
        int id PK
    }
                VendorOrderItem ||--|| OfferItem : "offerItem"
        OfferItem {
        int id PK
    }
                VendorOrderItem ||--o{ VendorOrderItemDelivery : "deliveries"
        VendorOrderItemDelivery {
        int id PK
    }
                VendorOrderItem ||--o{ VendorOrderItemMaterial : "materials"
        VendorOrderItemMaterial {
        int id PK
    }
                VendorOrderItem ||--o{ VendorOrderItemAvailability : "availabilities"
        VendorOrderItemAvailability {
        int id PK
    }
                VendorOrderItem }o--|| Product : "product"
        Product {
        int id PK
    }
                VendorOrderItem }o--|| MaterialPickList : "pickList"
        MaterialPickList {
        int id PK
    }
                VendorOrderItem }o--|| WarehouseStorageLocation : "location"
        WarehouseStorageLocation {
        int id PK
    }
                VendorOrderItem ||--o{ VendorOrderItemMetaField : "metafields"
        VendorOrderItemMetaField {
        int id PK
    }

Metadaten

Tabelle vendororderitem

Bundle WAWIBundle

Interfaces

IMetaExtendable IPrototype ICloneTimeTrackable IChildEntity

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`quantity`	`quantity`	`decimal`		{{ entity.quantity }}
`deliveredQuantity`	`deliveredQuantity`	`decimal`		{{ entity.deliveredQuantity }}
`created`	`created`	`datetime`		{{ entity.created }}
`ean`	`ean`	`text(255)`		{{ entity.ean }}
`bestBeforeDate`	`bestBeforeDate`	`date`		{{ entity.bestBeforeDate }}
`serialNumber`	`serialNumber`	`string(36)`		{{ entity.serialNumber }}
`vendorSku`	`vendorSku`	`text(255)`		{{ entity.vendorSku }}
`productTitle`	`productTitle`	`text`		{{ entity.productTitle }}
`variantTitle`	`variantTitle`	`text`		{{ entity.variantTitle }}
`productParameter`	`productParameter`	`text`		{{ entity.productParameter }}
`productOption`	`productOption`	`text`		{{ entity.productOption }}
`info`	`info`	`string(255)`		{{ entity.info }}
`foreignStatus`	`foreignStatus`	`text`		{{ entity.foreignStatus }}
`documentCategoryText`	`documentCategoryText`	`text`		{{ entity.documentCategoryText }}
`price`	`price`	`decimal`		{{ entity.price }}
`vat`	`vat`	`decimal`		{{ entity.vat }}
`note`	`note`	`text`		{{ entity.note }}
`note2`	`note2`	`text`		{{ entity.note2 }}
`excludedMaterialProducts`	`excludedMaterialProducts`	`text`		{{ entity.excludedMaterialProducts }}
`pickDate`	`pickDate`	`datetime`		{{ entity.pickDate }}
`producedDate`	`producedDate`	`datetime`		{{ entity.producedDate }}
`availableFrom`	`availableFrom`	`date`		{{ entity.availableFrom }}
`cloneDate`	`cloneDate`	`datetime`		{{ entity.cloneDate }}
`discount`	`discount`	`decimal`		{{ entity.discount }}
`discountPercent`	`discountPercent`	`decimal`		{{ entity.discountPercent }}
`discountNote`	`discountNote`	`string(255)`		{{ entity.discountNote }}

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

Property	Access	Twig Usage	Methods	Return Type
`fromVendorProduct` Computed	write		`setFromVendorProduct()`	-
`fromOrderItem` Computed	write		`setFromOrderItem()`	-
`fromOfferItem` Computed	write		`setFromOfferItem()`	-
`sum` Computed	read	{{ entity.sum }}	`getSum()`	-
`nettoSum` Computed	read	{{ entity.nettoSum }}	`getNettoSum()`	-
`nettoPrice` Computed	read	{{ entity.nettoPrice }}	`getNettoPrice()`	-
`bruttoPrice` Computed	read	{{ entity.bruttoPrice }}	`getBruttoPrice()`	-
`taxValue` Computed	read	{{ entity.taxValue }}	`getTaxValue()`	-
`pricingItem` Computed	read	{{ entity.pricingItem }}	`getPricingItem()`	-
`unitName` Computed	read	{{ entity.unitName }}	`getUnitName()`	-
`unitQuantity` Computed	read	{{ entity.unitQuantity }}	`getUnitQuantity()`	-
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`quantity` DB	read write	{{ entity.quantity }}	`getQuantity()` `setQuantity()`	`float`
`sku` Computed	read write	{{ entity.sku }}	`getSku()` `setSku()`	`string`
`vendorSku` DB	read write	{{ entity.vendorSku }}	`getVendorSku()` `setVendorSku()`	`string`
`productTitle` DB	read write	{{ entity.productTitle }}	`getProductTitle()` `setProductTitle()`	`string`
`variantTitle` DB	read write	{{ entity.variantTitle }}	`getVariantTitle()` `setVariantTitle()`	`string`
`productParameter` DB	read write	{{ entity.productParameter }}	`getProductParameter()` `setProductParameter()`	`string`
`productOption` DB	read write	{{ entity.productOption }}	`getProductOption()` `setProductOption()`	`string`
`vendorProductTitle` Computed	read write	{{ entity.vendorProductTitle }}	`getVendorProductTitle()` `setVendorProductTitle()`	`string`
`price` DB	read write	{{ entity.price }}	`getPrice()` `setPrice()`	`float`
`vat` DB	read write	{{ entity.vat }}	`getVat()` `setVat()`	`float`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`order` DB	read write	{{ entity.order }}	`getOrder()` `setOrder()`	`\Aggrosoft\WAWIBundle\Entity\VendorOrder`
`offerItem` DB	read write	{{ entity.offerItem }}	`getOfferItem()` `setOfferItem()`	`Aggrosoft\WAWIBundle\Entity\OfferItem`
`product` DB	read write	{{ entity.product }}	`getProduct()` `setProduct()`	`\Aggrosoft\WAWIBundle\Entity\Product`
`ean` DB	read write	{{ entity.ean }}	`getEan()` `setEan()`	`string`
`deliveries` DB	read	{{ entity.deliveries }}	`getDeliveries()`	`\Doctrine\Common\Collections\Collection`
`deliveredQuantity` DB	read write	{{ entity.deliveredQuantity }}	`getDeliveredQuantity()` `setDeliveredQuantity()`	`float`
`bestBeforeDate` DB	read write	{{ entity.bestBeforeDate }}	`getBestBeforeDate()` `setBestBeforeDate()`	`\DateTime`
`info` DB	read write	{{ entity.info }}	`getInfo()` `setInfo()`	`string`
`documentCategoryText` DB	read write	{{ entity.documentCategoryText }}	`getDocumentCategoryText()` `setDocumentCategoryText()`	`string`
`serialNumber` DB	read write	{{ entity.serialNumber }}	`getSerialNumber()` `setSerialNumber()`	`string`
`pickList` DB	read write	{{ entity.pickList }}	`getPickList()` `setPickList()`	`\Aggrosoft\WAWIBundle\Entity\MaterialPickList`
`pickDate` DB	read write	{{ entity.pickDate }}	`getPickDate()` `setPickDate()`	`\DateTime`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`status` DB	read write	{{ entity.status }}	`getStatus()` `setStatus()`	`\Aggrosoft\WAWIBundle\Entity\EntityStatus`
`delivered` Computed	read	{{ entity.delivered }}	`isDelivered()`	-
`producedDate` DB	read write	{{ entity.producedDate }}	`getProducedDate()` `setProducedDate()`	`\DateTime`
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`\Doctrine\Common\Collections\Collection`
`note2` DB	read write	{{ entity.note2 }}	`getNote2()` `setNote2()`	`string`
`availableFrom` DB	read write	{{ entity.availableFrom }}	`getAvailableFrom()` `setAvailableFrom()`	`\DateTime`
`cloneDate` DB	read write	{{ entity.cloneDate }}	`getCloneDate()` `setCloneDate()`	`\DateTime`
`pendingQuantity` Computed	read	{{ entity.pendingQuantity }}	`getPendingQuantity()`	-
`parentEntityForForms` Computed	read	{{ entity.parentEntityForForms }}	`getParentEntityForForms()`	-
`foreignStatus` DB	read write	{{ entity.foreignStatus }}	`getForeignStatus()` `setForeignStatus()`	`string`
`materials` DB	read	{{ entity.materials }}	`getMaterials()`	`\Doctrine\Common\Collections\Collection`
`allMaterials` Computed	read	{{ entity.allMaterials }}	`getAllMaterials()`	-
`excludedMaterialProducts` DB	read write	{{ entity.excludedMaterialProducts }}	`getExcludedMaterialProducts()` `setExcludedMaterialProducts()`	`string`
`discount` DB	read write	{{ entity.discount }}	`getDiscount()` `setDiscount()`	`string`
`discountPercent` DB	read write	{{ entity.discountPercent }}	`getDiscountPercent()` `setDiscountPercent()`	`string`
`discountNote` DB	read write	{{ entity.discountNote }}	`getDiscountNote()` `setDiscountNote()`	`string`
`basePrice` Computed	read write	{{ entity.basePrice }}	`getBasePrice()` `setBasePrice()`	-
`location` DB	read write	{{ entity.location }}	`getLocation()` `setLocation()`	`\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation`
`availabilities` DB	read	{{ entity.availabilities }}	`getAvailabilities()`	`\Doctrine\Common\Collections\Collection`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`status`	ManyToOne	EntityStatus	-	-	-	{{ entity.status }}
`order`	ManyToOne	VendorOrder	-	`items`	-	{{ entity.order }}
`offerItem`	OneToOne	OfferItem	`vendorOrderItem`	-	-	{{ entity.offerItem }}
`deliveries`	OneToMany	VendorOrderItemDelivery	`orderItem`	-	`persist` `remove` `refresh`	{{ entity.deliveries }}
`materials`	OneToMany	VendorOrderItemMaterial	`orderItem`	-	`persist` `remove` `refresh`	{{ entity.materials }}
`availabilities`	OneToMany	VendorOrderItemAvailability	`orderItem`	-	`persist` `remove` `refresh`	{{ entity.availabilities }}
`product`	ManyToOne	Product	-	-	-	{{ entity.product }}
`pickList`	ManyToOne	MaterialPickList	-	`vendorOrderItems`	-	{{ entity.pickList }}
`location`	ManyToOne	WarehouseStorageLocation	-	-	-	{{ entity.location }}
`metafields`	OneToMany	VendorOrderItemMetaField	`vendorOrderItem`	-	`persist` `remove`	{{ entity.metafields }}

Keine Indexes definiert