ERP/3.0/Developers Guide/Database Model/org.openbravo.model.pricing.priceadjustment/M Offer
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
Allweekdays
- Physical column name: Allweekdays
- Property Name: allweekdays
- Reference: YesNo
- Default value: Y
Apply to products up to the max quantity
- Physical column name: Isuptomaxqty
- Property Name: applyToProductsUpToTheMaxQuantity
- Reference: YesNo
- Default value: N
Apply_Next
- Physical column name: Apply_Next
- Property Name: applyNext
- Reference: YesNo
- Default value: Y
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)
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)
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:
- A (All of the values defined)
- N (Any of the ones defined)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Conforgprocess
- Physical column name: Conforgprocess
- Property Name: conforgprocess
- Reference: Button
- Default value: N
Confprodcatprocess
- Physical column name: Confprodcatprocess
- Property Name: confprodcatprocess
- Reference: Button
- Default value: N
Confprodprocess
- Physical column name: Confprodprocess
- Property Name: confprodprocess
- Reference: Button
- Default value: N
Created By
- Physical column name: Createdby
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Description
- Physical column name: Description
- Property Name: description
- Reference: Text
Discount %
- Physical column name: Discount
- Property Name: discount
- Reference: Number
- Default value: 0
Discount Amount
- Physical column name: Addamt
- Property Name: discountAmount
- Reference: Price
- Default value: 0
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)
Ending Date
- Physical column name: DateTo
- Property Name: endingDate
- Reference: Date
Endingtime
- Physical column name: Endingtime
- Property Name: endingtime
- Reference: Absolute Time
Endingtimefriday
- Physical column name: Endingtimefriday
- Property Name: endingtimefriday
- Reference: Absolute Time
Endingtimemonday
- Physical column name: Endingtimemonday
- Property Name: endingtimemonday
- Reference: Absolute Time
Endingtimesaturday
- Physical column name: Endingtimesaturday
- Property Name: endingtimesaturday
- Reference: Absolute Time
Endingtimesunday
- Physical column name: Endingtimesunday
- Property Name: endingtimesunday
- Reference: Absolute Time
Endingtimethursday
- Physical column name: Endingtimethursday
- Property Name: endingtimethursday
- Reference: Absolute Time
Endingtimetuesday
- Physical column name: Endingtimetuesday
- Property Name: endingtimetuesday
- Reference: Absolute Time
Endingtimewednesday
- Physical column name: Endingtimewednesday
- Property Name: endingtimewednesday
- Reference: Absolute Time
Fixed Price
- Physical column name: Fixed
- Property Name: fixedPrice
- Reference: Price
Friday
- Physical column name: Friday
- Property Name: friday
- Reference: YesNo
- Default value: N
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)
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)
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)
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:
- N (Any of the ones defined)
- Y (All Characteristics)
- A (All of the values defined)
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)
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)
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)
Ismultiple
- Physical column name: Ismultiple
- Property Name: ismultiple
- Reference: YesNo
- Default value: N
Max. Quantity
- Physical column name: Qty_To
- Property Name: maxQuantity
- Reference: Quantity
Min. Quantity
- Physical column name: Qty_From
- Property Name: minQuantity
- Reference: Quantity
Monday
- Physical column name: Monday
- Property Name: monday
- Reference: YesNo
- Default value: N
Multiple
- Physical column name: Multiple
- Property Name: multiple
- Reference: Quantity
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Price Adjustment
- Physical column name: M_Offer_ID
- Property Name: id
- Reference: ID
Print_Name
- Physical column name: Print_Name
- Property Name: printName
- Reference: String
Priority
- Physical column name: Priority
- Property Name: priority
- Reference: Integer
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)
Saturday
- Physical column name: Saturday
- Property Name: saturday
- Reference: YesNo
- Default value: N
Search Key
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Starting Date
- Physical column name: DateFrom
- Property Name: startingDate
- Reference: Date
Startingtime
- Physical column name: Startingtime
- Property Name: startingtime
- Reference: Absolute Time
Startingtimefriday
- Physical column name: Startingtimefriday
- Property Name: startingtimefriday
- Reference: Absolute Time
Startingtimemonday
- Physical column name: Startingtimemonday
- Property Name: startingtimemonday
- Reference: Absolute Time
Startingtimesaturday
- Physical column name: Startingtimesaturday
- Property Name: startingtimesaturday
- Reference: Absolute Time
Startingtimesunday
- Physical column name: Startingtimesunday
- Property Name: startingtimesunday
- Reference: Absolute Time
Startingtimethursday
- Physical column name: Startingtimethursday
- Property Name: startingtimethursday
- Reference: Absolute Time
Startingtimetuesday
- Physical column name: Startingtimetuesday
- Property Name: startingtimetuesday
- Reference: Absolute Time
Startingtimewednesday
- Physical column name: Startingtimewednesday
- Property Name: startingtimewednesday
- Reference: Absolute Time
Sunday
- Physical column name: Sunday
- Property Name: sunday
- Reference: YesNo
- Default value: N
Thursday
- Physical column name: Thursday
- Property Name: thursday
- Reference: YesNo
- Default value: N
Tuesday
- Physical column name: Tuesday
- Property Name: tuesday
- Reference: YesNo
- Default value: N
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Verify_Price_Limit
- Physical column name: Verify_Price_Limit
- Property Name: verifyPriceLimit
- Reference: YesNo
- Default value: Y
Wednesday
- Physical column name: Wednesday
- Property Name: wednesday
- Reference: YesNo
- Default value: N
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
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')