Tables
Relationships
Constraints
Anomalies
Columns
View
idempiere11
.
adempiere
.
rv_m_transaction_sum
Transaction Sum
Generated by
Quality Systems & Solutions
Related columns
Constraints
Comments
Legend
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
ad_client_id
numeric
10
√
null
Tenant for this installation.
ad_org_id
numeric
10
√
null
Organizational entity within tenant
movementtype
bpchar
2
√
null
Method of moving the inventory
m_warehouse_id
numeric
10
√
null
Storage Warehouse and Service Point
m_locator_id
numeric
10
√
null
Warehouse Locator
m_product_id
numeric
10
√
null
Product, Service, Item
movementdate
timestamp
29,6
√
null
Date a product was moved in or out of inventory
movementqty
numeric
0
√
null
Quantity of a product moved.
Analyzed at 2024-01-03 13:44 +0100