| PRIMARY KEY |
|
I_Inventory_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) |
| |
|
AD_Org_ID
NUMBER (10, 0) |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) |
| |
|
Created
DATE default: SYSDATE |
| |
|
CreatedBy
NUMBER (10, 0) |
| |
|
Updated
DATE default: SYSDATE |
| |
|
UpdatedBy
NUMBER (10, 0) |
| |
|
I_IsImported
CHAR (1) default: 'N' NOT NULL |
| |
|
I_ErrorMsg
NVARCHAR2 (2000) |
| |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
UPC
VARCHAR2 (30) |
| |
|
Value
NVARCHAR2 (40) |
| |
|
Lot
NVARCHAR2 (20) |
| |
|
SerNo
NVARCHAR2 (20) |
| |
|
M_Locator_ID
NUMBER (10, 0) |
| M_Locator |
|
M_Warehouse_ID
NUMBER (10, 0) |
| M_Warehouse |
|
WarehouseValue
NVARCHAR2 (40) |
| |
|
LocatorValue
NVARCHAR2 (40) |
| |
|
X
NVARCHAR2 (60) |
| |
|
Y
NVARCHAR2 (60) |
| |
|
Z
NVARCHAR2 (60) |
| |
|
M_Inventory_ID
NUMBER (10, 0) |
| M_Inventory |
|
M_InventoryLine_ID
NUMBER (10, 0) |
| M_InventoryLine |
|
QtyBook
NUMBER default: 0 |
| |
|
QtyCount
NUMBER default: 0 |
| |
|
MovementDate
DATE |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) |
| |
FOREIGN KEY
MInventory_IInventory: M_Inventory_ID => M_Inventory
MInventoryLine_IInventory: M_InventoryLine_ID => M_InventoryLine
MLocator_IInventory: M_Locator_ID => M_Locator
MProduct_IInventory: M_Product_ID => M_Product
MWarehouse_IInventory: M_Warehouse_ID => M_Warehouse
|