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

Contents 1 M_Transaction_Sum 1.1 Columns 1.1.1 Client 1.1.2 Organization 1.1.3 Movement Type 1.1.3.1 List values: M_Transaction Movement Type 1.1.4 Warehouse 1.1.5 Storage Bin 1.1.6 Product 1.1.7 Movement Date 1.1.8 Movement Quantity

M_Transaction_Sum

• Name:TransactionSum
• Classname:MaterialTransactionSum

This table contains the following columns:

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

Columns

Client

• Physical column name: AD_Client_ID
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

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

top

Organization

• Physical column name: AD_Org_ID
• Reference: TableDir
• Default value: @AD_Org_ID@

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)

• Physical column name: MovementType
• Reference: List

List values: M_Transaction Movement Type

The allowed values for this list are:

• C- (Customer Shipment)
• C+ (Customer Returns)
• V+ (Vendor Receipts)
• V- (Vendor Returns)
• I- (Inventory Out)
• I+ (Inventory In)
• M- (Movement From)
• M+ (Movement To)
• P+ (Production +)
• P- (Production -)
• W+ (Work Order +)
• W- (Work Order -)
• D+ (Internal Consumption +)
• D- (Internal Consumption -)

top

Warehouse

• Physical column name: M_Warehouse_ID
• Reference: TableDir
• This column is part of the table's identifier

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

top

Storage Bin

• Physical column name: M_Locator_ID
• Reference: Search
• This column is part of the table's identifier

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

top

Product

• Physical column name: M_Product_ID
• Reference: TableDir

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.

• Physical column name: MovementDate
• Reference: Date

top

Movement Quantity

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

• Physical column name: MovementQty
• Reference: Quantity

top