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

You are currently viewing the COMPANY database.
Change

COMPANY..PC30301 Table Definition

(COMPANY..PC Position Setup History)

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

	CHANGEDATE_I	datetime '1/1/1900'	*Change Da...(more) Join Now	HR2EMP02.CHANGEDATE_I

	SEQ_I	int 0

	CHANGETIME_I	datetime '1/1/1900'

	DSCRIPTN	char(31) ''

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

	ATACRVAC	tinyint 0

	BUDGETPERMSEATAMT	smallint 0

	BUDGETTEMPSEATAMT	smallint 0

	BUGETBENPERCENT	numeric(19,5) 0.00

	BUDGETTAXPERCENT	numeric(19,5) 0.00

	BUDGETBENAMOUNT	numeric(19,5) 0.00

	BUDGETTAXAMOUNT	numeric(19,5) 0.00

	Calc_Min_Wage_Bal	tinyint 0

	WCACFPAY	smallint 0

	CHANGEBY_I	char(15) ''	*Change By...(more) Join Now	TATX1030.CHANGEBY_I

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

	CONTSTARTDTE	datetime '1/1/1900'

	CREATDDT	datetime '1/1/1900'	Created Da...(more) Join Now	POP10100.CREATDDT

	CRUSRID	char(15) ''

	DEPRTMNT	char(7) ''	Department...(more) Join Now	TATX1030.DEPRTMNT
join ... more text available
	DIVISIONCODE_I	char(7) ''

	EEOCLASS_I	smallint 0

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

	BUDGETEDFTE	numeric(19,5) 0.00

	INHERITANCELOCK	tinyint 0

	LOCATNID	char(15) ''	Location I...(more) Join Now	PA01101.LOCATNID
join ... more text available
	NOTEINDX	numeric(19,5) 0.00	Note Index...(more) Join Now
join ... more text available
	NOTEINDX2	numeric(19,5) 0.00	Note Index...(more) Join Now

	GROSSPAYINDEX	int 0

	BENEFITEXPINDEX	int 0

	WCOMPTAXEXPINDEX	int 0

	TAXBENEXPENSEINDEX	int 0

	EMPLYRFICAMEINDEX	int 0

	EMPLYRFICASEINDEX	int 0

	EMPLYRFUTAINDEX	int 0

	EMPLYRSUTAINDEX	int 0

	POSSTATUS	smallint 0

	REPORTSTOPOS	char(7) ''

	REVIEWSETUPCODE_I	char(31) ''

	STMACMTH	smallint 0

	SKTMACAM	int 0

	SKTMHPYR	int 0

	SKILLSETNUMBER_I	int 0

	SUPERVISORCODE_I	char(7) ''

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

	CONTACTNUMBER_I	smallint 0

	UNIONDUESAMOUNT_I	numeric(19,5) 0.00

	UNIONNAME_I	char(31) ''

	VACCRMTH	smallint 0

	VACCRAMT	int 0

	VACAPRYR	int 0

	WRNSTFLSBLWZR	tinyint 0

	WRNVCNFLSBLWZR	tinyint 0

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

	CONTACTNUM_I	char ''

	CHANGEREASON_I	char(31) ''

	DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

	TXTFIELD	text	Text Field...(more) Join Now	UPR40301.TXTFIELD

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables

DynDeveloper.com

COMPANY..PC30301 Table Definition

Field Definitions: