B2Bsellers Suite
API Referenceswww.b2b-sellers.comPublic demoshopRoadmap
Beta < 0.9.X
Beta < 0.9.X
  • Home
  • Products & Configuration
    • Plans & Plugin Concept
    • Demoshops
    • B2Bseller Suite - CORE Plugin
      • CORE-Plugin Configuration
      • B2B Flow/Business Events
      • B2B Rules
      • B2B Body Classes
      • B2bContextTrait
      • B2bPlatformContext
      • Registration process
      • UseCustomer URL Parameter
      • How to add „Menü Item“ on B2BPlattform
      • EmployeePermissionTrait
      • Express checkout setup
    • B2Bseller Suite - purchasable Addons
      • Offer Function for Sales Agents
      • Spare Parts Shop
      • Subscription Article
      • Copper and brass product surcharges
      • Rating groups
      • B2B Platform Theme
      • E-Procurement (OCI,EDI,Ariba, Punchout)
      • Register Requests
      • Order lists
      • Bonus program
      • Product Request
      • URL Authentication
      • Cost centers
      • Training or e-learning - event articles with attendee registration
    • B2Bsellers Suite - Connectors
      • Import Customers and Employees from an external REST-API OR CSV
      • Import Orders from an external REST-API (ERP)
      • Import Customer Prices from an external REST-API
      • POST Register Request to an external REST-API
    • Third Party Extensions
      • Parent products in the listing
  • Guides
    • Setup
      • Installation
      • Requirements
      • Dockware Setup (Docker)
      • Use Test-Customers
      • Cronjobs
      • CLI-Commands
      • How to start the b2b-platform vue.js watcher
    • Developer Onboarding
      • Development Helpers
    • Own Extensions
      • Concept of Extensions
      • How to develop your own extensions
      • How to extend the b2b platform
      • Example Plugins
    • Migration
    • Tips for Deployment / Continuous Integration
    • Performance
    • Guides for ERP-Interface
      • Overview - Full integrated ERP-Systems
      • Integration of ERP orders to Shopware 6
      • Integration Customers and Employees from ERP
  • Ressources
    • Usable Components
      • Vue.js - B2B Platform
      • Storefront
    • E-Mail Templates
    • FAQs
    • Support
  • API-References
    • Database Schema
    • Store-API
      • Account Request
      • Customer Activity
      • Customer Activity Type
      • Customer Last Orders
      • Customer List
      • Customer Price
      • Customer Sales Ranking
      • Customer Search
      • Delivery Interval
      • Delete Product Subscription
      • Document
      • Employee
      • Employee Permission
      • Employee Role
      • Employee Order
      • Event Product
      • Login Target List
      • Offer Document
      • Offer
      • Offer Mail
      • Offer Order
      • Offer Status
      • Ordered Products
      • Payment Condition
      • Platform Cms
      • Product List
      • Product Table Listing
      • Product Subscription
      • Product Subscription List
      • Sales Statistic
      • Snippet
    • Entities
      • Custom Fields for existing Shopware Entities
      • Budget
      • BudgetEmployee
      • CollectionAccount
      • CustomerPrice
      • Employee
        • EmployeeCustomer
        • EmployeePermission
        • EmployeeRole
      • CustomerActivity
        • CustomerActivityType
      • Offer
        • OfferAddress
        • OfferCustomer
        • OfferItem
        • OfferStatus
      • ProductSubscription
      • ProductSubscriptionOrder
      • PasswordlessLogin
      • PaymentCondition
      • ProductExplodedView
      • B2bProductList
        • B2bProductListItem
        • B2bProductListType
      • RegisterRequest
        • RegisterRequestStatus
        • RegisterRequestActivity
      • SalesRepresentativeCustomer
    • Admin API
      • Order Import Endpoint
  • Release Notes
    • B2BsellersCore
      • Version v0.9.6
      • Version v0.9.5
      • Version v0.9.4
      • Version v0.9.3
      • Version v0.9.2
      • Version v0.9.1
    • B2BOffer (Archived)
      • Version v0.9.1
Powered by GitBook
On this page
  • Table columns
  • Associations

Was this helpful?

  1. API-References
  2. Entities

Offer

Last updated 2 years ago

Was this helpful?

Table-name: b2b_offer

Plugin

Table columns

Field
Class
Type
Is required

id

IdField

binary

true

statusId

FkField

binary

true

offerCustomerId

FkField

binary

true

employeeId

FkField

binary

true

number

StringField

varchar

false

deliveryDate

DateTimeFid

Datetime

false

documentDate

DateTimeField

Datetime

false

validUntil

DateTimeField

Datetimte

false

matchcode

StringField

varchar

false

commission

Stringfield

varchar

false

process

StringField

varchar

false

editorId

FkField

binary

false

billingAddressId

FkField

binary

true

deliveryAddressId

FkField

binary

true

salesChannelId

FkField

binary

true

currencyId

FkField

binary

true

price

CartPriceField

json

false

optionalPrice

CartPriceField

json

false

shippingCosts

CalculatedPriceField

json

false

shippingMethodId

FkField

binary

true

deepLinkId

StringField

varchar

false

headerText

LongTextField

text

false

footerText

LongtextField

text

false

file

StringField

varchar

false

customFields

CustomFields

json

false

mailTo

Stringfield

varchar

false

mailCc

Stringfield

varchar

false

updatedAt

UpdatedAtField

Datetime

false

createdAt

CreatedAtField

Datetime

true

Associations

Field
Entity
Class

status

OfferStatusEntity

ManyToOneAssociationField

offerCustomer

OfferCustomerEntity

OneToOneAssociationField

employee

EmployeeEntity

ManyToOneAssociationField

editor

CustomerEntity

ManyToOneAssociationField

billingAddress

OfferAddressEntity

OneToOneAssociationField

deliveryAddress

OfferAddressEntity

OneToOneAssociationField

salesChannel

SalesChannelEntity

ManyToOneAssociationField

currency

CurrencyEntity

ManyToOneAssociationField

paymentCondition

PaymentConditionEntity

ManyToOneAssociationField

items

OfferItemEntity

OneToOneAssociationField

shippingMethod

ShippingMethodEntity

ManyToOneAssociationField

paymentMethod

PaymentMethodEntity

ManyToOneAssociationField

Offer Function for Sales Agents