Dynamics GP Table Reference - COMPANY..AHRTA330 fields

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

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module HR tables AHRTA330

You are currently viewing the COMPANY database.
Change

COMPANY..AHRTA330 Table Definition

(COMPANY..Archive_TA_TRX_Detail)

What is the 'source' column?

	Column Name	Data 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