m_movement

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_movement_id numeric 10 null
cof_rv_docfiscal.m_movement_id Implied Constraint R
i_movement.m_movement_id mmovement_imovement R
lbr_docfiscal.m_movement_id mmovement_lbrdocfiscal R
m_movement.reversal_id reversal_mmovement R
m_movementconfirm.m_movement_id mmovement_mmovementconfirm C
m_movementline.m_movement_id mmovement_mmovementline C
m_movementlinema_v.m_movement_id Implied Constraint R
m_movementlinema_vt.m_movement_id Implied Constraint R
m_transaction_v.m_movement_id Implied Constraint R
rv_transaction.m_movement_id Implied Constraint R
t_transaction.m_movement_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_mmovement R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updatedby numeric 10 null
updated timestamp 29,6 now()
documentno varchar 30 null
description varchar 255 √ null
movementdate timestamp 29,6 null
posted bpchar 1 'N'::bpchar
processed bpchar 1 'N'::bpchar
processing bpchar 1 √ null
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_mmovement R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_mmovement R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_mmovement R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_mmovement R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_mmove R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser2_mmove R
datereceived timestamp 29,6 √ null
docaction bpchar 2 null
docstatus bpchar 2 null
isintransit bpchar 1 'N'::bpchar
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_mmovement R
isapproved bpchar 1 'N'::bpchar
approvalamt numeric 0 √ null
freightcostrule bpchar 1 √ 'I'::bpchar
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_mmovement R
priorityrule bpchar 1 √ null
salesrep_id numeric 10 √ null
ad_user.ad_user_id salesrep_mmovement R
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_mmovement R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_mmovement R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_mmovement R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_mmovement R
chargeamt numeric 0 √ null
createfrom bpchar 1 √ null
dd_order_id numeric 10 √ null
dd_order.dd_order_id ddorder_mmovement R
deliveryrule bpchar 1 √ null
deliveryviarule bpchar 1 √ null
freightamt numeric 0 √ null
reversal_id numeric 10 √ null
m_movement.m_movement_id reversal_mmovement R
poreference varchar 20 √ null
processedon numeric 0 √ null
m_movement_uu varchar 36 √ NULL::character varying
m_inout_id numeric 10 √ null
m_inout.m_inout_id Implied Constraint R
cof_totallines numeric 0 √ (0)::numeric
cof_grandtotal numeric 0 √ (0)::numeric
lbr_nfdescription varchar 255 √ NULL::character varying
cof_isgeneratenfmovement bpchar 1 √ 'N'::bpchar
lbr_transactiontype varchar 3 'TFR'::character varying
cof_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id cofdocfiscal_mmovement N
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_mmovement N
cof_orgto_id numeric 10 √ NULL::numeric
ad_org.ad_org_id coforgto_mmovement C
cof_pp_planomestreprod_id numeric 10 √ NULL::numeric
cof_pp_planomestreprod.cof_pp_planomestreprod_id cofppplanomestreprod_mmovement R
cof_pp_devolucao bpchar 1 √ null
cof_docautomatico bpchar 1 √ 'N'::bpchar
m_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_mmovement R
m_warehouseto_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouseto_mmovement R

Indexes

Constraint Name Type Sort Column(s)
m_movement_pkey Primary key Asc m_movement_id
idxm_movement_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id
m_movement_uu_idx Must be unique Asc m_movement_uu

Check Constraints

Constraint Name Constraint
m_movement_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_movement_cof_docautomatico_check ((cof_docautomatico = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_movement_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_movement_cof_pp_devolucao_check ((cof_pp_devolucao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_movement_cof_isgeneratenfmovement_check ((cof_isgeneratenfmovement = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation