SchemaSpy Analysis of idempiere11.adempiere - ColumnsProduct Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:53 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 300 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_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
c_uom 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
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
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
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product_trl istranslated bpchar 1 'N'::bpchar This column is translated
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_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom_conversion 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_acct 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_product_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productdownload 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_relatedproduct isactive bpchar 1 'Y'::bpchar The record is active in the system
m_replenish isactive bpchar 1 'Y'::bpchar The record is active in the system
m_substitute 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
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
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_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
m_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
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)
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_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
c_uom_conversion dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
m_replenish level_max numeric 0 0 Maximum Inventory level for this product
m_replenish level_min numeric 0 0 Minimum Inventory level for this product
c_uom_conversion multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
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_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
c_uom created timestamp 29,6 now() Date this record was created
c_uom_conversion created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_acct 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_product_trl created timestamp 29,6 now() Date this record was created
m_productdownload created timestamp 29,6 now() Date this record was created
m_productprice created timestamp 29,6 now() Date this record was created
m_relatedproduct created timestamp 29,6 now() Date this record was created
m_replenish created timestamp 29,6 now() Date this record was created
m_substitute created timestamp 29,6 now() Date this record was created
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom_conversion updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_acct 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_product_trl updated timestamp 29,6 now() Date this record was updated
m_productdownload updated timestamp 29,6 now() Date this record was updated
m_productprice updated timestamp 29,6 now() Date this record was updated
m_relatedproduct updated timestamp 29,6 now() Date this record was updated
m_replenish updated timestamp 29,6 now() Date this record was updated
m_substitute updated timestamp 29,6 now() Date this record was updated
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
m_product_bom ad_client_id numeric 10  √  null Tenant for this installation.
m_product_bom ad_org_id numeric 10  √  null Organizational entity within tenant
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
m_product_bom bomqty numeric 0  √  null Bill of Materials Quantity
m_product_bom bomtype varchar 2147483647  √  null Type of BOM
m_productpricevendorbreak c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_product_po c_currency_id numeric 10  √  null The Currency for this record
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_po c_uom_id numeric 10  √  null Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product_bom created timestamp 29,6  √  null Date this record was created
m_product_bom createdby numeric 10  √  null User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
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_uom description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product_bom description varchar 255  √  null Optional short description of the record
m_product_category description varchar 255  √  null Optional short description of the record
m_product_trl description varchar 255  √  null Optional short description of the record
m_relatedproduct description varchar 255  √  null Optional short description of the record
m_substitute 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_product documentnote varchar 2000  √  null Additional information for a Document
m_product_trl documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
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
m_product_bom isactive bpchar 1  √  null The record is active in the system
m_product istoformule bpchar 1  √  null
m_product_bom line numeric 10  √  null Unique line for this document
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_replenish m_locator_id numeric 10  √  null Warehouse Locator
m_product_bom m_product_bom_id numeric 10  √  null BOM Line
m_product_bom m_product_bom_uu varchar 36  √  null M_Product_BOM_UU
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
c_uom_conversion m_product_id numeric 10  √  null Product, Service, Item
m_product_bom m_product_id numeric 10  √  null Product, Service, Item
m_product_bom m_productbom_id numeric 10  √  null Bill of Material Component Product
m_replenish m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
m_substitute name varchar 60  √  null Alphanumeric identifier of the entity
m_product_acct p_burden_acct numeric 10  √  null The Burden account is the account used Manufacturing Order
m_product_acct p_costadjustment_acct numeric 10  √  null Product Cost Adjustment Account
m_product_acct p_costofproduction_acct numeric 10  √  null The Cost Of Production account is the account used Manufacturing Order
m_product_acct p_floorstock_acct numeric 10  √  null The Floor Stock account is the account used Manufacturing Order
m_product_acct p_inventoryclearing_acct numeric 10  √  null Product Inventory Clearing Account
m_product_acct p_labor_acct numeric 10  √  null The Labor account is the account used Manufacturing Order
m_product_acct p_methodchangevariance_acct numeric 10  √  null The Method Change Variance account is the account used Manufacturing Order
m_product_acct p_mixvariance_acct numeric 10  √  null The Mix Variance account is the account used Manufacturing Order
m_product_acct p_outsideprocessing_acct numeric 10  √  null The Outside Processing Account is the account used in Manufacturing Order
m_product_acct p_overhead_acct numeric 10  √  null The Overhead account is the account used in Manufacturing Order
m_product_acct p_ratevariance_acct numeric 10  √  null The Rate Variance account is the account used Manufacturing Order
m_product_acct p_scrap_acct numeric 10  √  null The Scrap account is the account used in Manufacturing Order
m_product_acct p_usagevariance_acct numeric 10  √  null The Usage Variance account is the account used Manufacturing Order
m_product_acct p_wip_acct numeric 10  √  null The Work in Process account is the account used Manufacturing Order
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
m_product processing bpchar 1  √  null Process Now
m_replenish qtybatchsize numeric 0  √  null Qty Batch Size
m_product_po qualityrating numeric 0  √  null Method for rating vendors
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
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
m_product unitsperpallet numeric 0  √  null Units Per Pallet
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
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)
m_product_bom updated timestamp 29,6  √  null Date this record was updated
m_product_bom updatedby numeric 10  √  null User who updated this records
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
m_product versionno varchar 20  √  null Version Number
c_uom ad_client_id numeric 10 Tenant for this installation.
c_uom_conversion ad_client_id numeric 10 Tenant for this installation.
m_product ad_client_id numeric 10 Tenant for this installation.
m_product_acct 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_product_trl ad_client_id numeric 10 Tenant for this installation.
m_productdownload 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_relatedproduct ad_client_id numeric 10 Tenant for this installation.
m_replenish ad_client_id numeric 10 Tenant for this installation.
m_substitute ad_client_id numeric 10 Tenant for this installation.
m_product_trl ad_language varchar 6 Language for this entity
c_uom ad_org_id numeric 10 Organizational entity within tenant
c_uom_conversion ad_org_id numeric 10 Organizational entity within tenant
m_product ad_org_id numeric 10 Organizational entity within tenant
m_product_acct 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_product_trl ad_org_id numeric 10 Organizational entity within tenant
m_productdownload 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_relatedproduct ad_org_id numeric 10 Organizational entity within tenant
m_replenish ad_org_id numeric 10 Organizational entity within tenant
m_substitute ad_org_id numeric 10 Organizational entity within tenant
m_productpricevendorbreak breakvalue numeric 0 Low Value of trade discount break level
m_product_acct c_acctschema_id numeric 10 Rules for accounting
m_product_po c_bpartner_id numeric 10 Identifies a Business Partner
m_product c_taxcategory_id numeric 10 Tax Category
c_uom_conversion c_uom_conversion_id numeric 10 Unit of Measure Conversion
c_uom c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_to_id numeric 10 Target or destination Unit of Measure
c_uom costingprecision numeric 10 Rounding used costing calculations
c_uom createdby numeric 10 User who created this records
c_uom_conversion createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_acct 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_product_trl createdby numeric 10 User who created this records
m_productdownload 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_relatedproduct createdby numeric 10 User who created this records
m_replenish createdby numeric 10 User who created this records
m_substitute createdby numeric 10 User who created this records
m_productdownload downloadurl varchar 120 URL of the Download files
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
m_product m_product_id numeric 10 Product, Service, Item
m_product_acct m_product_id numeric 10 Product, Service, Item
m_product_po m_product_id numeric 10 Product, Service, Item
m_product_trl m_product_id numeric 10 Product, Service, Item
m_productdownload 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_relatedproduct m_product_id numeric 10 Product, Service, Item
m_replenish m_product_id numeric 10 Product, Service, Item
m_substitute m_product_id numeric 10 Product, Service, Item
m_productdownload m_productdownload_id numeric 10 Product downloads
m_productpricevendorbreak m_productpricevendorbreak_id numeric 10 Product Price Break
m_replenish m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_uom 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_product_trl name varchar 255 Alphanumeric identifier of the entity
m_productdownload name varchar 60 Alphanumeric identifier of the entity
m_relatedproduct name varchar 60 Alphanumeric identifier of the entity
m_product_acct p_asset_acct numeric 10 Account for Product Asset (Inventory)
m_product_acct p_cogs_acct numeric 10 Account for Cost of Goods Sold
m_product_acct p_expense_acct numeric 10 Account for Product Expense
m_product_acct p_invoicepricevariance_acct numeric 10 Difference between Costs and Invoice Price (IPV)
m_product_acct p_purchasepricevariance_acct numeric 10 Difference between Standard Cost and Purchase Price (PPV)
m_product_acct p_revenue_acct numeric 10 Account for Product Revenue (Sales Account)
m_product_acct p_tradediscountgrant_acct numeric 10 Trade Discount Granted Account
m_product_acct p_tradediscountrec_acct numeric 10 Trade Discount Receivable Account
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_relatedproduct relatedproduct_id numeric 10 Related Product
m_relatedproduct relatedproducttype bpchar 1 Related Product Type
m_replenish replenishtype bpchar 1 Method for re-ordering a product
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
m_substitute substitute_id numeric 10 Entity which can be used in place of this entity
c_uom updatedby numeric 10 User who updated this records
c_uom_conversion updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_acct 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_product_trl updatedby numeric 10 User who updated this records
m_productdownload 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_relatedproduct updatedby numeric 10 User who updated this records
m_replenish updatedby numeric 10 User who updated this records
m_substitute updatedby numeric 10 User who updated this records
m_product value varchar 510 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_uom x12de355 varchar 4 UOM EDI X12 Code
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying C_UOM_Conversion_UU
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
m_product_acct m_product_acct_uu varchar 36  √  NULL::character varying M_Product_Acct_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_trl m_product_trl_uu varchar 36  √  NULL::character varying M_Product_Trl_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_productdownload m_productdownload_uu varchar 36  √  NULL::character varying M_ProductDownload_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_relatedproduct m_relatedproduct_uu varchar 36  √  NULL::character varying M_RelatedProduct_UU
m_replenish m_replenish_uu varchar 36  √  NULL::character varying M_Replenish_UU
m_substitute m_substitute_uu varchar 36  √  NULL::character varying M_Substitute_UU
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric Average Cost Variance
m_product_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric Product Landed Cost Clearing Account
m_productprice m_productprice_id numeric 10 NULL::numeric Intersection between a Product and a Price List Version
m_productpricevendorbreak created timestamp 29,6 statement_timestamp() Date this record was created
m_productpricevendorbreak updated timestamp 29,6 statement_timestamp() Date this record was updated