View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.procurement/M RequisitionLine

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.procurement

Index

Contents

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.

This table contains the following columns:

Name Nullable Data Type Description
M_Requisitionline_ID NVARCHAR2(32)null
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
M_Requisition_ID NVARCHAR2(32)null
M_Product_ID NVARCHAR2(32)An item produced by a process.
Qty NNUMBERThe number of a certain item.
PriceList YNUMBERThe official price of a product in a specified currency.
LineNetAmt YNUMBERThe final amount of a specified line, based only on quantities and prices.
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_UOM_ID YVARCHAR2(32)A non monetary unit of measure.
M_Product_Uom_Id YVARCHAR2(32)The unit of measure being used for the request.
QuantityOrder YNUMBERThe number of a certain item involved in the transaction, shown in units which differ from the standard UOM.
M_AttributeSetInstance_ID YVARCHAR2(32)An attribute associated with a product as part of an attribute set.
Reqstatus NVARCHAR2(60)null
Orderedqty NNUMBERnull
Description YNVARCHAR2(255)A space to write additional related information.
Changestatus YCHAR(1)null
Internalnotes YNVARCHAR2(255)null
Suppliernotes YNVARCHAR2(255)null
Needbydate NDATEnull
PriceActual YNUMBERThe price that will be paid for a specified item.
Discount YNUMBERThe proportional discount given to an item, without respect to any previously defined discounts.
C_Currency_ID YVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
Lockedby YVARCHAR2(32)null
Lockqty YNUMBERnull
Lockprice YNUMBERnull
M_PriceList_ID YVARCHAR2(32)A catalog of selected items with prices defined generally or for a specific partner.
Lockdate YDATEnull
Lockcause YVARCHAR2(60)null
Line NNUMBER(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:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Requisition Line

Identifies each product demand of a requisition.

top

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

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Requisition

Foreign key column to M_Requisition table, (column: M_Requisition_ID)

top

Product

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.

top

Quantity

The Quantity indicates the number of a specific product or item for this document.

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.

top

List Price

The List Price is the official price stated by the selected pricelist and the currency of the document.

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.

top

Line Net Amount

Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.

top

Business Partner

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.

top

UOM

Foreign key column to C_UOM table, (column: C_UOM_ID)

top

Order UOM

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.

top

Order Quantity


Product quantity in the order uom.

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.

top

Attribute Set Value

Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)

top

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.

List values: Requisition status

The allowed values for this list are:

top

Matched PO Qty

Indicates the already ordered quantity to fulfill the demand.

top

Description

A description is limited to 255 characters.

top

Change Status

Button to change the status of the record.

top

Internal notes

Notes that can be set with the aim to be seen only by users with access to the record.

top

Notes for supplier

Notes set to include in the Purchase Orders with indications to the vendor.

top

Need by date

The date by when the demand needs to be fulfilled.

top

Unit Price

The actual price indicates the price for a product in source currency.

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.

top

Discount %

The Discount indicates the discount applied or taken as a percentage.

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.

top

Currency

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')

top

Locked by

Foreign key column to AD_User table, (column: AD_User_ID)


Reference Table AD_User

top

Lock qty


Quantity set to be used when the record is processed.

top

Lock price


Price set to be used when the record is processed.

top

Price List

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.

top

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.

top

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.

List values: Requisition lock cause

The allowed values for this list are:

top

Line No.

Indicates the unique line for a document. It will also control the display order of the lines within a document.

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.procurement/M_RequisitionLine"

This page has been accessed 4,051 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.