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/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm/M Lot

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.plm


Contents

M_Lot

This table contains the following columns:

Name Nullable Data Type Description


AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
IsActive No CHAR (1) 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.

DateTo Yes TIMESTAMP (7) The Date To indicates the end date of a range (inclusive)
Help Yes NVARCHAR (2000) The Help field contains a hint, comment or help about the use of this item.
UpdatedBy No VARCHAR (32) The Updated By field indicates the user who updated this record.
M_Lot_ID No VARCHAR (32) The individual Lot of a Product
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Description Yes NVARCHAR (255) A description is limited to 255 characters.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
DateFrom Yes TIMESTAMP (7) The Date From indicates the starting date of a range.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
CreatedBy No VARCHAR (32) The Created By field indicates the user who created this record.
M_Product_ID No VARCHAR (32) Identifies an item which is either purchased or sold in this organization.
Name No NVARCHAR (60) A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

Columns

Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Active



top


Ending Date



top


Help/Comment



top


Updated By


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

top


Lot



top


Creation Date



top


Description



top


Client


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

top


Starting Date



top


Updated



top


Created By


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

top


Product

Foreign key column to M_Product table, (column: M_Product_ID)

top


Name


top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.common.plm

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.common.plm/M_Lot"

This page has been accessed 1,044 times. This page was last modified on 4 January 2017, at 07:12. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.