m_locator

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_locator_id numeric 10 null
a_asset.m_locator_id mlocator_aasset R
a_asset_addition.m_locator_id mlocator_aassetaddition R
a_asset_product.m_locator_id mlocator_aassetproduct R
c_projectissue.m_locator_id mlocator_cprojectissue R
cof_label.m_locator_id mlocator_coflabel R
cof_labelentry.m_locator_id mlocator_coflabelentry R
cof_linhacalculo.m_locator_id mlocator_coflinhacalculo R
cof_linhareposicao.m_locator_id mlocator_coflinhareposicao R
cof_linhareposicao.m_locatorto_id mlocatorto_coflinhareposicao R
cof_pp_centrotrabalho.m_locator_id mlocator_cofppcentrotrabalho R
cof_pp_consumomateriaprima.m_locator_id mlocator_cofppconsumomateriapr R
cof_pp_gestaomp.m_locator_id mlocator_cofppgestaomp R
cof_pp_gestaomp.m_locatorto_id mlocatorto_cofppgestaomp R
cof_pp_planomestreprod.m_locator_id mlocator_cofppplanomestreprod R
cof_produtolocalizadorconfig.m_locator_id mlocator_cofprodutolocalizadorconfig R
dd_orderline.m_locator_id mlocator_ddorderline R
dd_orderline.m_locatorto_id mlocatorto_ddorderline R
fact_acct.m_locator_id mlocator_factacct R
i_asset.m_locator_id mlocator_iasset R
i_fixedasset.m_locator_id mlocator_ifixedasset R
i_inventory.m_locator_id mlocator_iinventory N
i_movement.m_locator_id mlocator_imovement R
i_movement.m_locatorto_id mlocatorto_imovement R
m_inoutline.m_locator_id mlocator_minoutline R
m_inventoryline.m_locator_id mlocator_minventoryline R
m_movementline.m_locator_id mlocatorto_mmovementline R
m_movementline.m_locatorto_id mlocator_movementline R
m_product.m_locator_id mlocator_mproduct R
m_production.m_locator_id mlocator_mproduction R
m_productionline.m_locator_id mlocator_mproductionline R
m_productionplan.m_locator_id mlocator_mproductionplan R
m_replenish.m_locator_id mlocator_mreplenish R
m_storageonhand.m_locator_id mlocator_mstorageonhand R
m_transaction.m_locator_id mlocator_minventorycount R
m_warehouse.m_reservelocator_id mreservelocator_mwarehouse R
pp_cost_collector.m_locator_id mlocator_ppcostcollector R
pp_order_bomline.m_locator_id mlocator_pporderbomline R
t_inventorytrxsummary.m_locator_id mlocator_tinventorytrxsummary R
t_transaction.m_locator_id mlocator_ttransaction C
ad_client_id numeric 10 null
ad_client.ad_client_id m_wh_locator_client R
ad_org_id numeric 10 null
ad_org.ad_org_id m_wh_locator_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
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id m_warehouse_locator C
priorityno numeric 10 null
isdefault bpchar 1 'N'::bpchar
x varchar 60 √ null
y varchar 60 √ null
z varchar 60 √ null
m_locator_uu varchar 36 √ NULL::character varying
c_bpartner_id numeric 10 √ null
m_locatortype_id numeric 10 √ NULL::numeric
m_locatortype.m_locatortype_id mlocatortype_mlocator R
cof_volcalclocalizador numeric 0 √ '0'::numeric
cof_volumelocalizador numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
m_locator_pkey Primary key Asc m_locator_id
m_location_where Must be unique Asc/Asc/Asc/Asc m_warehouse_id + x + y + z
m_locator_uu_idx Must be unique Asc m_locator_uu

Check Constraints

Constraint Name Constraint
m_locator_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation