SchemaSpy Analysis of idempiere11.adempiere - ColumnsProduct Price | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:54 +0100 |
| |||||
|
idempiere11.adempiere contains 465 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
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_promotionreward | amount | numeric | 0 | √ | null | Amount in a defined currency | |
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 | |||
m_product_po | costperorder | numeric | 0 | √ | 0 | Fixed Cost Per Order | |
m_discountschemabreak | fixedprice | numeric | 0 | √ | 0 | Fixed Price for Product | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
m_discountschema | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
m_discountschemaline | limit_addamt | numeric | 0 | 0 | Amount added to the converted/copied price before multiplying | ||
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_fixed | numeric | 0 | √ | 0 | Fixed Limit Price (not calculated) | |
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_discount | numeric | 0 | Discount from list price as a percentage | |||
m_discountschemaline | list_fixed | numeric | 0 | √ | 0 | Fixes List Price (not calculated) | |
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_promotionline | minimumamt | numeric | 0 | √ | null | Minimum Amount in Document Currency | |
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) | |
m_product_category | plannedmargin | numeric | 0 | Project's planned margin as a percentage | |||
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_productprice | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
m_productpricevendorbreak | pricelimit | numeric | 0 | Lowest price for a product | |||
m_product_po | pricelist | numeric | 0 | √ | 0 | List Price | |
m_productprice | pricelist | numeric | 0 | 0 | List Price | ||
m_productpricevendorbreak | pricelist | numeric | 0 | List Price | |||
m_product_po | pricepo | numeric | 0 | √ | 0 | Price based on a purchase order | |
m_productprice | pricestd | numeric | 0 | 0 | Standard Price | ||
m_productpricevendorbreak | pricestd | numeric | 0 | Standard Price | |||
m_promotiondistribution | qty | numeric | 0 | 0 | Quantity | ||
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_po | royaltyamt | numeric | 0 | √ | 0 | (Included) Amount for copyright, etc. | |
m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
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_addamt | numeric | 0 | 0 | Amount added to a price as a surcharge | ||
m_discountschemaline | std_discount | numeric | 0 | Discount percentage to subtract from base price | |||
m_discountschemaline | std_fixed | numeric | 0 | √ | 0 | Fixed Standard Price (not calculated) | |
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 | ||
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 | volume | numeric | 0 | √ | 0 | Volume of a product | |
m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
m_discountschema | cumulativelevel | bpchar | 1 | √ | null | Level for accumulative calculations | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
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_discountschema | discounttype | bpchar | 1 | Type of trade discount calculation | |||
m_promotiondistribution | distributionsorting | bpchar | 1 | √ | null | Quantity distribution sorting by unit price | |
m_promotionreward | distributionsorting | bpchar | 1 | √ | null | Quantity distribution sorting by unit price | |
m_promotiondistribution | distributiontype | bpchar | 1 | Type of quantity distribution calculation using comparison qty and order qty as operand | |||
m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | Do not allow prices below the limit price | ||
c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
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 | 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_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_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
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_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | Data entry is required in this column | |
m_promotionline | ismandatorypl | bpchar | 1 | 'Y'::bpchar | Order must have this promotion line | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
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 | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
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 | ||
m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | Is Present For Product | |
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
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) | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
m_promotionreward | issamedistribution | bpchar | 1 | √ | 'Y'::bpchar | Use the same distribution for source and target | |
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 | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
m_product | istoformule | bpchar | 1 | √ | null | ||
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 | ||
m_discountschemaline | limit_base | bpchar | 1 | Base price for calculation of the new 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_rounding | bpchar | 1 | Rounding rule for final list price | |||
m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
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_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
m_promotionreward | rewardtype | bpchar | 1 | Type of reward which consists of percentage discount, flat discount or absolute amount | |||
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
m_discountschemaline | std_base | bpchar | 1 | Base price for calculating new standard price | |||
m_discountschemaline | std_rounding | bpchar | 1 | Rounding rule for calculated price | |||
m_promotiondistribution | operation | varchar | 2 | Compare Operation | |||
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
m_product_category | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_discountschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_discountschemabreak | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_discountschemaline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_pricelist | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_pricelist_version | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_category | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_po | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_productprice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_productpricevendorbreak | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_promotion | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotiondistribution | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotiongroup | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotiongroupline | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotionline | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotionprecondition | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
m_promotionreward | ad_client_id | numeric | 10 | NULL::numeric | Tenant for this installation. | ||
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_discountschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_discountschemabreak | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_discountschemaline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_pricelist | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_pricelist_version | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_category | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_po | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_productprice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_productpricevendorbreak | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_promotion | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotiondistribution | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotiongroup | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotiongroupline | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotionline | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotionprecondition | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
m_promotionreward | ad_org_id | numeric | 10 | NULL::numeric | Organizational entity within tenant | ||
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_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_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
m_promotionprecondition | c_bp_group_id | numeric | 10 | √ | null | 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_discountschemaline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
m_product_po | c_bpartner_id | numeric | 10 | 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_promotion | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
m_promotionreward | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
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_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 | |
m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
m_product_po | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
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 | |||
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
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 | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
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 | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
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 | ||
m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
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 price list trade discount schema | |||
m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
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_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_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_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 | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product_category | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | Parent Product Category | |
c_bpartner_product | m_product_id | numeric | 10 | Product, Service, Item | |||
m_discountschemabreak | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_discountschemaline | m_product_id | numeric | 10 | √ | null | 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_productprice | m_productprice_id | numeric | 10 | NULL::numeric | Intersection between a Product and a Price List Version | ||
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_promotionreward | m_promotiondistribution_id | numeric | 10 | √ | null | Promotion Distribution | |
m_promotiongroup | m_promotiongroup_id | numeric | 10 | Promotion Group | |||
m_promotiongroupline | m_promotiongroup_id | numeric | 10 | Promotion Group | |||
m_promotionline | m_promotiongroup_id | numeric | 10 | √ | null | 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 | |||
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 | numberemployees | numeric | 10 | √ | null | Number of employees | |
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 | |
m_pricelist | priceprecision | numeric | 10 | 2 | Precision (number of decimals) for the Price | ||
m_promotionprecondition | promotioncounter | numeric | 10 | √ | 0 | Usage counter | |
m_promotion | promotionpriority | numeric | 10 | 0 | Which promotion should be apply to a product | ||
m_promotionprecondition | promotionusagelimit | numeric | 10 | √ | 0 | Maximum usage limit | |
m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
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_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 | |||
m_promotiondistribution | seqno | numeric | 10 | NULL::numeric | Method of ordering records; lowest number comes first | ||
m_promotionprecondition | seqno | numeric | 10 | 0 | Method of ordering records; lowest number comes first | ||
m_promotionreward | seqno | numeric | 10 | NULL::numeric | Method of ordering records; lowest number comes first | ||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
c_bpartner_product | shelflifemindays | numeric | 10 | Minimum Shelf Life in days based on Product Instance Guarantee Date | |||
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
c_bpartner_product | shelflifeminpct | numeric | 10 | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |||
m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
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 | |||
c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
m_discountschemaline | classification | varchar | 12 | √ | null | Classification for grouping | |
m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
m_product_po | upc | varchar | 20 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product | versionno | varchar | 20 | √ | null | Version Number | |
m_discountschemaline | conversiondate | timestamp | 29,6 | Date for selecting conversion rate | |||
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 | ||
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_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 | ||
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
m_promotionprecondition | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
m_product_po | priceeffective | timestamp | 29,6 | √ | null | Effective Date of Price | |
m_promotionprecondition | startdate | timestamp | 29,6 | First effective day (inclusive) | |||
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_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 | ||
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_product | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
m_product_po | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
m_promotionprecondition | promotioncode | varchar | 30 | √ | null | User entered promotion code at sales time | |
m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
c_bpartner_product | vendorcategory | varchar | 30 | √ | null | Product Category of the Business Partner | |
m_discountschemaline | vendorcategory | varchar | 30 | √ | NULL::character varying | 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 | |
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 | |
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 | |
c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
c_bpartner | 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 | |||
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
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_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 | |||
c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
m_product | downloadurl | varchar | 120 | √ | null | ||
m_product | imageurl | varchar | 120 | √ | null | URL of image | |
c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
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_discountschemaline | description | varchar | 255 | √ | NULL::character varying | 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_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 | name | varchar | 255 | Alphanumeric identifier of the entity | |||
c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
m_discountschema | script | varchar | 2000 | √ | null | Dynamic Java Language Script to calculate result |