MSP_RESOURCES |
Default Table Name | MSP_RESOURCES |
Definition |
MSP_RESOURCES Columns |
ColumnName | Domain | Datatype | NULL | Definition |
UPLOAD_ID | VARCHAR2(36) | YES | ||
ROW_UID | VARCHAR2(255) | YES | ||
ID | VARCHAR2(255) | YES | ||
NAME | VARCHAR2(255) | YES | ||
TYPE | VARCHAR2(255) | YES | ||
IS_NULL | VARCHAR2(255) | YES | ||
INITIALS | VARCHAR2(255) | YES | ||
MATERIALLABEL | VARCHAR2(255) | YES | ||
CODE | VARCHAR2(255) | YES | ||
GRP | VARCHAR2(255) | YES | ||
WORKGROUP | VARCHAR2(255) | YES | ||
MAXUNITS | VARCHAR2(255) | YES | ||
PEAKUNITS | VARCHAR2(255) | YES | ||
OVERALLOCATED | VARCHAR2(255) | YES | ||
CANLEVEL | VARCHAR2(255) | YES | ||
ACCRUEAT | VARCHAR2(255) | YES | ||
WORK | VARCHAR2(255) | YES | ||
REGULARWORK | VARCHAR2(255) | YES | ||
OVERTIMEWORK | VARCHAR2(255) | YES | ||
ACTUALWORK | VARCHAR2(255) | YES | ||
REMAININGWORK | VARCHAR2(255) | YES | ||
ACTUALOVERTIMEWORK | VARCHAR2(255) | YES | ||
REMAININGOVERTIMEWORK | VARCHAR2(255) | YES | ||
PERCENTWORKCOMPLETE | VARCHAR2(255) | YES | ||
STANDARDRATE | VARCHAR2(255) | YES | ||
STANDARDRATEFORMAT | VARCHAR2(255) | YES | ||
COST | VARCHAR2(255) | YES | ||
OVERTIMERATE | VARCHAR2(255) | YES | ||
OVERTIMERATEFORMAT | VARCHAR2(255) | YES | ||
OVERTIMECOST | VARCHAR2(255) | YES | ||
COSTPERUSE | VARCHAR2(255) | YES | ||
ACTUALCOST | VARCHAR2(255) | YES | ||
ACTUALOVERTIMECOST | VARCHAR2(255) | YES | ||
REMAININGCOST | VARCHAR2(255) | YES | ||
REMAININGOVERTIMECOST | VARCHAR2(255) | YES | ||
WORKVARIANCE | VARCHAR2(255) | YES | ||
COSTVARIANCE | VARCHAR2(255) | YES | ||
SV | VARCHAR2(255) | YES | ||
CV | VARCHAR2(255) | YES | ||
ACWP | VARCHAR2(255) | YES | ||
CALENDARUID | VARCHAR2(255) | YES | ||
BCWS | VARCHAR2(255) | YES | ||
BCWP | VARCHAR2(255) | YES | ||
ISGENERIC | VARCHAR2(255) | YES | ||
ISINACTIVE | VARCHAR2(255) | YES |
MSP_RESOURCES Primary and Unique Keys |
Key Name | Key Type | Keys |
MSP_RESOURCES Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |