| PRIMARY KEY |
|
M_PerpetualInv_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
NoInventoryCount
NUMBER (10, 0) NOT NULL |
Number of Inventory Counts per Year
| |
|
NoProductCount
NUMBER (10, 0) NOT NULL |
Number of times to count each product per year
| |
|
CountHighMovement
CHAR (1) default: 'N' CHECK ( CountHighMovement in ( 'Y' , 'N' )) NOT NULL |
Count Proecucts with high movement every time
| |
|
Processing
CHAR (1) |
| |
|
DateLastRun
DATE |
| |
|
DateNextRun
DATE NOT NULL |
| |
|
NumberOfRuns
NUMBER (10, 0) NOT NULL |
| |
|
M_Product_Category_ID
NUMBER (10, 0) |
| M_Product_Category |
|
M_Warehouse_ID
NUMBER (10, 0) |
| M_Warehouse |
FOREIGN KEY
MProdCategory_MPerpetualInv: M_Product_Category_ID => M_Product_Category
MWarehouse_MPerpetualInv: M_Warehouse_ID => M_Warehouse
|
REFERENCED BY
M_Inventory |
|