DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module HR tables TATX1030
You are currently viewing the COMPANY database.
Change

COMPANY..TATX1030 Table Definition

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

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
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3