Dynamics GP Table Reference - COMPANY..PAM30505 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 PAM tables PAM30505

You are currently viewing the COMPANY database.
Change

COMPANY..PAM30505 Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value		Source
JOBNUMBR	char ''	Job Number...(more) Join Now	SF010601.JOBNUMBR

CUSTNMBR	char ''	Customer c...(more) Join Now

DSCRIPTN	char ''

TEMPSTAT	char ''

CNTCPRSN	char ''	Contact pe...(more) Join Now

Contact_Position	char ''

ADRSCODE	char ''	This field...(more) Join Now

DIVISID	char ''

PERIODID	smallint 0

STARTDT	datetime '1/1/1900'

EXPTDEND	datetime '1/1/1900'

ACTEND	datetime '1/1/1900'

YEAR1	smallint 0	Year...(more) Join Now	SY40101.YEAR1

CREATDDT	datetime '1/1/1900'	Date this ...(more) Join Now	RM00102.CREATDDT

CREATUSR	char ''

MODIFDT	datetime '1/1/1900'	Date the r...(more) Join Now	WDC41400.MODIFDT

MDFUSRID	char ''	User that ...(more) Join Now	SY40500.MDFUSRID

USRDEFS1	char ''

USRDEFS2	char ''

USERAMT1	numeric 0.00

USERAMT2	numeric 0.00

USRDAT01	datetime '1/1/1900'

USRDAT02	datetime '1/1/1900'

ACCSETID	char ''

INVFORMT	char ''

CALC881	tinyint 0

EXTOFJOB	char ''

JOBDURTN	int 0

CONTCONT	tinyint 0

CLNTCONT	tinyint 0

MARGINRT	numeric 0.00

PRTAPPLY	tinyint 0

CONTVALU	numeric 0.00

Consultant_ID	char ''

DAYPERWK	int 0

HRSPERWK	int 0

PORDNMBR	char ''	Purchase O...(more) Join Now	JC00701.PORDNMBR

PODATE	datetime '1/1/1900'

POAMOUNT	numeric 0.00

POBALNCE	numeric 0.00

PO_Hours	int 0

AWARDID	char ''

TAXSCHID	char ''

INVCFREQ	smallint 0

Office_ID	char ''

SBU	char ''

STATECD	char ''	State Code...(more) Join Now	W200006.STATECD

LOCALTAX	char ''

WRKRCOMP	char ''	Workers Co...(more) Join Now	JC00701.WRKRCOMP

HOLD	tinyint 0

HOLDCDID	char ''

WEBTS_JOB_ENABLED	tinyint 0

PAM_Calculate_Discounts	tinyint 0

PAM_Discount_ID	char ''

PAM_Discount_Percent	smallint 0

PR_Apply_Fed_Rules	tinyint 0

PR_OTBillType	smallint 0

PR_OTPayTypeID	char ''

PR_OTRegPayTypeID	char ''

PR_DTBillType	smallint 0

PR_DTPayTypeID	char ''

PR_DTRegPayTypeID	char ''

Contact_ID	char ''

Flat_Rate_Billing	tinyint 0

Flat_Rate_Bill_Amount	numeric 0.00

ADDRESS1	char ''

ADDRESS2	char ''

ADDRESS3	char ''

CITY	char ''

ZIP	char ''

CURNCYID	char ''	Currency I...(more) Join Now	MC40200.CURNCYID

PAMProjectID	char ''

PAM_Service_Code	char ''

ADRCNTCT	char ''

PAM_TimesheetFormat	smallint 0

LOCLCODE	char ''

Local_Code_Long_Name	char ''

Email_Address	char ''

PAM_Latitude	numeric 0.00

PAM_Longitude	numeric 0.00

FO_Job_Number	char ''

PAYROLLED	tinyint 0

PAM_VMS_Fee_ID	char ''

PAM_VMS_Fee_Percent	smallint 0

PayCycleID	char ''

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

DynDeveloper.com

COMPANY..PAM30505 Table Definition

Field Definitions: