Module List > Module PA tables PDK00300
You are currently viewing the COMPANY database.
Change

COMPANY..PDK00300 Table Definition

(COMPANY..PDK Timesheet Template Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
PAREPDT datetime
'1/1/1900'

PAREPD smallint
0

PACOMM char(51)
''

PAUD1 char(21)
''
PA User De...(more) Join Now PA01001.PAUD1
PAUD2 char(21)
''
PA User De...(more) Join Now PA01001.PAUD2
CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now CM20200.RTCLCMTD
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