Module List >
Module Manufacturing tables
CP010030
You are currently viewing the COMPANY
database.
Change
|
COMPANY..CP010030 Table Definition
(COMPANY..Capacity Master File)
Field Definitions:
What is the 'source' column?
| WCID_I |
char(11)
''
|
|
|
|
|
| EFFECTIVEDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| AVAILABLEEMPHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANAVAILEMPHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| SCHEDULEDEMPHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANSCHEDEMPHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| AVAILABLEMACHHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANAVAILMACHHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| SCHEDULEDMACHHOURS_I |
numeric(19,5)
0.00
|
|
|
|
|
| PLANSCHEDMACHRS_I |
numeric(19,5)
0.00
|
|
|
|
|
| PERCENTOFMAXEMP_I |
int
0
|
|
|
|
|
| PLANPEROFMAXEMP_I |
int
0
|
|
|
|
|
| PERCENTOFMAXMACH_I |
int
0
|
|
|
|
|
| PLANPEROFMAXMACH_I |
int
0
|
|
|
|
|
| EMPLOYEEOVERLOAD_I |
tinyint
0
|
|
|
|
|
| PLANEMPOVERLOAD_I |
tinyint
0
|
|
|
|
|
| MACHINEOVERLOAD_I |
tinyint
0
|
|
|
|
|
| PLANMACOVERLOAD_I |
tinyint
0
|
|
|
|
|
| PLNNDAVLBLEEMPHRSMRP |
numeric(19,5)
0.00
|
|
|
|
|
| PLNNDSCHDLDEMPHRSMRP |
numeric(19,5)
0.00
|
|
|
|
|
| PLNNDAVLBLMACHHRSMRP |
numeric(19,5)
0.00
|
|
|
|
|
| PLNNDSCHDLDMACHHRSMRP |
numeric(19,5)
0.00
|
|
|
|
|
| PLNNEDPRCNTMAXEMPMRP |
int
0
|
|
|
|
|
| PLNNDPRCNTMACMACHMRP |
int
0
|
|
|
|
|
| PLNNDEMPOVRLDMRP |
tinyint
0
|
|
|
|
|
| PLNNDMACHOVRLDMRP |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|