Offer

Table-name: b2b_offer

Plugin

pageOffer Function for Sales Agents

Table columns

FieldClassTypeIs 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

FieldEntityClass

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