i_movement

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_movement_id numeric 10 null
ad_org_id numeric 10 null
ad_client_id numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
isactive bpchar 1 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
processed bpchar 1 'N'::bpchar
i_isimported bpchar 1 'N'::bpchar
processing bpchar 1 'N'::bpchar
i_errormsg varchar 2000 √ NULL::character varying
productvalue varchar 40 √ NULL::character varying
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_imovement R
movementdate timestamp 29,6 √ null
m_locator_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocator_imovement R
locatorvalue varchar 40 √ NULL::character varying
m_locatorto_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocatorto_imovement R
locatortovalue varchar 40 √ NULL::character varying
orgvalue varchar 40 √ NULL::character varying
movementqty numeric 0 √ null
documentno varchar 40 √ null
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctype_imovement R
doctypename varchar 40 √ NULL::character varying
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_imovement R
bpartnervalue varchar 40 √ NULL::character varying
m_shipper_id numeric 10 √ NULL::numeric
m_shipper.m_shipper_id mshipper_imovement R
shippername varchar 40 √ NULL::character varying
ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id aduser_imovement R
deliveryviarule varchar 40 √ NULL::character varying
deliveryrule varchar 40 √ NULL::character varying
priorityrule varchar 40 √ NULL::character varying
freightcostrule varchar 40 √ 'I'::character varying
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_imovement R
projectvalue varchar 40 √ NULL::character varying
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_imovement R
campaignvalue varchar 40 √ NULL::character varying
ad_orgtrx_id numeric 10 √ NULL::numeric
ad_org.ad_org_id adorgtrx_imovement R
orgtrxvalue varchar 40 √ NULL::character varying
user1_id varchar 10 √ NULL::character varying
user2_id varchar 10 √ NULL::character varying
m_movement_id numeric 10 √ NULL::numeric
m_movement.m_movement_id mmovement_imovement R
m_movementline_id numeric 10 √ null
m_movementline.m_movementline_id mmovementline_imovement R
i_movement_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
i_movement_key Primary key Asc i_movement_id
i_movement_uu_idx Must be unique Asc i_movement_uu

Check Constraints

Constraint Name Constraint
i_movement_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_movement_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_movement_i_isimported_check ((i_isimported = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation