cof_ordemservico

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_ordemservico_id numeric 10 null
cof_osapontamentos.cof_ordemservico_id cofordemservico_cofosapontamen R
cof_osproduto.cof_ordemservico_id cofordemservico_cofosproduto R
cof_osservico.cof_ordemservico_id cofordemservico_cofosservico R
cof_ordemservico_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
value varchar 40 null
startdate timestamp 29,6 null
enddate timestamp 29,6 √ null
datepromised timestamp 29,6 √ null
docstatus varchar 2 √ 'DR'::character varying
processed bpchar 1 'N'::bpchar
docaction bpchar 2 'DR'::bpchar
cof_equipments_id numeric 10 √ NULL::numeric
cof_equipments.cof_equipments_id cofequipments_cofordemservico N
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_cofordemservico N
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_cofordemservico R
m_attributesetinstance_id numeric 10 √ NULL::numeric
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_cofordem R
cof_nomeentregador varchar 40 √ NULL::character varying
c_bpartner_id numeric 10 NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofordemservico R
cof_bpinternal_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofbpinternal_cofordemservico R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cofordemservico R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cofordemservico R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_cofordemservico R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_cofordemservico R
c_salesregion_id numeric 10 √ NULL::numeric
c_salesregion.c_salesregion_id csalesregion_cofordemservico R
cof_precoproduto_id numeric 10 √ NULL::numeric
m_pricelist.m_pricelist_id cofprecoproduto_cofordemservic R
cof_precoservico_id numeric 10 √ NULL::numeric
m_pricelist.m_pricelist_id cofprecoservico_cofordemservic R
cof_prognostico varchar 2000 NULL::character varying
cof_diagnostico varchar 2000 √ NULL::character varying
cof_solucoes varchar 2000 √ NULL::character varying
cof_valortotalservicos numeric 0 √ null
cof_valortotalprodutos numeric 0 √ null
cof_motivoparalisacao_id numeric 10 √ NULL::numeric
cof_motivoparalisacao.cof_motivoparalisacao_id cofmotivoparalisacao_cofordems R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_cofordemservico R
c_doctypetarget_id numeric 10 null
c_doctype.c_doctype_id cdoctypetarget_cofordemservico R
cof_orderproduto_id numeric 10 √ null
c_order.c_order_id coforderproduto_cofordemservic N
cof_orderservico_id numeric 10 √ NULL::numeric
c_order.c_order_id coforderservico_cofordemservic N
cof_movementos_id numeric 10 √ null
m_inventory.m_inventory_id cofmovementos_cofordemservico N
c_bpartnersr_id numeric 10 null
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofordemserv R
c_location_id numeric 10 √ NULL::numeric
c_location.c_location_id clocation_cofordemservico R
cof_gerarapontamentos bpchar 1 'N'::bpchar
cof_statusinternoos_id numeric 10 √ NULL::numeric
cof_statusinternoos.cof_statusinternoos_id cofstatusinternoos_cofordemser R
m_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_cofordemservico R
ad_user_id numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
cof_ordemservico_key Primary key Asc cof_ordemservico_id
cof_ordemservico_cof_orderproduto_id_idx Performance Asc cof_orderproduto_id
cof_ordemservico_cof_orderservico_id_idx Performance Asc cof_orderservico_id
cof_ordemservico_uu_idx Must be unique Asc cof_ordemservico_uu

Check Constraints

Constraint Name Constraint
cof_ordemservico_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_ordemservico_cof_gerarapontamentos_check ((cof_gerarapontamentos = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_ordemservico_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation