View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.materialmgmt.transaction/M Transaction Sum

Contents

M_Transaction_Sum

This table contains the following columns:

Name Nullable Data Type Description
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
MovementType NVARCHAR2(60)The type of a certain item being moved from one location to another.
M_Warehouse_ID NVARCHAR2(32)The location where products arrive to or are sent from.
M_Locator_ID NVARCHAR2(32)A set of coordinates (x, y, z) which help locate an item in a warehouse.
M_Product_ID NVARCHAR2(32)An item produced by a process.
MovementDate NDATEThe date that a certain item is moved from one location to another.
MovementQty YNUMBERThe number of items being moved from one location to another.

Columns

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Movement Type

The Movement Type indicates the type of movement (in, out, to production, etc)

List values: M_Transaction Movement Type

The allowed values for this list are:

top

Warehouse

Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)

top

Storage Bin

Foreign key column to M_Locator table, (column: M_Locator_ID)

top

Product

Foreign key column to M_Product table, (column: M_Product_ID)

top

Movement Date

The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.

top

Movement Quantity

The Movement Quantity indicates the quantity of a product that has been moved.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.materialmgmt.transaction/M_Transaction_Sum"

This page has been accessed 1,497 times. This page was last modified on 27 April 2011, at 16:41. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.