Dynamics GP Table Reference - COMPANY..PC40800 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 PC40800

You are currently viewing the COMPANY database.
Change

COMPANY..PC40800 Table Definition

(COMPANY..PC Position Seat Inheritance)

4Penny.net

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	PLANCODE	char(15) ''

	JOBTITLE	char(7) ''	Job Title:...(more) Join Now	TATX1030.JOBTITLE

	TEMPSEAT	tinyint 0

	SEAT	int 0

	SEQNUMBR	int 0	Sequence N...(more) Join Now	IV10400.SEQNUMBR

	ACTINDX	int 0	Account In...(more) Join Now	UPR40500.ACTINDX
join ... more text available
	ACRUSTIM	tinyint 0	Accrue sic...(more) Join Now

	ACRUVACN	tinyint 0	Accrue Vac...(more) Join Now

	Calc_Min_Wage_Bal	tinyint 0

	CALCMINWAGEBALCB	tinyint 0

	CONTENDDTE	datetime '1/1/1900'	Contract E...(more) Join Now

	CONTSTARTDTE	datetime '1/1/1900'

	DIVISIONCODE_I	char(7) ''

	DIVISIONCODECB	tinyint 0

	EMPLCLAS	char(15) ''	Employee C...(more) Join Now	UPR00100.EMPLCLAS
join ... more text available
	EMPLCLASCB	tinyint 0

	WCACFPAY	smallint 0

	WHICHCACHACCTCB	tinyint 0

	LOCATNID	char(15) ''	Location I...(more) Join Now	PA01101.LOCATNID
join ... more text available
	LOCATNIDCB	tinyint 0

	STMACMTH	smallint 0

	SKTMACAM	int 0

	SKTMHPYR	int 0

	SUPERVISOR	char(31) ''

	SUPERVISORCB	tinyint 0

	EMPLOYMENTTYPE	smallint 0	Type of Em...(more) Join Now	HR2EMP02.EMPLOYMENTTYPE

	EMPLOYMENTTYPECB	tinyint 0

	CONTACTNUMBER_I	smallint 0

	UNIONDUESAMOUNT_I	numeric(19,5) 0.00

	UNIONINFOCB	tinyint 0

	UNIONNAME_I	char(31) ''

	VACCRMTH	smallint 0

	VACCRAMT	int 0

	VACAPRYR	int 0

	VACSICKCB	tinyint 0

	WRNSTFLSBLWZR	tinyint 0

	WRNVCNFLSBLWZR	tinyint 0

	WKHRPRYR	smallint 0

	WKHRPRYRCB	tinyint 0

	WRKRCOMP	char(7) ''	Workers Co...(more) Join Now	UPR00400.WRKRCOMP

	CONTACTNUM_I	char ''

	WRKRCOMPCB	tinyint 0

	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