View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.dataimport/I Inventory

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

Index

Contents

I_Inventory

Validate and Import Inventory Transactions. The Locator is primarily determined by the Locator Key, then the Warehouse and X,Y,Z fields.

A Physical Inventory is created per Warehouse and Movement Date.

This table contains the following columns:
Name Nullable Data Type Description
I_Inventory_ID NVARCHAR2(32)Import Inventory Transactions
AD_Client_ID YVARCHAR2(32)Client for this installation.
AD_Org_ID YVARCHAR2(32)Organizational entity within client
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created YDATEThe date that this record is completed.
CreatedBy YVARCHAR2(32)User who created this records
Updated YDATEx not implemented
UpdatedBy YVARCHAR2(32)User who updated this records
Processing YCHAR(1)A request to process the respective document or task.
Processed YCHAR(1)A confirmation that the associated documents or requests are processed.
Description YNVARCHAR2(255)A space to write additional related information.
Lot YNVARCHAR2(20)A group of identical or similar items organized and placed into inventory under one number.
M_InventoryLine_ID YVARCHAR2(32)A statement displaying one item in the physical inventory list.
M_Locator_ID YVARCHAR2(32)A set of coordinates (x, y, z) which help locate an item in a warehouse.
M_Product_ID YVARCHAR2(32)An item produced by a process.
QtyBook YNUMBERBook Quantity
QtyCount YNUMBERCounted Quantity
SerNo YNVARCHAR2(20)An attribute used as a unique identifier for a product.
UPC YVARCHAR2(30)A bar code with a number to identify a product.
Value YNVARCHAR2(40)A fast method for finding a particular record.
WarehouseValue YNVARCHAR2(40)Key of the Warehouse
X YNVARCHAR2(60)X dimension, e.g., Aisle
Y YNVARCHAR2(60)Y dimension, e.g., Bin
Z YNVARCHAR2(60)Z dimension, e.g., Level
LocatorValue YNVARCHAR2(40)Key of the Warehouse Locator
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.
M_Inventory_ID YVARCHAR2(32)Parameters for a Physical Inventory
M_Warehouse_ID YVARCHAR2(32)The location where products arrive to or are sent from.
MovementDate YDATEThe date that a certain item is moved from one location to another.

Other Info

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

Import Inventory

Import Inventory Transactions

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

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Description

A description is limited to 255 characters.

top

Lot Name

The Lot Number indicates the specific lot that a product was part of.

top

Physical Inventory Line

Foreign key column to M_InventoryLine table, (column: M_InventoryLine_ID)

top

Storage Bin

Foreign key column to M_Locator table, (column: M_Locator_ID)

top

Product

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

top

Book Quantity

The Quantity Book indicates the line count stored in the system for a product in inventory

top

Quantity count

The Quantity Count indicates the actual inventory count taken for a product in inventory

top

Serial No.

The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.

top

UPC/EAN

Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode)

top

Search Key

A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

top

Warehouse Key

Key to identify the Warehouse

top

Row (X)

The X dimension indicates the Aisle a product is located in.

top

Stack (Y)

The Y dimension indicates the Bin a product is located in

top

Level (Z)

The Z dimension indicates the Level a product is located in.

top

Locator Key

Key of the Warehouse Locator

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

top

Import Process Complete

The Imported check box indicates if this import has been processed.

top

Phys.Inventory

Foreign key column to M_Inventory table, (column: M_Inventory_ID)

top

Warehouse

Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)

top

Movement Date

The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.

top

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

This page has been accessed 2,706 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.