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 a_asset_group_id numeric 10  √  null
m_product_bom ad_client_id numeric 10  √  null
m_product_bom ad_org_id numeric 10  √  null
m_product_category ad_printcolor_id numeric 10  √  null
m_product_bom bomqty numeric 0  √  null
m_product_bom bomtype varchar 2147483647  √  null
m_productpricevendorbreak c_bpartner_id numeric 10  √  null
m_product_po c_currency_id numeric 10  √  null
m_product c_revenuerecognition_id numeric 10  √  null
m_product c_subscriptiontype_id numeric 10  √  null
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying
m_product_po c_uom_id numeric 10  √  null
c_uom c_uom_uu varchar 36  √  NULL::character varying
m_product classification varchar 12  √  null
m_product copyfrom bpchar 1  √  NULL::bpchar
m_product_po costperorder numeric 0  √  0
m_product_bom created timestamp 29,6  √  null
m_product_bom createdby numeric 10  √  null
m_product customstariffnumber varchar 20  √  null
m_product_po deliverytime_actual numeric 10  √  null
m_product_po deliverytime_promised numeric 10  √  null
c_uom description varchar 255  √  null
m_product description varchar 255  √  null
m_product_bom description varchar 255  √  null
m_product_category description varchar 255  √  null
m_product_trl description varchar 255  √  null
m_relatedproduct description varchar 255  √  null
m_substitute description varchar 255  √  null
m_product descriptionurl varchar 120  √  null
m_product discontinued bpchar 1  √  'N'::bpchar
m_product_po discontinued bpchar 1  √  'N'::bpchar
m_product discontinuedat timestamp 29,6  √  null
m_product_po discontinuedat timestamp 29,6  √  null
m_product discontinuedby timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
m_product documentnote varchar 2000  √  null
m_product_trl documentnote varchar 2000  √  null
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null
m_product group2 varchar 255  √  null
m_product guaranteedays numeric 10  √  null
m_product guaranteedaysmin numeric 10  √  null
m_product help varchar 2000  √  null
m_product imageurl varchar 120  √  null
m_product_bom isactive bpchar 1  √  null
m_product isphantom bpchar 1  √  'N'::bpchar
m_product istoformule bpchar 1  √  null
m_product_bom line numeric 10  √  null
m_product m_attributeset_id numeric 10  √  null
m_product m_attributesetinstance_id numeric 10  √  0
m_product m_freightcategory_id numeric 10  √  null
m_product m_locator_id numeric 10  √  null
m_replenish m_locator_id numeric 10  √  null
m_product m_parttype_id numeric 10  √  NULL::numeric
m_product_acct m_product_acct_uu varchar 36  √  NULL::character varying
m_product_bom m_product_bom_id numeric 10  √  null
m_product_bom m_product_bom_uu varchar 36  √  null
m_product_category m_product_category_parent_id numeric 10  √  null
m_product_category m_product_category_uu varchar 36  √  NULL::character varying
c_uom_conversion m_product_id numeric 10  √  null
m_product_bom m_product_id numeric 10  √  null
m_product_po m_product_po_uu varchar 36  √  NULL::character varying
m_product_trl m_product_trl_uu varchar 36  √  NULL::character varying
m_product m_product_uu varchar 36  √  NULL::character varying
m_product_bom m_productbom_id numeric 10  √  null
m_productdownload m_productdownload_uu varchar 36  √  NULL::character varying
m_productprice m_productprice_uu varchar 36  √  NULL::character varying
m_productpricevendorbreak m_productpricevendorbreak_uu varchar 36  √  NULL::character varying
m_relatedproduct m_relatedproduct_uu varchar 36  √  NULL::character varying
m_replenish m_replenish_uu varchar 36  √  NULL::character varying
m_substitute m_substitute_uu varchar 36  √  NULL::character varying
m_replenish m_warehousesource_id numeric 10  √  null
m_product_po manufacturer varchar 30  √  null
m_substitute name varchar 60  √  null
m_product_po order_min numeric 0  √  0
m_product_po order_pack numeric 0  √  0
m_product_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric
m_product_acct p_burden_acct numeric 10  √  null
m_product_acct p_costadjustment_acct numeric 10  √  null
m_product_acct p_costofproduction_acct numeric 10  √  null
m_product_acct p_floorstock_acct numeric 10  √  null
m_product_acct p_inventoryclearing_acct numeric 10  √  null
m_product_acct p_labor_acct numeric 10  √  null
m_product_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric
m_product_acct p_methodchangevariance_acct numeric 10  √  null
m_product_acct p_mixvariance_acct numeric 10  √  null
m_product_acct p_outsideprocessing_acct numeric 10  √  null
m_product_acct p_overhead_acct numeric 10  √  null
m_product_acct p_ratevariance_acct numeric 10  √  null
m_product_acct p_scrap_acct numeric 10  √  null
m_product_acct p_usagevariance_acct numeric 10  √  null
m_product_acct p_wip_acct numeric 10  √  null
m_product_po priceeffective timestamp 29,6  √  null
m_product_po pricelastinv numeric 0  √  0
m_product_po pricelastpo numeric 0  √  0
m_product_po pricelist numeric 0  √  0
m_product_po pricepo numeric 0  √  0
m_product processing bpchar 1  √  null
m_replenish qtybatchsize numeric 0  √  null
m_product_po qualityrating numeric 0  √  null
m_product r_mailtext_id numeric 10  √  null
m_product_po royaltyamt numeric 0  √  0
m_product s_expensetype_id numeric 10  √  null
m_product s_resource_id numeric 10  √  null
m_product salesrep_id numeric 10  √  null
m_product shelfdepth numeric 10  √  null
m_product shelfheight numeric 0  √  null
m_product shelfwidth numeric 10  √  null
m_product sku varchar 30  √  null
m_product unitsperpallet numeric 0  √  null
c_uom uomsymbol varchar 10  √  null
c_uom uomtype varchar 2  √  NULL::character varying
m_product upc varchar 30  √  null
m_product_po upc varchar 20  √  null
m_product_bom updated timestamp 29,6  √  null
m_product_bom updatedby numeric 10  √  null
m_product_po vendorcategory varchar 30  √  null
m_product versionno varchar 20  √  null
m_product volume numeric 0  √  0
m_product weight numeric 0  √  0
c_uom ad_client_id numeric 10
c_uom_conversion ad_client_id numeric 10
m_product ad_client_id numeric 10
m_product_acct ad_client_id numeric 10
m_product_category ad_client_id numeric 10
m_product_po ad_client_id numeric 10
m_product_trl ad_client_id numeric 10
m_productdownload ad_client_id numeric 10
m_productprice ad_client_id numeric 10
m_productpricevendorbreak ad_client_id numeric 10
m_relatedproduct ad_client_id numeric 10
m_replenish ad_client_id numeric 10
m_substitute ad_client_id numeric 10
m_product_trl ad_language varchar 6
c_uom ad_org_id numeric 10
c_uom_conversion ad_org_id numeric 10
m_product ad_org_id numeric 10
m_product_acct ad_org_id numeric 10
m_product_category ad_org_id numeric 10
m_product_po ad_org_id numeric 10
m_product_trl ad_org_id numeric 10
m_productdownload ad_org_id numeric 10
m_productprice ad_org_id numeric 10
m_productpricevendorbreak ad_org_id numeric 10
m_relatedproduct ad_org_id numeric 10
m_replenish ad_org_id numeric 10
m_substitute ad_org_id numeric 10
m_productpricevendorbreak breakvalue numeric 0
m_product_acct c_acctschema_id numeric 10
m_product_po c_bpartner_id numeric 10
m_product c_taxcategory_id numeric 10
c_uom_conversion c_uom_conversion_id numeric 10
c_uom c_uom_id numeric 10
c_uom_conversion c_uom_id numeric 10
m_product c_uom_id numeric 10
c_uom_conversion c_uom_to_id numeric 10
c_uom costingprecision numeric 10
c_uom created timestamp 29,6 now()
c_uom_conversion created timestamp 29,6 now()
m_product created timestamp 29,6 now()
m_product_acct created timestamp 29,6 now()
m_product_category created timestamp 29,6 now()
m_product_po created timestamp 29,6 now()
m_product_trl created timestamp 29,6 now()
m_productdownload created timestamp 29,6 now()
m_productprice created timestamp 29,6 now()
m_productpricevendorbreak created timestamp 29,6 statement_timestamp()
m_relatedproduct created timestamp 29,6 now()
m_replenish created timestamp 29,6 now()
m_substitute created timestamp 29,6 now()
c_uom createdby numeric 10
c_uom_conversion createdby numeric 10
m_product createdby numeric 10
m_product_acct createdby numeric 10
m_product_category createdby numeric 10
m_product_po createdby numeric 10
m_product_trl createdby numeric 10
m_productdownload createdby numeric 10
m_productprice createdby numeric 10
m_productpricevendorbreak createdby numeric 10
m_relatedproduct createdby numeric 10
m_replenish createdby numeric 10
m_substitute createdby numeric 10
c_uom_conversion dividerate numeric 0 0
m_productdownload downloadurl varchar 120
c_uom isactive bpchar 1 'Y'::bpchar
c_uom_conversion isactive bpchar 1 'Y'::bpchar
m_product isactive bpchar 1 'Y'::bpchar
m_product_acct isactive bpchar 1 'Y'::bpchar
m_product_category isactive bpchar 1 'Y'::bpchar
m_product_po isactive bpchar 1 'Y'::bpchar
m_product_trl isactive bpchar 1 'Y'::bpchar
m_productdownload isactive bpchar 1 'Y'::bpchar
m_productprice isactive bpchar 1 'Y'::bpchar
m_productpricevendorbreak isactive bpchar 1 'Y'::bpchar
m_relatedproduct isactive bpchar 1 'Y'::bpchar
m_replenish isactive bpchar 1 'Y'::bpchar
m_substitute isactive bpchar 1 'Y'::bpchar
m_product isautoproduce bpchar 1 'N'::bpchar
m_product isbom bpchar 1 'N'::bpchar
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar
c_uom isdefault bpchar 1 'N'::bpchar
m_product_category isdefault bpchar 1 'N'::bpchar
m_product isdropship bpchar 1 'N'::bpchar
m_product isexcludeautodelivery bpchar 1 'N'::bpchar
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar
m_product iskanban bpchar 1 'N'::bpchar
m_product ismanufactured bpchar 1 'N'::bpchar
m_product isownbox bpchar 1 'N'::bpchar
m_product ispicklistprintdetails bpchar 1 'N'::bpchar
m_product ispurchased bpchar 1 'Y'::bpchar
m_product isselfservice bpchar 1 'Y'::bpchar
m_product_category isselfservice bpchar 1 'Y'::bpchar
m_product issold bpchar 1 'Y'::bpchar
m_product isstocked bpchar 1 'Y'::bpchar
m_product issummary bpchar 1 'N'::bpchar
m_product_trl istranslated bpchar 1 'N'::bpchar
m_product isverified bpchar 1 'N'::bpchar
m_product iswebstorefeatured bpchar 1 'N'::bpchar
m_replenish level_max numeric 0 0
m_replenish level_min numeric 0 0
m_product lowlevel numeric 10 (0)::numeric
m_productprice m_pricelist_version_id numeric 10
m_productpricevendorbreak m_pricelist_version_id numeric 10
m_product m_product_category_id numeric 10
m_product_category m_product_category_id numeric 10
m_product m_product_id numeric 10
m_product_acct m_product_id numeric 10
m_product_po m_product_id numeric 10
m_product_trl m_product_id numeric 10
m_productdownload m_product_id numeric 10
m_productprice m_product_id numeric 10
m_productpricevendorbreak m_product_id numeric 10
m_relatedproduct m_product_id numeric 10
m_replenish m_product_id numeric 10
m_substitute m_product_id numeric 10
m_productdownload m_productdownload_id numeric 10
m_productprice m_productprice_id numeric 10 NULL::numeric
m_productpricevendorbreak m_productpricevendorbreak_id numeric 10
m_replenish m_warehouse_id numeric 10
m_product_category mmpolicy bpchar 1 'F'::bpchar
c_uom_conversion multiplyrate numeric 0 0
c_uom name varchar 60
m_product name varchar 255
m_product_category name varchar 60
m_product_trl name varchar 255
m_productdownload name varchar 60
m_relatedproduct name varchar 60
m_product_acct p_asset_acct numeric 10
m_product_acct p_cogs_acct numeric 10
m_product_acct p_expense_acct numeric 10
m_product_acct p_invoicepricevariance_acct numeric 10
m_product_acct p_purchasepricevariance_acct numeric 10
m_product_acct p_revenue_acct numeric 10
m_product_acct p_tradediscountgrant_acct numeric 10
m_product_acct p_tradediscountrec_acct numeric 10
m_product_category plannedmargin numeric 0
m_productprice pricelimit numeric 0 0
m_productpricevendorbreak pricelimit numeric 0
m_productprice pricelist numeric 0 0
m_productpricevendorbreak pricelist numeric 0
m_productprice pricestd numeric 0 0
m_productpricevendorbreak pricestd numeric 0
m_product producttype bpchar 1 'I'::bpchar
m_relatedproduct relatedproduct_id numeric 10
m_relatedproduct relatedproducttype bpchar 1
m_replenish replenishtype bpchar 1
c_uom stdprecision numeric 10
m_substitute substitute_id numeric 10
m_product unitsperpack numeric 10 1
c_uom updated timestamp 29,6 now()
c_uom_conversion updated timestamp 29,6 now()
m_product updated timestamp 29,6 now()
m_product_acct updated timestamp 29,6 now()
m_product_category updated timestamp 29,6 now()
m_product_po updated timestamp 29,6 now()
m_product_trl updated timestamp 29,6 now()
m_productdownload updated timestamp 29,6 now()
m_productprice updated timestamp 29,6 now()
m_productpricevendorbreak updated timestamp 29,6 statement_timestamp()
m_relatedproduct updated timestamp 29,6 now()
m_replenish updated timestamp 29,6 now()
m_substitute updated timestamp 29,6 now()
c_uom updatedby numeric 10
c_uom_conversion updatedby numeric 10
m_product updatedby numeric 10
m_product_acct updatedby numeric 10
m_product_category updatedby numeric 10
m_product_po updatedby numeric 10
m_product_trl updatedby numeric 10
m_productdownload updatedby numeric 10
m_productprice updatedby numeric 10
m_productpricevendorbreak updatedby numeric 10
m_relatedproduct updatedby numeric 10
m_replenish updatedby numeric 10
m_substitute updatedby numeric 10
m_product value varchar 510
m_product_category value varchar 40
m_product_po vendorproductno varchar 40
c_uom x12de355 varchar 4