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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Skip Navigation LinkseConnect Module : Type : Node : Fields Easy Navigation


eConnect Errors Each eConnect node has specific errors that are associated with it
Param NameData TypeReqParamDescParam Mode
CUSTNMBRchar(15)YesCustomer Number IN
ADRSCODEchar(15)YesAddress ID IN
SLPRSNIDchar(15)NoSales Person ID IN
SHIPMTHDchar(15)NoShipping Method IN
TAXSCHIDchar(15)NoTax Schedule IN
CNTCPRSNchar(60)NoContact Person IN
ADDRESS1char(60)NoCustomer Address One IN
ADDRESS2char(60)NoCustomer Address Two IN
ADDRESS3char(60)NoCustomer Address Three IN
COUNTRYchar(60)NoCustomer Country IN
CITYchar(35)NoCustomer City IN
STATEchar(29)NoCustomer State IN
ZIPCODEchar(10)NoCustomer Zip IN
PHNUMBR1char(21)NoPhone one IN
PHNUMBR2char(21)NoPhone two IN
PHNUMBR3char(21)NoPhone three IN
FAXchar(21)NoFax IN
GPSFOINTEGRATIONIDchar(30)NoFront Office Integration ID IN
INTEGRATIONSOURCEsmallintNoIntegration Source IN
INTEGRATIONIDchar(30)NoIntegration ID IN
CCodechar(6)NoCountry Code IN
LOCNCODEchar(10)NoLocation Code IN
SALSTERRchar(15)NoSales Territory IN
ShipToNamechar(64)No Ship To Name IN
Print_Phone_NumberGBsmallintNo User Defined field - IN
USERDEF1char(20)NoUser Defined 1 IN
USERDEF2char(20)NoUser Defined 2 IN
UpdateIfExiststinyintNoUpdateIfExists IN
RequesterTrxsmallintNoRequester transaction 0 = false, 1 = true IN
USRDEFND1char(50)NoUser Defined field - developer use only IN
USRDEFND2char(50)NoUser Defined field - developer use only IN
USRDEFND3char(50)NoUser Defined field - developer use only IN
USRDEFND4varchar(8000)NoUser Defined field - developer use only IN
USRDEFND5varchar(8000)NoUser Defined field - developer use only IN
ErrorStateintNoReturn value: 0=No Errors, 1=Error Occurred INOUT
oErrStringvarchar(255)NoReturn Error Code List 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