ERP/3.0/Developers Guide/Database Model/org.openbravo.model.materialmgmt.transaction/M Transaction Sum
Contents |
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)
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)
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 -)
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)
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)
Product
- Physical column name: M_Product_ID
- Reference: TableDir
Foreign key column to M_Product table, (column: M_Product_ID)
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
Movement Quantity
The Movement Quantity indicates the quantity of a product that has been moved.
- Physical column name: MovementQty
- Reference: Quantity