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_project_details_v.m_locator_id Implied Constraint R
c_project_details_vt.m_locator_id Implied Constraint 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_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_rv_detalheplanomestre.m_locator_id Implied Constraint R
cof_rv_detalhesproducao.m_locator_id Implied Constraint R
cof_rv_productsmanufacturedandsold.m_locator_id Implied Constraint 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_inout.m_locator_id Implied Constraint 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_inout_line_v.m_locator_id Implied Constraint R
m_inout_line_v.m_product_m_locator_id Implied Constraint R
m_inout_line_vt.m_locator_id Implied Constraint R
m_inout_line_vt.m_product_m_locator_id Implied Constraint R
m_inout_lineconfirm_v.m_locator_id Implied Constraint R
m_inout_lineconfirm_vt.m_locator_id Implied Constraint R
m_inoutline.m_locator_id mlocator_minoutline R
m_inoutlinema_v.m_locator_id Implied Constraint R
m_inoutlinema_vt.m_locator_id Implied Constraint R
m_inventoryline.m_locator_id mlocator_minventoryline R
m_movement_candidate_v.m_locator_id Implied Constraint R
m_movementline.m_locator_id mlocatorto_mmovementline R
m_movementline.m_locatorto_id mlocator_movementline R
m_movementlinema_v.m_locator_id Implied Constraint R
m_movementlinema_vt.m_locator_id Implied Constraint 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_storage.m_locator_id Implied Constraint R
m_storageonhand.m_locator_id mlocator_mstorageonhand R
m_transaction.m_locator_id mlocator_minventorycount R
m_transaction_v.m_locator_id Implied Constraint 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
pp_order_bomline_v.m_locator_id Implied Constraint R
pp_order_bomline_vt.m_locator_id Implied Constraint R
rv_c_invoiceline.m_locator_id Implied Constraint R
rv_cof_detalhesestoquefisico.m_locator_id Implied Constraint R
rv_cost.m_locator_id Implied Constraint R
rv_costdetail.m_locator_id Implied Constraint R
rv_dd_orderdetail.m_locator_id Implied Constraint R
rv_fact_acct.m_locator_id Implied Constraint R
rv_fact_acct.m_product_m_locator_id Implied Constraint R
rv_fact_acct_day.m_locator_id Implied Constraint R
rv_fact_acct_period.m_locator_id Implied Constraint R
rv_inoutdetails.m_locator_id Implied Constraint R
rv_inoutlineconfirm.m_locator_id Implied Constraint R
rv_m_transaction.m_locator_id Implied Constraint R
rv_m_transaction.m_product_m_locator_id Implied Constraint R
rv_m_transaction_sum.m_locator_id Implied Constraint R
rv_pp_order_receipt_issue.m_locator_id Implied Constraint R
rv_pp_order_storage.m_locator_id Implied Constraint R
rv_pp_order_transactions.m_locator_id Implied Constraint R
rv_projectlineissue.m_locator_id Implied Constraint R
rv_storage.m_locator_id Implied Constraint R
rv_storage.m_product_m_locator_id Implied Constraint R
rv_storage_per_product.m_locator_id Implied Constraint R
rv_transaction.c_prjctissue_m_locator_id Implied Constraint R
rv_transaction.m_inventoryline_m_locator_id Implied Constraint R
rv_transaction.m_locator_id Implied Constraint R
rv_transaction.m_movementline_m_locator_id Implied Constraint R
rv_transaction.m_product_m_locator_id Implied Constraint R
rv_transaction.m_productionline_m_locator_id Implied Constraint R
rv_transaction.m_productionplan_m_locator_id Implied Constraint R
t_inventorytrxsummary.m_locator_id mlocator_tinventorytrxsummary R
t_invoicegl_v.m_locator_id Implied Constraint R
t_rv_reconciliation.m_locator_id Implied Constraint R
t_rv_reconciliation.m_product_m_locator_id Implied Constraint R
t_transaction.m_locator_id mlocator_ttransaction C
t_trialbalance.m_locator_id Implied Constraint R
test.m_locator_id Implied Constraint R
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
c_bpartner.c_bpartner_id Implied Constraint R
m_locatortype_id numeric 10 √ NULL::numeric
m_locatortype.m_locatortype_id mlocatortype_mlocator R

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