ERP 2.50:Developers Guide/Database Model/org.openbravo.model.procurement/M RequisitionLine
M_RequisitionLine
This table contains each product demand of a requisition. The demand is defined by a product, the date when is needed to have and the quantity. It is also possible to define a preferred vendor, price list and the correspondent prices. The demands are locked when are being used to generate the purchase orders so there are not created duplicate purchase orders for the same demand.
- Name:ProcurementRequisitionLine
- Classname:RequisitionLine
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| M_Requisitionline_ID | N | VARCHAR2(32) | null |
| 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 |
| M_Requisition_ID | N | VARCHAR2(32) | null |
| M_Product_ID | N | VARCHAR2(32) | An item produced by a process. |
| Qty | N | NUMBER | The number of a certain item. |
| PriceList | Y | NUMBER | The official price of a product in a specified currency. |
| LineNetAmt | Y | NUMBER | The final amount of a specified line, based only on quantities and prices. |
| C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| C_UOM_ID | Y | VARCHAR2(32) | A non monetary unit of measure. |
| M_Product_Uom_Id | Y | VARCHAR2(32) | The unit of measure being used for the request. |
| QuantityOrder | Y | NUMBER | The number of a certain item involved in the transaction, shown in units which differ from the standard UOM. |
| M_AttributeSetInstance_ID | Y | VARCHAR2(32) | An attribute associated with a product as part of an attribute set. |
| Reqstatus | N | VARCHAR2(60) | null |
| Orderedqty | N | NUMBER | null |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| Changestatus | Y | CHAR(1) | null |
| Internalnotes | Y | NVARCHAR2(255) | null |
| Suppliernotes | Y | NVARCHAR2(255) | null |
| Needbydate | N | DATE | null |
| PriceActual | Y | NUMBER | The price that will be paid for a specified item. |
| Discount | Y | NUMBER | The proportional discount given to an item, without respect to any previously defined discounts. |
| C_Currency_ID | Y | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
| Lockedby | Y | VARCHAR2(32) | null |
| Lockqty | Y | NUMBER | null |
| Lockprice | Y | NUMBER | null |
| M_PriceList_ID | Y | VARCHAR2(32) | A catalog of selected items with prices defined generally or for a specific partner. |
| Lockdate | Y | DATE | null |
| Lockcause | Y | VARCHAR2(60) | null |
| Line | N | NUMBER(10, 0) | A line stating the position of this request in the document. |
Other Info
Check constraints
These are the check constraints for this table:
- M_REQUISITIONLI_ISACTIVE_CHECK: ISACTIVE 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):
Unique
- M_REQUISITIONLINE_KEY
Columns
Requisition Line
Identifies each product demand of a requisition.
- Physical column name: M_Requisitionline_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)
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
- Default value: Y
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
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
- Default value: SYSDATE
Updated By
- Physical column name: Updatedby
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Requisition
- Physical column name: M_Requisition_ID
- Property Name: requisition
- 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_Requisition table, (column: M_Requisition_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_RequisitionLine_Product
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Product Java class.
Quantity
The Quantity indicates the number of a specific product or item for this document.
- Physical column name: Qty
- Property Name: quantity
- Reference: Quantity
- Default value: 1
- This column is part of the table's identifier
Callout: SL_RequisitionLine_Amt
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Amt Java class.
List Price
The List Price is the official price stated by the selected pricelist and the currency of the document.
- Physical column name: PriceList
- Property Name: listPrice
- Reference: Price
Callout: SL_RequisitionLine_Amt
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Amt Java class.
Line Net Amount
Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.
- Physical column name: LineNetAmt
- Property Name: lineNetAmount
- Reference: Amount
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Callout: SL_Requisition_BPartner
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Requisition_BPartner 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)
Order UOM
- Physical column name: M_Product_Uom_Id
- Property Name: orderUOM
- Reference: TableDir
Foreign key column to M_Product_Uom table, (column: M_Product_Uom_Id)
Validation Rule M_Product_UOM_ID: null. With the following code:
M_Product_UOM.M_Product_ID = @M_Product_ID@
Callout: SL_RequisitionLine_Conversion
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Conversion Java class.
Order Quantity
Product quantity in the order uom.
- Physical column name: QuantityOrder
- Property Name: orderQuantity
- Reference: Quantity
Callout: SL_RequisitionLine_Conversion
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Conversion Java class.
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)
Requisition line status
Each product demand has its own status different than the status of the requisition. The statuses of the demands are:
Open: The demand hasn't been yet fulfilled.
Closed: Has been ordered enough products.
Cancelled: The demand has been closed without ordering any product.
Planned: The demand has been included in a Purchase Plan of the MRP module.
- Physical column name: Reqstatus
- Property Name: requisitionLineStatus
- Reference: List
- Default value: O
List values: Requisition status
The allowed values for this list are:
- C (Closed): The requisition has at least an associated purchase order.
- D (Cancelled): The requisition has been cancelled without creating a purchase order.
- O (Open): The requisition line has not been inclluded in a Purchasing plan, neither has an associated purchase order.
- P (Planned): The requisition has been included in a Purchase Plan and purchase orders have been created.
Matched PO Qty
Indicates the already ordered quantity to fulfill the demand.
- Physical column name: Orderedqty
- Property Name: matchedPOQty
- Reference: Quantity
- Default value: 0
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Text
Change Status
Button to change the status of the record.
- Physical column name: Changestatus
- Property Name: changeStatus
- Reference: Button
Internal notes
Notes that can be set with the aim to be seen only by users with access to the record.
- Physical column name: Internalnotes
- Property Name: internalNotes
- Reference: Text
Notes for supplier
Notes set to include in the Purchase Orders with indications to the vendor.
- Physical column name: Suppliernotes
- Property Name: notesForSupplier
- Reference: Text
Need by date
The date by when the demand needs to be fulfilled.
- Physical column name: Needbydate
- Property Name: needByDate
- Reference: Date
- This column is part of the table's identifier
Unit Price
The actual price indicates the price for a product in source currency.
- Physical column name: PriceActual
- Property Name: unitPrice
- Reference: Price
Callout: SL_RequisitionLine_Amt
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Amt Java class.
Discount %
The Discount indicates the discount applied or taken as a percentage.
- Physical column name: Discount
- Property Name: discount
- Reference: Number
Callout: SL_RequisitionLine_Amt
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Amt Java class.
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
- Default value: @C_Currency_ID@
Foreign key column to C_Currency table, (column: C_Currency_ID)
Validation Rule C_Currency of PriceList: Sets the currency of the pricelist. With the following code:
C_Currency.C_Currency_ID IN (SELECT C_Currency_ID FROM M_Pricelist WHERE ISACTIVE='Y')
Locked by
- Physical column name: Lockedby
- Property Name: lockedBy
- Reference: Table
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User
Lock qty
Quantity set to be used when the record is processed.
- Physical column name: Lockqty
- Property Name: lockQty
- Reference: Quantity
Lock price
Price set to be used when the record is processed.
- Physical column name: Lockprice
- Property Name: lockPrice
- Reference: Price
Price List
- Physical column name: M_PriceList_ID
- Property Name: priceList
- Reference: TableDir
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Validation Rule Purchase Pricelist: Purchase Pricelist. With the following code:
M_Pricelist.IsSOPricelist='N'
Callout: SL_RequisitionLine_Product
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_RequisitionLine_Product Java class.
Lock date
Indicates the date when the record was locked. Id the lock it is more than 3 days old it is considered as unlocked.
- Physical column name: Lockdate
- Property Name: lockDate
- Reference: Date
Lock cause
Indicate the reason to be locked the requisition line. The demands are locked when are being used in processes that will generate Purchase Orders to fulfill the demand. The lock is removed when those processes finish or if the lock is 3 days old.
The causes are The Requisition to Order window or the inclusion of the demand in a MRP process.
- Physical column name: Lockcause
- Property Name: lockCause
- Reference: List
List values: Requisition lock cause
The allowed values for this list are:
- M (Locked by Requisition to Order window)
- P (Included in a MRP process)
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_REQUISITIONLINE WHERE M_Requisition_ID=@M_Requisition_ID@
Related tables
Tables that link this table: