Table idempiere9.adempiere.i_movement
I_Movement_ID

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
i_movement_id numeric 10 I_Movement_ID
ad_org_id numeric 10 Organizational entity within client
ad_client_id numeric 10 Client/Tenant for this installation.
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
isactive bpchar 1 The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
processed bpchar 1 'N'::bpchar The document has been processed
i_isimported bpchar 1 'N'::bpchar Has this import been processed
processing bpchar 1 'N'::bpchar Process Now
i_errormsg varchar 2000  √  NULL::character varying Messages generated from import process
productvalue varchar 40  √  NULL::character varying Key of the Product
m_product_id numeric 10  √  NULL::numeric
m_product.m_product_id mproduct_imovement R
Product, Service, Item
movementdate timestamp 29,6  √  null Date a product was moved in or out of inventory
m_locator_id numeric 10  √  NULL::numeric
m_locator.m_locator_id mlocator_imovement R
Warehouse Locator
locatorvalue varchar 40  √  NULL::character varying Key of the Warehouse Locator
m_locatorto_id numeric 10  √  NULL::numeric
m_locator.m_locator_id mlocatorto_imovement R
Location inventory is moved to
locatortovalue varchar 40  √  NULL::character varying Locator To Key
orgvalue varchar 40  √  NULL::character varying Key of the Organization
movementqty numeric 0  √  null Quantity of a product moved.
documentno varchar 40  √  null Document sequence number of the document
c_doctype_id numeric 10  √  NULL::numeric
c_doctype.c_doctype_id cdoctype_imovement R
Document type or rules
doctypename varchar 40  √  NULL::character varying Name of the Document Type
c_bpartner_id numeric 10  √  NULL::numeric
c_bpartner.c_bpartner_id cbpartner_imovement R
Identifies a Business Partner
bpartnervalue varchar 40  √  NULL::character varying Key of the Business Partner
m_shipper_id numeric 10  √  NULL::numeric
m_shipper.m_shipper_id mshipper_imovement R
Method or manner of product delivery
shippername varchar 40  √  NULL::character varying ShipperName
ad_user_id numeric 10  √  NULL::numeric
ad_user.ad_user_id aduser_imovement R
User within the system - Internal or Business Partner Contact
deliveryviarule varchar 40  √  NULL::character varying How the order will be delivered
deliveryrule varchar 40  √  NULL::character varying Defines the timing of Delivery
priorityrule varchar 40  √  NULL::character varying Priority of a document
freightcostrule varchar 40  √  NULL::character varying Method for charging Freight
c_project_id numeric 10  √  NULL::numeric
c_project.c_project_id cproject_imovement R
Financial Project
projectvalue varchar 40  √  NULL::character varying Key of the Project
c_campaign_id numeric 10  √  NULL::numeric
c_campaign.c_campaign_id ccampaign_imovement R
Marketing Campaign
campaignvalue varchar 40  √  NULL::character varying Text key of the Campaign
ad_orgtrx_id numeric 10  √  NULL::numeric
ad_org.ad_org_id adorgtrx_imovement R
Performing or initiating organization
orgtrxvalue varchar 40  √  NULL::character varying Key of the Transaction Organization
user1_id varchar 10  √  NULL::character varying User defined list element #1
user2_id varchar 10  √  NULL::character varying User defined list element #2
m_movement_id numeric 10  √  NULL::numeric
m_movement.m_movement_id mmovement_imovement R
Movement of Inventory
m_movementline_id numeric 10  √  null
m_movementline.m_movementline_id mmovementline_imovement R
Inventory Move document Line
i_movement_uu varchar 36  √  NULL::character varying I_Movement_UU

Table contained 0 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.