| PRIMARY KEY |
|
S_Resource_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 |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
S_ResourceType_ID
NUMBER (10, 0) NOT NULL |
| S_ResourceType |
|
M_Warehouse_ID
NUMBER (10, 0) NOT NULL |
| M_Warehouse |
|
IsAvailable
CHAR (1) default: 'Y' CHECK ( IsAvailable in ( 'Y' , 'N' )) NOT NULL |
| |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
ChargeableQty
NUMBER default: 0 |
| |
FOREIGN KEY
ADUser_SResource: AD_User_ID => AD_User
MWarehouse_SResource: M_Warehouse_ID => M_Warehouse
SResourceType_SResource: S_ResourceType_ID => S_ResourceType
|
REFERENCED BY
M_Product,
R_ResourcePlanCost,
S_ResourceAssignment,
S_ResourceUnAvailable |
|