m_product

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_product_id numeric 10 null
a_asset.m_product_id mproduct_aasset R
a_asset_addition.m_product_id mproduct_aassetaddition R
a_asset_product.m_product_id mproduct_aassetproduct R
a_registration.m_product_id mproduct_aregistration R
a_registrationproduct.m_product_id mproduct_aregproduct R
ad_clientinfo.m_productfreight_id mproductfreight_adclientinfo R
b_topictype.m_product_id mproduct_btopictype R
b_topictype.m_productmember_id mproduct_btopictypemember R
c_acctschema_element.m_product_id mproduct_caschemaelement R
c_bpartner_product.m_product_id mproduct_cbpproduct C
c_cashplanline.m_product_id mproduct_ccashplanline R
c_commission.m_product_id mproduct_ccommission R
c_commissionline.m_product_id mproduct_ccommissionline R
c_invoiceline.m_product_id mproduct_cinvoiceline R
c_invoiceline_v.m_product_id Implied Constraint R
c_landedcost.m_product_id mproduct_clandedcost R
c_landedcostallocation.m_product_id mproduct_clandedcostalloc R
c_orderline.m_product_id mproduct_corderline R
c_phase.m_product_id mproduct_cphase R
c_poskey.m_product_id mproduct_cposkey R
c_project_details_v.m_product_id Implied Constraint R
c_project_details_v.m_product_m_product_id Implied Constraint R
c_project_details_vt.m_product_id Implied Constraint R
c_project_details_vt.m_product_m_product_id Implied Constraint R
c_project_header_v.c_phase_m_product_id Implied Constraint R
c_project_header_vt.c_phase_m_product_id Implied Constraint R
c_projectissue.m_product_id mproduct_cprojectissue R
c_projectline.m_product_id mproduct_cprojectline R
c_projectphase.m_product_id mproduct_cprojectphase R
c_projecttask.m_product_id mproduct_cprojecttask R
c_rfq_topicsubscriberonly.m_product_id mproduct_crfqtsubonly R
c_rfqline.m_product_id mproduct_crfqline R
c_rfqresponseline_v.m_product_id Implied Constraint R
c_rfqresponseline_vt.m_product_id Implied Constraint R
c_servicelevel.m_product_id mproduct_cservicelevel R
c_subscription.m_product_id mproduct_csubscription R
c_task.m_product_id mproduct_ctask R
c_taxdefinition.m_product_id mproduct_ctaxdefinition R
c_uom_conversion.m_product_id mproduct_cuomconversion R
c_validcombination.m_product_id mproduct_vc R
cof_ajusteestoqueprvstline.m_product_id mproduct_cofajusteestoqueprvst R
cof_ajusteqtdcontabil.m_product_id mproduct_cofajusteqtdcontabil R
cof_c_acct_ignoreelement.m_product_id mproduct_cofcacctignoreelement R
cof_c_diadi.m_product_id mproduct_cofcdiadi R
cof_c_markup.m_product_id mproduct_cofcmarkup R
cof_c_pricechange.m_product_id mproduct_cofcpricechange R
cof_c_taxdetermination_fact.m_product_id mproduct_cofctaxdeterminationf R
cof_c_taxdetermination_line.m_product_id mproduct_cofctaxdeterminationl R
cof_cbenef_config.m_product_id mproduct_cofcbenefconfig R
cof_correcaoestoquek280.m_product_id mproduct_cofcorrecaoestoquek28 R
cof_deliveryrestriction.m_product_id mproduct_cofdeliveryrestrictio R
cof_estoqueescrituradok200.m_product_id mproduct_cofestoqueescriturado R
cof_estoqueprevisto.m_product_id mproduct_cofestoqueprevisto R
cof_fci.m_product_id mproduct_coffci R
cof_fci_prod.m_product_id mproduct_coffciprod R
cof_fciline.m_product_id mproduct_coffciline R
cof_infofechamentoblocoh.m_product_id mproduct_cofinfofechamentobloc R
cof_inoutline_candidate_v.m_product_id Implied Constraint R
cof_itemsubstituto.m_product_id mproduct_cofitemsubstituto R
cof_label.m_product_id mproduct_coflabel R
cof_materialaplicado.m_product_id mproduct_cofmaterialaplicado R
cof_mprecebida.m_product_id mproduct_cofmprecebida R
cof_nve_product.m_product_id mproduct_cofnveproduct R
cof_orcamentoconfig.m_product_id mproduct_coforcamentoconfig R
cof_ordemservico.m_product_id mproduct_cofordemservico R
cof_osproduto.cof_servico_id cofservico_cofosproduto R
cof_osproduto.m_product_id mproduct_cofosproduto R
cof_osservico.cof_servico_id cofservico_cofosservico R
cof_pmp_apontamento_producao_manual.m_product_id mproduct_cofpmpapontamentoprod R
cof_pp_consumomateriaprima.m_product_id mproduct_cofppconsumomateriapr R
cof_pp_ferramentarest.m_product_id mproduct_cofppferramentarest R
cof_pp_gestaomp.m_product_id mproduct_cofppgestaomp R
cof_pp_planomestreprod.m_product_id mproduct_cofppplanomestreprod R
cof_pp_recursosconfig.m_product_id mproduct_cofpprecursosconfig N
cof_pp_roteiroprod.m_product_id mproduct_cofpproteiroprod R
cof_preferenciaxml.m_product_id mproduct_cofpreferenciaxml N
cof_products.m_product_id mproduct_cofproducts R
cof_produtosgruposeparacao.m_product_id mproduct_cofprodutosgruposepar R
cof_projecaoestoquefiscal.m_product_id mproduct_cofprojecaoestoquefis R
cof_registrocorrecaoblocok270.m_product_id mproduct_cofregistrocorrecaobl R
cof_rv_commission_composition_detail.m_product_id Implied Constraint R
cof_rv_confimpostos.m_product_id Implied Constraint R
cof_rv_contract.m_product_id Implied Constraint R
cof_rv_detalheplanomestre.m_product_id Implied Constraint R
cof_rv_detalhesestoqueprevisto.m_product_id Implied Constraint R
cof_rv_detalhesmovimentocusto.m_product_id Implied Constraint R
cof_rv_detalhesordemservico.m_product_id Implied Constraint R
cof_rv_detalhesordemservicoapontamento.m_product_id Implied Constraint R
cof_rv_detalhesproducao.m_product_id Implied Constraint R
cof_rv_docfiscal.m_product_id Implied Constraint R
cof_rv_entrieslabel.m_product_id Implied Constraint R
cof_rv_etiquetaxestoque.m_product_id Implied Constraint R
cof_rv_faturamentoprodutomargem.m_product_id Implied Constraint R
cof_rv_infodevolucao.m_product_id Implied Constraint R
cof_rv_ordemservico.m_product_id Implied Constraint R
cof_rv_productsmanufacturedandsold.m_product_id Implied Constraint R
cof_rv_requestpartner.m_product_id Implied Constraint R
cof_transacoesfiscais.m_product_id Implied Constraint R
cof_trxestoqueprevisto.m_product_id mproduct_coftrxestoqueprevisto R
dd_orderline.m_product_id mproduct_ddorderline R
fact_acct.m_product_id m_product_fact_acct R
fact_acct_balance.m_product_id Implied Constraint R
fact_acct_summary.m_product_id mproduct_factacctsummary R
gl_distribution.m_product_id mproduct_gldist R
gl_distributionline.m_product_id mproduct_gldistline R
gl_journalline.m_product_id mproduct_gljournalline R
gl_journalline_acct_v.m_product_id Implied Constraint R
i_asset.m_product_id mproduct_iasset R
i_fajournal.m_product_id mproduct_ifajournal R
i_fixedasset.m_product_id mproduct_ifixedasset R
i_gljournal.m_product_id mproduct_ogljournal N
i_inout.m_product_id Implied Constraint R
i_inventory.m_product_id mproduct_iinventory N
i_invoice.m_product_id nproduct_iinvoice N
i_movement.m_product_id mproduct_imovement R
i_order.m_product_id mproduct_iorder N
i_pricelist.m_product_id mproduct_ipricelist R
i_product.m_product_id mproduct_iproduct N
i_productplanning.m_product_id mproduct_iproductplanning R
lbr_averagecostline.m_product_id Implied Constraint R
lbr_docfiscal_line.m_product_id Implied Constraint R
lbr_issmatrix.m_product_id Implied Constraint R
lbr_taxdefinition.m_product_id Implied Constraint R
m_bom.m_product_id mproduct_mbom C
m_bomalternative.m_product_id mproduct_mbomalternative C
m_bomproduct.m_productbom_id mproduct_mbomproduct R
m_bp_price.m_product_id mproduct_mbpprice R
m_commodityshipment.m_product_id mproduct_mcommodityshipment R
m_cost.m_product_id mproduct_mcost R
m_costdetail.m_product_id mproduct_mcostdetail R
m_costhistory.m_product_id mproduct_mcosthistory R
m_costmovement_v.m_product_id Implied Constraint R
m_costqueue.m_product_id mproduct_mcostqueue R
m_demandline.m_product_id mproduct_mdemandline C
m_discountschemabreak.m_product_id mproduct_mdiscountsbreak R
m_discountschemaline.m_product_id mproduct_mdiscountsline N
m_distributionrunline.m_product_id mproduct_mdistributionrun R
m_edi.m_product_id mproduct_medi R
m_forecastline.m_product_id mproduct_mforecastline C
m_inout_line_v.m_product_id Implied Constraint R
m_inout_line_vt.m_product_id Implied Constraint R
m_inout_lineconfirm_v.m_product_id Implied Constraint R
m_inout_lineconfirm_vt.m_product_id Implied Constraint R
m_inoutline.m_product_id mproduct_minoutline R
m_inoutlinema_v.m_product_id Implied Constraint R
m_inoutlinema_vt.m_product_id Implied Constraint R
m_inventoryline.m_product_id mproduct_minventoryline R
m_lot.m_product_id mproduct_mlot R
m_matchinv.m_product_id mproduct_mmatchinv R
m_matchpo.m_product_id mproduct_mmatchpo R
m_movementline.m_product_id mproduct_mmovementline R
m_movementlinema_v.m_product_id Implied Constraint R
m_movementlinema_vt.m_product_id Implied Constraint R
m_packageline.m_product_id mproduct_mpackageline R
m_packagelines_avail_v.m_product_id Implied Constraint R
m_product_acct.m_product_id m_product_m_product_acct C
m_product_bom.m_product_id Implied Constraint R
m_product_bom_old.m_product_id mproduct_mproductbom C
m_product_bom_old.m_productbom_id mproduct_bomproduct R
m_product_po.m_product_id m_product_productpo C
m_product_qualitytest.m_product_id mproduct_mproductqualitytest R
m_product_stock_v.m_product_id Implied Constraint R
m_product_substituterelated_v.m_product_id Implied Constraint R
m_product_trl.m_product_id mproduct_mproducttrl C
m_productdownload.m_product_id mproduct_mproductdownload R
m_production.m_product_id mproduct_mproduction R
m_productionline.m_product_id mproduct_mproductionline R
m_productionplan.m_product_id mproduct_mproductionplan R
m_productoperation.m_product_id mproduct_mproductoperation C
m_productprice.m_product_id mproduct_mproductprice C
m_productpricevendorbreak.m_product_id mproduct_mproductpricevendorbr R
m_promotiongroupline.m_product_id mproduct_mpromotiongroupline R
m_relatedproduct.m_product_id mproduct_mrelated_product C
m_relatedproduct.relatedproduct_id mproduct_mrelatedproduct C
m_replenish.m_product_id m_product_replenish C
m_requisitionline.m_product_id mproduct_mrequisitionline R
m_rma_createfrom_v.m_product_id Implied Constraint R
m_rmaline.m_product_id mproduct_mrmaline R
m_storage.m_product_id Implied Constraint R
m_storageonhand.m_product_id mproduct_mstorageonhand R
m_storagereservation.m_product_id mproduct_mstoragereservation R
m_storagereservationlog.m_product_id mproduct_mstoragereservationlo R
m_substitute.m_product_id mproduct_substitute C
m_substitute.substitute_id mproduct_substitutesub C
m_transaction.m_product_id mproduct_minventorycount R
m_transaction_v.m_product_id Implied Constraint R
m_transactionallocation.m_product_id mproduct_mtrxalloc R
mp_jobstandar_resource.m_product_id mproduct_mpjobstandarresource R
mp_maintain_resource.m_product_id mproduct_mpmaintainresource R
mp_ot_resource.m_product_id mproduct_mpotresource R
pa_goalrestriction.m_product_id mproduct_pagoalrestriction R
pa_reportcolumn.m_product_id mproduct_pareportcolumn R
pa_reportsource.m_product_id mproduct_pareportsource R
pp_cost_collector.m_product_id mproduct_ppcostcollector R
pp_mrp.m_product_id mproduct_ppmrp R
pp_order.m_product_id mproduct_pporder R
pp_order_bom.m_product_id mproduct_pporderbom R
pp_order_bom_header_v.m_product_id Implied Constraint R
pp_order_bom_header_vt.m_product_id Implied Constraint R
pp_order_bomline.m_product_id mproduct_pporderbomline R
pp_order_bomline_v.m_product_id Implied Constraint R
pp_order_bomline_vt.m_product_id Implied Constraint R
pp_order_cost.m_product_id mproduct_ppordercost R
pp_order_header_v.m_product_id Implied Constraint R
pp_order_header_vt.m_product_id Implied Constraint R
pp_order_node_product.m_product_id mproduct_ppordernodeproduct R
pp_product_bom.m_product_id mproduct_ppproductbom R
pp_product_bomline.m_product_id mproduct_ppproductbomline R
pp_product_bomline_v.m_product_id Implied Constraint R
pp_product_bomline_vt.m_product_id Implied Constraint R
pp_product_planning.m_product_id mproduct_ppproductplanning R
pp_wf_node_product.m_product_id mproduct_ppwfnodeproduct R
qm_specification.m_product_id mproduct_qmspecification R
r_category.m_product_id mproduct_rcategory R
r_request.m_product_id mproduct_rrequest R
r_request.m_productspent_id mproductspent_rrequest R
r_request_v.m_product_id Implied Constraint R
r_requestaction.m_product_id mproduct_rrequestaction R
r_requestaction.m_productspent_id mproductspent_rrequestaction R
r_requestupdate.m_productspent_id mproductspent_rrequestupdate R
rv_asset_customer.m_product_id Implied Constraint R
rv_asset_delivery.m_product_id Implied Constraint R
rv_asset_summonth.m_product_id Implied Constraint R
rv_c_invoice_day.m_product_id Implied Constraint R
rv_c_invoice_productmonth.m_product_id Implied Constraint R
rv_c_invoice_productqtr.m_product_id Implied Constraint R
rv_c_invoiceline.m_product_id Implied Constraint R
rv_c_invoiceline.m_product_m_product_id Implied Constraint R
rv_c_rfqresponse.m_product_id Implied Constraint R
rv_cof_detailassetmaintain.m_product_id Implied Constraint R
rv_cof_detalhesestoquefisico.m_product_id Implied Constraint R
rv_commissionrundetail.m_product_id Implied Constraint R
rv_cost.m_product_id Implied Constraint R
rv_costdetail.m_product_id Implied Constraint R
rv_costsummary.m_product_id Implied Constraint R
rv_dd_orderdetail.m_product_id Implied Constraint R
rv_fact_acct.m_product_id Implied Constraint R
rv_fact_acct_day.m_product_id Implied Constraint R
rv_fact_acct_period.m_product_id Implied Constraint R
rv_inoutdetails.m_product_id Implied Constraint R
rv_inoutlineconfirm.m_product_id Implied Constraint R
rv_m_forecast.m_product_id Implied Constraint R
rv_m_forecast_period.m_product_id Implied Constraint R
rv_m_product_whereused_v.m_product_id Implied Constraint R
rv_m_requisition.m_product_id Implied Constraint R
rv_m_transaction.m_product_id Implied Constraint R
rv_m_transaction.m_product_po_m_product_id Implied Constraint R
rv_m_transaction_sum.m_product_id Implied Constraint R
rv_orderdetail.m_product_id Implied Constraint R
rv_pp_mrp.m_product_id Implied Constraint R
rv_pp_order.m_product_id Implied Constraint R
rv_pp_order_bomline.m_product_id Implied Constraint R
rv_pp_order_receipt_issue.m_product_id Implied Constraint R
rv_pp_order_storage.m_product_id Implied Constraint R
rv_pp_order_transactions.m_product_id Implied Constraint R
rv_pp_product_bomline.m_product_id Implied Constraint R
rv_projectlineissue.m_product_id Implied Constraint R
rv_storage.m_product_id Implied Constraint R
rv_storage_per_product.m_product_id Implied Constraint R
rv_transaction.c_prjctissue_m_product_id Implied Constraint R
rv_transaction.m_inoutline_m_product_id Implied Constraint R
rv_transaction.m_inventoryline_m_product_id Implied Constraint R
rv_transaction.m_movementline_m_product_id Implied Constraint R
rv_transaction.m_product_id Implied Constraint R
rv_transaction.m_productionline_m_product_id Implied Constraint R
rv_transaction.m_productionplan_m_product_id Implied Constraint R
rv_warehouseprice.m_product_id Implied Constraint R
s_timeexpenseline.m_product_id mproduct_stimeexpenseline R
s_training_class.m_product_id mproduct_strainingclass R
t_bom_indented.m_product_id Implied Constraint R
t_bomline.m_product_id Implied Constraint R
t_bomline_costs.m_product_id Implied Constraint R
t_cashflow.m_product_id Implied Constraint R
t_cof_relatoriocompra.m_product_id mproduct_tcofrelatoriocompra R
t_cof_relatoriomrp.m_product_id mproduct_tcofrelatoriomrp R
t_distributionrundetail.m_product_id mproduct_tdrdetail C
t_inventorytrxsummary.m_product_id mproduct_tinventorytrxsummary R
t_inventoryvalue.m_product_id mproduct_tinventoryvalue C
t_invoicegl_v.fact_acct_m_product_id Implied Constraint R
t_itensaproduzir.m_product_id mproduct_coftitensaproduzir R
t_itensnaovendidosaclientes.m_product_id mproduct_titensnaovendidosacli R
t_replenish.m_product_id mproduct_treplenish C
t_rv_reconciliation.m_product_id Implied Constraint R
t_transaction.m_product_id mproduct_ttransaction C
t_trialbalance.m_product_id Implied Constraint R
test.m_product_id Implied Constraint R
w_basketline.m_product_id mproduct_wbasketline R
x_packagelineweight.m_product_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_mproduct R
ad_org_id numeric 10 null
ad_org.ad_org_id ad_org_mproduct R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 510 null
name varchar 255 null
description varchar 255 √ null
documentnote varchar 2000 √ null
help varchar 2000 √ null
upc varchar 30 √ 'SEM GTIN'::character varying
sku varchar 30 √ null
c_uom_id numeric 10 null
c_uom.c_uom_id cuom_mproduct R
salesrep_id numeric 10 √ null
ad_user.ad_user_id salesrep_mproduct R
issummary bpchar 1 'N'::bpchar
isstocked bpchar 1 'Y'::bpchar
ispurchased bpchar 1 'Y'::bpchar
issold bpchar 1 'Y'::bpchar
isbom bpchar 1 'N'::bpchar
isinvoiceprintdetails bpchar 1 'N'::bpchar
ispicklistprintdetails bpchar 1 'N'::bpchar
isverified bpchar 1 'N'::bpchar
c_revenuerecognition_id numeric 10 √ null
c_revenuerecognition.c_revenuerecognition_id crevrecognition_mproduct R
m_product_category_id numeric 10 null
m_product_category.m_product_category_id mproduct_mproductcategory R
classification varchar 40 √ null
volume numeric 0 √ 0
weight numeric 0 √ 0
shelfwidth numeric 10 √ null
shelfheight numeric 0 √ null
shelfdepth numeric 10 √ null
unitsperpallet numeric 0 √ null
c_taxcategory_id numeric 10 null
c_taxcategory.c_taxcategory_id ctaxcategory_mproduct R
s_resource_id numeric 10 √ null
s_resource.s_resource_id sresource_mproduct R
discontinued bpchar 1 √ 'N'::bpchar
discontinuedby timestamp 29,6 √ null
processing bpchar 1 √ null
s_expensetype_id numeric 10 √ null
s_expensetype.s_expensetype_id sexpensetype_mproduct R
producttype bpchar 1 'I'::bpchar
imageurl varchar 120 √ null
descriptionurl varchar 120 √ null
guaranteedays numeric 10 √ null
r_mailtext_id numeric 10 √ null
r_mailtext.r_mailtext_id rmailtext_mproduct R
versionno varchar 20 √ null
m_attributeset_id numeric 10 √ null
m_attributeset.m_attributeset_id mattributeset_mproduct C
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
downloadurl varchar 120 √ null
m_freightcategory_id numeric 10 √ null
m_freightcategory.m_freightcategory_id mfreightcategory_mproduct R
m_locator_id numeric 10 √ null
m_locator.m_locator_id mlocator_mproduct R
guaranteedaysmin numeric 10 √ null
iswebstorefeatured bpchar 1 'N'::bpchar
isselfservice bpchar 1 'Y'::bpchar
c_subscriptiontype_id numeric 10 √ null
c_subscriptiontype.c_subscriptiontype_id csubscriptiontype_mproduct R
isdropship bpchar 1 'N'::bpchar
isexcludeautodelivery bpchar 1 'N'::bpchar
group1 varchar 255 √ null
group2 varchar 255 √ null
istoformule bpchar 1 √ null
lowlevel numeric 10 (0)::numeric
unitsperpack numeric 10 1
discontinuedat timestamp 29,6 √ null
copyfrom bpchar 1 √ NULL::bpchar
m_product_uu varchar 36 √ NULL::character varying
m_parttype_id numeric 10 √ NULL::numeric
m_parttype.m_parttype_id mparttype_mproduct R
iskanban bpchar 1 'N'::bpchar
ismanufactured bpchar 1 'N'::bpchar
isphantom bpchar 1 √ 'N'::bpchar
isownbox bpchar 1 'N'::bpchar
lbr_productcategory_id numeric 10 √ null
lbr_productcategory.lbr_productcategory_id Implied Constraint R
lbr_ismanufactured bpchar 1 'N'::bpchar
lbr_ncm_id numeric 10 √ null
lbr_ncm.lbr_ncm_id Implied Constraint R
lbr_fiscalgroup_product_id numeric 10 √ null
lbr_fiscalgroup_product.lbr_fiscalgroup_product_id Implied Constraint R
lbr_hassubstitution bpchar 1 'N'::bpchar
lbr_productsource bpchar 1 '0'::bpchar
lbr_servicecode varchar 20 √ null
cof_specificproduct varchar 2 √ null
cof_cest_id numeric 10 √ NULL::numeric
cof_cest.cof_cest_id cofcest_mproduct R
cof_nfci varchar 36 √ NULL::character varying
cof_isgenericitem bpchar 1 √ 'N'::bpchar
cof_producttype varchar 2 √ NULL::character varying
cof_c_generoitem_sped_id numeric 10 √ NULL::numeric
cof_c_generoitem_sped.cof_c_generoitem_sped_id cofcgeneroitemsped_mproduct R
cof_isnve bpchar 1 √ 'N'::bpchar
cof_isfci bpchar 1 √ 'N'::bpchar
cof_producttype_id numeric 10 √ null
cof_producttype.cof_producttype_id cofproducttype_mproduct R
cof_productclass_id numeric 10 √ NULL::numeric
cof_productclass.cof_productclass_id cofproductclass_mproduct R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_mproduct R
cof_maxtolerance numeric 0 √ null
cof_mintolerance numeric 0 √ null
cof_conversionfactor1 numeric 0 √ null
cof_conversionfactor2 numeric 0 √ null
cof_netweight numeric 0 √ '0'::numeric
cof_abc varchar 2 √ null
cof_qtymincomercial numeric 0 √ null
processing2 bpchar 1 √ 'N'::bpchar
cof_indnatfrt bpchar 1 √ NULL::bpchar
cof_nbs_id numeric 10 √ NULL::numeric
cof_nbs.cof_nbs_id cofnbs_mproduct R
det_prod_indescala bpchar 1 √ NULL::bpchar
det_prod_cnpjfab varchar 14 √ NULL::character varying
det_prod_med_cprodanvisa varchar 13 √ NULL::character varying
cof_tabelaanexos varchar 20 √ null
cof_situacaocomercial varchar 4 'PL'::character varying
cof_liberadosweb bpchar 1 √ 'N'::bpchar
cof_grupofornecedor_id numeric 10 √ null
cof_grupofornecedor.cof_grupofornecedor_id cofgrupofornecedor_mproduct R
cof_upctrib varchar 30 √ NULL::character varying
cof_codigocnae varchar 7 √ NULL::character varying
cof_tipotributacao bpchar 1 √ NULL::bpchar
cof_exigibilidadeiss bpchar 1 √ NULL::bpchar
cof_operacao bpchar 1 √ NULL::bpchar
cof_executado bpchar 1 'N'::bpchar
det_prod_comb_cprodanp numeric 10 √ NULL::numeric
det_prod_comb_descanp varchar 95 √ NULL::character varying
det_prod_comb_pglp numeric 0 √ '0'::numeric
det_prod_comb_pgnn numeric 0 √ '0'::numeric
det_prod_comb_pgni numeric 0 √ '0'::numeric
cof_cidadeservico bpchar 1 √ 'E'::bpchar
cof_naturezatributacao bpchar 1 √ NULL::bpchar
cof_extipi varchar 3 √ NULL::character varying
customstariffnumber varchar 20 √ null
cof_natbccred varchar 2 √ NULL::character varying
isautoproduce bpchar 1 'N'::bpchar
cof_ismaterialdeterceiro bpchar 1 √ 'N'::bpchar
cof_isindustrializadoporterceiro bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
m_product_pkey Primary key Asc m_product_id
m_product_expensetype Must be unique Asc s_expensetype_id
m_product_name Performance Asc name
m_product_productcategory Performance Asc m_product_category_id
m_product_resource Must be unique Asc s_resource_id
m_product_upc Performance Asc upc
m_product_uu_idx Must be unique Asc m_product_uu
m_product_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
m_product_issold_check ((issold = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_isnve_check ((cof_isnve = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_executado_check ((cof_executado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_ispicklistprintdetails_check ((ispicklistprintdetails = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isinvoiceprintdetails_check ((isinvoiceprintdetails = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_isfci_check ((cof_isfci = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_isgenericitem_check ((cof_isgenericitem = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isbom_check ((isbom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isstocked_check ((isstocked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_discontinued_check ((discontinued = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_isindustrializadoporterceiro_check ((cof_isindustrializadoporterceiro = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isautoproduce_check ((isautoproduce = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_ismanufactured_check ((ismanufactured = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isownbox_check ((isownbox = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_iskanban_check ((iskanban = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_isverified_check ((isverified = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_istoformule_check ((istoformule = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_liberadosweb_check ((cof_liberadosweb = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_lbr_hassubstitution_check ((lbr_hassubstitution = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_cof_ismaterialdeterceiro_check ((cof_ismaterialdeterceiro = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_product_ispurchased_check ((ispurchased = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation