ERP/3.0/Developers Guide/Database Model/org.openbravo.model.pricing.priceadjustment/M Offer

Contents 1 M_Offer 1.1 Columns 1.1.1 Active 1.1.2 Allweekdays 1.1.3 Apply to products up to the max quantity 1.1.4 Apply_Next 1.1.5 BP_Set_Selection 1.1.5.1 List values: Offers 1.1.6 Bpartner_Extref_Selection 1.1.6.1 List values: Offers 1.1.7 Characteristics_Excl_Selection 1.1.7.1 List values: Characteristics Offers 1.1.8 Client 1.1.9 Conforgprocess 1.1.10 Confprodcatprocess 1.1.11 Confprodprocess 1.1.12 Created By 1.1.13 Creation Date 1.1.14 Description 1.1.15 Discount % 1.1.16 Discount Amount 1.1.17 Discount Type 1.1.18 Ending Date 1.1.19 Endingtime 1.1.20 Endingtimefriday 1.1.21 Endingtimemonday 1.1.22 Endingtimesaturday 1.1.23 Endingtimesunday 1.1.24 Endingtimethursday 1.1.25 Endingtimetuesday 1.1.26 Endingtimewednesday 1.1.27 Fixed Price 1.1.28 Friday 1.1.29 Include Price Lists 1.1.29.1 List values: Offers 1.1.30 Included BP Categories 1.1.30.1 List values: Offers 1.1.31 Included Business Partners 1.1.31.1 List values: Offers 1.1.32 Included Characteristics 1.1.32.1 List values: Include Characteristics Offers 1.1.33 Included Organizations 1.1.33.1 List values: Offers 1.1.34 Included Product Categories 1.1.34.1 List values: Offers 1.1.35 Included Products 1.1.35.1 List values: Offers 1.1.36 Ismultiple 1.1.37 Max. Quantity 1.1.38 Min. Quantity 1.1.39 Monday 1.1.40 Multiple 1.1.41 Name 1.1.42 Organization 1.1.43 Price Adjustment 1.1.44 Print_Name 1.1.45 Priority 1.1.46 Priority Rule 1.1.46.1 List values: Price Adjustment Priority Rule 1.1.47 Saturday 1.1.48 Search Key 1.1.49 Starting Date 1.1.50 Startingtime 1.1.51 Startingtimefriday 1.1.52 Startingtimemonday 1.1.53 Startingtimesaturday 1.1.54 Startingtimesunday 1.1.55 Startingtimethursday 1.1.56 Startingtimetuesday 1.1.57 Startingtimewednesday 1.1.58 Sunday 1.1.59 Thursday 1.1.60 Tuesday 1.1.61 Updated 1.1.62 Updated By 1.1.63 Verify_Price_Limit 1.1.64 Wednesday 1.2 Other Info 1.2.1 Indices 1.2.2 Check Constraints

M_Offer

• Name:M_Offer
• Classname:PricingAdjustment

This table contains the following columns:

Name	Nullable	Data Type	Description
IsActive	No	CHAR (1)	There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: (1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
Allweekdays	Yes	CHAR (1)	Allows to apply the discount the whole week
Isuptomaxqty	No	CHAR (1)
Apply_Next	No	CHAR (1)	In case there are other Promotions and Discounts applicable to this same line with less priority than this one, this flag decides whether the next one should be applied or not.
BP_Set_Selection	No	VARCHAR (60)	Business Partner Set Selection Mode is the way Business Partners will be selected.
Bpartner_Extref_Selection	No	VARCHAR (60)	External Business Partner Reference Selection Mode is the way External Business Partner References will be selected.
Characteristics_Excl_Selection	No	VARCHAR (60)
AD_Client_ID	No	VARCHAR (32)	A Client is a company or a legal entity. You cannot share data between Clients.
Conforgprocess	Yes	CHAR (1)
Confprodcatprocess	Yes	CHAR (1)
Confprodprocess	Yes	CHAR (1)
Createdby	No	VARCHAR (32)	The Created By field indicates the user who created this record.
Created	No	TIMESTAMP (7)	The Created field indicates the date that this record was created.
Description	Yes	VARCHAR (255)	A description is limited to 255 characters.
Discount	No	DECIMAL	The Discount indicates the discount applied or taken as a percentage.
Addamt	No	DECIMAL	Fixed discount amount
M_Offer_Type_ID	No	VARCHAR (32)	Discounts and Promotions functionality allows to apply different rules to order/invoice lines to adjust pricing. A type is each of these kinds of rules.
DateTo	Yes	TIMESTAMP (7)	The Date To indicates the end date of a range (inclusive)
Endingtime	Yes	TIMESTAMP (7)
Endingtimefriday	Yes	TIMESTAMP (7)
Endingtimemonday	Yes	TIMESTAMP (7)
Endingtimesaturday	Yes	TIMESTAMP (7)
Endingtimesunday	Yes	TIMESTAMP (7)
Endingtimethursday	Yes	TIMESTAMP (7)
Endingtimetuesday	Yes	TIMESTAMP (7)
Endingtimewednesday	Yes	TIMESTAMP (7)
Fixed	Yes	DECIMAL	Fixed price for the promotion. When the promotion is applied, this is the final price the product will have.
Friday	Yes	CHAR (1)	Allows to apply the discount on Fridays
Pricelist_Selection	No	VARCHAR (60)	Defines the way Price Lists will be selected (including or excluding the taken ones)
BP_Group_Selection	No	VARCHAR (60)	Defines the way Business Partner Groups will be selected (including or excluding the taken ones)
BPartner_Selection	No	VARCHAR (60)	Business Partner Selection Mode is the way Business Partners will be selected.
Characteristics_Selection	No	VARCHAR (60)	Defines the way Product Characteristics will be selected (including or excluding the taken ones)
Org_Selection	No	VARCHAR (60)
Prod_Cat_Selection	No	VARCHAR (60)	Defines the way Product Categories will be selected (including or excluding the taken ones)
Product_Selection	No	VARCHAR (60)	Defines the way Products will be selected (including or excluding the taken ones)
Ismultiple	No	CHAR (1)	The discount will be applied only if the quantity ordered fits to the specified package quantity or a multiple.
Qty_To	Yes	DECIMAL	Quantity to is the maximum amount to apply the offer.
Qty_From	Yes	DECIMAL	Quantity From is the minimum amount that the offer will be applied from.
Monday	Yes	CHAR (1)	Allows to apply the discount on Monday
Multiple	Yes	DECIMAL	Units per package
Name	No	NVARCHAR (60)	A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
AD_Org_ID	No	VARCHAR (32)	An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
M_Offer_ID	No	VARCHAR (32)	Promotion or Discount applied to a particular line (product) automatically by the system.
Print_Name	Yes	VARCHAR (60)	Name that will be shown to final user in UI and reports to identify current promotion. In case it is empty, name will be used instead. In general, name should be used internally, whereas printed name is intended to be read by user.
Priority	Yes	DECIMAL	The Priority indicates the importance of this request.
Applicationpriorityrule	Yes	VARCHAR (60)	The Priority indicates the importance (high, medium, low) of this document
Saturday	Yes	CHAR (1)	Allows to apply the discount on Saturdays
Value	Yes	NVARCHAR (30)	A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order). Usually, company's internal identifiers for various records (products, customers, etc) are stored here.
DateFrom	No	TIMESTAMP (7)	The Date From indicates the starting date of a range.
Startingtime	Yes	TIMESTAMP (7)
Startingtimefriday	Yes	TIMESTAMP (7)
Startingtimemonday	Yes	TIMESTAMP (7)
Startingtimesaturday	Yes	TIMESTAMP (7)
Startingtimesunday	Yes	TIMESTAMP (7)
Startingtimethursday	Yes	TIMESTAMP (7)
Startingtimetuesday	Yes	TIMESTAMP (7)
Startingtimewednesday	Yes	TIMESTAMP (7)
Sunday	Yes	CHAR (1)	Allows to apply the discount on Sundays
Thursday	Yes	CHAR (1)	Allows to apply the discount on Thursdays
Tuesday	Yes	CHAR (1)	Allows to apply the discount on Tuesdays
Updated	No	TIMESTAMP (7)	The Updated field indicates the date that this record was updated.
Updatedby	No	VARCHAR (32)	The Updated By field indicates the user who updated this record.
Verify_Price_Limit	No	CHAR (1)
Wednesday	Yes	CHAR (1)	Allows to apply the discount on Wednesdays

Columns

Active

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo
• Default value: Y

top

Allweekdays

• Physical column name: Allweekdays
• Property Name: allweekdays
• Reference: YesNo
• Default value: Y

top

Apply to products up to the max quantity

• Physical column name: Isuptomaxqty
• Property Name: applyToProductsUpToTheMaxQuantity
• Reference: YesNo
• Default value: N

top

Apply_Next

• Physical column name: Apply_Next
• Property Name: applyNext
• Reference: YesNo
• Default value: Y

top

BP_Set_Selection

• Physical column name: BP_Set_Selection
• Property Name: setSelection
• Reference: List
• Default value: Y

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Bpartner_Extref_Selection

• Physical column name: Bpartner_Extref_Selection
• Property Name: bpartnerExtrefSelection
• Reference: List
• Default value: Y

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Characteristics_Excl_Selection

• Physical column name: Characteristics_Excl_Selection
• Property Name: characteristicsExclSelection
• Reference: List
• Default value: A

List values: Characteristics Offers

The allowed values for this list are:

• N (Any of the ones defined)
• A (All of the values defined)

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Conforgprocess

• Physical column name: Conforgprocess
• Property Name: conforgprocess
• Reference: Button
• Default value: N

top

Confprodcatprocess

• Physical column name: Confprodcatprocess
• Property Name: confprodcatprocess
• Reference: Button
• Default value: N

top

Confprodprocess

• Physical column name: Confprodprocess
• Property Name: confprodprocess
• Reference: Button
• Default value: N

top

Created By

• Physical column name: Createdby
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Creation Date

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

top

Description

• Physical column name: Description
• Property Name: description
• Reference: Text

top

Discount %

• Physical column name: Discount
• Property Name: discount
• Reference: Number
• Default value: 0

top

Discount Amount

• Physical column name: Addamt
• Property Name: discountAmount
• Reference: Price
• Default value: 0

top

Discount Type

• Physical column name: M_Offer_Type_ID
• Property Name: discountType
• Reference: TableDir
• Default value: 5D4BAF6BB86D4D2C9ED3D5A6FC051579

Foreign key column to M_Offer_Type table, (column: M_Offer_Type_ID)

top

Ending Date

• Physical column name: DateTo
• Property Name: endingDate
• Reference: Date

top

Endingtime

• Physical column name: Endingtime
• Property Name: endingtime
• Reference: Absolute Time

top

Endingtimefriday

• Physical column name: Endingtimefriday
• Property Name: endingtimefriday
• Reference: Absolute Time

top

Endingtimemonday

• Physical column name: Endingtimemonday
• Property Name: endingtimemonday
• Reference: Absolute Time

top

Endingtimesaturday

• Physical column name: Endingtimesaturday
• Property Name: endingtimesaturday
• Reference: Absolute Time

top

Endingtimesunday

• Physical column name: Endingtimesunday
• Property Name: endingtimesunday
• Reference: Absolute Time

top

Endingtimethursday

• Physical column name: Endingtimethursday
• Property Name: endingtimethursday
• Reference: Absolute Time

top

Endingtimetuesday

• Physical column name: Endingtimetuesday
• Property Name: endingtimetuesday
• Reference: Absolute Time

top

Endingtimewednesday

• Physical column name: Endingtimewednesday
• Property Name: endingtimewednesday
• Reference: Absolute Time

top

Fixed Price

• Physical column name: Fixed
• Property Name: fixedPrice
• Reference: Price

top

Friday

• Physical column name: Friday
• Property Name: friday
• Reference: YesNo
• Default value: N

top

Include Price Lists

• Physical column name: Pricelist_Selection
• Property Name: includePriceLists
• Reference: List
• Default value: Y

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Included BP Categories

• Physical column name: BP_Group_Selection
• Property Name: includedBPCategories
• Reference: List

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Included Business Partners

• Physical column name: BPartner_Selection
• Property Name: includedBusinessPartners
• Reference: List

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Included Characteristics

• Physical column name: Characteristics_Selection
• Property Name: includedCharacteristics
• Reference: List
• Default value: Y

List values: Include Characteristics Offers

The allowed values for this list are:

• A (All of the values defined)
• N (Any of the ones defined)
• Y (All Characteristics)

top

Included Organizations

• Physical column name: Org_Selection
• Property Name: includedOrganizations
• Reference: List
• Default value: Y

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Included Product Categories

• Physical column name: Prod_Cat_Selection
• Property Name: includedProductCategories
• Reference: List

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Included Products

• Physical column name: Product_Selection
• Property Name: includedProducts
• Reference: List

List values: Offers

The allowed values for this list are:

• N (Only those defined)
• Y (All excluding defined)

top

Ismultiple

• Physical column name: Ismultiple
• Property Name: ismultiple
• Reference: YesNo
• Default value: N

top

Max. Quantity

• Physical column name: Qty_To
• Property Name: maxQuantity
• Reference: Quantity

top

Min. Quantity

• Physical column name: Qty_From
• Property Name: minQuantity
• Reference: Quantity

top

Monday

• Physical column name: Monday
• Property Name: monday
• Reference: YesNo
• Default value: N

top

Multiple

• Physical column name: Multiple
• Property Name: multiple
• Reference: Quantity

top

Name

• Physical column name: Name
• Property Name: name
• Reference: String

• This column is part of the table's identifier

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Price Adjustment

• Physical column name: M_Offer_ID
• Property Name: id
• Reference: ID

top

Print_Name

• Physical column name: Print_Name
• Property Name: printName
• Reference: String

top

Priority

• Physical column name: Priority
• Property Name: priority
• Reference: Integer

top

Priority Rule

• Physical column name: Applicationpriorityrule
• Property Name: priorityRule
• Reference: List

List values: Price Adjustment Priority Rule

The allowed values for this list are:

• MOSTEXPENSIVE (Apply to highest price products)
• CHEAPEST (Apply to lowest price products)

top

Saturday

• Physical column name: Saturday
• Property Name: saturday
• Reference: YesNo
• Default value: N

top

Search Key

• Physical column name: Value
• Property Name: searchKey
• Reference: String

top

Starting Date

• Physical column name: DateFrom
• Property Name: startingDate
• Reference: Date

top

Startingtime

• Physical column name: Startingtime
• Property Name: startingtime
• Reference: Absolute Time

top

Startingtimefriday

• Physical column name: Startingtimefriday
• Property Name: startingtimefriday
• Reference: Absolute Time

top

Startingtimemonday

• Physical column name: Startingtimemonday
• Property Name: startingtimemonday
• Reference: Absolute Time

top

Startingtimesaturday

• Physical column name: Startingtimesaturday
• Property Name: startingtimesaturday
• Reference: Absolute Time

top

Startingtimesunday

• Physical column name: Startingtimesunday
• Property Name: startingtimesunday
• Reference: Absolute Time

top

Startingtimethursday

• Physical column name: Startingtimethursday
• Property Name: startingtimethursday
• Reference: Absolute Time

top

Startingtimetuesday

• Physical column name: Startingtimetuesday
• Property Name: startingtimetuesday
• Reference: Absolute Time

top

Startingtimewednesday

• Physical column name: Startingtimewednesday
• Property Name: startingtimewednesday
• Reference: Absolute Time

top

Sunday

• Physical column name: Sunday
• Property Name: sunday
• Reference: YesNo
• Default value: N

top

Thursday

• Physical column name: Thursday
• Property Name: thursday
• Reference: YesNo
• Default value: N

top

Tuesday

• Physical column name: Tuesday
• Property Name: tuesday
• Reference: YesNo
• Default value: N

top

Updated

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

• Physical column name: Updatedby
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Verify_Price_Limit

• Physical column name: Verify_Price_Limit
• Property Name: verifyPriceLimit
• Reference: YesNo
• Default value: Y

top

Wednesday

• Physical column name: Wednesday
• Property Name: wednesday
• Reference: YesNo
• Default value: N

top

Other Info

Indices

These are the indices for this table (for each index there is a list of all the columns included within it):

• M_OFFER_VALUE Not Unique. Columns:
  • VALUE

top

Check Constraints

These are the check constraints for this table:

• M_OFFER_ALL_WEEK_TIME_CHK: STARTINGTIME < ENDINGTIME
• M_OFFER_DATE_CHK: DATEFROM <= DATETO
• M_OFFER_FRIDAY_CHK: FRIDAY IN ('Y', 'N')
• M_OFFER_FRIDAY_TIME_CHK: STARTINGTIMEFRIDAY < ENDINGTIMEFRIDAY
• M_OFFER_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
• M_OFFER_MONDAY_CHK: MONDAY IN ('Y', 'N')
• M_OFFER_MONDAY_TIME_CHK: STARTINGTIMEMONDAY < ENDINGTIMEMONDAY
• M_OFFER_NEXT_CHECK: APPLY_NEXT IN ('Y', 'N')
• M_OFFER_ORG_CHK: CONFORGPROCESS IN ('Y', 'N')
• M_OFFER_ORG_PROD_CHK: CONFPRODPROCESS IN ('Y', 'N')
• M_OFFER_ORG_PRODCAT_CHK: CONFPRODCATPROCESS IN ('Y', 'N')
• M_OFFER_SATURDAY_CHK: SATURDAY IN ('Y', 'N')
• M_OFFER_SATURDAY_TIME_CHK: STARTINGTIMESATURDAY < ENDINGTIMESATURDAY
• M_OFFER_SUNDAY_CHK: SUNDAY IN ('Y', 'N')
• M_OFFER_SUNDAY_TIME_CHK: STARTINGTIMESUNDAY < ENDINGTIMESUNDAY
• M_OFFER_THURSDAY_CHK: THURSDAY IN ('Y', 'N')
• M_OFFER_THURSDAY_TIME_CHK: STARTINGTIMETHURSDAY < ENDINGTIMETHURSDAY
• M_OFFER_TUESDAY_CHK: TUESDAY IN ('Y', 'N')
• M_OFFER_TUESDAY_TIME_CHK: STARTINGTIMETUESDAY < ENDINGTIMETUESDAY
• M_OFFER_WEDNESDAY_CHK: WEDNESDAY IN ('Y', 'N')
• M_OFFER_WEDNESDAY_TIME_CHK: STARTINGTIMEWEDNESDAY < ENDINGTIMEWEDNESDAY
• M_OFFER_WHOLE_WEEK_CHK: ALLWEEKDAYS IN ('Y', 'N')

top

Categories: Database Entity Model | Generated Doc