Module List > Module TM tables UPR10111
You are currently viewing the COMPANY database.
Change

COMPANY..UPR10111 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
MonthofCoverage_1 smallint
0

MonthofCoverage_2 smallint
0

MonthofCoverage_3 smallint
0

MonthofCoverage_4 smallint
0

MonthofCoverage_5 smallint
0

MonthofCoverage_6 smallint
0

MonthofCoverage_7 smallint
0

MonthofCoverage_8 smallint
0

MonthofCoverage_9 smallint
0

MonthofCoverage_10 smallint
0

MonthofCoverage_11 smallint
0

MonthofCoverage_12 smallint
0

MonthofCost_1 numeric
0.00

MonthofCost_2 numeric
0.00

MonthofCost_3 numeric
0.00

MonthofCost_4 numeric
0.00

MonthofCost_5 numeric
0.00

MonthofCost_6 numeric
0.00

MonthofCost_7 numeric
0.00

MonthofCost_8 numeric
0.00

MonthofCost_9 numeric
0.00

MonthofCost_10 numeric
0.00

MonthofCost_11 numeric
0.00

MonthofCost_12 numeric
0.00

MonthofSafeHarbor_1 smallint
0

MonthofSafeHarbor_2 smallint
0

MonthofSafeHarbor_3 smallint
0

MonthofSafeHarbor_4 smallint
0

MonthofSafeHarbor_5 smallint
0

MonthofSafeHarbor_6 smallint
0

MonthofSafeHarbor_7 smallint
0

MonthofSafeHarbor_8 smallint
0

MonthofSafeHarbor_9 smallint
0

MonthofSafeHarbor_10 smallint
0

MonthofSafeHarbor_11 smallint
0

MonthofSafeHarbor_12 smallint
0

CHANGEBY_I char
''
*Change By...(more) Join Now
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
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