ERP/2.50/Developers Guide/Database Model/org.openbravo.model.materialmgmt.transaction/M InOutLine
M_InOutLine
The table defines the individual line that comprise shipment line
- Name:MaterialMgmtShipmentInOutLine
- Classname:ShipmentInOutLine
This table contains the following columns:
Name | Nullable | Data Type | Description |
M_InOutLine_ID | N | VARCHAR2(32) | A statement displaying one item, charge, or movement in a shipment. |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | N | DATE | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
Line | N | NUMBER(10, 0) | A line stating the position of this request in the document. |
Description | Y | NVARCHAR2(2000) | A space to write additional related information. |
M_InOut_ID | N | VARCHAR2(32) | The document number for identifying an act of sending goods. |
C_OrderLine_ID | Y | VARCHAR2(32) | Purchase Order Line |
M_Locator_ID | Y | VARCHAR2(32) | A set of coordinates (x, y, z) which help locate an item in a warehouse. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
C_UOM_ID | N | VARCHAR2(32) | A non monetary unit of measure. |
MovementQty | N | NUMBER | The number of items being moved from one location to another. |
IsInvoiced | N | CHAR(1) | An indication that a transaction may be invoiced to a business partner. |
M_AttributeSetInstance_ID | Y | VARCHAR2(32) | An attribute associated with a product as part of an attribute set. |
IsDescription | N | CHAR(1) | if true, the line is just description and no transaction |
QuantityOrder | Y | NUMBER | The number of a certain item involved in the transaction, shown in units which differ from the standard UOM. |
M_Product_Uom_Id | Y | VARCHAR2(32) | The unit of measure being used for the request. |
Other Info
Check constraints
These are the check constraints for this table:
- M_INOUTLINE: ((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))
- M_INOUTLINE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
- M_INOUTLINE_ISINVOICED_CHECK: ISINVOICED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- M_INOUTLINE_INOUT
- M_INOUTLINE_ORDERLINE
- M_INOUTLINE_PRODUCT
Unique
- M_INOUTLINE_KEY
Columns
Goods Shipment Line
The Goods Shipment Line indicates a unique line in a Shipment document
- Physical column name: M_InOutLine_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- 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
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Validation Rule AD_Org show child organizations: It only shows the child organizations of the organization's header. With the following code:
AD_ISORGINCLUDED(ad_org.ad_org_id, @AD_ORG_ID@, ad_org.ad_client_id)<>-1 AND IsReady='Y'
Active
There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Line No.
Indicates the unique line for a document. It will also control the display order of the lines within a document.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
- Default value: @SQL=SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM M_InOutLine WHERE M_InOut_ID=@M_InOut_ID@
- This column is part of the table's identifier
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Text
Shipment/Receipt
- Physical column name: M_InOut_ID
- Property Name: shipmentReceipt
- Reference: Search
- This column is part of the table's identifier
- This column is a child for a buisiness object (is Parent)
Foreign key column to M_InOut table, (column: M_InOut_ID)
Purchase Order Line
The Purchase Order Line is a unique identifier for a line in an order.
- Physical column name: C_OrderLine_ID
- Property Name: salesOrderLine
- Reference: Search
Foreign key column to C_OrderLine table, (column: C_OrderLine_ID)
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: Search
- Default value: @SQL=SELECT M_LOCATOR_ID AS DEFAULTVALUE FROM M_LOCATOR WHERE AD_ISORGINCLUDED(@AD_Org_ID@, M_LOCATOR.AD_Org_ID, @#AD_Client_ID@) <> -1 AND ISACTIVE='Y' AND M_WAREHOUSE_ID=@M_WAREHOUSE_ID@ ORDER BY M_LOCATOR.ISDEFAULT DESC
Foreign key column to M_Locator table, (column: M_Locator_ID)
Validation Rule M_Locator of Warehouse: null. With the following code:
M_Locator.M_Warehouse_ID=@M_Warehouse_ID@
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
- This column is part of the table's identifier
Foreign key column to M_Product table, (column: M_Product_ID)
Callout: SL_InOutLine_Product
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_InOutLine_Product Java class.
UOM
- Physical column name: C_UOM_ID
- Property Name: uOM
- Reference: TableDir
Foreign key column to C_UOM table, (column: C_UOM_ID)
Movement Quantity
The Movement Quantity indicates the quantity of a product that has been moved.
- Physical column name: MovementQty
- Property Name: movementQuantity
- Reference: Quantity
- Default value: 1
- This column is part of the table's identifier
Re-invoice
Indicator if invoiced
- Physical column name: IsInvoiced
- Property Name: reinvoice
- Reference: YesNo
Attribute Set Value
- Physical column name: M_AttributeSetInstance_ID
- Property Name: attributeSetValue
- Reference: PAttribute
Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)
Description Only
If a line is Description Only, e.g. Product Inventory is not corrected. No accounting transactions are created and the amount or totals are not included in the document. This for including descriptional detail lines, e.g. for an Work Order.
- Physical column name: IsDescription
- Property Name: descriptionOnly
- Reference: YesNo
- Default value: N
Order Quantity
Product quantity in the order uom.
- Physical column name: QuantityOrder
- Property Name: orderQuantity
- Reference: Quantity
Callout: SL_InOut_Conversion
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_InOut_Conversion Java class.
Order UOM
- Physical column name: M_Product_Uom_Id
- Property Name: orderUOM
- Reference: Table
Foreign key column to M_Product_UOM table, (column: M_Product_Uom_Id)
Reference Table M_Product_UOM With the following where clause:
M_Product_UOM.M_Product_ID = @M_Product_ID@
Callout: SL_InOut_Conversion
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_InOut_Conversion Java class.
Related tables
Tables that link this table:
- InvoiceLine.Goods Shipment Line
- MaterialMgmtCosting.Goods Shipment Line
- MaterialMgmtMaterialTransaction.Goods Shipment Line
- ProcurementPOInvoiceMatch.Goods Shipment Line
- ProcurementReceiptInvoiceMatch.Goods Shipment Line
- ProjectIssue.Goods Shipment Line