Module List > Module Manufacturing tables CP010030
You are currently viewing the COMPANY database.
Change

COMPANY..CP010030 Table Definition

(COMPANY..Capacity Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3