m_warehouse

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_warehouse_id numeric 10 null
ad_orginfo.dropship_warehouse_id dropshipwarehouse_adorginfo R
ad_orginfo.m_warehouse_id mwarehouse_adorginfo R
c_bp_edi.m_warehouse_id mwarehouse_cbpedi R
c_doctype.m_warehouse_id mwarehouse_cdoctype R
c_order.m_warehouse_id mwarehouse_corder R
c_orderline.m_warehouse_id mwarehouse_corderline R
c_pos.m_warehouse_id mwarehouse_cpos R
c_project.m_warehouse_id mwarehouse_cproject R
cof_equipments.cof_warehouse_id cofwarehouse_cofequipments R
cof_equipments.cof_warehouseto_id cofwarehouseto_cofequipments R
cof_linhacalculo.m_warehouse_id mwarehouse_coflinhacalculo R
cof_linhareposicao.m_warehouse_id mwarehouse_coflinhareposicao R
cof_linhareposicao.m_warehouseto_id mwarehouseto_coflinhareposicao R
cof_localseparation.m_warehouse_id mwarehouse_coflocalseparation R
cof_ordemservico.m_warehouse_id mwarehouse_cofordemservico R
cof_packinglist.cof_warehouse_id cofwarehouse_cofpackinglist R
cof_packinglist.cof_warehouseto_id cofwarehouseto_cofpackinglist R
cof_produtolocalizadorconfig.m_warehouse_id mwarehouse_cofprodutolocalizadorconfig R
cof_reposicaoestoquefilial.m_warehouse_id mwarehouse_cofreposicaoestoquefilial R
cof_sparewarehouse.cof_warehouse_id cofwarehouse_cofsparewarehouse R
cof_sparewarehouse.m_warehouse_id mwarehouse_cofsparewarehouse R
dd_networkdistributionline.m_warehouse_id mwarehouse_ddnetworkdistributi R
dd_networkdistributionline.m_warehousesource_id mwarehousesource_ddnetworkdist R
dd_order.m_warehouse_id mwarehouse_ddorder R
i_inventory.m_warehouse_id mwarehouse_iinventory N
i_order.m_warehouse_id mwarehouse_iorder N
i_productplanning.m_warehouse_id mwarehouse_iproductplanning R
m_edi.m_warehouse_id mwarehouse_medi R
m_forecastline.m_warehouse_id mwarehouse_mforecastline R
m_inout.m_warehouse_id mwarehouse_minout R
m_inventory.m_warehouse_id mwarehouse_minventory R
m_locator.m_warehouse_id m_warehouse_locator C
m_movement.m_warehouse_id mwarehouse_mmovement R
m_movement.m_warehouseto_id mwarehouseto_mmovement R
m_perpetualinv.m_warehouse_id mwarehouse_mperpetualinv R
m_promotionprecondition.m_warehouse_id mwarehouse_mpromotionprecondit R
m_replenish.m_warehouse_id m_warehouse_replenish C
m_replenish.m_warehousesource_id mwarehousesource_mreplenish R
m_requisition.m_warehouse_id mwarehouse_mrequisition R
m_shippingtransaction.m_warehouse_id mwarehouse_mshippingtransactio R
m_storagereservation.m_warehouse_id mwarehouse_mstoragereservation R
m_storagereservationlog.m_warehouse_id mwh_mstoragereservationlog R
m_warehouse.m_warehousesource_id mwarehousesource_mwarehouse R
pp_cost_collector.m_warehouse_id mwarehouse_ppcostcollector R
pp_mrp.m_warehouse_id mwarehouse_ppmrp R
pp_order.m_warehouse_id mwarehouse_pporder R
pp_order_bomline.m_warehouse_id mwarehouse_pporderbomline R
pp_product_planning.m_warehouse_id mwarehouse_ppproductplanning R
s_resource.m_warehouse_id mwarehouse_sresource R
s_timeexpense.m_warehouse_id mwarehouse_stimeexpense R
t_inventorytrxsummary.m_warehouse_id mwarehouse_tinventorytrxsummar R
t_inventoryvalue.m_warehouse_id mwarehouse_tinventoryvalue C
t_itensaproduzir.m_warehouse_id mwarehouse_coftitensaproduzir R
t_replenish.m_warehouse_id mwarehouse_treplenish C
t_replenish.m_warehousesource_id mwarehousesource_treplenish C
u_posterminal.m_warehouse_id mwarehouse_uposterminal R
w_store.m_warehouse_id mwarehouse_wstore R
ad_client_id numeric 10 null
ad_client.ad_client_id m_warehouse_client R
ad_org_id numeric 10 null
ad_org.ad_org_id m_warehouse_org 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 40 null
name varchar 60 null
description varchar 255 √ null
c_location_id numeric 10 null
c_location.c_location_id c_location_warehouse R
separator bpchar 1 null
m_warehousesource_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehousesource_mwarehouse R
replenishmentclass varchar 60 √ null
isintransit bpchar 1 √ 'N'::bpchar
isdisallownegativeinv bpchar 1 'N'::bpchar
m_warehouse_uu varchar 36 √ NULL::character varying
m_reservelocator_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mreservelocator_mwarehouse R
lbr_isthirdparty bpchar 1 √ 'N'::bpchar
lbr_warehousetype varchar 3 'OWN'::character varying
cof_considerarabascompra bpchar 1 'Y'::bpchar
cof_isnaopermitirqtddispneg bpchar 1 'N'::bpchar
h010_cod_part varchar 60 √ NULL::character varying
isdisableinventorypopup bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
m_warehouse_pkey Primary key Asc m_warehouse_id
m_warehouse_name Must be unique Asc/Asc ad_client_id + name
m_warehouse_uu_idx Must be unique Asc m_warehouse_uu

Check Constraints

Constraint Name Constraint
m_warehouse_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_lbr_isthirdparty_check ((lbr_isthirdparty = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_cof_considerarabascompra_check ((cof_considerarabascompra = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isdisallownegativeinv_check ((isdisallownegativeinv = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isdisableinventorypopup_check ((isdisableinventorypopup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_cof_isnaopermitirqtddispneg_check ((cof_isnaopermitirqtddispneg = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isintransit_check ((isintransit = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation