ERP/2.50/Developers Guide/Database Model/org.openbravo.model.dataimport/I Inventory
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.
- Name:DataImportInventory
- Classname:Inventory
Name | Nullable | Data Type | Description |
I_Inventory_ID | N | VARCHAR2(32) | Import Inventory Transactions |
AD_Client_ID | Y | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | Y | VARCHAR2(32) | Organizational entity within client |
IsActive | Y | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
Created | Y | DATE | The date that this record is completed. |
CreatedBy | Y | VARCHAR2(32) | User who created this records |
Updated | Y | DATE | x not implemented |
UpdatedBy | Y | VARCHAR2(32) | User who updated this records |
Processing | Y | CHAR(1) | A request to process the respective document or task. |
Processed | Y | CHAR(1) | A confirmation that the associated documents or requests are processed. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
Lot | Y | NVARCHAR2(20) | A group of identical or similar items organized and placed into inventory under one number. |
M_InventoryLine_ID | Y | VARCHAR2(32) | A statement displaying one item in the physical inventory list. |
M_Locator_ID | Y | VARCHAR2(32) | A set of coordinates (x, y, z) which help locate an item in a warehouse. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
QtyBook | Y | NUMBER | Book Quantity |
QtyCount | Y | NUMBER | Counted Quantity |
SerNo | Y | NVARCHAR2(20) | An attribute used as a unique identifier for a product. |
UPC | Y | VARCHAR2(30) | A bar code with a number to identify a product. |
Value | Y | NVARCHAR2(40) | A fast method for finding a particular record. |
WarehouseValue | Y | NVARCHAR2(40) | Key of the Warehouse |
X | Y | NVARCHAR2(60) | X dimension, e.g., Aisle |
Y | Y | NVARCHAR2(60) | Y dimension, e.g., Bin |
Z | Y | NVARCHAR2(60) | Z dimension, e.g., Level |
LocatorValue | Y | NVARCHAR2(40) | Key of the Warehouse Locator |
I_ErrorMsg | Y | NVARCHAR2(2000) | A message that appears when errors occur during the importing process. |
I_IsImported | Y | CHAR(1) | A indication that the desired process has been completed successfully. |
M_Inventory_ID | Y | VARCHAR2(32) | Parameters for a Physical Inventory |
M_Warehouse_ID | Y | VARCHAR2(32) | The location where products arrive to or are sent from. |
MovementDate | Y | DATE | The 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
- I_INVENTORY_KEY
Columns
Import Inventory
Import Inventory Transactions
- Physical column name: I_Inventory_ID
- Property Name: id
- Reference: ID
- This column is part of the table's identifier
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)
Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
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
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
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
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Process Now
When this field is set as 'Y' a process is being performed on this record.
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Property Name: processed
- Reference: YesNo
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Lot Name
The Lot Number indicates the specific lot that a product was part of.
- Physical column name: Lot
- Property Name: lotName
- Reference: String
Physical Inventory Line
- Physical column name: M_InventoryLine_ID
- Property Name: physicalInventoryLine
- Reference: Search
Foreign key column to M_InventoryLine table, (column: M_InventoryLine_ID)
Storage Bin
- Physical column name: M_Locator_ID
- Property Name: storageBin
- Reference: TableDir
Foreign key column to M_Locator table, (column: M_Locator_ID)
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Book Quantity
The Quantity Book indicates the line count stored in the system for a product in inventory
- Physical column name: QtyBook
- Property Name: bookQuantity
- Reference: Quantity
Quantity count
The Quantity Count indicates the actual inventory count taken for a product in inventory
- Physical column name: QtyCount
- Property Name: quantityCount
- Reference: Quantity
Serial No.
The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1.
- Physical column name: SerNo
- Property Name: serialNo
- Reference: String
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)
- Physical column name: UPC
- Property Name: uPCEAN
- Reference: String
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.
- Physical column name: Value
- Property Name: searchKey
- Reference: String
Warehouse Key
Key to identify the Warehouse
- Physical column name: WarehouseValue
- Property Name: warehouseKey
- Reference: String
Row (X)
The X dimension indicates the Aisle a product is located in.
- Physical column name: X
- Property Name: rowX
- Reference: String
Stack (Y)
The Y dimension indicates the Bin a product is located in
- Physical column name: Y
- Property Name: stackY
- Reference: String
Level (Z)
The Z dimension indicates the Level a product is located in.
- Physical column name: Z
- Property Name: levelZ
- Reference: String
Locator Key
Key of the Warehouse Locator
- Physical column name: LocatorValue
- Property Name: locatorKey
- Reference: String
Import Error Message
The Import Error Message displays any error messages generated during the import process.
- Physical column name: I_ErrorMsg
- Property Name: importErrorMessage
- Reference: String
Import Process Complete
The Imported check box indicates if this import has been processed.
- Physical column name: I_IsImported
- Property Name: importProcessComplete
- Reference: YesNo
Phys.Inventory
- Physical column name: M_Inventory_ID
- Property Name: physInventory
- Reference: Search
Foreign key column to M_Inventory table, (column: M_Inventory_ID)
Warehouse
- Physical column name: M_Warehouse_ID
- Property Name: warehouse
- Reference: TableDir
Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)
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.
- Physical column name: MovementDate
- Property Name: movementDate
- Reference: Date