Module List > Module HR tables AHRTA330
You are currently viewing the COMPANY database.
Change

COMPANY..AHRTA330 Table Definition

(COMPANY..Archive_TA_TRX_Detail)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRX_I int
0
Transactio...(more) Join Now TATX1030.TRX_I
GBTATYPE smallint
0

EMPID_I char(15)
''
Employee I...(more) Join Now TATX1030.EMPID_I
JOBTITLE char(7)
''
Job Title:...(more) Join Now UPR00100.JOBTITLE
DEPRTMNT char(7)
''
Department...(more) Join Now UPR00100.DEPRTMNT
join ... more text available
DIVISIONCODE_I char(7)
''
*Division:...(more) Join Now UPR00100.DIVISIONCODE_I
TIMECODE_I char(7)
''
Time Code...(more) Join Now TATM1030.TIMECODE_I
TRXDATE datetime
'1/1/1900'
TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
TRXENDDT datetime
'1/1/1900'

TRXERROR_I smallint
0

HOURS_I int
0

HOURSAVAILABLE_I int
0

DAYSWRDK int
0

WKSWRKD int
0

ACCFLG tinyint
0

ACCRUETIMEBENEFITS_I tinyint
0

POSTED tinyint
0
Posted: S...(more) Join Now RM10301.POSTED
ATTTYP char(31)
''

ATTRSN char(31)
''

ATTTRXSTATUS smallint
0

BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
COMPTRNM int
0

CMRECNUM numeric(19,5)
0.00
Record Num...(more) Join Now CM20300.CMRECNUM
PAYRCORD char(7)
''
Pay Record...(more) Join Now UPR40600.PAYRCORD
CHANGEBY_I char(15)
''
*Change By...(more) Join Now UPR00100.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now UPR00100.CHANGEDATE_I
CHANGETIME_I datetime
'1/1/1900'

NOTESINDEX_I numeric(19,5)
0.00

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