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

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.uom/C UOM Conversion

Contents

C_UOM_Conversion

The Conversion defines the rates for converting a Unit of Measure. The system provides some automatic conversions between units of measures (e.g. minute, hour, day, working day, etc.) if they are not explicitly defined here. Conversions need to be dir

This table contains the following columns:

Name Nullable Data Type Description
C_UOM_Conversion_ID NVARCHAR2(32)Unit of Measure Conversion
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
C_UOM_ID NVARCHAR2(32)A non monetary unit of measure.
C_UOM_To_ID NVARCHAR2(32)Target or destination Unit of Measure
MultiplyRate NNUMBERThe rate by which the base unit will be mutiplied by to create the converted unit.
DivideRate NNUMBERThe rate by which the base unit will be divided by to create the converted unit.

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

UOM Conversion

The UOM Conversion identifies a unique to and from Unit of Measure, conversion rate and conversion date range.

top

Client

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


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

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

UOM

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

top

To UOM

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


Reference Table C_UOM

top

Multiple Rate by

To convert Source number to Target number, the Source is multiplied by the multiply rate. If the Multiply Rate is entered, then the Divide Rate will be automatically calculated.

Callout: SL_Conversion_Rate

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Conversion_Rate Java class.

top

Divide Rate by

To convert Source number to Target number, the Source is divided by the divide rate. If you enter a Divide Rate, the Multiply Rate will be automatically calculated.

Callout: SL_Conversion_Rate

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Conversion_Rate Java class.

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Database_Model/org.openbravo.model.common.uom/C_UOM_Conversion"

This page has been accessed 4,383 times. This page was last modified on 2 July 2011, at 20:50. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.