cof_linhareposicao

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_coflinhareposicao R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_coflinhareposicao R
cof_linhareposicao_id numeric 10 null
c_orderline.cof_linhareposicao_id coflinhareposicao_corderline N
cof_linhareposicao_uu varchar 36 √ NULL::character varying
cof_reposicaoestoquefilial_id numeric 10 √ null
cof_reposicaoestoquefilial.cof_reposicaoestoquefilial_id cofreposicaoestoquefilial_coflinhareposicao R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_coflinhareposicao R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_coflinhareposicao R
m_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_coflinhareposicao R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_coflinhareposicao R
m_warehouseto_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouseto_coflinhareposicao R
m_locatorto_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocatorto_coflinhareposicao R
cof_qtdtotalestoqueorigem numeric 0 √ '0'::numeric
cof_deltavendasmensal numeric 0 √ '0'::numeric
cof_qtdreposicao numeric 0 √ '0'::numeric
cof_qtdestoquedestino numeric 0 √ '0'::numeric
cof_nvmaxlocdest numeric 0 √ '0'::numeric
cof_nvminlocdest numeric 0 √ '0'::numeric
cof_nivelseguranca numeric 0 √ '0'::numeric
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_coflinhareposicao N
cof_volumeexcedente numeric 0 √ '0'::numeric
cof_diasestoqueorigem numeric 0 √ '0'::numeric
cof_diasestoquedestino numeric 0 √ '0'::numeric
cof_isvalidacao1 bpchar 1 'N'::bpchar
cof_isvalidacao2 bpchar 1 'N'::bpchar
cof_isvalidacao3 bpchar 1 'N'::bpchar
m_locator_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocator_coflinhareposicao R

Indexes

Constraint Name Type Sort Column(s)
cof_linhareposicao_key Primary key Asc cof_linhareposicao_id
cof_linhareposicao_uu_idx Must be unique Asc cof_linhareposicao_uu

Check Constraints

Constraint Name Constraint
cof_linhareposicao_cof_validacao1_check ((cof_isvalidacao1 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_linhareposicao_cof_validacao3_check ((cof_isvalidacao3 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_linhareposicao_cof_validacao2_check ((cof_isvalidacao2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_linhareposicao_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation