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

You are currently viewing the COMPANY database.
Change

COMPANY..PAM_VMS_MAPPINGS Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	MappingID	varchar ''

	EmployeeID	varchar ''

	EmployeeName	varchar ''

	JobNumber	varchar ''

	CustomerID	varchar ''

	TSLDate	varchar ''

	PayType	varchar ''	Pay Type: ...(more) Join Now

	PositionID	varchar ''

	TimeUnit	varchar ''

	TimeWorked	varchar ''

	PayRate	varchar ''

	PayAmount	varchar ''

	TimeBilled	varchar ''

	BillRate	varchar ''

	BillAmount	varchar ''

	PONumber	varchar ''	PO Number ...(more) Join Now	SEE30303.PONUMBER

	ExceptionPath	varchar ''

	OutputPath	varchar ''

	CustomerValue	varchar ''

	DateValue	varchar ''

	PayType1	varchar ''

	PayType2	varchar ''

	PayTypeHours	varchar ''

	PositionValue	varchar ''

	TimeUnitValue	varchar ''

	TimeBilledValue	varchar ''

	BillAsPay	varchar ''

	PayTypeCol2	varchar ''

	PayTypeCol2V	varchar ''

	TimeWorked2	varchar ''

	TimeBilled2	varchar ''

	BillAsPay2	varchar ''

	PayRate2	varchar ''

	BillRate2	varchar ''

	PayAmount2	varchar ''

	BillAmount2	varchar ''

	PayTypeCol3	varchar ''

	PayTypeCol3V	varchar ''

	TimeWorked3	varchar ''

	TimeBilled3	varchar ''

	BillAsPay3	varchar ''

	PayRate3	varchar ''

	BillRate3	varchar ''

	PayAmount3	varchar ''

	BillAmount3	varchar ''

	UD1	varchar ''

	UD2	varchar ''

	UD3	varchar ''

	UD4	varchar ''

	UD5	varchar ''

	UD6	varchar ''

	UD7	varchar ''

	UD8	varchar ''

	UD9	varchar ''

	UD10	varchar ''

	UD11	varchar ''

	UD12	varchar ''

	USERID	varchar ''	The user t...(more) Join Now	WRS10001.USERID

	ContainsHdr	varchar ''

	ImportToWBT	varchar ''

	CalcAmtIfEmpty	varchar ''

	WBTDB	varchar ''

	ImportAsApproved	varchar ''

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