SchemaSpy Analysis of idempiere9.adempiere - ColumnsProduct Price Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:54 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 464 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product_po discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_discountschema isbpartnerflatdiscount bpchar 1 'N'::bpchar Use flat discount defined on Business Partner Level
m_discountschemabreak isbpartnerflatdiscount bpchar 1 'N'::bpchar Use flat discount defined on Business Partner Level
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_product_category isdefault bpchar 1 'N'::bpchar Default value
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
m_promotionreward isforalldistribution bpchar 1 'N'::bpchar This reward is for all distribution
m_discountschemaline isignoreiscurrentvendor bpchar 1 'N'::bpchar take all PO prices into account
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner_product ismanufacturer bpchar 1 'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
m_promotionreward issamedistribution bpchar 1  √  'Y'::bpchar Use the same distribution for source and target
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_discountschema isactive bpchar 1 'Y'::bpchar The record is active in the system
m_discountschemabreak isactive bpchar 1 'Y'::bpchar The record is active in the system
m_discountschemaline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist_version isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productprice isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productpricevendorbreak isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotion isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotiondistribution isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotiongroup isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotiongroupline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotionline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotionprecondition isactive bpchar 1 'Y'::bpchar The record is active in the system
m_promotionreward isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar Use this Vendor for pricing and stock replenishment
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
m_promotionline ismandatorypl bpchar 1 'Y'::bpchar Order must have this promotion line
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_discountschema isquantitybased bpchar 1 'Y'::bpchar Trade discount break level based on Quantity (not value)
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
m_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
m_discountschemaline limit_fixed numeric 0  √  0 Fixed Limit Price (not calculated)
m_discountschemaline list_fixed numeric 0  √  0 Fixes List Price (not calculated)
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product_po order_min numeric 0  √  0 Minimum order quantity in UOM
m_product_po order_pack numeric 0  √  0 Package order size in UOM (e.g. order set of 5 units)
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
m_product_po pricelastinv numeric 0  √  0 Price of the last invoice for the product
m_product_po pricelastpo numeric 0  √  0 Price of the last purchase order for the product
m_product_po pricelist numeric 0  √  0 List Price
m_product_po pricepo numeric 0  √  0 Price based on a purchase order
m_promotionprecondition promotioncounter numeric 10  √  0 Usage counter
m_promotionprecondition promotionusagelimit numeric 10  √  0 Maximum usage limit
m_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
m_discountschemaline std_fixed numeric 0  √  0 Fixed Standard Price (not calculated)
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_discountschemaline limit_addamt numeric 0 0 Amount added to the converted/copied price before multiplying
m_discountschemaline limit_maxamt numeric 0 0 Maximum difference to original limit price; ignored if zero
m_discountschemaline limit_minamt numeric 0 0 Minimum difference to original limit price; ignored if zero
m_discountschemaline list_addamt numeric 0 0 List Price Surcharge Amount
m_discountschemaline list_maxamt numeric 0 0 Maximum margin for a product
m_discountschemaline list_minamt numeric 0 0 Minimum margin for a product
m_productprice pricelimit numeric 0 0 Lowest price for a product
m_productprice pricelist numeric 0 0 List Price
m_productprice pricestd numeric 0 0 Standard Price
m_promotion promotionpriority numeric 10 0 Which promotion should be apply to a product
m_promotiondistribution qty numeric 0 0 Quantity
m_promotionprecondition seqno numeric 10 0 Method of ordering records; lowest number comes first
m_discountschemaline std_addamt numeric 0 0 Amount added to a price as a surcharge
m_discountschemaline std_maxamt numeric 0 0 Maximum margin allowed for a product
m_discountschemaline std_minamt numeric 0 0 Minimum margin allowed for a product
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner_product created timestamp 29,6 now() Date this record was created
m_discountschema created timestamp 29,6 now() Date this record was created
m_discountschemabreak created timestamp 29,6 now() Date this record was created
m_discountschemaline created timestamp 29,6 now() Date this record was created
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist_version created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_category created timestamp 29,6 now() Date this record was created
m_product_po created timestamp 29,6 now() Date this record was created
m_productprice created timestamp 29,6 now() Date this record was created
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner_product updated timestamp 29,6 now() Date this record was updated
m_discountschema updated timestamp 29,6 now() Date this record was updated
m_discountschemabreak updated timestamp 29,6 now() Date this record was updated
m_discountschemaline updated timestamp 29,6 now() Date this record was updated
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist_version updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_category updated timestamp 29,6 now() Date this record was updated
m_product_po updated timestamp 29,6 now() Date this record was updated
m_productprice updated timestamp 29,6 now() Date this record was updated
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
m_promotionreward amount numeric 0  √  null Amount in a defined currency
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
m_promotionprecondition c_bp_group_id numeric 10  √  null Business Partner Group
m_discountschemaline c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_productpricevendorbreak c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_promotionprecondition c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_promotionreward c_charge_id numeric 10  √  null Additional document charges
m_product_po c_currency_id numeric 10  √  null The Currency for this record
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
m_product_po c_uom_id numeric 10  √  null Unit of Measure
m_discountschemaline classification varchar 12  √  null Classification for grouping
m_product classification varchar 12  √  null Classification for grouping
m_discountschema cumulativelevel bpchar 1  √  null Level for accumulative calculations
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
m_product_po deliverytime_actual numeric 10  √  null Actual days between order and delivery
m_product_po deliverytime_promised numeric 10  √  null Promised days between order and delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_bpartner description varchar 255  √  null Optional short description of the record
c_bpartner_product description varchar 255  √  null Optional short description of the record
m_discountschema description varchar 255  √  null Optional short description of the record
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist_version description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product_category description varchar 255  √  null Optional short description of the record
m_promotion description varchar 255  √  null Optional short description of the record
m_promotiongroup description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product_po discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
m_promotiondistribution distributionsorting bpchar 1  √  null Quantity distribution sorting by unit price
m_promotionreward distributionsorting bpchar 1  √  null Quantity distribution sorting by unit price
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_promotionprecondition enddate timestamp 29,6  √  null Last effective date (inclusive)
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
m_discountschema flatdiscount numeric 0  √  null Flat discount percentage
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
m_discountschemaline group1 varchar 255  √  null Group1
m_product group1 varchar 255  √  null Group1
m_discountschemaline group2 varchar 255  √  null Group2
m_product group2 varchar 255  √  null Group2
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
m_product istoformule bpchar 1  √  null
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_promotionprecondition m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_pricelist_version m_pricelist_version_base_id numeric 10  √  null Source for Price list calculations
m_discountschemabreak m_product_category_id numeric 10  √  null Category of a Product
m_discountschemaline m_product_category_id numeric 10  √  null Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
m_discountschemabreak m_product_id numeric 10  √  null Product, Service, Item
m_discountschemaline m_product_id numeric 10  √  null Product, Service, Item
m_promotionreward m_promotiondistribution_id numeric 10  √  null Promotion Distribution
m_promotionline m_promotiongroup_id numeric 10  √  null Promotion Group
m_promotionreward m_targetdistribution_id numeric 10  √  null Get product from target distribution to apply the promotion reward
m_promotionprecondition m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
c_bpartner_product manufacturer varchar 30  √  null Manufacturer of the Product
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
m_promotionline minimumamt numeric 0  √  null Minimum Amount in Document Currency
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner name2 varchar 60  √  null Additional Name
c_bpartner numberemployees numeric 10  √  null Number of employees
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
m_pricelist_version proccreate bpchar 1  √  null Create
m_discountschema processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_promotionprecondition promotioncode varchar 30  √  null User entered promotion code at sales time
m_promotionreward qty numeric 0  √  null Quantity
c_bpartner_product qualityrating numeric 0  √  null Method for rating vendors
m_product_po qualityrating numeric 0  √  null Method for rating vendors
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
m_discountschema script varchar 2000  √  null Dynamic Java Language Script to calculate result
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner taxid varchar 20  √  null Tax Identification
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product_po upc varchar 20  √  null Bar Code (Universal Product Code or its superset European Article Number)
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner_product vendorcategory varchar 30  √  null Product Category of the Business Partner
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
c_bpartner_product vendorproductno varchar 30  √  null Product Key of the Business Partner
m_product versionno varchar 20  √  null Version Number
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_product ad_client_id numeric 10 Client/Tenant for this installation.
m_discountschema ad_client_id numeric 10 Client/Tenant for this installation.
m_discountschemabreak ad_client_id numeric 10 Client/Tenant for this installation.
m_discountschemaline ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist_version ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
m_product_po ad_client_id numeric 10 Client/Tenant for this installation.
m_productprice ad_client_id numeric 10 Client/Tenant for this installation.
m_productpricevendorbreak ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner_product ad_org_id numeric 10 Organizational entity within client
m_discountschema ad_org_id numeric 10 Organizational entity within client
m_discountschemabreak ad_org_id numeric 10 Organizational entity within client
m_discountschemaline ad_org_id numeric 10 Organizational entity within client
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_pricelist_version ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_product_category ad_org_id numeric 10 Organizational entity within client
m_product_po ad_org_id numeric 10 Organizational entity within client
m_productprice ad_org_id numeric 10 Organizational entity within client
m_productpricevendorbreak ad_org_id numeric 10 Organizational entity within client
m_discountschemabreak breakdiscount numeric 0 Trade Discount in Percent for the break level
m_discountschemabreak breakvalue numeric 0 Low Value of trade discount break level
m_productpricevendorbreak breakvalue numeric 0 Low Value of trade discount break level
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_product c_bpartner_id numeric 10 Identifies a Business Partner
m_product_po c_bpartner_id numeric 10 Identifies a Business Partner
m_discountschemaline c_conversiontype_id numeric 10 Currency Conversion Rate Type
m_pricelist c_currency_id numeric 10 The Currency for this record
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_discountschemaline conversiondate timestamp 29,6 Date for selecting conversion rate
c_bpartner createdby numeric 10 User who created this records
c_bpartner_product createdby numeric 10 User who created this records
m_discountschema createdby numeric 10 User who created this records
m_discountschemabreak createdby numeric 10 User who created this records
m_discountschemaline createdby numeric 10 User who created this records
m_pricelist createdby numeric 10 User who created this records
m_pricelist_version createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_category createdby numeric 10 User who created this records
m_product_po createdby numeric 10 User who created this records
m_productprice createdby numeric 10 User who created this records
m_productpricevendorbreak createdby numeric 10 User who created this records
m_promotion createdby numeric 10 User who created this records
m_promotiondistribution createdby numeric 10 User who created this records
m_promotiongroup createdby numeric 10 User who created this records
m_promotiongroupline createdby numeric 10 User who created this records
m_promotionline createdby numeric 10 User who created this records
m_promotionprecondition createdby numeric 10 User who created this records
m_promotionreward createdby numeric 10 User who created this records
m_discountschema discounttype bpchar 1 Type of trade discount calculation
m_promotiondistribution distributiontype bpchar 1 Type of quantity distribution calculation using comparison qty and order qty as operand
m_discountschemaline limit_base bpchar 1 Base price for calculation of the new price
m_discountschemaline limit_discount numeric 0 Discount in percent to be subtracted from base, if negative it will be added to base price
m_discountschemaline limit_rounding bpchar 1 Rounding of the final result
m_discountschemaline list_base bpchar 1 Price used as the basis for price list calculations
m_discountschemaline list_discount numeric 0 Discount from list price as a percentage
m_discountschemaline list_rounding bpchar 1 Rounding rule for final list price
m_discountschema m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_discountschemabreak m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_discountschemaline m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_pricelist_version m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
m_discountschemabreak m_discountschemabreak_id numeric 10 Trade Discount Break
m_discountschemaline m_discountschemaline_id numeric 10 Line of the pricelist trade discount schema
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productprice m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_productpricevendorbreak m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_product m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_id numeric 10 Category of a Product
c_bpartner_product m_product_id numeric 10 Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_product_po m_product_id numeric 10 Product, Service, Item
m_productprice m_product_id numeric 10 Product, Service, Item
m_productpricevendorbreak m_product_id numeric 10 Product, Service, Item
m_promotiongroupline m_product_id numeric 10 Product, Service, Item
m_productpricevendorbreak m_productpricevendorbreak_id numeric 10 Product Price Break
m_promotion m_promotion_id numeric 10 Promotion
m_promotiondistribution m_promotion_id numeric 10 Promotion
m_promotionline m_promotion_id numeric 10 Promotion
m_promotionprecondition m_promotion_id numeric 10 Promotion
m_promotionreward m_promotion_id numeric 10 Promotion
m_promotiondistribution m_promotiondistribution_id numeric 10 Promotion Distribution
m_promotiongroup m_promotiongroup_id numeric 10 Promotion Group
m_promotiongroupline m_promotiongroup_id numeric 10 Promotion Group
m_promotiongroupline m_promotiongroupline_id numeric 10 Promotion Group Line
m_promotiondistribution m_promotionline_id numeric 10 Promotion Line
m_promotionline m_promotionline_id numeric 10 Promotion Line
m_promotionprecondition m_promotionprecondition_id numeric 10 Promotion Pre Condition
m_promotionreward m_promotionreward_id numeric 10 Promotion Reward
c_bpartner name varchar 120 Alphanumeric identifier of the entity
m_discountschema name varchar 60 Alphanumeric identifier of the entity
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist_version name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
m_product_category name varchar 60 Alphanumeric identifier of the entity
m_promotion name varchar 60 Alphanumeric identifier of the entity
m_promotiongroup name varchar 60 Alphanumeric identifier of the entity
m_promotiondistribution operation varchar 2 Compare Operation
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
m_productpricevendorbreak pricelimit numeric 0 Lowest price for a product
m_productpricevendorbreak pricelist numeric 0 List Price
m_productpricevendorbreak pricestd numeric 0 Standard Price
m_promotionreward rewardtype bpchar 1 Type of reward which consists of percentage discount, flat discount or absolute amount
m_discountschemabreak seqno numeric 10 Method of ordering records; lowest number comes first
m_discountschemaline seqno numeric 10 Method of ordering records; lowest number comes first
c_bpartner_product shelflifemindays numeric 10 Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner_product shelflifeminpct numeric 10 Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_promotionprecondition startdate timestamp 29,6 First effective day (inclusive)
m_discountschemaline std_base bpchar 1 Base price for calculating new standard price
m_discountschemaline std_discount numeric 0 Discount percentage to subtract from base price
m_discountschemaline std_rounding bpchar 1 Rounding rule for calculated price
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner_product updatedby numeric 10 User who updated this records
m_discountschema updatedby numeric 10 User who updated this records
m_discountschemabreak updatedby numeric 10 User who updated this records
m_discountschemaline updatedby numeric 10 User who updated this records
m_pricelist updatedby numeric 10 User who updated this records
m_pricelist_version updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_category updatedby numeric 10 User who updated this records
m_product_po updatedby numeric 10 User who updated this records
m_productprice updatedby numeric 10 User who updated this records
m_productpricevendorbreak updatedby numeric 10 User who updated this records
m_promotion updatedby numeric 10 User who updated this records
m_promotiondistribution updatedby numeric 10 User who updated this records
m_promotiongroup updatedby numeric 10 User who updated this records
m_promotiongroupline updatedby numeric 10 User who updated this records
m_promotionline updatedby numeric 10 User who updated this records
m_promotionprecondition updatedby numeric 10 User who updated this records
m_promotionreward updatedby numeric 10 User who updated this records
m_discountschema validfrom timestamp 29,6 Valid from including this date (first day)
m_pricelist_version validfrom timestamp 29,6 Valid from including this date (first day)
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product_category value varchar 40 Search key for the record in the format required - must be unique
m_product_po vendorproductno varchar 40 Product Key of the Business Partner
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_bpartner_product c_bpartner_product_uu varchar 36  √  NULL::character varying C_BPartner_Product_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
m_discountschemaline description varchar 255  √  NULL::character varying Optional short description of the record
m_discountschema m_discountschema_uu varchar 36  √  NULL::character varying M_DiscountSchema_UU
m_discountschemabreak m_discountschemabreak_uu varchar 36  √  NULL::character varying M_DiscountSchemaBreak_UU
m_discountschemaline m_discountschemaline_uu varchar 36  √  NULL::character varying M_DiscountSchemaLine_UU
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying M_PriceList_Version_UU
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
m_product_po m_product_po_uu varchar 36  √  NULL::character varying M_Product_PO_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_productprice m_productprice_uu varchar 36  √  NULL::character varying M_ProductPrice_UU
m_productpricevendorbreak m_productpricevendorbreak_uu varchar 36  √  NULL::character varying M_ProductPriceVendorBreak_UU
m_promotion m_promotion_uu varchar 36  √  NULL::character varying M_Promotion_UU
m_promotiondistribution m_promotiondistribution_uu varchar 36  √  NULL::character varying M_PromotionDistribution_UU
m_promotiongroup m_promotiongroup_uu varchar 36  √  NULL::character varying M_PromotionGroup_UU
m_promotiongroupline m_promotiongroupline_uu varchar 36  √  NULL::character varying M_PromotionGroupLine_UU
m_promotionline m_promotionline_uu varchar 36  √  NULL::character varying M_PromotionLine_UU
m_promotionprecondition m_promotionprecondition_uu varchar 36  √  NULL::character varying M_PromotionPreCondition_UU
m_promotionreward m_promotionreward_uu varchar 36  √  NULL::character varying M_PromotionReward_UU
m_discountschemaline vendorcategory varchar 30  √  NULL::character varying Product Category of the Business Partner
m_promotionprecondition c_activity_id numeric 10  √  NULL::numeric Business Activity
m_promotion c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_promotion ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotiondistribution ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotiongroup ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotiongroupline ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotionline ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotionprecondition ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotionreward ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
m_promotion ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotiondistribution ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotiongroup ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotiongroupline ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotionline ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotionprecondition ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_promotionreward ad_org_id numeric 10 NULL::numeric Organizational entity within client
m_productprice m_productprice_id numeric 10 NULL::numeric Intersection between a Product and a Price List Version
m_promotiondistribution seqno numeric 10 NULL::numeric Method of ordering records; lowest number comes first
m_promotionreward seqno numeric 10 NULL::numeric Method of ordering records; lowest number comes first
m_productpricevendorbreak created timestamp 29,6 statement_timestamp() Date this record was created
m_promotion created timestamp 29,6 statement_timestamp() Date this record was created
m_promotiondistribution created timestamp 29,6 statement_timestamp() Date this record was created
m_promotiongroup created timestamp 29,6 statement_timestamp() Date this record was created
m_promotiongroupline created timestamp 29,6 statement_timestamp() Date this record was created
m_promotionline created timestamp 29,6 statement_timestamp() Date this record was created
m_promotionprecondition created timestamp 29,6 statement_timestamp() Date this record was created
m_promotionreward created timestamp 29,6 statement_timestamp() Date this record was created
m_productpricevendorbreak updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotion updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotiondistribution updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotiongroup updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotiongroupline updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotionline updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotionprecondition updated timestamp 29,6 statement_timestamp() Date this record was updated
m_promotionreward updated timestamp 29,6 statement_timestamp() Date this record was updated