B2Bsellers Suite
API Referenceswww.b2b-sellers.comPublic demoshopRoadmap
v1.X.X (Shopware 6.4)
v1.X.X (Shopware 6.4)
  • Home
  • Product Tour
    • Plans & Plugin Concept
    • Public Demoshops
    • Get a personal B2B demo store?
  • User Guide
    • Installation & Setup
      • Installation
      • Requirements
      • Easy activate all Addons and Features
      • Use Test-Customers
      • License Settings
    • Configuration
      • License, purchaseable Addons and Features configuration
      • Configuration of the CORE
        • Express checkout setup
      • How to add „Menü Item“ on B2BPlattform
      • E-Mail Templates
      • B2B Rules
      • B2B Flow/Business Events
      • Customer specific prices
      • Registration process
      • PDP variant list
    • Configuration of 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-Punchout)
      • E-Procurement (cXML Purchase Order / Ariba)
      • Register Requests (wip)
      • Order lists
      • Bonus program
      • Product Request
      • URL Authentication
      • Cost centers
      • Discount Rate
      • Mobile sales portal (app)
      • Customer-specific assortments
      • Eventmanager (Beta)
      • Employee budgets
      • Order entry for Sales representatives (Beta)
    • Third Party Extensions
      • You want to provide a plugin?
    • Performance
    • FAQs
    • Support
  • Developer Guides
    • First Steps
      • Getting Started
      • Concept of Extensions
      • Dockware Setup (Docker)
      • How to start the b2b-platform vue.js watcher
      • How to build the b2b-platform (vue.js)
      • Protection of the Store-API
      • How to develop your first extensions
      • CLI-Commands
        • Migration of existing Shopware Customers
      • Cronjobs
      • Development Helpers
      • Example Plugins
    • Smart developer helpers
      • B2bPlatformContext
      • B2bContextTrait
      • EmployeePermissionTrait
      • B2B Body Classes
      • UseCustomer URL Parameter
      • Useful Vue.js Components for the B2B Platform
      • Useful Storefront Shopping World Elements
      • How to import external orders and offers?
    • How to's
      • Using B2Bsellers Suite with Shopware frontends
    • Guides for ERP-Interface
      • Overview - Full integrated ERP-Systems
      • Integration of ERP orders to Shopware 6
      • Integration Customers and Employees from ERP
    • Tips for Deployment / Continuous Integration
    • Typical errors
  • API-References
    • Database Schema
    • 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
    • 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
    • Admin API
      • General Admin-API Info
      • Order Import Endpoint
      • Order Extension
  • Release Notes
    • B2BsellersCore
      • Version v1.1.4 - security update
      • Version v1.1.3
      • Version v1.1.2
      • Version v1.1.1
      • Version v1.1.0
      • Version v1.0.4
      • Version v1.0.3
      • Version v1.0.2
      • Version v1.0.1 - Hotfix
      • Version v1.0.0
      • Version v0.9.6
      • Version v0.9.5
      • Version v0.9.4
      • Version v0.9.3
      • Version v0.9.2
      • Version v0.9.1
Powered by GitBook
On this page
  • Table columns
  • Associations

Was this helpful?

Edit on GitHub
  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