DynDeveloper.com - Your Dynamics GP Questions, Answered

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

eConnect Module : Type : Node : Fields

taFSServiceCallMaster

eConnect Errors Each eConnect node has specific errors that are associated with it

Param Name	Data Type	Req	ParamDesc	Param Mode
SRVRECTYPE	smallint	No	Service Record Type	IN
CALLNBR	char(11)	No	Service Call Number 1=Quote, 2=Open, 3=Invoiced	IN
SRVSTAT	char(3)	No	Service Call Status Code	IN
SRVTYPE	char(11)	No	Service Type	IN
SVCDESCR	char(61)	No	Service Description	IN
priorityLevel	smallint	No	Priority Level	IN
CUSTNMBR	char(15)	No	Customer Number	IN
Customer_Reference	char(21)	No	Customer Reference	IN
ADRSCODE	char(15)	No	Customer Address Code	IN
CUSTNAME	char(31)	No		IN
ADDRESS1	char(31)	No	Customer Address Line 1	IN
ADDRESS2	char(31)	No	Customer Address Line 2	IN
ADDRESS3	char(31)	No	Customer Address Line 3	IN
CITY	char(31)	No	Customer City	IN
STATE	char(3)	No	Customer State Code	IN
ZIP	char(11)	No	Customer Zip	IN
COUNTRY	char(21)	No	Customer Country	IN
CNTCPRSN	char(31)	No	Customer Contact Person	IN
PHONE1	char(21)	No	Customer Phone 1	IN
CKHOLD	smallint	No	Flag to indicate whether to check for Customer Hold.	IN
OFFID	char(11)	No	Office ID	IN
SVCAREA	char(11)	No	Service Area	IN
TECHID	char(11)	No	Tech ID	IN
TIMEZONE	char(3)	No	Time Zone	IN
CONTNBR	char(11)	No	Contract Number	IN
PRICELVL	char(15)	No		IN
ENTDTE	datetime	No	Entry Date	IN
ENTTME	datetime	No	Entry Time	IN
ETADTE	datetime	No	ETA Date	IN
ETATME	datetime	No	ETA Time	IN
DISPDTE	datetime	No	Dispatch Date	IN
DISPTME	datetime	No	Dispatch Time	IN
ARRIVDTE	datetime	No	Arrival Date	IN
ARRIVTME	datetime	No	Arrival Time	IN
COMPDTE	datetime	No	Complete Date	IN
COMPTME	datetime	No	Complete Time	IN
Response_Date	datetime	No	Response Date	IN
Response_Time	datetime	No	Response Time	IN
SLPRSNID	char(15)	No	Payment Terms ID	IN
PORDNMBR	char(21)	No	Purchase Order Number	IN
NOTETXT	varchar(8000)	No	Notes	IN
USERDEF1	char(21)	No	Additional Information, line 1	IN
USERDEF2	char(21)	No	Additional Information, line 2	IN
USRDEF03	char(21)	No	Additional Information, line 3	IN
USRDEF04	char(21)	No	Additional Information, line 4	IN
USRDEF05	char(21)	No	Additional Information, line 5	IN
SVC_On_Hold	tinyint	No	Service On Hold	IN
PYMTRMID	char(21)	No	Payment Term ID	IN
SVC_FO_ID	char(51)	No	Service Front Office ID	IN
CURNCYID	char(15)	No	Currency ID	IN
AutoCreateLabor	tinyint	No	Flag to indicate whether to labor lines automatically for Arrival and Completion	IN
UpdateIfExists	tinyint	No	Flag to allow customer data to be updated if it exists. 0=no, 1=yes	IN
RequesterTrx	smallint	No	Requester Trx - 0=false,1=true - if true than populates Requester shadow table	IN
USRDEFND1	char(50)	No	User Defined field - developer use only	IN
USRDEFND2	char(50)	No	User Defined field - developer use only	IN
USRDEFND3	char(50)	No	User Defined field - developer use only	IN
USRDEFND4	varchar(8000)	No	User Defined field - developer use only	IN
USRDEFND5	varchar(8000)	No	User Defined field - developer use only	IN
ErrorState	int	No	List of errors encountered	INOUT
oErrString	varchar(255)	No	List of errors encountered	INOUT

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables