m_warehouse

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_warehouse_id numeric 10 null
ad_org_v.m_warehouse_id Implied Constraint R
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_dunning_header_v.m_warehouse_id Implied Constraint R
c_dunning_header_vt.m_warehouse_id Implied Constraint R
c_invoice_header_v.m_warehouse_id Implied Constraint R
c_invoice_header_vt.m_warehouse_id Implied Constraint R
c_order.m_warehouse_id mwarehouse_corder R
c_order_header_v.ad_orginfo_m_warehouse_id Implied Constraint R
c_order_header_v.m_warehouse_id Implied Constraint R
c_order_header_vt.ad_orginfo_m_warehouse_id Implied Constraint R
c_order_header_vt.m_warehouse_id Implied Constraint R
c_orderline.m_warehouse_id mwarehouse_corderline R
c_payselection_check_v.m_warehouse_id Implied Constraint R
c_payselection_check_vt.m_warehouse_id Implied Constraint R
c_pos.m_warehouse_id mwarehouse_cpos R
c_project.m_warehouse_id mwarehouse_cproject R
c_project_details_v.m_warehouse_id Implied Constraint R
c_project_details_vt.m_warehouse_id Implied Constraint R
c_project_header_v.ad_orginfo_m_warehouse_id Implied Constraint R
c_project_header_v.m_warehouse_id Implied Constraint R
c_project_header_vt.ad_orginfo_m_warehouse_id Implied Constraint R
c_project_header_vt.m_warehouse_id Implied Constraint R
cof_equipments.cof_warehouse_id cofwarehouse_cofequipments R
cof_equipments.cof_warehouseto_id cofwarehouseto_cofequipments R
cof_inoutline_candidate_v.m_warehouse_id Implied Constraint R
cof_localseparation.m_warehouse_id mwarehouse_coflocalseparation R
cof_m_inout_candidate_v.m_warehouse_id Implied Constraint 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_rv_etiquetaxestoque.m_warehouse_id Implied Constraint R
cof_rv_mapa_pedido.m_warehouse_id Implied Constraint 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
dd_order_header_v.m_warehouse_id Implied Constraint R
dd_order_header_vt.m_warehouse_id Implied Constraint R
i_inout.m_warehouse_id Implied Constraint 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_inout_candidate_v.m_warehouse_id Implied Constraint R
m_inout_header_v.ad_orginfo_m_warehouse_id Implied Constraint R
m_inout_header_v.m_warehouse_id Implied Constraint R
m_inout_header_vt.ad_orginfo_m_warehouse_id Implied Constraint R
m_inout_header_vt.m_warehouse_id Implied Constraint R
m_inout_line_v.m_warehouse_id Implied Constraint R
m_inout_line_vt.m_warehouse_id Implied Constraint R
m_inout_lineconfirm_v.m_warehouse_id Implied Constraint R
m_inout_lineconfirm_vt.m_warehouse_id Implied Constraint R
m_inoutconfirm_v.m_warehouse_id Implied Constraint R
m_inoutconfirm_vt.m_warehouse_id Implied Constraint 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_product_stock_v.m_warehouse_id Implied Constraint R
m_product_substituterelated_v.m_warehouse_id Implied Constraint 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_bom_header_v.m_warehouse_id Implied Constraint R
pp_order_bom_header_vt.m_warehouse_id Implied Constraint R
pp_order_bomline.m_warehouse_id mwarehouse_pporderbomline R
pp_order_bomline_v.m_warehouse_id Implied Constraint R
pp_order_bomline_vt.m_warehouse_id Implied Constraint R
pp_order_header_v.m_warehouse_id Implied Constraint R
pp_order_header_vt.m_warehouse_id Implied Constraint R
pp_order_workflow_header_v.m_warehouse_id Implied Constraint R
pp_order_workflow_header_vt.m_warehouse_id Implied Constraint R
pp_product_planning.m_warehouse_id mwarehouse_ppproductplanning R
rv_cof_detalhesestoquefisico.m_warehouse_id Implied Constraint R
rv_commissionrundetail.c_order_m_warehouse_id Implied Constraint R
rv_commissionrundetail.c_orderline_m_warehouse_id Implied Constraint R
rv_inoutconfirm.m_warehouse_id Implied Constraint R
rv_inoutdetails.m_locator_m_warehouse_id Implied Constraint R
rv_inoutdetails.m_warehouse_id Implied Constraint R
rv_inoutlineconfirm.m_warehouse_id Implied Constraint R
rv_m_requisition.m_warehouse_id Implied Constraint R
rv_m_transaction_sum.m_warehouse_id Implied Constraint R
rv_orderdetail.c_order_m_warehouse_id Implied Constraint R
rv_orderdetail.m_warehouse_id Implied Constraint R
rv_pp_mrp.m_warehouse_id Implied Constraint R
rv_pp_order.m_warehouse_id Implied Constraint R
rv_pp_order_bomline.m_warehouse_id Implied Constraint R
rv_pp_order_receipt_issue.m_warehouse_id Implied Constraint R
rv_pp_order_storage.m_warehouse_id Implied Constraint R
rv_projectcycle.m_warehouse_id Implied Constraint R
rv_storage.m_warehouse_id Implied Constraint R
rv_storage_per_product.m_warehouse_id Implied Constraint R
rv_transaction.m_warehouse_id Implied Constraint R
rv_warehouseprice.m_warehouse_id Implied Constraint 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

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_lbr_isthirdparty_check ((lbr_isthirdparty = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isdisallownegativeinv_check ((isdisallownegativeinv = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_warehouse_isintransit_check ((isintransit = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation